pgBadger-
Global information
- Generated on Sat Sep 5 04:15:03 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260904
- Parsed 15,372 log entries in 2s
- Log start from 2026-09-04 00:00:02 to 2026-09-04 23:59:45
-
Overview
Global Stats
- 24 Number of unique normalized queries
- 57 Number of queries
- 44m56s Total query duration
- 2026-09-04 00:09:23 First query
- 2026-09-04 18:07:36 Last query
- 1 queries/s at 2026-09-04 10:27:55 Query peak
- 44m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 44m56s Execute total duration
- 10 Number of events
- 2 Number of unique normalized events
- 7 Max number of times the same event was reported
- 0 Number of cancellation
- 2 Total number of automatic vacuums
- 16 Total number of automatic analyzes
- 4 Number temporary file
- 2.09 MiB Max size of temporary file
- 1.23 MiB Average size of temporary file
- 1,865 Total number of sessions
- 49 sessions at 2026-09-04 18:05:01 Session peak
- 40d20h3m53s Total duration of sessions
- 31m31s Average duration of sessions
- 0 Average queries per session
- 1s446ms Average queries duration per session
- 31m30s Average idle time per session
- 1,865 Total number of connections
- 9 connections/s at 2026-09-04 05:40:08 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-04 10:27:55 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-04 10:27:55 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-04 10:07:19 Date
Queries duration
Key values
- 44m56s 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) Sep 04 00 6 0ms 9m21s 1m41s 0ms 11s252ms 9m28s 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 5s848ms 5s748ms 0ms 0ms 5s848ms 06 10 0ms 1m52s 28s84ms 39s701ms 58s428ms 1m52s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 2 0ms 1m35s 1m33s 0ms 1m31s 1m35s 10 12 0ms 1m52s 21s131ms 21s37ms 50s380ms 1m52s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 2 0ms 1m35s 1m32s 0ms 1m29s 1m35s 14 9 0ms 1m59s 25s890ms 0ms 49s718ms 2m40s 15 5 0ms 8m26s 2m22s 0ms 25s232ms 8m26s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 9 0ms 1m54s 25s88ms 0ms 39s520ms 1m54s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 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) Sep 04 00 5 0 2m 0ms 0ms 9m21s 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 5s748ms 0ms 0ms 5s848ms 06 1 9 28s84ms 0ms 39s701ms 1m52s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 2 0 1m33s 0ms 0ms 1m35s 10 3 9 21s131ms 5s55ms 21s37ms 1m52s 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 2 0 1m32s 0ms 0ms 1m35s 14 0 9 25s890ms 0ms 0ms 2m40s 15 4 0 51s6ms 0ms 0ms 2m53s 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 9 25s88ms 0ms 0ms 1m54s 19 0 0 0ms 0ms 0ms 0ms 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) Sep 04 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 Sep 04 00 0 4 4.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 2 2.00 0.00% 10 0 3 3.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 2 2.00 0.00% 14 0 0 0.00 0.00% 15 0 3 3.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 04 00 79 0.02/s 01 75 0.02/s 02 72 0.02/s 03 74 0.02/s 04 86 0.02/s 05 94 0.03/s 06 75 0.02/s 07 79 0.02/s 08 78 0.02/s 09 77 0.02/s 10 77 0.02/s 11 70 0.02/s 12 77 0.02/s 13 76 0.02/s 14 80 0.02/s 15 84 0.02/s 16 76 0.02/s 17 76 0.02/s 18 78 0.02/s 19 73 0.02/s 20 76 0.02/s 21 77 0.02/s 22 76 0.02/s 23 80 0.02/s Day Hour Count Average Duration Average idle time Sep 04 00 79 30m39s 30m32s 01 75 32m19s 32m19s 02 72 32m 32m 03 74 32m12s 32m12s 04 86 27m29s 27m29s 05 94 25m29s 25m29s 06 75 31m8s 31m4s 07 79 31m22s 31m22s 08 78 31m32s 31m32s 09 76 31m7s 31m4s 10 77 29m55s 29m52s 11 70 31m16s 31m16s 12 77 33m5s 33m5s 13 76 31m23s 31m21s 14 79 31m40s 31m37s 15 83 30m4s 29m56s 16 76 32m4s 32m4s 17 76 31m33s 31m33s 18 78 31m28s 31m25s 19 76 46m9s 46m9s 20 76 31m58s 31m58s 21 77 31m30s 31m30s 22 76 31m28s 31m28s 23 80 29m55s 29m55s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-09-04 05:40:08 Date
Connections per database
Key values
- ctdprd51 Main Database
- 1,865 connections Total
Connections per user
Key values
- qaeu Main User
- 1,865 connections Total
-
Sessions
Simultaneous sessions
Key values
- 49 sessions Session Peak
- 2026-09-04 18:05:01 Date
Histogram of session times
Key values
- 1,753 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 1,865 sessions Total
Sessions per user
Key values
- qaeu Main User
- 1,865 sessions Total
Sessions per host
Key values
- 10.12.5.46 Main Host
- 1,865 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,223 buffers Checkpoint Peak
- 2026-09-04 16:03:21 Date
- 262.725 seconds Highest write time
- 0.004 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-09-04 16:29:40 Date
Checkpoints distance
Key values
- 980.43 Mo Distance Peak
- 2026-09-04 15:34:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 04 00 427 42.951s 0.003s 42.962s 01 181 18.322s 0.002s 18.332s 02 88 8.993s 0.002s 9.002s 03 190 19.203s 0.002s 19.211s 04 135 13.707s 0.002s 13.761s 05 80 8.097s 0.001s 8.102s 06 708 71.121s 0.003s 71.136s 07 269 27.032s 0.001s 27.036s 08 740 74.38s 0.003s 74.394s 09 186 18.806s 0.002s 18.815s 10 72 7.302s 0.001s 7.307s 11 1,068 107.225s 0.003s 107.245s 12 28 2.964s 0.002s 2.973s 13 38 3.973s 0.002s 3.982s 14 353 35.574s 0.002s 35.584s 15 575 262.725s 0.004s 262.865s 16 2,272 227.709s 0.003s 227.724s 17 23 2.468s 0.002s 2.476s 18 167 16.904s 0.002s 16.913s 19 16 1.698s 0.001s 1.703s 20 58 5.998s 0.002s 6.007s 21 66 6.789s 0.002s 6.798s 22 158 16.017s 0.002s 16.027s 23 99 10.101s 0.002s 10.111s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 04 00 0 0 0 62 0.001s 0.002s 01 0 0 0 27 0.001s 0.002s 02 0 0 0 20 0.001s 0.002s 03 0 0 0 33 0.001s 0.002s 04 0 1 0 27 0.001s 0.002s 05 0 0 0 14 0.001s 0.001s 06 0 0 0 185 0.001s 0.003s 07 0 0 0 67 0.001s 0.001s 08 0 0 0 165 0.001s 0.003s 09 0 0 0 71 0.001s 0.002s 10 0 0 0 49 0.001s 0.001s 11 0 1 0 100 0.001s 0.003s 12 0 0 0 14 0.001s 0.002s 13 0 0 0 17 0.001s 0.002s 14 0 0 0 121 0.001s 0.002s 15 0 35 0 55 0.001s 0.001s 16 0 0 0 46 0.001s 0.003s 17 0 0 0 13 0.001s 0.002s 18 0 0 0 22 0.001s 0.002s 19 0 0 0 9 0.001s 0.001s 20 0 0 0 18 0.001s 0.002s 21 0 0 0 18 0.001s 0.002s 22 0 0 0 28 0.001s 0.002s 23 0 0 0 20 0.001s 0.002s Day Hour Count Avg time (sec) Sep 04 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 Sep 04 00 1,425.50 kB 78,668.50 kB 01 163.00 kB 63,741.00 kB 02 44.00 kB 51,649.50 kB 03 330.50 kB 41,886.00 kB 04 215.00 kB 33,968.00 kB 05 156.00 kB 28,994.00 kB 06 1,262.67 kB 23,815.67 kB 07 1,799.00 kB 19,509.00 kB 08 1,610.67 kB 16,250.67 kB 09 441.50 kB 12,569.50 kB 10 338.00 kB 10,774.00 kB 11 2,483.33 kB 9,418.00 kB 12 57.00 kB 7,244.00 kB 13 63.50 kB 5,879.50 kB 14 931.00 kB 4,908.50 kB 15 501,980.00 kB 501,980.00 kB 16 23,714.67 kB 414,530.33 kB 17 46.50 kB 317,816.50 kB 18 58.50 kB 257,443.00 kB 19 28.00 kB 219,509.00 kB 20 35.50 kB 187,685.00 kB 21 46.50 kB 152,033.50 kB 22 241.50 kB 123,191.50 kB 23 64.50 kB 99,798.50 kB -
Temporary Files
Size of temporary files
Key values
- 4.94 MiB Temp Files size Peak
- 2026-09-04 15:03:51 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-04 15:03:51 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 04 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 4 4.94 MiB 1.23 MiB 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 4 4.94 MiB 656.00 KiB 2.09 MiB 1.23 MiB vacuum full analyze edit.reference_contact;-
VACUUM FULL ANALYZE edit.reference_contact;
Date: 2026-09-04 15:03:51 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 2.09 MiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-09-04 15:03:51 ]
2 1.23 MiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-09-04 15:03:51 ]
3 1000.00 KiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-09-04 15:03:51 ]
4 656.00 KiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-09-04 15:03:51 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 15.24 sec Highest CPU-cost vacuum
Table load.ixn_prose
Database ctdprd51 - 2026-09-04 15:31:46 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 15.24 sec Highest CPU-cost vacuum
Table load.ixn_prose
Database ctdprd51 - 2026-09-04 15:31:46 Date
Analyzes per table
Key values
- pubc.log_query (12) Main table analyzed (database ctdprd51)
- 16 analyzes Total
Vacuums per table
Key values
- load.ixn_prose (1) Main table vacuumed on database ctdprd51
- 2 vacuums Total
Vacuum throughput per table
Key values
- load.ixn_prose (15.24) Max CPU elapsed for vacuum on database ctdprd51
- unknown (0 ms) Max I/O read time for vacuum on database ctdprd51
- unknown (0 ms) Max I/O write time for vacuum on database ctdprd51
Tuples removed per table
Key values
- pubc.log_query (3) Main table with removed tuples on database ctdprd51
- 3 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 Sep 04 00 0 0 01 0 1 02 0 0 03 0 2 04 0 1 05 1 3 06 0 0 07 0 1 08 0 1 09 0 1 10 0 1 11 0 1 12 0 0 13 0 0 14 0 1 15 1 2 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 - 15.24 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
- 19 Total read queries
- 37 Total write queries
Queries by database
Key values
- unknown Main database
- 33 Requests
- 37m53s (ctdprd51)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 64 Requests
User Request type Count Duration edit Total 1 5s318ms select 1 5s318ms load Total 17 34m12s ddl 1 8m26s select 16 25m46s postgres Total 16 17m54s copy to 16 17m54s pubc Total 1 9m21s select 1 9m21s pubeu Total 17 14m6s select 17 14m6s qaeu Total 2 11s818ms select 2 11s818ms unknown Total 64 13m18s copy to 56 12m others 1 6s382ms select 7 1m11s Duration by user
Key values
- 34m12s (load) Main time consuming user
User Request type Count Duration edit Total 1 5s318ms select 1 5s318ms load Total 17 34m12s ddl 1 8m26s select 16 25m46s postgres Total 16 17m54s copy to 16 17m54s pubc Total 1 9m21s select 1 9m21s pubeu Total 17 14m6s select 17 14m6s qaeu Total 2 11s818ms select 2 11s818ms unknown Total 64 13m18s copy to 56 12m others 1 6s382ms select 7 1m11s Queries by host
Key values
- unknown Main host
- 118 Requests
- 1h29m11s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 46 Requests
- 18m (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-04 16:43:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 38 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 9m21s /* * 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-09-04 00:09:23 - Database: ctdprd51 - User: pubc - Application: psql ]
2 8m26s drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;[ Date: 2026-09-04 15:30:42 - Database: ctdprd51 - User: load - Application: pgAdmin 4 - CONN:774039 ]
3 2m53s SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');[ Date: 2026-09-04 15:34:56 - Database: ctdprd51 - User: load - Bind query: yes ]
4 1m59s 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-09-04 14:07:01 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
5 1m54s 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-09-04 18:06:56 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
6 1m52s 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-09-04 10:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
7 1m52s 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-09-04 06:06:54 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
8 1m35s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-04 09:34:25 - Database: ctdprd51 - User: load - Bind query: yes ]
9 1m35s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-04 13:26:36 - Database: ctdprd51 - User: load - Bind query: yes ]
10 1m31s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-04 09:44:25 - Database: ctdprd51 - User: load - Bind query: yes ]
11 1m29s select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;[ Date: 2026-09-04 13:33:55 - Database: ctdprd51 - User: load - Bind query: yes ]
12 58s428ms SELECT /* BatchDiseaseGeneAssnsDAO */ 'd056486' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2194138) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;[ Date: 2026-09-04 06:29:41 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
13 25s123ms COPY pubc.log_query_bots (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, 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-09-04 14:07:26 ]
14 24s211ms COPY pubc.log_query_bots (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, 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-09-04 10:07:19 ]
15 24s203ms COPY pubc.log_query_bots (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, 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-09-04 06:07:18 ]
16 24s126ms COPY pubc.log_query_bots (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, 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-09-04 18:07:20 ]
17 21s159ms COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;[ Date: 2026-09-04 10:00:23 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
18 20s600ms COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;[ Date: 2026-09-04 18:00:22 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
19 20s422ms COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;[ Date: 2026-09-04 14:00:22 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
20 20s253ms COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;[ Date: 2026-09-04 06:00:21 - Database: ctdprd51 - User: postgres - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 9m21s 1 9m21s 9m21s 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-09-04 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
2 8m26s 1 8m26s 8m26s 8m26s drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 15 1 8m26s 8m26s [ User: load - Total duration: 8m26s - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:774039 - Total duration: 8m26s - Times executed: 1 ]
-
drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;
Date: 2026-09-04 15:30:42 Duration: 8m26s Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:774039
3 7m39s 4 1m52s 1m59s 1m54s 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 #3
Day Hour Count Duration Avg duration Sep 04 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m59s 1m59s 18 1 1m54s 1m54s [ User: postgres - Total duration: 7m39s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m39s - Times executed: 4 ]
-
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-09-04 14:07:01 Duration: 1m59s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 18:06:56 Duration: 1m54s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
4 4m35s 3 1m29s 1m35s 1m31s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ?, reference_score # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 09 1 1m31s 1m31s 13 2 3m4s 1m32s [ User: load - Total duration: 4m35s - Times executed: 3 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:26:36 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:44:25 Duration: 1m31s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:33:55 Duration: 1m29s Database: ctdprd51 User: load Bind query: yes
5 2m53s 1 2m53s 2m53s 2m53s select r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, ?), r.evidence_cd, i.create_by from edit.reference_ixn r, edit.ixn i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.ixn_type where nm = ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 15 1 2m53s 2m53s [ User: load - Total duration: 2m53s - Times executed: 1 ]
-
SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');
Date: 2026-09-04 15:34:56 Duration: 2m53s Database: ctdprd51 User: load Bind query: yes
6 1m37s 4 24s126ms 25s123ms 24s416ms copy pubc.log_query_bots (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, 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 Sep 04 06 1 24s203ms 24s203ms 10 1 24s211ms 24s211ms 14 1 25s123ms 25s123ms 18 1 24s126ms 24s126ms -
COPY pubc.log_query_bots (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, 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-09-04 14:07:26 Duration: 25s123ms
-
COPY pubc.log_query_bots (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, 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-09-04 10:07:19 Duration: 24s211ms
-
COPY pubc.log_query_bots (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, 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-09-04 06:07:18 Duration: 24s203ms
7 1m35s 1 1m35s 1m35s 1m35s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 09 1 1m35s 1m35s [ User: load - Total duration: 1m35s - Times executed: 1 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:34:25 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
8 1m22s 4 20s253ms 21s159ms 20s609ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 06 1 20s253ms 20s253ms 10 1 21s159ms 21s159ms 14 1 20s422ms 20s422ms 18 1 20s600ms 20s600ms [ User: postgres - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:23 Duration: 21s159ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:22 Duration: 20s600ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:22 Duration: 20s422ms Database: ctdprd51 User: postgres Application: pg_dump
9 1m2s 4 15s394ms 15s952ms 15s566ms copy pubc.log_query_bots_original (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, 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, user_agent_pattern) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 06 1 15s497ms 15s497ms 10 1 15s421ms 15s421ms 14 1 15s952ms 15s952ms 18 1 15s394ms 15s394ms -
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 14:07:42 Duration: 15s952ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 06:07:34 Duration: 15s497ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 10:07:34 Duration: 15s421ms
10 1m 4 14s979ms 15s205ms 15s100ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 06 1 15s20ms 15s20ms 10 1 14s979ms 14s979ms 14 1 15s205ms 15s205ms 18 1 15s198ms 15s198ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:54 Duration: 15s205ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:54 Duration: 15s198ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:00:53 Duration: 15s20ms
11 59s445ms 4 14s492ms 15s509ms 14s861ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 06 1 14s638ms 14s638ms 10 1 14s492ms 14s492ms 14 1 15s509ms 15s509ms 18 1 14s804ms 14s804ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:10 Duration: 15s509ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:09 Duration: 14s804ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:01:07 Duration: 14s638ms
12 58s428ms 1 58s428ms 58s428ms 58s428ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 06 1 58s428ms 58s428ms [ User: pubeu - Total duration: 58s428ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'd056486' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2194138) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-04 06:29:41 Duration: 58s428ms Database: ctdprd51 User: pubeu Bind query: yes
13 42s359ms 4 10s181ms 11s252ms 10s589ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 00 4 42s359ms 10s589ms [ User: pubeu - Total duration: 31s764ms - Times executed: 3 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:54:00 Duration: 11s252ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:47 Duration: 10s595ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:38 Duration: 10s330ms Database: ctdprd51 User: pubeu Bind query: yes
14 30s917ms 4 7s544ms 7s959ms 7s729ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 06 1 7s544ms 7s544ms 10 1 7s959ms 7s959ms 14 1 7s663ms 7s663ms 18 1 7s749ms 7s749ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:33 Duration: 7s959ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:32 Duration: 7s749ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:32 Duration: 7s663ms
15 26s570ms 4 6s519ms 6s858ms 6s642ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 06 1 6s519ms 6s519ms 10 1 6s545ms 6s545ms 14 1 6s858ms 6s858ms 18 1 6s647ms 6s647ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:18 Duration: 6s858ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:18 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:01:18 Duration: 6s545ms
16 25s279ms 4 6s280ms 6s425ms 6s319ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 06 1 6s280ms 6s280ms 10 1 6s282ms 6s282ms 14 1 6s425ms 6s425ms 18 1 6s291ms 6s291ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:39 Duration: 6s425ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:39 Duration: 6s291ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:40 Duration: 6s282ms
17 24s781ms 2 6s350ms 18s430ms 12s390ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 10 2 24s781ms 12s390ms [ User: pubeu - Total duration: 6s350ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:28:46 Duration: 18s430ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:35:13 Duration: 6s350ms Database: ctdprd51 User: pubeu Bind query: yes
18 19s786ms 1 19s786ms 19s786ms 19s786ms select i.root_id, iq.nm from edit.reference_ixn_qualifier riq, edit.ixn_qualifier iq, edit.reference_ixn ri, edit.ixn i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 15 1 19s786ms 19s786ms -
select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;
Date: 2026-09-04 15:35:25 Duration: 19s786ms Bind query: yes
19 11s497ms 2 5s649ms 5s848ms 5s748ms 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 #19
Day Hour Count Duration Avg duration Sep 04 05 2 11s497ms 5s748ms [ User: qaeu - Total duration: 5s848ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s649ms - 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 = 1404748)) 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-09-04 05:43:38 Duration: 5s848ms 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 = 1404748)) 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-09-04 05:48:38 Duration: 5s649ms Database: ctdprd51 User: pubeu Bind query: yes
20 6s382ms 1 6s382ms 6s382ms 6s382ms vacuum analyze log_query_archive;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 00 1 6s382ms 6s382ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-04 00:09:30 Duration: 6s382ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 4 7m39s 1m52s 1m59s 1m54s 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 #1
Day Hour Count Duration Avg duration Sep 04 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m59s 1m59s 18 1 1m54s 1m54s [ User: postgres - Total duration: 7m39s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m39s - Times executed: 4 ]
-
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-09-04 14:07:01 Duration: 1m59s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 18:06:56 Duration: 1m54s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
2 4 1m37s 24s126ms 25s123ms 24s416ms copy pubc.log_query_bots (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, 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 #2
Day Hour Count Duration Avg duration Sep 04 06 1 24s203ms 24s203ms 10 1 24s211ms 24s211ms 14 1 25s123ms 25s123ms 18 1 24s126ms 24s126ms -
COPY pubc.log_query_bots (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, 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-09-04 14:07:26 Duration: 25s123ms
-
COPY pubc.log_query_bots (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, 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-09-04 10:07:19 Duration: 24s211ms
-
COPY pubc.log_query_bots (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, 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-09-04 06:07:18 Duration: 24s203ms
3 4 1m22s 20s253ms 21s159ms 20s609ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 06 1 20s253ms 20s253ms 10 1 21s159ms 21s159ms 14 1 20s422ms 20s422ms 18 1 20s600ms 20s600ms [ User: postgres - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:23 Duration: 21s159ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:22 Duration: 20s600ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:22 Duration: 20s422ms Database: ctdprd51 User: postgres Application: pg_dump
4 4 1m2s 15s394ms 15s952ms 15s566ms copy pubc.log_query_bots_original (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, 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, user_agent_pattern) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 06 1 15s497ms 15s497ms 10 1 15s421ms 15s421ms 14 1 15s952ms 15s952ms 18 1 15s394ms 15s394ms -
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 14:07:42 Duration: 15s952ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 06:07:34 Duration: 15s497ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 10:07:34 Duration: 15s421ms
5 4 1m 14s979ms 15s205ms 15s100ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 06 1 15s20ms 15s20ms 10 1 14s979ms 14s979ms 14 1 15s205ms 15s205ms 18 1 15s198ms 15s198ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:54 Duration: 15s205ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:54 Duration: 15s198ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:00:53 Duration: 15s20ms
6 4 59s445ms 14s492ms 15s509ms 14s861ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 06 1 14s638ms 14s638ms 10 1 14s492ms 14s492ms 14 1 15s509ms 15s509ms 18 1 14s804ms 14s804ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:10 Duration: 15s509ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:09 Duration: 14s804ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:01:07 Duration: 14s638ms
7 4 42s359ms 10s181ms 11s252ms 10s589ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 00 4 42s359ms 10s589ms [ User: pubeu - Total duration: 31s764ms - Times executed: 3 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:54:00 Duration: 11s252ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:47 Duration: 10s595ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:38 Duration: 10s330ms Database: ctdprd51 User: pubeu Bind query: yes
8 4 30s917ms 7s544ms 7s959ms 7s729ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 06 1 7s544ms 7s544ms 10 1 7s959ms 7s959ms 14 1 7s663ms 7s663ms 18 1 7s749ms 7s749ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:33 Duration: 7s959ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:32 Duration: 7s749ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:32 Duration: 7s663ms
9 4 26s570ms 6s519ms 6s858ms 6s642ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 06 1 6s519ms 6s519ms 10 1 6s545ms 6s545ms 14 1 6s858ms 6s858ms 18 1 6s647ms 6s647ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:18 Duration: 6s858ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:18 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:01:18 Duration: 6s545ms
10 4 25s279ms 6s280ms 6s425ms 6s319ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 06 1 6s280ms 6s280ms 10 1 6s282ms 6s282ms 14 1 6s425ms 6s425ms 18 1 6s291ms 6s291ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:39 Duration: 6s425ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:39 Duration: 6s291ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:40 Duration: 6s282ms
11 3 4m35s 1m29s 1m35s 1m31s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ?, reference_score # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 09 1 1m31s 1m31s 13 2 3m4s 1m32s [ User: load - Total duration: 4m35s - Times executed: 3 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:26:36 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:44:25 Duration: 1m31s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:33:55 Duration: 1m29s Database: ctdprd51 User: load Bind query: yes
12 2 24s781ms 6s350ms 18s430ms 12s390ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 10 2 24s781ms 12s390ms [ User: pubeu - Total duration: 6s350ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:28:46 Duration: 18s430ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:35:13 Duration: 6s350ms Database: ctdprd51 User: pubeu Bind query: yes
13 2 11s497ms 5s649ms 5s848ms 5s748ms 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 #13
Day Hour Count Duration Avg duration Sep 04 05 2 11s497ms 5s748ms [ User: qaeu - Total duration: 5s848ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s649ms - 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 = 1404748)) 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-09-04 05:43:38 Duration: 5s848ms 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 = 1404748)) 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-09-04 05:48:38 Duration: 5s649ms Database: ctdprd51 User: pubeu Bind query: yes
14 1 9m21s 9m21s 9m21s 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-09-04 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
15 1 8m26s 8m26s 8m26s 8m26s drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 15 1 8m26s 8m26s [ User: load - Total duration: 8m26s - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:774039 - Total duration: 8m26s - Times executed: 1 ]
-
drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;
Date: 2026-09-04 15:30:42 Duration: 8m26s Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:774039
16 1 2m53s 2m53s 2m53s 2m53s select r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, ?), r.evidence_cd, i.create_by from edit.reference_ixn r, edit.ixn i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.ixn_type where nm = ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 15 1 2m53s 2m53s [ User: load - Total duration: 2m53s - Times executed: 1 ]
-
SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');
Date: 2026-09-04 15:34:56 Duration: 2m53s Database: ctdprd51 User: load Bind query: yes
17 1 1m35s 1m35s 1m35s 1m35s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 09 1 1m35s 1m35s [ User: load - Total duration: 1m35s - Times executed: 1 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:34:25 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
18 1 58s428ms 58s428ms 58s428ms 58s428ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 06 1 58s428ms 58s428ms [ User: pubeu - Total duration: 58s428ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'd056486' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2194138) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-04 06:29:41 Duration: 58s428ms Database: ctdprd51 User: pubeu Bind query: yes
19 1 19s786ms 19s786ms 19s786ms 19s786ms select i.root_id, iq.nm from edit.reference_ixn_qualifier riq, edit.ixn_qualifier iq, edit.reference_ixn ri, edit.ixn i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 15 1 19s786ms 19s786ms -
select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;
Date: 2026-09-04 15:35:25 Duration: 19s786ms Bind query: yes
20 1 6s382ms 6s382ms 6s382ms 6s382ms vacuum analyze log_query_archive;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 00 1 6s382ms 6s382ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-04 00:09:30 Duration: 6s382ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 9m21s 9m21s 9m21s 1 9m21s select maint_query_logs_archive ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 00 1 9m21s 9m21s [ User: pubc - Total duration: 9m21s - Times executed: 1 ]
[ Application: psql - Total duration: 9m21s - 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-09-04 00:09:23 Duration: 9m21s Database: ctdprd51 User: pubc Application: psql
2 8m26s 8m26s 8m26s 1 8m26s drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 15 1 8m26s 8m26s [ User: load - Total duration: 8m26s - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:774039 - Total duration: 8m26s - Times executed: 1 ]
-
drop table load.ixn_prose; create table load.ixn_prose as select edit.get_ixn_prose (ri.ixn_id) as ixn_prose_txt, ri.reference_acc_txt, ri.taxon_acc_txt, ri.mod_tm, t.nm from edit.reference_ixn ri, edit.ixn i, edit.ixn_type t where ri.ixn_id = i.id and i.ixn_type_id = t.id;
Date: 2026-09-04 15:30:42 Duration: 8m26s Database: ctdprd51 User: load Application: pgAdmin 4 - CONN:774039
3 2m53s 2m53s 2m53s 1 2m53s select r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, ?), r.evidence_cd, i.create_by from edit.reference_ixn r, edit.ixn i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.ixn_type where nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 15 1 2m53s 2m53s [ User: load - Total duration: 2m53s - Times executed: 1 ]
-
SELECT r.ixn_id, edit.get_ixn_prose (r.ixn_id), r.reference_acc_txt, r.taxon_acc_txt, r.internal_note, r.field_cd, edit.get_ixn_xml (r.ixn_id), to_char(r.create_tm, 'mm-dd-yyyy'), r.evidence_cd, i.create_by FROM edit.REFERENCE_IXN r, edit.IXN i where r.ixn_id = i.id and i.ixn_type_id = ( select id from edit.IXN_TYPE where nm = 'PHENOTYPE');
Date: 2026-09-04 15:34:56 Duration: 2m53s Database: ctdprd51 User: load Bind query: yes
4 1m52s 1m59s 1m54s 4 7m39s 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 #4
Day Hour Count Duration Avg duration Sep 04 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m59s 1m59s 18 1 1m54s 1m54s [ User: postgres - Total duration: 7m39s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 7m39s - Times executed: 4 ]
-
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-09-04 14:07:01 Duration: 1m59s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 18:06:56 Duration: 1m54s Database: ctdprd51 User: postgres Application: pg_dump
-
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-09-04 10:06:54 Duration: 1m52s Database: ctdprd51 User: postgres Application: pg_dump
5 1m35s 1m35s 1m35s 1 1m35s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 09 1 1m35s 1m35s [ User: load - Total duration: 1m35s - Times executed: 1 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015 from pub2.TETRAMER t # 015 inner join pub2.term chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.term geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.term phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.term diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:34:25 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
6 1m29s 1m35s 1m31s 3 4m35s select chemterm.nm # ?, chemterm.acc_txt # ?, chemterm.secondary_nm # ?, geneterm.nm # ?, geneterm.acc_txt # ?, phenotypeterm.nm # ?, phenotypeterm.acc_txt # ?, diseaseterm.nm # ?, diseaseterm.acc_txt # ?, reference_score # ? from pub2.tetramer t # ? inner join pub2.term chemterm on t.chem_id = chemterm.id # ? inner join pub2.term geneterm on t.gene_id = geneterm.id # ? inner join pub2.term phenotypeterm on t.phenotype_id = phenotypeterm.id # ? inner join pub2.term diseaseterm on t.disease_id = diseaseterm.id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 09 1 1m31s 1m31s 13 2 3m4s 1m32s [ User: load - Total duration: 4m35s - Times executed: 3 ]
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:26:36 Duration: 1m35s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 09:44:25 Duration: 1m31s Database: ctdprd51 User: load Bind query: yes
-
select chemTerm.nm # 015, chemTerm.acc_txt # 015, chemTerm.secondary_nm # 015, geneTerm.nm # 015, geneTerm.acc_txt # 015, phenotypeTerm.nm # 015, phenotypeTerm.acc_txt # 015, diseaseTerm.nm # 015, diseaseTerm.acc_txt # 015, reference_score # 015 from pub2.TETRAMER t # 015 inner join pub2.TERM chemTerm on t.chem_id = chemTerm.id # 015 inner join pub2.TERM geneTerm on t.gene_id = geneTerm.id # 015 inner join pub2.TERM phenotypeTerm on t.phenotype_id = phenotypeTerm.id # 015 inner join pub2.TERM diseaseTerm on t.disease_id = diseaseTerm.id;
Date: 2026-09-04 13:33:55 Duration: 1m29s Database: ctdprd51 User: load Bind query: yes
7 58s428ms 58s428ms 58s428ms 1 58s428ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where (d.id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 06 1 58s428ms 58s428ms [ User: pubeu - Total duration: 58s428ms - Times executed: 1 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'd056486' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE (d.id = 2194138) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-09-04 06:29:41 Duration: 58s428ms Database: ctdprd51 User: pubeu Bind query: yes
8 24s126ms 25s123ms 24s416ms 4 1m37s copy pubc.log_query_bots (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, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 06 1 24s203ms 24s203ms 10 1 24s211ms 24s211ms 14 1 25s123ms 25s123ms 18 1 24s126ms 24s126ms -
COPY pubc.log_query_bots (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, 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-09-04 14:07:26 Duration: 25s123ms
-
COPY pubc.log_query_bots (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, 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-09-04 10:07:19 Duration: 24s211ms
-
COPY pubc.log_query_bots (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, 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-09-04 06:07:18 Duration: 24s203ms
9 20s253ms 21s159ms 20s609ms 4 1m22s copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 06 1 20s253ms 20s253ms 10 1 21s159ms 21s159ms 14 1 20s422ms 20s422ms 18 1 20s600ms 20s600ms [ User: postgres - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 4 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:23 Duration: 21s159ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:22 Duration: 20s600ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:22 Duration: 20s422ms Database: ctdprd51 User: postgres Application: pg_dump
10 19s786ms 19s786ms 19s786ms 1 19s786ms select i.root_id, iq.nm from edit.reference_ixn_qualifier riq, edit.ixn_qualifier iq, edit.reference_ixn ri, edit.ixn i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 15 1 19s786ms 19s786ms -
select i.root_id, iq.nm from edit.REFERENCE_IXN_QUALIFIER riq, edit.IXN_QUALIFIER iq, edit.REFERENCE_IXN ri, edit.IXN i where riq.ixn_qualifier_id = iq.id and ri.id = riq.reference_ixn_id and ri.ixn_id = i.id;
Date: 2026-09-04 15:35:25 Duration: 19s786ms Bind query: yes
11 15s394ms 15s952ms 15s566ms 4 1m2s copy pubc.log_query_bots_original (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, 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, user_agent_pattern) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 06 1 15s497ms 15s497ms 10 1 15s421ms 15s421ms 14 1 15s952ms 15s952ms 18 1 15s394ms 15s394ms -
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 14:07:42 Duration: 15s952ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 06:07:34 Duration: 15s497ms
-
COPY pubc.log_query_bots_original (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, 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, user_agent_pattern) TO stdout;
Date: 2026-09-04 10:07:34 Duration: 15s421ms
12 14s979ms 15s205ms 15s100ms 4 1m copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 06 1 15s20ms 15s20ms 10 1 14s979ms 14s979ms 14 1 15s205ms 15s205ms 18 1 15s198ms 15s198ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:54 Duration: 15s205ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:54 Duration: 15s198ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:00:53 Duration: 15s20ms
13 14s492ms 15s509ms 14s861ms 4 59s445ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 06 1 14s638ms 14s638ms 10 1 14s492ms 14s492ms 14 1 15s509ms 15s509ms 18 1 14s804ms 14s804ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:10 Duration: 15s509ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:09 Duration: 14s804ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 06:01:07 Duration: 14s638ms
14 6s350ms 18s430ms 12s390ms 2 24s781ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 10 2 24s781ms 12s390ms [ User: pubeu - Total duration: 6s350ms - Times executed: 1 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1502608') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:28:46 Duration: 18s430ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1531906') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-09-04 10:35:13 Duration: 6s350ms Database: ctdprd51 User: pubeu Bind query: yes
15 10s181ms 11s252ms 10s589ms 4 42s359ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 00 4 42s359ms 10s589ms [ User: pubeu - Total duration: 31s764ms - Times executed: 3 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:54:00 Duration: 11s252ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:47 Duration: 10s595ms Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2205217') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-09-04 00:53:38 Duration: 10s330ms Database: ctdprd51 User: pubeu Bind query: yes
16 7s544ms 7s959ms 7s729ms 4 30s917ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 06 1 7s544ms 7s544ms 10 1 7s959ms 7s959ms 14 1 7s663ms 7s663ms 18 1 7s749ms 7s749ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:33 Duration: 7s959ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:32 Duration: 7s749ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:32 Duration: 7s663ms
17 6s519ms 6s858ms 6s642ms 4 26s570ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 06 1 6s519ms 6s519ms 10 1 6s545ms 6s545ms 14 1 6s858ms 6s858ms 18 1 6s647ms 6s647ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:01:18 Duration: 6s858ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:01:18 Duration: 6s647ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:01:18 Duration: 6s545ms
18 6s382ms 6s382ms 6s382ms 1 6s382ms vacuum analyze log_query_archive;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 00 1 6s382ms 6s382ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-09-04 00:09:30 Duration: 6s382ms
19 6s280ms 6s425ms 6s319ms 4 25s279ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 06 1 6s280ms 6s280ms 10 1 6s282ms 6s282ms 14 1 6s425ms 6s425ms 18 1 6s291ms 6s291ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 14:00:39 Duration: 6s425ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 18:00:39 Duration: 6s291ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-09-04 10:00:40 Duration: 6s282ms
20 5s649ms 5s848ms 5s748ms 2 11s497ms 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 #20
Day Hour Count Duration Avg duration Sep 04 05 2 11s497ms 5s748ms [ User: qaeu - Total duration: 5s848ms - Times executed: 1 ]
[ User: pubeu - Total duration: 5s649ms - 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 = 1404748)) 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-09-04 05:43:38 Duration: 5s848ms 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 = 1404748)) 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-09-04 05:48:38 Duration: 5s649ms Database: ctdprd51 User: pubeu Bind query: yes
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,665 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
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 7 Max number of times the same event was reported
- 10 Total events found
Rank Times reported Error 1 7 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 04 09 3 13 3 15 1 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-09-04 09:32:19 Database: ctdprd51 Application: User: load Remote:
Date: 2026-09-04 09:34:34
Date: 2026-09-04 09:44:35
2 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 04 19 3 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-09-04 19:42:23
Date: 2026-09-04 19:51:07 Database: ctdprd51 Application: pgAdmin 4 - CONN:5620679 User: pub1 Remote:
Date: 2026-09-04 19:59:52