pgBadger-
Global information
- Generated on Thu Jul 30 04:15:07 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260729
- Parsed 78,427 log entries in 5s
- Log start from 2026-07-26 00:00:02 to 2026-07-30 03:48:41
-
Overview
Global Stats
- 160 Number of unique normalized queries
- 405 Number of queries
- 10h54m46s Total query duration
- 2026-07-26 00:09:26 First query
- 2026-07-30 03:41:56 Last query
- 3 queries/s at 2026-07-30 03:41:56 Query peak
- 10h54m46s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h54m46s Execute total duration
- 21 Number of events
- 12 Number of unique normalized events
- 5 Max number of times the same event was reported
- 0 Number of cancellation
- 238 Total number of automatic vacuums
- 153 Total number of automatic analyzes
- 2,355 Number temporary file
- 1.00 GiB Max size of temporary file
- 286.25 MiB Average size of temporary file
- 8,310 Total number of sessions
- 168 sessions at 2026-07-30 00:33:11 Session peak
- 180d13h13m23s Total duration of sessions
- 31m17s Average duration of sessions
- 0 Average queries per session
- 4s727ms Average queries duration per session
- 31m12s Average idle time per session
- 8,321 Total number of connections
- 21 connections/s at 2026-07-30 00:33:11 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-30 03:41:56 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-30 03:41:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-07-29 06:06:54 Date
Queries duration
Key values
- 10h54m46s 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) Jul 26 00 2 0ms 9m24s 4m45s 0ms 0ms 9m31s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s835ms 5s622ms 0ms 0ms 5s835ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 2 0ms 10s387ms 10s330ms 0ms 0ms 20s661ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 1 0ms 9s220ms 9s220ms 0ms 0ms 9s220ms 17 7 0ms 8s325ms 8s90ms 7s992ms 8s89ms 16s607ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jul 27 00 8 0ms 9m25s 1m16s 0ms 11s684ms 9m52s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 1 0ms 5s417ms 5s417ms 0ms 0ms 5s417ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 3 0ms 1m20s 30s582ms 0ms 5s709ms 1m20s 06 12 0ms 1m53s 23s63ms 21s45ms 48s733ms 1m53s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 5s375ms 5s375ms 0ms 0ms 5s375ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 1m53s 24s820ms 0ms 39s793ms 1m53s 11 1 0ms 26s662ms 26s662ms 0ms 0ms 26s662ms 12 1 0ms 26s811ms 26s811ms 0ms 0ms 26s811ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 10 0ms 1m53s 22s984ms 21s183ms 48s667ms 1m53s 15 2 0ms 30s199ms 29s487ms 0ms 28s775ms 30s199ms 16 7 0ms 1m20s 28s984ms 10s753ms 1m14s 1m20s 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 9 0ms 1m53s 24s707ms 21s50ms 48s446ms 1m53s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 6 0ms 1m55s 34s581ms 0ms 29s599ms 1m55s 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jul 28 00 3 0ms 9m24s 3m15s 0ms 0ms 9m31s 01 6 0ms 15s870ms 13s347ms 14s822ms 14s965ms 15s870ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s663ms 5s513ms 0ms 5s364ms 5s663ms 06 10 0ms 1m52s 23s718ms 20s980ms 48s478ms 1m52s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 2 0ms 5s72ms 5s37ms 0ms 0ms 5s72ms 10 10 0ms 1m52s 22s954ms 6s862ms 39s939ms 1m52s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 2 0ms 7s426ms 6s879ms 0ms 6s332ms 7s426ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 9 0ms 1m53s 24s749ms 39s579ms 48s902ms 1m53s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 9 0ms 1m52s 24s710ms 0ms 39s602ms 1m52s 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 1 0ms 6s488ms 6s488ms 0ms 0ms 6s488ms 23 1 0ms 7s235ms 7s235ms 0ms 0ms 7s235ms Jul 29 00 2 0ms 9m21s 4m44s 0ms 0ms 9m28s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 1 0ms 22s317ms 22s317ms 0ms 0ms 22s317ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s585ms 5s525ms 0ms 0ms 5s585ms 06 9 0ms 1m52s 24s720ms 0ms 39s844ms 1m52s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 13s262ms 13s262ms 0ms 0ms 13s262ms 09 1 0ms 5s121ms 5s121ms 0ms 0ms 5s121ms 10 9 0ms 1m53s 24s763ms 0ms 39s593ms 1m53s 11 11 0ms 15s156ms 8s581ms 0ms 24s322ms 30s758ms 12 35 0ms 5m31s 1m2s 1m59s 2m13s 5m31s 13 5 0ms 2m30s 41s28ms 6s803ms 39s412ms 2m30s 14 9 0ms 1m52s 24s785ms 0ms 39s704ms 1m52s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 10 0ms 30m48s 6m21s 2m1s 5m21s 30m48s 17 8 0ms 36m12s 6m8s 5s870ms 1m10s 36m20s 18 13 0ms 1m55s 31s626ms 47s197ms 49s109ms 1m55s 19 1 0ms 50m34s 50m34s 0ms 0ms 50m34s 20 21 0ms 1h8m36s 4m55s 2m19s 7m18s 1h8m36s 21 28 0ms 5m28s 57s 1m49s 2m25s 5m28s 22 10 0ms 1m7s 26s892ms 28s614ms 43s315ms 1m35s 23 56 0ms 13m17s 36s716ms 2m8s 2m58s 13m17s Jul 30 00 26 0ms 33m14s 2m11s 1m25s 2m54s 33m14s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 3 0ms 1h57m12s 40m4s 0ms 3m1s 1h57m12s 03 5 0ms 12s978ms 8s692ms 0ms 18s911ms 24s549ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 00 1 0 9m24s 0ms 0ms 9m24s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s622ms 0ms 0ms 5s835ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 2 0 10s330ms 0ms 0ms 20s661ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 1 0 9s220ms 0ms 0ms 9s220ms 17 7 0 8s90ms 0ms 7s992ms 16s607ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Jul 27 00 7 0 1m26s 0ms 0ms 9m45s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 5s417ms 0ms 0ms 5s417ms 04 0 0 0ms 0ms 0ms 0ms 05 3 0 30s582ms 0ms 0ms 1m20s 06 3 9 23s63ms 0ms 21s45ms 1m53s 07 0 0 0ms 0ms 0ms 0ms 08 1 0 5s375ms 0ms 0ms 5s375ms 09 0 0 0ms 0ms 0ms 0ms 10 0 9 24s820ms 0ms 0ms 1m53s 11 1 0 26s662ms 0ms 0ms 26s662ms 12 1 0 26s811ms 0ms 0ms 26s811ms 13 0 0 0ms 0ms 0ms 0ms 14 1 9 22s984ms 0ms 21s183ms 1m53s 15 2 0 29s487ms 0ms 0ms 30s199ms 16 7 0 28s984ms 0ms 10s753ms 1m20s 17 0 0 0ms 0ms 0ms 0ms 18 0 9 24s707ms 0ms 21s50ms 1m53s 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 6 0 34s581ms 0ms 0ms 1m55s 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Jul 28 00 2 0 4m49s 0ms 0ms 9m24s 01 6 0 13s347ms 0ms 14s822ms 15s870ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s513ms 0ms 0ms 5s663ms 06 1 9 23s718ms 0ms 20s980ms 1m52s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 2 0 5s37ms 0ms 0ms 5s72ms 10 1 9 22s954ms 0ms 6s862ms 1m52s 11 0 0 0ms 0ms 0ms 0ms 12 2 0 6s879ms 0ms 0ms 7s426ms 13 0 0 0ms 0ms 0ms 0ms 14 0 9 24s749ms 0ms 39s579ms 1m53s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 9 24s710ms 0ms 0ms 1m52s 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 1 0 6s488ms 0ms 0ms 6s488ms 23 1 0 7s235ms 0ms 0ms 7s235ms Jul 29 00 1 0 9m21s 0ms 0ms 9m21s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 22s317ms 0ms 0ms 22s317ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s525ms 0ms 0ms 5s585ms 06 0 9 24s720ms 0ms 0ms 1m52s 07 0 0 0ms 0ms 0ms 0ms 08 1 0 13s262ms 0ms 0ms 13s262ms 09 1 0 5s121ms 0ms 0ms 5s121ms 10 0 9 24s763ms 0ms 0ms 1m53s 11 10 0 8s540ms 0ms 0ms 30s758ms 12 35 0 1m2s 1m37s 1m59s 3m50s 13 1 0 6s803ms 0ms 0ms 6s803ms 14 0 9 24s785ms 0ms 0ms 1m52s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 8 0 6m8s 0ms 5s870ms 36m20s 18 4 9 31s626ms 21s285ms 47s197ms 1m55s 19 1 0 50m34s 0ms 0ms 50m34s 20 17 0 5m32s 55s466ms 1m27s 1h8m36s 21 7 0 1m20s 0ms 14s678ms 5m28s 22 10 0 26s892ms 0ms 28s614ms 1m35s 23 51 0 16s646ms 54s3ms 1m2s 2m58s Jul 30 00 3 0 3m34s 0ms 0ms 36s214ms 01 0 0 0ms 0ms 0ms 0ms 02 1 0 1h57m12s 0ms 0ms 1h57m12s 03 5 0 8s692ms 0ms 0ms 24s549ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 26 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Jul 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Jul 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Jul 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 1 0 0 0 8s999ms 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 10 0 0 0 6m21s 0ms 0ms 17m32s 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Jul 30 00 9 9 0 0 2m31s 0ms 5s900ms 2m20s 01 0 0 0 0 0ms 0ms 0ms 0ms 02 1 0 0 0 2m53s 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 2 2.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 1 1.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Jul 27 00 0 6 6.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 3 3.00 0.00% 06 0 3 3.00 0.00% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.00 0.00% 12 0 1 1.00 0.00% 13 0 0 0.00 0.00% 14 0 1 1.00 0.00% 15 0 2 2.00 0.00% 16 0 7 7.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 6 6.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Jul 28 00 0 1 1.00 0.00% 01 0 6 6.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 2 2.00 0.00% 10 0 1 1.00 0.00% 11 0 0 0.00 0.00% 12 0 2 2.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Jul 29 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 10 10.00 0.00% 12 0 35 35.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 10 10.00 0.00% 17 0 8 8.00 0.00% 18 0 4 4.00 0.00% 19 0 1 1.00 0.00% 20 0 21 21.00 0.00% 21 0 28 28.00 0.00% 22 0 10 10.00 0.00% 23 0 56 56.00 0.00% Jul 30 00 0 24 24.00 0.00% 01 0 0 0.00 0.00% 02 0 3 3.00 0.00% 03 0 5 5.00 0.00% Day Hour Count Average / Second Jul 26 00 77 0.02/s 01 76 0.02/s 02 81 0.02/s 03 77 0.02/s 04 79 0.02/s 05 95 0.03/s 06 75 0.02/s 07 75 0.02/s 08 74 0.02/s 09 91 0.03/s 10 82 0.02/s 11 77 0.02/s 12 77 0.02/s 13 69 0.02/s 14 79 0.02/s 15 76 0.02/s 16 77 0.02/s 17 79 0.02/s 18 79 0.02/s 19 78 0.02/s 20 78 0.02/s 21 75 0.02/s 22 80 0.02/s 23 81 0.02/s Jul 27 00 79 0.02/s 01 80 0.02/s 02 86 0.02/s 03 85 0.02/s 04 80 0.02/s 05 101 0.03/s 06 75 0.02/s 07 74 0.02/s 08 75 0.02/s 09 83 0.02/s 10 90 0.03/s 11 83 0.02/s 12 72 0.02/s 13 82 0.02/s 14 82 0.02/s 15 79 0.02/s 16 75 0.02/s 17 74 0.02/s 18 82 0.02/s 19 77 0.02/s 20 77 0.02/s 21 84 0.02/s 22 79 0.02/s 23 77 0.02/s Jul 28 00 83 0.02/s 01 135 0.04/s 02 86 0.02/s 03 83 0.02/s 04 86 0.02/s 05 95 0.03/s 06 76 0.02/s 07 85 0.02/s 08 94 0.03/s 09 81 0.02/s 10 101 0.03/s 11 82 0.02/s 12 72 0.02/s 13 73 0.02/s 14 72 0.02/s 15 77 0.02/s 16 76 0.02/s 17 76 0.02/s 18 79 0.02/s 19 76 0.02/s 20 76 0.02/s 21 77 0.02/s 22 77 0.02/s 23 77 0.02/s Jul 29 00 83 0.02/s 01 77 0.02/s 02 85 0.02/s 03 87 0.02/s 04 75 0.02/s 05 99 0.03/s 06 74 0.02/s 07 76 0.02/s 08 76 0.02/s 09 97 0.03/s 10 73 0.02/s 11 129 0.04/s 12 132 0.04/s 13 83 0.02/s 14 80 0.02/s 15 78 0.02/s 16 77 0.02/s 17 90 0.03/s 18 80 0.02/s 19 78 0.02/s 20 82 0.02/s 21 90 0.03/s 22 105 0.03/s 23 88 0.02/s Jul 30 00 190 0.05/s 01 81 0.02/s 02 83 0.02/s 03 60 0.02/s Day Hour Count Average Duration Average idle time Jul 26 00 77 31m42s 31m35s 01 76 32m4s 32m4s 02 81 30m15s 30m15s 03 77 30m12s 30m12s 04 79 31m3s 31m3s 05 95 24m7s 24m7s 06 75 31m23s 31m23s 07 75 31m29s 31m29s 08 74 31m29s 31m29s 09 91 28m43s 28m43s 10 82 29m53s 29m52s 11 77 31m19s 31m19s 12 77 31m36s 31m36s 13 69 31m20s 31m20s 14 79 31m18s 31m18s 15 76 33m13s 33m13s 16 79 2h32m11s 2h32m11s 17 79 30m31s 30m30s 18 79 31m2s 31m2s 19 78 31m 31m 20 78 30m40s 30m40s 21 75 29m3s 29m3s 22 80 30m41s 30m41s 23 81 29m49s 29m49s Jul 27 00 79 30m30s 30m22s 01 80 31m30s 31m30s 02 86 28m22s 28m22s 03 85 27m14s 27m14s 04 80 28m33s 28m33s 05 101 24m18s 24m17s 06 75 30m26s 30m22s 07 74 32m51s 32m51s 08 75 31m24s 31m24s 09 81 30m45s 30m45s 10 87 28m38s 28m35s 11 82 30m20s 30m20s 12 72 30m50s 30m49s 13 82 29m41s 29m41s 14 82 27m54s 27m52s 15 79 30m21s 30m20s 16 75 29m58s 29m55s 17 74 33m10s 33m10s 18 82 30m39s 30m36s 19 77 31m36s 31m36s 20 77 31m49s 31m49s 21 84 29m17s 29m15s 22 79 31m13s 31m13s 23 77 30m58s 30m58s Jul 28 00 83 28m59s 28m52s 01 135 17m46s 17m46s 02 86 28m11s 28m11s 03 83 29m25s 29m25s 04 86 29m1s 29m1s 05 95 24m17s 24m17s 06 76 30m5s 30m2s 07 85 29m8s 29m8s 08 94 24m4s 24m4s 09 81 29m9s 29m9s 10 101 26m3s 26m1s 11 82 26m16s 26m16s 12 72 30m46s 30m46s 13 73 31m33s 31m33s 14 72 33m10s 33m6s 15 77 33m18s 33m18s 16 76 32m9s 32m9s 17 76 31m45s 31m45s 18 79 31m11s 31m8s 19 76 31m58s 31m58s 20 76 31m23s 31m23s 21 77 32m3s 32m3s 22 77 32m3s 32m3s 23 77 30m28s 30m28s Jul 29 00 83 30m35s 30m28s 01 77 29m48s 29m48s 02 85 28m4s 28m4s 03 87 28m43s 28m43s 04 75 31m49s 31m49s 05 99 24m22s 24m22s 06 74 30m30s 30m27s 07 76 32m56s 32m56s 08 76 30m52s 30m52s 09 91 27m20s 27m20s 10 73 28m54s 28m51s 11 128 18m46s 18m45s 12 133 18m44s 18m28s 13 83 29m19s 29m17s 14 80 30m48s 30m45s 15 77 31m28s 31m28s 16 77 31m10s 30m20s 17 90 26m50s 26m18s 18 80 30m17s 30m12s 19 78 31m4s 30m25s 20 82 32m37s 31m21s 21 90 27m23s 27m5s 22 105 23m50s 23m47s 23 88 2h24m3s 2h23m40s Jul 30 00 190 12m27s 12m9s 01 81 29m38s 29m38s 02 83 29m38s 28m11s 03 60 29m58s 29m58s -
Connections
Established Connections
Key values
- 21 connections Connection Peak
- 2026-07-30 00:33:11 Date
Connections per database
Key values
- ctdprd51 Main Database
- 8,321 connections Total
Connections per user
Key values
- pubeu Main User
- 8,321 connections Total
-
Sessions
Simultaneous sessions
Key values
- 168 sessions Session Peak
- 2026-07-30 00:33:11 Date
Histogram of session times
Key values
- 7,316 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 8,310 sessions Total
Sessions per user
Key values
- pubeu Main User
- 8,310 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 8,310 sessions Total
Host Count Total Duration Average Duration 10.12.5.45 1,573 33d7h31m27s 30m29s 10.12.5.46 1,563 33d3h48m14s 30m32s 10.12.5.52 16 26s767ms 1s672ms 10.12.5.53 1,849 33d7h57m43s 25m57s 10.12.5.54 1,559 33d6h4m6s 30m42s 10.12.5.55 1,537 33d6h51m30s 31m11s 10.12.5.56 181 10h14m20s 3m23s 192.168.201.10 5 13s694ms 2s738ms 192.168.201.6 2 6d16h26m6s 3d8h13m3s ::1 25 7d2h19m13s 6h48m46s Sessions per application
Key values
- unknown Main Application
- 8,310 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 2,078,348 buffers Checkpoint Peak
- 2026-07-29 23:29:55 Date
- 1619.884 seconds Highest write time
- 0.750 seconds Sync time
Checkpoints Wal files
Key values
- 571 files Wal files usage Peak
- 2026-07-29 23:07:32 Date
Checkpoints distance
Key values
- 17,258.10 Mo Distance Peak
- 2026-07-29 20:53:59 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 26 00 423 42.604s 0.003s 42.616s 01 41 4.296s 0.002s 4.305s 02 78 8.004s 0.003s 8.014s 03 122 12.301s 0.002s 12.31s 04 73 7.497s 0.002s 7.507s 05 664 66.708s 0.002s 66.717s 06 306 30.874s 0.003s 30.883s 07 298 30.041s 0.002s 30.088s 08 372 37.453s 0.002s 37.462s 09 383 38.561s 0.002s 38.569s 10 45 4.69s 0.002s 4.699s 11 95 9.687s 0.002s 9.695s 12 106 10.847s 0.002s 10.856s 13 42 4.37s 0.002s 4.378s 14 40 4.16s 0.002s 4.168s 15 35 3.656s 0.002s 3.664s 16 285 28.742s 0.002s 28.752s 17 28 2.985s 0.002s 2.993s 18 6 0.677s 0.001s 0.681s 19 12 1.398s 0.002s 1.406s 20 27 2.854s 0.002s 2.862s 21 98 10.018s 0.002s 10.026s 22 52 5.404s 0.003s 5.414s 23 6,289 629.655s 0.002s 629.707s Jul 27 00 490 49.356s 0.003s 49.369s 01 123 12.504s 0.002s 12.512s 02 53 5.505s 0.002s 5.514s 03 101 10.316s 0.002s 10.325s 04 697 69.989s 0.002s 69.997s 05 155 15.705s 0.002s 15.715s 06 10,862 1,088.452s 0.003s 1,088.565s 07 210 21.196s 0.002s 21.205s 08 62 6.395s 0.002s 6.404s 09 203 20.503s 0.002s 20.512s 10 120 12.237s 0.002s 12.247s 11 376 37.881s 0.002s 37.89s 12 3,925 393.149s 0.002s 393.164s 13 208 21.021s 0.002s 21.03s 14 178 18.053s 0.002s 18.066s 15 96 9.795s 0.002s 9.805s 16 30 3.209s 0.002s 3.219s 17 249 25.127s 0.002s 25.136s 18 79 8.071s 0.002s 8.08s 19 7 0.777s 0.001s 0.781s 20 30 3.179s 0.002s 3.188s 21 51 5.288s 0.002s 5.334s 22 136 13.783s 0.002s 13.791s 23 80 8.179s 0.002s 8.188s Jul 28 00 1,659 166.358s 0.003s 166.37s 01 135 13.7s 0.002s 13.71s 02 245 24.709s 0.002s 24.718s 03 912 91.412s 0.001s 91.454s 04 55,099 1,787.137s 0.005s 1,787.282s 05 127 12.893s 0.002s 12.901s 06 351 35.365s 0.002s 35.374s 07 490 49.174s 0.002s 49.184s 08 579 58.19s 0.002s 58.202s 09 181 18.312s 0.002s 18.322s 10 240 24.263s 0.002s 24.273s 11 323 32.559s 0.002s 32.568s 12 955 95.866s 0.002s 95.876s 13 334 33.631s 0.002s 33.641s 14 68 7.014s 0.002s 7.036s 15 182 18.408s 0.002s 18.417s 16 172 17.395s 0.002s 17.404s 17 184 18.599s 0.002s 18.644s 18 71 7.303s 0.002s 7.313s 19 5,432 543.866s 0.002s 543.911s 20 52 5.381s 0.002s 5.39s 21 90 9.19s 0.002s 9.199s 22 170 17.186s 0.002s 17.195s 23 856 85.892s 0.002s 85.902s Jul 29 00 516 51.862s 0.003s 51.909s 01 102 10.397s 0.003s 10.406s 02 79 7.993s 0.001s 7.997s 03 143,044 1,660.903s 0.003s 1,661.007s 04 157 15.882s 0.002s 15.891s 05 164 16.586s 0.002s 16.595s 06 369 37.034s 0.004s 37.044s 07 320 32.215s 0.002s 32.224s 08 670 67.298s 0.002s 67.308s 09 188 19.01s 0.003s 19.021s 10 3,025 302.75s 0.09s 302.988s 11 112 11.324s 0.001s 11.363s 12 331,363 2,480.16s 1.449s 2,489.604s 13 84,211 2,939.004s 0.01s 2,941.153s 14 1,090 109.385s 0.002s 109.824s 15 788,383 542.916s 0.305s 544.77s 16 2,756,759 2,582.168s 0.872s 2,587.19s 17 1,081,557 1,619.088s 0.012s 1,620.117s 18 378,227 1,623.483s 0.008s 1,624.194s 19 16 1.808s 0.002s 1.82s 20 3,915 392.8s 0.006s 397.656s 21 99 10.363s 1.287s 17.134s 22 801,678 1,623.014s 0.009s 1,624.219s 23 2,806,580 2,779.838s 0.022s 2,785.045s Jul 30 00 3,572,918 2,587.089s 0.379s 2,593.009s 01 1,780,997 3,248.738s 0.005s 3,250.152s 02 39 3.991s 0.001s 3.996s 03 319,481 3,239.108s 0.012s 3,240.053s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 26 00 0 0 0 64 0.001s 0.002s 01 0 0 0 20 0.001s 0.002s 02 0 0 0 23 0.001s 0.002s 03 0 0 0 27 0.001s 0.002s 04 0 0 0 21 0.001s 0.002s 05 0 0 0 24 0.001s 0.002s 06 0 0 0 117 0.001s 0.002s 07 0 0 1 111 0.001s 0.002s 08 0 0 0 122 0.001s 0.002s 09 0 0 0 117 0.001s 0.002s 10 0 0 0 17 0.001s 0.002s 11 0 0 0 21 0.001s 0.002s 12 0 0 0 57 0.001s 0.002s 13 0 0 0 15 0.001s 0.002s 14 0 0 0 19 0.001s 0.002s 15 0 0 0 24 0.001s 0.002s 16 0 0 0 24 0.001s 0.002s 17 0 0 0 16 0.001s 0.002s 18 0 0 0 6 0.001s 0.001s 19 0 0 0 12 0.001s 0.002s 20 0 0 0 14 0.001s 0.002s 21 0 0 0 25 0.001s 0.002s 22 0 0 0 20 0.001s 0.002s 23 0 0 4 50 0.001s 0.002s Jul 27 00 0 0 0 68 0.001s 0.002s 01 0 0 0 26 0.001s 0.002s 02 0 0 0 23 0.001s 0.002s 03 0 0 0 31 0.001s 0.002s 04 0 0 0 50 0.001s 0.002s 05 0 0 0 33 0.001s 0.002s 06 0 0 8 110 0.001s 0.002s 07 0 0 0 70 0.001s 0.002s 08 0 0 0 21 0.001s 0.002s 09 0 0 0 71 0.001s 0.002s 10 0 0 0 26 0.001s 0.002s 11 0 0 0 119 0.001s 0.002s 12 0 0 2 28 0.001s 0.002s 13 0 0 0 26 0.001s 0.002s 14 0 0 0 117 0.001s 0.002s 15 0 0 0 25 0.001s 0.002s 16 0 0 0 17 0.001s 0.002s 17 0 0 0 104 0.001s 0.002s 18 0 0 0 61 0.001s 0.002s 19 0 0 0 6 0.001s 0.001s 20 0 0 0 18 0.001s 0.002s 21 0 0 1 18 0.001s 0.002s 22 0 0 0 29 0.001s 0.002s 23 0 0 0 24 0.001s 0.002s Jul 28 00 0 0 0 87 0.001s 0.002s 01 0 0 0 26 0.001s 0.002s 02 0 0 0 36 0.001s 0.002s 03 0 0 1 21 0.001s 0.001s 04 0 0 33 67 0.003s 0.003s 05 0 0 0 25 0.001s 0.002s 06 0 0 0 124 0.001s 0.002s 07 0 0 0 127 0.001s 0.002s 08 0 0 1 86 0.001s 0.002s 09 0 0 0 28 0.001s 0.002s 10 0 0 0 75 0.001s 0.002s 11 0 0 0 113 0.001s 0.002s 12 0 0 0 125 0.001s 0.002s 13 0 0 0 30 0.001s 0.002s 14 0 0 0 25 0.001s 0.002s 15 0 0 0 73 0.001s 0.002s 16 0 0 0 71 0.001s 0.002s 17 0 0 1 30 0.001s 0.002s 18 0 0 0 25 0.001s 0.002s 19 0 0 3 29 0.001s 0.002s 20 0 0 0 20 0.001s 0.002s 21 0 0 0 21 0.001s 0.002s 22 0 0 0 29 0.001s 0.002s 23 0 0 0 32 0.001s 0.002s Jul 29 00 0 0 1 78 0.001s 0.002s 01 0 0 0 27 0.001s 0.002s 02 0 0 0 17 0.001s 0.001s 03 0 0 32 76 0.001s 0.003s 04 0 0 0 34 0.001s 0.002s 05 0 0 0 29 0.001s 0.002s 06 0 0 0 93 0.001s 0.002s 07 0 0 0 111 0.001s 0.002s 08 0 0 0 81 0.001s 0.002s 09 0 0 0 26 0.001s 0.002s 10 0 0 1 836 0.001s 0.002s 11 0 0 1 51 0.001s 0.001s 12 0 218 3,336 517 0.577s 0.042s 13 0 0 1,076 155 0.001s 0.002s 14 0 0 156 89 0.001s 0.002s 15 0 207 590 117 0.033s 0.014s 16 0 0 2,152 207 0.131s 0.026s 17 0 0 538 137 0.001s 0.001s 18 0 0 274 253 0.001s 0.002s 19 0 0 0 15 0.001s 0.002s 20 0 0 1,090 103 0.001s 0.004s 21 0 0 2,105 96 0.748s 0.064s 22 0 0 553 110 0.001s 0.002s 23 0 0 1,675 160 0.003s 0.004s Jul 30 00 0 68 2,690 834 0.109s 0.007s 01 0 0 645 158 0.001s 0.003s 02 0 0 0 11 0.001s 0.001s 03 0 287 10 103 0.003s 0.002s Day Hour Count Avg time (sec) Jul 26 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Jul 27 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Jul 28 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Jul 29 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Jul 30 00 0 0s 01 0 0s 02 0 0s 03 0 0s Day Hour Mean distance Mean estimate Jul 26 00 1,093.50 kB 24,703.00 kB 01 24.00 kB 20,065.50 kB 02 145.50 kB 16,281.00 kB 03 306.00 kB 13,233.00 kB 04 185.00 kB 10,766.50 kB 05 2,126.00 kB 8,937.50 kB 06 963.50 kB 7,577.00 kB 07 946.50 kB 6,305.00 kB 08 1,236.00 kB 5,341.50 kB 09 1,236.00 kB 4,569.50 kB 10 97.50 kB 3,754.00 kB 11 202.00 kB 3,081.50 kB 12 325.00 kB 2,559.00 kB 13 70.00 kB 2,084.00 kB 14 48.50 kB 1,699.50 kB 15 78.50 kB 1,391.50 kB 16 781.50 kB 1,436.50 kB 17 31.00 kB 1,171.00 kB 18 24.00 kB 1,002.00 kB 19 23.00 kB 860.00 kB 20 38.00 kB 702.50 kB 21 252.50 kB 600.50 kB 22 124.00 kB 524.00 kB 23 31,828.50 kB 31,828.50 kB Jul 27 00 1,347.50 kB 51,632.50 kB 01 171.00 kB 41,899.00 kB 02 56.00 kB 33,959.50 kB 03 193.50 kB 27,543.00 kB 04 2,074.50 kB 22,535.50 kB 05 248.50 kB 18,455.00 kB 06 58,286.00 kB 109,809.00 kB 07 523.00 kB 89,072.50 kB 08 101.00 kB 72,181.00 kB 09 402.00 kB 58,542.00 kB 10 132.50 kB 47,445.00 kB 11 1,139.50 kB 38,598.50 kB 12 18,882.50 kB 35,293.00 kB 13 762.00 kB 32,229.00 kB 14 399.00 kB 26,246.50 kB 15 226.00 kB 21,301.00 kB 16 57.50 kB 17,264.00 kB 17 794.00 kB 14,091.50 kB 18 170.50 kB 11,491.00 kB 19 20.00 kB 9,801.00 kB 20 32.50 kB 8,385.00 kB 21 88.50 kB 6,806.00 kB 22 284.00 kB 5,549.00 kB 23 124.00 kB 4,535.50 kB Jul 28 00 5,779.50 kB 8,177.50 kB 01 163.00 kB 6,793.00 kB 02 522.50 kB 5,558.50 kB 03 5,912.00 kB 5,912.00 kB 04 182,202.33 kB 483,572.00 kB 05 218.00 kB 371,472.00 kB 06 1,020.00 kB 301,051.50 kB 07 1,441.00 kB 244,078.00 kB 08 1,973.00 kB 198,136.00 kB 09 311.00 kB 160,570.00 kB 10 564.00 kB 130,134.00 kB 11 952.00 kB 105,572.50 kB 12 2,910.50 kB 85,896.50 kB 13 1,201.50 kB 69,933.50 kB 14 119.00 kB 56,765.50 kB 15 464.50 kB 46,049.50 kB 16 434.00 kB 37,401.00 kB 17 465.50 kB 30,386.50 kB 18 90.50 kB 24,628.00 kB 19 29,136.00 kB 39,627.50 kB 20 54.50 kB 49,810.00 kB 21 125.50 kB 40,367.00 kB 22 308.50 kB 32,741.00 kB 23 2,609.00 kB 27,027.00 kB Jul 29 00 1,394.50 kB 22,113.50 kB 01 171.00 kB 17,985.00 kB 02 331.00 kB 15,382.00 kB 03 175,661.67 kB 474,191.00 kB 04 373.50 kB 363,716.00 kB 05 322.50 kB 294,663.50 kB 06 960.00 kB 238,836.00 kB 07 928.50 kB 193,651.00 kB 08 1,484.50 kB 157,068.50 kB 09 467.00 kB 127,412.00 kB 10 8,738.50 kB 104,766.00 kB 11 721.00 kB 89,506.00 kB 12 7,213,560.62 kB 7,222,886.25 kB 13 8,820,517.50 kB 8,825,852.50 kB 14 1,534,623.50 kB 7,837,174.50 kB 15 4,177,794.00 kB 7,292,402.67 kB 16 8,815,025.00 kB 8,817,323.75 kB 17 8,813,928.00 kB 8,818,672.00 kB 18 2,508,975.50 kB 8,016,665.50 kB 19 20.50 kB 6,493,506.50 kB 20 4,409,739.50 kB 7,047,112.75 kB 21 8,821,779.75 kB 8,830,500.25 kB 22 4,241,655.00 kB 8,356,280.50 kB 23 8,074,116.00 kB 8,745,671.75 kB Jul 30 00 7,960,195.60 kB 8,730,804.40 kB 01 3,697,727.33 kB 8,117,015.67 kB 02 66.00 kB 6,618,281.00 kB 03 2,168,769.00 kB 6,015,726.50 kB -
Temporary Files
Size of temporary files
Key values
- 37.00 GiB Temp Files size Peak
- 2026-07-29 20:35:17 Date
Number of temporary files
Key values
- 37 per second Temp Files Peak
- 2026-07-29 20:35:17 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Jul 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Jul 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Jul 29 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 240 2.30 GiB 9.80 MiB 12 988 71.59 GiB 74.20 MiB 13 115 6.96 GiB 62.02 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 32 31.02 GiB 992.68 MiB 19 65 64.38 GiB 1014.24 MiB 20 364 350.55 GiB 986.15 MiB 21 210 82.06 GiB 400.16 MiB 22 175 17.62 GiB 103.09 MiB 23 75 28.71 GiB 391.96 MiB Jul 30 00 91 3.14 GiB 35.30 MiB 01 0 0 0 02 0 0 0 03 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 1,413 100.17 GiB 8.00 KiB 1.00 GiB 72.60 MiB select * from pgbulkload.pg_bulkload (?);-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-07-29 20:48:34 Duration: 7m45s Database: ctdprd51 User: load Application: pg_bulkload
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-07-29 12:08:43 Duration: 5m31s
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-07-29 21:26:08 Duration: 5m28s
2 307 305.84 GiB 222.13 MiB 1.00 GiB 1020.12 MiB select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in;-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in;
Date: 2026-07-29 20:35:05 Duration: 0ms
3 65 64.38 GiB 389.71 MiB 1.00 GiB 1014.24 MiB select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;-
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in;
Date: 2026-07-29 19:13:16 Duration: 0ms
4 35 1.25 GiB 26.45 MiB 52.38 MiB 36.48 MiB vacuum full analyze ixn_actor;-
vacuum FULL analyze ixn_actor;
Date: 2026-07-29 13:14:52 Duration: 28s168ms
-
vacuum FULL analyze ixn_actor;
Date: 2026-07-29 13:14:31 Duration: 0ms
5 35 5.09 GiB 87.49 MiB 247.19 MiB 149.04 MiB vacuum full analyze db_link;-
vacuum FULL analyze db_link;
Date: 2026-07-29 13:17:56 Duration: 2m30s
-
vacuum FULL analyze db_link;
Date: 2026-07-29 13:15:53 Duration: 0ms
6 32 31.02 GiB 21.85 MiB 1.00 GiB 992.68 MiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub1.gene_chem_reference gcr, pub1.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;
Date: 2026-07-29 18:18:38 Duration: 0ms
7 25 411.71 MiB 11.64 MiB 24.24 MiB 16.47 MiB vacuum full analyze ixn;-
vacuum FULL analyze ixn;
Date: 2026-07-29 13:15:10 Duration: 8s669ms
-
vacuum FULL analyze ixn;
Date: 2026-07-29 13:15:04 Duration: 0ms
8 25 16.14 GiB 8.00 KiB 1.00 GiB 661.15 MiB alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:06 Duration: 3m22s
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:05 Duration: 0ms
9 20 14.32 GiB 8.00 KiB 1.00 GiB 733.25 MiB create unique index gene_disease_reference_ak1 on pub1.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 4m33s
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 0ms Database: ctdprd51 User: pub1
10 20 227.07 MiB 6.48 MiB 16.18 MiB 11.35 MiB vacuum full analyze term;-
vacuum FULL analyze TERM;
Date: 2026-07-29 13:14:55 Duration: 11s243ms
-
vacuum FULL analyze TERM;
Date: 2026-07-29 13:14:46 Duration: 0ms
11 15 11.53 GiB 261.86 MiB 1.00 GiB 787.07 MiB create index ix_term_enrich_agent_enr_term on pub1.term_enrichment_agent using btree (enriched_term_id);-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-07-29 23:32:10 Duration: 2m4s
-
CREATE INDEX ix_term_enrich_agent_enr_term ON pub1.term_enrichment_agent USING btree (enriched_term_id);
Date: 2026-07-29 23:32:10 Duration: 0ms
12 15 7.96 GiB 8.00 KiB 1.00 GiB 543.15 MiB alter table pub1.gene_disease_reference add constraint gene_disease_reference_pk primary key (id);-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-07-29 21:13:33 Duration: 1m28s
-
ALTER TABLE pub1.gene_disease_reference ADD CONSTRAINT gene_disease_reference_pk PRIMARY KEY (id);
Date: 2026-07-29 21:13:33 Duration: 0ms
13 10 156.41 MiB 8.00 KiB 31.72 MiB 15.64 MiB alter table pub1.term_enrichment add constraint term_enrichment_pk primary key (term_id, enriched_term_id);-
ALTER TABLE pub1.term_enrichment ADD CONSTRAINT term_enrichment_pk PRIMARY KEY (term_id, enriched_term_id);
Date: 2026-07-29 23:13:13 Duration: 0ms Database: ctdprd51 User: pub1
14 10 7.96 GiB 594.93 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_dis_gene on pub1.gene_disease_reference using btree (disease_id, gene_id);-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-07-29 21:05:26 Duration: 2m25s
-
CREATE INDEX ix_gene_disease_ref_dis_gene ON pub1.gene_disease_reference USING btree (disease_id, gene_id);
Date: 2026-07-29 21:05:25 Duration: 0ms
15 10 7.96 GiB 592.65 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_src_db on pub1.gene_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-07-29 20:55:56 Duration: 1m22s
-
CREATE INDEX ix_gene_disease_ref_src_db ON pub1.gene_disease_reference USING btree (source_acc_db_id);
Date: 2026-07-29 20:55:55 Duration: 0ms
16 10 7.96 GiB 564.88 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_reference on pub1.gene_disease_reference using btree (reference_id);-
CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id);
Date: 2026-07-29 21:03:00 Duration: 1m48s
-
CREATE INDEX ix_gene_disease_ref_reference ON pub1.gene_disease_reference USING btree (reference_id);
Date: 2026-07-29 21:02:59 Duration: 0ms
17 10 479.61 MiB 8.00 KiB 96.91 MiB 47.96 MiB create unique index chem_disease_reference_ak1 on pub1.chem_disease_reference using btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);-
CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-07-29 21:16:25 Duration: 8s345ms
-
CREATE UNIQUE INDEX chem_disease_reference_ak1 ON pub1.chem_disease_reference USING btree (chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id);
Date: 2026-07-29 21:16:25 Duration: 0ms
18 10 7.96 GiB 564.88 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_net_sc on pub1.gene_disease_reference using btree (network_score);-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-07-29 21:12:05 Duration: 3m
-
CREATE INDEX ix_gene_disease_ref_net_sc ON pub1.gene_disease_reference USING btree (network_score);
Date: 2026-07-29 21:12:05 Duration: 0ms
19 10 68.04 MiB 8.00 KiB 15.09 MiB 6.80 MiB alter table pub1.phenotype_term add constraint phenotype_term_pk primary key (phenotype_id, term_id);-
ALTER TABLE pub1.phenotype_term ADD CONSTRAINT phenotype_term_pk PRIMARY KEY (phenotype_id, term_id);
Date: 2026-07-30 00:00:55 Duration: 0ms
20 10 7.96 GiB 575.39 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_source_cd on pub1.gene_disease_reference using btree (source_cd);-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd);
Date: 2026-07-29 20:57:24 Duration: 1m27s
-
CREATE INDEX ix_gene_disease_ref_source_cd ON pub1.gene_disease_reference USING btree (source_cd);
Date: 2026-07-29 20:57:23 Duration: 0ms
21 10 7.96 GiB 587.04 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_reference_ixn on pub1.gene_disease_reference using btree (ixn_id);-
CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id);
Date: 2026-07-29 21:07:15 Duration: 1m49s
-
CREATE INDEX ix_gene_disease_reference_ixn ON pub1.gene_disease_reference USING btree (ixn_id);
Date: 2026-07-29 21:07:15 Duration: 0ms
22 10 7.96 GiB 564.88 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_disease on pub1.gene_disease_reference using btree (disease_id);-
CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id);
Date: 2026-07-29 21:01:11 Duration: 1m52s
-
CREATE INDEX ix_gene_disease_ref_disease ON pub1.gene_disease_reference USING btree (disease_id);
Date: 2026-07-29 21:01:10 Duration: 0ms
23 10 7.96 GiB 565.03 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_mod_tm on pub1.gene_disease_reference using btree (mod_tm);-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm);
Date: 2026-07-29 21:09:05 Duration: 1m49s
-
CREATE INDEX ix_gene_disease_ref_mod_tm ON pub1.gene_disease_reference USING btree (mod_tm);
Date: 2026-07-29 21:09:05 Duration: 0ms
24 10 7.96 GiB 564.94 MiB 1.00 GiB 814.72 MiB create index ix_gene_disease_ref_chem on pub1.gene_disease_reference using btree (via_chem_id);-
CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id);
Date: 2026-07-29 20:59:19 Duration: 1m55s
-
CREATE INDEX ix_gene_disease_ref_chem ON pub1.gene_disease_reference USING btree (via_chem_id);
Date: 2026-07-29 20:59:18 Duration: 0ms
25 10 263.23 MiB 8.00 KiB 54.27 MiB 26.32 MiB alter table pub1.chem_disease_reference add constraint chem_disease_reference_pk primary key (id);-
ALTER TABLE pub1.chem_disease_reference ADD CONSTRAINT chem_disease_reference_pk PRIMARY KEY (id);
Date: 2026-07-29 21:16:54 Duration: 0ms
26 10 676.25 MiB 8.00 KiB 136.41 MiB 67.62 MiB alter table pub1.gene_disease add constraint gene_disease_pk primary key (gene_id, disease_id);-
ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-07-30 00:00:50 Duration: 7s163ms
-
ALTER TABLE pub1.gene_disease ADD CONSTRAINT gene_disease_pk PRIMARY KEY (gene_id, disease_id);
Date: 2026-07-30 00:00:50 Duration: 0ms
27 10 1.20 GiB 8.00 KiB 247.79 MiB 123.16 MiB alter table pub1.phenotype_term_reference add constraint phenotype_term_reference_pk primary key (id);-
ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-07-29 21:13:53 Duration: 18s429ms
-
ALTER TABLE pub1.phenotype_term_reference ADD CONSTRAINT phenotype_term_reference_pk PRIMARY KEY (id);
Date: 2026-07-29 21:13:52 Duration: 0ms
28 8 68.12 MiB 8.00 KiB 17.61 MiB 8.52 MiB alter table pub1.chem_disease add constraint chem_disease_pk primary key (chem_id, disease_id);-
ALTER TABLE pub1.chem_disease ADD CONSTRAINT chem_disease_pk PRIMARY KEY (chem_id, disease_id);
Date: 2026-07-30 00:01:02 Duration: 0ms
29 7 6.52 GiB 531.98 MiB 1.00 GiB 953.71 MiB select distinct ptr.phenotype_id, cdr.disease_id, ( select id from pub1.object_type where cd = ?), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.object_type where cd = ?), cdr.mod_tm from pub1.chem_disease_reference cdr, pub1.phenotype_term_reference ptr where cdr.chem_id = ptr.term_id;-
SELECT DISTINCT ptr.phenotype_id, cdr.disease_id, ( select id from pub1.OBJECT_TYPE where cd = 'disease'), cdr.reference_id, ptr.reference_id, cdr.ixn_id, cdr.chem_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), cdr.mod_tm FROM pub1.CHEM_DISEASE_REFERENCE cdr, pub1.PHENOTYPE_TERM_REFERENCE ptr WHERE cdr.chem_id = ptr.term_id;
Date: 2026-07-29 20:39:47 Duration: 0ms
30 5 40.00 KiB 8.00 KiB 8.00 KiB 8.00 KiB create index ix_gene_disease_exp_ref_qty on pub1.gene_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_gene_disease_exp_ref_qty ON pub1.gene_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-07-30 00:00:43 Duration: 0ms
31 5 1.20 GiB 241.16 MiB 251.06 MiB 246.32 MiB create index ix_phenotype_term_ref_reference_id on pub1.phenotype_term_reference using btree (reference_id);-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id);
Date: 2026-07-29 21:14:43 Duration: 14s624ms
-
CREATE INDEX ix_phenotype_term_ref_reference_id ON pub1.phenotype_term_reference USING btree (reference_id);
Date: 2026-07-29 21:14:43 Duration: 0ms
32 5 676.07 MiB 133.90 MiB 137.82 MiB 135.21 MiB create index ix_gene_disease_ind_chem_qty on pub1.gene_disease using btree (indirect_chem_qty) where (indirect_chem_qty > ?);-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-07-30 00:00:42 Duration: 7s815ms
-
CREATE INDEX ix_gene_disease_ind_chem_qty ON pub1.gene_disease USING btree (indirect_chem_qty) WHERE (indirect_chem_qty > 0);
Date: 2026-07-30 00:00:42 Duration: 0ms
33 5 676.20 MiB 128.52 MiB 138.88 MiB 135.24 MiB create index ix_gene_disease_network_score on pub1.gene_disease using btree (network_score);-
CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score);
Date: 2026-07-30 00:00:34 Duration: 15s432ms
-
CREATE INDEX ix_gene_disease_network_score ON pub1.gene_disease USING btree (network_score);
Date: 2026-07-30 00:00:34 Duration: 0ms
34 5 156.38 MiB 30.57 MiB 32.24 MiB 31.27 MiB create index ix_term_enrich_tgt_match on pub1.term_enrichment using btree (target_match_qty);-
CREATE INDEX ix_term_enrich_tgt_match ON pub1.term_enrichment USING btree (target_match_qty);
Date: 2026-07-29 23:13:16 Duration: 0ms
35 5 1.20 GiB 238.73 MiB 256.80 MiB 246.32 MiB create index ix_phenotype_term_ref_term_id on pub1.phenotype_term_reference using btree (term_id);-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id);
Date: 2026-07-29 21:14:18 Duration: 12s902ms
-
CREATE INDEX ix_phenotype_term_ref_term_id ON pub1.phenotype_term_reference USING btree (term_id);
Date: 2026-07-29 21:14:18 Duration: 0ms
36 5 1.20 GiB 240.22 MiB 254.98 MiB 246.32 MiB create index ix_phenotype_term_ref_evidence_cd on pub1.phenotype_term_reference using btree (evidence_cd);-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-07-29 21:15:06 Duration: 11s304ms
-
CREATE INDEX ix_phenotype_term_ref_evidence_cd ON pub1.phenotype_term_reference USING btree (evidence_cd);
Date: 2026-07-29 21:15:05 Duration: 0ms
37 5 263.20 MiB 49.55 MiB 54.99 MiB 52.64 MiB create index ix_chem_disease_ref_source_cd on pub1.chem_disease_reference using btree (source_cd);-
CREATE INDEX ix_chem_disease_ref_source_cd ON pub1.chem_disease_reference USING btree (source_cd);
Date: 2026-07-29 21:16:34 Duration: 0ms
38 5 263.19 MiB 51.92 MiB 53.61 MiB 52.64 MiB create index ix_chem_disease_ref_src_db on pub1.chem_disease_reference using btree (source_acc_db_id);-
CREATE INDEX ix_chem_disease_ref_src_db ON pub1.chem_disease_reference USING btree (source_acc_db_id);
Date: 2026-07-29 21:16:36 Duration: 0ms
39 5 1.20 GiB 235.47 MiB 259.53 MiB 246.32 MiB create index ix_phenotype_term_ref_object_type_id on pub1.phenotype_term_reference using btree (term_object_type_id);-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-07-29 21:14:29 Duration: 10s531ms
-
CREATE INDEX ix_phenotype_term_ref_object_type_id ON pub1.phenotype_term_reference USING btree (term_object_type_id);
Date: 2026-07-29 21:14:29 Duration: 0ms
40 5 1.20 GiB 233.94 MiB 260.02 MiB 246.32 MiB create index ix_phenotype_term_ref_phenotype_id on pub1.phenotype_term_reference using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-07-29 21:14:05 Duration: 12s344ms
-
CREATE INDEX ix_phenotype_term_ref_phenotype_id ON pub1.phenotype_term_reference USING btree (phenotype_id);
Date: 2026-07-29 21:14:05 Duration: 0ms
41 5 688.00 KiB 128.00 KiB 152.00 KiB 137.60 KiB create index ix_gene_disease_cur_ref_qty on pub1.gene_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_gene_disease_cur_ref_qty ON pub1.gene_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-07-30 00:00:35 Duration: 0ms
42 5 68.00 MiB 11.48 MiB 14.45 MiB 13.60 MiB create index ix_phenotype_term_term_id on pub1.phenotype_term using btree (term_id);-
CREATE INDEX ix_phenotype_term_term_id ON pub1.phenotype_term USING btree (term_id);
Date: 2026-07-30 00:00:55 Duration: 0ms
43 5 263.20 MiB 49.57 MiB 53.59 MiB 52.64 MiB create index ix_chem_disease_ref_mod_tm on pub1.chem_disease_reference using btree (mod_tm);-
CREATE INDEX ix_chem_disease_ref_mod_tm ON pub1.chem_disease_reference USING btree (mod_tm);
Date: 2026-07-29 21:16:46 Duration: 0ms
44 5 218.31 MiB 42.72 MiB 44.43 MiB 43.66 MiB create index ix_term_enrich_corr_p_val on pub1.term_enrichment using btree (corrected_p_val);-
CREATE INDEX ix_term_enrich_corr_p_val ON pub1.term_enrichment USING btree (corrected_p_val);
Date: 2026-07-29 23:13:21 Duration: 0ms
45 5 676.21 MiB 131.44 MiB 137.38 MiB 135.24 MiB create index ix_gene_disease_disease on pub1.gene_disease using btree (disease_id);-
CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id);
Date: 2026-07-30 00:00:19 Duration: 10s752ms
-
CREATE INDEX ix_gene_disease_disease ON pub1.gene_disease USING btree (disease_id);
Date: 2026-07-30 00:00:19 Duration: 0ms Database: ctdprd51 User: pub1
46 5 1.20 GiB 241.30 MiB 249.46 MiB 246.32 MiB create index ix_phenotype_term_ref_taxon_id on pub1.phenotype_term_reference using btree (taxon_id);-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id);
Date: 2026-07-29 21:14:54 Duration: 10s878ms
-
CREATE INDEX ix_phenotype_term_ref_taxon_id ON pub1.phenotype_term_reference USING btree (taxon_id);
Date: 2026-07-29 21:14:54 Duration: 0ms
47 5 156.38 MiB 30.80 MiB 32.05 MiB 31.28 MiB create index ix_term_enrich_enr_obj_type on pub1.term_enrichment using btree (enriched_object_type_id);-
CREATE INDEX ix_term_enrich_enr_obj_type ON pub1.term_enrichment USING btree (enriched_object_type_id);
Date: 2026-07-29 23:13:17 Duration: 0ms
48 5 1.20 GiB 236.55 MiB 260.30 MiB 246.32 MiB create index ix_phenotype_term_reference_ixn_id on pub1.phenotype_term_reference using btree (ixn_id);-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id);
Date: 2026-07-29 21:15:47 Duration: 14s818ms
-
CREATE INDEX ix_phenotype_term_reference_ixn_id ON pub1.phenotype_term_reference USING btree (ixn_id);
Date: 2026-07-29 21:15:47 Duration: 0ms
49 5 263.20 MiB 50.66 MiB 54.52 MiB 52.64 MiB create index ix_chem_disease_ref_net_sc on pub1.chem_disease_reference using btree (network_score);-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score);
Date: 2026-07-29 21:16:51 Duration: 5s606ms
-
CREATE INDEX ix_chem_disease_ref_net_sc ON pub1.chem_disease_reference USING btree (network_score);
Date: 2026-07-29 21:16:51 Duration: 0ms
50 5 1.20 GiB 240.78 MiB 251.54 MiB 246.32 MiB create index ix_phenotype_term_ref_via_term_id on pub1.phenotype_term_reference using btree (via_term_id);-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id);
Date: 2026-07-29 21:16:01 Duration: 13s832ms
-
CREATE INDEX ix_phenotype_term_ref_via_term_id ON pub1.phenotype_term_reference USING btree (via_term_id);
Date: 2026-07-29 21:16:01 Duration: 0ms
51 5 263.20 MiB 51.77 MiB 54.77 MiB 52.64 MiB create index ix_chem_disease_reference_ref on pub1.chem_disease_reference using btree (reference_id);-
CREATE INDEX ix_chem_disease_reference_ref ON pub1.chem_disease_reference USING btree (reference_id);
Date: 2026-07-29 21:16:32 Duration: 0ms
52 5 156.38 MiB 26.70 MiB 37.67 MiB 31.28 MiB create index ix_term_enrich_obj_type on pub1.term_enrichment using btree (object_type_id);-
CREATE INDEX ix_term_enrich_obj_type ON pub1.term_enrichment USING btree (object_type_id);
Date: 2026-07-29 23:13:14 Duration: 0ms
53 5 263.20 MiB 51.41 MiB 53.42 MiB 52.64 MiB create index ix_chem_disease_reference_gene on pub1.chem_disease_reference using btree (via_gene_id);-
CREATE INDEX ix_chem_disease_reference_gene ON pub1.chem_disease_reference USING btree (via_gene_id);
Date: 2026-07-29 21:16:39 Duration: 0ms
54 5 263.20 MiB 50.21 MiB 57.17 MiB 52.64 MiB create index ix_chem_disease_reference_dis on pub1.chem_disease_reference using btree (disease_id);-
CREATE INDEX ix_chem_disease_reference_dis ON pub1.chem_disease_reference USING btree (disease_id);
Date: 2026-07-29 21:16:28 Duration: 0ms
55 5 1.20 GiB 236.55 MiB 254.16 MiB 246.32 MiB create index ix_phenotype_term_reference_term_reference_id on pub1.phenotype_term_reference using btree (term_reference_id);-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-07-29 21:15:33 Duration: 15s164ms
-
CREATE INDEX ix_phenotype_term_reference_term_reference_id ON pub1.phenotype_term_reference USING btree (term_reference_id);
Date: 2026-07-29 21:15:33 Duration: 0ms
56 5 1.69 GiB 336.46 MiB 352.09 MiB 345.67 MiB create index ix_phenotype_term_ref_ids on pub1.phenotype_term_reference using btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);-
CREATE INDEX ix_phenotype_term_ref_ids ON pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-07-29 21:16:17 Duration: 15s612ms
-
CREATE INDEX ix_phenotype_term_ref_ids ON pub1.phenotype_term_reference USING btree (phenotype_id, term_id, via_term_object_type_id, term_object_type_id);
Date: 2026-07-29 21:16:17 Duration: 0ms
57 5 68.01 MiB 13.34 MiB 13.73 MiB 13.60 MiB create index ix_phenotype_term_phenotype_id on pub1.phenotype_term using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_phenotype_id ON pub1.phenotype_term USING btree (phenotype_id);
Date: 2026-07-30 00:00:54 Duration: 0ms
58 5 218.30 MiB 43.12 MiB 45.78 MiB 43.66 MiB create index ix_term_enrich_raw_p_val on pub1.term_enrichment using btree (raw_p_val);-
CREATE INDEX ix_term_enrich_raw_p_val ON pub1.term_enrichment USING btree (raw_p_val);
Date: 2026-07-29 23:13:26 Duration: 0ms
59 5 1.20 GiB 239.41 MiB 249.19 MiB 246.32 MiB create index ix_phenotype_term_reference_source_acc_db_id on pub1.phenotype_term_reference using btree (source_acc_db_id);-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-07-29 21:15:17 Duration: 11s953ms
-
CREATE INDEX ix_phenotype_term_reference_source_acc_db_id ON pub1.phenotype_term_reference USING btree (source_acc_db_id);
Date: 2026-07-29 21:15:17 Duration: 0ms
60 5 263.20 MiB 51.70 MiB 54.19 MiB 52.64 MiB create index ix_chem_disease_reference_ixn on pub1.chem_disease_reference using btree (ixn_id);-
CREATE INDEX ix_chem_disease_reference_ixn ON pub1.chem_disease_reference USING btree (ixn_id);
Date: 2026-07-29 21:16:43 Duration: 0ms
61 4 68.09 MiB 14.71 MiB 18.39 MiB 17.02 MiB create index ix_chem_disease_disease on pub1.chem_disease using btree (disease_id);-
CREATE INDEX ix_chem_disease_disease ON pub1.chem_disease USING btree (disease_id);
Date: 2026-07-30 00:01:00 Duration: 0ms
62 4 68.09 MiB 16.97 MiB 17.09 MiB 17.02 MiB create index ix_chem_disease_network_score on pub1.chem_disease using btree (network_score);-
CREATE INDEX ix_chem_disease_network_score ON pub1.chem_disease USING btree (network_score);
Date: 2026-07-30 00:01:00 Duration: 0ms
63 4 32.00 KiB 8.00 KiB 8.00 KiB 8.00 KiB create index ix_chem_disease_exp_ref_qty on pub1.chem_disease using btree (exposure_reference_qty) where (exposure_reference_qty > ?);-
CREATE INDEX ix_chem_disease_exp_ref_qty ON pub1.chem_disease USING btree (exposure_reference_qty) WHERE (exposure_reference_qty > 0);
Date: 2026-07-30 00:01:01 Duration: 0ms
64 4 15.50 MiB 8.00 KiB 7.80 MiB 3.88 MiB alter table pub1.phenotype_term_axn add constraint phenotype_term_axn_pk primary key (phenotype_id, term_id, action_type_nm, action_degree_type_nm);-
ALTER TABLE pub1.phenotype_term_axn ADD CONSTRAINT phenotype_term_axn_pk PRIMARY KEY (phenotype_id, term_id, action_type_nm, action_degree_type_nm);
Date: 2026-07-30 00:00:57 Duration: 0ms
65 4 2.04 MiB 504.00 KiB 552.00 KiB 522.00 KiB create index ix_chem_disease_cur_ref_qty on pub1.chem_disease using btree (curated_reference_qty) where (curated_reference_qty > ?);-
CREATE INDEX ix_chem_disease_cur_ref_qty ON pub1.chem_disease USING btree (curated_reference_qty) WHERE (curated_reference_qty > 0);
Date: 2026-07-30 00:01:01 Duration: 0ms
66 4 67.20 MiB 15.98 MiB 17.16 MiB 16.80 MiB create index ix_chem_disease_ind_gene_qty on pub1.chem_disease using btree (indirect_gene_qty) where (indirect_gene_qty > ?);-
CREATE INDEX ix_chem_disease_ind_gene_qty ON pub1.chem_disease USING btree (indirect_gene_qty) WHERE (indirect_gene_qty > 0);
Date: 2026-07-30 00:01:01 Duration: 0ms
67 2 7.02 MiB 3.06 MiB 3.96 MiB 3.51 MiB create index ix_phenotype_term_axn_term_id on pub1.phenotype_term_axn using btree (term_id);-
CREATE INDEX ix_phenotype_term_axn_term_id ON pub1.phenotype_term_axn USING btree (term_id);
Date: 2026-07-30 00:00:58 Duration: 0ms
68 2 7.02 MiB 2.98 MiB 4.05 MiB 3.51 MiB create index ix_phenotype_term_axn_phenotype_id on pub1.phenotype_term_axn using btree (phenotype_id);-
CREATE INDEX ix_phenotype_term_axn_phenotype_id ON pub1.phenotype_term_axn USING btree (phenotype_id);
Date: 2026-07-30 00:00:57 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 1.00 GiB SELECT * FROM pgbulkload.pg_bulkload ($1);[ Date: 2026-07-29 12:38:36 - Database: ctdprd51 - User: load - Application: pg_bulkload ]
2 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
3 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
4 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
5 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
6 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
7 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
8 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
9 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
10 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
11 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
12 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
13 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
14 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
15 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
16 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
17 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
18 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
19 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
20 1.00 GiB select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn;[ Date: 2026-07-29 18:18:38 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 389.00 sec Highest CPU-cost vacuum
Table pub1.gene_disease
Database ctdprd51 - 2026-07-30 00:49:33 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 389.00 sec Highest CPU-cost vacuum
Table pub1.gene_disease
Database ctdprd51 - 2026-07-30 00:49:33 Date
Analyzes per table
Key values
- pubc.log_query (62) Main table analyzed (database ctdprd51)
- 153 analyzes Total
Table Number of analyzes ctdprd51.pubc.log_query 62 ctdprd51.pg_catalog.pg_class 4 ctdprd51.pub1.term 3 postgres.pg_catalog.pg_shdepend 2 ctdprd51.pub1.db 2 ctdprd51.pg_catalog.pg_index 2 ctdprd51.pub1.reference 2 ctdprd51.pg_catalog.pg_attribute 2 ctdprd51.pub1.dag_node 2 ctdprd51.pg_catalog.pg_attrdef 1 ctdprd51.pub1.exp_study_factor 1 ctdprd51.edit.chem_conc_uom 1 ctdprd51.pub1.country 1 ctdprd51.edit.country 1 ctdprd51.pub1.gene_gene_reference 1 ctdprd51.edit.geographic_region 1 ctdprd51.pub1.db_link 1 ctdprd51.pub1.exp_receptor_race 1 ctdprd51.pub1.exp_stressor 1 ctdprd51.pub1.reference_party_role 1 ctdprd51.pub1.term_pathway 1 ctdprd51.edit.action_type_path 1 ctdprd51.pub1.geographic_region 1 ctdprd51.pub1.db_report 1 ctdprd51.edit.term_label_type 1 ctdprd51.pub1.gene_taxon 1 ctdprd51.pub1.slim_term_mapping 1 ctdprd51.edit.db_link 1 ctdprd51.pub1.exp_outcome 1 ctdprd51.pub2.term_comp 1 ctdprd51.edit.db_report 1 ctdprd51.pub1.chem_disease 1 ctdprd51.pg_catalog.pg_type 1 ctdprd51.pub1.exp_receptor 1 ctdprd51.edit.slim_term 1 ctdprd51.pub1.action_type 1 ctdprd51.pub1.gene_gene 1 ctdprd51.edit.db 1 ctdprd51.pub1.exp_stressor_stressor_src 1 ctdprd51.edit.db_report_site 1 ctdprd51.edit.race 1 ctdprd51.pub1.reference_exp 1 ctdprd51.pub1.exp_receptor_gender 1 ctdprd51.pub1.db_report_site 1 ctdprd51.pub1.gene_go_annot 1 ctdprd51.pub1.img 1 ctdprd51.edit.reference_db_link 1 ctdprd51.pub1.dag_edge 1 ctdprd51.edit.action_type 1 ctdprd51.pub1.gene_disease 1 ctdprd51.pub1.term_label 1 ctdprd51.pub2.term_set_enrichment 1 ctdprd51.pub1.chem_conc_anatomy 1 ctdprd51.pg_catalog.pg_trigger 1 ctdprd51.pub1.ixn 1 ctdprd51.edit.chem_conc_exp_route 1 ctdprd51.edit.study_factor 1 ctdprd51.load.data_load 1 ctdprd51.pg_catalog.pg_description 1 ctdprd51.pub2.term_set_enrichment_agent 1 ctdprd51.pub1.gene_gene_ref_throughput 1 ctdprd51.pg_catalog.pg_depend 1 ctdprd51.pub1.exp_event_project 1 ctdprd51.edit.action_degree 1 ctdprd51.pub1.exp_event_location 1 ctdprd51.pg_catalog.pg_constraint 1 ctdprd51.pg_catalog.pg_proc 1 ctdprd51.pub1.exp_anatomy 1 ctdprd51.pub1.chem_conc 1 ctdprd51.pub1.term_reference 1 ctdprd51.pub1.list_db_report 1 ctdprd51.pub1.exposure 1 ctdprd51.edit.list_db_report 1 ctdprd51.pub1.exp_receptor_tobacco_use 1 ctdprd51.pub1.medium 1 ctdprd51.edit.object_note 1 ctdprd51.pub1.gene_chem_ref_gene_form 1 ctdprd51.pub1.exp_event_assay_method 1 ctdprd51.pub1.phenotype_term 1 ctdprd51.pub1.exp_event 1 ctdprd51.pub1.reference_party 1 Total 153 Vacuums per table
Key values
- pub1.term (38) Main table vacuumed on database ctdprd51
- 238 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pub1.term 38 1 7,304,569 0 251,795 0 0 408,819 206,961 705,087,801 ctdprd51.pubc.log_query 35 6 7,932 0 420 0 0 878 212 1,011,159 ctdprd51.pub1.reference 35 1 5,535,670 0 74,470 5 0 199,733 81,246 163,388,862 ctdprd51.pub1.dag_node 35 1 6,197,673 0 285,817 0 0 333,299 201,076 499,874,083 ctdprd51.pub1.chem_disease 33 1 3,635,258 0 93,840 0 0 172,137 67,652 227,877,958 ctdprd51.pg_catalog.pg_class 3 3 1,038 0 141 0 62 438 130 610,960 ctdprd51.pg_catalog.pg_statistic 2 2 1,489 0 323 0 249 989 209 802,177 ctdprd51.pg_catalog.pg_attribute 2 2 1,303 0 163 0 92 604 147 661,380 ctdprd51.pg_toast.pg_toast_11936346 1 0 91,036 0 4 0 0 45,510 2 2,701,613 ctdprd51.edit.object_note 1 1 197 0 3 0 0 28 2 13,632 ctdprd51.pub1.phenotype_term 1 1 223,192 0 687 0 0 170,437 65,810 153,996,278 ctdprd51.pub1.exp_event 1 0 14,088 0 2 0 0 1 0 281 ctdprd51.pub1.gene_chem_ref_gene_form 1 0 36,227 0 3 0 0 18,063 2 1,077,516 ctdprd51.pub1.exp_stressor_stressor_src 1 0 3,043 0 3 0 0 1 0 281 ctdprd51.pub1.exp_event_assay_method 1 0 5,595 0 3 0 0 1 1 5,981 ctdprd51.pg_toast.pg_toast_11936277 1 1 93 0 3 0 0 50 10 11,996 ctdprd51.pub1.reference_party 1 0 5,173 0 4 0 0 2,553 2 165,050 ctdprd51.pub1.gene_gene 1 0 13,291 0 5 0 0 6,594 2 402,825 ctdprd51.pg_toast.pg_toast_2619 1 1 4,954 0 1,433 0 9,922 4,841 972 574,176 ctdprd51.pub1.exposure 1 0 4,178 0 3 0 0 1 1 7,101 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 1,320 0 2 0 0 1 0 281 ctdprd51.edit.action_degree 1 0 45 0 0 0 0 12 1 9,451 ctdprd51.pub1.exp_outcome 1 0 1,000 0 3 0 0 1 1 6,145 ctdprd51.pg_catalog.pg_constraint 1 1 291 0 19 0 0 118 20 96,724 ctdprd51.pg_catalog.pg_proc 1 1 441 0 95 0 79 290 91 173,386 ctdprd51.pub1.exp_event_location 1 0 3,882 0 3 0 0 1 1 6,057 ctdprd51.pg_catalog.pg_type 1 1 156 0 35 0 0 69 33 153,750 ctdprd51.pub1.term_reference 1 0 40,786 0 5 0 0 20,338 2 1,212,581 ctdprd51.pub1.exp_anatomy 1 0 163 0 2 0 0 1 0 281 ctdprd51.pub1.exp_receptor 1 0 8,176 0 2 0 0 1 0 281 ctdprd51.pub1.chem_conc 1 0 767 0 4 0 0 369 2 35,510 ctdprd51.pub1.gene_gene_ref_throughput 1 0 15,995 0 3 0 0 7,958 1 477,941 ctdprd51.pub1.slim_term_mapping 1 0 606 0 4 0 0 265 2 30,058 ctdprd51.pub2.term_set_enrichment_agent 1 0 225,749 0 95,621 0 0 112,815 5 6,697,292 ctdprd51.pub1.exp_event_project 1 0 2,428 0 2 0 0 1 0 281 ctdprd51.pg_catalog.pg_depend 1 1 718 0 93 0 65 325 100 399,516 ctdprd51.edit.db_link 1 0 7,717 0 3 0 0 3,740 1 229,055 ctdprd51.pg_catalog.pg_trigger 1 1 384 0 34 0 0 158 38 201,801 ctdprd51.edit.action_type_path 1 0 48 0 0 0 0 4 1 9,059 ctdprd51.pub1.ixn 1 1 1,647,242 0 98 0 0 1,094,971 49,963 256,494,455 ctdprd51.pub1.gene_taxon 1 0 193,311 0 6 0 0 96,595 4 5,729,958 ctdprd51.edit.evidence 1 0 32 0 2 0 0 3 2 15,339 ctdprd51.pub1.gene_disease 1 1 3,088,535 0 1,002,351 0 0 1,710,477 902,466 2,234,849,673 ctdprd51.pub1.term_label 1 0 240,627 0 90,763 0 0 120,258 5 7,132,452 ctdprd51.pub1.exp_receptor_race 1 0 1,434 0 2 0 0 1 0 281 ctdprd51.pg_toast.pg_toast_486223 1 0 48 0 0 0 0 1 0 188 ctdprd51.pub1.chem_conc_anatomy 1 0 525 0 3 0 0 233 1 22,166 ctdprd51.pub1.exp_stressor 1 0 7,065 0 3 0 0 1 1 6,801 ctdprd51.pub1.reference_party_role 1 0 13,815 0 4 0 0 6,880 1 414,339 ctdprd51.pub1.term_pathway 1 0 3,337 0 4 0 0 1,614 2 107,917 ctdprd51.pg_catalog.pg_index 1 1 206 0 27 0 0 112 20 80,725 ctdprd51.pub1.exp_receptor_gender 1 0 3,006 0 2 0 0 1 0 281 ctdprd51.pub1.img 1 0 1,109 0 5 0 0 524 2 45,375 ctdprd51.pub1.gene_go_annot 1 0 718,256 0 301,870 0 0 359,004 12 21,276,985 ctdprd51.pub1.dag_edge 1 0 1,053 0 5 0 0 482 2 39,585 ctdprd51.edit.reference_db_link 1 0 7,506 0 4 0 0 3,740 1 228,986 ctdprd51.pub1.db 1 1 151 0 13 0 0 20 10 36,683 ctdprd51.pub1.db_link 1 0 338,691 0 153,987 0 0 169,205 6 10,032,499 postgres.pg_catalog.pg_shdepend 1 1 224 0 16 0 0 99 14 46,922 ctdprd51.pub1.exp_study_factor 1 0 81 0 2 0 0 1 0 281 ctdprd51.pub1.reference_exp 1 0 346 0 3 0 0 1 1 3,389 ctdprd51.pub1.gene_gene_reference 1 0 33,327 0 3 0 0 16,586 1 986,993 ctdprd51.edit.country 1 0 63 0 0 0 0 8 1 9,627 Total 238 31 29,696,661 155,094 2,354,225 5 10,469 5,092,261 1,577,251 4,305,572,460 Tuples removed per table
Key values
- pub1.gene_disease (35382373) Main table with removed tuples on database ctdprd51
- 46652711 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pub1.gene_disease 1 1 35,382,373 35,382,373 0 0 520,329 ctdprd51.pub1.chem_disease 33 1 3,562,194 231,542,610 113,990,208 0 1,727,121 ctdprd51.pub1.phenotype_term 1 1 3,557,222 3,557,222 0 0 66,491 ctdprd51.pub1.term 38 1 2,215,345 159,373,542 77,537,075 0 3,532,496 ctdprd51.pub1.dag_node 35 1 1,825,008 123,826,284 60,225,264 0 3,012,866 ctdprd51.pub1.ixn 1 1 57,874 2,535,212 0 0 603,943 ctdprd51.pub1.reference 35 1 35,085 13,957,127 6,837,099 0 2,726,902 ctdprd51.pg_toast.pg_toast_2619 1 1 6,160 19,211 0 0 12,592 ctdprd51.pubc.log_query 35 6 3,514 63,111 51,172 0 2,314 ctdprd51.pg_catalog.pg_attribute 2 2 1,996 18,520 0 0 472 ctdprd51.pg_catalog.pg_depend 1 1 1,684 13,747 0 0 153 ctdprd51.pg_catalog.pg_statistic 2 2 1,317 6,269 301 0 820 ctdprd51.pg_catalog.pg_trigger 1 1 676 1,889 0 13 45 postgres.pg_catalog.pg_shdepend 1 1 645 2,119 0 0 22 ctdprd51.pg_catalog.pg_index 1 1 259 1,188 0 0 39 ctdprd51.pg_catalog.pg_constraint 1 1 210 911 0 0 40 ctdprd51.edit.object_note 1 1 169 169 0 5 5 ctdprd51.pg_catalog.pg_class 3 3 169 7,139 0 0 282 ctdprd51.edit.country 1 0 163 249 0 0 4 ctdprd51.pg_catalog.pg_proc 1 1 150 1,589 0 0 205 ctdprd51.pub1.db 1 1 134 134 0 0 7 ctdprd51.edit.action_type_path 1 0 106 106 0 0 2 ctdprd51.edit.action_degree 1 0 96 219 0 0 6 ctdprd51.pg_toast.pg_toast_11936277 1 1 68 71 0 0 22 ctdprd51.edit.evidence 1 0 54 18 0 0 1 ctdprd51.pg_catalog.pg_type 1 1 40 1,171 0 0 35 ctdprd51.pg_toast.pg_toast_11936346 1 0 0 246,034 0 0 45,509 ctdprd51.pub1.exp_event 1 0 0 235,732 0 0 6,965 ctdprd51.pub1.gene_chem_ref_gene_form 1 0 0 3,334,360 0 0 18,062 ctdprd51.pub1.exp_stressor_stressor_src 1 0 0 337,026 0 0 1,492 ctdprd51.pub1.exp_event_assay_method 1 0 0 274,309 0 0 2,768 ctdprd51.pub1.reference_party 1 0 0 456,853 0 0 2,552 ctdprd51.pub1.gene_gene 1 0 0 1,219,652 0 0 6,593 ctdprd51.pub1.exposure 1 0 0 246,770 0 0 2,035 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 0 88,384 0 0 624 ctdprd51.pub1.exp_outcome 1 0 0 48,479 0 0 441 ctdprd51.pub1.exp_event_location 1 0 0 282,536 0 0 1,889 ctdprd51.pub1.term_reference 1 0 0 3,762,172 0 0 20,337 ctdprd51.pub1.exp_anatomy 1 0 0 4,377 0 0 37 ctdprd51.pub1.exp_receptor 1 0 0 218,063 0 0 4,058 ctdprd51.pub1.chem_conc 1 0 0 11,335 0 0 368 ctdprd51.pub1.gene_gene_ref_throughput 1 0 0 1,528,421 0 0 7,957 ctdprd51.pub1.slim_term_mapping 1 0 0 33,517 0 0 264 ctdprd51.pub2.term_set_enrichment_agent 1 0 0 50,023,047 0 0 568,445 ctdprd51.pub1.exp_event_project 1 0 0 113,913 0 0 1,191 ctdprd51.edit.db_link 1 0 0 335,486 0 0 3,739 ctdprd51.pub1.gene_taxon 1 0 0 15,165,253 0 0 96,594 ctdprd51.pub1.term_label 1 0 0 8,423,122 0 0 120,257 ctdprd51.pub1.exp_receptor_race 1 0 0 105,119 0 0 681 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 0 0 0 ctdprd51.pub1.chem_conc_anatomy 1 0 0 24,778 0 0 232 ctdprd51.pub1.exp_stressor 1 0 0 239,186 0 0 3,502 ctdprd51.pub1.reference_party_role 1 0 0 1,272,475 0 0 6,879 ctdprd51.pub1.term_pathway 1 0 0 135,792 0 0 1,613 ctdprd51.pub1.exp_receptor_gender 1 0 0 214,677 0 0 1,487 ctdprd51.pub1.img 1 0 0 50,667 0 0 523 ctdprd51.pub1.gene_go_annot 1 0 0 56,364,442 0 0 359,003 ctdprd51.pub1.dag_edge 1 0 0 88,931 0 0 481 ctdprd51.edit.reference_db_link 1 0 0 335,486 0 0 3,739 ctdprd51.pub1.db_link 1 0 0 23,324,378 0 0 169,204 ctdprd51.pub1.exp_study_factor 1 0 0 1,794 0 0 11 ctdprd51.pub1.reference_exp 1 0 0 3,747 0 0 135 ctdprd51.pub1.gene_gene_reference 1 0 0 1,520,765 0 0 16,585 Total 238 31 46,652,711 740,383,278 258,641,119 18 13,683,466 Pages removed per table
Key values
- pg_catalog.pg_trigger (13) Main table with removed pages on database ctdprd51
- 18 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pg_catalog.pg_trigger 1 1 676 13 ctdprd51.edit.object_note 1 1 169 5 ctdprd51.pg_toast.pg_toast_11936346 1 0 0 0 ctdprd51.pub1.phenotype_term 1 1 3557222 0 ctdprd51.pub1.exp_event 1 0 0 0 ctdprd51.pub1.gene_chem_ref_gene_form 1 0 0 0 ctdprd51.pub1.exp_stressor_stressor_src 1 0 0 0 ctdprd51.pub1.exp_event_assay_method 1 0 0 0 ctdprd51.pg_toast.pg_toast_11936277 1 1 68 0 ctdprd51.pub1.reference_party 1 0 0 0 ctdprd51.pub1.gene_gene 1 0 0 0 ctdprd51.pg_toast.pg_toast_2619 1 1 6160 0 ctdprd51.pub1.exposure 1 0 0 0 ctdprd51.pg_catalog.pg_statistic 2 2 1317 0 ctdprd51.pub1.exp_receptor_tobacco_use 1 0 0 0 ctdprd51.edit.action_degree 1 0 96 0 ctdprd51.pub1.exp_outcome 1 0 0 0 ctdprd51.pg_catalog.pg_constraint 1 1 210 0 ctdprd51.pub1.chem_disease 33 1 3562194 0 ctdprd51.pg_catalog.pg_proc 1 1 150 0 ctdprd51.pub1.exp_event_location 1 0 0 0 ctdprd51.pubc.log_query 35 6 3514 0 ctdprd51.pg_catalog.pg_type 1 1 40 0 ctdprd51.pub1.term_reference 1 0 0 0 ctdprd51.pub1.exp_anatomy 1 0 0 0 ctdprd51.pub1.exp_receptor 1 0 0 0 ctdprd51.pub1.chem_conc 1 0 0 0 ctdprd51.pub1.gene_gene_ref_throughput 1 0 0 0 ctdprd51.pub1.slim_term_mapping 1 0 0 0 ctdprd51.pub2.term_set_enrichment_agent 1 0 0 0 ctdprd51.pub1.exp_event_project 1 0 0 0 ctdprd51.pg_catalog.pg_depend 1 1 1684 0 ctdprd51.edit.db_link 1 0 0 0 ctdprd51.edit.action_type_path 1 0 106 0 ctdprd51.pub1.ixn 1 1 57874 0 ctdprd51.pub1.reference 35 1 35085 0 ctdprd51.pub1.gene_taxon 1 0 0 0 ctdprd51.pub1.term 38 1 2215345 0 ctdprd51.edit.evidence 1 0 54 0 ctdprd51.pub1.dag_node 35 1 1825008 0 ctdprd51.pub1.gene_disease 1 1 35382373 0 ctdprd51.pub1.term_label 1 0 0 0 ctdprd51.pub1.exp_receptor_race 1 0 0 0 ctdprd51.pg_catalog.pg_class 3 3 169 0 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 ctdprd51.pub1.chem_conc_anatomy 1 0 0 0 ctdprd51.pub1.exp_stressor 1 0 0 0 ctdprd51.pub1.reference_party_role 1 0 0 0 ctdprd51.pub1.term_pathway 1 0 0 0 ctdprd51.pg_catalog.pg_index 1 1 259 0 ctdprd51.pg_catalog.pg_attribute 2 2 1996 0 ctdprd51.pub1.exp_receptor_gender 1 0 0 0 ctdprd51.pub1.img 1 0 0 0 ctdprd51.pub1.gene_go_annot 1 0 0 0 ctdprd51.pub1.dag_edge 1 0 0 0 ctdprd51.edit.reference_db_link 1 0 0 0 ctdprd51.pub1.db 1 1 134 0 ctdprd51.pub1.db_link 1 0 0 0 postgres.pg_catalog.pg_shdepend 1 1 645 0 ctdprd51.pub1.exp_study_factor 1 0 0 0 ctdprd51.pub1.reference_exp 1 0 0 0 ctdprd51.pub1.gene_gene_reference 1 0 0 0 ctdprd51.edit.country 1 0 163 0 Total 238 31 46,652,711 18 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 26 00 0 0 01 0 1 02 0 1 03 0 2 04 0 0 05 0 3 06 0 0 07 0 2 08 1 1 09 0 0 10 0 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 1 Jul 27 00 1 0 01 0 1 02 0 1 03 0 1 04 0 1 05 1 3 06 0 1 07 0 1 08 0 0 09 0 1 10 0 0 11 0 1 12 0 0 13 0 0 14 0 1 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 Jul 28 00 4 2 01 0 1 02 0 1 03 0 2 04 0 1 05 0 4 06 0 0 07 0 1 08 0 0 09 0 1 10 0 1 11 1 0 12 0 1 13 0 0 14 0 0 15 0 1 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 Jul 29 00 0 0 01 0 2 02 1 3 03 0 2 04 0 1 05 1 4 06 0 1 07 0 0 08 0 0 09 10 12 10 0 0 11 6 18 12 0 1 13 1 4 14 0 0 15 0 0 16 17 21 17 1 0 18 0 0 19 0 0 20 0 0 21 0 2 22 0 1 23 0 0 Jul 30 00 191 32 01 0 2 02 2 3 03 0 1 - 389.00 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
- 223 Total read queries
- 170 Total write queries
Queries by database
Key values
- unknown Main database
- 285 Requests
- 8h3m18s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 1,025 Requests
User Request type Count Duration edit Total 4 35s998ms insert 4 35s998ms load Total 90 4h14m36s select 90 4h14m36s postgres Total 73 1h20m22s copy to 73 1h20m22s pub1 Total 12 1h11m4s insert 8 1h10m29s select 4 34s168ms pubc Total 7 1h6m30s select 7 1h6m30s pubeu Total 114 24m17s select 114 24m17s qaeu Total 31 8m12s select 31 8m12s unknown Total 1,025 1d3h52m6s copy to 308 2h31m25s ddl 120 3h2m17s insert 52 3h15m6s others 33 19m51s select 494 17h17m27s update 18 1h25m58s Duration by user
Key values
- 1d3h52m6s (unknown) Main time consuming user
User Request type Count Duration edit Total 4 35s998ms insert 4 35s998ms load Total 90 4h14m36s select 90 4h14m36s postgres Total 73 1h20m22s copy to 73 1h20m22s pub1 Total 12 1h11m4s insert 8 1h10m29s select 4 34s168ms pubc Total 7 1h6m30s select 7 1h6m30s pubeu Total 114 24m17s select 114 24m17s qaeu Total 31 8m12s select 31 8m12s unknown Total 1,025 1d3h52m6s copy to 308 2h31m25s ddl 120 3h2m17s insert 52 3h15m6s others 33 19m51s select 494 17h17m27s update 18 1h25m58s Queries by host
Key values
- unknown Main host
- 1,356 Requests
- 1d12h17m45s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 359 Requests
- 9h25m5s (unknown)
- Main time consuming application
Application Request type Count Duration pgAdmin 4 - CONN:7727537 Total 1 8s999ms insert 1 8s999ms pg_bulkload Total 16 15m28s select 16 15m28s pg_dump Total 24 26m40s copy to 24 26m40s psql Total 5 47m22s select 5 47m22s unknown Total 359 9h25m5s copy to 84 17m55s ddl 32 45m54s insert 20 1h9m8s others 12 5m24s select 202 6h23m42s update 9 42m59s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-26 15:43:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 265 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 1h57m12s select pub1.maint_gene_chem_ref_gene_form_refresh ();[ Date: 2026-07-30 02:44:16 - Bind query: yes ]
2 1h8m36s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-07-29 20:21:55 - Bind query: yes ]
3 50m34s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-07-29 19:13:14 - Bind query: yes ]
4 36m12s SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;[ Date: 2026-07-29 17:25:27 - Database: ctdprd51 - User: load - Bind query: yes ]
5 33m14s update pub1.GENE_DISEASE gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.GENE_DISEASE_REFERENCE gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.REFERENCE r where has_exposures = true));[ Date: 2026-07-30 00:40:47 - Bind query: yes ]
6 30m48s insert into pub1.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;[ Date: 2026-07-29 16:39:31 - Bind query: yes ]
7 17m22s insert into pub1.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;[ Date: 2026-07-29 16:02:11 - Database: ctdprd51 - User: pub1 - Bind query: yes ]
8 13m17s ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);[ Date: 2026-07-29 23:26:44 - Bind query: yes ]
9 10m46s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');[ Date: 2026-07-29 17:39:08 - Database: ctdprd51 - User: load - Bind query: yes ]
10 9m46s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-07-30 00:09:48 - Database: ctdprd51 - User: pubc - Application: psql ]
11 9m25s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-07-27 00:09:27 - Database: ctdprd51 - User: pubc - Application: psql ]
12 9m24s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-07-28 00:09:26 - Database: ctdprd51 - User: pubc - Application: psql ]
13 9m24s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-07-26 00:09:26 - Database: ctdprd51 - User: pubc - Application: psql ]
14 9m21s /* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();[ Date: 2026-07-29 00:09:23 - Database: ctdprd51 - User: pubc - Application: psql ]
15 7m45s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');[ Date: 2026-07-29 20:48:34 - Database: ctdprd51 - User: load - Application: pg_bulkload - Bind query: yes ]
16 6m47s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');[ Date: 2026-07-29 20:34:13 - Bind query: yes ]
17 5m31s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');[ Date: 2026-07-29 12:08:43 - Bind query: yes ]
18 5m28s SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');[ Date: 2026-07-29 21:26:08 - Bind query: yes ]
19 5m21s insert into pub1.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;[ Date: 2026-07-29 16:44:53 - Bind query: yes ]
20 4m33s CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);[ Date: 2026-07-29 20:54:33 - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h57m12s 1 1h57m12s 1h57m12s 1h57m12s select pub1.maint_gene_chem_ref_gene_form_refresh ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 30 02 1 1h57m12s 1h57m12s -
select pub1.maint_gene_chem_ref_gene_form_refresh ();
Date: 2026-07-30 02:44:16 Duration: 1h57m12s Bind query: yes
2 1h21m41s 12 16s498ms 1h8m36s 6m48s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 20 12 1h21m41s 6m48s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:21:55 Duration: 1h8m36s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:34:13 Duration: 6m47s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:24:47 Duration: 1m27s Bind query: yes
3 1h2m44s 64 5s96ms 7m45s 58s825ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 11 10 1m25s 8s540ms 12 32 35m37s 1m6s 17 3 1m10s 23s408ms 20 3 9m11s 3m3s 21 4 7m23s 1m50s 22 8 4m13s 31s706ms 23 3 3m21s 1m7s Jul 30 00 1 20s931ms 20s931ms [ User: load - Total duration: 15m28s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m28s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-07-29 20:48:34 Duration: 7m45s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-07-29 12:08:43 Duration: 5m31s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-07-29 21:26:08 Duration: 5m28s Bind query: yes
4 50m34s 1 50m34s 50m34s 50m34s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 29 19 1 50m34s 50m34s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 19:13:14 Duration: 50m34s Bind query: yes
5 47m22s 5 9m21s 9m46s 9m28s select maint_query_logs_archive ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 26 00 1 9m24s 9m24s Jul 27 00 1 9m25s 9m25s Jul 28 00 1 9m24s 9m24s Jul 29 00 1 9m21s 9m21s Jul 30 00 1 9m46s 9m46s [ User: pubc - Total duration: 47m22s - Times executed: 5 ]
[ Application: psql - Total duration: 47m22s - Times executed: 5 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-30 00:09:48 Duration: 9m46s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-27 00:09:27 Duration: 9m25s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-28 00:09:26 Duration: 9m24s Database: ctdprd51 User: pubc Application: psql
6 36m12s 1 36m12s 36m12s 36m12s select i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) from edit.ixn i, edit.reference_ixn r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in (...) order by i.id asc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 29 17 1 36m12s 36m12s [ User: load - Total duration: 36m12s - Times executed: 1 ]
-
SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;
Date: 2026-07-29 17:25:27 Duration: 36m12s Database: ctdprd51 User: load Bind query: yes
7 33m14s 1 33m14s 33m14s 33m14s update pub1.gene_disease gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.gene_disease_reference gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.reference r where has_exposures = true));Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 30 00 1 33m14s 33m14s -
update pub1.GENE_DISEASE gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.GENE_DISEASE_REFERENCE gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.REFERENCE r where has_exposures = true));
Date: 2026-07-30 00:40:47 Duration: 33m14s Bind query: yes
8 30m48s 1 30m48s 30m48s 30m48s insert into pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.gene_go_annot;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 29 16 1 30m48s 30m48s -
insert into pub1.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;
Date: 2026-07-29 16:39:31 Duration: 30m48s Bind query: yes
9 22m39s 12 1m52s 1m55s 1m53s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 06 1 1m53s 1m53s 10 1 1m53s 1m53s 14 1 1m53s 1m53s 18 1 1m53s 1m53s Jul 28 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s Jul 29 06 1 1m52s 1m52s 10 1 1m53s 1m53s 14 1 1m52s 1m52s 18 1 1m55s 1m55s [ User: postgres - Total duration: 22m39s - Times executed: 12 ]
[ Application: pg_dump - Total duration: 22m39s - Times executed: 12 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:06:56 Duration: 1m55s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 10:06:55 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:06:56 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
10 17m22s 1 17m22s 17m22s 17m22s insert into pub1.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.db_link;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 29 16 1 17m22s 17m22s [ User: pub1 - Total duration: 17m22s - Times executed: 1 ]
-
insert into pub1.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;
Date: 2026-07-29 16:02:11 Duration: 17m22s Database: ctdprd51 User: pub1 Bind query: yes
11 13m55s 5 46s252ms 10m46s 2m47s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub1.gene_chem_reference gcr, pub1.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 29 17 2 11m33s 5m46s 18 3 2m21s 47s188ms [ User: load - Total duration: 10m46s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 17:39:08 Duration: 10m46s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:08:41 Duration: 48s115ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:03:08 Duration: 47s197ms Bind query: yes
12 13m17s 1 13m17s 13m17s 13m17s alter table pub1.term_enrichment_agent add constraint term_enr_agent_term_enr_fk foreign key (term_id, enriched_term_id) references term_enrichment (term_id, enriched_term_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 29 23 1 13m17s 13m17s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);
Date: 2026-07-29 23:26:44 Duration: 13m17s Bind query: yes
13 10m17s 45 5s936ms 23s131ms 13s722ms select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.gene_disease_reference order by gene_id, disease_id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 29 23 45 10m17s 13s722ms -
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:34:26 Duration: 23s131ms Bind query: yes
-
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:34:49 Duration: 23s29ms Bind query: yes
-
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:35:11 Duration: 22s164ms Bind query: yes
14 5m21s 1 5m21s 5m21s 5m21s insert into pub1.gene_taxon (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.gene_taxon;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 29 16 1 5m21s 5m21s -
insert into pub1.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;
Date: 2026-07-29 16:44:53 Duration: 5m21s Bind query: yes
15 4m51s 12 24s94ms 24s483ms 24s273ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 06 1 24s483ms 24s483ms 10 1 24s235ms 24s235ms 14 1 24s330ms 24s330ms 18 1 24s327ms 24s327ms Jul 28 06 1 24s141ms 24s141ms 10 1 24s407ms 24s407ms 14 1 24s168ms 24s168ms 18 1 24s116ms 24s116ms Jul 29 06 1 24s284ms 24s284ms 10 1 24s94ms 24s94ms 14 1 24s240ms 24s240ms 18 1 24s457ms 24s457ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:07:20 Duration: 24s483ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:07:20 Duration: 24s457ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-28 10:07:18 Duration: 24s407ms
16 4m33s 1 4m33s 4m33s 4m33s create unique index gene_disease_reference_ak1 on pub1.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 29 20 1 4m33s 4m33s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 4m33s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 0ms Database: ctdprd51 User: pub1
17 4m18s 1 4m18s 4m18s 4m18s insert into pub1.term_label (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.term t, load.term_label l where t.id = l.term_id and t.id in ( select id from pub1.term);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 29 16 1 4m18s 4m18s -
INSERT INTO pub1.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub1.TERM);
Date: 2026-07-29 16:08:42 Duration: 4m18s Bind query: yes
18 4m 12 19s899ms 20s346ms 20s73ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 06 1 20s42ms 20s42ms 10 1 19s980ms 19s980ms 14 1 19s913ms 19s913ms 18 1 19s899ms 19s899ms Jul 28 06 1 19s915ms 19s915ms 10 1 20s67ms 20s67ms 14 1 20s201ms 20s201ms 18 1 20s133ms 20s133ms Jul 29 06 1 19s977ms 19s977ms 10 1 20s180ms 20s180ms 14 1 20s225ms 20s225ms 18 1 20s346ms 20s346ms [ User: postgres - Total duration: 4m - Times executed: 12 ]
[ Application: pg_dump - Total duration: 4m - Times executed: 12 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:00:21 Duration: 20s346ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:22 Duration: 20s225ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 14:00:22 Duration: 20s201ms Database: ctdprd51 User: postgres Application: pg_dump
19 3m27s 6 8s26ms 1m55s 34s581ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where d.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 21 6 3m27s 34s581ms [ User: pubeu - Total duration: 2m31s - Times executed: 4 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'drug-induced liver injury' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2190672) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:12:50 Duration: 1m55s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'cardiomyopathy' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2195718) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:07:29 Duration: 29s599ms Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'arrhythmia' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2191919) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:06:29 Duration: 26s272ms Bind query: yes
20 3m22s 1 3m22s 3m22s 3m22s alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 29 23 1 3m22s 3m22s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:06 Duration: 3m22s Bind query: yes
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:05 Duration: 0ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 64 1h2m44s 5s96ms 7m45s 58s825ms select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 29 11 10 1m25s 8s540ms 12 32 35m37s 1m6s 17 3 1m10s 23s408ms 20 3 9m11s 3m3s 21 4 7m23s 1m50s 22 8 4m13s 31s706ms 23 3 3m21s 1m7s Jul 30 00 1 20s931ms 20s931ms [ User: load - Total duration: 15m28s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m28s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-07-29 20:48:34 Duration: 7m45s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-07-29 12:08:43 Duration: 5m31s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-07-29 21:26:08 Duration: 5m28s Bind query: yes
2 45 10m17s 5s936ms 23s131ms 13s722ms select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.gene_disease_reference order by gene_id, disease_id;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 23 45 10m17s 13s722ms -
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:34:26 Duration: 23s131ms Bind query: yes
-
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:34:49 Duration: 23s29ms Bind query: yes
-
select gene_id, disease_id, reference_id, source_cd, via_chem_id, network_score, source_acc_txt from pub1.GENE_DISEASE_REFERENCE order by gene_id, disease_id;
Date: 2026-07-29 23:35:11 Duration: 22s164ms Bind query: yes
3 12 1h21m41s 16s498ms 1h8m36s 6m48s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 20 12 1h21m41s 6m48s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:21:55 Duration: 1h8m36s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:34:13 Duration: 6m47s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:24:47 Duration: 1m27s Bind query: yes
4 12 22m39s 1m52s 1m55s 1m53s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 06 1 1m53s 1m53s 10 1 1m53s 1m53s 14 1 1m53s 1m53s 18 1 1m53s 1m53s Jul 28 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s Jul 29 06 1 1m52s 1m52s 10 1 1m53s 1m53s 14 1 1m52s 1m52s 18 1 1m55s 1m55s [ User: postgres - Total duration: 22m39s - Times executed: 12 ]
[ Application: pg_dump - Total duration: 22m39s - Times executed: 12 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:06:56 Duration: 1m55s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 10:06:55 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:06:56 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
5 12 4m51s 24s94ms 24s483ms 24s273ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 06 1 24s483ms 24s483ms 10 1 24s235ms 24s235ms 14 1 24s330ms 24s330ms 18 1 24s327ms 24s327ms Jul 28 06 1 24s141ms 24s141ms 10 1 24s407ms 24s407ms 14 1 24s168ms 24s168ms 18 1 24s116ms 24s116ms Jul 29 06 1 24s284ms 24s284ms 10 1 24s94ms 24s94ms 14 1 24s240ms 24s240ms 18 1 24s457ms 24s457ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:07:20 Duration: 24s483ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:07:20 Duration: 24s457ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-28 10:07:18 Duration: 24s407ms
6 12 4m 19s899ms 20s346ms 20s73ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 06 1 20s42ms 20s42ms 10 1 19s980ms 19s980ms 14 1 19s913ms 19s913ms 18 1 19s899ms 19s899ms Jul 28 06 1 19s915ms 19s915ms 10 1 20s67ms 20s67ms 14 1 20s201ms 20s201ms 18 1 20s133ms 20s133ms Jul 29 06 1 19s977ms 19s977ms 10 1 20s180ms 20s180ms 14 1 20s225ms 20s225ms 18 1 20s346ms 20s346ms [ User: postgres - Total duration: 4m - Times executed: 12 ]
[ Application: pg_dump - Total duration: 4m - Times executed: 12 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:00:21 Duration: 20s346ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:22 Duration: 20s225ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 14:00:22 Duration: 20s201ms Database: ctdprd51 User: postgres Application: pg_dump
7 12 3m6s 15s397ms 15s796ms 15s520ms copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 06 1 15s602ms 15s602ms 10 1 15s558ms 15s558ms 14 1 15s397ms 15s397ms 18 1 15s490ms 15s490ms Jul 28 06 1 15s451ms 15s451ms 10 1 15s532ms 15s532ms 14 1 15s411ms 15s411ms 18 1 15s486ms 15s486ms Jul 29 06 1 15s560ms 15s560ms 10 1 15s498ms 15s498ms 14 1 15s463ms 15s463ms 18 1 15s796ms 15s796ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-29 18:07:36 Duration: 15s796ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-27 06:07:36 Duration: 15s602ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-29 06:07:34 Duration: 15s560ms
8 12 2m59s 14s823ms 15s160ms 14s955ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 06 1 14s935ms 14s935ms 10 1 14s823ms 14s823ms 14 1 14s994ms 14s994ms 18 1 14s907ms 14s907ms Jul 28 06 1 14s909ms 14s909ms 10 1 15s48ms 15s48ms 14 1 14s932ms 14s932ms 18 1 14s848ms 14s848ms Jul 29 06 1 14s979ms 14s979ms 10 1 14s931ms 14s931ms 14 1 15s160ms 15s160ms 18 1 14s996ms 14s996ms -
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:54 Duration: 15s160ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 10:00:53 Duration: 15s48ms
-
COPY edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:00:53 Duration: 14s996ms
9 12 2m55s 14s517ms 14s713ms 14s634ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 06 1 14s601ms 14s601ms 10 1 14s642ms 14s642ms 14 1 14s668ms 14s668ms 18 1 14s552ms 14s552ms Jul 28 06 1 14s517ms 14s517ms 10 1 14s623ms 14s623ms 14 1 14s566ms 14s566ms 18 1 14s713ms 14s713ms Jul 29 06 1 14s666ms 14s666ms 10 1 14s679ms 14s679ms 14 1 14s682ms 14s682ms 18 1 14s692ms 14s692ms -
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 18:01:07 Duration: 14s713ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:01:08 Duration: 14s692ms
-
COPY edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:01:08 Duration: 14s682ms
10 12 1m30s 7s451ms 7s571ms 7s505ms copy edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 06 1 7s521ms 7s521ms 10 1 7s528ms 7s528ms 14 1 7s531ms 7s531ms 18 1 7s474ms 7s474ms Jul 28 06 1 7s451ms 7s451ms 10 1 7s499ms 7s499ms 14 1 7s484ms 7s484ms 18 1 7s454ms 7s454ms Jul 29 06 1 7s476ms 7s476ms 10 1 7s571ms 7s571ms 14 1 7s548ms 7s548ms 18 1 7s518ms 7s518ms -
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 10:00:31 Duration: 7s571ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:32 Duration: 7s548ms
-
COPY edit.ixn (id, ixn_type_id, parent_id, position_seq, root_id, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-27 14:00:31 Duration: 7s531ms
11 12 1m18s 6s444ms 6s638ms 6s516ms copy edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 06 1 6s444ms 6s444ms 10 1 6s538ms 6s538ms 14 1 6s515ms 6s515ms 18 1 6s498ms 6s498ms Jul 28 06 1 6s462ms 6s462ms 10 1 6s498ms 6s498ms 14 1 6s465ms 6s465ms 18 1 6s558ms 6s558ms Jul 29 06 1 6s482ms 6s482ms 10 1 6s507ms 6s507ms 14 1 6s638ms 6s638ms 18 1 6s592ms 6s592ms -
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:01:17 Duration: 6s638ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:01:16 Duration: 6s592ms
-
COPY edit.reference_ixn (id, reference_acc_txt, reference_acc_db_id, ixn_id, taxon_acc_txt, taxon_acc_db_id, evidence_cd, source_cd, field_cd, internal_note, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 18:01:16 Duration: 6s558ms
12 12 1m14s 6s163ms 6s284ms 6s220ms copy edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 06 1 6s233ms 6s233ms 10 1 6s191ms 6s191ms 14 1 6s227ms 6s227ms 18 1 6s163ms 6s163ms Jul 28 06 1 6s202ms 6s202ms 10 1 6s203ms 6s203ms 14 1 6s284ms 6s284ms 18 1 6s163ms 6s163ms Jul 29 06 1 6s210ms 6s210ms 10 1 6s264ms 6s264ms 14 1 6s258ms 6s258ms 18 1 6s247ms 6s247ms -
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 14:00:38 Duration: 6s284ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 10:00:38 Duration: 6s264ms
-
COPY edit.ixn_action (ixn_id, action_type_id, action_degree_type_id, position_seq, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:38 Duration: 6s258ms
13 8 44s466ms 5s364ms 5s835ms 5s558ms select ? "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casrn "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" from ( with sq as ( select distinct c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casrn, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort from term c inner join gene_chem_reference gcr on c.id = gcr.chem_id inner join term g on gcr.gene_id = g.id where (c.id = ?)) select distinct sq.chem_nm, sq.chem_acc_txt, sq.casrn, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm from sq inner join gene_go_annot gga on sq.gene_id = gga.gene_id inner join dag_node gt on gga.go_term_id = gt.object_id inner join dag d on gt.dag_id = d.id where gga.is_not = false and (d.id = ? or d.id = ?) order by sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 26 05 2 11s245ms 5s622ms Jul 27 05 2 11s142ms 5s571ms Jul 28 05 2 11s27ms 5s513ms Jul 29 05 2 11s51ms 5s525ms [ User: qaeu - Total duration: 22s793ms - Times executed: 4 ]
[ User: pubeu - Total duration: 21s673ms - Times executed: 4 ]
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1400764)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-07-26 05:43:38 Duration: 5s835ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1400764)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-07-27 05:43:38 Duration: 5s709ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* BatchChemGODAO */ 'ddt' "Input", sqi.chem_nm "ChemicalName", sqi.chem_acc_txt "ChemicalID", sqi.casRN "CasRN", sqi.gene_symbol "GeneSymbol", sqi.gene_acc_txt "GeneID", sqi.ontology_nm "Ontology", sqi.go_term_nm "GoTermName", sqi.go_acc_txt "GoTermID" FROM ( WITH sq AS ( SELECT DISTINCT c.id chem_id, c.nm chem_nm, c.acc_txt chem_acc_txt, c.secondary_nm casRN, c.nm_sort chem_nm_sort, gcr.gene_id, g.nm gene_symbol, g.acc_txt gene_acc_txt, g.nm_sort gene_symbol_sort FROM term c INNER JOIN gene_chem_reference gcr ON c.id = gcr.chem_id INNER JOIN term g ON gcr.gene_id = g.id WHERE (c.id = 1400764)) SELECT DISTINCT sq.chem_nm, sq.chem_acc_txt, sq.casRN, sq.gene_symbol, sq.gene_acc_txt, gt.nm go_term_nm, gt.acc_txt go_acc_txt, sq.chem_nm_sort, sq.gene_symbol_sort, gt.nm_sort, d.nm ontology_nm FROM sq INNER JOIN gene_go_annot gga ON sq.gene_id = gga.gene_id INNER JOIN dag_node gt ON gga.go_term_id = gt.object_id INNER JOIN dag d ON gt.dag_id = d.id WHERE gga.is_not = false AND (d.id = 5 OR d.id = 4) ORDER BY sq.chem_nm_sort, sq.gene_symbol_sort, d.nm, gt.nm_sort) sqi;
Date: 2026-07-28 05:43:47 Duration: 5s663ms Database: ctdprd51 User: qaeu Bind query: yes
14 6 3m27s 8s26ms 1m55s 34s581ms select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where d.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 21 6 3m27s 34s581ms [ User: pubeu - Total duration: 2m31s - Times executed: 4 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'drug-induced liver injury' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2190672) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:12:50 Duration: 1m55s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'cardiomyopathy' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2195718) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:07:29 Duration: 29s599ms Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'arrhythmia' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2191919) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:06:29 Duration: 26s272ms Bind query: yes
15 6 1m29s 14s434ms 15s870ms 14s917ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 28 00 1 14s455ms 14s455ms 01 5 1m15s 15s9ms [ User: pubeu - Total duration: 1m29s - Times executed: 6 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2201844') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-28 01:12:31 Duration: 15s870ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2201844') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-28 01:00:23 Duration: 14s965ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2201844') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-07-28 01:10:33 Duration: 14s955ms Database: ctdprd51 User: pubeu Bind query: yes
16 6 1m16s 5s34ms 26s811ms 12s822ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ? offset ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 00 3 18s428ms 6s142ms 11 1 26s662ms 26s662ms 12 1 26s811ms 26s811ms Jul 28 01 1 5s34ms 5s34ms [ User: pubeu - Total duration: 37s433ms - Times executed: 3 ]
[ User: qaeu - Total duration: 26s811ms - Times executed: 1 ]
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2194916') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 4612950;
Date: 2026-07-27 12:00:43 Duration: 26s811ms Database: ctdprd51 User: qaeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2194916') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 4612950;
Date: 2026-07-27 11:59:47 Duration: 26s662ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* DiseaseGeneAssnsDAO */ d.nm diseaseNm, d.acc_txt diseaseAcc, d.acc_db_cd diseaseAccDbCd, d.id diseaseId, g.nm geneSymbol, g.acc_txt geneAcc, g.acc_db_cd geneAccDbCd, g.id geneId, gd.network_score networkScore, gd.indirect_chem_qty inferredCount, gd.reference_qty referenceCount, gd.exposure_reference_qty exposureReferenceCount, CASE WHEN gd.curated_reference_qty > 0 THEN ( SELECT STRING_AGG(a.action_type_cd || '^' || a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gd.gene_id AND a.disease_id = gd.disease_id) ELSE NULL END actionTypes FROM gene_disease gd INNER JOIN term g ON gd.gene_id = g.id INNER JOIN term d ON gd.disease_id = d.id WHERE gd.disease_id IN ( SELECT p.descendant_object_id FROM dag_path p WHERE p.ancestor_object_id = '2201053') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50 OFFSET 50;
Date: 2026-07-27 00:09:27 Duration: 6s916ms Bind query: yes
17 5 47m22s 9m21s 9m46s 9m28s select maint_query_logs_archive ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 26 00 1 9m24s 9m24s Jul 27 00 1 9m25s 9m25s Jul 28 00 1 9m24s 9m24s Jul 29 00 1 9m21s 9m21s Jul 30 00 1 9m46s 9m46s [ User: pubc - Total duration: 47m22s - Times executed: 5 ]
[ Application: psql - Total duration: 47m22s - Times executed: 5 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-30 00:09:48 Duration: 9m46s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-27 00:09:27 Duration: 9m25s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-28 00:09:26 Duration: 9m24s Database: ctdprd51 User: pubc Application: psql
18 5 13m55s 46s252ms 10m46s 2m47s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub1.gene_chem_reference gcr, pub1.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 29 17 2 11m33s 5m46s 18 3 2m21s 47s188ms [ User: load - Total duration: 10m46s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 17:39:08 Duration: 10m46s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:08:41 Duration: 48s115ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:03:08 Duration: 47s197ms Bind query: yes
19 5 34s917ms 6s525ms 7s341ms 6s983ms vacuum analyze log_query_archive;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 26 00 1 6s785ms 6s785ms Jul 27 00 1 7s202ms 7s202ms Jul 28 00 1 6s525ms 6s525ms Jul 29 00 1 7s341ms 7s341ms Jul 30 00 1 7s62ms 7s62ms -
VACUUM ANALYZE log_query_archive;
Date: 2026-07-29 00:09:30 Duration: 7s341ms
-
VACUUM ANALYZE log_query_archive;
Date: 2026-07-27 00:09:35 Duration: 7s202ms
-
VACUUM ANALYZE log_query_archive;
Date: 2026-07-30 00:09:55 Duration: 7s62ms
20 5 26s893ms 5s46ms 5s933ms 5s378ms 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 #20
Day Hour Count Duration Avg duration Jul 27 03 1 5s417ms 5s417ms 08 1 5s375ms 5s375ms Jul 29 09 1 5s121ms 5s121ms 21 1 5s46ms 5s46ms Jul 30 03 1 5s933ms 5s933ms [ User: pubeu - Total duration: 26s893ms - Times executed: 5 ]
-
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 = '1466757' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-30 03:00:23 Duration: 5s933ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1475975' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-27 03:33:58 Duration: 5s417ms Database: ctdprd51 User: pubeu Bind query: yes
-
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 = '1428078' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-07-27 08:41:34 Duration: 5s375ms Database: ctdprd51 User: pubeu Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 1h57m12s 1h57m12s 1h57m12s 1 1h57m12s select pub1.maint_gene_chem_ref_gene_form_refresh ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 30 02 1 1h57m12s 1h57m12s -
select pub1.maint_gene_chem_ref_gene_form_refresh ();
Date: 2026-07-30 02:44:16 Duration: 1h57m12s Bind query: yes
2 50m34s 50m34s 50m34s 1 50m34s select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.object_type where cd = ?), ptr.term_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.phenotype_term_reference ptr, pub1.phenotype_term_reference ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 19 1 50m34s 50m34s -
select distinct ptr.phenotype_id, gcr.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ptr.term_id, ( select id from pub1.OBJECT_TYPE where cd = 'chem'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.PHENOTYPE_TERM_REFERENCE ptr, pub1.PHENOTYPE_TERM_REFERENCE ptr2 where gcr.chem_id = ptr.term_id and ptr.phenotype_id = ptr2.phenotype_id and gcr.gene_id = ptr2.term_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 19:13:14 Duration: 50m34s Bind query: yes
3 36m12s 36m12s 36m12s 1 36m12s select i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) from edit.ixn i, edit.reference_ixn r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in (...) order by i.id asc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 17 1 36m12s 36m12s [ User: load - Total duration: 36m12s - Times executed: 1 ]
-
SELECT i.id, edit.get_ixn_xml (i.id), edit.get_ixn_prose (i.id), edit.get_ixn_delimited_actions (i.id), i.ixn_type_id, r.reference_acc_txt, r.taxon_acc_txt, r.create_by, common.break_html_words (edit.get_ixn_prose_html (i.id), false) FROM edit.IXN i, edit.REFERENCE_IXN r where i.id = i.root_id and i.id = r.ixn_id and r.create_by not in ('bogusName') order by i.id asc;
Date: 2026-07-29 17:25:27 Duration: 36m12s Database: ctdprd51 User: load Bind query: yes
4 33m14s 33m14s 33m14s 1 33m14s update pub1.gene_disease gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.gene_disease_reference gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.reference r where has_exposures = true));Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 30 00 1 33m14s 33m14s -
update pub1.GENE_DISEASE gd set exposure_reference_qty = ( select count(distinct reference_id) from pub1.GENE_DISEASE_REFERENCE gdr where gd.gene_id = gdr.gene_id and gd.disease_id = gdr.disease_id and reference_id in ( select id from pub1.REFERENCE r where has_exposures = true));
Date: 2026-07-30 00:40:47 Duration: 33m14s Bind query: yes
5 30m48s 30m48s 30m48s 1 30m48s insert into pub1.gene_go_annot (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.gene_go_annot;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 29 16 1 30m48s 30m48s -
insert into pub1.GENE_GO_ANNOT (gene_id, go_term_id, taxon_id, evidence_cd, is_not) select gene_id, go_term_id, taxon_id, evidence_cd, is_not from load.GENE_GO_ANNOT;
Date: 2026-07-29 16:39:31 Duration: 30m48s Bind query: yes
6 17m22s 17m22s 17m22s 1 17m22s insert into pub1.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.db_link;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 29 16 1 17m22s 17m22s [ User: pub1 - Total duration: 17m22s - Times executed: 1 ]
-
insert into pub1.DB_LINK (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary) select object_id, object_type_id, acc_txt, db_id, type_cd, is_primary from edit.DB_LINK;
Date: 2026-07-29 16:02:11 Duration: 17m22s Database: ctdprd51 User: pub1 Bind query: yes
7 13m17s 13m17s 13m17s 1 13m17s alter table pub1.term_enrichment_agent add constraint term_enr_agent_term_enr_fk foreign key (term_id, enriched_term_id) references term_enrichment (term_id, enriched_term_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 29 23 1 13m17s 13m17s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enr_agent_term_enr_fk FOREIGN KEY (term_id, enriched_term_id) REFERENCES term_enrichment (term_id, enriched_term_id);
Date: 2026-07-29 23:26:44 Duration: 13m17s Bind query: yes
8 9m21s 9m46s 9m28s 5 47m22s select maint_query_logs_archive ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 26 00 1 9m24s 9m24s Jul 27 00 1 9m25s 9m25s Jul 28 00 1 9m24s 9m24s Jul 29 00 1 9m21s 9m21s Jul 30 00 1 9m46s 9m46s [ User: pubc - Total duration: 47m22s - Times executed: 5 ]
[ Application: psql - Total duration: 47m22s - Times executed: 5 ]
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-30 00:09:48 Duration: 9m46s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-27 00:09:27 Duration: 9m25s Database: ctdprd51 User: pubc Application: psql
-
/* * Run daily to prune LOG_QUERY, archive old queries to LOG_QUERY_ARCHIVE * and vacuum/analyze the tables. * * $Id: archive_query_logs.sql 10832 2012-03-19 15:27:11Z mcr $ */ SELECT maint_query_logs_archive ();
Date: 2026-07-28 00:09:26 Duration: 9m24s Database: ctdprd51 User: pubc Application: psql
9 16s498ms 1h8m36s 6m48s 12 1h21m41s select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.object_type where cd = ?), ( select current_date) from pub1.gene_chem_reference gcr, pub1.gene_go_annot gga, pub1.phenotype_term_reference ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 29 20 12 1h21m41s 6m48s -
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:21:55 Duration: 1h8m36s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:34:13 Duration: 6m47s Bind query: yes
-
select distinct gga.go_term_id, gcr.chem_id, ptr.term_object_type_id, gga.gene_id, ( select id from pub1.OBJECT_TYPE where cd = 'gene'), ( select current_date) from pub1.GENE_CHEM_REFERENCE gcr, pub1.GENE_GO_ANNOT gga, pub1.PHENOTYPE_TERM_REFERENCE ptr where gcr.gene_id = gga.gene_id and gcr.chem_id = ptr.term_id and gga.go_term_id = ptr.phenotype_id and gcr.id not in ( select gene_chem_reference_id from pub1.GENE_CHEM_REFERENCE_AXN where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 20:24:47 Duration: 1m27s Bind query: yes
10 5m21s 5m21s 5m21s 1 5m21s insert into pub1.gene_taxon (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.gene_taxon;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 29 16 1 5m21s 5m21s -
insert into pub1.GENE_TAXON (gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd) select gene_id, taxon_id, gene_acc_txt, gene_acc_db_cd from load.GENE_TAXON;
Date: 2026-07-29 16:44:53 Duration: 5m21s Bind query: yes
11 4m33s 4m33s 4m33s 1 4m33s create unique index gene_disease_reference_ak1 on pub1.gene_disease_reference using btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 29 20 1 4m33s 4m33s -
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 4m33s Bind query: yes
-
CREATE UNIQUE INDEX gene_disease_reference_ak1 ON pub1.gene_disease_reference USING btree (gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id);
Date: 2026-07-29 20:54:33 Duration: 0ms Database: ctdprd51 User: pub1
12 4m18s 4m18s 4m18s 1 4m18s insert into pub1.term_label (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.term t, load.term_label l where t.id = l.term_id and t.id in ( select id from pub1.term);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 29 16 1 4m18s 4m18s -
INSERT INTO pub1.TERM_LABEL (id, object_type_id, term_id, term_label_type_id, nm) select l.id, t.object_type_id, l.term_id, l.term_label_type_id, l.nm from load.TERM t, load.TERM_LABEL l where t.id = l.term_id and t.id in ( select id from pub1.TERM);
Date: 2026-07-29 16:08:42 Duration: 4m18s Bind query: yes
13 3m22s 3m22s 3m22s 1 3m22s alter table pub1.term_enrichment_agent add constraint term_enrichment_agent_pk primary key (term_id, enriched_term_id, agent_term_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 29 23 1 3m22s 3m22s -
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:06 Duration: 3m22s Bind query: yes
-
ALTER TABLE pub1.term_enrichment_agent ADD CONSTRAINT term_enrichment_agent_pk PRIMARY KEY (term_id, enriched_term_id, agent_term_id);
Date: 2026-07-29 23:30:05 Duration: 0ms
14 46s252ms 10m46s 2m47s 5 13m55s select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, to_char(cdr.mod_tm, ?) from pub1.gene_chem_reference gcr, pub1.chem_disease_reference cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = ? and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 29 17 2 11m33s 5m46s 18 3 2m21s 47s188ms [ User: load - Total duration: 10m46s - Times executed: 1 ]
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 17:39:08 Duration: 10m46s Database: ctdprd51 User: load Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:08:41 Duration: 48s115ms Bind query: yes
-
select distinct gcr.gene_id, cdr.disease_id, cdr.reference_id, cdr.chem_id as via_chem_id, cdr.ixn_id, TO_CHAR(cdr.mod_tm, 'YYYY-MM-DD') from pub1.GENE_CHEM_REFERENCE gcr, pub1.CHEM_DISEASE_REFERENCE cdr where gcr.chem_id = cdr.chem_id and cdr.source_cd = 'C' and gcr.id not in ( select gene_chem_reference_id from pub1.gene_chem_reference_axn where action_degree_type_nm = 'does not affect');
Date: 2026-07-29 18:03:08 Duration: 47s197ms Bind query: yes
15 1m52s 1m55s 1m53s 12 22m39s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 06 1 1m53s 1m53s 10 1 1m53s 1m53s 14 1 1m53s 1m53s 18 1 1m53s 1m53s Jul 28 06 1 1m52s 1m52s 10 1 1m52s 1m52s 14 1 1m53s 1m53s 18 1 1m52s 1m52s Jul 29 06 1 1m52s 1m52s 10 1 1m53s 1m53s 14 1 1m52s 1m52s 18 1 1m55s 1m55s [ User: postgres - Total duration: 22m39s - Times executed: 12 ]
[ Application: pg_dump - Total duration: 22m39s - Times executed: 12 ]
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:06:56 Duration: 1m55s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 10:06:55 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
-
COPY pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:06:56 Duration: 1m53s Database: ctdprd51 User: postgres Application: pg_dump
16 5s96ms 7m45s 58s825ms 64 1h2m44s select * from pgbulkload.pg_bulkload (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 29 11 10 1m25s 8s540ms 12 32 35m37s 1m6s 17 3 1m10s 23s408ms 20 3 9m11s 3m3s 21 4 7m23s 1m50s 22 8 4m13s 31s706ms 23 3 3m21s 1m7s Jul 30 00 1 20s931ms 20s931ms [ User: load - Total duration: 15m28s - Times executed: 16 ]
[ Application: pg_bulkload - Total duration: 15m28s - Times executed: 16 ]
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.GENE_DISEASE_REFERENCE,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.log,parse-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/indirectAssociation/geneDiseaseRef.txt.DUPE}');
Date: 2026-07-29 20:48:34 Duration: 7m45s Database: ctdprd51 User: load Application: pg_bulkload Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=edit.DB_LINK,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.log,parse-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/voc/gene/output/dbLink.txt.DUPE}');
Date: 2026-07-29 12:08:43 Duration: 5m31s Bind query: yes
-
SELECT * FROM pgbulkload.pg_bulkload ('{TABLE=pub1.DAG_PATH,TYPE=CSV,DELIMITER=|,"ESCAPE=\\",PARSE_ERRORS=0,DUPLICATE_ERRORS=0,OFFSET=1,VERBOSE=true,infile=stdin,logfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.log,parse-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.BAD,duplicate-badfile=/home/load/ctdLoadData/pub/dag/dagPath.txt.DUPE}');
Date: 2026-07-29 21:26:08 Duration: 5m28s Bind query: yes
17 8s26ms 1m55s 34s581ms 6 3m27s select ? "Input", d.nm "DiseaseName", d.acc_db_cd || ? || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( select string_agg(stm.slim_term_nm, ? order by stm.slim_term_nm) from slim_term_mapping stm where stm.mapped_term_id = d.id) "DiseaseCategories", case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", string_agg(gdr.source_acc_txt, ? order by gdr.source_acc_txt) "OmimIDs", string_agg(distinct r.acc_txt, ?) "PubMedIDs" from gene_disease_reference gdr inner join term g on gdr.gene_id = g.id inner join term d on gdr.disease_id = d.id left outer join reference r on gdr.reference_id = r.id left outer join term c on gdr.via_chem_id = c.id where d.id in ( select distinct dp.descendant_object_id from dag_path dp where dp.ancestor_object_id = ?) group by g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, case when gdr.via_chem_id is null then ( select string_agg(a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gdr.gene_id and a.disease_id = gdr.disease_id) else null end, c.nm, gdr.network_score order by d.nm_sort, g.nm, "DirectEvidence", c.nm;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 21 6 3m27s 34s581ms [ User: pubeu - Total duration: 2m31s - Times executed: 4 ]
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'drug-induced liver injury' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2190672) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:12:50 Duration: 1m55s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'cardiomyopathy' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2195718) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:07:29 Duration: 29s599ms Bind query: yes
-
SELECT /* BatchDiseaseGeneAssnsDAO */ 'arrhythmia' "Input", d.nm "DiseaseName", d.acc_db_cd || ':' || d.acc_txt "DiseaseID", g.nm "GeneSymbol", g.acc_txt "GeneID", ( SELECT STRING_AGG(stm.slim_term_nm, '|' ORDER BY stm.slim_term_nm) FROM slim_term_mapping stm WHERE stm.mapped_term_id = d.id) "DiseaseCategories", CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END "DirectEvidence", c.nm "InferenceChemicalName", gdr.network_score "InferenceScore", STRING_AGG(gdr.source_acc_txt, '|' ORDER BY gdr.source_acc_txt) "OmimIDs", STRING_AGG(DISTINCT r.acc_txt, '|') "PubMedIDs" FROM gene_disease_reference gdr INNER JOIN term g ON gdr.gene_id = g.id INNER JOIN term d ON gdr.disease_id = d.id LEFT OUTER JOIN reference r ON gdr.reference_id = r.id LEFT OUTER JOIN term c ON gdr.via_chem_id = c.id WHERE d.id in ( select distinct dp.descendant_object_id from dag_path dp WHERE dp.ancestor_object_id = 2191919) GROUP BY g.nm, g.acc_txt, d.nm, d.id, d.acc_txt, d.acc_db_cd, d.nm_sort, CASE WHEN gdr.via_chem_id IS NULL THEN ( SELECT STRING_AGG(a.action_type_nm, '|') FROM gene_disease_axn a WHERE a.gene_id = gdr.gene_id AND a.disease_id = gdr.disease_id) ELSE NULL END, c.nm, gdr.network_score ORDER BY d.nm_sort, g.nm, "DirectEvidence", c.nm;
Date: 2026-07-27 21:06:29 Duration: 26s272ms Bind query: yes
18 24s94ms 24s483ms 24s273ms 12 4m51s copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 06 1 24s483ms 24s483ms 10 1 24s235ms 24s235ms 14 1 24s330ms 24s330ms 18 1 24s327ms 24s327ms Jul 28 06 1 24s141ms 24s141ms 10 1 24s407ms 24s407ms 14 1 24s168ms 24s168ms 18 1 24s116ms 24s116ms Jul 29 06 1 24s284ms 24s284ms 10 1 24s94ms 24s94ms 14 1 24s240ms 24s240ms 18 1 24s457ms 24s457ms -
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-27 06:07:20 Duration: 24s483ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-29 18:07:20 Duration: 24s457ms
-
COPY pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) TO stdout;
Date: 2026-07-28 10:07:18 Duration: 24s407ms
19 19s899ms 20s346ms 20s73ms 12 4m copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 06 1 20s42ms 20s42ms 10 1 19s980ms 19s980ms 14 1 19s913ms 19s913ms 18 1 19s899ms 19s899ms Jul 28 06 1 19s915ms 19s915ms 10 1 20s67ms 20s67ms 14 1 20s201ms 20s201ms 18 1 20s133ms 20s133ms Jul 29 06 1 19s977ms 19s977ms 10 1 20s180ms 20s180ms 14 1 20s225ms 20s225ms 18 1 20s346ms 20s346ms [ User: postgres - Total duration: 4m - Times executed: 12 ]
[ Application: pg_dump - Total duration: 4m - Times executed: 12 ]
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 18:00:21 Duration: 20s346ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-29 14:00:22 Duration: 20s225ms Database: ctdprd51 User: postgres Application: pg_dump
-
COPY edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) TO stdout;
Date: 2026-07-28 14:00:22 Duration: 20s201ms Database: ctdprd51 User: postgres Application: pg_dump
20 15s397ms 15s796ms 15s520ms 12 3m6s copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 06 1 15s602ms 15s602ms 10 1 15s558ms 15s558ms 14 1 15s397ms 15s397ms 18 1 15s490ms 15s490ms Jul 28 06 1 15s451ms 15s451ms 10 1 15s532ms 15s532ms 14 1 15s411ms 15s411ms 18 1 15s486ms 15s486ms Jul 29 06 1 15s560ms 15s560ms 10 1 15s498ms 15s498ms 14 1 15s463ms 15s463ms 18 1 15s796ms 15s796ms -
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-29 18:07:36 Duration: 15s796ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-27 06:07:36 Duration: 15s602ms
-
COPY pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) TO stdout;
Date: 2026-07-29 06:07:34 Duration: 15s560ms
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
- 39,092 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1 FATAL entries
- 17 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 21 Total events found
Rank Times reported Error 1 5 ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 27 11 5 - ERROR: column "log_query.results_qty" must appear in the GROUP BY clause or be used in an aggregate function at character 21
- ERROR: column "log_query.execution_ms" must appear in the GROUP BY clause or be used in an aggregate function at character 34
- ERROR: column "log_query.execution_ms" must appear in the GROUP BY clause or be used in an aggregate function at character 34
Statement: select remote_addr, results_qty, execution_ms, type_cd,basic_query_txt from log_query where query_tm >= '20260723' and http_user_agent not like '%CTD%' group by remote_addr order by results_qty desc, query_tm desc
Date: 2026-07-27 11:02:04
Statement: select remote_addr, results_qty, execution_ms, type_cd,basic_query_txt from log_query where query_tm >= '20260723' and http_user_agent not like '%CTD%' group by remote_addr, results_qty order by results_qty desc, query_tm desc
Date: 2026-07-27 11:02:42
Statement: select remote_addr, results_qty, execution_ms, type_cd,basic_query_txt from log_query where query_tm >= '20260723' and http_user_agent not like '%CTD%' group by remote_addr, results_qty, query_tm order by results_qty desc, query_tm desc
Date: 2026-07-27 11:03:02
2 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 27 11 1 Jul 29 10 1 15 1 - ERROR: syntax error at or near "group" at character 194
- ERROR: syntax error at or near ".159" at character 112
- ERROR: syntax error at or near "=" at character 10
Statement: select remote_addr, results_qty, execution_ms, type_cd,basic_query_txt from log_query where query_tm >= '20260723' and http_user_agent not like '%CTD%' order by results_qty desc, query_tm desc group by remote_addr --order by count(*) desc limit 100
Date: 2026-07-27 11:01:26 Database: ctdprd51 Application: pgAdmin 4 - CONN:3040563 User: pubc Remote:
Statement: select count(*) from log_query_archive where results_qty =18901 and type_cd = 'ixn' and remote_addr in (103.172.159.94 ,114.143.215.162 ,165.99.8.22 )
Date: 2026-07-29 10:38:18
Statement: select * =-- count(*) from exposure order by create_tm desc limit 100
Date: 2026-07-29 15:42:23
3 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 29 13 1 15 1 - ERROR: relation "ixn_actor" does not exist
- ERROR: relation "exi" does not exist at character 27
Statement: vacuum FULL analyze ixn_actor
Date: 2026-07-29 13:14:07
Statement: select * -- count(*) from exi order by create_tm desc limit 100
Date: 2026-07-29 15:42:42
4 2 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 26 10 1 Jul 27 02 1 - ERROR: invalid byte sequence for encoding "UTF8": 0x00
Context: unnamed portal parameter $1
Statement: SELECT /* ObjectIdDAOImpl.LabelsAndAccs */ t.id ,t.nm ,t.nm_sort nmSort ,t.acc_txt acc ,t.acc_db_cd accDbCd FROM term t ,(SELECT li.term_id FROM term_label li WHERE UPPER(li.nm) = $1 AND li.object_type_id = 2 UNION SELECT l.object_id FROM db_link l WHERE upper( l.acc_txt ) = $2 AND l.object_type_id = 2 AND l.type_cd = 'A') ids WHERE t.id = ids.term_id ORDER BY CASE WHEN UPPER(t.nm) = $3 THEN 1 ELSE 2 END ,t.nm_sortDate: 2026-07-26 10:16:50 Database: ctdprd51 Application: User: pubeu Remote:
5 2 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 26 16 2 6 1 ERROR: syntax error at end of input
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 29 10 1 - ERROR: syntax error at end of input at character 190
Statement: select count(*) from log_query --where results_qty =18901 and type_cd = 'ixn' --and remote_addr in ('103.172.159.94' where remote_addr in ('103.172.159.94' ,'114.143.215.162' ,'165.99.8.22'
Date: 2026-07-29 10:41:15
7 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 29 23 1 - ERROR: canceling statement due to user request
Statement: SELECT pg_database_size(datname::text) FROM pg_catalog.pg_database WHERE datistemplate = false AND datname = $1;
Date: 2026-07-29 23:29:06
8 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 29 23 1 9 1 ERROR: function get_ixn_prose(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 29 11 1 - ERROR: function get_ixn_prose(integer) does not exist at character 66
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select reference_acc_txt ,taxon_acc_txt ,pubTerm.nm ,get_ixn_prose( ixn_id ) ,create_by ,create_tm from edit.reference_ixn ri ,pub2.term pubTerm -- set to CURRENT PRODUCTION PUB!!!!! where taxon_acc_txt not in ( select acc_txt from load.term where object_type_id = ( select id from edit.object_type where cd = 'taxon' ) ) and pubTerm.acc_txt = ri.taxon_acc_txt and object_type_id = ( select id from edit.object_type where cd = 'taxon' ) and taxon_acc_txt is not null and taxon_acc_txt <> ''Date: 2026-07-29 11:35:32
10 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 29 23 1 11 1 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 29 09 1 - ERROR: unterminated quoted identifier at or near "" " at character 402
Statement: -- This provides discrepancies introduced this month - it is NOT aggregate select nm as Underlying_Term_Name ,acc_txt as Underlying_Term_Accession ,synonym ,reference_acc_txt ,notes ,create_by ,create_tm from edit.term_label where ( acc_txt, object_type_id ) not in ( -- Current Month's PUB select acc_txt, object_type_id from pub2.term ) order by acc_txt "
Date: 2026-07-29 09:34:13 Database: ctdprd51 Application: pgAdmin 4 - CONN:774039 User: load Remote:
12 1 ERROR: permission denied for table ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 29 12 1 - ERROR: permission denied for table term
Statement: begin transaction; update term set secondary_nm = '7461-02-1' where secondary_nm = '7461-02-1 (+-)-' and object_type_id = 2 and acc_txt = 'C014212'
Date: 2026-07-29 12:30:54