pgBadger-
Global information
- Generated on Mon Jul 20 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260719
- Parsed 49,480 log entries in 2s
- Log start from 2026-07-19 00:00:01 to 2026-07-19 23:56:52
-
Overview
Global Stats
- 14 Number of unique normalized queries
- 61 Number of queries
- 36m4s Total query duration
- 2026-07-19 00:04:33 First query
- 2026-07-19 22:11:29 Last query
- 1 queries/s at 2026-07-19 11:09:04 Query peak
- 36m4s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 36m4s Execute total duration
- 6 Number of events
- 3 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 2 Total number of automatic vacuums
- 15 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 6,127 Total number of sessions
- 54 sessions at 2026-07-19 22:53:07 Session peak
- 39d23h49m2s Total duration of sessions
- 9m23s Average duration of sessions
- 0 Average queries per session
- 353ms Average queries duration per session
- 9m23s Average idle time per session
- 6,131 Total number of connections
- 19 connections/s at 2026-07-19 22:53:18 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-19 11:09:04 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-19 11:09:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 36m4s 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) Jul 19 00 14 0ms 9m23s 1m13s 1m15s 1m57s 9m30s 01 1 0ms 6s412ms 6s412ms 0ms 0ms 6s412ms 02 17 0ms 44s891ms 31s166ms 39s441ms 1m19s 2m49s 03 6 0ms 17s295ms 16s694ms 16s208ms 16s785ms 17s295ms 04 3 0ms 25s44ms 18s412ms 0ms 0ms 50s39ms 05 1 0ms 5s620ms 5s620ms 0ms 0ms 5s620ms 06 1 0ms 5s317ms 5s317ms 0ms 0ms 5s317ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 1 0ms 5s77ms 5s77ms 0ms 0ms 5s77ms 11 11 0ms 23s872ms 14s267ms 16s557ms 17s160ms 23s872ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 2 0ms 6s480ms 6s460ms 0ms 0ms 12s921ms 14 1 0ms 3m57s 3m57s 0ms 0ms 3m57s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 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 3 0ms 5s346ms 5s255ms 0ms 0ms 15s767ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 19 00 13 0 1m18s 0ms 1m15s 9m23s 01 1 0 6s412ms 0ms 0ms 6s412ms 02 17 0 31s166ms 5s94ms 39s441ms 2m49s 03 6 0 16s694ms 0ms 16s208ms 16s840ms 04 3 0 18s412ms 0ms 0ms 50s39ms 05 1 0 5s620ms 0ms 0ms 5s620ms 06 1 0 5s317ms 0ms 0ms 5s317ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 1 0 5s77ms 0ms 0ms 5s77ms 11 11 0 14s267ms 5s179ms 16s557ms 17s412ms 12 0 0 0ms 0ms 0ms 0ms 13 2 0 6s460ms 0ms 0ms 12s921ms 14 1 0 3m57s 0ms 0ms 3m57s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 3 0 5s255ms 0ms 0ms 15s767ms 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) Jul 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 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 Jul 19 00 0 12 12.00 0.00% 01 0 1 1.00 0.00% 02 0 17 17.00 0.00% 03 0 6 6.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.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 11 11.00 0.00% 12 0 0 0.00 0.00% 13 0 2 2.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 0 0.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 3 3.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 19 00 84 0.02/s 01 79 0.02/s 02 107 0.03/s 03 149 0.04/s 04 92 0.03/s 05 90 0.03/s 06 69 0.02/s 07 74 0.02/s 08 72 0.02/s 09 75 0.02/s 10 79 0.02/s 11 169 0.05/s 12 76 0.02/s 13 72 0.02/s 14 73 0.02/s 15 77 0.02/s 16 78 0.02/s 17 78 0.02/s 18 79 0.02/s 19 78 0.02/s 20 75 0.02/s 21 71 0.02/s 22 612 0.17/s 23 3,623 1.01/s Day Hour Count Average Duration Average idle time Jul 19 00 84 28m46s 28m34s 01 79 29m6s 29m6s 02 107 23m36s 23m31s 03 149 16m27s 16m26s 04 92 26m18s 26m17s 05 90 26m36s 26m36s 06 69 32m55s 32m55s 07 74 31m57s 31m57s 08 72 34m42s 34m42s 09 75 31m53s 31m53s 10 79 31m10s 31m10s 11 167 15m17s 15m16s 12 76 31m2s 31m2s 13 72 32m14s 32m14s 14 71 30m52s 30m48s 15 77 32m21s 32m21s 16 78 31m5s 31m5s 17 78 31m6s 31m6s 18 79 31m28s 31m28s 19 78 31m27s 31m27s 20 75 30m52s 30m52s 21 71 30m32s 30m32s 22 612 4m9s 4m9s 23 3,623 39s48ms 39s48ms -
Connections
Established Connections
Key values
- 19 connections Connection Peak
- 2026-07-19 22:53:18 Date
Connections per database
Key values
- ctdprd51 Main Database
- 6,131 connections Total
Connections per user
Key values
- pubeu Main User
- 6,131 connections Total
-
Sessions
Simultaneous sessions
Key values
- 54 sessions Session Peak
- 2026-07-19 22:53:07 Date
Histogram of session times
Key values
- 2,067 0-500ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 6,127 sessions Total
Sessions per user
Key values
- pubeu Main User
- 6,127 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 6,127 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 641 buffers Checkpoint Peak
- 2026-07-19 21:45:04 Date
- 64.302 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-07-19 10:14:10 Date
Checkpoints distance
Key values
- 4.69 Mo Distance Peak
- 2026-07-19 04:44:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 19 00 322 32.457s 0.003s 32.468s 01 94 9.591s 0.002s 9.6s 02 120 12.195s 0.002s 12.203s 03 72 7.401s 0.002s 7.41s 04 385 38.769s 0.002s 38.78s 05 151 15.311s 0.002s 15.32s 06 218 22.027s 0.003s 22.037s 07 338 34.071s 0.002s 34.08s 08 306 30.839s 0.003s 30.848s 09 354 35.644s 0.002s 35.653s 10 158 15.896s 0.002s 15.942s 11 760 76.346s 0.002s 76.354s 12 55 5.681s 0.002s 5.69s 13 302 30.433s 0.002s 30.441s 14 367 36.924s 0.002s 36.933s 15 433 43.534s 0.002s 43.542s 16 325 32.635s 0.001s 32.64s 17 0 0s 0s 0s 18 393 39.52s 0.002s 39.529s 19 369 37.12s 0.002s 37.148s 20 39 4.065s 0.002s 4.075s 21 1,208 121.189s 0.002s 121.197s 22 449 45.17s 0.002s 45.178s 23 67 6.911s 0.002s 6.92s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 19 00 0 0 0 67 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 02 0 0 0 27 0.001s 0.002s 03 0 0 0 20 0.001s 0.002s 04 0 0 0 44 0.001s 0.002s 05 0 0 0 33 0.001s 0.002s 06 0 0 0 72 0.001s 0.002s 07 0 0 0 120 0.001s 0.002s 08 0 0 0 117 0.001s 0.002s 09 0 0 0 112 0.001s 0.002s 10 0 0 1 29 0.001s 0.002s 11 0 0 0 79 0.001s 0.002s 12 0 0 0 17 0.001s 0.002s 13 0 0 0 16 0.001s 0.002s 14 0 0 0 16 0.001s 0.002s 15 0 0 0 16 0.001s 0.002s 16 0 0 0 8 0.001s 0.001s 17 0 0 0 0 0s 0s 18 0 0 0 17 0.001s 0.002s 19 0 0 0 16 0.001s 0.002s 20 0 0 0 17 0.001s 0.002s 21 0 0 0 70 0.001s 0.002s 22 0 0 0 121 0.001s 0.002s 23 0 0 0 20 0.001s 0.002s Day Hour Count Avg time (sec) Jul 19 00 0 0s 01 0 0s 02 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 Jul 19 00 1,039.50 kB 15,790.00 kB 01 29.00 kB 12,795.50 kB 02 240.50 kB 10,400.50 kB 03 30.50 kB 8,439.00 kB 04 1,332.50 kB 6,982.00 kB 05 315.50 kB 5,809.50 kB 06 663.50 kB 4,811.50 kB 07 1,230.50 kB 4,119.00 kB 08 966.00 kB 3,519.00 kB 09 1,070.50 kB 3,051.00 kB 10 354.00 kB 2,581.00 kB 11 1,138.50 kB 2,277.50 kB 12 84.50 kB 1,895.50 kB 13 55.00 kB 1,547.00 kB 14 47.50 kB 1,262.00 kB 15 44.00 kB 1,030.50 kB 16 43.00 kB 885.00 kB 17 0.00 kB 0.00 kB 18 35.00 kB 760.50 kB 19 50.00 kB 627.00 kB 20 41.50 kB 514.50 kB 21 1,051.50 kB 1,403.50 kB 22 1,138.50 kB 1,436.00 kB 23 117.50 kB 1,216.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 Jul 19 00 0 0 0 01 0 0 0 02 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
- 0.01 sec Highest CPU-cost vacuum
Table pubc.log_query
Database ctdprd51 - 2026-07-19 11:19:14 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pubc.log_query
Database ctdprd51 - 2026-07-19 11:19:14 Date
Analyzes per table
Key values
- pubc.log_query (15) Main table analyzed (database ctdprd51)
- 15 analyzes Total
Vacuums per table
Key values
- pubc.log_query (2) Main table vacuumed on database ctdprd51
- 2 vacuums Total
Tuples removed per table
Key values
- pubc.log_query (46) Main table with removed tuples on database ctdprd51
- 46 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 19 00 1 0 01 0 1 02 0 1 03 0 0 04 0 2 05 0 4 06 0 1 07 0 0 08 0 1 09 0 1 10 0 2 11 1 1 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 0.01 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
- 60 Total read queries
- 0 Total write queries
Queries by database
Key values
- ctdprd51 Main database
- 54 Requests
- 33m22s (ctdprd51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 62 Requests
User Request type Count Duration postgres Total 1 20s322ms copy to 1 20s322ms pubc Total 1 9m23s select 1 9m23s pubeu Total 60 24m45s select 60 24m45s unknown Total 62 1h40m11s copy to 55 1h37m28s others 1 6s406ms select 6 2m35s Duration by user
Key values
- 1h40m11s (unknown) Main time consuming user
User Request type Count Duration postgres Total 1 20s322ms copy to 1 20s322ms pubc Total 1 9m23s select 1 9m23s pubeu Total 60 24m45s select 60 24m45s unknown Total 62 1h40m11s copy to 55 1h37m28s others 1 6s406ms select 6 2m35s Queries by host
Key values
- unknown Main host
- 124 Requests
- 2h14m40s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 60 Requests
- 26m40s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-19 15:53:52 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 43 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 9m23s /* * 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-07-19 00:09:25 - Database: ctdprd51 - User: pubc - Application: psql ]
2 3m57s 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', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 | 7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4| 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 |7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4 | 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') 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 '(12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125029)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1327-53-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327533)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(100-44-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '100447)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(94-75-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '94757)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25168-26-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25168267)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(330-54-1', $14 = '330541)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(51-28-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '51285)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7632-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7632000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(79-01-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '79016)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(93-72-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '93721)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(52-68-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '52686)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14644-61-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14644612)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-04-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298044)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7664-41-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7664417)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(75-44-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '75445)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(151-50-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '151508)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(108-24-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '108247)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(13765-19-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '13765190)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(12002-03-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12002038)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-87-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314870)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1072-35-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1072351)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1310-73-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1310732)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7720-78-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7720787)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10102-18-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10102188)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25321-22-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25321226)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(42504-46-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '42504461)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-89-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101890)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-80-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314803)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(8003-19-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '8003198)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10140-65-5', $62 = '10140655)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10415-75-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10415755)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25167-82-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25167822)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(815-82-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '815827)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(26952-23-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '26952238)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(16923-95-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '16923958)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7779-86-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7779864)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1319-72-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1319728)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-63-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101630)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14216-75-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14216752)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(55488-87-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '55488874)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOCAS_1025795' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(543-90-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '543908)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7782-50-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7782505)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(67-66-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '67663)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(115-29-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '115297)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(106-89-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '106898)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(98-01-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '98011)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(143-50-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '143500)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(91-22-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '91225)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(109-73-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '109739)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(300-76-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '300765)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '74' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327-53-3')) 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 '100-44-7' OR upper(l.acc_txt) LIKE '94-75-7' OR upper(l.acc_txt) LIKE '25168-26-7' OR upper(l.acc_txt) LIKE '330-54-1' OR upper(l.acc_txt) LIKE '51-28-5' OR upper(l.acc_txt) LIKE '7632-00-0' OR upper(l.acc_txt) LIKE '79-01-6' OR upper(l.acc_txt) LIKE '93-72-1' OR upper(l.acc_txt) LIKE '52-68-6' OR upper(l.acc_txt) LIKE '14644-61-2' OR upper(l.acc_txt) LIKE '298-04-4' OR upper(l.acc_txt) LIKE '7664-41-7' OR upper(l.acc_txt) LIKE '75-44-5' OR upper(l.acc_txt) LIKE '151-50-8' OR upper(l.acc_txt) LIKE '108-24-7' OR upper(l.acc_txt) LIKE '13765-19-0' OR upper(l.acc_txt) LIKE '12002-03-8' OR upper(l.acc_txt) LIKE '1314-87-0' OR upper(l.acc_txt) LIKE '1072-35-1' OR upper(l.acc_txt) LIKE '1310-73-2' OR upper(l.acc_txt) LIKE '7720-78-7' OR upper(l.acc_txt) LIKE '10102-18-8' OR upper(l.acc_txt) LIKE '25321-22-6' OR upper(l.acc_txt) LIKE '42504-46-1' OR upper(l.acc_txt) LIKE '10101-89-0' OR upper(l.acc_txt) LIKE '1314-80-3' OR upper(l.acc_txt) LIKE '8003-19-8' OR upper(l.acc_txt) LIKE '10140-65-5' OR upper(l.acc_txt) LIKE '10415-75-5' OR upper(l.acc_txt) LIKE '25167-82-2' OR upper(l.acc_txt) LIKE '815-82-7' OR upper(l.acc_txt) LIKE '26952-23-8' OR upper(l.acc_txt) LIKE '16923-95-8' OR upper(l.acc_txt) LIKE '7779-86-4' OR upper(l.acc_txt) LIKE '1319-72-8' OR upper(l.acc_txt) LIKE '10101-63-0' OR upper(l.acc_txt) LIKE '14216-75-2' OR upper(l.acc_txt) LIKE '55488-87-4' OR upper(l.acc_txt) LIKE 'NOCAS_1025795' OR upper(l.acc_txt) LIKE '543-90-8' OR upper(l.acc_txt) LIKE '7782-50-5' OR upper(l.acc_txt) LIKE '67-66-3' OR upper(l.acc_txt) LIKE '115-29-7' OR upper(l.acc_txt) LIKE '106-89-8' OR upper(l.acc_txt) LIKE '98-01-1' OR upper(l.acc_txt) LIKE '143-50-0' OR upper(l.acc_txt) LIKE '298-00-0' OR upper(l.acc_txt) LIKE '91-22-5' OR upper(l.acc_txt) LIKE '109-73-9' OR upper(l.acc_txt) LIKE '300-76-5' OR upper(l.acc_txt) LIKE '74' OR upper(l.acc_txt) LIKE OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;[ Date: 2026-07-19 14:34:53 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
3 44s891ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:26:16 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
4 43s284ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:25:57 - Bind query: yes ]
5 42s181ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:26:08 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
6 41s962ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:26:03 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
7 40s618ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 00:06:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
8 40s175ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:25:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
9 40s31ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:26:06 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
10 40s11ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 02:24:39 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
11 39s773ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 00:20:06 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
12 39s682ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 00:20:08 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
13 39s623ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 02:27:37 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
14 39s537ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 02:27:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
15 39s441ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 02:28:23 - Bind query: yes ]
16 39s438ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 02:25:31 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
17 39s248ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 00:20:03 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18 39s40ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;[ Date: 2026-07-19 02:24:00 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 38s937ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;[ Date: 2026-07-19 00:06:02 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
20 38s611ms SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-07-19 00:04:38 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9m59s 15 36s975ms 44s891ms 39s984ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 00 8 5m7s 38s474ms 02 7 4m51s 41s709ms [ User: pubeu - Total duration: 8m38s - Times executed: 13 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:16 Duration: 44s891ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:25:57 Duration: 43s284ms Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:08 Duration: 42s181ms Database: ctdprd51 User: pubeu Bind query: yes
2 9m23s 1 9m23s 9m23s 9m23s select maint_query_logs_archive ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 00 1 9m23s 9m23s [ User: pubc - Total duration: 9m23s - Times executed: 1 ]
[ Application: psql - Total duration: 9m23s - 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-07-19 00:09:25 Duration: 9m23s Database: ctdprd51 User: pubc Application: psql
3 4m36s 7 37s977ms 40s618ms 39s464ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 00 2 1m18s 39s297ms 02 5 3m17s 39s530ms [ User: pubeu - Total duration: 3m56s - Times executed: 6 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 00:06:09 Duration: 40s618ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:24:39 Duration: 40s11ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:27:37 Duration: 39s623ms Database: ctdprd51 User: pubeu Bind query: yes
4 4m17s 15 16s208ms 23s872ms 17s197ms 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 02 1 16s798ms 16s798ms 03 6 1m40s 16s694ms 11 8 2m21s 17s625ms [ User: pubeu - Total duration: 3m54s - Times executed: 14 ]
-
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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:09:04 Duration: 23s872ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:37:41 Duration: 17s412ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 03:45:03 Duration: 17s295ms Database: ctdprd51 User: pubeu Bind query: yes
5 3m57s 1 3m57s 3m57s 3m57s 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 ? 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 ? 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 ?, ? = ? 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 ? 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 ? 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 ? 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 ? 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 #5
Day Hour Count Duration Avg duration Jul 19 14 1 3m57s 3m57s [ User: pubeu - Total duration: 3m57s - Times executed: 1 ]
-
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', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 | 7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4| 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 |7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4 | 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') 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 '(12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125029)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1327-53-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327533)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(100-44-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '100447)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(94-75-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '94757)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25168-26-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25168267)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(330-54-1', $14 = '330541)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(51-28-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '51285)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7632-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7632000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(79-01-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '79016)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(93-72-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '93721)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(52-68-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '52686)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14644-61-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14644612)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-04-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298044)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7664-41-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7664417)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(75-44-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '75445)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(151-50-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '151508)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(108-24-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '108247)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(13765-19-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '13765190)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(12002-03-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12002038)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-87-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314870)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1072-35-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1072351)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1310-73-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1310732)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7720-78-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7720787)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10102-18-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10102188)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25321-22-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25321226)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(42504-46-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '42504461)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-89-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101890)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-80-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314803)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(8003-19-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '8003198)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10140-65-5', $62 = '10140655)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10415-75-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10415755)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25167-82-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25167822)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(815-82-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '815827)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(26952-23-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '26952238)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(16923-95-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '16923958)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7779-86-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7779864)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1319-72-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1319728)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-63-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101630)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14216-75-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14216752)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(55488-87-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '55488874)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOCAS_1025795' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(543-90-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '543908)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7782-50-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7782505)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(67-66-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '67663)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(115-29-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '115297)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(106-89-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '106898)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(98-01-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '98011)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(143-50-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '143500)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(91-22-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '91225)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(109-73-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '109739)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(300-76-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '300765)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '74' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327-53-3')) 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 '100-44-7' OR upper(l.acc_txt) LIKE '94-75-7' OR upper(l.acc_txt) LIKE '25168-26-7' OR upper(l.acc_txt) LIKE '330-54-1' OR upper(l.acc_txt) LIKE '51-28-5' OR upper(l.acc_txt) LIKE '7632-00-0' OR upper(l.acc_txt) LIKE '79-01-6' OR upper(l.acc_txt) LIKE '93-72-1' OR upper(l.acc_txt) LIKE '52-68-6' OR upper(l.acc_txt) LIKE '14644-61-2' OR upper(l.acc_txt) LIKE '298-04-4' OR upper(l.acc_txt) LIKE '7664-41-7' OR upper(l.acc_txt) LIKE '75-44-5' OR upper(l.acc_txt) LIKE '151-50-8' OR upper(l.acc_txt) LIKE '108-24-7' OR upper(l.acc_txt) LIKE '13765-19-0' OR upper(l.acc_txt) LIKE '12002-03-8' OR upper(l.acc_txt) LIKE '1314-87-0' OR upper(l.acc_txt) LIKE '1072-35-1' OR upper(l.acc_txt) LIKE '1310-73-2' OR upper(l.acc_txt) LIKE '7720-78-7' OR upper(l.acc_txt) LIKE '10102-18-8' OR upper(l.acc_txt) LIKE '25321-22-6' OR upper(l.acc_txt) LIKE '42504-46-1' OR upper(l.acc_txt) LIKE '10101-89-0' OR upper(l.acc_txt) LIKE '1314-80-3' OR upper(l.acc_txt) LIKE '8003-19-8' OR upper(l.acc_txt) LIKE '10140-65-5' OR upper(l.acc_txt) LIKE '10415-75-5' OR upper(l.acc_txt) LIKE '25167-82-2' OR upper(l.acc_txt) LIKE '815-82-7' OR upper(l.acc_txt) LIKE '26952-23-8' OR upper(l.acc_txt) LIKE '16923-95-8' OR upper(l.acc_txt) LIKE '7779-86-4' OR upper(l.acc_txt) LIKE '1319-72-8' OR upper(l.acc_txt) LIKE '10101-63-0' OR upper(l.acc_txt) LIKE '14216-75-2' OR upper(l.acc_txt) LIKE '55488-87-4' OR upper(l.acc_txt) LIKE 'NOCAS_1025795' OR upper(l.acc_txt) LIKE '543-90-8' OR upper(l.acc_txt) LIKE '7782-50-5' OR upper(l.acc_txt) LIKE '67-66-3' OR upper(l.acc_txt) LIKE '115-29-7' OR upper(l.acc_txt) LIKE '106-89-8' OR upper(l.acc_txt) LIKE '98-01-1' OR upper(l.acc_txt) LIKE '143-50-0' OR upper(l.acc_txt) LIKE '298-00-0' OR upper(l.acc_txt) LIKE '91-22-5' OR upper(l.acc_txt) LIKE '109-73-9' OR upper(l.acc_txt) LIKE '300-76-5' OR upper(l.acc_txt) LIKE '74' OR upper(l.acc_txt) LIKE OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;
Date: 2026-07-19 14:34:53 Duration: 3m57s Database: ctdprd51 User: pubeu Bind query: yes
6 1m16s 2 37s660ms 38s937ms 38s298ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.genesymbolsort, sq.gonmsort limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 00 2 1m16s 38s298ms [ User: pubeu - Total duration: 1m16s - Times executed: 2 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:02 Duration: 38s937ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:41 Duration: 37s660ms Database: ctdprd51 User: pubeu Bind query: yes
7 50s39ms 2 24s995ms 25s44ms 25s19ms 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 Jul 19 04 2 50s39ms 25s19ms [ User: pubeu - Total duration: 50s39ms - 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:35 Duration: 25s44ms 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:34 Duration: 24s995ms Database: ctdprd51 User: pubeu Bind query: yes
8 32s249ms 5 6s412ms 6s480ms 6s449ms 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 ?)) 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 ?)) ii group by ii.cd;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 01 1 6s412ms 6s412ms 02 2 12s915ms 6s457ms 13 2 12s921ms 6s460ms [ User: pubeu - Total duration: 25s792ms - Times executed: 4 ]
-
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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 13:23:40 Duration: 6s480ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:56 Duration: 6s458ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:53 Duration: 6s457ms Bind query: yes
9 26s163ms 5 5s77ms 5s346ms 5s232ms 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 #9
Day Hour Count Duration Avg duration Jul 19 06 1 5s317ms 5s317ms 10 1 5s77ms 5s77ms 22 3 15s767ms 5s255ms [ User: pubeu - Total duration: 26s163ms - Times executed: 5 ]
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:25 Duration: 5s346ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1438885' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 06:23:16 Duration: 5s317ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:28 Duration: 5s257ms Database: ctdprd51 User: pubeu Bind query: yes
10 15s837ms 3 5s179ms 5s393ms 5s279ms 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 ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 02 1 5s393ms 5s393ms 11 2 10s444ms 5s222ms [ User: pubeu - Total duration: 10s658ms - 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 02:55:15 Duration: 5s393ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:00:30 Duration: 5s264ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:01:43 Duration: 5s179ms Bind query: yes
11 11s114ms 2 5s493ms 5s620ms 5s557ms 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 #11
Day Hour Count Duration Avg duration Jul 19 05 1 5s620ms 5s620ms 11 1 5s493ms 5s493ms [ User: pubeu - Total duration: 11s114ms - Times executed: 2 ]
-
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 = 1400764)) 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-07-19 05:48:44 Duration: 5s620ms Database: ctdprd51 User: pubeu 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 = 1400764)) 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-07-19 11:19:32 Duration: 5s493ms Database: ctdprd51 User: pubeu Bind query: yes
12 6s406ms 1 6s406ms 6s406ms 6s406ms vacuum analyze log_query_archive;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 00 1 6s406ms 6s406ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-19 00:09:32 Duration: 6s406ms
13 5s198ms 1 5s198ms 5s198ms 5s198ms 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 = ?) and gd.indirect_chem_qty > ? and gd.curated_reference_qty = ? order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 04 1 5s198ms 5s198ms [ User: pubeu - Total duration: 5s198ms - 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 = '2189764') AND gd.indirect_chem_qty > 0 AND gd.curated_reference_qty = 0 ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:20:43 Duration: 5s198ms Database: ctdprd51 User: pubeu Bind query: yes
14 5s94ms 1 5s94ms 5s94ms 5s94ms select phenotypeterm.nm gonm, phenotypeterm.nm_html gonmhtml, phenotypeterm.acc_txt goacc, phenotypeterm.id goid, diseaseterm.nm diseasenm, diseaseterm.acc_txt diseaseacc, diseaseterm.acc_db_cd diseaseaccdbcd, diseaseterm.id diseaseid, via_gene_qty genenetworkcount, via_chem_qty chemnetworkcount, indirect_reference_qty referencecount, count(*) over () fullrowcount from phenotype_term pt inner join term phenotypeterm on pt.phenotype_id = phenotypeterm.id inner join term diseaseterm on pt.term_id = diseaseterm.id where phenotypeterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) and diseaseterm.object_type_id = ? order by chemnetworkcount desc, genenetworkcount desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 02 1 5s94ms 5s94ms [ User: pubeu - Total duration: 5s94ms - Times executed: 1 ]
-
SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1321052') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc;
Date: 2026-07-19 02:23:13 Duration: 5s94ms Database: ctdprd51 User: pubeu Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 15 9m59s 36s975ms 44s891ms 39s984ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 00 8 5m7s 38s474ms 02 7 4m51s 41s709ms [ User: pubeu - Total duration: 8m38s - Times executed: 13 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:16 Duration: 44s891ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:25:57 Duration: 43s284ms Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:08 Duration: 42s181ms Database: ctdprd51 User: pubeu Bind query: yes
2 15 4m17s 16s208ms 23s872ms 17s197ms 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 19 02 1 16s798ms 16s798ms 03 6 1m40s 16s694ms 11 8 2m21s 17s625ms [ User: pubeu - Total duration: 3m54s - Times executed: 14 ]
-
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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:09:04 Duration: 23s872ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:37:41 Duration: 17s412ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 03:45:03 Duration: 17s295ms Database: ctdprd51 User: pubeu Bind query: yes
3 7 4m36s 37s977ms 40s618ms 39s464ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 00 2 1m18s 39s297ms 02 5 3m17s 39s530ms [ User: pubeu - Total duration: 3m56s - Times executed: 6 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 00:06:09 Duration: 40s618ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:24:39 Duration: 40s11ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:27:37 Duration: 39s623ms Database: ctdprd51 User: pubeu Bind query: yes
4 5 32s249ms 6s412ms 6s480ms 6s449ms 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 ?)) 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 ?)) ii group by ii.cd;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 01 1 6s412ms 6s412ms 02 2 12s915ms 6s457ms 13 2 12s921ms 6s460ms [ User: pubeu - Total duration: 25s792ms - Times executed: 4 ]
-
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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 13:23:40 Duration: 6s480ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:56 Duration: 6s458ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:53 Duration: 6s457ms Bind query: yes
5 5 26s163ms 5s77ms 5s346ms 5s232ms 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 #5
Day Hour Count Duration Avg duration Jul 19 06 1 5s317ms 5s317ms 10 1 5s77ms 5s77ms 22 3 15s767ms 5s255ms [ User: pubeu - Total duration: 26s163ms - Times executed: 5 ]
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:25 Duration: 5s346ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1438885' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 06:23:16 Duration: 5s317ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:28 Duration: 5s257ms Database: ctdprd51 User: pubeu Bind query: yes
6 3 15s837ms 5s179ms 5s393ms 5s279ms 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 ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 19 02 1 5s393ms 5s393ms 11 2 10s444ms 5s222ms [ User: pubeu - Total duration: 10s658ms - 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 02:55:15 Duration: 5s393ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:00:30 Duration: 5s264ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:01:43 Duration: 5s179ms Bind query: yes
7 2 1m16s 37s660ms 38s937ms 38s298ms select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.genesymbolsort, sq.gonmsort limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 00 2 1m16s 38s298ms [ User: pubeu - Total duration: 1m16s - Times executed: 2 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:02 Duration: 38s937ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:41 Duration: 37s660ms Database: ctdprd51 User: pubeu Bind query: yes
8 2 50s39ms 24s995ms 25s44ms 25s19ms 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 #8
Day Hour Count Duration Avg duration Jul 19 04 2 50s39ms 25s19ms [ User: pubeu - Total duration: 50s39ms - 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:35 Duration: 25s44ms 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:34 Duration: 24s995ms Database: ctdprd51 User: pubeu Bind query: yes
9 2 11s114ms 5s493ms 5s620ms 5s557ms 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 #9
Day Hour Count Duration Avg duration Jul 19 05 1 5s620ms 5s620ms 11 1 5s493ms 5s493ms [ User: pubeu - Total duration: 11s114ms - Times executed: 2 ]
-
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 = 1400764)) 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-07-19 05:48:44 Duration: 5s620ms Database: ctdprd51 User: pubeu 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 = 1400764)) 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-07-19 11:19:32 Duration: 5s493ms Database: ctdprd51 User: pubeu Bind query: yes
10 1 9m23s 9m23s 9m23s 9m23s select maint_query_logs_archive ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 19 00 1 9m23s 9m23s [ User: pubc - Total duration: 9m23s - Times executed: 1 ]
[ Application: psql - Total duration: 9m23s - 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-07-19 00:09:25 Duration: 9m23s Database: ctdprd51 User: pubc Application: psql
11 1 3m57s 3m57s 3m57s 3m57s 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 ? 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 ? 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 ?, ? = ? 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 ? 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 ? 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 ? 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 ? 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 #11
Day Hour Count Duration Avg duration Jul 19 14 1 3m57s 3m57s [ User: pubeu - Total duration: 3m57s - Times executed: 1 ]
-
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', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 | 7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4| 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 |7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4 | 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') 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 '(12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125029)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1327-53-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327533)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(100-44-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '100447)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(94-75-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '94757)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25168-26-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25168267)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(330-54-1', $14 = '330541)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(51-28-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '51285)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7632-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7632000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(79-01-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '79016)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(93-72-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '93721)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(52-68-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '52686)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14644-61-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14644612)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-04-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298044)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7664-41-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7664417)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(75-44-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '75445)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(151-50-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '151508)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(108-24-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '108247)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(13765-19-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '13765190)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(12002-03-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12002038)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-87-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314870)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1072-35-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1072351)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1310-73-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1310732)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7720-78-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7720787)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10102-18-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10102188)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25321-22-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25321226)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(42504-46-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '42504461)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-89-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101890)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-80-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314803)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(8003-19-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '8003198)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10140-65-5', $62 = '10140655)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10415-75-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10415755)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25167-82-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25167822)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(815-82-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '815827)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(26952-23-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '26952238)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(16923-95-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '16923958)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7779-86-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7779864)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1319-72-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1319728)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-63-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101630)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14216-75-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14216752)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(55488-87-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '55488874)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOCAS_1025795' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(543-90-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '543908)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7782-50-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7782505)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(67-66-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '67663)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(115-29-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '115297)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(106-89-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '106898)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(98-01-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '98011)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(143-50-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '143500)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(91-22-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '91225)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(109-73-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '109739)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(300-76-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '300765)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '74' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327-53-3')) 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 '100-44-7' OR upper(l.acc_txt) LIKE '94-75-7' OR upper(l.acc_txt) LIKE '25168-26-7' OR upper(l.acc_txt) LIKE '330-54-1' OR upper(l.acc_txt) LIKE '51-28-5' OR upper(l.acc_txt) LIKE '7632-00-0' OR upper(l.acc_txt) LIKE '79-01-6' OR upper(l.acc_txt) LIKE '93-72-1' OR upper(l.acc_txt) LIKE '52-68-6' OR upper(l.acc_txt) LIKE '14644-61-2' OR upper(l.acc_txt) LIKE '298-04-4' OR upper(l.acc_txt) LIKE '7664-41-7' OR upper(l.acc_txt) LIKE '75-44-5' OR upper(l.acc_txt) LIKE '151-50-8' OR upper(l.acc_txt) LIKE '108-24-7' OR upper(l.acc_txt) LIKE '13765-19-0' OR upper(l.acc_txt) LIKE '12002-03-8' OR upper(l.acc_txt) LIKE '1314-87-0' OR upper(l.acc_txt) LIKE '1072-35-1' OR upper(l.acc_txt) LIKE '1310-73-2' OR upper(l.acc_txt) LIKE '7720-78-7' OR upper(l.acc_txt) LIKE '10102-18-8' OR upper(l.acc_txt) LIKE '25321-22-6' OR upper(l.acc_txt) LIKE '42504-46-1' OR upper(l.acc_txt) LIKE '10101-89-0' OR upper(l.acc_txt) LIKE '1314-80-3' OR upper(l.acc_txt) LIKE '8003-19-8' OR upper(l.acc_txt) LIKE '10140-65-5' OR upper(l.acc_txt) LIKE '10415-75-5' OR upper(l.acc_txt) LIKE '25167-82-2' OR upper(l.acc_txt) LIKE '815-82-7' OR upper(l.acc_txt) LIKE '26952-23-8' OR upper(l.acc_txt) LIKE '16923-95-8' OR upper(l.acc_txt) LIKE '7779-86-4' OR upper(l.acc_txt) LIKE '1319-72-8' OR upper(l.acc_txt) LIKE '10101-63-0' OR upper(l.acc_txt) LIKE '14216-75-2' OR upper(l.acc_txt) LIKE '55488-87-4' OR upper(l.acc_txt) LIKE 'NOCAS_1025795' OR upper(l.acc_txt) LIKE '543-90-8' OR upper(l.acc_txt) LIKE '7782-50-5' OR upper(l.acc_txt) LIKE '67-66-3' OR upper(l.acc_txt) LIKE '115-29-7' OR upper(l.acc_txt) LIKE '106-89-8' OR upper(l.acc_txt) LIKE '98-01-1' OR upper(l.acc_txt) LIKE '143-50-0' OR upper(l.acc_txt) LIKE '298-00-0' OR upper(l.acc_txt) LIKE '91-22-5' OR upper(l.acc_txt) LIKE '109-73-9' OR upper(l.acc_txt) LIKE '300-76-5' OR upper(l.acc_txt) LIKE '74' OR upper(l.acc_txt) LIKE OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;
Date: 2026-07-19 14:34:53 Duration: 3m57s Database: ctdprd51 User: pubeu Bind query: yes
12 1 6s406ms 6s406ms 6s406ms 6s406ms vacuum analyze log_query_archive;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 19 00 1 6s406ms 6s406ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-19 00:09:32 Duration: 6s406ms
13 1 5s198ms 5s198ms 5s198ms 5s198ms 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 = ?) and gd.indirect_chem_qty > ? and gd.curated_reference_qty = ? order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 04 1 5s198ms 5s198ms [ User: pubeu - Total duration: 5s198ms - 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 = '2189764') AND gd.indirect_chem_qty > 0 AND gd.curated_reference_qty = 0 ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:20:43 Duration: 5s198ms Database: ctdprd51 User: pubeu Bind query: yes
14 1 5s94ms 5s94ms 5s94ms 5s94ms select phenotypeterm.nm gonm, phenotypeterm.nm_html gonmhtml, phenotypeterm.acc_txt goacc, phenotypeterm.id goid, diseaseterm.nm diseasenm, diseaseterm.acc_txt diseaseacc, diseaseterm.acc_db_cd diseaseaccdbcd, diseaseterm.id diseaseid, via_gene_qty genenetworkcount, via_chem_qty chemnetworkcount, indirect_reference_qty referencecount, count(*) over () fullrowcount from phenotype_term pt inner join term phenotypeterm on pt.phenotype_id = phenotypeterm.id inner join term diseaseterm on pt.term_id = diseaseterm.id where phenotypeterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) and diseaseterm.object_type_id = ? order by chemnetworkcount desc, genenetworkcount desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 02 1 5s94ms 5s94ms [ User: pubeu - Total duration: 5s94ms - Times executed: 1 ]
-
SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1321052') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc;
Date: 2026-07-19 02:23:13 Duration: 5s94ms Database: ctdprd51 User: pubeu Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 9m23s 9m23s 9m23s 1 9m23s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 19 00 1 9m23s 9m23s [ User: pubc - Total duration: 9m23s - Times executed: 1 ]
[ Application: psql - Total duration: 9m23s - 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-07-19 00:09:25 Duration: 9m23s Database: ctdprd51 User: pubc Application: psql
2 3m57s 3m57s 3m57s 1 3m57s 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 ? 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 ? 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 ?, ? = ? 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 ? 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 ? 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 ? 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 ? 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 Jul 19 14 1 3m57s 3m57s [ User: pubeu - Total duration: 3m57s - Times executed: 1 ]
-
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', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 | 7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4| 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', '(12125-02-9 | 12125029) & (1327-53-3 | 1327533) & (100-44-7 | 100447) & (94-75-7 | 94757) & (25168-26-7 | 25168267) & (330-54-1 | 330541) & (51-28-5 | 51285) & (7632-00-0 | 7632000) & (79-01-6 | 79016) & (93-72-1 | 93721) & (52-68-6 | 52686) & (14644-61-2 | 14644612) & (298-04-4 | 298044) & (7664-41-7 | 7664417) & (75-44-5 | 75445) & (151-50-8 | 151508) & (108-24-7 | 108247) & (13765-19-0 | 13765190) & (12002-03-8 | 12002038) & (1314-87-0 | 1314870) & (1072-35-1 | 1072351) & (1310-73-2 | 1310732) & (7720-78-7 |7720787) & (10102-18-8 | 10102188) & (25321-22-6 | 25321226) & (42504-46-1 | 42504461) & (10101-89-0 | 10101890) & (1314-80-3 | 1314803) & (8003-19-8 | 8003198) & (10140-65-5 | 10140655) & (10415-75-5 | 10415755) & (25167-82-2 | 25167822) & (815-82-7 | 815827) & (26952-23-8 | 26952238) & (16923-95-8 | 16923958) & (7779-86-4 | 7779864) & (1319-72-8 | 1319728) & (10101-63-0 | 10101630) & (14216-75-2 | 14216752) & (55488-87-4 | 55488874) & NOCAS_1025795 & (543-90-8 | 543908) & (7782-50-5 | 7782505) & (67-66-3 | 67663) & (115-29-7 | 115297) & (106-89-8 | 106898) & (98-01-1 | 98011) & (143-50-0 | 143500) & (298-00-0 | 298000) & (91-22-5 | 91225) & (109-73-9 | 109739) & (300-76-5 | 300765) & 74') 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 '(12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125029)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1327-53-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327533)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(100-44-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '100447)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(94-75-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '94757)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25168-26-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25168267)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(330-54-1', $14 = '330541)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(51-28-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '51285)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7632-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7632000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(79-01-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '79016)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(93-72-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '93721)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(52-68-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '52686)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14644-61-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14644612)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-04-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298044)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7664-41-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7664417)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(75-44-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '75445)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(151-50-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '151508)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(108-24-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '108247)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(13765-19-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '13765190)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(12002-03-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12002038)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-87-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314870)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1072-35-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1072351)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1310-73-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1310732)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7720-78-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7720787)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10102-18-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10102188)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25321-22-6' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25321226)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(42504-46-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '42504461)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-89-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101890)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1314-80-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1314803)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(8003-19-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '8003198)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10140-65-5', $62 = '10140655)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10415-75-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10415755)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(25167-82-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '25167822)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(815-82-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '815827)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(26952-23-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '26952238)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(16923-95-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '16923958)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7779-86-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7779864)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(1319-72-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1319728)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(10101-63-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '10101630)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(14216-75-2' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '14216752)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(55488-87-4' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '55488874)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'NOCAS_1025795' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(543-90-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '543908)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(7782-50-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '7782505)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(67-66-3' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '67663)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(115-29-7' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '115297)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(106-89-8' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '106898)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(98-01-1' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '98011)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(143-50-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '143500)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(298-00-0' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '298000)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(91-22-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '91225)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(109-73-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '109739)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '(300-76-5' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '300765)' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '74' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '12125-02-9' OR SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE '1327-53-3')) 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 '100-44-7' OR upper(l.acc_txt) LIKE '94-75-7' OR upper(l.acc_txt) LIKE '25168-26-7' OR upper(l.acc_txt) LIKE '330-54-1' OR upper(l.acc_txt) LIKE '51-28-5' OR upper(l.acc_txt) LIKE '7632-00-0' OR upper(l.acc_txt) LIKE '79-01-6' OR upper(l.acc_txt) LIKE '93-72-1' OR upper(l.acc_txt) LIKE '52-68-6' OR upper(l.acc_txt) LIKE '14644-61-2' OR upper(l.acc_txt) LIKE '298-04-4' OR upper(l.acc_txt) LIKE '7664-41-7' OR upper(l.acc_txt) LIKE '75-44-5' OR upper(l.acc_txt) LIKE '151-50-8' OR upper(l.acc_txt) LIKE '108-24-7' OR upper(l.acc_txt) LIKE '13765-19-0' OR upper(l.acc_txt) LIKE '12002-03-8' OR upper(l.acc_txt) LIKE '1314-87-0' OR upper(l.acc_txt) LIKE '1072-35-1' OR upper(l.acc_txt) LIKE '1310-73-2' OR upper(l.acc_txt) LIKE '7720-78-7' OR upper(l.acc_txt) LIKE '10102-18-8' OR upper(l.acc_txt) LIKE '25321-22-6' OR upper(l.acc_txt) LIKE '42504-46-1' OR upper(l.acc_txt) LIKE '10101-89-0' OR upper(l.acc_txt) LIKE '1314-80-3' OR upper(l.acc_txt) LIKE '8003-19-8' OR upper(l.acc_txt) LIKE '10140-65-5' OR upper(l.acc_txt) LIKE '10415-75-5' OR upper(l.acc_txt) LIKE '25167-82-2' OR upper(l.acc_txt) LIKE '815-82-7' OR upper(l.acc_txt) LIKE '26952-23-8' OR upper(l.acc_txt) LIKE '16923-95-8' OR upper(l.acc_txt) LIKE '7779-86-4' OR upper(l.acc_txt) LIKE '1319-72-8' OR upper(l.acc_txt) LIKE '10101-63-0' OR upper(l.acc_txt) LIKE '14216-75-2' OR upper(l.acc_txt) LIKE '55488-87-4' OR upper(l.acc_txt) LIKE 'NOCAS_1025795' OR upper(l.acc_txt) LIKE '543-90-8' OR upper(l.acc_txt) LIKE '7782-50-5' OR upper(l.acc_txt) LIKE '67-66-3' OR upper(l.acc_txt) LIKE '115-29-7' OR upper(l.acc_txt) LIKE '106-89-8' OR upper(l.acc_txt) LIKE '98-01-1' OR upper(l.acc_txt) LIKE '143-50-0' OR upper(l.acc_txt) LIKE '298-00-0' OR upper(l.acc_txt) LIKE '91-22-5' OR upper(l.acc_txt) LIKE '109-73-9' OR upper(l.acc_txt) LIKE '300-76-5' OR upper(l.acc_txt) LIKE '74' OR upper(l.acc_txt) LIKE OR upper(l.acc_txt) LIKE)) ii GROUP BY ii.cd;
Date: 2026-07-19 14:34:53 Duration: 3m57s Database: ctdprd51 User: pubeu Bind query: yes
3 36s975ms 44s891ms 39s984ms 15 9m59s select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 19 00 8 5m7s 38s474ms 02 7 4m51s 41s709ms [ User: pubeu - Total duration: 8m38s - Times executed: 13 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:16 Duration: 44s891ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:25:57 Duration: 43s284ms Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-07-19 02:26:08 Duration: 42s181ms Database: ctdprd51 User: pubeu Bind query: yes
4 37s977ms 40s618ms 39s464ms 7 4m36s select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.gonmsort, sq.genesymbolsort;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 19 00 2 1m18s 39s297ms 02 5 3m17s 39s530ms [ User: pubeu - Total duration: 3m56s - Times executed: 6 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 00:06:09 Duration: 40s618ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:24:39 Duration: 40s11ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort;
Date: 2026-07-19 02:27:37 Duration: 39s623ms Database: ctdprd51 User: pubeu Bind query: yes
5 37s660ms 38s937ms 38s298ms 2 1m16s select sq.*, count(*) over () fullrowcount from ( select distinct gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid from dag_node gt inner join gene_go_annot gga on gt.object_id = gga.go_term_id inner join term g on gga.gene_id = g.id where gt.id in ( select p.descendant_dag_node_id from dag_path p where p.ancestor_object_id = ?) and gga.is_not = false) sq order by sq.genesymbolsort, sq.gonmsort limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 19 00 2 1m16s 38s298ms [ User: pubeu - Total duration: 1m16s - Times executed: 2 ]
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:02 Duration: 38s937ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GoGenesDAO */ sq.*, COUNT(*) OVER () fullRowCount FROM ( SELECT DISTINCT gt.nm gonm, gt.nm_html gonmhtml, gt.nm_sort gonmsort, gt.acc_txt goacc, gt.object_id goid, g.nm genesymbol, g.nm_sort genesymbolsort, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid FROM dag_node gt INNER JOIN gene_go_annot gga ON gt.object_id = gga.go_term_id INNER JOIN term g ON gga.gene_id = g.id WHERE gt.id IN ( SELECT p.descendant_dag_node_id FROM dag_path p WHERE p.ancestor_object_id = '1321052') AND gga.is_not = false) sq ORDER BY sq.genesymbolsort, sq.gonmsort LIMIT 50;
Date: 2026-07-19 00:06:41 Duration: 37s660ms Database: ctdprd51 User: pubeu Bind query: yes
6 24s995ms 25s44ms 25s19ms 2 50s39ms 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 #6
Day Hour Count Duration Avg duration Jul 19 04 2 50s39ms 25s19ms [ User: pubeu - Total duration: 50s39ms - 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:35 Duration: 25s44ms 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 = '2201144') ORDER BY g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:42:34 Duration: 24s995ms Database: ctdprd51 User: pubeu Bind query: yes
7 16s208ms 23s872ms 17s197ms 15 4m17s 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;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 19 02 1 16s798ms 16s798ms 03 6 1m40s 16s694ms 11 8 2m21s 17s625ms [ User: pubeu - Total duration: 3m54s - Times executed: 14 ]
-
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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:09:04 Duration: 23s872ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 11:37:41 Duration: 17s412ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-19 03:45:03 Duration: 17s295ms Database: ctdprd51 User: pubeu Bind query: yes
8 6s412ms 6s480ms 6s449ms 5 32s249ms 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 ?)) 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 ?)) ii group by ii.cd;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 19 01 1 6s412ms 6s412ms 02 2 12s915ms 6s457ms 13 2 12s921ms 6s460ms [ User: pubeu - Total duration: 25s792ms - Times executed: 4 ]
-
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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 13:23:40 Duration: 6s480ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:56 Duration: 6s458ms 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', 'CTD_CHEMICALS_DISEASES.CSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEMICALS_DISEASES.CSV.GZ') 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) 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 'CTD_CHEMICALS_DISEASES.CSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-07-19 02:29:53 Duration: 6s457ms Bind query: yes
9 6s406ms 6s406ms 6s406ms 1 6s406ms vacuum analyze log_query_archive;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 19 00 1 6s406ms 6s406ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-19 00:09:32 Duration: 6s406ms
10 5s493ms 5s620ms 5s557ms 2 11s114ms 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 Jul 19 05 1 5s620ms 5s620ms 11 1 5s493ms 5s493ms [ User: pubeu - Total duration: 11s114ms - Times executed: 2 ]
-
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 = 1400764)) 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-07-19 05:48:44 Duration: 5s620ms Database: ctdprd51 User: pubeu 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 = 1400764)) 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-07-19 11:19:32 Duration: 5s493ms Database: ctdprd51 User: pubeu Bind query: yes
11 5s179ms 5s393ms 5s279ms 3 15s837ms 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 ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 19 02 1 5s393ms 5s393ms 11 2 10s444ms 5s222ms [ User: pubeu - Total duration: 10s658ms - 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 02:55:15 Duration: 5s393ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:00:30 Duration: 5s264ms 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 = '2196372') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 11:01:43 Duration: 5s179ms Bind query: yes
12 5s77ms 5s346ms 5s232ms 5 26s163ms 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 #12
Day Hour Count Duration Avg duration Jul 19 06 1 5s317ms 5s317ms 10 1 5s77ms 5s77ms 22 3 15s767ms 5s255ms [ User: pubeu - Total duration: 26s163ms - Times executed: 5 ]
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:25 Duration: 5s346ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1438885' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 06:23:16 Duration: 5s317ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1412352' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-19 22:11:28 Duration: 5s257ms Database: ctdprd51 User: pubeu Bind query: yes
13 5s198ms 5s198ms 5s198ms 1 5s198ms 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 = ?) and gd.indirect_chem_qty > ? and gd.curated_reference_qty = ? order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 19 04 1 5s198ms 5s198ms [ User: pubeu - Total duration: 5s198ms - 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 = '2189764') AND gd.indirect_chem_qty > 0 AND gd.curated_reference_qty = 0 ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-07-19 04:20:43 Duration: 5s198ms Database: ctdprd51 User: pubeu Bind query: yes
14 5s94ms 5s94ms 5s94ms 1 5s94ms select phenotypeterm.nm gonm, phenotypeterm.nm_html gonmhtml, phenotypeterm.acc_txt goacc, phenotypeterm.id goid, diseaseterm.nm diseasenm, diseaseterm.acc_txt diseaseacc, diseaseterm.acc_db_cd diseaseaccdbcd, diseaseterm.id diseaseid, via_gene_qty genenetworkcount, via_chem_qty chemnetworkcount, indirect_reference_qty referencecount, count(*) over () fullrowcount from phenotype_term pt inner join term phenotypeterm on pt.phenotype_id = phenotypeterm.id inner join term diseaseterm on pt.term_id = diseaseterm.id where phenotypeterm.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) and diseaseterm.object_type_id = ? order by chemnetworkcount desc, genenetworkcount desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 19 02 1 5s94ms 5s94ms [ User: pubeu - Total duration: 5s94ms - Times executed: 1 ]
-
SELECT /* GoDiseasesDAO */ phenotypeTerm.nm goNm, phenotypeTerm.nm_html goNmHTML, phenotypeTerm.acc_txt goAcc, phenotypeTerm.id goId, diseaseTerm.nm diseaseNm, diseaseTerm.acc_txt diseaseAcc, diseaseTerm.acc_db_cd diseaseAccDBCd, diseaseTerm.id diseaseId, via_gene_qty geneNetworkCount, via_chem_qty chemNetworkCount, indirect_reference_qty referenceCount, COUNT(*) OVER () fullRowCount FROM phenotype_term pt inner join term phenotypeTerm on pt.phenotype_id = phenotypeTerm.id inner join term diseaseTerm on pt.term_id = diseaseTerm.id WHERE phenotypeTerm.id IN ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = '1321052') and diseaseTerm.object_type_id = 3 ORDER BY chemNetworkCount desc, geneNetworkCount desc;
Date: 2026-07-19 02:23:13 Duration: 5s94ms 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 1 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 19 14 1 0ms 0ms [ User: pubeu - Total duration: 3m57s - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: ctdprd51 Remote: pubeu
-
Events
Log levels
Key values
- 24,757 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
- 3 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 6 Total events found
Rank Times reported Error 1 3 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 19 11 3 2 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 19 11 1 13 1 - ERROR: syntax error at or near "group" at character 231
- ERROR: syntax error at or near "group" at character 275
Statement: select * --select max(query_tm) from log_query -- from log_query_archive where query_tm >= '20260515' -- and query_tm < '20251129' --and remote_addr = '58.247.218.239' and remote_addr = '218.15.194.182' order by query_tm desc group by remote_addr
Date: 2026-07-19 11:35:01
Statement: select * --select max(query_tm) from log_query -- from log_query_archive where query_tm >= '20260515' -- and query_tm < '20251129' --and remote_addr = '58.247.218.239' --and remote_addr = '218.15.194.182' --order by query_tm desc order by execution_ms, results_qty desc group by remote_addr
Date: 2026-07-19 13:24:07
3 1 ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 19 11 1 - ERROR: column "log_query.basic_query_txt" must appear in the GROUP BY clause or be used in an aggregate function at character 17
Statement: select distinct(basic_query_txt) --select * --select max(query_tm) from log_query -- from log_query_archive where query_tm >= '20260515' -- and query_tm < '20251129' and remote_addr = '58.247.218.239' --and remote_addr = '87.65.155.53' --order by query_tm desc group by remote_addr
Date: 2026-07-19 11:30:00 Database: ctdprd51 Application: pgAdmin 4 - CONN:6886256 User: pubc Remote: