pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Aug 5 04:10:03 2026
Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20260804
Parsed 1,342 log entries in 2s
Log start from 2026-08-04 11:51:41 to 2026-08-04 20:32:06

Global Stats

13 Number of unique normalized queries
21 Number of queries
8m25s Total query duration
2026-08-04 13:57:18 First query
2026-08-04 16:54:34 Last query
1 queries/s at 2026-08-04 14:24:35 Query peak

8m25s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
8m25s Execute total duration

85 Number of events
15 Number of unique normalized events
14 Max number of times the same event was reported
0 Number of cancellation

0 Total number of automatic vacuums
0 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

124 Total number of sessions
18 sessions at 2026-08-04 16:19:42 Session peak
9d20h19m35s Total duration of sessions
1h54m21s Average duration of sessions
0 Average queries per session
4s77ms Average queries duration per session
1h54m17s Average idle time per session

125 Total number of connections
9 connections/s at 2026-08-04 14:54:52 Connection peak
2 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-08-04 14:24:35 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-08-04 14:24:35 Date

INSERT/UPDATE/DELETE Traffic

Key values

1 queries/s Query Peak
2026-08-04 16:14:10 Date

Queries duration

Key values

8m25s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 04	11	0	0ms	0ms	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms	0ms	0ms
	13	3	0ms	5s890ms	5s618ms	5s522ms	11s331ms	11s331ms
	14	7	0ms	17s374ms	12s684ms	14s516ms	17s374ms	30s797ms
	15	4	0ms	51s819ms	47s16ms	47s819ms	51s819ms	51s819ms
	16	7	0ms	51s728ms	30s275ms	52s585ms	1m35s	1m35s
	17	0	0ms	0ms	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 04	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	3	5s618ms	0ms	5s522ms	11s331ms
	14	7	12s684ms	10s344ms	14s516ms	30s797ms
	15	4	47s16ms	47s130ms	47s819ms	51s819ms
	16	4	38s377ms	5s888ms	51s728ms	1m35s
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Aug 04	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms

Day	Hour	Bind	Bind/Prepare	Percentage of prepare
Aug 04	11	0	0.00	0.00%
	12	0	0.00	0.00%
	13	0	0.00	0.00%
	14	4	4.00	0.00%
	15	4	4.00	0.00%
	16	5	5.00	0.00%
	17	0	0.00	0.00%
	18	0	0.00	0.00%
	19	0	0.00	0.00%
	20	0	0.00	0.00%

Day	Hour	Count	Average / Second
Aug 04	11	6	0.00/s
	12	14	0.00/s
	13	2	0.00/s
	14	44	0.01/s
	15	47	0.01/s
	16	12	0.00/s
	17	0	0.00/s
	18	0	0.00/s
	19	0	0.00/s
	20	0	0.00/s

Day	Hour	Count	Average Duration	Average idle time
Aug 04	11	0	0ms	0ms
	12	15	11m41s	11m41s
	13	0	0ms	0ms
	14	36	4h33m20s	4h33m18s
	15	47	8m30s	8m26s
	16	17	1h47m51s	1h47m39s
	17	5	3h42s	3h42s
	18	0	0ms	0ms
	19	3	4h16m22s	4h16m22s
	20	1	4h17m27s	4h17m27s

↑ Back to the top of the General Activity table

Established Connections

Key values

9 connections Connection Peak
2026-08-04 14:54:52 Date

Connections per database

Key values

ctddev51 Main Database
125 connections Total

Chart
Table

Database	User	Count
ctddev51		122
	pub1	3
	pubeu	118
	qaeu	1
postgres		3
	pub1	1
	pubeu	2

Connections per user

Key values

pubeu Main User
125 connections Total

Chart
Table

User	Count
pub1	4
pubeu	120
qaeu	1

Connections per host

Key values

10.12.5.37 Main host with 93 connections
125 Total connections

Chart
Table

Host	Count
10.12.5.37	93
192.168.201.10	27
192.168.201.22	1
192.168.201.6	4

Simultaneous sessions

Key values

18 sessions Session Peak
2026-08-04 16:19:42 Date

Histogram of session times

Key values

