pgBadger-
Global information
- Generated on Sun Sep 6 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260905
- Parsed 16,351 log entries in 3s
- Log start from 2026-09-05 00:00:01 to 2026-09-05 23:59:53
-
Overview
Global Stats
- 64 Number of unique normalized queries
- 81 Number of queries
- 1h55m18s Total query duration
- 2026-09-05 00:09:31 First query
- 2026-09-05 23:18:00 Last query
- 1 queries/s at 2026-09-05 18:14:12 Query peak
- 1h55m18s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h55m18s Execute total duration
- 8 Number of events
- 5 Number of unique normalized events
- 3 Max number of times the same event was reported
- 0 Number of cancellation
- 3 Total number of automatic vacuums
- 12 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,983 Total number of sessions
- 49 sessions at 2026-09-05 00:01:40 Session peak
- 40d2h20m33s Total duration of sessions
- 29m7s Average duration of sessions
- 0 Average queries per session
- 3s488ms Average queries duration per session
- 29m3s Average idle time per session
- 1,983 Total number of connections
- 9 connections/s at 2026-09-05 05:40:09 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-05 18:14:12 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-05 08:46:22 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-05 18:14:12 Date
Queries duration
Key values
- 1h55m18s 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 05 00 2 0ms 9m29s 4m48s 0ms 0ms 9m36s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 11 0ms 16s873ms 7s317ms 7s480ms 10s921ms 22s587ms 05 2 0ms 5s880ms 5s824ms 0ms 0ms 5s880ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 6s639ms 6s639ms 0ms 0ms 6s639ms 08 1 0ms 48s630ms 48s630ms 0ms 0ms 48s630ms 09 7 0ms 51s506ms 36s712ms 47s561ms 48s593ms 51s506ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 1 0ms 10s362ms 10s362ms 0ms 0ms 10s362ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 31 0ms 28m5s 1m34s 1m24s 1m44s 28m51s 19 24 0ms 28m27s 2m3s 1m29s 2m15s 28m27s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 1 0ms 15s877ms 15s877ms 0ms 0ms 15s877ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 05 00 1 0 9m29s 0ms 0ms 9m29s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 11 0 7s317ms 0ms 7s480ms 22s587ms 05 2 0 5s824ms 0ms 0ms 5s880ms 06 0 0 0ms 0ms 0ms 0ms 07 1 0 6s639ms 0ms 0ms 6s639ms 08 1 0 48s630ms 0ms 0ms 48s630ms 09 7 0 36s712ms 0ms 47s561ms 51s506ms 10 0 0 0ms 0ms 0ms 0ms 11 1 0 10s362ms 0ms 0ms 10s362ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 31 1m34s 1m3s 1m24s 28m51s 19 0 24 2m3s 59s77ms 1m29s 28m27s 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 0 15s877ms 0ms 0ms 15s877ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 05 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 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 11 11.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 7 7.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Sep 05 00 80 0.02/s 01 74 0.02/s 02 80 0.02/s 03 79 0.02/s 04 108 0.03/s 05 103 0.03/s 06 79 0.02/s 07 118 0.03/s 08 89 0.02/s 09 92 0.03/s 10 76 0.02/s 11 79 0.02/s 12 77 0.02/s 13 77 0.02/s 14 78 0.02/s 15 78 0.02/s 16 79 0.02/s 17 78 0.02/s 18 79 0.02/s 19 74 0.02/s 20 76 0.02/s 21 76 0.02/s 22 77 0.02/s 23 77 0.02/s Day Hour Count Average Duration Average idle time Sep 05 00 80 30m18s 30m11s 01 74 31m38s 31m38s 02 80 29m42s 29m42s 03 79 28m55s 28m55s 04 108 22m50s 22m49s 05 103 23m45s 23m44s 06 79 29m44s 29m44s 07 118 20m24s 20m24s 08 89 27m26s 27m26s 09 92 24m30s 24m27s 10 76 30m39s 30m39s 11 79 31m48s 31m48s 12 77 31m34s 31m34s 13 77 31m23s 31m23s 14 78 31m43s 31m43s 15 78 31m15s 31m15s 16 79 31m2s 31m2s 17 78 31m4s 31m4s 18 78 30m20s 29m43s 19 75 32m21s 31m41s 20 76 32m 32m 21 76 31m23s 31m23s 22 77 31m28s 31m28s 23 77 31m33s 31m33s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-09-05 05:40:09 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,983 connections Total
Connections per user
Key values
- pubeu Main User
- 1,983 connections Total
-
Sessions
Simultaneous sessions
Key values
- 49 sessions Session Peak
- 2026-09-05 00:01:40 Date
Histogram of session times
Key values
- 1,774 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,983 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,983 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,983 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,634 buffers Checkpoint Peak
- 2026-09-05 19:34:08 Date
- 263.775 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-09-05 20:03:19 Date
Checkpoints distance
Key values
- 5.13 Mo Distance Peak
- 2026-09-05 00:30:13 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 05 00 414 41.683s 0.003s 41.694s 01 102 10.383s 0.002s 10.392s 02 183 18.496s 0.002s 18.506s 03 211 21.346s 0.002s 21.354s 04 229 23.147s 0.002s 23.156s 05 71 7.098s 0.001s 7.102s 06 525 52.854s 0.003s 52.868s 07 115 11.709s 0.002s 11.719s 08 191 19.331s 0.002s 19.343s 09 156 15.837s 0.002s 15.847s 10 110 11.203s 0.002s 11.213s 11 195 19.717s 0.002s 19.726s 12 49 5.086s 0.002s 5.096s 13 46 4.782s 0.002s 4.791s 14 20 2.098s 0.001s 2.104s 15 11 1.178s 0.001s 1.183s 16 0 0s 0s 0s 17 27 2.802s 0.001s 2.806s 18 46 4.806s 0.002s 4.816s 19 2,634 263.775s 0.001s 263.78s 20 2,166 217.003s 0.002s 217.012s 21 148 15.013s 0.002s 15.022s 22 116 11.788s 0.002s 11.798s 23 87 8.897s 0.002s 8.906s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 05 00 0 0 0 63 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 02 0 0 0 26 0.001s 0.002s 03 0 0 0 30 0.001s 0.002s 04 0 0 0 28 0.001s 0.002s 05 0 0 0 11 0.001s 0.001s 06 0 0 0 38 0.001s 0.003s 07 0 0 0 20 0.001s 0.002s 08 0 0 0 27 0.001s 0.002s 09 0 0 0 25 0.001s 0.002s 10 0 0 0 21 0.001s 0.002s 11 0 0 0 29 0.001s 0.002s 12 0 0 0 19 0.001s 0.002s 13 0 0 0 18 0.001s 0.002s 14 0 0 0 8 0.001s 0.001s 15 0 0 0 7 0.001s 0.001s 16 0 0 0 0 0s 0s 17 0 0 0 10 0.001s 0.001s 18 0 0 0 23 0.001s 0.002s 19 0 0 0 10 0.001s 0.001s 20 0 0 0 20 0.001s 0.002s 21 0 0 0 27 0.001s 0.002s 22 0 0 0 19 0.001s 0.002s 23 0 0 0 20 0.001s 0.002s Day Hour Count Avg time (sec) Sep 05 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 05 00 1,444.50 kB 81,101.50 kB 01 37.00 kB 65,709.50 kB 02 157.00 kB 53,254.00 kB 03 304.50 kB 43,182.00 kB 04 215.50 kB 35,028.50 kB 05 62.00 kB 29,877.00 kB 06 492.00 kB 24,417.00 kB 07 85.50 kB 18,738.50 kB 08 206.00 kB 15,216.50 kB 09 293.00 kB 12,363.50 kB 10 224.50 kB 10,063.00 kB 11 286.00 kB 8,214.00 kB 12 70.50 kB 6,671.00 kB 13 64.50 kB 5,416.50 kB 14 34.00 kB 4,624.00 kB 15 52.00 kB 4,167.00 kB 16 0.00 kB 0.00 kB 17 33.00 kB 3,754.00 kB 18 67.00 kB 3,219.00 kB 19 50.00 kB 2,753.00 kB 20 43.50 kB 2,359.00 kB 21 250.50 kB 1,942.00 kB 22 99.00 kB 1,606.50 kB 23 80.00 kB 1,316.50 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.04 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database ctdprd51 - 2026-09-05 05:45:24 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 0.04 sec Highest CPU-cost vacuum
Table pg_catalog.pg_statistic
Database ctdprd51 - 2026-09-05 05:45:24 Date
Analyzes per table
Key values
- pubc.log_query (12) Main table analyzed (database ctdprd51)
- 12 analyzes Total
Vacuums per table
Key values
- pubc.log_query (2) Main table vacuumed on database ctdprd51
- 3 vacuums Total
Vacuum throughput per table
Key values
- pg_catalog.pg_statistic (0.04) 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
- pg_catalog.pg_statistic (550) Main table with removed tuples on database ctdprd51
- 556 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 05 00 1 1 01 0 0 02 0 1 03 0 2 04 0 1 05 1 3 06 0 0 07 0 0 08 0 1 09 0 1 10 1 0 11 0 1 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 - 0.04 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
- 25 Total read queries
- 55 Total write queries
Queries by database
Key values
- unknown Main database
- 61 Requests
- 1h39m6s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 92 Requests
User Request type Count Duration edit Total 1 5s318ms select 1 5s318ms load Total 6 17m31s ddl 1 8m26s select 5 9m4s postgres Total 9 9m22s copy to 9 9m22s pubc Total 1 9m29s select 1 9m29s pubeu Total 21 7m31s select 21 7m31s qaeu Total 2 11s728ms select 2 11s728ms unknown Total 92 1h45m52s copy to 82 1h44m13s others 1 6s832ms select 9 1m32s Duration by user
Key values
- 1h45m52s (unknown) Main time consuming user
User Request type Count Duration edit Total 1 5s318ms select 1 5s318ms load Total 6 17m31s ddl 1 8m26s select 5 9m4s postgres Total 9 9m22s copy to 9 9m22s pubc Total 1 9m29s select 1 9m29s pubeu Total 21 7m31s select 21 7m31s qaeu Total 2 11s728ms select 2 11s728ms unknown Total 92 1h45m52s copy to 82 1h44m13s others 1 6s832ms select 9 1m32s Queries by host
Key values
- unknown Main host
- 132 Requests
- 2h30m5s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 79 Requests
- 1h45m28s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-05 22:59:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 52 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 28m27s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-09-05 19:33:49 ]
2 28m5s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-09-05 18:46:04 ]
3 9m29s /* * 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-05 00:09:31 - Database: ctdprd51 - User: pubc - Application: psql ]
4 6m56s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-09-05 19:46:31 ]
5 6m55s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-09-05 18:58:47 ]
6 1m51s 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-05 19:49:33 ]
7 1m44s COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;[ Date: 2026-09-05 18:49:44 ]
8 1m44s COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;[ Date: 2026-09-05 19:37:29 ]
9 1m22s COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;[ Date: 2026-09-05 19:02:56 ]
10 1m22s COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;[ Date: 2026-09-05 18:15:34 ]
11 1m4s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-09-05 18:16:39 ]
12 1m4s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-09-05 19:04:01 ]
13 56s138ms COPY pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-09-05 19:01:25 ]
14 56s105ms COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-09-05 18:14:03 ]
15 52s523ms COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;[ Date: 2026-09-05 18:51:11 ]
16 52s445ms COPY pub2.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;[ Date: 2026-09-05 19:38:55 ]
17 51s506ms 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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-09-05 09:35:48 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18 50s167ms 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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-09-05 09:23:09 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 48s630ms 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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-09-05 08:46:22 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
20 48s593ms 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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-09-05 09:44:07 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 28m27s 1 28m27s 28m27s 28m27s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 19 1 28m27s 28m27s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:33:49 Duration: 28m27s
2 28m5s 1 28m5s 28m5s 28m5s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 05 18 1 28m5s 28m5s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:46:04 Duration: 28m5s
3 9m29s 1 9m29s 9m29s 9m29s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 00 1 9m29s 9m29s [ User: pubc - Total duration: 9m29s - Times executed: 1 ]
[ Application: psql - Total duration: 9m29s - 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-05 00:09:31 Duration: 9m29s Database: ctdprd51 User: pubc Application: psql
4 6m56s 1 6m56s 6m56s 6m56s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 05 19 1 6m56s 6m56s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 19:46:31 Duration: 6m56s
5 6m55s 1 6m55s 6m55s 6m55s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 18 1 6m55s 6m55s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 18:58:47 Duration: 6m55s
6 5m11s 7 16s873ms 51s506ms 44s435ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 05 04 1 16s873ms 16s873ms 08 1 48s630ms 48s630ms 09 5 4m5s 49s108ms [ User: pubeu - Total duration: 4m54s - Times executed: 6 ]
-
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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:35:48 Duration: 51s506ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:23:09 Duration: 50s167ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 08:46:22 Duration: 48s630ms Database: ctdprd51 User: pubeu Bind query: yes
7 1m51s 1 1m51s 1m51s 1m51s 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 #7
Day Hour Count Duration Avg duration Sep 05 19 1 1m51s 1m51s -
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-05 19:49:33 Duration: 1m51s
8 1m44s 1 1m44s 1m44s 1m44s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 05 18 1 1m44s 1m44s -
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 18:49:44 Duration: 1m44s
9 1m44s 1 1m44s 1m44s 1m44s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 05 19 1 1m44s 1m44s -
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 19:37:29 Duration: 1m44s
10 1m22s 1 1m22s 1m22s 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 19:02:56 Duration: 1m22s
11 1m22s 1 1m22s 1m22s 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 05 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 18:15:34 Duration: 1m22s
12 1m4s 1 1m4s 1m4s 1m4s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 05 18 1 1m4s 1m4s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 18:16:39 Duration: 1m4s
13 1m4s 1 1m4s 1m4s 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 05 19 1 1m4s 1m4s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 19:04:01 Duration: 1m4s
14 56s138ms 1 56s138ms 56s138ms 56s138ms copy pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 05 19 1 56s138ms 56s138ms -
COPY pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:01:25 Duration: 56s138ms
15 56s105ms 1 56s105ms 56s105ms 56s105ms copy pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 18 1 56s105ms 56s105ms -
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:14:03 Duration: 56s105ms
16 52s523ms 1 52s523ms 52s523ms 52s523ms copy pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 05 18 1 52s523ms 52s523ms -
COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-09-05 18:51:11 Duration: 52s523ms
17 52s445ms 1 52s445ms 52s445ms 52s445ms copy pub2.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 05 19 1 52s445ms 52s445ms -
COPY pub2.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-09-05 19:38:55 Duration: 52s445ms
18 47s333ms 1 47s333ms 47s333ms 47s333ms copy pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 05 19 1 47s333ms 47s333ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-09-05 19:34:41 Duration: 47s333ms
19 46s796ms 1 46s796ms 46s796ms 46s796ms copy load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 05 18 1 46s796ms 46s796ms -
COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;
Date: 2026-09-05 18:12:20 Duration: 46s796ms
20 45s960ms 1 45s960ms 45s960ms 45s960ms copy pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 05 18 1 45s960ms 45s960ms -
COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-09-05 18:46:55 Duration: 45s960ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 7 5m11s 16s873ms 51s506ms 44s435ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 04 1 16s873ms 16s873ms 08 1 48s630ms 48s630ms 09 5 4m5s 49s108ms [ User: pubeu - Total duration: 4m54s - Times executed: 6 ]
-
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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:35:48 Duration: 51s506ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:23:09 Duration: 50s167ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 08:46:22 Duration: 48s630ms Database: ctdprd51 User: pubeu Bind query: yes
2 5 40s392ms 6s639ms 10s362ms 8s78ms 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 #2
Day Hour Count Duration Avg duration Sep 05 04 3 23s390ms 7s796ms 07 1 6s639ms 6s639ms 11 1 10s362ms 10s362ms [ User: pubeu - Total duration: 32s911ms - Times executed: 4 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'd008113' "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 = 2203028) 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-05 11:59:56 Duration: 10s362ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'mesh:d009369' "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 = 2198383) 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-05 04:25:10 Duration: 8s53ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'mesh:d009369' "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 = 2198383) 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-05 04:25:33 Duration: 7s857ms Database: ctdprd51 User: pubeu Bind query: yes
3 4 21s574ms 5s318ms 5s491ms 5s393ms select ? "Input", chemicalname AS "ChemicalName", chemicalid AS "ChemicalID", casrn AS "CasRN", phenotypename AS "PhenotypeName", phenotypeid AS "PhenotypeID", interaction AS "Interaction", interactionactions AS "InteractionActions", organismnameandid AS "OrganismName^ID", anatomynameandidandseqnbr AS "AnatomyName^ID^SeqNbr", inferencenetworkterms AS "InferenceNetworkTerms", pubmedids AS "PubMedIDs" from ( select distinct associatedterm.nm as chemicalname, associatedterm.acc_txt as chemicalid, coalesce(associatedterm.secondary_nm, ?) as casrn, phenotypeterm.nm as phenotypename, phenotypeterm.acc_txt as phenotypeid, i.ixn_prose_txt as interaction, i.actions_txt as interactionactions, ( select string_agg(distinct taxonterm.nm || ? || taxonterm.acc_txt, ?)) as organismnameandid, ( select string_agg(distinct anatomyterm.nm || ? || anatomyterm.acc_txt || ? || ia.level_seq, ?)) as anatomynameandidandseqnbr, ( select string_agg(distinct r.acc_txt, ?)) as pubmedids, i.id, ( select string_agg(distinct t.nm, ?) from phenotype_term_reference ptr2, term t where ptr2.via_term_id = t.id and ptr.phenotype_id = ptr2.phenotype_id and ptr.term_id = ptr2.term_id and ptr2.source_cd = ?) as inferencenetworkterms from phenotype_term_reference ptr inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ia.ixn_id = any (array ( select ixn_id from ixn_anatomy where (anatomy_id = ?))) and ptr.source_cd = ? and ptr.term_object_type_id = ? group by chemicalname, chemicalid, casrn, phenotypename, phenotypeid, i.id, interaction, inferencenetworkterms) as baseline order by chemicalname, phenotypename;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 04 4 21s574ms 5s393ms [ User: pubeu - Total duration: 10s826ms - Times executed: 2 ]
-
select 'd008099' "Input", ChemicalName as "ChemicalName", ChemicalID as "ChemicalID", CasRN as "CasRN", PhenotypeName as "PhenotypeName", PhenotypeID as "PhenotypeID", Interaction as "Interaction", InteractionActions as "InteractionActions", OrganismNameAndID as "OrganismName^ID", AnatomyNameAndIDAndSeqNbr as "AnatomyName^ID^SeqNbr", InferenceNetworkTerms as "InferenceNetworkTerms", PubMedIDs as "PubMedIDs" from ( SELECT distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm AS ChemicalName, associatedTerm.acc_txt as ChemicalID, COALESCE(associatedTerm.secondary_nm, '') AS CasRN, phenotypeTerm.nm AS PhenotypeName, phenotypeTerm.acc_txt AS PhenotypeID, i.ixn_prose_txt AS Interaction, i.actions_txt AS InteractionActions, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || taxonTerm.acc_txt, '|')) AS OrganismNameAndID, ( SELECT STRING_AGG(distinct anatomyTerm.nm || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq, '|')) AS AnatomyNameAndIDAndSeqNbr, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) AS PubMedIDs, i.id, ( SELECT STRING_AGG(distinct t.nm, '|') from phenotype_term_reference ptr2, term t where ptr2.via_term_id = t.id and ptr.phenotype_id = ptr2.phenotype_id and ptr.term_id = ptr2.term_id and ptr2.source_cd = 'I') AS InferenceNetworkTerms from phenotype_term_reference ptr inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id WHERE ia.ixn_id = ANY (ARRAY ( select ixn_id from ixn_anatomy where (anatomy_id = 2210073))) and ptr.source_cd = 'C' and ptr.term_object_type_id = 2 group by ChemicalName, ChemicalID, CasRN, PhenotypeName, PhenotypeID, i.id, Interaction, InferenceNetworkTerms) as baseline ORDER BY ChemicalName, PhenotypeName;
Date: 2026-09-05 04:31:02 Duration: 5s491ms Database: ctdprd51 User: pubeu Bind query: yes
-
select 'd008099' "Input", ChemicalName as "ChemicalName", ChemicalID as "ChemicalID", CasRN as "CasRN", PhenotypeName as "PhenotypeName", PhenotypeID as "PhenotypeID", Interaction as "Interaction", InteractionActions as "InteractionActions", OrganismNameAndID as "OrganismName^ID", AnatomyNameAndIDAndSeqNbr as "AnatomyName^ID^SeqNbr", InferenceNetworkTerms as "InferenceNetworkTerms", PubMedIDs as "PubMedIDs" from ( SELECT distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm AS ChemicalName, associatedTerm.acc_txt as ChemicalID, COALESCE(associatedTerm.secondary_nm, '') AS CasRN, phenotypeTerm.nm AS PhenotypeName, phenotypeTerm.acc_txt AS PhenotypeID, i.ixn_prose_txt AS Interaction, i.actions_txt AS InteractionActions, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || taxonTerm.acc_txt, '|')) AS OrganismNameAndID, ( SELECT STRING_AGG(distinct anatomyTerm.nm || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq, '|')) AS AnatomyNameAndIDAndSeqNbr, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) AS PubMedIDs, i.id, ( SELECT STRING_AGG(distinct t.nm, '|') from phenotype_term_reference ptr2, term t where ptr2.via_term_id = t.id and ptr.phenotype_id = ptr2.phenotype_id and ptr.term_id = ptr2.term_id and ptr2.source_cd = 'I') AS InferenceNetworkTerms from phenotype_term_reference ptr inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id WHERE ia.ixn_id = ANY (ARRAY ( select ixn_id from ixn_anatomy where (anatomy_id = 2210073))) and ptr.source_cd = 'C' and ptr.term_object_type_id = 2 group by ChemicalName, ChemicalID, CasRN, PhenotypeName, PhenotypeID, i.id, Interaction, InferenceNetworkTerms) as baseline ORDER BY ChemicalName, PhenotypeName;
Date: 2026-09-05 04:31:27 Duration: 5s429ms Bind query: yes
-
select 'd008099' "Input", ChemicalName as "ChemicalName", ChemicalID as "ChemicalID", CasRN as "CasRN", PhenotypeName as "PhenotypeName", PhenotypeID as "PhenotypeID", Interaction as "Interaction", InteractionActions as "InteractionActions", OrganismNameAndID as "OrganismName^ID", AnatomyNameAndIDAndSeqNbr as "AnatomyName^ID^SeqNbr", InferenceNetworkTerms as "InferenceNetworkTerms", PubMedIDs as "PubMedIDs" from ( SELECT distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm AS ChemicalName, associatedTerm.acc_txt as ChemicalID, COALESCE(associatedTerm.secondary_nm, '') AS CasRN, phenotypeTerm.nm AS PhenotypeName, phenotypeTerm.acc_txt AS PhenotypeID, i.ixn_prose_txt AS Interaction, i.actions_txt AS InteractionActions, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || taxonTerm.acc_txt, '|')) AS OrganismNameAndID, ( SELECT STRING_AGG(distinct anatomyTerm.nm || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq, '|')) AS AnatomyNameAndIDAndSeqNbr, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) AS PubMedIDs, i.id, ( SELECT STRING_AGG(distinct t.nm, '|') from phenotype_term_reference ptr2, term t where ptr2.via_term_id = t.id and ptr.phenotype_id = ptr2.phenotype_id and ptr.term_id = ptr2.term_id and ptr2.source_cd = 'I') AS InferenceNetworkTerms from phenotype_term_reference ptr inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id WHERE ia.ixn_id = ANY (ARRAY ( select ixn_id from ixn_anatomy where (anatomy_id = 2210073))) and ptr.source_cd = 'C' and ptr.term_object_type_id = 2 group by ChemicalName, ChemicalID, CasRN, PhenotypeName, PhenotypeID, i.id, Interaction, InferenceNetworkTerms) as baseline ORDER BY ChemicalName, PhenotypeName;
Date: 2026-09-05 04:30:43 Duration: 5s334ms Database: ctdprd51 User: pubeu Bind query: yes
4 3 17s962ms 5s768ms 6s314ms 5s987ms 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 #4
Day Hour Count Duration Avg duration Sep 05 05 2 11s648ms 5s824ms 09 1 6s314ms 6s314ms [ User: pubeu - Total duration: 12s82ms - Times executed: 2 ]
[ User: qaeu - Total duration: 5s880ms - 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-05 09:36:16 Duration: 6s314ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 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-05 05:43:41 Duration: 5s880ms 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-05 05:48:45 Duration: 5s768ms Database: ctdprd51 User: pubeu Bind query: yes
5 2 13s285ms 6s608ms 6s677ms 6s642ms 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", 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 = ?) and gdr.source_cd = ? group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, c.nm, gdr.network_score order by d.nm_sort, g.nm, c.nm;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 04 2 13s285ms 6s642ms -
SELECT /* BatchDiseaseGeneAssnsDAO */ 'mesh:d009369' "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", 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 = 2198383) AND gdr.source_cd = 'I' GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, c.nm;
Date: 2026-09-05 04:25:28 Duration: 6s677ms Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'mesh:d009369' "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", 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 = 2198383) AND gdr.source_cd = 'I' GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, c.nm;
Date: 2026-09-05 04:26:24 Duration: 6s608ms Bind query: yes
6 2 10s494ms 5s127ms 5s367ms 5s247ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 05 04 1 5s367ms 5s367ms 09 1 5s127ms 5s127ms [ User: pubeu - Total duration: 10s494ms - Times executed: 2 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198151') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-05 04:10:22 Duration: 5s367ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2198151') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-05 09:13:42 Duration: 5s127ms Database: ctdprd51 User: pubeu Bind query: yes
7 1 28m27s 28m27s 28m27s 28m27s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 05 19 1 28m27s 28m27s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:33:49 Duration: 28m27s
8 1 28m5s 28m5s 28m5s 28m5s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 05 18 1 28m5s 28m5s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:46:04 Duration: 28m5s
9 1 9m29s 9m29s 9m29s 9m29s select maint_query_logs_archive ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 05 00 1 9m29s 9m29s [ User: pubc - Total duration: 9m29s - Times executed: 1 ]
[ Application: psql - Total duration: 9m29s - 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-05 00:09:31 Duration: 9m29s Database: ctdprd51 User: pubc Application: psql
10 1 6m56s 6m56s 6m56s 6m56s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 19 1 6m56s 6m56s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 19:46:31 Duration: 6m56s
11 1 6m55s 6m55s 6m55s 6m55s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 05 18 1 6m55s 6m55s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 18:58:47 Duration: 6m55s
12 1 1m51s 1m51s 1m51s 1m51s 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 #12
Day Hour Count Duration Avg duration Sep 05 19 1 1m51s 1m51s -
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-05 19:49:33 Duration: 1m51s
13 1 1m44s 1m44s 1m44s 1m44s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 05 18 1 1m44s 1m44s -
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 18:49:44 Duration: 1m44s
14 1 1m44s 1m44s 1m44s 1m44s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 05 19 1 1m44s 1m44s -
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 19:37:29 Duration: 1m44s
15 1 1m22s 1m22s 1m22s 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 19:02:56 Duration: 1m22s
16 1 1m22s 1m22s 1m22s 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 05 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 18:15:34 Duration: 1m22s
17 1 1m4s 1m4s 1m4s 1m4s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 05 18 1 1m4s 1m4s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 18:16:39 Duration: 1m4s
18 1 1m4s 1m4s 1m4s 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 05 19 1 1m4s 1m4s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 19:04:01 Duration: 1m4s
19 1 56s138ms 56s138ms 56s138ms 56s138ms copy pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 05 19 1 56s138ms 56s138ms -
COPY pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:01:25 Duration: 56s138ms
20 1 56s105ms 56s105ms 56s105ms 56s105ms copy pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 05 18 1 56s105ms 56s105ms -
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:14:03 Duration: 56s105ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 28m27s 28m27s 28m27s 1 28m27s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 05 19 1 28m27s 28m27s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:33:49 Duration: 28m27s
2 28m5s 28m5s 28m5s 1 28m5s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 05 18 1 28m5s 28m5s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:46:04 Duration: 28m5s
3 9m29s 9m29s 9m29s 1 9m29s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 05 00 1 9m29s 9m29s [ User: pubc - Total duration: 9m29s - Times executed: 1 ]
[ Application: psql - Total duration: 9m29s - 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-05 00:09:31 Duration: 9m29s Database: ctdprd51 User: pubc Application: psql
4 6m56s 6m56s 6m56s 1 6m56s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 05 19 1 6m56s 6m56s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 19:46:31 Duration: 6m56s
5 6m55s 6m55s 6m55s 1 6m55s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 05 18 1 6m55s 6m55s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-09-05 18:58:47 Duration: 6m55s
6 1m51s 1m51s 1m51s 1 1m51s 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 #6
Day Hour Count Duration Avg duration Sep 05 19 1 1m51s 1m51s -
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-05 19:49:33 Duration: 1m51s
7 1m44s 1m44s 1m44s 1 1m44s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 05 18 1 1m44s 1m44s -
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 18:49:44 Duration: 1m44s
8 1m44s 1m44s 1m44s 1 1m44s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 05 19 1 1m44s 1m44s -
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-09-05 19:37:29 Duration: 1m44s
9 1m22s 1m22s 1m22s 1 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 05 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 19:02:56 Duration: 1m22s
10 1m22s 1m22s 1m22s 1 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 05 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-09-05 18:15:34 Duration: 1m22s
11 1m4s 1m4s 1m4s 1 1m4s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 05 18 1 1m4s 1m4s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 18:16:39 Duration: 1m4s
12 1m4s 1m4s 1m4s 1 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 05 19 1 1m4s 1m4s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-09-05 19:04:01 Duration: 1m4s
13 56s138ms 56s138ms 56s138ms 1 56s138ms copy pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 05 19 1 56s138ms 56s138ms -
COPY pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 19:01:25 Duration: 56s138ms
14 56s105ms 56s105ms 56s105ms 1 56s105ms copy pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 05 18 1 56s105ms 56s105ms -
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-09-05 18:14:03 Duration: 56s105ms
15 52s523ms 52s523ms 52s523ms 1 52s523ms copy pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 05 18 1 52s523ms 52s523ms -
COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-09-05 18:51:11 Duration: 52s523ms
16 52s445ms 52s445ms 52s445ms 1 52s445ms copy pub2.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 05 19 1 52s445ms 52s445ms -
COPY pub2.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-09-05 19:38:55 Duration: 52s445ms
17 47s333ms 47s333ms 47s333ms 1 47s333ms copy pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 05 19 1 47s333ms 47s333ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-09-05 19:34:41 Duration: 47s333ms
18 46s796ms 46s796ms 46s796ms 1 46s796ms copy load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 05 18 1 46s796ms 46s796ms -
COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;
Date: 2026-09-05 18:12:20 Duration: 46s796ms
19 45s960ms 45s960ms 45s960ms 1 45s960ms copy pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 05 18 1 45s960ms 45s960ms -
COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-09-05 18:46:55 Duration: 45s960ms
20 16s873ms 51s506ms 44s435ms 7 5m11s select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 05 04 1 16s873ms 16s873ms 08 1 48s630ms 48s630ms 09 5 4m5s 49s108ms [ User: pubeu - Total duration: 4m54s - Times executed: 6 ]
-
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 = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:35:48 Duration: 51s506ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 09:23:09 Duration: 50s167ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2197909') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-09-05 08:46:22 Duration: 48s630ms Database: ctdprd51 User: pubeu Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 8,154 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 4 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3 Max number of times the same event was reported
- 8 Total events found
Rank Times reported Error 1 3 LOG: could not send data to client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 05 09 3 - LOG: could not send data to client: Connection reset by peer
- LOG: could not send data to client: Connection reset by peer
- LOG: could not send data to client: Connection reset by peer
Statement: 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
Date: 2026-09-05 09:32:19 Database: ctdprd51 Application: User: pubeu Remote:
Statement: 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 = $1) ORDER BY actionTypes ,gd.network_score DESC NULLS LAST ,g.nm_sort ,d.nm_sort
Date: 2026-09-05 09:32:19 Database: ctdprd51 Application: User: pubeu Remote:
Date: 2026-09-05 09:32:19
2 2 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 05 09 2 - FATAL: connection to client lost
- FATAL: connection to client lost
Statement: 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 = $1) ORDER BY actionTypes ,gd.network_score DESC NULLS LAST ,g.nm_sort ,d.nm_sort
Date: 2026-09-05 09:32:19
Statement: 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 = $1) ORDER BY actionTypes ,gd.network_score DESC NULLS LAST ,g.nm_sort ,d.nm_sort
Date: 2026-09-05 09:32:19
3 1 FATAL: connection to client lost 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 (...) 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 (...) ORDER BY actionTypes ,gd.network_score DESC NULLS LAST ,g.nm_sort ,d.nm_sort
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 05 09 1 - FATAL: connection to client lost 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 = ) ORDER BY actionTypes ,gd.network_score DESC NULLS LAST ,g.nm_sort ,d.nm_sort
Statement: SELECT /* DiseaseGeneAssnsDAO */
Date: 2026-09-05 09:32:19
4 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 05 09 1 - FATAL: canceling authentication due to timeout
Date: 2026-09-05 09:27:21
5 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 05 09 1 - LOG: could not receive data from client: Connection reset by peer
Date: 2026-09-05 09:32:19 Database: ctdprd51 Application: User: pubeu Remote: