pgBadger-
Global information
- Generated on Mon Mar 9 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260308
- Parsed 14,966 log entries in 2s
- Log start from 2026-03-08 00:00:02 to 2026-03-08 23:59:58
-
Overview
Global Stats
- 11 Number of unique normalized queries
- 19 Number of queries
- 15m35s Total query duration
- 2026-03-08 00:09:16 First query
- 2026-03-08 18:56:12 Last query
- 1 queries/s at 2026-03-08 05:44:04 Query peak
- 15m35s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 15m35s Execute total duration
- 14 Number of events
- 1 Number of unique normalized events
- 14 Max number of times the same event was reported
- 0 Number of cancellation
- 5 Total number of automatic vacuums
- 18 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,830 Total number of sessions
- 48 sessions at 2026-03-08 20:46:26 Session peak
- 44d3h32m13s Total duration of sessions
- 34m44s Average duration of sessions
- 0 Average queries per session
- 511ms Average queries duration per session
- 34m43s Average idle time per session
- 1,826 Total number of connections
- 9 connections/s at 2026-03-08 05:45:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-08 05:44:04 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-03-08 05:44:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 15m35s 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) Mar 08 00 2 0ms 9m14s 4m40s 0ms 0ms 9m20s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 6 0ms 7s587ms 6s691ms 5s123ms 14s772ms 15s68ms 06 4 0ms 1m10s 1m10s 0ms 0ms 4m40s 07 1 0ms 5s19ms 5s19ms 0ms 0ms 5s19ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 1 0ms 8s890ms 8s890ms 0ms 0ms 8s890ms 11 3 0ms 5s632ms 5s346ms 0ms 0ms 16s38ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 1 0ms 18s730ms 18s730ms 0ms 0ms 18s730ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 5s481ms 5s481ms 0ms 0ms 5s481ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 08 00 1 0 9m14s 0ms 0ms 9m14s 01 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 6 0 6s691ms 0ms 5s123ms 15s68ms 06 4 0 1m10s 0ms 0ms 4m40s 07 1 0 5s19ms 0ms 0ms 5s19ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 1 0 8s890ms 0ms 0ms 8s890ms 11 3 0 5s346ms 0ms 0ms 16s38ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 1 0 18s730ms 0ms 0ms 18s730ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 1 0 5s481ms 0ms 0ms 5s481ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 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 12 0 0 0 0 0ms 0ms 0ms 0ms 13 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 19 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 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 6 6.00 0.00% 06 0 4 4.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 1 1.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 1 1.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 08 00 83 0.02/s 01 79 0.02/s 03 86 0.02/s 04 81 0.02/s 05 96 0.03/s 06 82 0.02/s 07 75 0.02/s 08 77 0.02/s 09 80 0.02/s 10 76 0.02/s 11 82 0.02/s 12 75 0.02/s 13 79 0.02/s 14 77 0.02/s 15 77 0.02/s 16 81 0.02/s 17 77 0.02/s 18 79 0.02/s 19 86 0.02/s 20 73 0.02/s 21 71 0.02/s 22 76 0.02/s 23 78 0.02/s Day Hour Count Average Duration Average idle time Mar 08 00 83 29m10s 29m3s 01 80 55m40s 55m40s 03 85 53m27s 53m27s 04 83 46m50s 46m50s 05 96 26m2s 26m2s 06 82 28m50s 28m46s 07 75 32m1s 32m1s 08 77 31m46s 31m46s 09 80 30m7s 30m7s 10 76 31m7s 31m7s 11 82 30m17s 30m17s 12 75 31m8s 31m8s 13 79 31m13s 31m13s 14 77 31m40s 31m39s 15 77 30m34s 30m34s 16 81 31m8s 31m8s 17 79 51m48s 51m48s 18 79 30m47s 30m47s 19 78 30m8s 30m8s 20 73 31m8s 31m8s 21 79 41m14s 41m14s 22 76 31m5s 31m5s 23 78 30m51s 30m51s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-03-08 05:45:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,826 connections Total
Connections per user
Key values
- pubeu Main User
- 1,826 connections Total
-
Sessions
Simultaneous sessions
Key values
- 48 sessions Session Peak
- 2026-03-08 20:46:26 Date
Histogram of session times
Key values
- 1,719 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,830 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,830 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,830 sessions Total
Host Count Total Duration Average Duration 10.12.5.45 369 7d15h58m58s 29m54s 10.12.5.46 360 7d16h19s 30m40s 10.12.5.53 376 7d16h11m46s 29m23s 10.12.5.54 358 7d15h46m49s 30m48s 10.12.5.55 353 7d15h23m49s 31m10s 192.168.201.10 2 2d21h20m31s 1d10h40m15s 192.168.201.14 8 17h48m26s 2h13m33s 192.168.201.6 4 2d5h1m31s 13h15m22s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 85,115 buffers Checkpoint Peak
- 2026-03-08 06:13:23 Date
- 1619.716 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-03-08 19:43:25 Date
Checkpoints distance
Key values
- 1,032.48 Mo Distance Peak
- 2026-03-08 06:13:23 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 08 00 281 28.343s 0.002s 28.354s 01 66 6.792s 0.002s 6.801s 03 2,397 240.041s 0.002s 240.1s 04 2,177 218.109s 0.002s 218.166s 05 155 15.619s 0.001s 15.624s 06 85,234 1,631.165s 0.002s 1,631.299s 07 4,320 432.733s 0.002s 432.794s 08 447 44.968s 0.002s 44.978s 09 349 35.18s 0.002s 35.189s 10 294 29.639s 0.002s 29.648s 11 115 11.69s 0.002s 11.7s 12 568 57.081s 0.003s 57.091s 13 998 100.134s 0.002s 100.185s 14 162 16.415s 0.002s 16.424s 15 977 98.048s 0.002s 98.057s 16 25 2.678s 0.002s 2.688s 17 15 1.681s 0.002s 1.69s 18 16 1.774s 0.002s 1.784s 19 17,958 1,619.716s 0.001s 1,619.796s 20 72 7.388s 0.002s 7.396s 21 41 4.301s 0.002s 4.311s 22 117 11.906s 0.002s 11.915s 23 113 11.501s 0.002s 11.509s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 08 00 0 0 0 60 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 03 0 1 0 37 0.001s 0.002s 04 0 1 0 43 0.001s 0.002s 05 0 0 0 18 0.001s 0.001s 06 0 32 0 49 0.001s 0.002s 07 0 3 0 38 0.001s 0.002s 08 0 0 0 122 0.001s 0.002s 09 0 0 0 106 0.001s 0.002s 10 0 0 0 72 0.001s 0.002s 11 0 0 0 24 0.001s 0.002s 12 0 0 0 126 0.001s 0.002s 13 0 1 0 108 0.001s 0.002s 14 0 0 0 63 0.001s 0.002s 15 0 0 0 38 0.001s 0.002s 16 0 0 0 16 0.001s 0.002s 17 0 0 0 13 0.001s 0.002s 18 0 0 0 13 0.001s 0.002s 19 0 12 0 26 0.001s 0.001s 20 0 0 0 22 0.001s 0.002s 21 0 0 0 19 0.001s 0.002s 22 0 0 0 32 0.001s 0.002s 23 0 0 0 27 0.001s 0.002s Day Hour Count Avg time (sec) Mar 08 00 0 0s 01 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 08 00 1,072.50 kB 45,228.50 kB 01 162.00 kB 36,654.50 kB 03 9,458.50 kB 30,650.50 kB 04 2,563.50 kB 26,149.00 kB 05 361.00 kB 22,347.00 kB 06 264,569.50 kB 502,223.50 kB 07 22,301.00 kB 411,056.50 kB 08 1,196.00 kB 333,103.50 kB 09 843.00 kB 270,022.50 kB 10 543.50 kB 218,852.00 kB 11 233.00 kB 177,303.00 kB 12 1,739.50 kB 143,842.50 kB 13 3,237.50 kB 117,230.50 kB 14 463.00 kB 95,059.50 kB 15 3,008.00 kB 77,302.00 kB 16 43.00 kB 62,892.00 kB 17 21.50 kB 50,946.00 kB 18 30.00 kB 41,271.50 kB 19 194,298.00 kB 194,298.00 kB 20 72.50 kB 166,136.50 kB 21 72.50 kB 134,582.50 kB 22 347.50 kB 109,075.50 kB 23 262.00 kB 88,402.50 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 Mar 08 00 0 0 0 01 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 9.17 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-03-08 05:19:14 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 9.17 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-03-08 05:19:14 Date
Analyzes per table
Key values
- pubc.log_query (14) Main table analyzed (database ctdprd51)
- 18 analyzes Total
Vacuums per table
Key values
- pub2.term_set_enrichment_agent (1) Main table vacuumed on database ctdprd51
- 5 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pub2.term_set_enrichment_agent 1 0 114,359 0 37,617 0 0 57,122 3 3,395,011 ctdprd51.pg_catalog.pg_statistic 1 1 717 0 145 0 126 415 133 548,670 ctdprd51.pub2.term_set_enrichment 1 0 2,104 0 993 0 0 999 2 70,548 ctdprd51.pubc.log_query 1 1 186 0 19 0 0 41 16 106,024 ctdprd51.pub2.term_comp_agent 1 0 226 0 30 0 0 26 2 13,141 Total 5 2 117,592 36 38,804 0 126 58,603 156 4,133,394 Tuples removed per table
Key values
- pg_catalog.pg_statistic (592) Main table with removed tuples on database ctdprd51
- 598 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pg_catalog.pg_statistic 1 1 592 3,416 0 0 410 ctdprd51.pubc.log_query 1 1 6 307 0 0 14 ctdprd51.pub2.term_set_enrichment_agent 1 0 0 21,653,560 0 0 246,064 ctdprd51.pub2.term_set_enrichment 1 0 0 294,393 0 0 4,877 ctdprd51.pub2.term_comp_agent 1 0 0 7,270 0 0 67 Total 5 2 598 21,958,946 0 0 251,432 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pub2.term_set_enrichment_agent 1 0 0 0 ctdprd51.pg_catalog.pg_statistic 1 1 592 0 ctdprd51.pub2.term_set_enrichment 1 0 0 0 ctdprd51.pubc.log_query 1 1 6 0 ctdprd51.pub2.term_comp_agent 1 0 0 0 Total 5 2 598 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 08 00 0 0 01 0 1 03 0 2 04 1 1 05 2 6 06 0 0 07 0 1 08 1 1 09 0 1 10 0 0 11 0 1 12 0 0 13 0 0 14 0 0 15 0 1 16 0 0 17 0 0 18 0 0 19 1 1 20 0 0 21 0 0 22 0 2 23 0 0 - 9.17 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
- 18 Total read queries
- 0 Total write queries
Queries by database
Key values
- ctdprd51 Main database
- 15 Requests
- 14m6s (ctdprd51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 57 Requests
User Request type Count Duration postgres Total 1 18s679ms copy to 1 18s679ms pubc Total 1 9m14s select 1 9m14s pubeu Total 18 5m16s select 18 5m16s qaeu Total 4 25s621ms select 4 25s621ms unknown Total 57 1h35m32s copy to 52 1h33m56s others 1 6s567ms select 4 1m30s Duration by user
Key values
- 1h35m32s (unknown) Main time consuming user
User Request type Count Duration postgres Total 1 18s679ms copy to 1 18s679ms pubc Total 1 9m14s select 1 9m14s pubeu Total 18 5m16s select 18 5m16s qaeu Total 4 25s621ms select 4 25s621ms unknown Total 57 1h35m32s copy to 52 1h33m56s others 1 6s567ms select 4 1m30s Queries by host
Key values
- unknown Main host
- 81 Requests
- 1h50m48s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 18 Requests
- 9m14s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-08 21:42:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 9m14s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-03-08 00:09:16 - Database: ctdprd51 - User: pubc - Application: psql ]
2 1m10s SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;[ Date: 2026-03-08 06:02:33 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
3 1m10s SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;[ Date: 2026-03-08 06:02:41 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
4 1m10s SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;[ Date: 2026-03-08 06:02:39 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
5 1m10s SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;[ Date: 2026-03-08 06:02:35 - Bind query: yes ]
6 18s730ms SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130040') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;[ Date: 2026-03-08 14:09:08 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
7 8s890ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE '1H-IMIDAZOLE-4-ACETALDEHYDE')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;[ Date: 2026-03-08 10:07:31 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
8 7s587ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;[ Date: 2026-03-08 05:44:04 - Database: ctdprd51 - User: qaeu - Bind query: yes ]
9 7s480ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;[ Date: 2026-03-08 05:44:12 - Bind query: yes ]
10 7s399ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;[ Date: 2026-03-08 05:49:17 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
11 7s372ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;[ Date: 2026-03-08 05:49:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
12 6s567ms VACUUM ANALYZE log_query_archive;[ Date: 2026-03-08 00:09:22 ]
13 5s632ms SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;[ Date: 2026-03-08 11:32:04 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
14 5s481ms SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;[ Date: 2026-03-08 18:56:12 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
15 5s233ms SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 350;[ Date: 2026-03-08 11:32:32 - Bind query: yes ]
16 5s183ms SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;[ Date: 2026-03-08 05:43:39 - Database: ctdprd51 - User: qaeu - Bind query: yes ]
17 5s172ms SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;[ Date: 2026-03-08 11:32:02 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18 5s123ms SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;[ Date: 2026-03-08 05:48:43 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 5s19ms SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1435614' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;[ Date: 2026-03-08 07:20:54 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9m14s 1 9m14s 9m14s 9m14s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 23 1 9m14s 9m14s [ User: pubc - Total duration: 9m14s - Times executed: 1 ]
[ Application: psql - Total duration: 9m14s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-03-08 00:09:16 Duration: 9m14s Database: ctdprd51 User: pubc Application: psql
2 4m40s 4 1m10s 1m10s 1m10s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 06 4 4m40s 1m10s [ User: pubeu - Total duration: 3m30s - Times executed: 3 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:33 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:41 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:39 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
3 18s730ms 1 18s730ms 18s730ms 18s730ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 14 1 18s730ms 18s730ms [ User: pubeu - Total duration: 18s730ms - Times executed: 1 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130040') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-03-08 14:09:08 Duration: 18s730ms Database: ctdprd51 User: pubeu Bind query: yes
4 16s38ms 3 5s172ms 5s632ms 5s346ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ? offset ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 11 3 16s38ms 5s346ms [ User: pubeu - Total duration: 10s804ms - Times executed: 2 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:04 Duration: 5s632ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 350;
Date: 2026-03-08 11:32:32 Duration: 5s233ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:02 Duration: 5s172ms Database: ctdprd51 User: pubeu Bind query: yes
5 14s960ms 2 7s372ms 7s587ms 7s480ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 05 2 14s960ms 7s480ms [ User: qaeu - Total duration: 7s587ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s372ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:04 Duration: 7s587ms Database: ctdprd51 User: qaeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:09 Duration: 7s372ms Database: ctdprd51 User: pubeu Bind query: yes
6 14s880ms 2 7s399ms 7s480ms 7s440ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 05 2 14s880ms 7s440ms [ User: pubeu - Total duration: 7s399ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:12 Duration: 7s480ms Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:17 Duration: 7s399ms Database: ctdprd51 User: pubeu Bind query: yes
7 10s306ms 2 5s123ms 5s183ms 5s153ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 05 2 10s306ms 5s153ms [ User: qaeu - Total duration: 5s183ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s123ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:43:39 Duration: 5s183ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:48:43 Duration: 5s123ms Database: ctdprd51 User: pubeu Bind query: yes
8 8s890ms 1 8s890ms 8s890ms 8s890ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 10 1 8s890ms 8s890ms [ User: pubeu - Total duration: 8s890ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE '1H-IMIDAZOLE-4-ACETALDEHYDE')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 10:07:31 Duration: 8s890ms Database: ctdprd51 User: pubeu Bind query: yes
9 6s567ms 1 6s567ms 6s567ms 6s567ms vacuum analyze log_query_archive;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 23 1 6s567ms 6s567ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-03-08 00:09:22 Duration: 6s567ms
10 5s481ms 1 5s481ms 5s481ms 5s481ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 18 1 5s481ms 5s481ms [ User: pubeu - Total duration: 5s481ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-03-08 18:56:12 Duration: 5s481ms Database: ctdprd51 User: pubeu Bind query: yes
11 5s19ms 1 5s19ms 5s19ms 5s19ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 07 1 5s19ms 5s19ms [ User: pubeu - Total duration: 5s19ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1435614' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-03-08 07:20:54 Duration: 5s19ms Database: ctdprd51 User: pubeu Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4 4m40s 1m10s 1m10s 1m10s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 06 4 4m40s 1m10s [ User: pubeu - Total duration: 3m30s - Times executed: 3 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:33 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:41 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:39 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
2 3 16s38ms 5s172ms 5s632ms 5s346ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ? offset ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 11 3 16s38ms 5s346ms [ User: pubeu - Total duration: 10s804ms - Times executed: 2 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:04 Duration: 5s632ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 350;
Date: 2026-03-08 11:32:32 Duration: 5s233ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:02 Duration: 5s172ms Database: ctdprd51 User: pubeu Bind query: yes
3 2 14s960ms 7s372ms 7s587ms 7s480ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 05 2 14s960ms 7s480ms [ User: qaeu - Total duration: 7s587ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s372ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:04 Duration: 7s587ms Database: ctdprd51 User: qaeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:09 Duration: 7s372ms Database: ctdprd51 User: pubeu Bind query: yes
4 2 14s880ms 7s399ms 7s480ms 7s440ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 05 2 14s880ms 7s440ms [ User: pubeu - Total duration: 7s399ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:12 Duration: 7s480ms Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:17 Duration: 7s399ms Database: ctdprd51 User: pubeu Bind query: yes
5 2 10s306ms 5s123ms 5s183ms 5s153ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 05 2 10s306ms 5s153ms [ User: qaeu - Total duration: 5s183ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s123ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:43:39 Duration: 5s183ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:48:43 Duration: 5s123ms Database: ctdprd51 User: pubeu Bind query: yes
6 1 9m14s 9m14s 9m14s 9m14s select maint_query_logs_archive ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 23 1 9m14s 9m14s [ User: pubc - Total duration: 9m14s - Times executed: 1 ]
[ Application: psql - Total duration: 9m14s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-03-08 00:09:16 Duration: 9m14s Database: ctdprd51 User: pubc Application: psql
7 1 18s730ms 18s730ms 18s730ms 18s730ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 14 1 18s730ms 18s730ms [ User: pubeu - Total duration: 18s730ms - Times executed: 1 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130040') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-03-08 14:09:08 Duration: 18s730ms Database: ctdprd51 User: pubeu Bind query: yes
8 1 8s890ms 8s890ms 8s890ms 8s890ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 10 1 8s890ms 8s890ms [ User: pubeu - Total duration: 8s890ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE '1H-IMIDAZOLE-4-ACETALDEHYDE')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 10:07:31 Duration: 8s890ms Database: ctdprd51 User: pubeu Bind query: yes
9 1 6s567ms 6s567ms 6s567ms 6s567ms vacuum analyze log_query_archive;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 23 1 6s567ms 6s567ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-03-08 00:09:22 Duration: 6s567ms
10 1 5s481ms 5s481ms 5s481ms 5s481ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 18 1 5s481ms 5s481ms [ User: pubeu - Total duration: 5s481ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-03-08 18:56:12 Duration: 5s481ms Database: ctdprd51 User: pubeu Bind query: yes
11 1 5s19ms 5s19ms 5s19ms 5s19ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 07 1 5s19ms 5s19ms [ User: pubeu - Total duration: 5s19ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1435614' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-03-08 07:20:54 Duration: 5s19ms Database: ctdprd51 User: pubeu Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 9m14s 9m14s 9m14s 1 9m14s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 08 23 1 9m14s 9m14s [ User: pubc - Total duration: 9m14s - Times executed: 1 ]
[ Application: psql - Total duration: 9m14s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-03-08 00:09:16 Duration: 9m14s Database: ctdprd51 User: pubc Application: psql
2 1m10s 1m10s 1m10s 4 4m40s select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ? or substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ? or upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 08 06 4 4m40s 1m10s [ User: pubeu - Total duration: 3m30s - Times executed: 3 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:33 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:41 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'COPPER & AND & LIVER & INJURY & OR & HEPATIC & DAMAGE & OR & LIVER & DISEASE & OR & HEPATOTOXICITY & OR & MITOCHONDRIAL & DAMAGE & OR & OXIDATIVE & STRESS & AND & GENE_DISEASE') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'COPPER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'INJURY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATIC' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'LIVER' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DISEASE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'HEPATOTOXICITY' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'MITOCHONDRIAL' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'DAMAGE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OR' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'OXIDATIVE' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'STRESS' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'AND' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'GENE_DISEASE')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'COPPER' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'INJURY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATIC' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'LIVER' OR upper(l.acc_txt) LIKE 'DISEASE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'HEPATOTOXICITY' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'MITOCHONDRIAL' OR upper(l.acc_txt) LIKE 'DAMAGE' OR upper(l.acc_txt) LIKE 'OR' OR upper(l.acc_txt) LIKE 'OXIDATIVE' OR upper(l.acc_txt) LIKE 'STRESS' OR upper(l.acc_txt) LIKE 'AND' OR upper(l.acc_txt) LIKE 'GENE_DISEASE')) ii GROUP BY ii.cd;
Date: 2026-03-08 06:02:39 Duration: 1m10s Database: ctdprd51 User: pubeu Bind query: yes
3 18s730ms 18s730ms 18s730ms 1 18s730ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 08 14 1 18s730ms 18s730ms [ User: pubeu - Total duration: 18s730ms - Times executed: 1 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2130040') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-03-08 14:09:08 Duration: 18s730ms Database: ctdprd51 User: pubeu Bind query: yes
4 8s890ms 8s890ms 8s890ms 1 8s890ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 08 10 1 8s890ms 8s890ms [ User: pubeu - Total duration: 8s890ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE '1H-IMIDAZOLE-4-ACETALDEHYDE')) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 10:07:31 Duration: 8s890ms Database: ctdprd51 User: pubeu Bind query: yes
5 7s372ms 7s587ms 7s480ms 2 14s960ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 08 05 2 14s960ms 7s480ms [ User: qaeu - Total duration: 7s587ms - Times executed: 1 ]
[ User: pubeu - Total duration: 7s372ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:04 Duration: 7s587ms Database: ctdprd51 User: qaeu Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ZINC')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006915' AND l.type_cd = 'A' AND l.object_type_id = 5))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9606' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:09 Duration: 7s372ms Database: ctdprd51 User: pubeu Bind query: yes
6 7s399ms 7s480ms 7s440ms 2 14s880ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and ptr.term_object_type_id = ? and ptr.phenotype_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and taxonterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and baseterm.id in ( select object_id from db_link l where l.acc_txt = ? and l.type_cd = ? and l.object_type_id = ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort asc, pt.indirect_term_qty desc limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 08 05 2 14s880ms 7s440ms [ User: pubeu - Total duration: 7s399ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:44:12 Duration: 7s480ms Bind query: yes
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'ACETYLCYSTEINE')) and ptr.term_object_type_id = 2 and ptr.phenotype_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 5 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = 'GO:0006979' AND l.type_cd = 'A' AND l.object_type_id = 5))) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'CARDIOVASCULAR SYSTEM'))) and taxonTerm.id in ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 1 and baseTerm.id in ( select object_id from db_link l where l.acc_txt = '9605' AND l.type_cd = 'A' AND l.object_type_id = 1))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort asc, pt.indirect_term_qty desc LIMIT 50;
Date: 2026-03-08 05:49:17 Duration: 7s399ms Database: ctdprd51 User: pubeu Bind query: yes
7 6s567ms 6s567ms 6s567ms 1 6s567ms vacuum analyze log_query_archive;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 08 23 1 6s567ms 6s567ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-03-08 00:09:22 Duration: 6s567ms
8 5s481ms 5s481ms 5s481ms 1 5s481ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 08 18 1 5s481ms 5s481ms [ User: pubeu - Total duration: 5s481ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1450321') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-03-08 18:56:12 Duration: 5s481ms Database: ctdprd51 User: pubeu Bind query: yes
9 5s172ms 5s632ms 5s346ms 3 16s38ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ? offset ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 08 11 3 16s38ms 5s346ms [ User: pubeu - Total duration: 10s804ms - Times executed: 2 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:04 Duration: 5s632ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 350;
Date: 2026-03-08 11:32:32 Duration: 5s233ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2119969') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 300;
Date: 2026-03-08 11:32:02 Duration: 5s172ms Database: ctdprd51 User: pubeu Bind query: yes
10 5s123ms 5s183ms 5s153ms 2 10s306ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 08 05 2 10s306ms 5s153ms [ User: qaeu - Total duration: 5s183ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s123ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:43:39 Duration: 5s183ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1335246)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-03-08 05:48:43 Duration: 5s123ms Database: ctdprd51 User: pubeu Bind query: yes
11 5s19ms 5s19ms 5s19ms 1 5s19ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 08 07 1 5s19ms 5s19ms [ User: pubeu - Total duration: 5s19ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1435614' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-03-08 07:20:54 Duration: 5s19ms Database: ctdprd51 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 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 08 06 4 0ms 0ms [ User: pubeu - Total duration: 3m30s - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: ctdprd51 Remote: pubeu
-
Events
Log levels
Key values
- 7,464 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
- 0 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 14 Max number of times the same event was reported
- 14 Total events found
Rank Times reported Error 1 14 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 08 00 1 03 1 04 2 17 2 21 8