pgBadger-
Global information
- Generated on Sat Jan 17 04:10:04 2026
- Log file: /project/archive/log/postgres/dbdev51/postgresql.log-20260116
- Parsed 3,407 log entries in 3s
- Log start from 2026-01-12 12:20:37 to 2026-01-16 18:13:42
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 54 Number of queries
- 21m17s Total query duration
- 2026-01-12 15:05:50 First query
- 2026-01-16 16:22:02 Last query
- 1 queries/s at 2026-01-16 10:47:34 Query peak
- 21m17s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 21m17s Execute total duration
- 96 Number of events
- 14 Number of unique normalized events
- 31 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
- 352 Total number of sessions
- 23 sessions at 2026-01-14 16:17:57 Session peak
- 93d13h49m29s Total duration of sessions
- 6h22m48s Average duration of sessions
- 0 Average queries per session
- 3s629ms Average queries duration per session
- 6h22m45s Average idle time per session
- 356 Total number of connections
- 9 connections/s at 2026-01-14 15:51:14 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-16 10:47:34 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-16 10:47:34 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 0 queries/s Query Peak
- Date
Queries duration
Key values
- 21m17s 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 12 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 1 0ms 5s880ms 5s880ms 0ms 5s880ms 5s880ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 13 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 1 0ms 5s511ms 5s511ms 0ms 5s511ms 5s511ms 13 2 0ms 5s877ms 5s762ms 0ms 11s525ms 11s525ms 14 1 0ms 5s205ms 5s205ms 0ms 5s205ms 5s205ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 14 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 3 0ms 49s321ms 24s663ms 1m4s 1m4s 1m4s 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 3 0ms 1m21s 36s605ms 1m36s 1m36s 1m36s 18 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 15 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 1 0ms 9s403ms 9s403ms 9s403ms 9s403ms 9s403ms 13 3 0ms 54s984ms 24s822ms 1m9s 1m9s 1m9s 14 3 0ms 54s742ms 25s647ms 1m7s 1m7s 1m7s 15 12 0ms 56s742ms 24s524ms 1m6s 1m6s 1m6s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 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 12 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 5s880ms 0ms 0ms 5s880ms 16 0 0 0ms 0ms 0ms 0ms Jan 13 11 0 0 0ms 0ms 0ms 0ms 12 1 0 5s511ms 0ms 0ms 5s511ms 13 2 0 5s762ms 0ms 0ms 11s525ms 14 1 0 5s205ms 0ms 0ms 5s205ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms Jan 14 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 3 0 24s663ms 1m4s 1m4s 1m4s 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 3 0 36s605ms 13s125ms 1m36s 1m36s 18 0 0 0ms 0ms 0ms 0ms Jan 15 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 9s403ms 0ms 9s403ms 9s403ms 13 3 0 24s822ms 5s465ms 1m9s 1m9s 14 3 0 25s647ms 9s666ms 1m7s 1m7s 15 12 0 24s524ms 1m4s 1m6s 1m6s 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 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 12 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 Jan 13 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms Jan 14 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 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 Jan 15 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 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 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 12 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% Jan 13 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 2 2.00 0.00% 14 0 1 1.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 19 0 0 0.00 0.00% Jan 14 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 3 3.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 3 3.00 0.00% 18 0 0 0.00 0.00% Jan 15 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 1 1.00 0.00% 13 0 3 3.00 0.00% 14 0 3 3.00 0.00% 15 0 12 12.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 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 12 12 16 0.00/s 13 16 0.00/s 14 15 0.00/s 15 16 0.00/s 16 7 0.00/s Jan 13 11 19 0.01/s 12 14 0.00/s 13 14 0.00/s 14 16 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 19 0 0.00/s Jan 14 09 3 0.00/s 10 5 0.00/s 11 2 0.00/s 12 1 0.00/s 13 0 0.00/s 15 9 0.00/s 16 9 0.00/s 18 0 0.00/s Jan 15 09 14 0.00/s 10 15 0.00/s 11 13 0.00/s 12 21 0.01/s 13 16 0.00/s 14 6 0.00/s 15 5 0.00/s 19 0 0.00/s 20 0 0.00/s 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 12 12 8 24m38s 24m38s 13 16 33m29s 33m29s 14 15 32m13s 32m13s 15 16 26m55s 26m55s 16 15 23m39s 23m39s Jan 13 11 11 19m44s 19m44s 12 14 31m26s 31m26s 13 14 35m24s 35m23s 14 16 28m55s 28m55s 15 11 16m36s 16m36s 16 3 31s697ms 31s697ms 17 0 0ms 0ms 19 3 2h14m39s 2h14m39s Jan 14 09 0 0ms 0ms 10 2 260ms 260ms 11 2 41s110ms 4s115ms 12 0 0ms 0ms 13 0 0ms 0ms 15 1 253ms 253ms 16 14 17m25s 17m17s 18 4 7h58m34s 7h58m34s Jan 15 09 5 3h28m43s 3h28m43s 10 20 5h40m56s 5h40m56s 11 13 32m56s 32m56s 12 16 33m29s 33m28s 13 17 25m43s 25m38s 14 13 23m28s 23m22s 15 5 1m30s 31s662ms 19 2 6h49m8s 6h49m8s 20 1 10h14m39s 10h14m39s 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-14 15:51:14 Date
Connections per database
Key values
- ctddev51 Main Database
- 356 connections Total
Connections per user
Key values
- pubeu Main User
- 356 connections Total
-
Sessions
Simultaneous sessions
Key values
- 23 sessions Session Peak
- 2026-01-14 16:17:57 Date
Histogram of session times
Key values
- 230 1800000-3600000ms duration
Sessions per database
Key values
- ctddev51 Main Database
- 352 sessions Total
Sessions per user
Key values
- pubeu Main User
- 352 sessions Total
Sessions per host
Key values
- 192.168.201.6 Main Host
- 352 sessions Total
Sessions per application
Key values
- unknown Main Application
- 352 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 52,289 buffers Checkpoint Peak
- 2026-01-12 13:17:01 Date
- 1619.572 seconds Highest write time
- 0.003 seconds Sync time
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- 2026-01-15 13:20:20 Date
Checkpoints distance
Key values
- 1,129.72 Mo Distance Peak
- 2026-01-12 13:17:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 12 12 0 0s 0s 0s 13 52,289 1,619.572s 0.002s 1,619.691s 14 22 2.362s 0.002s 2.4s 15 7 0.805s 0.001s 0.82s 16 7 0.782s 0.001s 0.796s Jan 13 11 6 0.706s 0.001s 0.721s 12 12 1.387s 0.002s 1.417s 13 2,724 272.825s 0.002s 272.848s 14 40 4.185s 0.002s 4.222s 15 0 0s 0s 0s 16 1 0.183s 0.001s 0.198s 17 5 0.601s 0.001s 0.618s 19 0 0s 0s 0s Jan 14 09 0 0s 0s 0s 10 6 0.706s 0.001s 0.722s 11 5 0.609s 0.001s 0.634s 12 0 0s 0s 0s 13 1 0.285s 0.001s 0.302s 15 0 0s 0s 0s 16 177 17.932s 0.002s 17.963s 18 0 0s 0s 0s Jan 15 09 0 0s 0s 0s 10 13 1.507s 0.002s 1.538s 11 15 1.69s 0.002s 1.72s 12 6 0.709s 0.001s 0.724s 13 68 7.004s 0.004s 7.046s 14 177 17.8s 0.001s 17.816s 15 130 13.222s 0.002s 13.263s 19 0 0s 0s 0s 20 0 0s 0s 0s 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 12 12 0 0 0 0 0s 0s 13 0 35 0 19 0.001s 0.001s 14 0 0 0 13 0.001s 0.002s 15 0 0 0 6 0.001s 0.001s 16 0 0 0 6 0.001s 0.001s Jan 13 11 0 0 0 6 0.001s 0.001s 12 0 0 0 11 0.001s 0.002s 13 0 1 0 19 0.001s 0.001s 14 0 0 0 15 0.001s 0.002s 15 0 0 0 0 0s 0s 16 0 0 0 1 0.001s 0.001s 17 0 0 0 6 0.001s 0.001s 19 0 0 0 0 0s 0s Jan 14 09 0 0 0 0 0s 0s 10 0 0 0 8 0.001s 0.001s 11 0 0 0 6 0.001s 0.001s 12 0 0 0 0 0s 0s 13 0 0 0 1 0.001s 0.001s 15 0 0 0 0 0s 0s 16 0 0 0 13 0.001s 0.002s 18 0 0 0 0 0s 0s Jan 15 09 0 0 0 0 0s 0s 10 0 0 0 12 0.001s 0.002s 11 0 0 0 11 0.001s 0.002s 12 0 0 0 6 0.001s 0.001s 13 0 0 0 52 0.001s 0.002s 14 0 0 0 8 0.001s 0.001s 15 0 0 0 8 0.001s 0.002s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 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 12 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s Jan 13 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 19 0 0s Jan 14 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 15 0 0s 16 0 0s 18 0 0s Jan 15 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 19 0 0s 20 0 0s 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 12 12 0.00 kB 0.00 kB 13 578,416.00 kB 635,729.00 kB 14 36.00 kB 543,553.50 kB 15 29.00 kB 463,455.00 kB 16 26.00 kB 417,112.00 kB Jan 13 11 19.00 kB 375,403.00 kB 12 26.50 kB 320,973.50 kB 13 20,244.00 kB 275,698.00 kB 14 122.50 kB 235,744.50 kB 15 0.00 kB 0.00 kB 16 0.00 kB 201,003.00 kB 17 22.00 kB 180,905.00 kB 19 0.00 kB 0.00 kB Jan 14 09 0.00 kB 0.00 kB 10 22.00 kB 162,817.00 kB 11 22.00 kB 146,537.00 kB 12 0.00 kB 0.00 kB 13 6.00 kB 131,884.00 kB 15 0.00 kB 0.00 kB 16 32.00 kB 112,765.50 kB 18 0.00 kB 0.00 kB Jan 15 09 0.00 kB 0.00 kB 10 27.50 kB 91,345.00 kB 11 36.00 kB 73,996.00 kB 12 24.00 kB 63,096.00 kB 13 156.50 kB 53,975.00 kB 14 32.00 kB 46,026.00 kB 15 18.00 kB 39,354.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 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 12 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 Jan 13 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 19 0 0 0 Jan 14 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 15 0 0 0 16 0 0 0 18 0 0 0 Jan 15 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 19 0 0 0 20 0 0 0 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 12 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 Jan 13 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 19 0 0 Jan 14 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 15 0 0 16 0 0 18 0 0 Jan 15 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 19 0 0 20 0 0 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
- 54 Total read queries
- 0 Total write queries
Queries by database
Key values
- unknown Main database
- 34 Requests
- 18m42s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 50 Requests
User Request type Count Duration edit Total 24 3m10s select 24 3m10s pubeu Total 4 22s63ms select 4 22s63ms unknown Total 50 27m55s select 50 27m55s Duration by user
Key values
- 27m55s (unknown) Main time consuming user
User Request type Count Duration edit Total 24 3m10s select 24 3m10s pubeu Total 4 22s63ms select 4 22s63ms unknown Total 50 27m55s select 50 27m55s Queries by host
Key values
- unknown Main host
- 78 Requests
- 31m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 54 Requests
- 21m17s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-16 14:49:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 33 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1m21s 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-14 16:19:21 - Bind query: yes ]
2 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 ]
3 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 ]
4 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 ]
5 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 ]
6 56s742ms 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-15 15:13:32 - Bind query: yes ]
7 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 ]
8 54s984ms 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-15 13:00:13 - Bind query: yes ]
9 54s742ms 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-15 14:25:32 - Bind query: yes ]
10 53s771ms 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-15 15:40:38 - Bind query: yes ]
11 53s517ms 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-15 15:24:00 - Bind query: yes ]
12 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 ]
13 51s32ms 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-15 15:19:34 - Bind query: yes ]
14 49s321ms 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-14 11:02:14 - Bind query: yes ]
15 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 ]
16 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 ]
17 15s264ms 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-14 16:19:39 - Bind query: yes ]
18 14s742ms 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-14 11:02:30 - Bind query: yes ]
19 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 ]
20 14s16ms 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-15 13:00:29 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 17m22s 32 5s721ms 1m21s 32s584ms 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 14 11 2 59s248ms 29s624ms 16 2 1m34s 47s275ms Jan 15 12 1 9s403ms 9s403ms 13 1 54s984ms 54s984ms 14 2 1m4s 32s204ms 15 8 4m8s 31s93ms Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 2m13s - Times executed: 16 ]
-
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-14 16:19:21 Duration: 1m21s 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: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
2 3m21s 16 10s74ms 15s264ms 12s585ms 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 14 11 1 14s742ms 14s742ms 16 1 15s264ms 15s264ms Jan 15 13 1 14s16ms 14s16ms 14 1 12s533ms 12s533ms 15 4 45s541ms 11s385ms 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-14 16:19:39 Duration: 15s264ms 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-14 11:02:30 Duration: 14s742ms 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 16:18:00 Duration: 14s692ms Bind query: yes
3 28s383ms 5 5s465ms 5s880ms 5s676ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 12 15 1 5s880ms 5s880ms Jan 13 12 1 5s511ms 5s511ms 13 2 11s525ms 5s762ms Jan 15 13 1 5s465ms 5s465ms [ User: pubeu - Total duration: 16s857ms - Times executed: 3 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-12 15:05:50 Duration: 5s880ms Database: ctddev51 User: pubeu Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:54 Duration: 5s877ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:50 Duration: 5s648ms Bind query: yes
4 5s205ms 1 5s205ms 5s205ms 5s205ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 14 1 5s205ms 5s205ms [ User: pubeu - Total duration: 5s205ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1369920' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-13 14:04:08 Duration: 5s205ms Database: ctddev51 User: pubeu Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 32 17m22s 5s721ms 1m21s 32s584ms 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 14 11 2 59s248ms 29s624ms 16 2 1m34s 47s275ms Jan 15 12 1 9s403ms 9s403ms 13 1 54s984ms 54s984ms 14 2 1m4s 32s204ms 15 8 4m8s 31s93ms Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 2m13s - Times executed: 16 ]
-
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-14 16:19:21 Duration: 1m21s 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: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
2 16 3m21s 10s74ms 15s264ms 12s585ms 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 14 11 1 14s742ms 14s742ms 16 1 15s264ms 15s264ms Jan 15 13 1 14s16ms 14s16ms 14 1 12s533ms 12s533ms 15 4 45s541ms 11s385ms 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-14 16:19:39 Duration: 15s264ms 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-14 11:02:30 Duration: 14s742ms 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 16:18:00 Duration: 14s692ms Bind query: yes
3 5 28s383ms 5s465ms 5s880ms 5s676ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 12 15 1 5s880ms 5s880ms Jan 13 12 1 5s511ms 5s511ms 13 2 11s525ms 5s762ms Jan 15 13 1 5s465ms 5s465ms [ User: pubeu - Total duration: 16s857ms - Times executed: 3 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-12 15:05:50 Duration: 5s880ms Database: ctddev51 User: pubeu Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:54 Duration: 5s877ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:50 Duration: 5s648ms Bind query: yes
4 1 5s205ms 5s205ms 5s205ms 5s205ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 14 1 5s205ms 5s205ms [ User: pubeu - Total duration: 5s205ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1369920' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-13 14:04:08 Duration: 5s205ms Database: ctddev51 User: pubeu Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 5s721ms 1m21s 32s584ms 32 17m22s 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 14 11 2 59s248ms 29s624ms 16 2 1m34s 47s275ms Jan 15 12 1 9s403ms 9s403ms 13 1 54s984ms 54s984ms 14 2 1m4s 32s204ms 15 8 4m8s 31s93ms Jan 16 10 6 3m10s 31s695ms 11 6 2m53s 28s857ms 16 4 2m28s 37s8ms [ User: edit - Total duration: 2m13s - Times executed: 16 ]
-
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-14 16:19:21 Duration: 1m21s 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: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
2 10s74ms 15s264ms 12s585ms 16 3m21s 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 14 11 1 14s742ms 14s742ms 16 1 15s264ms 15s264ms Jan 15 13 1 14s16ms 14s16ms 14 1 12s533ms 12s533ms 15 4 45s541ms 11s385ms 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-14 16:19:39 Duration: 15s264ms 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-14 11:02:30 Duration: 14s742ms 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 16:18:00 Duration: 14s692ms Bind query: yes
3 5s465ms 5s880ms 5s676ms 5 28s383ms select coalesce(st.alt_nm, t.nm) slimtermnm, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.curated_reference_qty > ?) curatedcount, ( select count(*) from slim_term_mapping stm inner join chem_disease cd on cd.disease_id = stm.mapped_term_id where cd.chem_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) and stm.slim_term_id = st.slim_term_id and cd.indirect_gene_qty > ?) inferredcount from slim_term st inner join term t on st.slim_term_id = t.id where st.slim_id = ? order by ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 12 15 1 5s880ms 5s880ms Jan 13 12 1 5s511ms 5s511ms 13 2 11s525ms 5s762ms Jan 15 13 1 5s465ms 5s465ms [ User: pubeu - Total duration: 16s857ms - Times executed: 3 ]
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-12 15:05:50 Duration: 5s880ms Database: ctddev51 User: pubeu Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:54 Duration: 5s877ms Bind query: yes
-
SELECT /* ChemDiseasesBySlimDAO */ COALESCE(st.alt_nm, t.nm) slimTermNm, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.curated_reference_qty > 0) curatedCount, ( SELECT COUNT(*) FROM slim_term_mapping stm INNER JOIN chem_disease cd ON cd.disease_id = stm.mapped_term_id WHERE cd.chem_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '1369920') AND stm.slim_term_id = st.slim_term_id AND cd.indirect_gene_qty > 0) inferredCount FROM slim_term st INNER JOIN term t ON st.slim_term_id = t.id WHERE st.slim_id = 1 ORDER BY 1;
Date: 2026-01-13 13:49:50 Duration: 5s648ms Bind query: yes
4 5s205ms 5s205ms 5s205ms 1 5s205ms select d.abbr dagabbr, d.nm dagnm, gt.level_min_no daglevelmin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pvalcorrected, te.raw_p_val pvalraw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, count(*) over () fullrowcount from term_enrichment te inner join dag_node gt on te.enriched_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where te.term_id = ? and te.enriched_object_type_id = ? order by te.corrected_p_val, d.abbr, gt.nm_sort limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 14 1 5s205ms 5s205ms [ User: pubeu - Total duration: 5s205ms - Times executed: 1 ]
-
SELECT /* ChemGODAO */ d.abbr dagAbbr, d.nm dagNm, gt.level_min_no dagLevelMin, gt.nm gonm, gt.nm_html gonmhtml, gt.acc_txt goacc, gt.object_id goid, te.corrected_p_val pValCorrected, te.raw_p_val pValRaw, te.target_match_qty targetmatchqty, te.target_total_qty targettotalqty, te.background_match_qty backgroundmatchqty, te.background_total_qty backgroundtotalqty, COUNT(*) OVER () fullRowCount FROM term_enrichment te INNER JOIN dag_node gt ON te.enriched_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE te.term_id = '1369920' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-13 14:04:08 Duration: 5s205ms Database: ctddev51 User: pubeu Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,721 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
- 45 ERROR entries
- 8 WARNING entries
- 43 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 31 Max number of times the same event was reported
- 96 Total events found
Rank Times reported Error 1 31 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 13 14 1 16 1 Jan 14 11 1 16 1 Jan 15 10 5 13 1 14 9 15 4 Jan 16 10 3 11 3 16 2 2 13 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 15 13 1 Jan 16 13 1 14 4 15 7 - ERROR: syntax error at or near "selec" at character 1
- ERROR: syntax error at or near "select" at character 15
- ERROR: syntax error at or near "," at character 10
Statement: selec* from chem_conc_anatomy
Date: 2026-01-15 13:39:02 Database: ctddev51 Application: pgAdmin 4 - CONN:909476 User: load Remote:
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
3 11 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 13 19 3 Jan 14 18 4 Jan 15 19 2 20 1 Jan 16 18 1 4 8 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 13 17 1 Jan 14 16 2 Jan 15 09 4 Jan 16 15 1 - ERROR: relation "cc_reference_curation" does not exist at character 17
- ERROR: relation "chem_conc" does not exist at character 15
- ERROR: relation "chem_conc" does not exist at character 15
Statement: select * from cc_reference_curation
Date: 2026-01-13 17:06:26 Database: ctddev51 Application: pgAdmin 4 - CONN:6684304 User: edit Remote:
Statement: select * from chem_conc
Date: 2026-01-14 16:29:29 Database: postgres Application: pgAdmin 4 - CONN:9005363 User: load Remote:
Statement: select * from CHEM_CONC
Date: 2026-01-15 09:51:34
5 8 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 14 12 1 Jan 16 14 2 15 5 - ERROR: column "detection_frequency_range" does not exist at character 38
- ERROR: column chemterm.nm_html does not exist at character 444
- ERROR: column cc.disease_acc_txt does not exist at character 885
Statement: select * from edit.exp_event where detection_frequency_range is not null limit 100
Date: 2026-01-14 12:38:40 Database: ctddev51 Application: pgAdmin 4 - CONN:6684304 User: edit Remote:
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
6 6 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 13 17 4 Jan 14 16 1 Jan 15 14 1 - ERROR: permission denied for table chem_conc
- ERROR: permission denied for table chem_conc
- ERROR: permission denied for table chem_conc
Statement: select * from load.chem_conc
Date: 2026-01-13 17:07:33
Statement: select * from chem_conc
Date: 2026-01-13 17:07:46
Statement: grant all on chem_conc to edit
Date: 2026-01-13 17:08:56
7 4 WARNING: Maximum parse error count exceeded - 1 error(...) found in input file
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 13 16 1 Jan 14 10 2 11 1 8 4 WARNING: Parse error Record 1: Input Record 1: Rejected - column 7. malformed range literal: "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jan 13 16 1 Jan 14 10 2 11 1 9 3 ERROR: could not open loader log file "...": Permission denied
Times Reported Most Frequent Error / Event #9
Day Hour Count Jan 13 14 1 16 2 - ERROR: could not open loader log file "/home/twiegers/testArea/load/ccc/c:\temp\ccc\output\cc_reference_curation.txt.log": Permission denied
Statement: SELECT * FROM pgbulkload.pg_bulkload($1)
Date: 2026-01-13 14:37:19 Database: ctddev51 Application: pg_bulkload User: load Remote:
10 3 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #10
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
11 2 ERROR: syntax error at end of input
Times Reported Most Frequent Error / Event #11
Day Hour Count Jan 13 17 1 Jan 16 15 1 - ERROR: syntax error at end of input at character 23
- ERROR: syntax error at end of input at character 2627
Statement: grant all on chem_conc
Date: 2026-01-13 17:08:41
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
12 1 ERROR: must be superuser to use pg_bulkload
Times Reported Most Frequent Error / Event #12
Day Hour Count Jan 13 14 1 - ERROR: must be superuser to use pg_bulkload
Statement: SELECT * FROM pgbulkload.pg_bulkload($1)
Date: 2026-01-13 14:33:16 Database: ctddev51 Application: pg_bulkload User: edit Remote:
13 1 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jan 15 14 1 - ERROR: could not create unique index "chem_conc_anatomy_pk"
Detail: Key (chem_conc_id, anatomy_acc_txt)=(4034, D009865) is duplicated.
Statement: SELECT * FROM pgbulkload.pg_bulkload($1)Date: 2026-01-15 14:54:30 Database: ctddev51 Application: pg_bulkload User: load Remote:
14 1 ERROR: unexpected EOF within message length word
Times Reported Most Frequent Error / Event #14
Day Hour Count Jan 13 16 1