pgBadger-
Global information
- Generated on Tue Aug 4 04:10:04 2026
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20260803
- Parsed 1,035 log entries in 2s
- Log start from 2026-08-03 09:50:27 to 2026-08-03 21:55:42
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 15 Number of queries
- 22m41s Total query duration
- 2026-08-03 15:28:13 First query
- 2026-08-03 18:32:51 Last query
- 1 queries/s at 2026-08-03 17:00:54 Query peak
- 22m41s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 22m41s Execute total duration
- 23 Number of events
- 5 Number of unique normalized events
- 6 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
- 110 Total number of sessions
- 14 sessions at 2026-08-03 18:32:47 Session peak
- 11d22h55m38s Total duration of sessions
- 2h36m30s Average duration of sessions
- 0 Average queries per session
- 12s375ms Average queries duration per session
- 2h36m17s Average idle time per session
- 113 Total number of connections
- 9 connections/s at 2026-08-03 18:25:51 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-08-03 17:00:54 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-08-03 17:00:54 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 22m41s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 4 0ms 5m45s 2m51s 5m45s 5m45s 5m45s 16 4 0ms 2m28s 1m20s 20s184ms 4m54s 4m54s 17 2 2m25s 2m27s 2m26s 4m53s 4m53s 4m53s 18 5 0ms 12s340ms 12s98ms 12s340ms 12s340ms 12s340ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 4 0 2m51s 3m17s 5m45s 5m45s 16 4 0 1m20s 5s715ms 20s184ms 4m54s 17 2 0 2m26s 4m53s 4m53s 4m53s 18 5 0 12s98ms 12s298ms 12s340ms 12s340ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 03 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 4 4.00 0.00% 16 0 4 4.00 0.00% 17 0 2 2.00 0.00% 18 0 5 5.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% Day Hour Count Average / Second Aug 03 09 3 0.00/s 10 0 0.00/s 11 12 0.00/s 14 0 0.00/s 15 20 0.01/s 16 40 0.01/s 17 0 0.00/s 18 38 0.01/s 20 0 0.00/s 21 0 0.00/s Day Hour Count Average Duration Average idle time Aug 03 09 0 0ms 0ms 10 0 0ms 0ms 11 12 17h18m13s 17h18m13s 14 0 0ms 0ms 15 20 1h31m28s 1h30m54s 16 34 20m24s 20m15s 17 2 3m40s 1m13s 18 37 20m46s 20m45s 20 0 0ms 0ms 21 5 4h51m24s 4h51m24s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-08-03 18:25:51 Date
Connections per database
Key values
- ctddev51 Main Database
- 113 connections Total
Connections per user
Key values
- pubeu Main User
- 113 connections Total
-
Sessions
Simultaneous sessions
Key values
- 14 sessions Session Peak
- 2026-08-03 18:32:47 Date
Histogram of session times
Key values
- 59 60000-600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 110 sessions Total
Sessions per user
Key values
- pubeu Main User
- 110 sessions Total
Sessions per host
Key values
- 10.12.5.37 Main Host
- 110 sessions Total
Sessions per application
Key values
- unknown Main Application
- 110 sessions Total
Application Count Total Duration Average Duration pgAdmin 4 - CONN:1309142 1 1m28s 1m28s pgAdmin 4 - CONN:135184 1 1m27s 1m27s pgAdmin 4 - CONN:365833 1 1m28s 1m28s pgAdmin 4 - CONN:3740352 1 1m28s 1m28s pgAdmin 4 - CONN:603359 1 1m28s 1m28s pgAdmin 4 - DB:ctddev51 2 1m31s 45s726ms unknown 103 11d22h46m45s 2h47m3s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 417 buffers Checkpoint Peak
- 2026-08-03 09:51:09 Date
- 41.989 seconds Highest write time
- 0.001 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-08-03 10:20:29 Date
Checkpoints distance
Key values
- 0.06 Mo Distance Peak
- 2026-08-03 15:50:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 03 09 417 41.989s 0.001s 42.004s 10 11 1.455s 0.001s 1.471s 11 0 0s 0s 0s 14 91 9.222s 0.001s 9.238s 15 56 5.729s 0.001s 5.744s 16 18 1.887s 0.001s 1.902s 17 0 0s 0s 0s 18 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 03 09 0 0 0 4 0.001s 0.001s 10 0 0 0 5 0.001s 0.001s 11 0 0 0 0 0s 0s 14 0 0 0 10 0.001s 0.001s 15 0 0 0 10 0.001s 0.001s 16 0 0 0 9 0.001s 0.001s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Aug 03 09 0 0s 10 0 0s 11 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 20 0 0s 21 0 0s Day Hour Mean distance Mean estimate Aug 03 09 2.00 kB 563.00 kB 10 5.00 kB 507.00 kB 11 0.00 kB 0.00 kB 14 21.00 kB 459.00 kB 15 30.00 kB 416.00 kB 16 25.00 kB 377.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 03 09 0 0 0 10 0 0 0 11 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 20 0 0 0 21 0 0 0 -
Vacuums
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)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 03 09 0 0 10 0 0 11 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 20 0 0 21 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
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
Queries by type
Key values
- 15 Total read queries
- 0 Total write queries
Queries by database
Key values
- ctddev51 Main database
- 11 Requests
- 19m37s (ctddev51)
- Main time consuming database
Queries by user
Key values
- pubeu Main user
- 11 Requests
User Request type Count Duration pubeu Total 11 19m37s select 11 19m37s unknown Total 4 3m3s select 4 3m3s Duration by user
Key values
- 19m37s (pubeu) Main time consuming user
User Request type Count Duration pubeu Total 11 19m37s select 11 19m37s unknown Total 4 3m3s select 4 3m3s Queries by host
Key values
- unknown Main host
- 15 Requests
- 22m41s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 15 Requests
- 22m41s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-03 15:28:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 5m45s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc ORDER BY chem, organism LIMIT 50;[ Date: 2026-08-03 15:52:43 - Database: ctddev51 - User: pubeu - Bind query: yes ]
2 3m17s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2207881')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 15:31:51 - Database: ctddev51 - User: pubeu - Bind query: yes ]
3 2m28s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 16:59:18 - Database: ctddev51 - User: pubeu - Bind query: yes ]
4 2m27s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 17:00:54 - Database: ctddev51 - User: pubeu - Bind query: yes ]
5 2m25s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 17:00:28 - Database: ctddev51 - User: pubeu - Bind query: yes ]
6 2m25s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 16:59:27 - Database: ctddev51 - User: pubeu - Bind query: yes ]
7 2m18s 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208350')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 15:30:40 - Bind query: yes ]
8 20s184ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 16:06:22 - Bind query: yes ]
9 12s340ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 18:26:13 - Bind query: yes ]
10 12s298ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 18:22:21 - Database: ctddev51 - User: pubeu - Bind query: yes ]
11 12s290ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 18:14:46 - Database: ctddev51 - User: pubeu - Bind query: yes ]
12 12s212ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 18:15:38 - Bind query: yes ]
13 11s351ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208350')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 18:32:51 - Database: ctddev51 - User: pubeu - Bind query: yes ]
14 5s755ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208596')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 15:28:13 - Database: ctddev51 - User: pubeu - Bind query: yes ]
15 5s715ms 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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208596')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;[ Date: 2026-08-03 16:09:26 - Database: ctddev51 - User: pubeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 15m35s 8 5s715ms 3m17s 1m56s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 15 3 5m42s 1m54s 16 3 5m 1m40s 17 2 4m53s 2m26s [ User: pubeu - Total duration: 13m16s - Times executed: 7 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2207881')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 15:31:51 Duration: 3m17s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:59:18 Duration: 2m28s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 17:00:54 Duration: 2m27s Database: ctddev51 User: pubeu Bind query: yes
2 5m45s 1 5m45s 5m45s 5m45s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc order by chem, organism limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 15 1 5m45s 5m45s [ User: pubeu - Total duration: 5m45s - Times executed: 1 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc ORDER BY chem, organism LIMIT 50;
Date: 2026-08-03 15:52:43 Duration: 5m45s Database: ctddev51 User: pubeu Bind query: yes
3 1m 5 11s351ms 12s340ms 12s98ms select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by ccid, chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 18 5 1m 12s98ms [ User: pubeu - Total duration: 35s940ms - Times executed: 3 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:26:13 Duration: 12s340ms Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:22:21 Duration: 12s298ms Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:14:46 Duration: 12s290ms Database: ctddev51 User: pubeu Bind query: yes
4 20s184ms 1 20s184ms 20s184ms 20s184ms select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 16 1 20s184ms 20s184ms -
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:06:22 Duration: 20s184ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 8 15m35s 5s715ms 3m17s 1m56s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 15 3 5m42s 1m54s 16 3 5m 1m40s 17 2 4m53s 2m26s [ User: pubeu - Total duration: 13m16s - Times executed: 7 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2207881')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 15:31:51 Duration: 3m17s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:59:18 Duration: 2m28s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 17:00:54 Duration: 2m27s Database: ctddev51 User: pubeu Bind query: yes
2 5 1m 11s351ms 12s340ms 12s98ms select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by ccid, chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 18 5 1m 12s98ms [ User: pubeu - Total duration: 35s940ms - Times executed: 3 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:26:13 Duration: 12s340ms Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:22:21 Duration: 12s298ms Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:14:46 Duration: 12s290ms Database: ctddev51 User: pubeu Bind query: yes
3 1 5m45s 5m45s 5m45s 5m45s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc order by chem, organism limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 15 1 5m45s 5m45s [ User: pubeu - Total duration: 5m45s - Times executed: 1 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc ORDER BY chem, organism LIMIT 50;
Date: 2026-08-03 15:52:43 Duration: 5m45s Database: ctddev51 User: pubeu Bind query: yes
4 1 20s184ms 20s184ms 20s184ms 20s184ms select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 16 1 20s184ms 20s184ms -
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:06:22 Duration: 20s184ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 5m45s 5m45s 5m45s 1 5m45s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc order by chem, organism limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 15 1 5m45s 5m45s [ User: pubeu - Total duration: 5m45s - Times executed: 1 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc ORDER BY chem, organism LIMIT 50;
Date: 2026-08-03 15:52:43 Duration: 5m45s Database: ctddev51 User: pubeu Bind query: yes
2 5s715ms 3m17s 1m56s 8 15m35s select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 15 3 5m42s 1m54s 16 3 5m 1m40s 17 2 4m53s 2m26s [ User: pubeu - Total duration: 13m16s - Times executed: 7 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2207881')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 15:31:51 Duration: 3m17s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:59:18 Duration: 2m28s Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 17:00:54 Duration: 2m27s Database: ctddev51 User: pubeu Bind query: yes
3 20s184ms 20s184ms 20s184ms 1 20s184ms select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?) group by chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 16 1 20s184ms 20s184ms -
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '1539167') GROUP BY chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 16:06:22 Duration: 20s184ms Bind query: yes
4 11s351ms 12s340ms 12s98ms 5 1m select 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, refacc, count(distinct cc.reference_id) 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 left join ( select r.id, string_agg(distinct r.acc_txt, ?) as refacc from reference r group by r.id) r on cc.reference_id = r.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 = ?)) group by cca.chem_conc_id) cca on cc.id = cca.chem_conc_id group by ccid, chem_id, chem, chemnmhtml, chemacc, casrn, concentration, vivovitro, exproute, organism, anatomyterms, anatomytermssort, directevidence, directevidencesort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refacc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 18 5 1m 12s98ms [ User: pubeu - Total duration: 35s940ms - Times executed: 3 ]
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:26:13 Duration: 12s340ms Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:22:21 Duration: 12s298ms Database: ctddev51 User: pubeu Bind query: yes
-
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, refAcc, COUNT(DISTINCT cc.reference_id) 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 LEFT JOIN ( SELECT r.id, string_agg(distinct r.acc_txt, '|') AS refAcc FROM reference r GROUP BY r.id) r ON cc.reference_id = r.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 = '2208555')) GROUP BY cca.chem_conc_id) cca ON cc.id = cca.chem_conc_id GROUP BY ccid, chem_id, chem, chemNmHtml, chemAcc, casRN, concentration, vivoVitro, expRoute, organism, anatomyTerms, anatomyTermsSort, directEvidence, directEvidenceSort, diseasenm, diseaseacc, diseaseaccdbcd, diseaseid, taxonnm, taxoncomnm, taxonid, taxonacc, refAcc LIMIT 50;
Date: 2026-08-03 18:14:46 Duration: 12s290ms Database: ctddev51 User: pubeu Bind query: yes
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
-
Events
Log levels
Key values
- 536 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 18 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6 Max number of times the same event was reported
- 23 Total events found
Rank Times reported Error 1 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 03 14 1 16 2 20 3 - ERROR: column "chemical" does not exist at character 694
- ERROR: column "fullrowcount" does not exist at character 594
- ERROR: column "fullrowcount" does not exist at character 597
Statement: select distinct chem_nm as ChemicalName ,concat(chem_conc || ' ', chem_conc_uom_nm) as Concentration ,ixn_qualifier_nm as VivoVitro ,chem_conc_exp_route_nm as ExposureRouteName ,taxon_nm as Organism ,STRING_AGG (DISTINCT anatomy_nm, '|' ORDER BY anatomy_nm) as Anatomy ,action_type_cd as DirectEvidence ,disease_nm as DiseaseName ,STRING_AGG(DISTINCT reference_acc_txt, '|' ORDER BY reference_acc_txt) as Reference from chem_conc cc inner join chem_conc_anatomy cca on cc.id = cca.chem_conc_id --where chem_nm = 'tanshinone' group by ChemicalName ,Concentration ,VivoVitro ,ExposureRouteName ,Organism ,DirectEvidence ,DiseaseName order by Chemical,Concentration,Organism
Date: 2026-08-03 14:46:40 Database: ctddev51 Application: pgAdmin 4 - CONN:4306899 User: pub1 Remote:
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id ) i WHERE fullRowCount = 2
Date: 2026-08-03 16:54:34
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() as fullRowCount FROM (SELECT DISTINCT cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id ) i WHERE fullRowCount = 2
Date: 2026-08-03 16:54:42
2 6 ERROR: operator does not exist: character varying = integer
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 03 16 6 - ERROR: operator does not exist: character varying = integer at character 667
- ERROR: operator does not exist: character varying = integer at character 670
- ERROR: operator does not exist: character varying = integer at character 647
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = $1 ) i WHERE i.concentration = '0.01-20 micromolar' AND i.refAcc IN (35780740) ORDER BY 1 LIMIT 50Date: 2026-08-03 16:42:32 Database: ctddev51 Application: User: pubeu Remote:
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = $1 ) i WHERE i.concentration = '0.01-20 micromolar' AND i.refAcc IN (35780740) ORDER BY 1 LIMIT 50Date: 2026-08-03 16:46:05 Database: ctddev51 Application: User: pubeu Remote:
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id ) i WHERE i.concentration = '0.01-20 micromolar' AND i.refAcc IN (35780740)Date: 2026-08-03 16:49:15 Database: ctddev51 Application: pgAdmin 4 - CONN:1309142 User: pubeu Remote:
3 5 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 03 21 5 4 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 03 15 1 18 3 20 1 - ERROR: syntax error at or near "SELECT" at character 300
- ERROR: syntax error at or near "cc" at character 114
- ERROR: syntax error at or near "cc" at character 117
Statement: select distinct chem_nm as ChemicalName ,concat(chem_conc || ' ', chem_conc_uom_nm) as Concentration ,ixn_qualifier_nm as VivoVitro ,chem_conc_exp_route_nm as ExposureRouteName ,taxon_nm as Organism -- ,STRING_AGG (DISTINCT anatomy_nm, '|' ORDER BY anatomy_nm) as Anatomy , SELECT STRING_AGG( distinct cca.position_seq + 1 || '^' || cca.anatomy_nm || '^' || cca.anatomy_acc_txt, '|' ORDER BY cca.position_seq + 1 || '^' || cca.anatomy_nm || '^' || cca.anatomy_acc_txt ) ) as anatomyTerms ,action_type_cd as DirectEvidence ,disease_nm as DiseaseName , reference_acc_txt as Reference -- -- ,STRING_AGG(DISTINCT reference_acc_txt, '|' ORDER BY reference_acc_txt) as Reference from chem_conc cc inner join chem_conc_anatomy cca on cc.id = cca.chem_conc_id where chem_nm = 'tanshinone' --where chem_nm = '2-(4-morpholinyl)-8-phenyl-4H-1-benzopyran-4-one' group by cc.chem_nm ,cc.chem_conc ,cc.chem_conc_uom_nm ,cc.ixn_qualifier_nm ,cc.chem_conc_exp_route_nm ,cc.taxon_nm ,cc.action_type_cd ,cc.disease_nm ,reference_acc_txt -- order by cc.chem_nm,cc.taxon_nm
Date: 2026-08-03 15:23:01
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() fullRowCount FROM (SELECT DISTINCT cc.id ccid cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id WHERE cc.chem_id = $1 ) i WHERE i.concentration = '1-3 parts per million' AND i.ccid IN (6) ORDER BY 1 LIMIT 50
Date: 2026-08-03 18:25:57 Database: ctddev51 Application: User: pubeu Remote:
Statement: SELECT /* ChemConcentrationRefsDAO */ i.* ,COUNT(*) OVER() as fullRowCount FROM (SELECT DISTINCT cc.id ccid cc.chem_conc || ' ' || cc.chem_conc_uom_nm AS concentration ,r.acc_txt as refAcc ,r.id ,r.abbr_authors_txt authors ,r.title ,r.core_citation_txt citation ,r.pub_start_yr yr ,r.has_diseases or r.has_ixns or r.has_exposures or r.has_phenotypes iscurated ,c.acc_txt chemacc ,cc.chem_id chemid ,cc.disease_id diseaseid ,r.has_exposures hasExposures FROM chem_conc cc INNER JOIN term c ON cc.chem_id = c.id LEFT OUTER JOIN REFERENCE r ON cc.reference_id = r.id ) i where i.ccid = 6
Date: 2026-08-03 18:27:13
5 1 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 03 15 1 - ERROR: column "cc.reference_acc_txt" must appear in the GROUP BY clause or be used in an aggregate function at character 360
Statement: select chem_nm as ChemicalName ,concat(chem_conc || ' ', chem_conc_uom_nm) as Concentration ,ixn_qualifier_nm as VivoVitro ,chem_conc_exp_route_nm as ExposureRouteName ,taxon_nm as Organism ,STRING_AGG (DISTINCT anatomy_nm, '|' ORDER BY anatomy_nm) as Anatomy ,action_type_cd as DirectEvidence ,disease_nm as DiseaseName , reference_acc_txt as Reference -- ,STRING_AGG(DISTINCT reference_acc_txt, '|' ORDER BY reference_acc_txt) as Reference from chem_conc cc inner join chem_conc_anatomy cca on cc.id = cca.chem_conc_id --where chem_nm = 'tanshinone' where chem_nm = '2-(4-morpholinyl)-8-phenyl-4H-1-benzopyran-4-one' group by cc.chem_nm ,cc.chem_conc ,cc.chem_conc_uom_nm ,cc.ixn_qualifier_nm ,cc.chem_conc_exp_route_nm ,cc.taxon_nm ,cc.action_type_cd ,cc.disease_nm order by cc.chem_nm,cc.taxon_nm
Date: 2026-08-03 15:14:11