pgBadger-
Global information
- Generated on Fri Sep 4 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260903
- Parsed 15,818 log entries in 2s
- Log start from 2026-09-03 00:00:01 to 2026-09-03 23:59:47
-
Overview
Global Stats
- 22 Number of unique normalized queries
- 64 Number of queries
- 53m45s Total query duration
- 2026-09-03 00:09:21 First query
- 2026-09-03 23:44:29 Last query
- 1 queries/s at 2026-09-03 10:07:18 Query peak
- 53m45s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 53m45s Execute total duration
- 32 Number of events
- 9 Number of unique normalized events
- 19 Max number of times the same event was reported
- 0 Number of cancellation
- 4 Total number of automatic vacuums
- 20 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,911 Total number of sessions
- 52 sessions at 2026-09-03 00:01:41 Session peak
- 40d15h26m20s Total duration of sessions
- 30m37s Average duration of sessions
- 0 Average queries per session
- 1s687ms Average queries duration per session
- 30m35s Average idle time per session
- 1,911 Total number of connections
- 9 connections/s at 2026-09-03 05:40:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-03 10:07:18 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-03 07:19:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-03 10:07:18 Date
Queries duration
Key values
- 53m45s 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) Sep 03 00 2 0ms 9m19s 4m42s 0ms 0ms 9m25s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 1 0ms 5s207ms 5s207ms 0ms 0ms 5s207ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s970ms 5s870ms 0ms 0ms 5s970ms 06 10 0ms 10m59s 1m28s 39s307ms 1m52s 10m59s 07 1 0ms 8s110ms 8s110ms 0ms 0ms 8s110ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 13 0ms 1m52s 45s770ms 1m26s 1m37s 1m52s 11 1 0ms 1m30s 1m30s 0ms 0ms 1m30s 12 1 0ms 1m27s 1m27s 0ms 0ms 1m27s 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 14 0ms 1m52s 41s764ms 1m21s 1m33s 1m52s 15 1 0ms 1m35s 1m35s 0ms 0ms 1m35s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 2 0ms 5s816ms 5s784ms 0ms 5s752ms 5s816ms 18 14 0ms 1m52s 17s965ms 11s399ms 48s927ms 1m58s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 1 0ms 27s661ms 27s661ms 0ms 0ms 27s661ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 1 0ms 10s232ms 10s232ms 0ms 0ms 10s232ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 03 00 1 0 9m19s 0ms 0ms 9m19s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 5s207ms 0ms 0ms 5s207ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s870ms 0ms 0ms 5s970ms 06 1 9 1m28s 0ms 39s307ms 10m59s 07 1 0 8s110ms 0ms 0ms 8s110ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 4 9 45s770ms 0ms 1m26s 1m52s 11 1 0 1m30s 0ms 0ms 1m30s 12 1 0 1m27s 0ms 0ms 1m27s 13 0 0 0ms 0ms 0ms 0ms 14 5 9 41s764ms 5s173ms 1m21s 1m52s 15 1 0 1m35s 0ms 0ms 1m35s 16 0 0 0ms 0ms 0ms 0ms 17 2 0 5s784ms 0ms 0ms 5s816ms 18 5 9 17s965ms 0ms 11s527ms 1m52s 19 0 0 0ms 0ms 0ms 0ms 20 1 0 27s661ms 0ms 0ms 27s661ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 0 10s232ms 0ms 0ms 10s232ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 03 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 Sep 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 4 4.00 0.00% 11 0 1 1.00 0.00% 12 0 1 1.00 0.00% 13 0 0 0.00 0.00% 14 0 5 5.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 2 2.00 0.00% 18 0 5 5.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Sep 03 00 76 0.02/s 01 80 0.02/s 02 77 0.02/s 03 80 0.02/s 04 73 0.02/s 05 110 0.03/s 06 78 0.02/s 07 74 0.02/s 08 74 0.02/s 09 78 0.02/s 10 85 0.02/s 11 78 0.02/s 12 75 0.02/s 13 77 0.02/s 14 87 0.02/s 15 82 0.02/s 16 82 0.02/s 17 76 0.02/s 18 78 0.02/s 19 77 0.02/s 20 78 0.02/s 21 76 0.02/s 22 77 0.02/s 23 83 0.02/s Day Hour Count Average Duration Average idle time Sep 03 00 76 31m4s 30m57s 01 80 31m8s 31m8s 02 77 31m34s 31m34s 03 80 29m40s 29m40s 04 73 31m23s 31m23s 05 109 22m13s 22m12s 06 79 29m25s 29m14s 07 74 32m19s 32m19s 08 74 32m36s 32m36s 09 78 31m5s 31m5s 10 85 28m26s 28m19s 11 77 30m36s 30m34s 12 75 30m51s 30m50s 13 76 31m13s 31m13s 14 87 28m43s 28m37s 15 81 31m11s 31m10s 16 82 29m1s 29m1s 17 78 34m45s 34m45s 18 79 37m29s 37m26s 19 77 31m13s 31m13s 20 78 31m13s 31m13s 21 76 31m1s 31m1s 22 77 30m28s 30m28s 23 83 30m17s 30m17s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-09-03 05:40:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,911 connections Total
Connections per user
Key values
- pubeu Main User
- 1,911 connections Total
-
Sessions
Simultaneous sessions
Key values
- 52 sessions Session Peak
- 2026-09-03 00:01:41 Date
Histogram of session times
Key values
- 1,762 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,911 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,911 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,911 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 58,841 buffers Checkpoint Peak
- 2026-09-03 14:56:34 Date
- 1619.674 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-09-03 04:59:58 Date
Checkpoints distance
Key values
- 1,184.71 Mo Distance Peak
- 2026-09-03 14:56:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 03 00 700 70.297s 0.003s 70.308s 01 457 45.955s 0.002s 45.963s 02 282 28.336s 0.001s 28.34s 03 786 78.991s 0.003s 79.005s 04 415 41.746s 0.002s 41.756s 05 158 15.914s 0.001s 15.919s 06 588 59.103s 0.003s 59.162s 07 359 36.166s 0.002s 36.175s 08 280 28.224s 0.002s 28.234s 09 2,523 252.782s 0.002s 252.834s 10 454 45.662s 0.002s 45.67s 11 62 6.376s 0.002s 6.385s 12 775 77.795s 0.003s 77.848s 13 126 12.806s 0.002s 12.816s 14 58,933 1,628.972s 0.002s 1,629.081s 15 153 15.43s 0.001s 15.434s 16 72 7.374s 0.002s 7.383s 17 2,087 209.192s 0.002s 209.247s 18 179 18.116s 0.002s 18.126s 19 25 2.688s 0.002s 2.697s 20 60 6.169s 0.002s 6.178s 21 165 16.689s 0.002s 16.698s 22 210 21.199s 0.002s 21.208s 23 216 21.814s 0.002s 21.824s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 03 00 0 0 0 63 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 02 0 0 0 17 0.001s 0.001s 03 0 0 0 55 0.001s 0.003s 04 0 0 0 35 0.001s 0.002s 05 0 0 0 11 0.001s 0.001s 06 0 1 0 143 0.001s 0.003s 07 0 0 0 123 0.001s 0.002s 08 0 0 0 107 0.001s 0.002s 09 0 1 0 122 0.001s 0.002s 10 0 0 0 114 0.001s 0.002s 11 0 0 0 20 0.001s 0.002s 12 0 1 0 42 0.001s 0.002s 13 0 0 0 27 0.001s 0.002s 14 0 37 0 87 0.001s 0.002s 15 0 0 0 57 0.001s 0.001s 16 0 0 0 22 0.001s 0.002s 17 0 1 0 120 0.001s 0.002s 18 0 0 0 70 0.001s 0.002s 19 0 0 0 16 0.001s 0.002s 20 0 0 0 19 0.001s 0.002s 21 0 0 0 20 0.001s 0.002s 22 0 0 0 30 0.001s 0.002s 23 0 0 0 20 0.001s 0.002s Day Hour Count Avg time (sec) Sep 03 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 Sep 03 00 1,239.00 kB 11,490.50 kB 01 147.00 kB 9,335.50 kB 02 309.00 kB 7,992.00 kB 03 308.33 kB 6,557.33 kB 04 335.50 kB 5,101.00 kB 05 92.00 kB 4,374.00 kB 06 881.33 kB 3,726.67 kB 07 1,043.50 kB 3,078.50 kB 08 718.00 kB 2,657.50 kB 09 12,246.50 kB 22,119.00 kB 10 1,202.00 kB 18,157.00 kB 11 87.00 kB 14,765.50 kB 12 3,141.50 kB 12,535.50 kB 13 247.50 kB 10,207.50 kB 14 303,530.50 kB 576,267.50 kB 15 834.00 kB 491,450.00 kB 16 112.50 kB 420,206.50 kB 17 9,820.50 kB 342,190.00 kB 18 432.00 kB 277,301.50 kB 19 29.00 kB 224,621.00 kB 20 51.50 kB 181,951.50 kB 21 137.00 kB 147,401.50 kB 22 348.00 kB 119,461.00 kB 23 90.50 kB 96,785.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 03 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
- 1.55 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-09-03 14:10:23 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 1.55 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-09-03 14:10:23 Date
Analyzes per table
Key values
- pubc.log_query (17) Main table analyzed (database ctdprd51)
- 20 analyzes Total
Vacuums per table
Key values
- pubc.log_query (2) Main table vacuumed on database ctdprd51
- 4 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples ctdprd51.pubc.log_query 2 2 561 0 105 0 0 195 80 548,776 0 0 ctdprd51.pub2.term_set_enrichment_agent 1 0 50,711 0 4,279 0 0 25,317 3 1,514,071 0 0 ctdprd51.pub2.term_set_enrichment 1 0 1,030 0 151 0 0 476 1 36,503 0 0 Total 4 2 52,302 3 4,535 0 0 25,988 84 2,099,350 0 0 Vacuum throughput per table
Key values
- pub2.term_set_enrichment_agent (1.55) Max CPU elapsed for vacuum on database ctdprd51
- unknown (0 ms) Max I/O read time for vacuum on database ctdprd51
- unknown (0 ms) Max I/O write time for vacuum on database ctdprd51
Tuples removed per table
Key values
- pubc.log_query (15) Main table with removed tuples on database ctdprd51
- 15 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 Sep 03 00 0 0 01 0 1 02 0 2 03 0 1 04 0 2 05 1 4 06 0 1 07 0 1 08 0 0 09 0 1 10 0 1 11 0 0 12 0 1 13 0 1 14 3 2 15 0 1 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 - 1.55 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
- 27 Total read queries
- 36 Total write queries
Queries by database
Key values
- ctdprd51 Main database
- 32 Requests
- 47m23s (ctdprd51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 62 Requests
User Request type Count Duration load Total 11 16m41s select 11 16m41s postgres Total 16 17m43s copy to 16 17m43s pubc Total 1 9m19s select 1 9m19s pubeu Total 23 20m2s cte 4 4m25s select 19 15m37s qaeu Total 2 11s826ms select 2 11s826ms unknown Total 62 12m35s copy to 56 11m56s others 1 6s336ms select 5 32s958ms Duration by user
Key values
- 20m2s (pubeu) Main time consuming user
User Request type Count Duration load Total 11 16m41s select 11 16m41s postgres Total 16 17m43s copy to 16 17m43s pubc Total 1 9m19s select 1 9m19s pubeu Total 23 20m2s cte 4 4m25s select 19 15m37s qaeu Total 2 11s826ms select 2 11s826ms unknown Total 62 12m35s copy to 56 11m56s others 1 6s336ms select 5 32s958ms Queries by host
Key values
- unknown Main host
- 115 Requests
- 1h16m34s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 55 Requests
- 35m34s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-03 06:40:08 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 39 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 10m59s SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id LIMIT 50;[ Date: 2026-09-03 06:05:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
2 9m19s /* * 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-09-03 00:09:21 - Database: ctdprd51 - User: pubc - Application: psql ]
3 1m52s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 18:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
4 1m52s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 14:06:55 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
5 1m52s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 10:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
6 1m52s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 06:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
7 1m39s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 10:47:49 - Database: ctdprd51 - User: load - Bind query: yes ]
8 1m37s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 10:45:11 - Database: ctdprd51 - User: load - Bind query: yes ]
9 1m35s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-03 15:10:05 - Database: ctdprd51 - User: load - Bind query: yes ]
10 1m34s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-03 14:57:17 - Database: ctdprd51 - User: load - Bind query: yes ]
11 1m33s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-03 14:53:56 - Database: ctdprd51 - User: load - Bind query: yes ]
12 1m30s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 11:14:04 - Database: ctdprd51 - User: load - Bind query: yes ]
13 1m28s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 10:57:27 - Database: ctdprd51 - User: load - Bind query: yes ]
14 1m27s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 12:52:23 - Database: ctdprd51 - User: load - Bind query: yes ]
15 1m26s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;[ Date: 2026-09-03 14:27:06 - Database: ctdprd51 - User: load - Bind query: yes ]
16 1m26s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-03 10:42:42 - Database: ctdprd51 - User: load - Bind query: yes ]
17 1m21s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-03 14:43:35 - Database: ctdprd51 - User: load - Bind query: yes ]
18 27s661ms 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 = '1325014') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;[ Date: 2026-09-03 20:57:33 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 24s367ms COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 18:07:19 ]
20 24s176ms COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-09-03 14:07:19 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m59s 1 10m59s 10m59s 10m59s select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.taxon_id = any (array ( select dp.descendant_object_id from dag_path dp inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 06 1 10m59s 10m59s [ User: pubeu - Total duration: 10m59s - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id LIMIT 50;
Date: 2026-09-03 06:05:09 Duration: 10m59s Database: ctdprd51 User: pubeu Bind query: yes
2 9m19s 1 9m19s 9m19s 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - 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-09-03 00:09:21 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
3 9m10s 6 1m26s 1m39s 1m31s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id # ? where ? = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 10 3 4m46s 1m35s 11 1 1m30s 1m30s 12 1 1m27s 1m27s 14 1 1m26s 1m26s [ User: load - Total duration: 9m10s - Times executed: 6 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:47:49 Duration: 1m39s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:45:11 Duration: 1m37s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 11:14:04 Duration: 1m30s Database: ctdprd51 User: load Bind query: yes
4 7m31s 5 1m21s 1m35s 1m30s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 10 1 1m26s 1m26s 14 3 4m29s 1m29s 15 1 1m35s 1m35s [ User: load - Total duration: 7m31s - Times executed: 5 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 15:10:05 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:57:17 Duration: 1m34s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:53:56 Duration: 1m33s Database: ctdprd51 User: load Bind query: yes
5 7m30s 4 1m52s 1m52s 1m52s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:06:55 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
6 1m36s 4 23s974ms 24s367ms 24s168ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 03 06 1 23s974ms 23s974ms 10 1 24s157ms 24s157ms 14 1 24s176ms 24s176ms 18 1 24s367ms 24s367ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:07:19 Duration: 24s367ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:07:19 Duration: 24s176ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:07:18 Duration: 24s157ms
7 1m21s 4 20s116ms 20s632ms 20s291ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 06 1 20s632ms 20s632ms 10 1 20s175ms 20s175ms 14 1 20s116ms 20s116ms 18 1 20s241ms 20s241ms [ User: postgres - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:22 Duration: 20s632ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:21 Duration: 20s241ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:22 Duration: 20s175ms Database: ctdprd51 User: postgres Application: pg_dump
8 1m1s 4 15s332ms 15s465ms 15s405ms copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 06 1 15s332ms 15s332ms 10 1 15s406ms 15s406ms 14 1 15s465ms 15s465ms 18 1 15s419ms 15s419ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 14:07:34 Duration: 15s465ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 18:07:34 Duration: 15s419ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 10:07:34 Duration: 15s406ms
9 1m 4 14s921ms 15s316ms 15s34ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 06 1 14s929ms 14s929ms 10 1 14s972ms 14s972ms 14 1 15s316ms 15s316ms 18 1 14s921ms 14s921ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:53 Duration: 15s316ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:53 Duration: 14s972ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:54 Duration: 14s929ms
10 58s385ms 4 14s497ms 14s721ms 14s596ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 06 1 14s497ms 14s497ms 10 1 14s635ms 14s635ms 14 1 14s721ms 14s721ms 18 1 14s531ms 14s531ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:08 Duration: 14s721ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:08 Duration: 14s635ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:01:07 Duration: 14s531ms
11 30s488ms 4 7s555ms 7s674ms 7s622ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 06 1 7s655ms 7s655ms 10 1 7s602ms 7s602ms 14 1 7s674ms 7s674ms 18 1 7s555ms 7s555ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:31 Duration: 7s674ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:32 Duration: 7s655ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:32 Duration: 7s602ms
12 27s661ms 1 27s661ms 27s661ms 27s661ms 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 #12
Day Hour Count Duration Avg duration Sep 03 20 1 27s661ms 27s661ms [ User: pubeu - Total duration: 27s661ms - Times executed: 1 ]
-
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 = '1325014') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-09-03 20:57:33 Duration: 27s661ms Database: ctdprd51 User: pubeu Bind query: yes
13 26s111ms 4 6s485ms 6s647ms 6s527ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 06 1 6s488ms 6s488ms 10 1 6s490ms 6s490ms 14 1 6s647ms 6s647ms 18 1 6s485ms 6s485ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:16 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:16 Duration: 6s490ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:01:17 Duration: 6s488ms
14 24s948ms 4 6s202ms 6s324ms 6s237ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 03 06 1 6s202ms 6s202ms 10 1 6s212ms 6s212ms 14 1 6s324ms 6s324ms 18 1 6s209ms 6s209ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:38 Duration: 6s324ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:38 Duration: 6s212ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:38 Duration: 6s209ms
15 23s211ms 4 5s719ms 5s867ms 5s802ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 17 1 5s816ms 5s816ms 18 3 17s394ms 5s798ms [ User: pubeu - Total duration: 17s491ms - Times executed: 3 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:06:59 Duration: 5s867ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 17:01:30 Duration: 5s816ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:07:00 Duration: 5s807ms Database: ctdprd51 User: pubeu Bind query: yes
16 17s151ms 3 5s675ms 5s752ms 5s717ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 17 1 5s752ms 5s752ms 18 2 11s399ms 5s699ms [ User: pubeu - Total duration: 5s752ms - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 17:03:11 Duration: 5s752ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:28 Duration: 5s723ms Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:53 Duration: 5s675ms Bind query: yes
17 11s741ms 2 5s771ms 5s970ms 5s870ms 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 #17
Day Hour Count Duration Avg duration Sep 03 05 2 11s741ms 5s870ms [ User: qaeu - Total duration: 5s970ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s771ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:43:37 Duration: 5s970ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:48:38 Duration: 5s771ms Database: ctdprd51 User: pubeu Bind query: yes
18 10s232ms 1 10s232ms 10s232ms 10s232ms 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 #18
Day Hour Count Duration Avg duration Sep 03 23 1 10s232ms 10s232ms [ User: pubeu - Total duration: 10s232ms - 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 = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-03 23:44:29 Duration: 10s232ms Database: ctdprd51 User: pubeu Bind query: yes
19 8s110ms 1 8s110ms 8s110ms 8s110ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 07 1 8s110ms 8s110ms [ User: pubeu - Total duration: 8s110ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'non-alcoholic fatty liver disease' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2202481) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-03 07:19:02 Duration: 8s110ms Database: ctdprd51 User: pubeu Bind query: yes
20 6s336ms 1 6s336ms 6s336ms 6s336ms vacuum analyze log_query_archive;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 00 1 6s336ms 6s336ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-03 00:09:27 Duration: 6s336ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 6 9m10s 1m26s 1m39s 1m31s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id # ? where ? = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 10 3 4m46s 1m35s 11 1 1m30s 1m30s 12 1 1m27s 1m27s 14 1 1m26s 1m26s [ User: load - Total duration: 9m10s - Times executed: 6 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:47:49 Duration: 1m39s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:45:11 Duration: 1m37s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 11:14:04 Duration: 1m30s Database: ctdprd51 User: load Bind query: yes
2 5 7m31s 1m21s 1m35s 1m30s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 10 1 1m26s 1m26s 14 3 4m29s 1m29s 15 1 1m35s 1m35s [ User: load - Total duration: 7m31s - Times executed: 5 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 15:10:05 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:57:17 Duration: 1m34s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:53:56 Duration: 1m33s Database: ctdprd51 User: load Bind query: yes
3 4 7m30s 1m52s 1m52s 1m52s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:06:55 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
4 4 1m36s 23s974ms 24s367ms 24s168ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 06 1 23s974ms 23s974ms 10 1 24s157ms 24s157ms 14 1 24s176ms 24s176ms 18 1 24s367ms 24s367ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:07:19 Duration: 24s367ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:07:19 Duration: 24s176ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:07:18 Duration: 24s157ms
5 4 1m21s 20s116ms 20s632ms 20s291ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 06 1 20s632ms 20s632ms 10 1 20s175ms 20s175ms 14 1 20s116ms 20s116ms 18 1 20s241ms 20s241ms [ User: postgres - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:22 Duration: 20s632ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:21 Duration: 20s241ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:22 Duration: 20s175ms Database: ctdprd51 User: postgres Application: pg_dump
6 4 1m1s 15s332ms 15s465ms 15s405ms copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 03 06 1 15s332ms 15s332ms 10 1 15s406ms 15s406ms 14 1 15s465ms 15s465ms 18 1 15s419ms 15s419ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 14:07:34 Duration: 15s465ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 18:07:34 Duration: 15s419ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 10:07:34 Duration: 15s406ms
7 4 1m 14s921ms 15s316ms 15s34ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 06 1 14s929ms 14s929ms 10 1 14s972ms 14s972ms 14 1 15s316ms 15s316ms 18 1 14s921ms 14s921ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:53 Duration: 15s316ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:53 Duration: 14s972ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:54 Duration: 14s929ms
8 4 58s385ms 14s497ms 14s721ms 14s596ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 06 1 14s497ms 14s497ms 10 1 14s635ms 14s635ms 14 1 14s721ms 14s721ms 18 1 14s531ms 14s531ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:08 Duration: 14s721ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:08 Duration: 14s635ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:01:07 Duration: 14s531ms
9 4 30s488ms 7s555ms 7s674ms 7s622ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 06 1 7s655ms 7s655ms 10 1 7s602ms 7s602ms 14 1 7s674ms 7s674ms 18 1 7s555ms 7s555ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:31 Duration: 7s674ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:32 Duration: 7s655ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:32 Duration: 7s602ms
10 4 26s111ms 6s485ms 6s647ms 6s527ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 06 1 6s488ms 6s488ms 10 1 6s490ms 6s490ms 14 1 6s647ms 6s647ms 18 1 6s485ms 6s485ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:16 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:16 Duration: 6s490ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:01:17 Duration: 6s488ms
11 4 24s948ms 6s202ms 6s324ms 6s237ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 06 1 6s202ms 6s202ms 10 1 6s212ms 6s212ms 14 1 6s324ms 6s324ms 18 1 6s209ms 6s209ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:38 Duration: 6s324ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:38 Duration: 6s212ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:38 Duration: 6s209ms
12 4 23s211ms 5s719ms 5s867ms 5s802ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 03 17 1 5s816ms 5s816ms 18 3 17s394ms 5s798ms [ User: pubeu - Total duration: 17s491ms - Times executed: 3 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:06:59 Duration: 5s867ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 17:01:30 Duration: 5s816ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:07:00 Duration: 5s807ms Database: ctdprd51 User: pubeu Bind query: yes
13 3 17s151ms 5s675ms 5s752ms 5s717ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 17 1 5s752ms 5s752ms 18 2 11s399ms 5s699ms [ User: pubeu - Total duration: 5s752ms - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 17:03:11 Duration: 5s752ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:28 Duration: 5s723ms Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:53 Duration: 5s675ms Bind query: yes
14 2 11s741ms 5s771ms 5s970ms 5s870ms 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 #14
Day Hour Count Duration Avg duration Sep 03 05 2 11s741ms 5s870ms [ User: qaeu - Total duration: 5s970ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s771ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:43:37 Duration: 5s970ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:48:38 Duration: 5s771ms Database: ctdprd51 User: pubeu Bind query: yes
15 1 10m59s 10m59s 10m59s 10m59s select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.taxon_id = any (array ( select dp.descendant_object_id from dag_path dp inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 06 1 10m59s 10m59s [ User: pubeu - Total duration: 10m59s - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id LIMIT 50;
Date: 2026-09-03 06:05:09 Duration: 10m59s Database: ctdprd51 User: pubeu Bind query: yes
16 1 9m19s 9m19s 9m19s 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - 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-09-03 00:09:21 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
17 1 27s661ms 27s661ms 27s661ms 27s661ms 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 #17
Day Hour Count Duration Avg duration Sep 03 20 1 27s661ms 27s661ms [ User: pubeu - Total duration: 27s661ms - Times executed: 1 ]
-
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 = '1325014') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-09-03 20:57:33 Duration: 27s661ms Database: ctdprd51 User: pubeu Bind query: yes
18 1 10s232ms 10s232ms 10s232ms 10s232ms 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 #18
Day Hour Count Duration Avg duration Sep 03 23 1 10s232ms 10s232ms [ User: pubeu - Total duration: 10s232ms - 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 = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-03 23:44:29 Duration: 10s232ms Database: ctdprd51 User: pubeu Bind query: yes
19 1 8s110ms 8s110ms 8s110ms 8s110ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 07 1 8s110ms 8s110ms [ User: pubeu - Total duration: 8s110ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'non-alcoholic fatty liver disease' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2202481) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-03 07:19:02 Duration: 8s110ms Database: ctdprd51 User: pubeu Bind query: yes
20 1 6s336ms 6s336ms 6s336ms 6s336ms vacuum analyze log_query_archive;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 00 1 6s336ms 6s336ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-03 00:09:27 Duration: 6s336ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 10m59s 10m59s 10m59s 1 10m59s select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.taxon_id = any (array ( select dp.descendant_object_id from dag_path dp inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 06 1 10m59s 10m59s [ User: pubeu - Total duration: 10m59s - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'gene'))) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Acc */ dp.descendant_object_id FROM dag_path dp INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id LIMIT 50;
Date: 2026-09-03 06:05:09 Duration: 10m59s Database: ctdprd51 User: pubeu Bind query: yes
2 9m19s 9m19s 9m19s 1 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - 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-09-03 00:09:21 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
3 1m52s 1m52s 1m52s 4 7m30s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m52s 1m52s 18 1 1m52s 1m52s [ User: postgres - Total duration: 7m30s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m30s - Times executed: 4 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:06:55 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
4 1m26s 1m39s 1m31s 6 9m10s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id # ? where ? = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 10 3 4m46s 1m35s 11 1 1m30s 1m30s 12 1 1m27s 1m27s 14 1 1m26s 1m26s [ User: load - Total duration: 9m10s - Times executed: 6 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:47:49 Duration: 1m39s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 10:45:11 Duration: 1m37s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id # 015 where 1 = 1;
Date: 2026-09-03 11:14:04 Duration: 1m30s Database: ctdprd51 User: load Bind query: yes
5 1m21s 1m35s 1m30s 5 7m31s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 10 1 1m26s 1m26s 14 3 4m29s 1m29s 15 1 1m35s 1m35s [ User: load - Total duration: 7m31s - Times executed: 5 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 15:10:05 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:57:17 Duration: 1m34s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-03 14:53:56 Duration: 1m33s Database: ctdprd51 User: load Bind query: yes
6 27s661ms 27s661ms 27s661ms 1 27s661ms 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 #6
Day Hour Count Duration Avg duration Sep 03 20 1 27s661ms 27s661ms [ User: pubeu - Total duration: 27s661ms - Times executed: 1 ]
-
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 = '1325014') AND gga.is_not = false) sq ORDER BY sq.gonmsort, sq.genesymbolsort LIMIT 50;
Date: 2026-09-03 20:57:33 Duration: 27s661ms Database: ctdprd51 User: pubeu Bind query: yes
7 23s974ms 24s367ms 24s168ms 4 1m36s copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 06 1 23s974ms 23s974ms 10 1 24s157ms 24s157ms 14 1 24s176ms 24s176ms 18 1 24s367ms 24s367ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 18:07:19 Duration: 24s367ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 14:07:19 Duration: 24s176ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-09-03 10:07:18 Duration: 24s157ms
8 20s116ms 20s632ms 20s291ms 4 1m21s copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 06 1 20s632ms 20s632ms 10 1 20s175ms 20s175ms 14 1 20s116ms 20s116ms 18 1 20s241ms 20s241ms [ User: postgres - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m21s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:22 Duration: 20s632ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:21 Duration: 20s241ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:22 Duration: 20s175ms Database: ctdprd51 User: postgres Application: pg_dump
9 15s332ms 15s465ms 15s405ms 4 1m1s copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 06 1 15s332ms 15s332ms 10 1 15s406ms 15s406ms 14 1 15s465ms 15s465ms 18 1 15s419ms 15s419ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 14:07:34 Duration: 15s465ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 18:07:34 Duration: 15s419ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-09-03 10:07:34 Duration: 15s406ms
10 14s921ms 15s316ms 15s34ms 4 1m copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 06 1 14s929ms 14s929ms 10 1 14s972ms 14s972ms 14 1 15s316ms 15s316ms 18 1 14s921ms 14s921ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:53 Duration: 15s316ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:53 Duration: 14s972ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:54 Duration: 14s929ms
11 14s497ms 14s721ms 14s596ms 4 58s385ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 06 1 14s497ms 14s497ms 10 1 14s635ms 14s635ms 14 1 14s721ms 14s721ms 18 1 14s531ms 14s531ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:08 Duration: 14s721ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:08 Duration: 14s635ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:01:07 Duration: 14s531ms
12 10s232ms 10s232ms 10s232ms 1 10s232ms 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 #12
Day Hour Count Duration Avg duration Sep 03 23 1 10s232ms 10s232ms [ User: pubeu - Total duration: 10s232ms - 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 = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-03 23:44:29 Duration: 10s232ms Database: ctdprd51 User: pubeu Bind query: yes
13 8s110ms 8s110ms 8s110ms 1 8s110ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 07 1 8s110ms 8s110ms [ User: pubeu - Total duration: 8s110ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'non-alcoholic fatty liver disease' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2202481) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-03 07:19:02 Duration: 8s110ms Database: ctdprd51 User: pubeu Bind query: yes
14 7s555ms 7s674ms 7s622ms 4 30s488ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 03 06 1 7s655ms 7s655ms 10 1 7s602ms 7s602ms 14 1 7s674ms 7s674ms 18 1 7s555ms 7s555ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:31 Duration: 7s674ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:00:32 Duration: 7s655ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:32 Duration: 7s602ms
15 6s485ms 6s647ms 6s527ms 4 26s111ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 06 1 6s488ms 6s488ms 10 1 6s490ms 6s490ms 14 1 6s647ms 6s647ms 18 1 6s485ms 6s485ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:01:16 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:01:16 Duration: 6s490ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 06:01:17 Duration: 6s488ms
16 6s336ms 6s336ms 6s336ms 1 6s336ms vacuum analyze log_query_archive;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 00 1 6s336ms 6s336ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-03 00:09:27 Duration: 6s336ms
17 6s202ms 6s324ms 6s237ms 4 24s948ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 03 06 1 6s202ms 6s202ms 10 1 6s212ms 6s212ms 14 1 6s324ms 6s324ms 18 1 6s209ms 6s209ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 14:00:38 Duration: 6s324ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 10:00:38 Duration: 6s212ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-03 18:00:38 Duration: 6s209ms
18 5s771ms 5s970ms 5s870ms 2 11s741ms 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 #18
Day Hour Count Duration Avg duration Sep 03 05 2 11s741ms 5s870ms [ User: qaeu - Total duration: 5s970ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s771ms - Times executed: 1 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:43:37 Duration: 5s970ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1404748)) 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-09-03 05:48:38 Duration: 5s771ms Database: ctdprd51 User: pubeu Bind query: yes
19 5s719ms 5s867ms 5s802ms 4 23s211ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 17 1 5s816ms 5s816ms 18 3 17s394ms 5s798ms [ User: pubeu - Total duration: 17s491ms - Times executed: 3 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:06:59 Duration: 5s867ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 17:01:30 Duration: 5s816ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt LIMIT 50;
Date: 2026-09-03 18:07:00 Duration: 5s807ms Database: ctdprd51 User: pubeu Bind query: yes
20 5s675ms 5s752ms 5s717ms 3 17s151ms select g.nm genesymbol, g.id geneid, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, c.nm chemnm, c.nm_html chemnmhtml, c.acc_txt chemacc, c.secondary_nm casrn, c.id chemid, i.id ixnid, i.ixn_prose_txt ixnprose, i.ixn_prose_html ixnprosehtml, i.actions_txt ixnactions, count(distinct gcr.reference_id) refcount, count(distinct gcr.taxon_id) taxoncount, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct r.acc_txt, ?)) as references, count(*) over () fullrowcount from gene_chem_reference gcr inner join ixn i on gcr.ixn_id = i.id inner join term g on gcr.gene_id = g.id inner join term c on gcr.chem_id = c.id inner join reference r on gcr.reference_id = r.id left outer join term taxonterm on gcr.taxon_id = taxonterm.id where exists ( select ? from gene_chem_ref_gene_form gf where gf.gene_chem_reference_id = gcr.id and gf.gene_id = gcr.gene_id and gf.actor_form_type_nm in ( select tc.nm from actor_form_type tp, actor_form_type tc where tc.subset_left_no between tp.subset_left_no and tp.subset_right_no and (tp.nm = ?))) and gcr.chem_id = any (array ( select dp.descendant_object_id from dag_path dp inner join term t on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) and gcr.taxon_id = any (array ( select dp.descendant_object_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id where upper(t.nm) like ? and t.object_type_id = ?)) group by g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id order by c.nm_sort, g.nm_sort, i.sort_txt;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 17 1 5s752ms 5s752ms 18 2 11s399ms 5s699ms [ User: pubeu - Total duration: 5s752ms - Times executed: 1 ]
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 17:03:11 Duration: 5s752ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:28 Duration: 5s723ms Bind query: yes
-
SELECT /* AdvancedIxnQueryDAO.getData */ g.nm geneSymbol, g.id geneId, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, c.nm chemNm, c.nm_html chemNmhtml, c.acc_txt chemAcc, c.secondary_nm casRN, c.id chemId, i.id ixnId, i.ixn_prose_txt ixnProse, i.ixn_prose_html ixnProseHtml, i.actions_txt ixnActions, COUNT(DISTINCT gcr.reference_id) refCount, COUNT(DISTINCT gcr.taxon_id) taxonCount, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(*) OVER () fullRowCount FROM gene_chem_reference gcr INNER JOIN ixn i ON gcr.ixn_id = i.id INNER JOIN term g ON gcr.gene_id = g.id INNER JOIN term c ON gcr.chem_id = c.id INNER JOIN reference r on gcr.reference_id = r.id LEFT OUTER JOIN term taxonTerm on gcr.taxon_id = taxonTerm.id WHERE /* CIQH.getIxnWhereCore */ EXISTS ( SELECT /* CIQH.getIxnGeneFormTypeWhere */ 1 FROM gene_chem_ref_gene_form gf WHERE gf.gene_chem_reference_id = gcr.id AND gf.gene_id = gcr.gene_id AND gf.actor_form_type_nm IN ( SELECT tc.nm FROM actor_form_type tp, actor_form_type tc WHERE tc.subset_left_no BETWEEN tp.subset_left_no AND tp.subset_right_no AND (tp.nm = 'protein'))) AND gcr.chem_id = ANY (ARRAY ( SELECT /* CIQH.getIxnChemWhereEquals.Name */ dp.descendant_object_id FROM dag_path dp INNER JOIN term t ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'TETRACHLORODIBENZODIOXIN' AND t.object_type_id = 2)) AND gcr.taxon_id = ANY (ARRAY ( SELECT /* CIQH.getIxnTaxonWhereEquals.Name */ dp.descendant_object_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id WHERE UPPER(t.nm) LIKE 'HOMO SAPIENS' AND t.object_type_id = 1)) GROUP BY g.nm, g.nm_sort, g.acc_txt, g.acc_db_cd, g.id, c.nm, c.nm_html, c.nm_sort, c.acc_txt, c.secondary_nm, c.id, i.ixn_prose_txt, i.ixn_prose_html, i.sort_txt, i.actions_txt, i.id ORDER BY c.nm_sort, g.nm_sort, i.sort_txt;
Date: 2026-09-03 18:09:53 Duration: 5s675ms Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 7,886 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1 FATAL entries
- 8 ERROR entries
- 0 WARNING entries
- 23 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 19 Max number of times the same event was reported
- 32 Total events found
Rank Times reported Error 1 19 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 03 10 5 11 2 12 1 14 10 15 1 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-09-03 10:40:32
Date: 2026-09-03 10:42:43
Date: 2026-09-03 10:45:12
2 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 03 17 2 18 1 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-09-03 17:29:31 Database: ctdprd51 Application: pgAdmin 4 - CONN:2371216 User: pub2 Remote:
Date: 2026-09-03 17:29:31
Date: 2026-09-03 18:52:32 Database: ctdprd51 Application: pgAdmin 4 - CONN:774039 User: load Remote:
3 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 03 13 1 14 1 15 1 - ERROR: column geneterm.acctxt does not exist at character 8
- ERROR: column "source_id" does not exist at character 233
- ERROR: column "cd" does not exist at character 52
Hint: Perhaps you meant to reference the column "geneterm.acc_txt".
Statement: select geneTerm.accTxt, diseaseTerm.accTxt, gdra.action_type_cd from gene_disease_reference gdr ,gene_disease_reference_axn gdra ,term geneTerm ,term diseaseTerm where source_cd = 'C' and gdr.id = gdra.gene_disease_reference_id and gene_id = geneTerm.id and disease_id = diseaseTerm.id limit 100Date: 2026-09-03 13:38:13 Database: ctdprd51 Application: pgAdmin 4 - CONN:5620679 User: pub1 Remote:
Hint: Perhaps you meant to reference the column "gdr.source_cd".
Statement: select geneTerm.acc_txt, diseaseTerm.acc_txt, gdra.action_type_cd #015 from pub2.GENE_DISEASE_REFERENCE gdr #015 ,pub2.GENE_DISEASE_REFERENCE_AXN gdra #015 ,pub2.TERM geneTerm #015 ,pub2.TERM diseaseTerm #015 where source_id = 'C'#015 and gdr.id = gdra.gene_disease_reference_id #015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015 union #015 select geneTerm.acc_txt, diseaseTerm.acc_txt, 'm'#015 from gene_disease_reference gdr #015 ,term geneTerm #015 ,term diseaseTerm #015 where source_cd = 'O'#015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015Date: 2026-09-03 14:21:17 Database: ctdprd51 Application: User: load Remote:
Hint: Perhaps you meant to reference the column "gdr.id".
Statement: select count(*) from ( select gene_id, disease_id, cd from gene_disease_reference gdr ,gene_disease_reference_axn gdra where gdr.id = gene_disease_reference.id and source_cd = 'C' union select gene_id, disease_id, 'm' from gene_disease_reference gdr where source_cd = 'O' ) as tesetDate: 2026-09-03 15:12:55
4 2 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 03 10 1 14 1 - ERROR: missing FROM-clause entry for table "t" at character 507
- ERROR: missing FROM-clause entry for table "geneterm" at character 9
Statement: select chemTerm.nm #015 ,chemTerm.acc_txt #015 ,chemTerm.secondary_nm #015 ,geneTerm.nm #015 ,geneTerm.acc_txt #015 ,phenotypeTerm.nm #015 ,phenotypeTerm.acc_txt #015 ,diseaseTerm.nm #015 ,diseaseTerm.acc_txt #015 from pub2.TETRAMER#015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id #015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id #015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id #015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id
Date: 2026-09-03 10:40:31 Database: ctdprd51 Application: User: load Remote:
Statement: select geneTerm.acc_txt, diseaseTerm.acc_txt, gdra.action_type_cd #015 from pub2.GENE_DISEASE_REFERENCE gdr #015 ,pub2.GENE_DISEASE_REFERENCE_AXN gdra #015 ,pub2.TERM geneT #015 ,pub2.TERM disea #015 where source_id = 'C'#015 and gdr.id = gdra.gene_disease_reference_id #015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015 union #015 select geneTerm.acc_txt, diseaseTerm.acc_txt, 'm'#015 from gene_disease_reference gdr #015 ,term geneTerm #015 ,term diseaseTerm #015 where source_cd = 'O'#015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015
Date: 2026-09-03 14:20:05 Database: ctdprd51 Application: User: load Remote:
5 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 03 06 1 - FATAL: connection to client lost
Date: 2026-09-03 06:05:09
6 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 03 06 1 - LOG: could not send data to client: Broken pipe
Date: 2026-09-03 06:05:09
7 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 03 14 1 - ERROR: relation "gene_disease_reference" does not exist at character 500
Statement: select geneTerm.acc_txt, diseaseTerm.acc_txt, gdra.action_type_cd #015 from pub2.GENE_DISEASE_REFERENCE gdr #015 ,pub2.GENE_DISEASE_REFERENCE_AXN gdra #015 ,pub2.TERM geneTerm #015 ,pub2.TERM diseaseTerm #015 where source_cd = 'C'#015 and gdr.id = gdra.gene_disease_reference_id #015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015 union #015 select geneTerm.acc_txt, diseaseTerm.acc_txt, 'm'#015 from gene_disease_reference gdr #015 ,term geneTerm #015 ,term diseaseTerm #015 where source_cd = 'O'#015 and gene_id = geneTerm.id #015 and disease_id = diseaseTerm.id #015
Date: 2026-09-03 14:22:08 Database: ctdprd51 Application: User: load Remote:
8 1 ERROR: function count(...) does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 03 15 1 - ERROR: function count(integer, integer, character varying) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select count( distinct gene_id, disease_id, action_type_cd) from ( select gene_id, disease_id, action_type_cd from gene_disease_reference gdr ,gene_disease_reference_axn gdra where gdr.id = gdra.gene_disease_reference_id and source_cd = 'C' union select gene_id, disease_id, 'm' from gene_disease_reference gdr where source_cd = 'O' ) as tesetDate: 2026-09-03 15:14:44
9 1 ERROR: invalid reference to FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 03 15 1 - ERROR: invalid reference to FROM-clause entry for table "gene_disease_reference" at character 156
Hint: Perhaps you meant to reference the table alias "gdr".
Statement: select count(*) from ( select gene_id, disease_id, action_type_cd from gene_disease_reference gdr ,gene_disease_reference_axn gdra where gdr.id = gene_disease_reference.id and source_cd = 'C' union select gene_id, disease_id, 'm' from gene_disease_reference gdr where source_cd = 'O' ) as tesetDate: 2026-09-03 15:13:50