pgBadger-
Global information
- Generated on Sun May 24 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260523
- Parsed 15,370 log entries in 2s
- Log start from 2026-05-23 00:00:01 to 2026-05-23 23:59:34
-
Overview
Global Stats
- 58 Number of unique normalized queries
- 60 Number of queries
- 1h46m54s Total query duration
- 2026-05-23 00:09:20 First query
- 2026-05-23 23:37:24 Last query
- 1 queries/s at 2026-05-23 18:45:29 Query peak
- 1h46m54s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h46m54s Execute total duration
- 1 Number of events
- 1 Number of unique normalized events
- 1 Max number of times the same event was reported
- 0 Number of cancellation
- 2 Total number of automatic vacuums
- 22 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,863 Total number of sessions
- 53 sessions at 2026-05-23 01:02:29 Session peak
- 39d23h23m50s Total duration of sessions
- 30m53s Average duration of sessions
- 0 Average queries per session
- 3s443ms Average queries duration per session
- 30m50s Average idle time per session
- 1,863 Total number of connections
- 9 connections/s at 2026-05-23 05:45:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-23 18:45:29 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-23 01:02:52 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-05-23 18:45:29 Date
Queries duration
Key values
- 1h46m54s 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) May 23 00 2 0ms 9m19s 4m43s 0ms 0ms 9m26s 01 2 0ms 49s946ms 49s425ms 0ms 0ms 1m38s 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s612ms 5s596ms 0ms 0ms 5s612ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 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 26m45s 1m34s 1m24s 1m41s 26m45s 19 22 0ms 26m58s 2m7s 1m23s 2m11s 26m58s 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 5s160ms 5s160ms 0ms 0ms 5s160ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 23 00 1 0 9m19s 0ms 0ms 9m19s 01 2 0 49s425ms 0ms 0ms 1m38s 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s596ms 0ms 0ms 5s612ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 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 1m 1m24s 26m45s 19 0 22 2m7s 50s370ms 1m23s 26m58s 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 1 0 5s160ms 0ms 0ms 5s160ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 23 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 May 23 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.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 May 23 00 74 0.02/s 01 72 0.02/s 02 75 0.02/s 03 77 0.02/s 04 97 0.03/s 05 90 0.03/s 06 77 0.02/s 07 76 0.02/s 08 74 0.02/s 09 77 0.02/s 10 77 0.02/s 11 79 0.02/s 12 76 0.02/s 13 78 0.02/s 14 77 0.02/s 15 77 0.02/s 16 78 0.02/s 17 76 0.02/s 18 79 0.02/s 19 74 0.02/s 20 76 0.02/s 21 75 0.02/s 22 79 0.02/s 23 73 0.02/s Day Hour Count Average Duration Average idle time May 23 00 74 31m41s 31m34s 01 72 31m20s 31m18s 02 75 31m19s 31m19s 03 77 31m29s 31m29s 04 97 25m44s 25m44s 05 90 26m58s 26m58s 06 77 30m35s 30m35s 07 76 32m11s 32m11s 08 74 32m 32m 09 77 31m7s 31m7s 10 77 31m9s 31m9s 11 79 31m31s 31m31s 12 76 31m31s 31m31s 13 78 32m9s 32m9s 14 77 31m5s 31m5s 15 77 31m32s 31m32s 16 78 31m38s 31m38s 17 76 31m34s 31m34s 18 78 30m40s 30m3s 19 75 32m29s 31m52s 20 76 31m37s 31m37s 21 75 30m36s 30m36s 22 79 30m21s 30m21s 23 73 31m15s 31m15s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-05-23 05:45:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,863 connections Total
Connections per user
Key values
- qaeu Main User
- 1,863 connections Total
-
Sessions
Simultaneous sessions
Key values
- 53 sessions Session Peak
- 2026-05-23 01:02:29 Date
Histogram of session times
Key values
- 1,792 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,863 sessions Total
Sessions per user
Key values
- qaeu Main User
- 1,863 sessions Total
Sessions per host
Key values
- 10.12.5.45 Main Host
- 1,863 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 77,961 buffers Checkpoint Peak
- 2026-05-23 11:18:30 Date
- 1619.521 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 31 files Wal files usage Peak
- 2026-05-23 11:18:30 Date
Checkpoints distance
Key values
- 998.91 Mo Distance Peak
- 2026-05-23 11:18:30 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 23 00 428 43.045s 0.003s 43.059s 01 145 14.69s 0.002s 14.699s 02 109 11.087s 0.002s 11.096s 03 511 51.354s 0.002s 51.363s 04 73 7.414s 0.002s 7.423s 05 155 15.702s 0.002s 15.71s 06 124 12.579s 0.002s 12.587s 07 111 11.275s 0.002s 11.284s 08 106 10.777s 0.002s 10.785s 09 158 15.988s 0.002s 15.996s 10 55 5.589s 0.001s 5.593s 11 78,806 1,704.311s 0.003s 1,704.416s 12 238 23.997s 0.002s 24.011s 13 228 23.019s 0.002s 23.028s 14 322 32.32s 0.002s 32.33s 15 237 23.895s 0.002s 23.905s 16 85 8.682s 0.002s 8.691s 17 60 6.17s 0.002s 6.178s 18 142 14.402s 0.002s 14.411s 19 36 3.691s 0.001s 3.695s 20 41,266 1,631.895s 0.003s 1,631.908s 21 76 7.774s 0.002s 7.782s 22 72 7.371s 0.002s 7.379s 23 88 8.986s 0.002s 8.995s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 23 00 0 0 1 65 0.001s 0.002s 01 0 0 0 23 0.001s 0.002s 02 0 0 0 24 0.001s 0.002s 03 0 0 0 38 0.001s 0.002s 04 0 0 0 21 0.001s 0.002s 05 0 0 0 28 0.001s 0.002s 06 0 0 0 21 0.001s 0.002s 07 0 0 0 19 0.001s 0.002s 08 0 0 0 19 0.001s 0.002s 09 0 0 0 30 0.001s 0.002s 10 0 0 0 10 0.001s 0.001s 11 0 0 31 84 0.001s 0.003s 12 0 0 1 36 0.001s 0.002s 13 0 0 0 36 0.001s 0.002s 14 0 0 0 38 0.001s 0.002s 15 0 0 0 36 0.001s 0.002s 16 0 0 0 21 0.001s 0.002s 17 0 0 0 20 0.001s 0.002s 18 0 0 0 32 0.001s 0.002s 19 0 0 0 9 0.001s 0.001s 20 0 0 0 32 0.001s 0.003s 21 0 0 0 23 0.001s 0.002s 22 0 0 0 19 0.001s 0.002s 23 0 0 0 21 0.001s 0.002s Day Hour Count Avg time (sec) May 23 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 May 23 00 1,662.00 kB 14,229.00 kB 01 176.50 kB 11,559.00 kB 02 172.50 kB 9,397.00 kB 03 1,288.50 kB 7,844.50 kB 04 43.50 kB 6,373.50 kB 05 370.50 kB 5,203.50 kB 06 77.50 kB 4,257.50 kB 07 56.00 kB 3,460.00 kB 08 66.00 kB 2,813.50 kB 09 231.00 kB 2,322.50 kB 10 100.00 kB 1,995.00 kB 11 172,098.33 kB 462,189.67 kB 12 532.50 kB 354,685.50 kB 13 530.50 kB 287,396.50 kB 14 608.00 kB 232,898.50 kB 15 585.00 kB 188,763.50 kB 16 106.00 kB 152,943.50 kB 17 37.00 kB 123,891.00 kB 18 221.50 kB 100,394.50 kB 19 37.00 kB 85,605.00 kB 20 71.33 kB 69,609.00 kB 21 66.50 kB 53,383.50 kB 22 81.00 kB 43,254.50 kB 23 91.00 kB 35,055.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pubc.log_query
Database ctdprd51 - 2026-05-23 14:25:06 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 0.01 sec Highest CPU-cost vacuum
Table pubc.log_query
Database ctdprd51 - 2026-05-23 14:25:06 Date
Analyzes per table
Key values
- pubc.log_query (21) Main table analyzed (database ctdprd51)
- 22 analyzes Total
Vacuums per table
Key values
- pubc.log_query (2) Main table vacuumed on database ctdprd51
- 2 vacuums Total
Tuples removed per table
Key values
- pubc.log_query (14) Main table with removed tuples on database ctdprd51
- 14 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 May 23 00 0 0 01 0 1 02 0 1 03 0 1 04 0 0 05 0 4 06 0 0 07 0 0 08 0 0 09 0 1 10 0 3 11 1 3 12 0 2 13 0 2 14 1 1 15 0 2 16 0 0 17 0 1 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0.01 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 6 Total read queries
- 53 Total write queries
Queries by database
Key values
- unknown Main database
- 53 Requests
- 1h35m20s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 82 Requests
User Request type Count Duration postgres Total 9 9m4s copy to 9 9m4s pubc Total 1 9m19s select 1 9m19s pubeu Total 34 7m3s select 34 7m3s qaeu Total 2 11s431ms select 2 11s431ms unknown Total 82 1h41m19s copy to 80 1h41m7s others 1 6s947ms select 1 5s68ms Duration by user
Key values
- 1h41m19s (unknown) Main time consuming user
User Request type Count Duration postgres Total 9 9m4s copy to 9 9m4s pubc Total 1 9m19s select 1 9m19s pubeu Total 34 7m3s select 34 7m3s qaeu Total 2 11s431ms select 2 11s431ms unknown Total 82 1h41m19s copy to 80 1h41m7s others 1 6s947ms select 1 5s68ms Queries by host
Key values
- unknown Main host
- 128 Requests
- 2h6m57s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 58 Requests
- 1h37m15s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-23 04:22:05 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 46 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 26m58s 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-05-23 19:30:39 ]
2 26m45s 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-05-23 18:44:24 ]
3 9m19s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-05-23 00:09:20 - Database: ctdprd51 - User: pubc - Application: psql ]
4 6m56s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-05-23 18:56:50 ]
5 6m50s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-05-23 19:43:04 ]
6 1m50s 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-05-23 19:46:45 ]
7 1m41s 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-05-23 19:34:12 ]
8 1m41s 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-05-23 18:47:54 ]
9 1m18s 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-05-23 19:01:19 ]
10 1m12s 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-05-23 18:15:17 ]
11 1m4s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-05-23 18:16:22 ]
12 1m4s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-05-23 19:02:23 ]
13 58s99ms COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-05-23 18:58:16 ]
14 54s817ms 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-05-23 18:13:55 ]
15 54s805ms 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-05-23 18:59:51 ]
16 50s370ms 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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;[ Date: 2026-05-23 19:35:35 ]
17 49s946ms 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-05-23 01:02:50 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18 48s905ms 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;[ Date: 2026-05-23 01:02:52 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 46s868ms 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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;[ Date: 2026-05-23 18:49:14 ]
20 45s676ms COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;[ Date: 2026-05-23 19:31:29 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m58s 1 26m58s 26m58s 26m58s 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 May 23 19 1 26m58s 26m58s -
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-05-23 19:30:39 Duration: 26m58s
2 26m45s 1 26m45s 26m45s 26m45s 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 May 23 18 1 26m45s 26m45s -
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-05-23 18:44:24 Duration: 26m45s
3 9m19s 1 9m19s 9m19s 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 23 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-05-23 00:09:20 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
4 6m56s 1 6m56s 6m56s 6m56s copy pub1.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 May 23 18 1 6m56s 6m56s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:56:50 Duration: 6m56s
5 6m50s 1 6m50s 6m50s 6m50s copy pub2.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 May 23 19 1 6m50s 6m50s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 19:43:04 Duration: 6m50s
6 1m50s 1 1m50s 1m50s 1m50s 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 May 23 19 1 1m50s 1m50s -
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-05-23 19:46:45 Duration: 1m50s
7 1m41s 1 1m41s 1m41s 1m41s 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 #7
Day Hour Count Duration Avg duration May 23 19 1 1m41s 1m41s -
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-05-23 19:34:12 Duration: 1m41s
8 1m41s 1 1m41s 1m41s 1m41s 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 May 23 18 1 1m41s 1m41s -
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-05-23 18:47:54 Duration: 1m41s
9 1m38s 2 48s905ms 49s946ms 49s425ms 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 #9
Day Hour Count Duration Avg duration May 23 01 2 1m38s 49s425ms [ User: pubeu - Total duration: 1m38s - 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:50 Duration: 49s946ms 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:52 Duration: 48s905ms Database: ctdprd51 User: pubeu Bind query: yes
10 1m18s 1 1m18s 1m18s 1m18s 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 May 23 19 1 1m18s 1m18s -
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-05-23 19:01:19 Duration: 1m18s
11 1m12s 1 1m12s 1m12s 1m12s 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 May 23 18 1 1m12s 1m12s -
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-05-23 18:15:17 Duration: 1m12s
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 May 23 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-05-23 18:16:22 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 May 23 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-05-23 19:02:23 Duration: 1m4s
14 58s99ms 1 58s99ms 58s99ms 58s99ms copy pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 23 18 1 58s99ms 58s99ms -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:58:16 Duration: 58s99ms
15 54s817ms 1 54s817ms 54s817ms 54s817ms 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 May 23 18 1 54s817ms 54s817ms -
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-05-23 18:13:55 Duration: 54s817ms
16 54s805ms 1 54s805ms 54s805ms 54s805ms 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 #16
Day Hour Count Duration Avg duration May 23 18 1 54s805ms 54s805ms -
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-05-23 18:59:51 Duration: 54s805ms
17 50s370ms 1 50s370ms 50s370ms 50s370ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 23 19 1 50s370ms 50s370ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 19:35:35 Duration: 50s370ms
18 46s868ms 1 46s868ms 46s868ms 46s868ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 23 18 1 46s868ms 46s868ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 18:49:14 Duration: 46s868ms
19 45s676ms 1 45s676ms 45s676ms 45s676ms copy pub2.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 May 23 19 1 45s676ms 45s676ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-05-23 19:31:29 Duration: 45s676ms
20 45s436ms 1 45s436ms 45s436ms 45s436ms copy pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 23 19 1 45s436ms 45s436ms -
COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 19:44:18 Duration: 45s436ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 1m38s 48s905ms 49s946ms 49s425ms 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 May 23 01 2 1m38s 49s425ms [ User: pubeu - Total duration: 1m38s - 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:50 Duration: 49s946ms 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:52 Duration: 48s905ms Database: ctdprd51 User: pubeu Bind query: yes
2 2 11s192ms 5s580ms 5s612ms 5s596ms 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 #2
Day Hour Count Duration Avg duration May 23 05 2 11s192ms 5s596ms [ User: pubeu - Total duration: 5s612ms - Times executed: 1 ]
[ User: qaeu - Total duration: 5s580ms - 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 = 1339298)) 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-05-23 05:48:44 Duration: 5s612ms 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 = 1339298)) 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-05-23 05:43:39 Duration: 5s580ms Database: ctdprd51 User: qaeu Bind query: yes
3 1 26m58s 26m58s 26m58s 26m58s 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 #3
Day Hour Count Duration Avg duration May 23 19 1 26m58s 26m58s -
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-05-23 19:30:39 Duration: 26m58s
4 1 26m45s 26m45s 26m45s 26m45s 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 #4
Day Hour Count Duration Avg duration May 23 18 1 26m45s 26m45s -
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-05-23 18:44:24 Duration: 26m45s
5 1 9m19s 9m19s 9m19s 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 23 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-05-23 00:09:20 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
6 1 6m56s 6m56s 6m56s 6m56s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 23 18 1 6m56s 6m56s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:56:50 Duration: 6m56s
7 1 6m50s 6m50s 6m50s 6m50s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 23 19 1 6m50s 6m50s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 19:43:04 Duration: 6m50s
8 1 1m50s 1m50s 1m50s 1m50s 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 #8
Day Hour Count Duration Avg duration May 23 19 1 1m50s 1m50s -
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-05-23 19:46:45 Duration: 1m50s
9 1 1m41s 1m41s 1m41s 1m41s 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 May 23 19 1 1m41s 1m41s -
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-05-23 19:34:12 Duration: 1m41s
10 1 1m41s 1m41s 1m41s 1m41s 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 #10
Day Hour Count Duration Avg duration May 23 18 1 1m41s 1m41s -
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-05-23 18:47:54 Duration: 1m41s
11 1 1m18s 1m18s 1m18s 1m18s 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 #11
Day Hour Count Duration Avg duration May 23 19 1 1m18s 1m18s -
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-05-23 19:01:19 Duration: 1m18s
12 1 1m12s 1m12s 1m12s 1m12s 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 #12
Day Hour Count Duration Avg duration May 23 18 1 1m12s 1m12s -
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-05-23 18:15:17 Duration: 1m12s
13 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 #13
Day Hour Count Duration Avg duration May 23 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-05-23 18:16:22 Duration: 1m4s
14 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 #14
Day Hour Count Duration Avg duration May 23 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-05-23 19:02:23 Duration: 1m4s
15 1 58s99ms 58s99ms 58s99ms 58s99ms copy pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 23 18 1 58s99ms 58s99ms -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:58:16 Duration: 58s99ms
16 1 54s817ms 54s817ms 54s817ms 54s817ms 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 #16
Day Hour Count Duration Avg duration May 23 18 1 54s817ms 54s817ms -
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-05-23 18:13:55 Duration: 54s817ms
17 1 54s805ms 54s805ms 54s805ms 54s805ms 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 #17
Day Hour Count Duration Avg duration May 23 18 1 54s805ms 54s805ms -
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-05-23 18:59:51 Duration: 54s805ms
18 1 50s370ms 50s370ms 50s370ms 50s370ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 23 19 1 50s370ms 50s370ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 19:35:35 Duration: 50s370ms
19 1 46s868ms 46s868ms 46s868ms 46s868ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 23 18 1 46s868ms 46s868ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 18:49:14 Duration: 46s868ms
20 1 45s676ms 45s676ms 45s676ms 45s676ms copy pub2.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 May 23 19 1 45s676ms 45s676ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-05-23 19:31:29 Duration: 45s676ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m58s 26m58s 26m58s 1 26m58s 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 May 23 19 1 26m58s 26m58s -
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-05-23 19:30:39 Duration: 26m58s
2 26m45s 26m45s 26m45s 1 26m45s 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 May 23 18 1 26m45s 26m45s -
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-05-23 18:44:24 Duration: 26m45s
3 9m19s 9m19s 9m19s 1 9m19s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 23 00 1 9m19s 9m19s [ User: pubc - Total duration: 9m19s - Times executed: 1 ]
[ Application: psql - Total duration: 9m19s - Times executed: 1 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-05-23 00:09:20 Duration: 9m19s Database: ctdprd51 User: pubc Application: psql
4 6m56s 6m56s 6m56s 1 6m56s copy pub1.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 May 23 18 1 6m56s 6m56s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:56:50 Duration: 6m56s
5 6m50s 6m50s 6m50s 1 6m50s copy pub2.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 May 23 19 1 6m50s 6m50s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 19:43:04 Duration: 6m50s
6 1m50s 1m50s 1m50s 1 1m50s 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 May 23 19 1 1m50s 1m50s -
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-05-23 19:46:45 Duration: 1m50s
7 1m41s 1m41s 1m41s 1 1m41s 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 #7
Day Hour Count Duration Avg duration May 23 19 1 1m41s 1m41s -
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-05-23 19:34:12 Duration: 1m41s
8 1m41s 1m41s 1m41s 1 1m41s 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 May 23 18 1 1m41s 1m41s -
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-05-23 18:47:54 Duration: 1m41s
9 1m18s 1m18s 1m18s 1 1m18s 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 May 23 19 1 1m18s 1m18s -
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-05-23 19:01:19 Duration: 1m18s
10 1m12s 1m12s 1m12s 1 1m12s 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 May 23 18 1 1m12s 1m12s -
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-05-23 18:15:17 Duration: 1m12s
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 May 23 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-05-23 18:16:22 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 May 23 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-05-23 19:02:23 Duration: 1m4s
13 58s99ms 58s99ms 58s99ms 1 58s99ms copy pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 23 18 1 58s99ms 58s99ms -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 18:58:16 Duration: 58s99ms
14 54s817ms 54s817ms 54s817ms 1 54s817ms 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 May 23 18 1 54s817ms 54s817ms -
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-05-23 18:13:55 Duration: 54s817ms
15 54s805ms 54s805ms 54s805ms 1 54s805ms 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 #15
Day Hour Count Duration Avg duration May 23 18 1 54s805ms 54s805ms -
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-05-23 18:59:51 Duration: 54s805ms
16 50s370ms 50s370ms 50s370ms 1 50s370ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 23 19 1 50s370ms 50s370ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 19:35:35 Duration: 50s370ms
17 48s905ms 49s946ms 49s425ms 2 1m38s 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 #17
Day Hour Count Duration Avg duration May 23 01 2 1m38s 49s425ms [ User: pubeu - Total duration: 1m38s - 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:50 Duration: 49s946ms 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 = '2128750') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-05-23 01:02:52 Duration: 48s905ms Database: ctdprd51 User: pubeu Bind query: yes
18 46s868ms 46s868ms 46s868ms 1 46s868ms 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, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 23 18 1 46s868ms 46s868ms -
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, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-05-23 18:49:14 Duration: 46s868ms
19 45s676ms 45s676ms 45s676ms 1 45s676ms copy pub2.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 May 23 19 1 45s676ms 45s676ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-05-23 19:31:29 Duration: 45s676ms
20 45s436ms 45s436ms 45s436ms 1 45s436ms copy pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 23 19 1 45s436ms 45s436ms -
COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-05-23 19:44:18 Duration: 45s436ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 7,643 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1 Max number of times the same event was reported
- 1 Total events found
Rank Times reported Error 1 1 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #1
Day Hour Count May 23 04 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x00
Context: unnamed portal parameter $1
Statement: SELECT /* ObjectIdDAOImpl.LabelsAndAccs */ t.id ,t.nm ,t.nm_sort nmSort ,t.acc_txt acc ,t.acc_db_cd accDbCd FROM term t ,(SELECT li.term_id FROM term_label li WHERE UPPER(li.nm) = $1 AND li.object_type_id = 2 UNION SELECT l.object_id FROM db_link l WHERE upper( l.acc_txt ) = $2 AND l.object_type_id = 2 AND l.type_cd = 'A') ids WHERE t.id = ids.term_id ORDER BY CASE WHEN UPPER(t.nm) = $3 THEN 1 ELSE 2 END ,t.nm_sortDate: 2026-05-23 04:45:26 Database: ctdprd51 Application: User: pubeu Remote: