pgBadger-
Global information
- Generated on Mon Jan 12 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260111
- Parsed 15,618 log entries in 3s
- Log start from 2026-01-11 00:00:01 to 2026-01-11 23:52:32
-
Overview
Global Stats
- 57 Number of unique normalized queries
- 58 Number of queries
- 1h43m42s Total query duration
- 2026-01-11 00:09:12 First query
- 2026-01-11 19:45:58 Last query
- 1 queries/s at 2026-01-11 05:48:47 Query peak
- 1h43m42s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h43m42s Execute total duration
- 4 Number of events
- 1 Number of unique normalized events
- 4 Max number of times the same event was reported
- 0 Number of cancellation
- 3 Total number of automatic vacuums
- 18 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,900 Total number of sessions
- 46 sessions at 2026-01-11 01:15:11 Session peak
- 47d16h55m56s Total duration of sessions
- 36m9s Average duration of sessions
- 0 Average queries per session
- 3s274ms Average queries duration per session
- 36m6s Average idle time per session
- 1,897 Total number of connections
- 9 connections/s at 2026-01-11 05:45:09 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-11 05:48:47 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-11 05:48:47 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-11 18:10:36 Date
Queries duration
Key values
- 1h43m42s 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 11 00 2 0ms 9m11s 4m38s 0ms 0ms 9m17s 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 5s232ms 5s227ms 0ms 0ms 5s232ms 06 1 0ms 5s947ms 5s947ms 0ms 0ms 5s947ms 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 32 0ms 26m3s 1m31s 1m25s 1m55s 26m3s 19 21 0ms 26m9s 2m10s 1m40s 7m58s 26m9s 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 11 00 1 0 9m11s 0ms 0ms 9m11s 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 5s227ms 0ms 0ms 5s232ms 06 1 0 5s947ms 0ms 0ms 5s947ms 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 32 1m31s 1m2s 1m25s 26m3s 19 0 21 2m10s 56s603ms 1m40s 26m9s 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 11 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 11 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 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 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 0 0.00 0.00% Day Hour Count Average / Second Jan 11 00 82 0.02/s 01 81 0.02/s 02 78 0.02/s 03 81 0.02/s 04 78 0.02/s 05 96 0.03/s 06 78 0.02/s 07 76 0.02/s 08 73 0.02/s 09 85 0.02/s 10 77 0.02/s 11 76 0.02/s 12 78 0.02/s 13 73 0.02/s 14 79 0.02/s 15 79 0.02/s 16 79 0.02/s 17 74 0.02/s 18 83 0.02/s 19 80 0.02/s 20 79 0.02/s 21 75 0.02/s 22 77 0.02/s 23 80 0.02/s Day Hour Count Average Duration Average idle time Jan 11 00 82 29m44s 29m37s 01 81 28m42s 28m42s 02 78 31m43s 31m43s 03 81 30m30s 30m30s 04 78 30m52s 30m52s 05 96 25m8s 25m8s 06 78 30m54s 30m54s 07 76 30m54s 30m54s 08 73 32m11s 32m11s 09 85 28m52s 28m52s 10 77 30m15s 30m15s 11 76 31m24s 31m24s 12 77 31m29s 31m29s 13 73 31m23s 31m23s 14 83 2h43m12s 2h43m12s 15 79 30m36s 30m36s 16 79 30m57s 30m57s 17 74 31m11s 31m11s 18 82 30m9s 29m34s 19 81 30m26s 29m52s 20 79 30m29s 30m29s 21 75 30m24s 30m24s 22 77 30m45s 30m45s 23 80 30m37s 30m37s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-01-11 05:45:09 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,897 connections Total
Connections per user
Key values
- pubeu Main User
- 1,897 connections Total
-
Sessions
Simultaneous sessions
Key values
- 46 sessions Session Peak
- 2026-01-11 01:15:11 Date
Histogram of session times
Key values
- 1,805 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,900 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,900 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,900 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 63,047 buffers Checkpoint Peak
- 2026-01-11 23:49:20 Date
- 1619.674 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-01-11 08:52:32 Date
Checkpoints distance
Key values
- 1,190.28 Mo Distance Peak
- 2026-01-11 23:49:20 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 11 00 279 28.124s 0.003s 28.196s 01 90 9.191s 0.002s 9.224s 02 1,036 103.934s 0.002s 104.02s 03 119 12.101s 0.002s 12.133s 04 5,868 587.602s 0.001s 587.636s 05 14,745 1,476.091s 0.005s 1,476.25s 06 159 16.097s 0.002s 16.127s 07 1,738 174.241s 0.003s 174.321s 08 237 23.921s 0.002s 23.952s 09 476 47.754s 0.002s 47.785s 10 148 15.001s 0.002s 15.031s 11 184 18.606s 0.002s 18.636s 12 67 6.883s 0.002s 6.914s 13 23 2.478s 0.002s 2.508s 14 496 49.845s 0.002s 49.875s 15 24 2.571s 0.002s 2.599s 16 10 1.087s 0.001s 1.102s 17 32 3.372s 0.002s 3.402s 18 127 12.954s 0.002s 12.985s 19 393 39.541s 0.003s 39.572s 20 45 4.678s 0.002s 4.708s 21 165 16.708s 0.002s 16.738s 22 82 8.39s 0.002s 8.42s 23 63,078 1,622.866s 0.002s 1,623.059s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 11 00 0 0 0 55 0.001s 0.002s 01 0 0 0 24 0.001s 0.002s 02 0 1 0 35 0.001s 0.002s 03 0 0 0 29 0.001s 0.002s 04 0 4 0 27 0.001s 0.001s 05 0 7 0 66 0.001s 0.003s 06 0 0 0 65 0.001s 0.002s 07 0 1 0 128 0.001s 0.002s 08 0 0 0 98 0.001s 0.002s 09 0 0 0 118 0.001s 0.002s 10 0 0 0 31 0.001s 0.002s 11 0 0 0 63 0.001s 0.002s 12 0 0 0 50 0.001s 0.002s 13 0 0 0 15 0.001s 0.002s 14 0 0 0 23 0.001s 0.002s 15 0 0 0 16 0.001s 0.002s 16 0 0 0 8 0.001s 0.001s 17 0 0 0 16 0.001s 0.002s 18 0 0 0 30 0.001s 0.002s 19 0 0 0 23 0.001s 0.002s 20 0 0 0 19 0.001s 0.002s 21 0 0 0 28 0.001s 0.002s 22 0 0 0 18 0.001s 0.002s 23 0 37 0 40 0.001s 0.002s Day Hour Count Avg time (sec) Jan 11 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 11 00 1,125.50 kB 2,112.50 kB 01 176.00 kB 1,731.50 kB 02 4,107.50 kB 7,514.50 kB 03 211.50 kB 6,138.00 kB 04 62,501.00 kB 62,501.00 kB 05 37,422.33 kB 59,383.00 kB 06 324.50 kB 47,217.50 kB 07 7,100.50 kB 39,540.00 kB 08 643.50 kB 32,193.50 kB 09 1,332.50 kB 26,297.50 kB 10 266.50 kB 21,416.50 kB 11 535.00 kB 17,407.00 kB 12 189.50 kB 14,179.00 kB 13 44.50 kB 11,493.00 kB 14 1,508.00 kB 9,596.50 kB 15 45.50 kB 7,781.50 kB 16 42.00 kB 6,641.00 kB 17 51.00 kB 5,686.00 kB 18 248.00 kB 4,653.50 kB 19 89.00 kB 3,782.50 kB 20 93.50 kB 3,082.50 kB 21 291.00 kB 2,535.00 kB 22 98.50 kB 2,090.00 kB 23 304,760.50 kB 578,956.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 11 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
- 2.40 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-01-11 23:00:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 2.40 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-01-11 23:00:26 Date
Analyzes per table
Key values
- pubc.log_query (14) Main table analyzed (database ctdprd51)
- 18 analyzes Total
Vacuums per table
Key values
- pub2.term_set_enrichment (1) Main table vacuumed on database ctdprd51
- 3 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pub2.term_set_enrichment 1 0 1,607 0 433 0 0 765 2 59,838 ctdprd51.pub2.term_set_enrichment_agent 1 0 61,193 0 7,899 0 0 30,558 3 1,823,002 ctdprd51.pubc.log_query 1 1 198 0 13 0 0 46 11 78,818 Total 3 1 62,998 25 8,345 0 0 31,369 16 1,961,658 Tuples removed per table
Key values
- pubc.log_query (9) Main table with removed tuples on database ctdprd51
- 9 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 11 00 0 0 01 0 1 02 0 1 03 0 2 04 0 1 05 1 5 06 0 0 07 0 1 08 0 0 09 0 2 10 0 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 1 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 2 2 - 2.40 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
- 4 Total read queries
- 53 Total write queries
Queries by database
Key values
- unknown Main database
- 53 Requests
- 1h33m56s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 106 Requests
User Request type Count Duration postgres Total 2 36s2ms copy to 2 36s2ms pubc Total 1 9m11s select 1 9m11s pubeu Total 7 55s322ms select 7 55s322ms qaeu Total 2 10s565ms select 2 10s565ms unknown Total 106 3h7m50s copy to 104 3h7m38s others 1 6s606ms select 1 5s399ms Duration by user
Key values
- 3h7m50s (unknown) Main time consuming user
User Request type Count Duration postgres Total 2 36s2ms copy to 2 36s2ms pubc Total 1 9m11s select 1 9m11s pubeu Total 7 55s322ms select 7 55s322ms qaeu Total 2 10s565ms select 2 10s565ms unknown Total 106 3h7m50s copy to 104 3h7m38s others 1 6s606ms select 1 5s399ms Queries by host
Key values
- unknown Main host
- 118 Requests
- 3h18m43s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 56 Requests
- 1h34m13s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-11 15:32:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 42 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 26m9s 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-11 19:29:30 ]
2 26m3s 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-11 18:43:28 ]
3 9m11s /* * 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-11 00:09:12 - Database: ctdprd51 - User: pubc - Application: psql ]
4 7m29s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-11 19:42:23 ]
5 7m25s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-11 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-11 19:45:19 ]
7 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-11 19:32:55 ]
8 1m39s 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-11 18:46:52 ]
9 1m23s COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-11 18:58:07 ]
10 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-11 19:01:01 ]
11 1m11s 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-11 18:15:05 ]
12 1m4s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-11 19:02:06 ]
13 1m4s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-11 18:16:10 ]
14 54s305ms 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-11 18:13:45 ]
15 53s685ms 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-11 18:59:40 ]
16 44s384ms 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-11 19:34:12 ]
17 44s338ms 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-11 18:48:09 ]
18 42s110ms 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-11 19:03:20 ]
19 41s770ms 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-11 18:17:24 ]
20 40s792ms 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-11 19:34:53 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m9s 1 26m9s 26m9s 26m9s 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 11 19 1 26m9s 26m9s -
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-11 19:29:30 Duration: 26m9s
2 26m3s 1 26m3s 26m3s 26m3s 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 11 18 1 26m3s 26m3s -
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-11 18:43:28 Duration: 26m3s
3 9m11s 1 9m11s 9m11s 9m11s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s [ User: pubc - Total duration: 9m11s - Times executed: 1 ]
[ Application: psql - Total duration: 9m11s - 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-11 00:09:12 Duration: 9m11s Database: ctdprd51 User: pubc Application: psql
4 7m29s 1 7m29s 7m29s 7m29s 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 11 19 1 7m29s 7m29s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
5 7m25s 1 7m25s 7m25s 7m25s 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 11 18 1 7m25s 7m25s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:56:16 Duration: 7m25s
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 11 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-11 19:45:19 Duration: 1m49s
7 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 #7
Day Hour Count Duration Avg duration Jan 11 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-11 19:32:55 Duration: 1m40s
8 1m39s 1 1m39s 1m39s 1m39s 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 Jan 11 18 1 1m39s 1m39s -
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-11 18:46:52 Duration: 1m39s
9 1m23s 1 1m23s 1m23s 1m23s 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 11 18 1 1m23s 1m23s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:58:07 Duration: 1m23s
10 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 #10
Day Hour Count Duration Avg duration Jan 11 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-11 19:01:01 Duration: 1m12s
11 1m11s 1 1m11s 1m11s 1m11s 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 Jan 11 18 1 1m11s 1m11s -
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-11 18:15:05 Duration: 1m11s
12 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 #12
Day Hour Count Duration Avg duration Jan 11 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-01-11 19:02:06 Duration: 1m4s
13 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 #13
Day Hour Count Duration Avg duration Jan 11 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-11 18:16:10 Duration: 1m4s
14 54s305ms 1 54s305ms 54s305ms 54s305ms 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 11 18 1 54s305ms 54s305ms -
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-11 18:13:45 Duration: 54s305ms
15 53s685ms 1 53s685ms 53s685ms 53s685ms 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 11 18 1 53s685ms 53s685ms -
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-11 18:59:40 Duration: 53s685ms
16 44s384ms 1 44s384ms 44s384ms 44s384ms 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 11 19 1 44s384ms 44s384ms -
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-11 19:34:12 Duration: 44s384ms
17 44s338ms 1 44s338ms 44s338ms 44s338ms 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 11 18 1 44s338ms 44s338ms -
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-11 18:48:09 Duration: 44s338ms
18 42s110ms 1 42s110ms 42s110ms 42s110ms 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 11 19 1 42s110ms 42s110ms -
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-11 19:03:20 Duration: 42s110ms
19 41s770ms 1 41s770ms 41s770ms 41s770ms 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 11 18 1 41s770ms 41s770ms -
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-11 18:17:24 Duration: 41s770ms
20 40s792ms 1 40s792ms 40s792ms 40s792ms 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 11 19 1 40s792ms 40s792ms -
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-11 19:34:53 Duration: 40s792ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 10s455ms 5s223ms 5s232ms 5s227ms 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 #1
Day Hour Count Duration Avg duration Jan 11 05 2 10s455ms 5s227ms [ User: qaeu - Total duration: 5s232ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s223ms - 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-11 05:43:39 Duration: 5s232ms 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-11 05:48:47 Duration: 5s223ms Database: ctdprd51 User: pubeu Bind query: yes
2 1 26m9s 26m9s 26m9s 26m9s 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 #2
Day Hour Count Duration Avg duration Jan 11 19 1 26m9s 26m9s -
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-11 19:29:30 Duration: 26m9s
3 1 26m3s 26m3s 26m3s 26m3s 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 #3
Day Hour Count Duration Avg duration Jan 11 18 1 26m3s 26m3s -
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-11 18:43:28 Duration: 26m3s
4 1 9m11s 9m11s 9m11s 9m11s select maint_query_logs_archive ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s [ User: pubc - Total duration: 9m11s - Times executed: 1 ]
[ Application: psql - Total duration: 9m11s - 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-11 00:09:12 Duration: 9m11s Database: ctdprd51 User: pubc Application: psql
5 1 7m29s 7m29s 7m29s 7m29s 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 Jan 11 19 1 7m29s 7m29s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
6 1 7m25s 7m25s 7m25s 7m25s 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 Jan 11 18 1 7m25s 7m25s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:56:16 Duration: 7m25s
7 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 #7
Day Hour Count Duration Avg duration Jan 11 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-11 19:45:19 Duration: 1m49s
8 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 #8
Day Hour Count Duration Avg duration Jan 11 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-11 19:32:55 Duration: 1m40s
9 1 1m39s 1m39s 1m39s 1m39s 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 #9
Day Hour Count Duration Avg duration Jan 11 18 1 1m39s 1m39s -
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-11 18:46:52 Duration: 1m39s
10 1 1m23s 1m23s 1m23s 1m23s 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 #10
Day Hour Count Duration Avg duration Jan 11 18 1 1m23s 1m23s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:58:07 Duration: 1m23s
11 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 #11
Day Hour Count Duration Avg duration Jan 11 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-11 19:01:01 Duration: 1m12s
12 1 1m11s 1m11s 1m11s 1m11s 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 Jan 11 18 1 1m11s 1m11s -
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-11 18:15:05 Duration: 1m11s
13 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 #13
Day Hour Count Duration Avg duration Jan 11 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-01-11 19:02:06 Duration: 1m4s
14 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 #14
Day Hour Count Duration Avg duration Jan 11 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-11 18:16:10 Duration: 1m4s
15 1 54s305ms 54s305ms 54s305ms 54s305ms 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 Jan 11 18 1 54s305ms 54s305ms -
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-11 18:13:45 Duration: 54s305ms
16 1 53s685ms 53s685ms 53s685ms 53s685ms 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 Jan 11 18 1 53s685ms 53s685ms -
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-11 18:59:40 Duration: 53s685ms
17 1 44s384ms 44s384ms 44s384ms 44s384ms 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 Jan 11 19 1 44s384ms 44s384ms -
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-11 19:34:12 Duration: 44s384ms
18 1 44s338ms 44s338ms 44s338ms 44s338ms 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 Jan 11 18 1 44s338ms 44s338ms -
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-11 18:48:09 Duration: 44s338ms
19 1 42s110ms 42s110ms 42s110ms 42s110ms 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 #19
Day Hour Count Duration Avg duration Jan 11 19 1 42s110ms 42s110ms -
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-11 19:03:20 Duration: 42s110ms
20 1 41s770ms 41s770ms 41s770ms 41s770ms 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 #20
Day Hour Count Duration Avg duration Jan 11 18 1 41s770ms 41s770ms -
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-11 18:17:24 Duration: 41s770ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m9s 26m9s 26m9s 1 26m9s 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 11 19 1 26m9s 26m9s -
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-11 19:29:30 Duration: 26m9s
2 26m3s 26m3s 26m3s 1 26m3s 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 11 18 1 26m3s 26m3s -
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-11 18:43:28 Duration: 26m3s
3 9m11s 9m11s 9m11s 1 9m11s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s [ User: pubc - Total duration: 9m11s - Times executed: 1 ]
[ Application: psql - Total duration: 9m11s - 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-11 00:09:12 Duration: 9m11s Database: ctdprd51 User: pubc Application: psql
4 7m29s 7m29s 7m29s 1 7m29s 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 11 19 1 7m29s 7m29s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
5 7m25s 7m25s 7m25s 1 7m25s 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 11 18 1 7m25s 7m25s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:56:16 Duration: 7m25s
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 11 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-11 19:45:19 Duration: 1m49s
7 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 #7
Day Hour Count Duration Avg duration Jan 11 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-11 19:32:55 Duration: 1m40s
8 1m39s 1m39s 1m39s 1 1m39s 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 Jan 11 18 1 1m39s 1m39s -
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-11 18:46:52 Duration: 1m39s
9 1m23s 1m23s 1m23s 1 1m23s 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 11 18 1 1m23s 1m23s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:58:07 Duration: 1m23s
10 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 #10
Day Hour Count Duration Avg duration Jan 11 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-11 19:01:01 Duration: 1m12s
11 1m11s 1m11s 1m11s 1 1m11s 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 Jan 11 18 1 1m11s 1m11s -
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-11 18:15:05 Duration: 1m11s
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 Jan 11 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-01-11 19:02:06 Duration: 1m4s
13 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 #13
Day Hour Count Duration Avg duration Jan 11 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-11 18:16:10 Duration: 1m4s
14 54s305ms 54s305ms 54s305ms 1 54s305ms 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 11 18 1 54s305ms 54s305ms -
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-11 18:13:45 Duration: 54s305ms
15 53s685ms 53s685ms 53s685ms 1 53s685ms 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 11 18 1 53s685ms 53s685ms -
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-11 18:59:40 Duration: 53s685ms
16 44s384ms 44s384ms 44s384ms 1 44s384ms 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 11 19 1 44s384ms 44s384ms -
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-11 19:34:12 Duration: 44s384ms
17 44s338ms 44s338ms 44s338ms 1 44s338ms 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 11 18 1 44s338ms 44s338ms -
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-11 18:48:09 Duration: 44s338ms
18 42s110ms 42s110ms 42s110ms 1 42s110ms 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 11 19 1 42s110ms 42s110ms -
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-11 19:03:20 Duration: 42s110ms
19 41s770ms 41s770ms 41s770ms 1 41s770ms 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 11 18 1 41s770ms 41s770ms -
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-11 18:17:24 Duration: 41s770ms
20 40s792ms 40s792ms 40s792ms 1 40s792ms 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 11 19 1 40s792ms 40s792ms -
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-11 19:34:53 Duration: 40s792ms
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,773 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
- 4 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4 Max number of times the same event was reported
- 4 Total events found
Rank Times reported Error 1 4 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 11 14 4