49 60000-600000ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	13	10.48%
500ms-1s	0	0.00%
1s-30s	7	5.65%
30s-1m	1	0.81%
1m-10m	49	39.52%
10m-30m	23	18.55%
30m-1h	7	5.65%
1h-8h	16	12.90%
> 8h	8	6.45%

Sessions per database

Key values

ctddev51 Main Database
124 sessions Total

Chart
Table

Database	Count	Total Duration	Average Duration
ctddev51	121	9d8h33m25s	1h51m21s
postgres	3	11h46m9s	3h55m23s

Sessions per user

Key values

pubeu Main User
124 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
pub1	3	12h49m6s	4h16m22s
pubeu	120	9d3h13m1s	1h49m36s
qaeu	1	4h17m27s	4h17m27s

Sessions per host

Key values

10.12.5.37 Main Host
124 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
10.12.5.37	93	7d6h41m12s	1h52m42s
192.168.201.10	27	1d20h31m49s	1h38m57s
192.168.201.6	4	17h6m33s	4h16m38s

Sessions per application

Key values

unknown Main Application
124 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
pgAdmin 4 - CONN:1340378	1	21s530ms	21s530ms
pgAdmin 4 - CONN:1542539	1	21s893ms	21s893ms
pgAdmin 4 - CONN:3810345	1	21s655ms	21s655ms
pgAdmin 4 - CONN:6828773	1	21s359ms	21s359ms
pgAdmin 4 - CONN:8699891	1	21s454ms	21s454ms
pgAdmin 4 - DB:ctddev51	4	22s410ms	5s602ms
unknown	115	9d20h17m25s	2h3m16s

Checkpoints Buffers

Key values

538 buffers Checkpoint Peak
2026-08-04 13:51:26 Date
54.129 seconds Highest write time
0.002 seconds Sync time

Checkpoints Wal files

Key values

0 files Wal files usage Peak
2026-08-04 13:51:26 Date

Checkpoints distance

Key values

0.08 Mo Distance Peak
2026-08-04 13:51:26 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Aug 04	11	0	0s	0s	0s
	12	0	0s	0s	0s
	13	538	54.129s	0.002s	54.146s
	14	30	3.108s	0.001s	3.123s
	15	0	0s	0s	0s
	16	87	8.807s	0.001s	8.823s
	17	0	0s	0s	0s
	18	49	5.021s	0.001s	5.037s
	19	0	0s	0s	0s
	20	0	0s	0s	0s

Day	Hour	Synced files	Longest sync	Average sync
Aug 04	11	0	0s	0s
	12	0	0s	0s
	13	11	0.001s	0.001s
	14	9	0.001s	0.001s
	15	0	0s	0s
	16	9	0.001s	0.001s
	17	0	0s	0s
	18	11	0.001s	0.001s
	19	0	0s	0s
	20	0	0s	0s

Day	Hour	Avg time (sec)
Aug 04	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s

Day	Hour	Mean distance	Mean estimate
Aug 04	11	0.00 kB	0.00 kB
	12	0.00 kB	0.00 kB
	13	39.00 kB	343.00 kB
	14	30.00 kB	312.00 kB
	15	0.00 kB	0.00 kB
	16	34.00 kB	284.00 kB
	17	0.00 kB	0.00 kB
	18	22.00 kB	258.00 kB
	19	0.00 kB	0.00 kB
	20	0.00 kB	0.00 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (4) Main checkpoint cause
4 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	4
Total	4

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Aug 04	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Aug 04	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

Most frequent waiting queries (N)

Rank	Count	Total time	Min time	Max time	Avg duration	Query
NO DATASET

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

18 Total read queries
3 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	18	85.71%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	3	14.29%
DDL	0	0.00%
TCL	0	0.00%
CURSOR	0	0.00%

Queries by database

Key values

unknown Main database
15 Requests
4m58s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
ctddev51	Total	6	3m27s
	cte	1	5s836ms
	select	5	3m21s
unknown	Total	15	4m58s
	cte	2	52s585ms
	select	13	4m5s

Queries by user

Key values

unknown Main user
15 Requests

Queries Chart
Table

User	Request type	Count	Duration
pubeu	Total	6	3m27s
	cte	1	5s836ms
	select	5	3m21s
