pgBadger-
Global information
- Generated on Sun Jan 11 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260110
- Parsed 15,845 log entries in 3s
- Log start from 2026-01-10 00:00:19 to 2026-01-10 23:59:58
-
Overview
Global Stats
- 59 Number of unique normalized queries
- 62 Number of queries
- 1h44m16s Total query duration
- 2026-01-10 00:09:28 First query
- 2026-01-10 19:45:56 Last query
- 1 queries/s at 2026-01-10 18:59:39 Query peak
- 1h44m16s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h44m16s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 Max number of times the same event was reported
- 0 Number of cancellation
- 1 Total number of automatic vacuums
- 14 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,928 Total number of sessions
- 55 sessions at 2026-01-10 03:03:12 Session peak
- 40d2h32m35s Total duration of sessions
- 29m57s Average duration of sessions
- 0 Average queries per session
- 3s245ms Average queries duration per session
- 29m54s Average idle time per session
- 1,928 Total number of connections
- 9 connections/s at 2026-01-10 05:45:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-10 18:59:39 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-10 00:09:28 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-10 18:59:39 Date
Queries duration
Key values
- 1h44m16s 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) Jan 10 00 2 0ms 9m9s 4m37s 0ms 0ms 9m15s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s333ms 5s276ms 0ms 5s219ms 5s333ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 4 0ms 14s843ms 9s751ms 0ms 0ms 24s161ms 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 1 0ms 5s326ms 5s326ms 0ms 0ms 5s326ms 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 32 0ms 26m4s 1m31s 1m24s 1m54s 26m4s 19 21 0ms 26m11s 2m10s 1m25s 2m28s 26m11s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 10 00 1 0 9m9s 0ms 0ms 9m9s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s276ms 0ms 0ms 5s333ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 4 0 9s751ms 0ms 0ms 24s161ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 5s326ms 0ms 0ms 5s326ms 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 32 1m31s 1m1s 1m24s 26m4s 19 0 21 2m10s 41s959ms 1m25s 26m11s 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 10 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 Jan 10 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 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 4 4.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 1 1.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 0 0.00 0.00% Day Hour Count Average / Second Jan 10 00 80 0.02/s 01 78 0.02/s 02 79 0.02/s 03 77 0.02/s 04 80 0.02/s 05 92 0.03/s 06 78 0.02/s 07 73 0.02/s 08 109 0.03/s 09 89 0.02/s 10 77 0.02/s 11 76 0.02/s 12 79 0.02/s 13 75 0.02/s 14 72 0.02/s 15 78 0.02/s 16 81 0.02/s 17 78 0.02/s 18 83 0.02/s 19 77 0.02/s 20 78 0.02/s 21 79 0.02/s 22 78 0.02/s 23 82 0.02/s Day Hour Count Average Duration Average idle time Jan 10 00 80 30m30s 30m23s 01 78 30m59s 30m59s 02 79 31m11s 31m11s 03 77 30m51s 30m51s 04 80 30m54s 30m54s 05 92 26m16s 26m16s 06 78 31m1s 31m1s 07 73 31m55s 31m55s 08 109 22m1s 22m1s 09 89 27m38s 27m38s 10 77 30m5s 30m5s 11 76 30m41s 30m41s 12 79 30m57s 30m57s 13 75 31m14s 31m14s 14 72 30m38s 30m38s 15 78 31m28s 31m28s 16 81 30m40s 30m40s 17 78 31m4s 31m4s 18 82 29m53s 29m17s 19 78 31m41s 31m6s 20 78 30m45s 30m45s 21 79 29m46s 29m46s 22 78 31m15s 31m15s 23 82 29m40s 29m40s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-01-10 05:45:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,928 connections Total
Connections per user
Key values
- pubeu Main User
- 1,928 connections Total
-
Sessions
Simultaneous sessions
Key values
- 55 sessions Session Peak
- 2026-01-10 03:03:12 Date
Histogram of session times
Key values
- 1,817 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,928 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,928 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,928 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 1,110 buffers Checkpoint Peak
- 2026-01-10 19:54:05 Date
- 111.245 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-01-10 20:52:15 Date
Checkpoints distance
Key values
- 4.69 Mo Distance Peak
- 2026-01-10 00:22:44 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 10 00 318 32.018s 0.003s 32.089s 01 141 14.097s 0.002s 14.128s 02 135 13.687s 0.002s 13.716s 03 128 12.989s 0.002s 13.018s 04 104 10.607s 0.002s 10.637s 05 145 14.707s 0.002s 14.739s 06 64 6.574s 0.002s 6.606s 07 120 12.196s 0.002s 12.227s 08 71 7.278s 0.002s 7.307s 09 416 41.839s 0.002s 41.87s 10 73 7.48s 0.002s 7.51s 11 114 11.601s 0.002s 11.632s 12 50 5.175s 0.002s 5.205s 13 46 4.766s 0.002s 4.794s 14 44 4.566s 0.002s 4.596s 15 109 11.091s 0.003s 11.121s 16 62 6.369s 0.002s 6.399s 17 26 2.763s 0.002s 2.794s 18 31 3.375s 0.002s 3.406s 19 1,148 115.185s 0.002s 115.214s 20 50 5.177s 0.002s 5.207s 21 38 3.983s 0.002s 4.012s 22 112 11.386s 0.002s 11.417s 23 49 5.087s 0.002s 5.118s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 10 00 0 0 0 62 0.001s 0.002s 01 0 0 0 31 0.001s 0.002s 02 0 0 0 32 0.001s 0.002s 03 0 0 0 30 0.001s 0.002s 04 0 0 0 29 0.001s 0.002s 05 0 0 0 35 0.001s 0.002s 06 0 0 0 18 0.001s 0.002s 07 0 0 0 29 0.001s 0.002s 08 0 0 0 20 0.001s 0.002s 09 0 0 0 39 0.001s 0.002s 10 0 0 0 24 0.001s 0.002s 11 0 0 0 26 0.001s 0.002s 12 0 0 0 18 0.001s 0.002s 13 0 0 0 21 0.001s 0.002s 14 0 0 0 18 0.001s 0.002s 15 0 0 0 28 0.001s 0.002s 16 0 0 0 22 0.001s 0.002s 17 0 0 0 16 0.001s 0.002s 18 0 0 0 13 0.001s 0.002s 19 0 0 0 18 0.001s 0.002s 20 0 0 0 17 0.001s 0.002s 21 0 0 0 18 0.001s 0.002s 22 0 0 0 26 0.001s 0.002s 23 0 0 0 20 0.001s 0.002s Day Hour Count Avg time (sec) Jan 10 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 Jan 10 00 1,221.50 kB 27,872.00 kB 01 167.00 kB 22,596.50 kB 02 313.00 kB 18,362.50 kB 03 213.00 kB 14,911.50 kB 04 206.50 kB 12,131.50 kB 05 416.00 kB 9,873.00 kB 06 108.50 kB 8,048.00 kB 07 243.00 kB 6,551.50 kB 08 85.00 kB 5,337.00 kB 09 1,136.50 kB 4,513.00 kB 10 102.00 kB 3,700.00 kB 11 238.50 kB 3,044.50 kB 12 66.00 kB 2,478.00 kB 13 52.00 kB 2,016.50 kB 14 49.50 kB 1,644.00 kB 15 221.00 kB 1,358.00 kB 16 78.00 kB 1,129.00 kB 17 33.00 kB 923.00 kB 18 33.50 kB 754.00 kB 19 46.50 kB 619.50 kB 20 58.00 kB 512.00 kB 21 75.50 kB 427.50 kB 22 256.50 kB 410.00 kB 23 93.50 kB 349.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 Jan 10 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 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- pubc.log_query (13) Main table analyzed (database ctdprd51)
- 14 analyzes Total
Vacuums per table
Key values
- pubc.log_query (1) Main table vacuumed on database ctdprd51
- 1 vacuums Total
Tuples removed per table
Key values
- pubc.log_query (5) Main table with removed tuples on database ctdprd51
- 5 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 Jan 10 00 0 0 01 0 1 02 0 2 03 0 1 04 0 1 05 1 3 06 0 0 07 0 1 08 0 0 09 0 2 10 0 0 11 0 1 12 0 0 13 0 0 14 0 0 15 0 1 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 - 0 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
- 8 Total read queries
- 53 Total write queries
Queries by database
Key values
- unknown Main database
- 54 Requests
- 1h33m59s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 137 Requests
User Request type Count Duration editeu Total 10 1m58s select 10 1m58s postgres Total 10 9m10s copy to 10 9m10s pubc Total 1 9m9s select 1 9m9s pubeu Total 21 2m36s select 21 2m36s qaeu Total 2 10s547ms select 2 10s547ms unknown Total 137 3h14m26s copy to 132 3h13m56s others 1 6s367ms select 4 24s224ms Duration by user
Key values
- 3h14m26s (unknown) Main time consuming user
User Request type Count Duration editeu Total 10 1m58s select 10 1m58s postgres Total 10 9m10s copy to 10 9m10s pubc Total 1 9m9s select 1 9m9s pubeu Total 21 2m36s select 21 2m36s qaeu Total 2 10s547ms select 2 10s547ms unknown Total 137 3h14m26s copy to 132 3h13m56s others 1 6s367ms select 4 24s224ms Queries by host
Key values
- unknown Main host
- 181 Requests
- 3h37m32s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 60 Requests
- 1h34m49s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-10 18:05:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 44 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 26m11s 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-01-10 19:29:31 ]
2 26m4s 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-01-10 18:43:30 ]
3 9m9s /* * 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-01-10 00:09:28 - Database: ctdprd51 - User: pubc - Application: psql ]
4 7m26s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-10 19:42:22 ]
5 7m22s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-10 18:56:16 ]
6 1m49s 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-01-10 19:45:17 ]
7 1m40s 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-01-10 18:46:55 ]
8 1m40s 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-01-10 19:32:56 ]
9 1m22s COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-10 18:58:06 ]
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-01-10 18:15:07 ]
11 1m12s 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-01-10 19:01:00 ]
12 1m4s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-10 18:16:12 ]
13 1m3s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-10 19:02:04 ]
14 54s628ms 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-01-10 18:13:45 ]
15 53s578ms 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-01-10 18:59:39 ]
16 44s576ms 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-01-10 19:34:13 ]
17 44s253ms 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-01-10 18:48:12 ]
18 41s959ms COPY pub2.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;[ Date: 2026-01-10 19:03:19 ]
19 41s524ms COPY pub1.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;[ Date: 2026-01-10 18:17:25 ]
20 40s795ms COPY pub2.term_enrichment (term_id, enriched_term_id, object_type_id, enriched_object_type_id, raw_p_val, corrected_p_val, target_match_qty, target_mismatch_qty, target_total_qty, control_match_qty, control_mismatch_qty, control_total_qty, background_match_qty, background_mismatch_qty, background_total_qty) TO stdout;[ Date: 2026-01-10 19:34:55 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m11s 1 26m11s 26m11s 26m11s 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 Jan 10 19 1 26m11s 26m11s -
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-01-10 19:29:31 Duration: 26m11s
2 26m4s 1 26m4s 26m4s 26m4s 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 Jan 10 18 1 26m4s 26m4s -
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-01-10 18:43:30 Duration: 26m4s
3 9m9s 1 9m9s 9m9s 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 10 00 1 9m9s 9m9s [ User: pubc - Total duration: 9m9s - Times executed: 1 ]
[ Application: psql - Total duration: 9m9s - 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-01-10 00:09:28 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
4 7m26s 1 7m26s 7m26s 7m26s 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 Jan 10 19 1 7m26s 7m26s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 19:42:22 Duration: 7m26s
5 7m22s 1 7m22s 7m22s 7m22s 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 Jan 10 18 1 7m22s 7m22s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:56:16 Duration: 7m22s
6 1m49s 1 1m49s 1m49s 1m49s 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 Jan 10 19 1 1m49s 1m49s -
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-01-10 19:45:17 Duration: 1m49s
7 1m40s 1 1m40s 1m40s 1m40s 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 Jan 10 18 1 1m40s 1m40s -
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-01-10 18:46:55 Duration: 1m40s
8 1m40s 1 1m40s 1m40s 1m40s 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 Jan 10 19 1 1m40s 1m40s -
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-01-10 19:32:56 Duration: 1m40s
9 1m22s 1 1m22s 1m22s 1m22s 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 #9
Day Hour Count Duration Avg duration Jan 10 18 1 1m22s 1m22s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:58:06 Duration: 1m22s
10 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 #10
Day Hour Count Duration Avg duration Jan 10 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-01-10 18:15:07 Duration: 1m12s
11 1m12s 1 1m12s 1m12s 1m12s 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 Jan 10 19 1 1m12s 1m12s -
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-01-10 19:01:00 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 Jan 10 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-01-10 18:16:12 Duration: 1m4s
13 1m3s 1 1m3s 1m3s 1m3s 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 Jan 10 19 1 1m3s 1m3s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-10 19:02:04 Duration: 1m3s
14 54s628ms 1 54s628ms 54s628ms 54s628ms 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 Jan 10 18 1 54s628ms 54s628ms -
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-01-10 18:13:45 Duration: 54s628ms
15 53s578ms 1 53s578ms 53s578ms 53s578ms 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 Jan 10 18 1 53s578ms 53s578ms -
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-01-10 18:59:39 Duration: 53s578ms
16 44s576ms 1 44s576ms 44s576ms 44s576ms 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 Jan 10 19 1 44s576ms 44s576ms -
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-01-10 19:34:13 Duration: 44s576ms
17 44s253ms 1 44s253ms 44s253ms 44s253ms 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 #17
Day Hour Count Duration Avg duration Jan 10 18 1 44s253ms 44s253ms -
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-01-10 18:48:12 Duration: 44s253ms
18 41s959ms 1 41s959ms 41s959ms 41s959ms copy pub2.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 10 19 1 41s959ms 41s959ms -
COPY pub2.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;
Date: 2026-01-10 19:03:19 Duration: 41s959ms
19 41s524ms 1 41s524ms 41s524ms 41s524ms copy pub1.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 10 18 1 41s524ms 41s524ms -
COPY pub1.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;
Date: 2026-01-10 18:17:25 Duration: 41s524ms
20 40s795ms 1 40s795ms 40s795ms 40s795ms copy pub2.term_enrichment (term_id, enriched_term_id, object_type_id, enriched_object_type_id, raw_p_val, corrected_p_val, target_match_qty, target_mismatch_qty, target_total_qty, control_match_qty, control_mismatch_qty, control_total_qty, background_match_qty, background_mismatch_qty, background_total_qty) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 10 19 1 40s795ms 40s795ms -
COPY pub2.term_enrichment (term_id, enriched_term_id, object_type_id, enriched_object_type_id, raw_p_val, corrected_p_val, target_match_qty, target_mismatch_qty, target_total_qty, control_match_qty, control_mismatch_qty, control_total_qty, background_match_qty, background_mismatch_qty, background_total_qty) TO stdout;
Date: 2026-01-10 19:34:55 Duration: 40s795ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 28s355ms 13s511ms 14s843ms 14s177ms 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 Jan 10 08 2 28s355ms 14s177ms [ User: pubeu - Total duration: 28s355ms - 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 = '2120593') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-10 08:39:02 Duration: 14s843ms 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 = '2120593') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-10 08:38:12 Duration: 13s511ms Database: ctdprd51 User: pubeu Bind query: yes
2 2 10s649ms 5s249ms 5s399ms 5s324ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ? offset ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 10 08 2 10s649ms 5s324ms [ User: pubeu - Total duration: 5s249ms - Times executed: 1 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2120593') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 1350;
Date: 2026-01-10 08:38:36 Duration: 5s399ms 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 = '2120593') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 1200;
Date: 2026-01-10 08:38:17 Duration: 5s249ms Database: ctdprd51 User: pubeu Bind query: yes
3 2 10s552ms 5s219ms 5s333ms 5s276ms 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 #3
Day Hour Count Duration Avg duration Jan 10 05 2 10s552ms 5s276ms [ User: qaeu - Total duration: 5s333ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s219ms - 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 = 1332236)) 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-01-10 05:43:42 Duration: 5s333ms 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 = 1332236)) 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-01-10 05:48:46 Duration: 5s219ms Database: ctdprd51 User: pubeu Bind query: yes
4 1 26m11s 26m11s 26m11s 26m11s 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 #4
Day Hour Count Duration Avg duration Jan 10 19 1 26m11s 26m11s -
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-01-10 19:29:31 Duration: 26m11s
5 1 26m4s 26m4s 26m4s 26m4s 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 #5
Day Hour Count Duration Avg duration Jan 10 18 1 26m4s 26m4s -
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-01-10 18:43:30 Duration: 26m4s
6 1 9m9s 9m9s 9m9s 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 10 00 1 9m9s 9m9s [ User: pubc - Total duration: 9m9s - Times executed: 1 ]
[ Application: psql - Total duration: 9m9s - 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-01-10 00:09:28 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
7 1 7m26s 7m26s 7m26s 7m26s 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 Jan 10 19 1 7m26s 7m26s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 19:42:22 Duration: 7m26s
8 1 7m22s 7m22s 7m22s 7m22s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 10 18 1 7m22s 7m22s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:56:16 Duration: 7m22s
9 1 1m49s 1m49s 1m49s 1m49s 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 #9
Day Hour Count Duration Avg duration Jan 10 19 1 1m49s 1m49s -
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-01-10 19:45:17 Duration: 1m49s
10 1 1m40s 1m40s 1m40s 1m40s 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 Jan 10 18 1 1m40s 1m40s -
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-01-10 18:46:55 Duration: 1m40s
11 1 1m40s 1m40s 1m40s 1m40s 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 #11
Day Hour Count Duration Avg duration Jan 10 19 1 1m40s 1m40s -
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-01-10 19:32:56 Duration: 1m40s
12 1 1m22s 1m22s 1m22s 1m22s 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 #12
Day Hour Count Duration Avg duration Jan 10 18 1 1m22s 1m22s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:58:06 Duration: 1m22s
13 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 #13
Day Hour Count Duration Avg duration Jan 10 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-01-10 18:15:07 Duration: 1m12s
14 1 1m12s 1m12s 1m12s 1m12s 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 #14
Day Hour Count Duration Avg duration Jan 10 19 1 1m12s 1m12s -
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-01-10 19:01:00 Duration: 1m12s
15 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 #15
Day Hour Count Duration Avg duration Jan 10 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-01-10 18:16:12 Duration: 1m4s
16 1 1m3s 1m3s 1m3s 1m3s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 10 19 1 1m3s 1m3s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-10 19:02:04 Duration: 1m3s
17 1 54s628ms 54s628ms 54s628ms 54s628ms 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 #17
Day Hour Count Duration Avg duration Jan 10 18 1 54s628ms 54s628ms -
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-01-10 18:13:45 Duration: 54s628ms
18 1 53s578ms 53s578ms 53s578ms 53s578ms 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 #18
Day Hour Count Duration Avg duration Jan 10 18 1 53s578ms 53s578ms -
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-01-10 18:59:39 Duration: 53s578ms
19 1 44s576ms 44s576ms 44s576ms 44s576ms 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 #19
Day Hour Count Duration Avg duration Jan 10 19 1 44s576ms 44s576ms -
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-01-10 19:34:13 Duration: 44s576ms
20 1 44s253ms 44s253ms 44s253ms 44s253ms 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 #20
Day Hour Count Duration Avg duration Jan 10 18 1 44s253ms 44s253ms -
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-01-10 18:48:12 Duration: 44s253ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m11s 26m11s 26m11s 1 26m11s 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 Jan 10 19 1 26m11s 26m11s -
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-01-10 19:29:31 Duration: 26m11s
2 26m4s 26m4s 26m4s 1 26m4s 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 Jan 10 18 1 26m4s 26m4s -
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-01-10 18:43:30 Duration: 26m4s
3 9m9s 9m9s 9m9s 1 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 10 00 1 9m9s 9m9s [ User: pubc - Total duration: 9m9s - Times executed: 1 ]
[ Application: psql - Total duration: 9m9s - 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-01-10 00:09:28 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
4 7m26s 7m26s 7m26s 1 7m26s 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 Jan 10 19 1 7m26s 7m26s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 19:42:22 Duration: 7m26s
5 7m22s 7m22s 7m22s 1 7m22s 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 Jan 10 18 1 7m22s 7m22s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:56:16 Duration: 7m22s
6 1m49s 1m49s 1m49s 1 1m49s 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 Jan 10 19 1 1m49s 1m49s -
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-01-10 19:45:17 Duration: 1m49s
7 1m40s 1m40s 1m40s 1 1m40s 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 Jan 10 18 1 1m40s 1m40s -
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-01-10 18:46:55 Duration: 1m40s
8 1m40s 1m40s 1m40s 1 1m40s 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 Jan 10 19 1 1m40s 1m40s -
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-01-10 19:32:56 Duration: 1m40s
9 1m22s 1m22s 1m22s 1 1m22s 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 #9
Day Hour Count Duration Avg duration Jan 10 18 1 1m22s 1m22s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-10 18:58:06 Duration: 1m22s
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 Jan 10 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-01-10 18:15:07 Duration: 1m12s
11 1m12s 1m12s 1m12s 1 1m12s 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 Jan 10 19 1 1m12s 1m12s -
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-01-10 19:01:00 Duration: 1m12s
12 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 #12
Day Hour Count Duration Avg duration Jan 10 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-01-10 18:16:12 Duration: 1m4s
13 1m3s 1m3s 1m3s 1 1m3s 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 Jan 10 19 1 1m3s 1m3s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-10 19:02:04 Duration: 1m3s
14 54s628ms 54s628ms 54s628ms 1 54s628ms 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 Jan 10 18 1 54s628ms 54s628ms -
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-01-10 18:13:45 Duration: 54s628ms
15 53s578ms 53s578ms 53s578ms 1 53s578ms 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 Jan 10 18 1 53s578ms 53s578ms -
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-01-10 18:59:39 Duration: 53s578ms
16 44s576ms 44s576ms 44s576ms 1 44s576ms 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 Jan 10 19 1 44s576ms 44s576ms -
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-01-10 19:34:13 Duration: 44s576ms
17 44s253ms 44s253ms 44s253ms 1 44s253ms 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 #17
Day Hour Count Duration Avg duration Jan 10 18 1 44s253ms 44s253ms -
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-01-10 18:48:12 Duration: 44s253ms
18 41s959ms 41s959ms 41s959ms 1 41s959ms copy pub2.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 10 19 1 41s959ms 41s959ms -
COPY pub2.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;
Date: 2026-01-10 19:03:19 Duration: 41s959ms
19 41s524ms 41s524ms 41s524ms 1 41s524ms copy pub1.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 10 18 1 41s524ms 41s524ms -
COPY pub1.gene_disease (gene_id, disease_id, reference_qty, curated_reference_qty, indirect_chem_qty, exposure_reference_qty, network_score) TO stdout;
Date: 2026-01-10 18:17:25 Duration: 41s524ms
20 40s795ms 40s795ms 40s795ms 1 40s795ms copy pub2.term_enrichment (term_id, enriched_term_id, object_type_id, enriched_object_type_id, raw_p_val, corrected_p_val, target_match_qty, target_mismatch_qty, target_total_qty, control_match_qty, control_mismatch_qty, control_total_qty, background_match_qty, background_mismatch_qty, background_total_qty) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 10 19 1 40s795ms 40s795ms -
COPY pub2.term_enrichment (term_id, enriched_term_id, object_type_id, enriched_object_type_id, raw_p_val, corrected_p_val, target_match_qty, target_mismatch_qty, target_total_qty, control_match_qty, control_mismatch_qty, control_total_qty, background_match_qty, background_mismatch_qty, background_total_qty) TO stdout;
Date: 2026-01-10 19:34:55 Duration: 40s795ms
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,895 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
- 0 EVENTLOG entries
Events per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET