pgBadger-
Global information
- Generated on Sun Jan 18 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260117
- Parsed 24,564 log entries in 2s
- Log start from 2026-01-17 00:00:02 to 2026-01-17 23:59:24
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 62 Number of queries
- 1h45m6s Total query duration
- 2026-01-17 00:09:11 First query
- 2026-01-17 22:36:30 Last query
- 1 queries/s at 2026-01-17 18:12:26 Query peak
- 1h45m6s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h45m6s 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
- 3,018 Total number of sessions
- 81 sessions at 2026-01-17 01:11:12 Session peak
- 40d2h28m8s Total duration of sessions
- 19m8s Average duration of sessions
- 0 Average queries per session
- 2s89ms Average queries duration per session
- 19m5s Average idle time per session
- 3,018 Total number of connections
- 49 connections/s at 2026-01-17 01:11:33 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-17 18:12:26 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-17 10:43:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-17 18:12:26 Date
Queries duration
Key values
- 1h45m6s 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 17 00 2 0ms 9m9s 4m38s 0ms 0ms 9m16s 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 5s183ms 5s170ms 0ms 5s157ms 5s183ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 5s30ms 5s30ms 0ms 0ms 5s30ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 2 0ms 7s220ms 6s957ms 0ms 6s695ms 7s220ms 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 30 0ms 26m19s 1m35s 1m29s 7m44s 26m19s 19 23 0ms 26m14s 2m2s 1m22s 2m29s 26m14s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 2 0ms 12s823ms 10s742ms 0ms 8s661ms 12s823ms 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 17 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 5s170ms 0ms 0ms 5s183ms 06 0 0 0ms 0ms 0ms 0ms 07 1 0 5s30ms 0ms 0ms 5s30ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 2 0 6s957ms 0ms 0ms 7s220ms 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 30 1m35s 1m2s 1m29s 26m19s 19 0 23 2m2s 54s207ms 1m22s 26m14s 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 2 0 10s742ms 0ms 0ms 12s823ms 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 17 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 17 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 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 2 2.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 2 2.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jan 17 00 129 0.04/s 01 1,108 0.31/s 02 77 0.02/s 03 80 0.02/s 04 76 0.02/s 05 92 0.03/s 06 102 0.03/s 07 93 0.03/s 08 79 0.02/s 09 79 0.02/s 10 81 0.02/s 11 77 0.02/s 12 78 0.02/s 13 81 0.02/s 14 85 0.02/s 15 81 0.02/s 16 80 0.02/s 17 75 0.02/s 18 80 0.02/s 19 77 0.02/s 20 79 0.02/s 21 73 0.02/s 22 77 0.02/s 23 79 0.02/s Day Hour Count Average Duration Average idle time Jan 17 00 129 18m20s 18m16s 01 1,108 2m17s 2m17s 02 77 31m13s 31m13s 03 80 30m45s 30m45s 04 76 31m19s 31m19s 05 92 26m16s 26m15s 06 102 22m33s 22m33s 07 93 24m38s 24m38s 08 79 30m46s 30m46s 09 79 31m10s 31m10s 10 81 29m39s 29m39s 11 77 30m55s 30m55s 12 78 30m55s 30m55s 13 81 30m38s 30m38s 14 85 28m55s 28m55s 15 81 29m47s 29m47s 16 80 30m52s 30m52s 17 75 31m8s 31m8s 18 79 29m59s 29m23s 19 78 31m24s 30m48s 20 79 30m47s 30m47s 21 73 30m55s 30m55s 22 77 31m2s 31m1s 23 79 30m50s 30m50s -
Connections
Established Connections
Key values
- 49 connections Connection Peak
- 2026-01-17 01:11:33 Date
Connections per database
Key values
- ctdprd51 Main Database
- 3,018 connections Total
Connections per user
Key values
- pubeu Main User
- 3,018 connections Total
-
Sessions
Simultaneous sessions
Key values
- 81 sessions Session Peak
- 2026-01-17 01:11:12 Date
Histogram of session times
Key values
- 1,816 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 3,018 sessions Total
Sessions per user
Key values
- pubeu Main User
- 3,018 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 3,018 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 299 buffers Checkpoint Peak
- 2026-01-17 00:23:02 Date
- 30.047 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2026-01-17 20:52:39 Date
Checkpoints distance
Key values
- 4.79 Mo Distance Peak
- 2026-01-17 00:23:02 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 17 00 337 33.941s 0.003s 34.012s 01 124 12.603s 0.002s 12.635s 02 109 11.092s 0.002s 11.122s 03 119 12.099s 0.002s 12.132s 04 29 3.075s 0.002s 3.106s 05 115 11.704s 0.002s 11.736s 06 58 5.987s 0.002s 6.019s 07 175 17.707s 0.002s 17.738s 08 140 14.194s 0.002s 14.224s 09 40 4.082s 0.002s 4.113s 10 107 10.893s 0.002s 10.924s 11 20 2.173s 0.002s 2.204s 12 44 4.576s 0.002s 4.607s 13 18 1.972s 0.002s 2.003s 14 24 2.571s 0.002s 2.602s 15 38 3.981s 0.002s 4.013s 16 23 2.475s 0.002s 2.507s 17 27 2.867s 0.002s 2.899s 18 10 1.083s 0.001s 1.098s 19 114 11.587s 0.002s 11.617s 20 36 3.775s 0.002s 3.865s 21 87 8.888s 0.002s 8.919s 22 53 5.481s 0.002s 5.511s 23 25 2.667s 0.002s 2.697s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 17 00 0 0 0 59 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 02 0 0 0 20 0.001s 0.002s 03 0 0 0 29 0.001s 0.002s 04 0 0 0 17 0.001s 0.002s 05 0 0 0 26 0.001s 0.002s 06 0 0 0 22 0.001s 0.002s 07 0 0 0 27 0.001s 0.002s 08 0 0 0 27 0.001s 0.002s 09 0 0 0 16 0.001s 0.002s 10 0 0 0 22 0.001s 0.002s 11 0 0 0 18 0.001s 0.002s 12 0 0 0 16 0.001s 0.002s 13 0 0 0 12 0.001s 0.002s 14 0 0 0 16 0.001s 0.002s 15 0 0 0 18 0.001s 0.002s 16 0 0 0 14 0.001s 0.002s 17 0 0 0 17 0.001s 0.002s 18 0 0 0 10 0.001s 0.001s 19 0 0 0 29 0.001s 0.002s 20 0 0 1 19 0.001s 0.002s 21 0 0 0 22 0.001s 0.002s 22 0 0 0 17 0.001s 0.002s 23 0 0 0 14 0.001s 0.002s Day Hour Count Avg time (sec) Jan 17 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 17 00 1,241.50 kB 2,333.00 kB 01 168.50 kB 1,920.50 kB 02 168.50 kB 1,588.00 kB 03 309.50 kB 1,334.50 kB 04 37.00 kB 1,100.00 kB 05 380.00 kB 932.00 kB 06 74.50 kB 798.00 kB 07 332.50 kB 699.50 kB 08 297.00 kB 629.00 kB 09 86.50 kB 529.50 kB 10 213.00 kB 456.00 kB 11 30.00 kB 391.00 kB 12 57.50 kB 326.50 kB 13 43.00 kB 273.50 kB 14 31.00 kB 227.00 kB 15 46.50 kB 192.00 kB 16 50.50 kB 166.00 kB 17 35.00 kB 142.50 kB 18 15.00 kB 123.00 kB 19 284.50 kB 287.00 kB 20 65.00 kB 395.50 kB 21 225.00 kB 363.50 kB 22 58.50 kB 334.50 kB 23 42.50 kB 279.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 17 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 (7) Main table with removed tuples on database ctdprd51
- 7 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 17 00 0 0 01 0 2 02 0 1 03 0 1 04 0 0 05 0 5 06 0 0 07 1 1 08 0 1 09 0 0 10 0 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 1 20 0 0 21 0 1 22 0 0 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
- 53 Requests
- 1h34m48s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 138 Requests
User Request type Count Duration postgres Total 10 9m11s copy to 10 9m11s pubc Total 1 9m9s select 1 9m9s pubeu Total 21 2m34s select 21 2m34s qaeu Total 2 10s349ms select 2 10s349ms unknown Total 138 3h16m1s copy to 132 3h14m49s others 1 6s660ms select 5 1m5s Duration by user
Key values
- 3h16m1s (unknown) Main time consuming user
User Request type Count Duration postgres Total 10 9m11s copy to 10 9m11s pubc Total 1 9m9s select 1 9m9s pubeu Total 21 2m34s select 21 2m34s qaeu Total 2 10s349ms select 2 10s349ms unknown Total 138 3h16m1s copy to 132 3h14m49s others 1 6s660ms select 5 1m5s Queries by host
Key values
- unknown Main host
- 172 Requests
- 3h37m6s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 60 Requests
- 1h35m39s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-17 01:10:57 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 26m19s 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-17 18:43:46 ]
2 26m14s 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-17 19:29:58 ]
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-17 00:09:11 - Database: ctdprd51 - User: pubc - Application: psql ]
4 7m30s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-17 19:42:54 ]
5 7m27s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-01-17 18:56:38 ]
6 1m50s COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;[ Date: 2026-01-17 19:46:12 ]
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-17 19:33:24 ]
8 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-17 18:47:11 ]
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-17 18:58:28 ]
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-17 19:01:23 ]
11 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-17 18:15:06 ]
12 1m4s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-17 18:16:12 ]
13 1m4s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-01-17 19:02:28 ]
14 54s565ms 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-17 18:13:45 ]
15 53s980ms 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-17 19:00:02 ]
16 44s597ms 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-17 19:34:41 ]
17 44s434ms 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-17 18:48:28 ]
18 42s465ms 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-17 19:03:43 ]
19 42s35ms 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-17 18:17:26 ]
20 41s33ms 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-17 19:35:23 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 26m19s 1 26m19s 26m19s 26m19s 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 #1
Day Hour Count Duration Avg duration Jan 17 18 1 26m19s 26m19s -
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-17 18:43:46 Duration: 26m19s
2 26m14s 1 26m14s 26m14s 26m14s 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 17 19 1 26m14s 26m14s -
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-17 19:29:58 Duration: 26m14s
3 9m9s 1 9m9s 9m9s 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 17 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-17 00:09:11 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
4 7m30s 1 7m30s 7m30s 7m30s 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 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
5 7m27s 1 7m27s 7m27s 7m27s 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 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
6 1m50s 1 1m50s 1m50s 1m50s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 17 19 1 1m50s 1m50s -
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-17 19:46:12 Duration: 1m50s
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 17 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-17 19:33:24 Duration: 1m40s
8 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 #8
Day Hour Count Duration Avg duration Jan 17 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-17 18:47:11 Duration: 1m40s
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 17 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-17 18:58:28 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 17 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-17 19:01:23 Duration: 1m12s
11 1m12s 1 1m12s 1m12s 1m12s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 17 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-17 18:15:06 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 17 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-17 18:16:12 Duration: 1m4s
13 1m4s 1 1m4s 1m4s 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 17 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-17 19:02:28 Duration: 1m4s
14 54s565ms 1 54s565ms 54s565ms 54s565ms 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 17 18 1 54s565ms 54s565ms -
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-17 18:13:45 Duration: 54s565ms
15 53s980ms 1 53s980ms 53s980ms 53s980ms 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 17 19 1 53s980ms 53s980ms -
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-17 19:00:02 Duration: 53s980ms
16 44s597ms 1 44s597ms 44s597ms 44s597ms 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 17 19 1 44s597ms 44s597ms -
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-17 19:34:41 Duration: 44s597ms
17 44s434ms 1 44s434ms 44s434ms 44s434ms 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 17 18 1 44s434ms 44s434ms -
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-17 18:48:28 Duration: 44s434ms
18 42s465ms 1 42s465ms 42s465ms 42s465ms 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 17 19 1 42s465ms 42s465ms -
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-17 19:03:43 Duration: 42s465ms
19 42s35ms 1 42s35ms 42s35ms 42s35ms 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 17 18 1 42s35ms 42s35ms -
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-17 18:17:26 Duration: 42s35ms
20 41s33ms 1 41s33ms 41s33ms 41s33ms 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 17 19 1 41s33ms 41s33ms -
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-17 19:35:23 Duration: 41s33ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 10s340ms 5s157ms 5s183ms 5s170ms 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 17 05 2 10s340ms 5s170ms [ User: pubeu - Total duration: 5s183ms - Times executed: 1 ]
[ User: qaeu - Total duration: 5s157ms - 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-17 05:48:43 Duration: 5s183ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 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-17 05:43:39 Duration: 5s157ms Database: ctdprd51 User: qaeu Bind query: yes
2 1 26m19s 26m19s 26m19s 26m19s 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 17 18 1 26m19s 26m19s -
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-17 18:43:46 Duration: 26m19s
3 1 26m14s 26m14s 26m14s 26m14s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 17 19 1 26m14s 26m14s -
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-17 19:29:58 Duration: 26m14s
4 1 9m9s 9m9s 9m9s 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 17 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-17 00:09:11 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
5 1 7m30s 7m30s 7m30s 7m30s 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 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
6 1 7m27s 7m27s 7m27s 7m27s 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 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
7 1 1m50s 1m50s 1m50s 1m50s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 17 19 1 1m50s 1m50s -
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-17 19:46:12 Duration: 1m50s
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 17 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-17 19:33:24 Duration: 1m40s
9 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 #9
Day Hour Count Duration Avg duration Jan 17 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-17 18:47:11 Duration: 1m40s
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 17 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-17 18:58:28 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 17 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-17 19:01:23 Duration: 1m12s
12 1 1m12s 1m12s 1m12s 1m12s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 17 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-17 18:15:06 Duration: 1m12s
13 1 1m4s 1m4s 1m4s 1m4s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 17 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-17 18:16:12 Duration: 1m4s
14 1 1m4s 1m4s 1m4s 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 17 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-17 19:02:28 Duration: 1m4s
15 1 54s565ms 54s565ms 54s565ms 54s565ms 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 17 18 1 54s565ms 54s565ms -
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-17 18:13:45 Duration: 54s565ms
16 1 53s980ms 53s980ms 53s980ms 53s980ms 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 17 19 1 53s980ms 53s980ms -
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-17 19:00:02 Duration: 53s980ms
17 1 44s597ms 44s597ms 44s597ms 44s597ms 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 17 19 1 44s597ms 44s597ms -
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-17 19:34:41 Duration: 44s597ms
18 1 44s434ms 44s434ms 44s434ms 44s434ms 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 17 18 1 44s434ms 44s434ms -
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-17 18:48:28 Duration: 44s434ms
19 1 42s465ms 42s465ms 42s465ms 42s465ms 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 17 19 1 42s465ms 42s465ms -
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-17 19:03:43 Duration: 42s465ms
20 1 42s35ms 42s35ms 42s35ms 42s35ms 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 17 18 1 42s35ms 42s35ms -
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-17 18:17:26 Duration: 42s35ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m19s 26m19s 26m19s 1 26m19s 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 #1
Day Hour Count Duration Avg duration Jan 17 18 1 26m19s 26m19s -
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-17 18:43:46 Duration: 26m19s
2 26m14s 26m14s 26m14s 1 26m14s 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 17 19 1 26m14s 26m14s -
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-17 19:29:58 Duration: 26m14s
3 9m9s 9m9s 9m9s 1 9m9s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 17 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-17 00:09:11 Duration: 9m9s Database: ctdprd51 User: pubc Application: psql
4 7m30s 7m30s 7m30s 1 7m30s 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 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
5 7m27s 7m27s 7m27s 1 7m27s 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 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
6 1m50s 1m50s 1m50s 1 1m50s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 17 19 1 1m50s 1m50s -
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-01-17 19:46:12 Duration: 1m50s
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 17 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-17 19:33:24 Duration: 1m40s
8 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 #8
Day Hour Count Duration Avg duration Jan 17 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-17 18:47:11 Duration: 1m40s
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 17 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-17 18:58:28 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 17 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-17 19:01:23 Duration: 1m12s
11 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 #11
Day Hour Count Duration Avg duration Jan 17 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-17 18:15:06 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 17 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-17 18:16:12 Duration: 1m4s
13 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 #13
Day Hour Count Duration Avg duration Jan 17 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-17 19:02:28 Duration: 1m4s
14 54s565ms 54s565ms 54s565ms 1 54s565ms 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 17 18 1 54s565ms 54s565ms -
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-17 18:13:45 Duration: 54s565ms
15 53s980ms 53s980ms 53s980ms 1 53s980ms 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 17 19 1 53s980ms 53s980ms -
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-17 19:00:02 Duration: 53s980ms
16 44s597ms 44s597ms 44s597ms 1 44s597ms 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 17 19 1 44s597ms 44s597ms -
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-17 19:34:41 Duration: 44s597ms
17 44s434ms 44s434ms 44s434ms 1 44s434ms 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 17 18 1 44s434ms 44s434ms -
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-17 18:48:28 Duration: 44s434ms
18 42s465ms 42s465ms 42s465ms 1 42s465ms 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 17 19 1 42s465ms 42s465ms -
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-17 19:03:43 Duration: 42s465ms
19 42s35ms 42s35ms 42s35ms 1 42s35ms 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 17 18 1 42s35ms 42s35ms -
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-17 18:17:26 Duration: 42s35ms
20 41s33ms 41s33ms 41s33ms 1 41s33ms 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 17 19 1 41s33ms 41s33ms -
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-17 19:35:23 Duration: 41s33ms
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
- 12,252 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