unknown	Total	15	4m58s
	cte	2	52s585ms
	select	13	4m5s

Duration by user

Key values

4m58s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
pubeu	Total	6	3m27s
	cte	1	5s836ms
	select	5	3m21s
unknown	Total	15	4m58s
	cte	2	52s585ms
	select	13	4m5s

Queries by host

Key values

unknown Main host
21 Requests
8m25s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	21	8m25s
	cte	3	58s421ms
	select	18	7m27s

Queries by application

Key values

unknown Main application
21 Requests
8m25s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	21	8m25s
	cte	3	58s421ms
	select	18	7m27s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-08-04 16:00:14 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

15 > 10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	6	28.57%
> 10000ms	15	71.43%

Slowest individual queries

Rank	Duration	Query
1	51s819ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 15:43:58 - Database: ctddev51 - User: pubeu - Bind query: yes ]
2	51s728ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 16:19:17 - Bind query: yes ]
3	49s19ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50; [ Date:* 2026-08-04 16:18:08 - Bind query: yes ]
4	47s819ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50; [ Date:* 2026-08-04 15:44:54 - Bind query: yes ]
5	47s130ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50; [ Date:* 2026-08-04 15:51:25 - Database: ctddev51 - User: pubeu - Bind query: yes ]
6	46s874ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207489')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc LIMIT 50; [ Date:* 2026-08-04 16:18:17 - Database: ctddev51 - User: pubeu - Bind query: yes ]
7	41s297ms	SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc.id) = ( SELECT array_agg(anatomy_id ORDER BY anatomy_id) FROM chem_conc_anatomy WHERE chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2207989')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 15:21:36 - Database: ctddev51 - User: pubeu - Bind query: yes ]
8	26s421ms	WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html \|\| '^' \|\| anatomy_acc_txt \|\| '^' \|\| position_seq \|\| '^' \|\| anatomy_acc_db_id \|\| '^' \|\| anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids JOIN anatomy a3 ON a2.chem_conc_id = cc2.id AND a3.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in (2207489)) GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 16:14:10 ]
9	26s163ms	WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html \|\| '^' \|\| anatomy_acc_txt \|\| '^' \|\| position_seq \|\| '^' \|\| anatomy_acc_db_id \|\| '^' \|\| anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids JOIN anatomy a3 ON a2.chem_conc_id = cc2.id AND a3.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in (2207489)) GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 16:14:42 ]
10	17s374ms	SELECT /* ChemConcentrationDao / cc.id, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, cc.reference_acc_txt, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT x.chem_conc_id FROM chem_conc_anatomy x) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.id, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 14:05:03 ]
11	15s663ms	SELECT /* ChemConcentrationDao / cc.id ccid, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1448452') GROUP BY ccid, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 14:28:42 - Bind query: yes ]
12	15s134ms	SELECT /* ChemConcentrationDao / cc.id ccid, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1502245') GROUP BY ccid, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 14:28:09 - Bind query: yes ]
13	14s516ms	SELECT /* ChemConcentrationDao / cc.id ccid, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208377')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY chem, organism LIMIT 50; [ Date:* 2026-08-04 14:24:35 - Database: ctddev51 - User: pubeu - Bind query: yes ]
14	10s459ms	SELECT /* ChemConcentrationDao / cc.id, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, cc.reference_acc_txt, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT OUTER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT x.chem_conc_id FROM chem_conc_anatomy x) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.id, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 14:04:37 ]
15	10s344ms	SELECT /* ChemConcentrationDao / cc.id ccid, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT chem_conc_id FROM chem_conc_anatomy WHERE anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '2208377')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY chem, organism; [ Date:* 2026-08-04 14:26:38 - Bind query: yes ]
16	5s890ms	SELECT /* ChemConcentrationDao / cc.id, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT OUTER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id = cc.chem_id AND cc2.chem_conc = cc.chem_conc AND cc2.chem_conc_uom_nm = cc.chem_conc_uom_nm AND cc2.taxon_id = cc.taxon_id AND cc2.disease_id = cc.disease_id AND cc2.chem_conc_exp_route_nm = cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm = cc.ixn_qualifier_nm AND cc2.action_type_cd = cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT x.chem_conc_id FROM chem_conc_anatomy x) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.id, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 13:57:18 ]
17	5s888ms	SELECT /* ChemGeneIxnsDAO / g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casRN, c.id chemId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, i.id ixnId, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm \|\| '^' \|\| 'taxon' \|\| '^' \|\| taxonTerm.nm_html \|\| '^' \|\| taxonTerm.acc_txt \|\| '^' \|\| taxonTerm.acc_db_cd \|\| '^' \|\| COALESCE(taxonTerm.secondary_nm, ''), '\|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '\|')) as references, COUNT() OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE gcr.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1441693') GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY g.nm_sort, c.nm_sort, i.sort_txt LIMIT 50; [ Date: 2026-08-04 16:54:34 - Bind query: yes ]
18	5s836ms	WITH anatomy AS ( SELECT chem_conc_id, array_agg(anatomy_id ORDER BY anatomy_id) AS anatomy_ids, string_agg(DISTINCT anatomy_nm_html \|\| '^' \|\| anatomy_acc_txt \|\| '^' \|\| position_seq \|\| '^' \|\| anatomy_acc_db_id \|\| '^' \|\| anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy GROUP BY chem_conc_id ) SELECT /* ChemConcentrationDao / cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, a1.anatomyTerms anatomyTerms, a1.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as referenceCount, COUNT() OVER () fullRowCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id INNER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id IS NOT DISTINCT FROM cc.chem_id AND cc2.chem_conc IS NOT DISTINCT FROM cc.chem_conc AND cc2.chem_conc_uom_nm IS NOT DISTINCT FROM cc.chem_conc_uom_nm AND cc2.taxon_id IS NOT DISTINCT FROM cc.taxon_id AND cc2.disease_id IS NOT DISTINCT FROM cc.disease_id AND cc2.chem_conc_exp_route_nm IS NOT DISTINCT FROM cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm IS NOT DISTINCT FROM cc.ixn_qualifier_nm AND cc2.action_type_cd IS NOT DISTINCT FROM cc.action_type_cd JOIN anatomy a1 ON a1.chem_conc_id = cc.id JOIN anatomy a2 ON a2.chem_conc_id = cc2.id AND a1.anatomy_ids = a2.anatomy_ids LEFT JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id WHERE t.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1441693') GROUP BY cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, a1.anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc ORDER BY organism LIMIT 50; [ Date:* 2026-08-04 16:50:27 - Database: ctddev51 - User: pubeu - Bind query: yes ]
19	5s522ms	SELECT /* ChemConcentrationDao / cc.id, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, cc.reference_acc_txt, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT OUTER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id = cc.chem_id AND cc2.chem_conc = cc.chem_conc AND cc2.chem_conc_uom_nm = cc.chem_conc_uom_nm AND cc2.taxon_id = cc.taxon_id AND cc2.disease_id = cc.disease_id AND cc2.chem_conc_exp_route_nm = cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm = cc.ixn_qualifier_nm AND cc2.action_type_cd = cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT x.chem_conc_id FROM chem_conc_anatomy x) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.id, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 13:58:39 ]
20	5s441ms	SELECT /* ChemConcentrationDao / cc.id, cc.chem_id chem_id, t.nm chem, t.nm_html chemNmHtml, t.acc_txt chemAcc, t.secondary_nm casRN, cc.chem_conc \|\| ' ' \|\| cc.chem_conc_uom_nm as concentration, cc.ixn_qualifier_nm vivoVitro, cc.chem_conc_exp_route_nm expRoute, cc.taxon_nm_html organism, cca.anatomyTerms anatomyTerms, cca.anatomyTerms anatomyTermsSort, cc.action_type_cd directEvidence, cc.action_type_cd directEvidenceSort, d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, tx.nm taxonnm, tx.secondary_nm taxoncomnm, tx.id taxonid, tx.acc_txt taxonacc, cc.reference_id, string_agg(distinct cc2.acc_txt, '\|') AS refAcc, COUNT(DISTINCT cc2.reference_id) as refCount FROM chem_conc cc INNER JOIN term t ON cc.chem_id = t.id INNER JOIN term tx ON cc.taxon_id = tx.id LEFT JOIN term d ON cc.disease_id = d.id LEFT OUTER JOIN ( SELECT cc2., refer.acc_txt FROM chem_conc cc2 LEFT OUTER JOIN REFERENCE refer ON cc2.reference_id = refer.id) cc2 ON cc2.chem_id = cc.chem_id AND cc2.chem_conc = cc.chem_conc AND cc2.chem_conc_uom_nm = cc.chem_conc_uom_nm AND cc2.taxon_id = cc.taxon_id AND cc2.disease_id = cc.disease_id AND cc2.chem_conc_exp_route_nm = cc.chem_conc_exp_route_nm AND cc2.ixn_qualifier_nm = cc.ixn_qualifier_nm AND cc2.action_type_cd = cc.action_type_cd AND EXISTS ( SELECT 1 FROM chem_conc_anatomy a1 JOIN chem_conc_anatomy a2 ON a1.anatomy_id = a2.anatomy_id WHERE a1.chem_conc_id = cc.id AND a2.chem_conc_id = cc2.id) INNER JOIN ( SELECT cca.chem_conc_id, string_agg(distinct cca.anatomy_nm_html \|\| '^' \|\| cca.anatomy_acc_txt \|\| '^' \|\| cca.position_seq \|\| '^' \|\| cca.anatomy_acc_db_id \|\| '^' \|\| cca.anatomy_nm, '\|') AS anatomyTerms FROM chem_conc_anatomy cca WHERE cca.chem_conc_id IN ( SELECT x.chem_conc_id FROM chem_conc_anatomy x) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY cc.id, cc.chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc; [ Date: 2026-08-04 13:57:57 ]

Time consuming queries (N)


[ User: pubeu - Total duration: 1m34s - Times executed: 2 ]
[ User: pubeu - Total duration: 1m33s - Times executed: 2 ]
Date: 2026-08-04 16:14:10
Duration: 26s421ms
Date: 2026-08-04 14:28:42
Duration: 15s663ms
Bind query: yes
Date: 2026-08-04 14:05:03
Duration: 17s374ms
[ User: pubeu - Total duration: 14s516ms - Times executed: 1 ]
Date: 2026-08-04 13:58:39
Duration: 5s522ms
Date: 2026-08-04 14:04:37
Duration: 10s459ms
Date: 2026-08-04 14:26:38
Duration: 10s344ms
Bind query: yes
Date: 2026-08-04 13:57:18
Duration: 5s890ms
Date: 2026-08-04 16:54:34
Duration: 5s888ms
Bind query: yes
[ User: pubeu - Total duration: 5s836ms - Times executed: 1 ]
Date: 2026-08-04 13:57:57
Duration: 5s441ms

Most frequent queries (N)


[ User: pubeu - Total duration: 1m34s - Times executed: 2 ]
[ User: pubeu - Total duration: 1m33s - Times executed: 2 ]
Date: 2026-08-04 16:14:10
Duration: 26s421ms
Date: 2026-08-04 14:28:42
Duration: 15s663ms
Bind query: yes
Date: 2026-08-04 13:58:39
Duration: 5s522ms
Date: 2026-08-04 14:05:03
Duration: 17s374ms
[ User: pubeu - Total duration: 14s516ms - Times executed: 1 ]
Date: 2026-08-04 14:04:37
Duration: 10s459ms
Date: 2026-08-04 14:26:38
Duration: 10s344ms
Bind query: yes
Date: 2026-08-04 13:57:18
Duration: 5s890ms
Date: 2026-08-04 16:54:34
Duration: 5s888ms
Bind query: yes
[ User: pubeu - Total duration: 5s836ms - Times executed: 1 ]
Date: 2026-08-04 13:57:57
Duration: 5s441ms

Normalized slowest queries (N)


[ User: pubeu - Total duration: 1m33s - Times executed: 2 ]
[ User: pubeu - Total duration: 1m34s - Times executed: 2 ]
Date: 2026-08-04 16:14:10
Duration: 26s421ms
Date: 2026-08-04 14:05:03
Duration: 17s374ms
Date: 2026-08-04 14:28:42
Duration: 15s663ms
Bind query: yes
[ User: pubeu - Total duration: 14s516ms - Times executed: 1 ]
Date: 2026-08-04 14:04:37
Duration: 10s459ms
Date: 2026-08-04 14:26:38
Duration: 10s344ms
Bind query: yes
Date: 2026-08-04 13:57:18
Duration: 5s890ms
Date: 2026-08-04 16:54:34
Duration: 5s888ms
Bind query: yes
[ User: pubeu - Total duration: 5s836ms - Times executed: 1 ]
Date: 2026-08-04 13:57:57
Duration: 5s441ms
Date: 2026-08-04 13:58:39
Duration: 5s522ms

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

697 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
DETAIL	13	1.87%
ERROR	61	8.75%
EVENTLOG	23	3.30%
FATAL	1	0.14%
HINT	10	1.43%
LOG	528	75.75%
STATEMENT	61	8.75%

Events distribution (except queries)

Key values

0 PANIC entries
1 FATAL entries
61 ERROR entries
0 WARNING entries
23 EVENTLOG entries

Most Frequent Errors/Events

Key values

14 Max number of times the same event was reported
85 Total events found

Rank

Times reported

Error

1

14

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Aug 04	13	10
	14	3
	16	1

ERROR: column "chem_con_nm" does not exist at character 139
ERROR: column cc2.acc_txt does not exist at character 878
ERROR: column cc2.acc_txt does not exist at character 878

2

13

Details

ERROR: syntax error at or near "..."

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Aug 04	11	1
	14	7
	15	3
	16	2

ERROR: syntax error at or near "outer" at character 733
ERROR: syntax error at or near "FROM" at character 611
ERROR: syntax error at or near "from" at character 12

3

11

Details

LOG: could not receive data from client: Connection timed out

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Aug 04	16	7
	19	3
	20	1

4

11

Details

LOG: could not receive data from client: Connection reset by peer

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Aug 04	12	6
	17	5

5

9

Details

ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Aug 04	13	2
	14	7

ERROR: column "cc2.id" must appear in the GROUP BY clause or be used in an aggregate function at character 804
ERROR: column "x.refcount" must appear in the GROUP BY clause or be used in an aggregate function at character 597
ERROR: column "cc.reference_acc_txt" must appear in the GROUP BY clause or be used in an aggregate function at character 582

6

9

Details

ERROR: missing FROM-clause entry for table "..."

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Aug 04	12	1
	13	3
	14	1
	15	2
	16	2

ERROR: missing FROM-clause entry for table "t" at character 172
ERROR: missing FROM-clause entry for table "r" at character 877
ERROR: missing FROM-clause entry for table "refer" at character 878

7

4

Details

ERROR: column reference "..." is ambiguous

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Aug 04	13	1
	15	1
	16	2

ERROR: column reference "chem_id" is ambiguous at character 1699
ERROR: column reference "anatomyterms" is ambiguous at character 2891
ERROR: column reference "anatomyterms" is ambiguous at character 1037

8

4

Details

ERROR: subquery in FROM must have an alias

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Aug 04	14	1
	15	3

ERROR: subquery in FROM must have an alias at character 22
ERROR: subquery in FROM must have an alias at character 93
ERROR: subquery in FROM must have an alias at character 93

9

3

Details

ERROR: aggregate functions are not allowed in GROUP BY

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Aug 04	13	2
	14	1

ERROR: aggregate functions are not allowed in GROUP BY at character 589
ERROR: aggregate functions are not allowed in GROUP BY at character 638
ERROR: aggregate functions are not allowed in GROUP BY at character 224

10

2

Details

ERROR: invalid reference to FROM-clause entry for table "..."

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Aug 04	13	2

ERROR: invalid reference to FROM-clause entry for table "cc" at character 964
ERROR: invalid reference to FROM-clause entry for table "cc" at character 1003

11

1

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Aug 04	16	1

12

1

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Aug 04	16	1

13

1

Details

ERROR: argument of AND must be type boolean, not type integer

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Aug 04	13	1

ERROR: argument of AND must be type boolean, not type integer at character 1019

14

1

Details

ERROR: syntax error at end of input

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Aug 04	14	1

ERROR: syntax error at end of input at character 578

15

1

Details

ERROR: table name "..." specified more than once

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Aug 04	15	1

ERROR: table name "r" specified more than once

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most