pgBadger-
Global information
- Generated on Sat Nov 15 04:10:04 2025
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20251114
- Parsed 4,554 log entries in 3s
- Log start from 2025-11-10 10:16:33 to 2025-11-14 18:34:36
-
Overview
Global Stats
- 8 Number of unique normalized queries
- 42 Number of queries
- 8m6s Total query duration
- 2025-11-10 10:16:45 First query
- 2025-11-14 16:47:37 Last query
- 2 queries/s at 2025-11-11 15:12:08 Query peak
- 8m6s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8m6s Execute total duration
- 105 Number of events
- 12 Number of unique normalized events
- 49 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 4 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 497 Total number of sessions
- 38 sessions at 2025-11-11 15:12:04 Session peak
- 1817d5h25m13s Total duration of sessions
- 3d15h45m12s Average duration of sessions
- 0 Average queries per session
- 978ms Average queries duration per session
- 3d15h45m11s Average idle time per session
- 502 Total number of connections
- 15 connections/s at 2025-11-11 15:12:02 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-11 15:12:08 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-11 15:12:08 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 8m6s 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) Nov 10 10 5 0ms 9s828ms 7s700ms 9s828ms 9s828ms 9s828ms 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 Nov 11 09 2 5s829ms 7s397ms 6s613ms 13s227ms 13s227ms 13s227ms 10 5 0ms 10s136ms 8s6ms 10s136ms 10s136ms 10s136ms 11 2 0ms 7s968ms 6s510ms 13s20ms 13s20ms 13s20ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 4 0ms 8s350ms 6s873ms 6s888ms 8s350ms 8s350ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 7 0ms 8s448ms 6s303ms 44s122ms 44s122ms 44s122ms 16 6 0ms 11s157ms 8s50ms 9s319ms 16s638ms 16s638ms Nov 12 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 13 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 5 0ms 1m3s 20s359ms 12s91ms 1m10s 1m10s 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 22 1 0ms 18s68ms 18s68ms 18s68ms 18s68ms 18s68ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 14 00 0 0ms 0ms 0ms 0ms 0ms 0ms 16 5 0ms 1m1s 28s362ms 1m7s 1m7s 1m7s 18 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 10 10 5 0 7s700ms 8s888ms 9s828ms 9s828ms 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 Nov 11 09 2 0 6s613ms 13s227ms 13s227ms 13s227ms 10 5 0 8s6ms 8s605ms 10s136ms 10s136ms 11 2 0 6s510ms 0ms 13s20ms 13s20ms 12 0 0 0ms 0ms 0ms 0ms 13 4 0 6s873ms 6s234ms 6s888ms 8s350ms 14 0 0 0ms 0ms 0ms 0ms 15 7 0 6s303ms 0ms 44s122ms 44s122ms 16 6 0 8s50ms 8s275ms 9s319ms 16s638ms Nov 12 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms Nov 13 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 5 0 20s359ms 9s945ms 12s91ms 1m10s 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 22 1 0 18s68ms 18s68ms 18s68ms 18s68ms 23 0 0 0ms 0ms 0ms 0ms Nov 14 00 0 0 0ms 0ms 0ms 0ms 16 5 0 28s362ms 56s442ms 1m7s 1m7s 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) Nov 10 10 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 Nov 11 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 Nov 12 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 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms Nov 13 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 18 0 0 0 0 0ms 0ms 0ms 0ms 19 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 Nov 14 00 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 Nov 10 10 0 5 5.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% Nov 11 09 0 2 2.00 0.00% 10 0 5 5.00 0.00% 11 0 2 2.00 0.00% 12 0 0 0.00 0.00% 13 0 4 4.00 0.00% 14 0 0 0.00 0.00% 15 0 7 7.00 0.00% 16 0 6 6.00 0.00% Nov 12 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% Nov 13 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 5 5.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Nov 14 00 0 0 0.00 0.00% 16 0 5 5.00 0.00% 18 0 0 0.00 0.00% Day Hour Count Average / Second Nov 10 10 4 0.00/s 12 48 0.01/s 13 21 0.01/s 14 30 0.01/s 15 3 0.00/s Nov 11 09 1 0.00/s 10 14 0.00/s 11 17 0.00/s 12 16 0.00/s 13 19 0.01/s 14 28 0.01/s 15 64 0.02/s 16 11 0.00/s Nov 12 09 17 0.00/s 10 14 0.00/s 11 28 0.01/s 12 14 0.00/s 13 20 0.01/s 14 9 0.00/s 15 0 0.00/s 18 0 0.00/s 19 0 0.00/s Nov 13 09 9 0.00/s 10 16 0.00/s 11 16 0.00/s 12 24 0.01/s 13 13 0.00/s 14 0 0.00/s 15 1 0.00/s 16 0 0.00/s 18 0 0.00/s 19 0 0.00/s 22 17 0.00/s 23 15 0.00/s Nov 14 00 10 0.00/s 16 3 0.00/s 18 0 0.00/s Day Hour Count Average Duration Average idle time Nov 10 10 4 17s973ms 8s347ms 12 48 11h43m38s 11h43m38s 13 21 13m43s 13m43s 14 30 17m3s 17m3s 15 3 30m10s 30m10s Nov 11 09 1 18s718ms 5s490ms 10 6 14s40ms 7s368ms 11 17 28m57s 28m56s 12 16 30m40s 30m40s 13 19 25m52s 25m51s 14 60 29d5h12m23s 29d5h12m23s 15 37 21h52m47s 21h52m46s 16 19 18m16s 18m13s Nov 12 09 9 30m44s 30m44s 10 14 32m37s 32m37s 11 18 26m6s 26m6s 12 14 31m54s 31m54s 13 17 30m10s 30m10s 14 17 18m20s 18m20s 15 0 0ms 0ms 18 1 5h21m8s 5h21m8s 19 2 6h13m40s 6h13m40s Nov 13 09 1 208ms 208ms 10 16 30m34s 30m34s 11 16 31m35s 31m35s 12 24 23m19s 23m19s 13 20 19m29s 19m24s 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 18 1 2h32m49s 2h32m49s 19 1 6h18m44s 6h18m44s 22 9 24m53s 24m51s 23 15 35m30s 35m30s Nov 14 00 18 26m52s 26m52s 16 2 1m19s 9s43ms 18 1 2h15m45s 2h15m45s -
Connections
Established Connections
Key values
- 15 connections Connection Peak
- 2025-11-11 15:12:02 Date
Connections per database
Key values
- ctddev51 Main Database
- 502 connections Total
Connections per user
Key values
- pubeu Main User
- 502 connections Total
-
Sessions
Simultaneous sessions
Key values
- 38 sessions Session Peak
- 2025-11-11 15:12:04 Date
Histogram of session times
Key values
- 284 1800000-3600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 497 sessions Total
Sessions per user
Key values
- pubeu Main User
- 497 sessions Total
Sessions per host
Key values
- 192.168.201.10 Main Host
- 497 sessions Total
Host Count Total Duration Average Duration 10.12.5.37 126 32d4h22m58s 6h7m48s 10.12.5.38 10 751d16h1m19s 75d4h7s 10.12.5.39 12 480d23h55m16s 40d1h59m36s 10.12.5.40 12 512d2h3m54s 42d16h10m19s 192.168.201.10 252 4d22h46m43s 28m16s 192.168.201.18 9 33d6h27m25s 3d16h43m2s 192.168.201.6 74 2d1h47m35s 40m22s [local] 2 65ms 32ms -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 121 buffers Checkpoint Peak
- 2025-11-12 11:42:03 Date
- 12.216 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 1 files Wal files usage Peak
- 2025-11-11 15:03:47 Date
Checkpoints distance
Key values
- 20.08 Mo Distance Peak
- 2025-11-11 15:03:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 10 10 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s Nov 11 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 11 1.185s 0.001s 1.2s 14 0 0s 0s 0s 15 18 0.929s 0.003s 1.028s 16 3 0.481s 0.001s 0.496s Nov 12 09 0 0s 0s 0s 10 7 0.824s 0.001s 0.841s 11 203 20.642s 0.006s 20.676s 12 6 0.697s 0.001s 0.711s 13 114 11.653s 0.002s 11.723s 14 0 0s 0s 0s 15 13 1.416s 0.001s 1.431s 18 0 0s 0s 0s 19 0 0s 0s 0s Nov 13 09 3 0.517s 0.001s 0.531s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 8 0.875s 0.001s 0.89s 13 15 1.691s 0.002s 1.72s 14 86 8.712s 0.003s 8.731s 15 0 0s 0s 0s 16 5 0.722s 0.001s 0.738s 18 0 0s 0s 0s 19 0 0s 0s 0s 22 1 0.28s 0.001s 0.295s 23 6 0.677s 0.001s 0.692s Nov 14 00 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 Nov 10 10 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s Nov 11 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 7 0.001s 0.001s 14 0 0 0 0 0s 0s 15 0 0 1 11 0.001s 0.002s 16 0 0 0 2 0.001s 0.001s Nov 12 09 0 0 0 0 0s 0s 10 0 0 0 7 0.001s 0.001s 11 0 0 0 94 0.002s 0.002s 12 0 0 0 6 0.001s 0.001s 13 0 0 0 49 0.001s 0.002s 14 0 0 0 0 0s 0s 15 0 0 0 10 0.001s 0.001s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s Nov 13 09 0 0 0 3 0.001s 0.001s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 7 0.001s 0.001s 13 0 0 0 14 0.001s 0.002s 14 0 0 0 48 0.001s 0.001s 15 0 0 0 0 0s 0s 16 0 0 0 3 0.001s 0.001s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 22 0 0 0 1 0.001s 0.001s 23 0 0 0 6 0.001s 0.001s Nov 14 00 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) Nov 10 10 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s Nov 11 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s Nov 12 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 18 0 0s 19 0 0s Nov 13 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 18 0 0s 19 0 0s 22 0 0s 23 0 0s Nov 14 00 0 0s 16 0 0s 18 0 0s Day Hour Mean distance Mean estimate Nov 10 10 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB Nov 11 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 46.00 kB 378.00 kB 14 0.00 kB 0.00 kB 15 3,447.67 kB 3,447.67 kB 16 7.00 kB 11.00 kB Nov 12 09 0.00 kB 0.00 kB 10 20.00 kB 20.00 kB 11 464.50 kB 464.50 kB 12 24.00 kB 513.00 kB 13 257.00 kB 471.00 kB 14 0.00 kB 0.00 kB 15 49.00 kB 433.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB Nov 13 09 6.00 kB 390.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 34.00 kB 355.00 kB 13 27.50 kB 307.50 kB 14 489.00 kB 489.00 kB 15 0.00 kB 0.00 kB 16 15.00 kB 442.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 22 6.00 kB 398.00 kB 23 27.00 kB 361.00 kB Nov 14 00 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 Nov 10 10 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 Nov 11 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 Nov 12 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 18 0 0 0 19 0 0 0 Nov 13 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 18 0 0 0 19 0 0 0 22 0 0 0 23 0 0 0 Nov 14 00 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
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- pg_catalog.pg_class (2) Main table analyzed (database ctddev51)
- 4 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 Nov 10 10 0 0 12 0 0 13 0 0 14 0 0 15 0 0 Nov 11 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 Nov 12 09 0 0 10 0 0 11 0 1 12 0 0 13 0 0 14 0 2 15 0 0 18 0 0 19 0 0 Nov 13 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 1 15 0 0 16 0 0 18 0 0 19 0 0 22 0 0 23 0 0 Nov 14 00 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
- 42 Total read queries
- 0 Total write queries
Queries by database
Key values
- ctddev51 Main database
- 29 Requests
- 4m6s (ctddev51)
- Main time consuming database
Queries by user
Key values
- load Main user
- 18 Requests
User Request type Count Duration edit Total 7 1m7s select 7 1m7s editeu Total 4 27s150ms select 4 27s150ms load Total 18 2m26s select 18 2m26s pubeu Total 2 23s880ms select 2 23s880ms unknown Total 16 6m3s select 16 6m3s Duration by user
Key values
- 6m3s (unknown) Main time consuming user
User Request type Count Duration edit Total 7 1m7s select 7 1m7s editeu Total 4 27s150ms select 4 27s150ms load Total 18 2m26s select 18 2m26s pubeu Total 2 23s880ms select 2 23s880ms unknown Total 16 6m3s select 16 6m3s Queries by host
Key values
- unknown Main host
- 47 Requests
- 10m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 42 Requests
- 8m6s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-13 12:13:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 34 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 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: 2025-11-13 13:45:26 - Bind query: yes ]
2 1m1s 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: 2025-11-14 16:47:29 - Bind query: yes ]
3 56s442ms 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: 2025-11-14 16:45:26 - Bind query: yes ]
4 18s68ms select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'LEAD')) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'LIVER'))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;[ Date: 2025-11-13 22:54:34 - Database: ctddev51 - User: pubeu - Bind query: yes ]
5 12s91ms 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: 2025-11-13 13:44:21 - Database: ctddev51 - User: edit - Bind query: yes ]
6 11s791ms 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: 2025-11-14 16:46:26 - Database: ctddev51 - User: edit - Bind query: yes ]
7 11s157ms 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: 2025-11-11 16:30:17 - Database: ctddev51 - User: load - Bind query: yes ]
8 10s136ms 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: 2025-11-11 10:48:54 - Database: ctddev51 - User: load - Bind query: yes ]
9 9s945ms 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: 2025-11-13 13:38:39 - Database: ctddev51 - User: edit - Bind query: yes ]
10 9s828ms 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: 2025-11-10 10:18:53 - Database: ctddev51 - User: load - Bind query: yes ]
11 9s319ms 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: 2025-11-11 16:32:36 - Database: ctddev51 - User: load - Bind query: yes ]
12 8s989ms 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: 2025-11-13 13:43:21 - Database: ctddev51 - User: edit - Bind query: yes ]
13 8s888ms 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: 2025-11-10 10:16:45 - Database: ctddev51 - User: load - Bind query: yes ]
14 8s778ms 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: 2025-11-10 10:41:47 - Database: ctddev51 - User: load - Bind query: yes ]
15 8s605ms 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: 2025-11-11 10:25:23 - Database: ctddev51 - User: load - Bind query: yes ]
16 8s448ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;[ Date: 2025-11-11 15:12:10 - Database: ctddev51 - User: editeu - Bind query: yes ]
17 8s350ms 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: 2025-11-11 13:15:54 - Database: ctddev51 - User: load - Bind query: yes ]
18 8s275ms 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: 2025-11-11 16:31:46 - Database: ctddev51 - User: load - Bind query: yes ]
19 7s968ms 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: 2025-11-11 11:00:28 - Database: ctddev51 - User: load - Bind query: yes ]
20 7s806ms select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;[ Date: 2025-11-11 15:12:10 - Database: ctddev51 - User: editeu - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6m16s 26 5s764ms 1m3s 14s497ms 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 Nov 10 10 4 33s259ms 8s314ms Nov 11 09 1 7s397ms 7s397ms 10 5 40s34ms 8s6ms 11 1 7s968ms 7s968ms 13 3 21s261ms 7s87ms 16 4 36s450ms 9s112ms Nov 13 13 4 1m34s 23s729ms Nov 14 16 4 2m15s 33s914ms [ User: load - Total duration: 2m26s - Times executed: 18 ]
[ User: edit - Total duration: 49s219ms - Times executed: 5 ]
-
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: 2025-11-13 13:45:26 Duration: 1m3s 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: 2025-11-14 16:47:29 Duration: 1m1s 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: 2025-11-14 16:45:26 Duration: 56s442ms Bind query: yes
2 34s210ms 6 5s52ms 6s370ms 5s701ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 10 1 5s242ms 5s242ms Nov 11 09 1 5s829ms 5s829ms 11 1 5s52ms 5s52ms 13 1 6s234ms 6s234ms 16 2 11s851ms 5s925ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 16:28:02 Duration: 6s370ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 13:14:02 Duration: 6s234ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 09:51:35 Duration: 5s829ms Bind query: yes
3 27s150ms 4 5s79ms 8s448ms 6s787ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 15 4 27s150ms 6s787ms [ User: editeu - Total duration: 27s150ms - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 8s448ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 7s806ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:08 Duration: 5s815ms Database: ctddev51 User: editeu Bind query: yes
4 18s68ms 1 18s68ms 18s68ms 18s68ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 22 1 18s68ms 18s68ms [ User: pubeu - Total duration: 18s68ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'LEAD')) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'LIVER'))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;
Date: 2025-11-13 22:54:34 Duration: 18s68ms Database: ctddev51 User: pubeu Bind query: yes
5 13s35ms 2 6s155ms 6s880ms 6s517ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 13 13 1 6s880ms 6s880ms Nov 14 16 1 6s155ms 6s155ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-13 13:45:35 Duration: 6s880ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-14 16:47:37 Duration: 6s155ms Bind query: yes
6 6s126ms 1 6s126ms 6s126ms 6s126ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select go_term_id from gene_go_annot gga where gga.taxon_id = ( select id from term where acc_txt = ? and object_type_id = ( select id from object_type where cd = ?)) and gga.is_not = ?) and p.ancestor_object_id not in ( select c.id from term c where c.acc_txt in (...) and c.object_type_id = ( select id from object_type where cd = ?));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 11 15 1 6s126ms 6s126ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));
Date: 2025-11-11 15:12:23 Duration: 6s126ms Bind query: yes
7 5s811ms 1 5s811ms 5s811ms 5s811ms select count(distinct gene_id) from gene_taxon where taxon_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 11 15 1 5s811ms 5s811ms [ User: pubeu - Total duration: 5s811ms - Times executed: 1 ]
-
select count(distinct gene_id) from GENE_TAXON where taxon_id = 567423;
Date: 2025-11-11 15:12:11 Duration: 5s811ms Database: ctddev51 User: pubeu Bind query: yes
8 5s34ms 1 5s34ms 5s34ms 5s34ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select disease_id from gene_disease_reference gdr where gdr.source_cd in (...) and gene_id in ( select gene_id from gene_taxon where taxon_id = ?)) and p.ancestor_object_id <> ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 11 15 1 5s34ms 5s34ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 567423)) and p.ancestor_object_id <> 2123366;
Date: 2025-11-11 15:12:16 Duration: 5s34ms Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 26 6m16s 5s764ms 1m3s 14s497ms 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 Nov 10 10 4 33s259ms 8s314ms Nov 11 09 1 7s397ms 7s397ms 10 5 40s34ms 8s6ms 11 1 7s968ms 7s968ms 13 3 21s261ms 7s87ms 16 4 36s450ms 9s112ms Nov 13 13 4 1m34s 23s729ms Nov 14 16 4 2m15s 33s914ms [ User: load - Total duration: 2m26s - Times executed: 18 ]
[ User: edit - Total duration: 49s219ms - Times executed: 5 ]
-
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: 2025-11-13 13:45:26 Duration: 1m3s 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: 2025-11-14 16:47:29 Duration: 1m1s 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: 2025-11-14 16:45:26 Duration: 56s442ms Bind query: yes
2 6 34s210ms 5s52ms 6s370ms 5s701ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 10 1 5s242ms 5s242ms Nov 11 09 1 5s829ms 5s829ms 11 1 5s52ms 5s52ms 13 1 6s234ms 6s234ms 16 2 11s851ms 5s925ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 16:28:02 Duration: 6s370ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 13:14:02 Duration: 6s234ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 09:51:35 Duration: 5s829ms Bind query: yes
3 4 27s150ms 5s79ms 8s448ms 6s787ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 15 4 27s150ms 6s787ms [ User: editeu - Total duration: 27s150ms - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 8s448ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 7s806ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:08 Duration: 5s815ms Database: ctddev51 User: editeu Bind query: yes
4 2 13s35ms 6s155ms 6s880ms 6s517ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 13 1 6s880ms 6s880ms Nov 14 16 1 6s155ms 6s155ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-13 13:45:35 Duration: 6s880ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-14 16:47:37 Duration: 6s155ms Bind query: yes
5 1 18s68ms 18s68ms 18s68ms 18s68ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 13 22 1 18s68ms 18s68ms [ User: pubeu - Total duration: 18s68ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'LEAD')) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'LIVER'))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;
Date: 2025-11-13 22:54:34 Duration: 18s68ms Database: ctddev51 User: pubeu Bind query: yes
6 1 6s126ms 6s126ms 6s126ms 6s126ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select go_term_id from gene_go_annot gga where gga.taxon_id = ( select id from term where acc_txt = ? and object_type_id = ( select id from object_type where cd = ?)) and gga.is_not = ?) and p.ancestor_object_id not in ( select c.id from term c where c.acc_txt in (...) and c.object_type_id = ( select id from object_type where cd = ?));Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 11 15 1 6s126ms 6s126ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));
Date: 2025-11-11 15:12:23 Duration: 6s126ms Bind query: yes
7 1 5s811ms 5s811ms 5s811ms 5s811ms select count(distinct gene_id) from gene_taxon where taxon_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 11 15 1 5s811ms 5s811ms [ User: pubeu - Total duration: 5s811ms - Times executed: 1 ]
-
select count(distinct gene_id) from GENE_TAXON where taxon_id = 567423;
Date: 2025-11-11 15:12:11 Duration: 5s811ms Database: ctddev51 User: pubeu Bind query: yes
8 1 5s34ms 5s34ms 5s34ms 5s34ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select disease_id from gene_disease_reference gdr where gdr.source_cd in (...) and gene_id in ( select gene_id from gene_taxon where taxon_id = ?)) and p.ancestor_object_id <> ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 11 15 1 5s34ms 5s34ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 567423)) and p.ancestor_object_id <> 2123366;
Date: 2025-11-11 15:12:16 Duration: 5s34ms Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 18s68ms 18s68ms 18s68ms 1 18s68ms select distinct associatedterm.nm || ? || o.cd || ? || associatedterm.nm_html || ? || associatedterm.acc_txt || ? || associatedterm.acc_db_cd as associatedterm, associatedterm.id associatedtermid, ptr.ixn_id ixnid, associatedterm.object_type_id || ? || associatedterm.nm_sort associatedtermnmsort, coalesce(associatedterm.secondary_nm, ?) casrn, phenotypeterm.nm || ? || ? || ? || phenotypeterm.nm_html || ? || phenotypeterm.acc_txt || ? || phenotypeterm.acc_db_cd as phenotype, phenotypeterm.id phenotypeid, ( select string_agg(distinct taxonterm.nm || ? || ? || ? || taxonterm.nm_html || ? || taxonterm.acc_txt || ? || taxonterm.acc_db_cd || ? || coalesce(taxonterm.secondary_nm, ?), ?)) as taxonterms, ( select string_agg(distinct anatomyterm.nm_html || ? || anatomyterm.acc_txt || ? || ia.level_seq || ? || anatomyterm.acc_db_cd || ? || anatomyterm.nm, ?)) as anatomyterms, count(distinct taxonterm.nm) taxoncount, i.ixn_prose_html ixnprosehtml, i.ixn_prose_txt ixnprose, i.sort_txt ixnsort, ( select string_agg(distinct r.acc_txt, ?)) as references, count(distinct ptr.reference_id) refcount, pt.indirect_term_qty inferredcount, count(*) over () fullrowcount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedterm on ptr.term_id = associatedterm.id inner join term phenotypeterm on ptr.phenotype_id = phenotypeterm.id left outer join term taxonterm on ptr.taxon_id = taxonterm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedterm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyterm on ia.anatomy_id = anatomyterm.id where ptr.term_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?)) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id in ( select distinct id from term baseterm where object_type_id = ? and upper(baseterm.nm) like ?))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = ? and action_degree_type_nm in (...)) group by associatedterm, associatedtermnmsort, phenotype, casrn, ixnid, ixnprosehtml, ixnprose, ixnsort, associatedtermid, phenotypeid, inferredcount order by associatedtermnmsort limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 22 1 18s68ms 18s68ms [ User: pubeu - Total duration: 18s68ms - Times executed: 1 ]
-
select distinct /* ChemPhenotypesAssnsDAO */ associatedTerm.nm || '^' || o.cd || '^' || associatedTerm.nm_html || '^' || associatedTerm.acc_txt || '^' || associatedTerm.acc_db_cd as associatedTerm, associatedTerm.id associatedTermId, ptr.ixn_id ixnId, associatedTerm.object_type_id || '|' || associatedTerm.nm_sort associatedTermNmSort, COALESCE(associatedTerm.secondary_nm, '') casRN, phenotypeTerm.nm || '^' || 'go' || '^' || phenotypeTerm.nm_html || '^' || phenotypeTerm.acc_txt || '^' || phenotypeTerm.acc_db_cd as phenotype, phenotypeTerm.id phenotypeId, ( SELECT STRING_AGG(distinct taxonTerm.nm || '^' || 'taxon' || '^' || taxonTerm.nm_html || '^' || taxonTerm.acc_txt || '^' || taxonTerm.acc_db_cd || '^' || COALESCE(taxonTerm.secondary_nm, ''), '|')) as taxonTerms, ( SELECT STRING_AGG(distinct anatomyTerm.nm_html || '^' || anatomyTerm.acc_txt || '^' || ia.level_seq || '^' || anatomyTerm.acc_db_cd || '^' || anatomyTerm.nm, '|')) as anatomyTerms, COUNT(DISTINCT taxonTerm.nm) taxonCount, i.ixn_prose_html ixnProseHtml, i.ixn_prose_txt ixnProse, i.sort_txt ixnSort, ( SELECT STRING_AGG(distinct r.acc_txt, '|')) as references, COUNT(DISTINCT ptr.reference_id) refCount, pt.indirect_term_qty inferredCount, COUNT(*) OVER () fullRowCount from phenotype_term_reference ptr inner join phenotype_term pt on ptr.term_id = pt.term_id and ptr.phenotype_id = pt.phenotype_id inner join term associatedTerm on ptr.term_id = associatedTerm.id inner join term phenotypeTerm on ptr.phenotype_id = phenotypeTerm.id left outer join term taxonTerm on ptr.taxon_id = taxonTerm.id inner join reference r on ptr.reference_id = r.id inner join ixn i on ptr.ixn_id = i.id inner join object_type o on associatedTerm.object_type_id = o.id left outer join ixn_anatomy ia on ptr.ixn_id = ia.ixn_id left outer join term anatomyTerm on ia.anatomy_id = anatomyTerm.id where ptr.term_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 2 and upper(baseTerm.nm) LIKE 'LEAD')) and i.id in ( select ixn_id from ixn_anatomy where anatomy_id IN ( select /* DBConstants.getDAGTermSQL */ distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id in ( select distinct id from term baseTerm where object_type_id = 10 and upper(baseTerm.nm) LIKE 'LIVER'))) and i.id in ( select ixn_id from ixn_axn where action_type_nm = 'phenotype' and action_degree_type_nm in ('increases', 'decreases', 'affects')) group by associatedTerm, associatedTermNmSort, phenotype, casRN, ixnId, ixnProseHtml, ixnProse, ixnSort, associatedTermId, phenotypeId, inferredCount ORDER BY associatedTermNmSort LIMIT 50;
Date: 2025-11-13 22:54:34 Duration: 18s68ms Database: ctddev51 User: pubeu Bind query: yes
2 5s764ms 1m3s 14s497ms 26 6m16s 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 #2
Day Hour Count Duration Avg duration Nov 10 10 4 33s259ms 8s314ms Nov 11 09 1 7s397ms 7s397ms 10 5 40s34ms 8s6ms 11 1 7s968ms 7s968ms 13 3 21s261ms 7s87ms 16 4 36s450ms 9s112ms Nov 13 13 4 1m34s 23s729ms Nov 14 16 4 2m15s 33s914ms [ User: load - Total duration: 2m26s - Times executed: 18 ]
[ User: edit - Total duration: 49s219ms - Times executed: 5 ]
-
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: 2025-11-13 13:45:26 Duration: 1m3s 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: 2025-11-14 16:47:29 Duration: 1m1s 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: 2025-11-14 16:45:26 Duration: 56s442ms Bind query: yes
3 5s79ms 8s448ms 6s787ms 4 27s150ms select t.id, t.object_type_id, t.acc_txt, t.acc_db_cd, t.nm, t.nm_sort, t.secondary_nm, t.description, t.note, l.nm from pub2.term t, pub2.term_label l where t.object_type_id = ? and t.id = l.term_id;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 15 4 27s150ms 6s787ms [ User: editeu - Total duration: 27s150ms - Times executed: 4 ]
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 8s448ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 4 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:10 Duration: 7s806ms Database: ctddev51 User: editeu Bind query: yes
-
select t.ID, t.OBJECT_TYPE_ID, t.ACC_TXT, t.ACC_DB_CD, t.NM, t.NM_SORT, t.SECONDARY_NM, t.DESCRIPTION, t.NOTE, l.NM from pub2.TERM t, pub2.TERM_LABEL l where t.OBJECT_TYPE_ID = 1 and t.id = l.TERM_ID;
Date: 2025-11-11 15:12:08 Duration: 5s815ms Database: ctddev51 User: editeu Bind query: yes
4 6s155ms 6s880ms 6s517ms 2 13s35ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 13 1 6s880ms 6s880ms Nov 14 16 1 6s155ms 6s155ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-13 13:45:35 Duration: 6s880ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt, ri.taxon_acc_txt, i.root_id from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-14 16:47:37 Duration: 6s155ms Bind query: yes
5 6s126ms 6s126ms 6s126ms 1 6s126ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select go_term_id from gene_go_annot gga where gga.taxon_id = ( select id from term where acc_txt = ? and object_type_id = ( select id from object_type where cd = ?)) and gga.is_not = ?) and p.ancestor_object_id not in ( select c.id from term c where c.acc_txt in (...) and c.object_type_id = ( select id from object_type where cd = ?));Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 11 15 1 6s126ms 6s126ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select go_term_id from GENE_GO_ANNOT gga where gga.taxon_id = ( select id from TERM where acc_txt = '9606' and object_type_id = ( select id from OBJECT_TYPE where cd = 'taxon')) AND gga.is_not = 'f') and p.ancestor_object_id NOT in ( SELECT c.id FROM TERM c WHERE c.acc_txt in ('ALL') AND c.object_type_id = ( select id from OBJECT_TYPE where cd = 'go'));
Date: 2025-11-11 15:12:23 Duration: 6s126ms Bind query: yes
6 5s811ms 5s811ms 5s811ms 1 5s811ms select count(distinct gene_id) from gene_taxon where taxon_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 11 15 1 5s811ms 5s811ms [ User: pubeu - Total duration: 5s811ms - Times executed: 1 ]
-
select count(distinct gene_id) from GENE_TAXON where taxon_id = 567423;
Date: 2025-11-11 15:12:11 Duration: 5s811ms Database: ctddev51 User: pubeu Bind query: yes
7 5s52ms 6s370ms 5s701ms 6 34s210ms select ri.reference_acc_txt, iachem.acc_txt, at.cd, iadisease.acc_txt from edit.ixn i, edit.ixn_actor iachem, edit.ixn_actor iadisease, edit.ixn_action iact, edit.action_type at, edit.reference_ixn ri where i.ixn_type_id = ? and i.root_id = iachem.ixn_id and i.root_id = iadisease.ixn_id and iachem.object_type_id = ? and iadisease.object_type_id = ? and i.root_id = ri.ixn_id and i.root_id = iact.ixn_id and iact.action_type_id = at.id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 10 10 1 5s242ms 5s242ms Nov 11 09 1 5s829ms 5s829ms 11 1 5s52ms 5s52ms 13 1 6s234ms 6s234ms 16 2 11s851ms 5s925ms -
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 16:28:02 Duration: 6s370ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 13:14:02 Duration: 6s234ms Bind query: yes
-
select ri.reference_acc_txt, iaChem.acc_txt, at.cd, iaDisease.acc_txt from edit.IXN i, edit.IXN_ACTOR iaChem, edit.IXN_ACTOR iaDisease, edit.IXN_ACTION iAct, edit.ACTION_TYPE at, edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id;
Date: 2025-11-11 09:51:35 Duration: 5s829ms Bind query: yes
8 5s34ms 5s34ms 5s34ms 1 5s34ms select p.ancestor_object_id, p.descendant_object_id from dag_path p where p.descendant_object_id in ( select disease_id from gene_disease_reference gdr where gdr.source_cd in (...) and gene_id in ( select gene_id from gene_taxon where taxon_id = ?)) and p.ancestor_object_id <> ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 11 15 1 5s34ms 5s34ms -
select p.ancestor_object_id, p.descendant_object_id from DAG_PATH p where p.descendant_object_id in ( select disease_id from GENE_DISEASE_REFERENCE gdr where gdr.source_cd in ('C', 'O') and gene_id in ( select gene_id from GENE_TAXON where taxon_id = 567423)) and p.ancestor_object_id <> 2123366;
Date: 2025-11-11 15:12:16 Duration: 5s34ms 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
- 2,268 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 33 FATAL entries
- 15 ERROR entries
- 0 WARNING entries
- 57 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 49 Max number of times the same event was reported
- 105 Total events found
Rank Times reported Error 1 49 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 10 10 4 Nov 11 09 1 10 5 11 1 13 3 16 12 Nov 12 13 1 14 10 Nov 13 13 2 Nov 14 00 8 16 2 2 18 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 11 15 18 - FATAL: password authentication failed for user "edit"
Detail: Connection matched pg_hba.conf line 85: "host all all 192.168.201.0/24 md5 "
Date: 2025-11-11 15:11:53
3 14 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 11 15 14 4 6 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 12 18 1 19 2 Nov 13 18 1 19 1 Nov 14 18 1 5 5 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 13 15 2 16 3 - ERROR: missing FROM-clause entry for table "riq" at character 874
- ERROR: missing FROM-clause entry for table "iq" at character 979
- ERROR: missing FROM-clause entry for table "riinvivo" at character 1054
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,iqInvitro.nm ,iqInvivo.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 LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvitro on ri.id = riq.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvitro on riqInvitro.ixn_qualifier_id = iq.id LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvivo on ri.id = riq.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvivio on riqInvivo.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and iqInvitro.nm = 'Invitro' and iqInvivo.nm = 'Invivo' limit 100
Date: 2025-11-13 15:59:15
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,iqInvitro.nm ,iqInvivo.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 LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvitro on ri.id = riqInvitro.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvitro on riqInvitro.ixn_qualifier_id = iq.id LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvivo on riInvivo.id = riq.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvivio on riqInvivo.ixn_qualifier_id = iq.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and iqInvitro.nm = 'Invitro' and iqInvivo.nm = 'Invivo' limit 100
Date: 2025-11-13 15:59:50
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,iqInvitro.nm ,iqInvivo.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 LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvitro on ri.id = riqInvitro.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvitro on riqInvitro.ixn_qualifier_id = iqInvitro.id LEFT OUTER JOIN edit.reference_ixn_qualifier riqInvivo on riInvivo.id = riq.reference_ixn_id INNER JOIN edit.ixn_qualifier iqInvivio on riqInvivo.ixn_qualifier_id = iqInvivo.id where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and iqInvitro.nm = 'Invitro' and iqInvivo.nm = 'Invivo' limit 100
Date: 2025-11-13 16:00:14
6 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 13 15 2 Nov 14 16 2 - ERROR: column riq.cd does not exist at character 380
- ERROR: column iq.cd does not exist at character 380
- ERROR: column "invivoandorinvitro" does not exist at character 1025
Hint: Perhaps you meant to reference the column "ri.id" or the column "iq.id".
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,riq.cd 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 LEFT OUTER JOIN edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id INNER 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 limit 100Date: 2025-11-13 15:53:25
Hint: Perhaps you meant to reference the column "iq.id".
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,iq.cd 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 LEFT OUTER JOIN edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id INNER 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 limit 100Date: 2025-11-13 15:53:54
Statement: SELECT ri.reference_acc_txt as referenceAccTxt ,iaChem.acc_txt as chemAccTxt ,at.cd as actionTypeCd ,iaDisease.acc_txt as diseaseAccTxt ,ri.taxon_acc_txt as taxonAccTxt ,i.root_id as rootID ,( SELECT STRING_AGG( DISTINCT iq.nm,'|' ) ) invivoAndOrInvitro 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 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 and invivoAndOrInvitro = 'Invivo|Invitro' group by referenceAccTxt ,chemAccTxt ,actionTypeCd ,diseaseAccTxt ,taxonAccTxt ,rootID limit 100
Date: 2025-11-14 16:20:46
7 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 13 13 1 15 2 Nov 14 16 1 - ERROR: syntax error at or near "elect" at character 2
- ERROR: syntax error at or near "JOIN" at character 422
- ERROR: syntax error at or near "where" at character 1033
Statement: elect ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id from edit.IXN i ,edit.IXN_ACTOR iaChem ,edit.IXN_ACTOR iaDisease ,edit.IXN_ACTION iAct ,edit.ACTION_TYPE at ,edit.REFERENCE_IXN ri where i.ixn_type_id = 2 and i.root_id = iaChem.ixn_id and i.root_id = iaDisease.ixn_id and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 and i.root_id = ri.ixn_id and i.root_id = iAct.ixn_id and iAct.action_type_id = at.id
Date: 2025-11-13 13:43:22
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id 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 where i.ixn_type_id = 2 and iaChem.object_type_id = 2 and iaDisease.object_type_id = 3 limit 100
Date: 2025-11-13 15:49:04 Database: ctddev51 Application: pgAdmin 4 - CONN:882006 User: edit Remote:
Statement: SELECT ri.reference_acc_txt ,iaChem.acc_txt ,at.cd ,iaDisease.acc_txt ,ri.taxon_acc_txt ,i.root_id ,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 LEFT OUTER JOIN edit.reference_ixn_qualifier riq on ri.id = riq.reference_ixn_id INNER 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 where iq.nm = 'Invitro' limit 100
Date: 2025-11-13 15:54:45
8 1 LOG: could not send data to client: Connection reset by peer
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 13 13 1 - LOG: could not send data to client: Connection reset by peer
Statement: 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: 2025-11-13 13:39:46
9 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 14 16 1 - ERROR: unterminated quoted identifier at or near "") 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 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 and iqInvitro.nm = 'Invitro' -- and ( iqInvivo.nm = 'Invivo' or iqInvivo.nm is null or iqInvivo.nm = '' ) and ( iqInvivo.nm is null or iqInvivo.nm = '' ) order by iqInvivo.nm group by referenceAccTxt ,chemAccTxt ,actionTypeCd ,diseaseAccTxt ,taxonAccTxt ,rootID limit 100" at character 358
Statement: SELECT ri.reference_acc_txt as referenceAccTxt ,iaChem.acc_txt as chemAccTxt ,at.cd as actionTypeCd ,iaDisease.acc_txt as diseaseAccTxt ,ri.taxon_acc_txt as taxonAccTxt ,i.root_id as rootID ,( SELECT STRING_AGG( DISTINCT iq.nm,'|' ) ) invivoAndOrInvitro ") 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 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 and iqInvitro.nm = 'Invitro' -- and ( iqInvivo.nm = 'Invivo' or iqInvivo.nm is null or iqInvivo.nm = '' ) and ( iqInvivo.nm is null or iqInvivo.nm = '' ) order by iqInvivo.nm group by referenceAccTxt ,chemAccTxt ,actionTypeCd ,diseaseAccTxt ,taxonAccTxt ,rootID limit 100
Date: 2025-11-14 16:18:51 Database: ctddev51 Application: pgAdmin 4 - CONN:882006 User: edit Remote:
10 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 13 13 1 - FATAL: connection to client lost
Statement: 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: 2025-11-13 13:39:46
11 1 ERROR: unterminated dollar-quoted string at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 12 11 1 - ERROR: unterminated dollar-quoted string at or near "$$ DECLARE r record; BEGIN ----- -- All tables ----- FOR r IN SELECT tablename FROM pg_tables WHERE tableowner = USER AND schemaname = current_schema LOOP -- Remove all public privs. EXECUTE 'REVOKE ALL ON ' || quote_ident(r.tablename) || ' FROM public'; EXECUTE 'GRANT SELECT ON ' || quote_ident(r.tablename) || ' TO pub1, pub2'; EXECUTE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || quote_ident(r.tablename) || ' TO editeu_r'; END LOOP; " at character 4
Statement: DO $$ DECLARE r record; BEGIN ----- -- All tables ----- FOR r IN SELECT tablename FROM pg_tables WHERE tableowner = USER AND schemaname = current_schema LOOP -- Remove all public privs. EXECUTE 'REVOKE ALL ON ' || quote_ident(r.tablename) || ' FROM public'; EXECUTE 'GRANT SELECT ON ' || quote_ident(r.tablename) || ' TO pub1, pub2'; EXECUTE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' || quote_ident(r.tablename) || ' TO editeu_r'; END LOOP;
Date: 2025-11-12 11:19:28 Database: ctddev51 Application: pgAdmin 4 - CONN:9693340 User: edit Remote:
12 1 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 11 15 1