pgBadger-
Global information
- Generated on Sat Jan 17 04:10:03 2026
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20260116
- Parsed 909 log entries in 2s
- Log start from 2026-01-16 10:46:21 to 2026-01-16 18:13:42
-
Overview
Global Stats
- 2 Number of unique normalized queries
- 24 Number of queries
- 10m10s Total query duration
- 2026-01-16 10:46:32 First query
- 2026-01-16 16:22:02 Last query
- 1 queries/s at 2026-01-16 10:58:58 Query peak
- 10m10s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10m10s Execute total duration
- 33 Number of events
- 7 Number of unique normalized events
- 12 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 95 Total number of sessions
- 8 sessions at 2026-01-16 16:18:01 Session peak
- 81d12h14m4s Total duration of sessions
- 20h35m30s Average duration of sessions
- 0 Average queries per session
- 6s427ms Average queries duration per session
- 20h35m24s Average idle time per session
- 95 Total number of connections
- 9 connections/s at 2026-01-16 15:54:58 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-16 10:58:58 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-16 10:58:58 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 10m10s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 16 10 9 0ms 1m 25s98ms 1m11s 1m11s 1m11s 11 9 0ms 1m6s 23s234ms 1m16s 1m16s 1m16s 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 6 0ms 1m8s 29s270ms 1m8s 1m8s 1m8s 18 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 16 10 9 0 25s98ms 1m 1m11s 1m11s 11 9 0 23s234ms 57s899ms 1m16s 1m16s 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 6 0 29s270ms 1m3s 1m8s 1m8s 18 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 16 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 18 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 16 10 0 9 9.00 0.00% 11 0 9 9.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 6 6.00 0.00% 18 0 0 0.00 0.00% Day Hour Count Average / Second Jan 16 10 3 0.00/s 11 12 0.00/s 12 13 0.00/s 13 13 0.00/s 14 15 0.00/s 15 34 0.01/s 16 5 0.00/s 18 0 0.00/s Day Hour Count Average Duration Average idle time Jan 16 10 3 1m22s 7s313ms 11 4 1m33s 41s6ms 12 13 30m52s 30m52s 13 12 30m39s 30m39s 14 15 30m42s 30m42s 15 42 1d21h56m43s 1d21h56m43s 16 5 18m44s 18m9s 18 1 4h17m41s 4h17m41s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-01-16 15:54:58 Date
Connections per database
Key values
- ctddev51 Main Database
- 95 connections Total
Connections per user
Key values
- pubeu Main User
- 95 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-01-16 16:18:01 Date
Histogram of session times
Key values
- 59 1800000-3600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 95 sessions Total
Sessions per user
Key values
- pubeu Main User
- 95 sessions Total
Sessions per host
Key values
- 192.168.201.6 Main Host
- 95 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 132 buffers Checkpoint Peak
- 2026-01-16 12:20:32 Date
- 13.438 seconds Highest write time
- 0.001 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-01-16 12:20:32 Date
Checkpoints distance
Key values
- 0.06 Mo Distance Peak
- 2026-01-16 12:20:32 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 16 10 0 0s 0s 0s 11 0 0s 0s 0s 12 132 13.438s 0.001s 13.453s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 18 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 16 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 8 0.001s 0.001s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jan 16 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 18 0 0s Day Hour Mean distance Mean estimate Jan 16 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 29.00 kB 33,559.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 16 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 18 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 16 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 18 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 24 Total read queries
- 0 Total write queries
Queries by database
Key values
- unknown Main database
- 16 Requests
- 9m13s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 16 Requests
User Request type Count Duration edit Total 8 57s393ms select 8 57s393ms unknown Total 16 9m13s select 16 9m13s Duration by user
Key values
- 9m13s (unknown) Main time consuming user
User Request type Count Duration edit Total 8 57s393ms select 8 57s393ms unknown Total 16 9m13s select 16 9m13s Queries by host
Key values
- unknown Main host
- 24 Requests
- 10m10s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 24 Requests
- 10m10s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-16 10:58:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 16 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1m8s select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 16:17:44 - Bind query: yes ]
2 1m6s select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 11:19:11 - Bind query: yes ]
3 1m3s select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 16:21:48 - Bind query: yes ]
4 1m select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 10:47:34 - Bind query: yes ]
5 55s692ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 10:52:49 - Bind query: yes ]
6 52s806ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 10:58:58 - Bind query: yes ]
7 44s469ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 11:01:35 - Bind query: yes ]
8 43s86ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;[ Date: 2026-01-16 11:04:13 - Bind query: yes ]
9 14s692ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 16:18:00 - Bind query: yes ]
10 13s430ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 11:01:50 - Bind query: yes ]
11 13s114ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 10:53:04 - Bind query: yes ]
12 12s894ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 16:22:02 - Bind query: yes ]
13 11s758ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 11:06:50 - Bind query: yes ]
14 11s442ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 10:47:47 - Bind query: yes ]
15 11s159ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 10:59:11 - Bind query: yes ]
16 10s775ms select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;[ Date: 2026-01-16 11:19:23 - Bind query: yes ]
17 8s670ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;[ Date: 2026-01-16 16:20:43 - Database: ctddev51 - User: edit - Bind query: yes ]
18 7s970ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;[ Date: 2026-01-16 16:16:34 - Database: ctddev51 - User: edit - Bind query: yes ]
19 7s785ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;[ Date: 2026-01-16 11:18:04 - Database: ctddev51 - User: edit - Bind query: yes ]
20 7s239ms select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 2;[ Date: 2026-01-16 10:58:03 - Database: ctddev51 - User: edit - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 8m31s 16 5s721ms 1m8s 31s959ms select id, object_type_id, acc_txt, t.acc_db_id, nm, nm_sort, secondary_nm, description, note from load.term t where object_type_id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 57s393ms - Times executed: 8 ]
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:17:44 Duration: 1m8s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 11:19:11 Duration: 1m6s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:21:48 Duration: 1m3s Bind query: yes
2 1m39s 8 10s775ms 14s692ms 12s408ms select distinct ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm, ( select string_agg(distinct iq.nm, ?)) from edit.ixn i inner join edit.ixn_actor iachem on i.root_id = iachem.ixn_id inner join edit.ixn_actor iadisease on i.root_id = iadisease.ixn_id inner join edit.ixn_action iact on i.root_id = iact.ixn_id inner join edit.action_type at on iact.action_type_id = at.id inner join edit.reference_ixn ri on i.root_id = ri.ixn_id inner join pub2.term chemterm on iachem.acc_txt = chemterm.acc_txt and chemterm.object_type_id = ? inner join pub2.term diseaseterm on iadisease.acc_txt = diseaseterm.acc_txt and diseaseterm.object_type_id = ? left outer join edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id left outer join edit.ixn_qualifier iq on riq.ixn_qualifier_id = iq.id where i.ixn_type_id = ? and iachem.object_type_id = ? and iadisease.object_type_id = ? group by ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 16 10 3 35s716ms 11s905ms 11 3 35s964ms 11s988ms 16 2 27s587ms 13s793ms -
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 16:18:00 Duration: 14s692ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 11:01:50 Duration: 13s430ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 10:53:04 Duration: 13s114ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 16 8m31s 5s721ms 1m8s 31s959ms select id, object_type_id, acc_txt, t.acc_db_id, nm, nm_sort, secondary_nm, description, note from load.term t where object_type_id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 57s393ms - Times executed: 8 ]
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:17:44 Duration: 1m8s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 11:19:11 Duration: 1m6s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:21:48 Duration: 1m3s Bind query: yes
2 8 1m39s 10s775ms 14s692ms 12s408ms select distinct ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm, ( select string_agg(distinct iq.nm, ?)) from edit.ixn i inner join edit.ixn_actor iachem on i.root_id = iachem.ixn_id inner join edit.ixn_actor iadisease on i.root_id = iadisease.ixn_id inner join edit.ixn_action iact on i.root_id = iact.ixn_id inner join edit.action_type at on iact.action_type_id = at.id inner join edit.reference_ixn ri on i.root_id = ri.ixn_id inner join pub2.term chemterm on iachem.acc_txt = chemterm.acc_txt and chemterm.object_type_id = ? inner join pub2.term diseaseterm on iadisease.acc_txt = diseaseterm.acc_txt and diseaseterm.object_type_id = ? left outer join edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id left outer join edit.ixn_qualifier iq on riq.ixn_qualifier_id = iq.id where i.ixn_type_id = ? and iachem.object_type_id = ? and iadisease.object_type_id = ? group by ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 16 10 3 35s716ms 11s905ms 11 3 35s964ms 11s988ms 16 2 27s587ms 13s793ms -
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 16:18:00 Duration: 14s692ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 11:01:50 Duration: 13s430ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 10:53:04 Duration: 13s114ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 5s721ms 1m8s 31s959ms 16 8m31s select id, object_type_id, acc_txt, t.acc_db_id, nm, nm_sort, secondary_nm, description, note from load.term t where object_type_id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 57s393ms - Times executed: 8 ]
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:17:44 Duration: 1m8s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 11:19:11 Duration: 1m6s Bind query: yes
-
select ID, OBJECT_TYPE_ID, ACC_TXT, t.ACC_DB_ID, NM, NM_SORT, SECONDARY_NM, DESCRIPTION, NOTE from load.term t where object_type_id = 1;
Date: 2026-01-16 16:21:48 Duration: 1m3s Bind query: yes
2 10s775ms 14s692ms 12s408ms 8 1m39s select distinct ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm, ( select string_agg(distinct iq.nm, ?)) from edit.ixn i inner join edit.ixn_actor iachem on i.root_id = iachem.ixn_id inner join edit.ixn_actor iadisease on i.root_id = iadisease.ixn_id inner join edit.ixn_action iact on i.root_id = iact.ixn_id inner join edit.action_type at on iact.action_type_id = at.id inner join edit.reference_ixn ri on i.root_id = ri.ixn_id inner join pub2.term chemterm on iachem.acc_txt = chemterm.acc_txt and chemterm.object_type_id = ? inner join pub2.term diseaseterm on iadisease.acc_txt = diseaseterm.acc_txt and diseaseterm.object_type_id = ? left outer join edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id left outer join edit.ixn_qualifier iq on riq.ixn_qualifier_id = iq.id where i.ixn_type_id = ? and iachem.object_type_id = ? and iadisease.object_type_id = ? group by ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemterm.nm, diseaseterm.nm;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 16 10 3 35s716ms 11s905ms 11 3 35s964ms 11s988ms 16 2 27s587ms 13s793ms -
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 16:18:00 Duration: 14s692ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 11:01:50 Duration: 13s430ms Bind query: yes
-
select DISTINCT ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm, ( SELECT STRING_AGG(DISTINCT iq.nm, '|')) from edit.IXN i INNER JOIN edit.IXN_ACTOR iaChem ON i.root_id = iaChem.ixn_id INNER JOIN edit.IXN_ACTOR iaDisease ON i.root_id = iaDisease.ixn_id INNER JOIN edit.IXN_ACTION iAct ON i.root_id = iAct.ixn_id INNER JOIN edit.ACTION_TYPE at ON iAct.action_type_id = at.id INNER JOIN edit.REFERENCE_IXN ri ON i.root_id = ri.ixn_id INNER JOIN pub2.TERM chemTerm ON iaChem.acc_txt = chemTerm.acc_txt and chemTerm.object_type_id = 2 INNER JOIN pub2.TERM diseaseTerm ON iaDisease.acc_txt = diseaseTerm.acc_txt and diseaseTerm.object_type_id = 3 LEFT OUTER JOIN edit.REFERENCE_IXN_QUALIFIER riq ON ri.id = riq.reference_ixn_id LEFT OUTER JOIN edit.IXN_QUALIFIER iq ON riq.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 group by ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id, chemTerm.nm, diseaseTerm.nm;
Date: 2026-01-16 10:53:04 Duration: 13s114ms 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
- 465 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
- 24 ERROR entries
- 0 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 12 Max number of times the same event was reported
- 33 Total events found
Rank Times reported Error 1 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 16 13 1 14 4 15 7 - ERROR: syntax error at or near "select" at character 15
- ERROR: syntax error at or near "," at character 10
- ERROR: syntax error at or near "," at character 65
Statement: select * from select * from chem_conc limit 100 --select * --from chem_conc_anatomy
Date: 2026-01-16 13:56:01 Database: ctddev51 Application: pgAdmin 4 - CONN:909476 User: load Remote:
Statement: SELECT ,id -- id ,reference_acc_txt -- reference_acc_txt ,reference_acc_db_id -- reference_acc_db_id ,chem_acc_txt -- chem_acc_txt ,chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,chem_conc -- chem_conc ,chem_conc_range -- chem_conc_range ,taxon_acc_txt -- taxon_acc_txt ,taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,disease_acc_txt -- disease_acc_txt ,disease_acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.Nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,note -- note ,action_type_cd -- action_type_cd ,chem_co_nm -- chem_co_nm ,chem_catalog_nbr -- chem_catalog_nbr FROM load.chem_conc cc ,load.term chemerm ,load.term taxonTerm ,load.term diseaseTerm ,edit.chem_conc_exp_route chemConcExpRoute ,edit.ixn_qualifier ixnQualifier WHERE cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) ------------------------------------------------------ AND cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ AND cc.disease_acc_txt = diseaseTerm.acc_txt AND cc.disease_acc_db_id = diseaseTerm.acc_db_id AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 14:41:53
Statement: ------------------------------------------------------ SELECT ,cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,cc.disease_acc_txt -- disease_acc_txt ,cc.disease_acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc ,load.term chemerm ,load.term taxonTerm ,load.term diseaseTerm ,edit.chem_conc_exp_route chemConcExpRoute ,edit.ixn_qualifier ixnQualifier ,edit.action_type actionType ------------------------------------------------------ WHERE cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) ------------------------------------------------------ AND cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ AND cc.disease_acc_txt = diseaseTerm.acc_txt AND cc.disease_acc_db_id = diseaseTerm.acc_db_id AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 14:46:23
2 8 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 16 10 3 11 3 16 2 3 7 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 16 14 2 15 5 - ERROR: column chemterm.nm_html does not exist at character 444
- ERROR: column cc.disease_acc_txt does not exist at character 885
- ERROR: column chemterm.acc_db_id does not exist at character 1786
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,cc.disease_acc_txt -- disease_acc_txt ,cc.disease_acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc ,load.term chemTerm ,load.term taxonTerm ,load.term diseaseTerm ,edit.chem_conc_exp_route chemConcExpRoute ,edit.ixn_qualifier ixnQualifier ,edit.action_type actionType ------------------------------------------------------ WHERE cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) ------------------------------------------------------ AND cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ AND cc.disease_acc_txt = diseaseTerm.acc_txt AND cc.disease_acc_db_id = diseaseTerm.acc_db_id AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 14:47:20
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,cc.disease_acc_txt -- disease_acc_txt ,cc.disease_acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc ,pub1.term chemTerm ,pub1.term taxonTerm ,pub1.term diseaseTerm ,edit.chem_conc_exp_route chemConcExpRoute ,edit.ixn_qualifier ixnQualifier ,edit.action_type actionType ------------------------------------------------------ WHERE cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) ------------------------------------------------------ AND cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ AND cc.disease_acc_txt = diseaseTerm.acc_txt AND cc.disease_acc_db_id = diseaseTerm.acc_db_id AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 14:49:03
Hint: Perhaps you meant to reference the column "chemterm.acc_db_cd".
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html -- ,cc.chem_conc -- chem_conc -- ,cc.chem_conc_range -- chem_conc_range -- ,cc.taxon_acc_txt -- taxon_acc_txt -- ,cc.taxon_acc_db_id -- taxon_acc_db_id -- ,taxonTerm.nm -- taxon_nm -- ,taxonTerm.nm_html -- taxon_nm_html -- ,cc.disease_acc_txt -- disease_acc_txt -- ,cc.disease_acc_db_id -- disease_acc_db_id -- ,diseaseTerm.nm -- disease_nm -- ,diseaseTerm.nm_html -- disease_nm_html -- ,chemConcExpRoute.nm -- chem_conc_exp_route_nm -- ,ixnQualifier.nm -- ixn_qualifier_nm -- ,cc.note -- note -- ,actionType.cd -- action_type_cd -- ,cc.chem_co_nm -- chem_co_nm -- ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub1.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) -- INNER JOIN pub1.term taxonTerm ON -- cc.taxon_acc_txt = taxonTerm.acc_txt AND -- cc.taxon_acc_db_id = taxonTerm.acc_db_id AND -- taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) -- INNER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc. -- INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.chem_conc_exp_route_id = chemConcExpRoute.id -- INNER JOIN edit.action_type actionType -- INNER JOIN ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id -- left_outer join ixn i ON cc.ixn_id = i.id ON cc.ixn_qualifier_id = ixnQualifier.id -- INNER JOIN pub1.term diseaseTerm -- ,ixn_actor ia ------------------------------------------------------ -- WHERE cc.chem_acc_txt = chemTerm.acc_txt -- AND cc.chem_acc_db_id = chemTerm.acc_db_id -- AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) -- ------------------------------------------------------ -- AND cc.taxon_acc_txt = taxonTerm.acc_txt -- AND cc.taxon_acc_db_id = taxonTerm.acc_db_id -- AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ --AND cc.disease_acc_txt = diseaseTerm.acc_txt --AND cc.disease_acc_db_id = diseaseTerm.acc_db_id --AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ --AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ --AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100Date: 2026-01-16 15:20:46
4 3 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 16 14 1 15 2 - ERROR: missing FROM-clause entry for table "chemterm" at character 381
- ERROR: missing FROM-clause entry for table "actiontype" at character 1336
- ERROR: missing FROM-clause entry for table "chemconcexproute" at character 2387
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html ,cc.disease_acc_txt -- disease_acc_txt ,cc.disease_acc_db_id -- disease_acc_db_id ,diseaseTerm.nm -- disease_nm ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc ,load.term chemerm ,load.term taxonTerm ,load.term diseaseTerm ,edit.chem_conc_exp_route chemConcExpRoute ,edit.ixn_qualifier ixnQualifier ,edit.action_type actionType ------------------------------------------------------ WHERE cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) ------------------------------------------------------ AND cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ AND cc.disease_acc_txt = diseaseTerm.acc_txt AND cc.disease_acc_db_id = diseaseTerm.acc_db_id AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 14:46:50
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html -- ,cc.disease_acc_txt -- disease_acc_txt -- ,cc.disease_acc_db_id -- disease_acc_db_id -- ,diseaseTerm.nm -- disease_nm -- ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.exp_route -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub1.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND -- cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub1.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND -- cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) INNER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.chem_conc_exp_route_id = chemConcExpRoute.id -- INNER JOIN edit.action_type actionType -- INNER JOIN ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id -- left_outer join ixn i ON cc.ixn_id = i.id ON cc.ixn_qualifier_id = ixnQualifier.id -- INNER JOIN pub1.term diseaseTerm -- ,ixn_actor ia ------------------------------------------------------ -- WHERE cc.chem_acc_txt = chemTerm.acc_txt -- AND cc.chem_acc_db_id = chemTerm.acc_db_id -- AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) -- ------------------------------------------------------ -- AND cc.taxon_acc_txt = taxonTerm.acc_txt -- AND cc.taxon_acc_db_id = taxonTerm.acc_db_id -- AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ --AND cc.disease_acc_txt = diseaseTerm.acc_txt --AND cc.disease_acc_db_id = diseaseTerm.acc_db_id --AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ --AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ --AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 15:46:39
Statement: ------------------------------------------------------ SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html -- ,cc.disease_acc_txt -- disease_acc_txt -- ,cc.disease_acc_db_id -- disease_acc_db_id -- ,diseaseTerm.nm -- disease_nm -- ,diseaseTerm.nm_html -- disease_nm_html -- ,chemConcExpRoute.exp_route -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note -- ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub1.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND -- cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub1.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND -- cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) -- INNER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.chem_conc_exp_route_id = chemConcExpRoute.id -- INNER JOIN edit.action_type actionType -- INNER JOIN ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id -- left_outer join ixn i ON cc.ixn_id = i.id ON cc.ixn_qualifier_id = ixnQualifier.id -- INNER JOIN pub1.term diseaseTerm -- ,ixn_actor ia ------------------------------------------------------ -- WHERE cc.chem_acc_txt = chemTerm.acc_txt -- AND cc.chem_acc_db_id = chemTerm.acc_db_id -- AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) -- ------------------------------------------------------ -- AND cc.taxon_acc_txt = taxonTerm.acc_txt -- AND cc.taxon_acc_db_id = taxonTerm.acc_db_id -- AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) ------------------------------------------------------ --AND cc.disease_acc_txt = diseaseTerm.acc_txt --AND cc.disease_acc_db_id = diseaseTerm.acc_db_id --AND diseaseTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'disease' ) ------------------------------------------------------ --AND cc.chem_conc_exp_route_id = chemConcExpRoute.id ------------------------------------------------------ --AND cc.ixn_qualifier_id = ixnQualifier.id ------------------------------------------------------ limit 100
Date: 2026-01-16 15:49:03
5 1 ERROR: syntax error at end of input
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 16 15 1 - ERROR: syntax error at end of input at character 2627
Statement: SELECT cc.id -- id ,cc.reference_acc_txt -- reference_acc_txt ,cc.reference_acc_db_id -- reference_acc_db_id ,cc.chem_acc_txt -- chem_acc_txt ,cc.chem_acc_db_id -- chem_acc_db_id ,chemTerm.nm -- chem_nm ,chemTerm.nm_html -- chem_nm_html ,cc.chem_conc -- chem_conc ,cc.chem_conc_range -- chem_conc_range ,cc.taxon_acc_txt -- taxon_acc_txt ,cc.taxon_acc_db_id -- taxon_acc_db_id ,taxonTerm.nm -- taxon_nm ,taxonTerm.nm_html -- taxon_nm_html -- ,cc.disease_acc_txt -- disease_acc_txt -- ,cc.disease_acc_db_id -- disease_acc_db_id -- ,diseaseTerm.nm -- disease_nm -- ,diseaseTerm.nm_html -- disease_nm_html ,chemConcExpRoute.nm -- chem_conc_exp_route_nm ,ixnQualifier.nm -- ixn_qualifier_nm ,cc.note -- note ,actionType.cd -- action_type_cd ,cc.chem_co_nm -- chem_co_nm ,cc.chem_catalog_nbr -- chem_catalog_nbr ------------------------------------------------------ FROM load.chem_conc cc INNER JOIN pub1.term chemTerm ON cc.chem_acc_txt = chemTerm.acc_txt AND cc.chem_acc_db_id = chemTerm.acc_db_id AND chemTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'chem' ) INNER JOIN pub1.term taxonTerm ON cc.taxon_acc_txt = taxonTerm.acc_txt AND cc.taxon_acc_db_id = taxonTerm.acc_db_id AND taxonTerm.object_type_id = ( SELECT id FROM edit.object_type WHERE cd = 'taxon' ) INNER JOIN edit.chem_conc_exp_route chemConcExpRoute ON cc. INNER JOIN edit.ixn_qualifier ixnQualifier ON cc.chem_conc_exp_route_id = chemConcExpRoute.id INNER JOIN edit.action_type actionType INNER JOIN ixn_qualifier ixnQualifier ON cc.ixn_qualifier_id = ixnQualifier.id -- left_outer join ixn i ON cc.ixn_id = i.id ON cc.ixn_qualifier_id = ixnQualifier.id -- INNER JOIN pub1.term diseaseTerm -- ,ixn_actor ia
Date: 2026-01-16 15:18:20
6 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 16 15 1 - ERROR: relation "chem_conc_exp_route" does not exist at character 15
Statement: select * from chem_conc_exp_route limit 100
Date: 2026-01-16 15:41:20
7 1 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 16 18 1