pgBadger-
Global information
- Generated on Sun Aug 23 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260822
- Parsed 15,605 log entries in 2s
- Log start from 2026-08-22 00:00:02 to 2026-08-22 23:58:41
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 62 Number of queries
- 1h48m51s Total query duration
- 2026-08-22 00:09:32 First query
- 2026-08-22 19:50:23 Last query
- 1 queries/s at 2026-08-22 19:04:39 Query peak
- 1h48m51s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h48m51s 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
- 0 Total number of automatic vacuums
- 10 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 1,901 Total number of sessions
- 48 sessions at 2026-08-22 00:05:07 Session peak
- 40d2h14m27s Total duration of sessions
- 30m22s Average duration of sessions
- 0 Average queries per session
- 3s435ms Average queries duration per session
- 30m18s Average idle time per session
- 1,901 Total number of connections
- 23 connections/s at 2026-08-22 13:07:10 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-08-22 19:04:39 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-08-22 04:55:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-08-22 19:04:39 Date
Queries duration
Key values
- 1h48m51s 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) Aug 22 00 2 0ms 9m30s 4m48s 0ms 0ms 9m36s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 1 0ms 9s3ms 9s3ms 0ms 0ms 9s3ms 05 2 0ms 6s231ms 6s210ms 0ms 0ms 6s231ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 32 0ms 28m13s 1m32s 1m10s 1m43s 28m13s 19 25 0ms 27m54s 1m59s 1m29s 1m53s 27m54s 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) Aug 22 00 1 0 9m30s 0ms 0ms 9m30s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 1 0 9s3ms 0ms 0ms 9s3ms 05 2 0 6s210ms 0ms 0ms 6s231ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 1 31 1m32s 56s977ms 1m10s 28m13s 19 0 25 1m59s 1m3s 1m29s 27m54s 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) Aug 22 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 Aug 22 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 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.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 Aug 22 00 76 0.02/s 01 78 0.02/s 02 75 0.02/s 03 77 0.02/s 04 77 0.02/s 05 97 0.03/s 06 82 0.02/s 07 72 0.02/s 08 76 0.02/s 09 76 0.02/s 10 78 0.02/s 11 77 0.02/s 12 77 0.02/s 13 114 0.03/s 14 76 0.02/s 15 79 0.02/s 16 80 0.02/s 17 76 0.02/s 18 71 0.02/s 19 77 0.02/s 20 74 0.02/s 21 78 0.02/s 22 76 0.02/s 23 82 0.02/s Day Hour Count Average Duration Average idle time Aug 22 00 76 31m58s 31m50s 01 78 31m27s 31m27s 02 75 30m4s 30m4s 03 77 31m9s 31m9s 04 77 30m20s 30m20s 05 97 25m46s 25m46s 06 82 29m22s 29m22s 07 72 32m25s 32m25s 08 76 31m16s 31m16s 09 76 31m23s 31m23s 10 78 31m12s 31m12s 11 77 31m32s 31m32s 12 77 31m39s 31m39s 13 114 21m35s 21m35s 14 76 31m50s 31m50s 15 79 30m38s 30m38s 16 80 30m38s 30m38s 17 76 31m49s 31m49s 18 70 30m28s 29m46s 19 78 32m36s 31m58s 20 74 31m25s 31m25s 21 78 31m59s 31m59s 22 76 31m9s 31m9s 23 82 30m39s 30m39s -
Connections
Established Connections
Key values
- 23 connections Connection Peak
- 2026-08-22 13:07:10 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,901 connections Total
Connections per user
Key values
- pubeu Main User
- 1,901 connections Total
-
Sessions
Simultaneous sessions
Key values
- 48 sessions Session Peak
- 2026-08-22 00:05:07 Date
Histogram of session times
Key values
- 1,788 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,901 sessions Total
Sessions per user
Key values
- pubeu Main User
- 1,901 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 1,901 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 26,677 buffers Checkpoint Peak
- 2026-08-22 19:48:04 Date
- 1619.794 seconds Highest write time
- 0.002 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-08-22 09:28:13 Date
Checkpoints distance
Key values
- 86.82 Mo Distance Peak
- 2026-08-22 09:28:13 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 22 00 296 29.829s 0.002s 29.84s 01 65 6.692s 0.002s 6.7s 02 47 4.91s 0.002s 4.918s 03 4,321 432.796s 0.002s 432.851s 04 296 29.846s 0.002s 29.854s 05 128 13.043s 0.002s 13.051s 06 47 4.888s 0.002s 4.898s 07 41 4.269s 0.002s 4.277s 08 27 2.883s 0.002s 2.891s 09 4,369 437.64s 0.002s 437.694s 10 32 3.382s 0.002s 3.392s 11 39 4.122s 0.002s 4.131s 12 39 4.093s 0.002s 4.101s 13 34 3.592s 0.002s 3.6s 14 142 14.398s 0.002s 14.408s 15 52 5.401s 0.002s 5.411s 16 121 12.271s 0.002s 12.28s 17 111 11.269s 0.002s 11.278s 18 67 6.994s 0.002s 7.002s 19 26,677 1,619.794s 0.002s 1,619.799s 20 82 8.397s 0.002s 8.406s 21 19 2.064s 0.002s 2.073s 22 29 3.081s 0.002s 3.089s 23 131 13.292s 0.002s 13.301s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 22 00 0 0 0 62 0.001s 0.002s 01 0 0 0 18 0.001s 0.002s 02 0 0 0 20 0.001s 0.002s 03 0 0 3 35 0.001s 0.002s 04 0 0 0 38 0.001s 0.002s 05 0 0 0 28 0.001s 0.002s 06 0 0 0 18 0.001s 0.002s 07 0 0 0 15 0.001s 0.002s 08 0 0 0 15 0.001s 0.002s 09 0 0 3 34 0.001s 0.002s 10 0 0 0 16 0.001s 0.002s 11 0 0 0 25 0.001s 0.002s 12 0 0 0 18 0.001s 0.002s 13 0 0 0 16 0.001s 0.002s 14 0 0 0 31 0.001s 0.002s 15 0 0 0 16 0.001s 0.002s 16 0 0 0 18 0.001s 0.002s 17 0 0 0 17 0.001s 0.002s 18 0 0 0 16 0.001s 0.002s 19 0 0 0 11 0.001s 0.001s 20 0 0 0 18 0.001s 0.002s 21 0 0 0 14 0.001s 0.002s 22 0 0 0 16 0.001s 0.002s 23 0 0 0 23 0.001s 0.002s Day Hour Count Avg time (sec) Aug 22 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 Aug 22 00 1,099.50 kB 24,015.50 kB 01 136.00 kB 19,468.50 kB 02 32.50 kB 15,785.50 kB 03 22,139.00 kB 28,749.00 kB 04 797.50 kB 37,766.50 kB 05 339.50 kB 30,641.50 kB 06 60.50 kB 24,855.50 kB 07 47.50 kB 20,143.00 kB 08 50.50 kB 16,326.00 kB 09 22,398.00 kB 42,246.50 kB 10 51.00 kB 34,241.50 kB 11 56.50 kB 27,747.00 kB 12 39.00 kB 22,483.50 kB 13 32.00 kB 18,217.50 kB 14 402.00 kB 14,832.00 kB 15 36.50 kB 12,021.50 kB 16 50.00 kB 9,746.00 kB 17 32.00 kB 7,901.50 kB 18 26.50 kB 6,405.00 kB 19 26.00 kB 5,465.00 kB 20 41.00 kB 4,679.50 kB 21 23.00 kB 3,794.50 kB 22 58.00 kB 3,083.50 kB 23 235.00 kB 2,527.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 Aug 22 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 (10) Main table analyzed (database ctdprd51)
- 10 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 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 Aug 22 00 0 0 01 0 1 02 0 0 03 0 1 04 0 2 05 0 3 06 0 0 07 0 0 08 0 0 09 0 1 10 0 0 11 0 0 12 0 0 13 0 0 14 0 1 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 1 - 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
- 5 Total read queries
- 56 Total write queries
Queries by database
Key values
- unknown Main database
- 56 Requests
- 1h38m28s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 84 Requests
User Request type Count Duration postgres Total 9 9m20s copy to 9 9m20s pubc Total 1 9m30s select 1 9m30s pubeu Total 7 1m33s select 7 1m33s qaeu Total 2 12s391ms select 2 12s391ms unknown Total 84 1h44m30s copy to 83 1h44m23s others 1 6s729ms Duration by user
Key values
- 1h44m30s (unknown) Main time consuming user
User Request type Count Duration postgres Total 9 9m20s copy to 9 9m20s pubc Total 1 9m30s select 1 9m30s pubeu Total 7 1m33s select 7 1m33s qaeu Total 2 12s391ms select 2 12s391ms unknown Total 84 1h44m30s copy to 83 1h44m23s others 1 6s729ms Queries by host
Key values
- unknown Main host
- 103 Requests
- 2h5m6s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 60 Requests
- 1h39m (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-22 11:11:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 45 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 28m13s 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-08-22 18:46:18 ]
2 27m54s 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-08-22 19:33:20 ]
3 9m30s /* * 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-08-22 00:09:32 - Database: ctdprd51 - User: pubc - Application: psql ]
4 6m57s COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-08-22 18:58:59 ]
5 6m55s COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-08-22 19:45:57 ]
6 1m53s 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-08-22 19:49:42 ]
7 1m43s 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-08-22 18:49:56 ]
8 1m43s 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-08-22 19:36:57 ]
9 1m22s COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;[ Date: 2026-08-22 18:15:39 ]
10 1m22s COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;[ Date: 2026-08-22 19:03:00 ]
11 1m5s COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-08-22 19:04:06 ]
12 1m5s COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;[ Date: 2026-08-22 18:16:45 ]
13 55s963ms 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-08-22 18:14:08 ]
14 55s664ms 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-08-22 19:01:29 ]
15 52s499ms COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;[ Date: 2026-08-22 18:51:22 ]
16 52s387ms 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-08-22 19:38:22 ]
17 46s292ms COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;[ Date: 2026-08-22 18:47:09 ]
18 46s202ms COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;[ Date: 2026-08-22 18:12:25 ]
19 44s968ms COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;[ Date: 2026-08-22 19:47:12 ]
20 44s737ms COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;[ Date: 2026-08-22 19:34:09 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 28m13s 1 28m13s 28m13s 28m13s 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 Aug 22 18 1 28m13s 28m13s -
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-08-22 18:46:18 Duration: 28m13s
2 27m54s 1 27m54s 27m54s 27m54s 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 Aug 22 19 1 27m54s 27m54s -
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-08-22 19:33:20 Duration: 27m54s
3 9m30s 1 9m30s 9m30s 9m30s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 22 00 1 9m30s 9m30s [ User: pubc - Total duration: 9m30s - Times executed: 1 ]
[ Application: psql - Total duration: 9m30s - 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-08-22 00:09:32 Duration: 9m30s Database: ctdprd51 User: pubc Application: psql
4 6m57s 1 6m57s 6m57s 6m57s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 22 18 1 6m57s 6m57s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 18:58:59 Duration: 6m57s
5 6m55s 1 6m55s 6m55s 6m55s 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 Aug 22 19 1 6m55s 6m55s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:45:57 Duration: 6m55s
6 1m53s 1 1m53s 1m53s 1m53s 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 Aug 22 19 1 1m53s 1m53s -
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-08-22 19:49:42 Duration: 1m53s
7 1m43s 1 1m43s 1m43s 1m43s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 22 18 1 1m43s 1m43s -
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-08-22 18:49:56 Duration: 1m43s
8 1m43s 1 1m43s 1m43s 1m43s 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 Aug 22 19 1 1m43s 1m43s -
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-08-22 19:36:57 Duration: 1m43s
9 1m22s 1 1m22s 1m22s 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 22 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 18:15:39 Duration: 1m22s
10 1m22s 1 1m22s 1m22s 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 22 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 19:03:00 Duration: 1m22s
11 1m5s 1 1m5s 1m5s 1m5s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 22 19 1 1m5s 1m5s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 19:04:06 Duration: 1m5s
12 1m5s 1 1m5s 1m5s 1m5s 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 Aug 22 18 1 1m5s 1m5s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 18:16:45 Duration: 1m5s
13 55s963ms 1 55s963ms 55s963ms 55s963ms 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 #13
Day Hour Count Duration Avg duration Aug 22 18 1 55s963ms 55s963ms -
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-08-22 18:14:08 Duration: 55s963ms
14 55s664ms 1 55s664ms 55s664ms 55s664ms copy pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 22 19 1 55s664ms 55s664ms -
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-08-22 19:01:29 Duration: 55s664ms
15 52s499ms 1 52s499ms 52s499ms 52s499ms copy pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 22 18 1 52s499ms 52s499ms -
COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-08-22 18:51:22 Duration: 52s499ms
16 52s387ms 1 52s387ms 52s387ms 52s387ms 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 Aug 22 19 1 52s387ms 52s387ms -
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-08-22 19:38:22 Duration: 52s387ms
17 46s292ms 1 46s292ms 46s292ms 46s292ms copy pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 22 18 1 46s292ms 46s292ms -
COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-08-22 18:47:09 Duration: 46s292ms
18 46s202ms 1 46s202ms 46s202ms 46s202ms copy load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 22 18 1 46s202ms 46s202ms -
COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;
Date: 2026-08-22 18:12:25 Duration: 46s202ms
19 44s968ms 1 44s968ms 44s968ms 44s968ms copy pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 22 19 1 44s968ms 44s968ms -
COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:47:12 Duration: 44s968ms
20 44s737ms 1 44s737ms 44s737ms 44s737ms copy pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 22 19 1 44s737ms 44s737ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-08-22 19:34:09 Duration: 44s737ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 12s421ms 6s189ms 6s231ms 6s210ms 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 Aug 22 05 2 12s421ms 6s210ms [ User: qaeu - Total duration: 6s231ms - Times executed: 1 ]
[ User: pubeu - Total duration: 6s189ms - 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 = 1403103)) 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-08-22 05:43:40 Duration: 6s231ms 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 = 1403103)) 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-08-22 05:48:42 Duration: 6s189ms Database: ctdprd51 User: pubeu Bind query: yes
2 1 28m13s 28m13s 28m13s 28m13s 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 Aug 22 18 1 28m13s 28m13s -
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-08-22 18:46:18 Duration: 28m13s
3 1 27m54s 27m54s 27m54s 27m54s 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 Aug 22 19 1 27m54s 27m54s -
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-08-22 19:33:20 Duration: 27m54s
4 1 9m30s 9m30s 9m30s 9m30s select maint_query_logs_archive ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 22 00 1 9m30s 9m30s [ User: pubc - Total duration: 9m30s - Times executed: 1 ]
[ Application: psql - Total duration: 9m30s - 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-08-22 00:09:32 Duration: 9m30s Database: ctdprd51 User: pubc Application: psql
5 1 6m57s 6m57s 6m57s 6m57s 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 Aug 22 18 1 6m57s 6m57s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 18:58:59 Duration: 6m57s
6 1 6m55s 6m55s 6m55s 6m55s copy pub2.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 Aug 22 19 1 6m55s 6m55s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:45:57 Duration: 6m55s
7 1 1m53s 1m53s 1m53s 1m53s 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 Aug 22 19 1 1m53s 1m53s -
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-08-22 19:49:42 Duration: 1m53s
8 1 1m43s 1m43s 1m43s 1m43s 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 Aug 22 18 1 1m43s 1m43s -
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-08-22 18:49:56 Duration: 1m43s
9 1 1m43s 1m43s 1m43s 1m43s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 22 19 1 1m43s 1m43s -
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-08-22 19:36:57 Duration: 1m43s
10 1 1m22s 1m22s 1m22s 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 22 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 18:15:39 Duration: 1m22s
11 1 1m22s 1m22s 1m22s 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 22 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 19:03:00 Duration: 1m22s
12 1 1m5s 1m5s 1m5s 1m5s 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 Aug 22 19 1 1m5s 1m5s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 19:04:06 Duration: 1m5s
13 1 1m5s 1m5s 1m5s 1m5s 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 Aug 22 18 1 1m5s 1m5s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 18:16:45 Duration: 1m5s
14 1 55s963ms 55s963ms 55s963ms 55s963ms 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 Aug 22 18 1 55s963ms 55s963ms -
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-08-22 18:14:08 Duration: 55s963ms
15 1 55s664ms 55s664ms 55s664ms 55s664ms 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 Aug 22 19 1 55s664ms 55s664ms -
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-08-22 19:01:29 Duration: 55s664ms
16 1 52s499ms 52s499ms 52s499ms 52s499ms copy pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 22 18 1 52s499ms 52s499ms -
COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-08-22 18:51:22 Duration: 52s499ms
17 1 52s387ms 52s387ms 52s387ms 52s387ms 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 Aug 22 19 1 52s387ms 52s387ms -
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-08-22 19:38:22 Duration: 52s387ms
18 1 46s292ms 46s292ms 46s292ms 46s292ms copy pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 22 18 1 46s292ms 46s292ms -
COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-08-22 18:47:09 Duration: 46s292ms
19 1 46s202ms 46s202ms 46s202ms 46s202ms copy load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 22 18 1 46s202ms 46s202ms -
COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;
Date: 2026-08-22 18:12:25 Duration: 46s202ms
20 1 44s968ms 44s968ms 44s968ms 44s968ms copy pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 22 19 1 44s968ms 44s968ms -
COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:47:12 Duration: 44s968ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 28m13s 28m13s 28m13s 1 28m13s 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 Aug 22 18 1 28m13s 28m13s -
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-08-22 18:46:18 Duration: 28m13s
2 27m54s 27m54s 27m54s 1 27m54s 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 Aug 22 19 1 27m54s 27m54s -
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-08-22 19:33:20 Duration: 27m54s
3 9m30s 9m30s 9m30s 1 9m30s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 22 00 1 9m30s 9m30s [ User: pubc - Total duration: 9m30s - Times executed: 1 ]
[ Application: psql - Total duration: 9m30s - 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-08-22 00:09:32 Duration: 9m30s Database: ctdprd51 User: pubc Application: psql
4 6m57s 6m57s 6m57s 1 6m57s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 22 18 1 6m57s 6m57s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 18:58:59 Duration: 6m57s
5 6m55s 6m55s 6m55s 1 6m55s 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 Aug 22 19 1 6m55s 6m55s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:45:57 Duration: 6m55s
6 1m53s 1m53s 1m53s 1 1m53s 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 Aug 22 19 1 1m53s 1m53s -
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-08-22 19:49:42 Duration: 1m53s
7 1m43s 1m43s 1m43s 1 1m43s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 22 18 1 1m43s 1m43s -
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-08-22 18:49:56 Duration: 1m43s
8 1m43s 1m43s 1m43s 1 1m43s 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 Aug 22 19 1 1m43s 1m43s -
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-08-22 19:36:57 Duration: 1m43s
9 1m22s 1m22s 1m22s 1 1m22s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 22 18 1 1m22s 1m22s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 18:15:39 Duration: 1m22s
10 1m22s 1m22s 1m22s 1 1m22s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 22 19 1 1m22s 1m22s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-08-22 19:03:00 Duration: 1m22s
11 1m5s 1m5s 1m5s 1 1m5s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 22 19 1 1m5s 1m5s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 19:04:06 Duration: 1m5s
12 1m5s 1m5s 1m5s 1 1m5s 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 Aug 22 18 1 1m5s 1m5s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-08-22 18:16:45 Duration: 1m5s
13 55s963ms 55s963ms 55s963ms 1 55s963ms 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 #13
Day Hour Count Duration Avg duration Aug 22 18 1 55s963ms 55s963ms -
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-08-22 18:14:08 Duration: 55s963ms
14 55s664ms 55s664ms 55s664ms 1 55s664ms copy pub2.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 22 19 1 55s664ms 55s664ms -
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-08-22 19:01:29 Duration: 55s664ms
15 52s499ms 52s499ms 52s499ms 1 52s499ms copy pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 22 18 1 52s499ms 52s499ms -
COPY pub1.term (id, object_type_id, acc_txt, acc_db_cd, nm, nm_sort, nm_html, secondary_nm, description, note, is_leaf, new_ixn_qty, ixn_qty, has_chems, has_diseases, has_genes, has_go, has_ixns, has_marrays, has_pathways, has_comps, has_references, has_exposures, has_phenotypes, has_ccc, curated_edge_qty, gene_edge_qty, nm_fts) TO stdout;
Date: 2026-08-22 18:51:22 Duration: 52s499ms
16 52s387ms 52s387ms 52s387ms 1 52s387ms 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 Aug 22 19 1 52s387ms 52s387ms -
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-08-22 19:38:22 Duration: 52s387ms
17 46s292ms 46s292ms 46s292ms 1 46s292ms copy pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 22 18 1 46s292ms 46s292ms -
COPY pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-08-22 18:47:09 Duration: 46s292ms
18 46s202ms 46s202ms 46s202ms 1 46s202ms copy load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 22 18 1 46s202ms 46s202ms -
COPY load.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not, create_tm) TO stdout;
Date: 2026-08-22 18:12:25 Duration: 46s202ms
19 44s968ms 44s968ms 44s968ms 1 44s968ms copy pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 22 19 1 44s968ms 44s968ms -
COPY pub2.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-08-22 19:47:12 Duration: 44s968ms
20 44s737ms 44s737ms 44s737ms 1 44s737ms copy pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 22 19 1 44s737ms 44s737ms -
COPY pub2.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) TO stdout;
Date: 2026-08-22 19:34:09 Duration: 44s737ms
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,776 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