pgBadger-
Global information
- Generated on Sun Jan 18 04:15:04 2026
- Log file: /project/archive/log/postgres/dbprd51/postgresql.log-20260117
- Parsed 150,508 log entries in 3s
- Log start from 2026-01-11 00:00:01 to 2026-01-17 23:59:24
-
Overview
Global Stats
- 96 Number of unique normalized queries
- 728 Number of queries
- 14h41m19s Total query duration
- 2026-01-11 00:09:12 First query
- 2026-01-17 22:36:30 Last query
- 3 queries/s at 2026-01-13 06:06:31 Query peak
- 14h41m19s Total query duration
- 6s584ms Prepare/parse total duration
- 0ms Bind total duration
- 14h41m12s Execute total duration
- 128 Number of events
- 10 Number of unique normalized events
- 31 Max number of times the same event was reported
- 0 Number of cancellation
- 24 Total number of automatic vacuums
- 131 Total number of automatic analyzes
- 4 Number temporary file
- 1.93 MiB Max size of temporary file
- 1.22 MiB Average size of temporary file
- 18,261 Total number of sessions
- 99 sessions at 2026-01-13 13:18:42 Session peak
- 353d13h21m10s Total duration of sessions
- 27m52s Average duration of sessions
- 0 Average queries per session
- 2s895ms Average queries duration per session
- 27m49s Average idle time per session
- 18,261 Total number of connections
- 90 connections/s at 2026-01-12 04:12:57 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2026-01-13 06:06:31 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-01-13 06:06:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-01-16 10:01:12 Date
Queries duration
Key values
- 14h41m19s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 11 00 2 0ms 9m11s 4m38s 0ms 0ms 9m17s 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 5s232ms 5s227ms 0ms 0ms 5s232ms 06 1 0ms 5s947ms 5s947ms 0ms 0ms 5s947ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 32 0ms 26m3s 1m31s 1m25s 1m55s 26m3s 19 21 0ms 26m9s 2m10s 1m40s 7m58s 26m9s 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 Jan 12 00 2 0ms 9m11s 4m38s 0ms 0ms 9m17s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 1 0ms 5s213ms 5s213ms 0ms 0ms 5s213ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 2 0ms 5s212ms 5s162ms 0ms 0ms 5s212ms 06 9 0ms 1m50s 24s84ms 0ms 39s446ms 1m50s 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 9 0ms 1m50s 23s960ms 20s745ms 45s639ms 1m50s 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 9 0ms 1m50s 24s65ms 0ms 39s336ms 1m50s 15 1 0ms 6s56ms 6s56ms 0ms 0ms 6s56ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 4 0ms 6s431ms 5s471ms 0ms 0ms 11s563ms 18 41 0ms 26m11s 1m16s 1m51s 2m9s 26m11s 19 21 0ms 26m15s 2m10s 1m21s 2m11s 26m15s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 8 0ms 36s547ms 13s809ms 11s628ms 11s771ms 36s547ms 22 2 0ms 5s435ms 5s421ms 0ms 0ms 5s435ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 13 00 4 0ms 12m49s 5m34s 0ms 5s959ms 12m49s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 2 0ms 5s241ms 5s211ms 0ms 0ms 10s423ms 03 4 0ms 11s332ms 6s930ms 5s174ms 5s856ms 11s332ms 04 6 0ms 14m33s 7m10s 5s60ms 7s425ms 29m1s 05 4 0ms 5s192ms 5s149ms 0ms 5s156ms 10s247ms 06 15 0ms 2m7s 18s34ms 25s418ms 37s477ms 2m46s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 1 0ms 5s841ms 5s841ms 0ms 0ms 5s841ms 10 10 0ms 1m50s 22s179ms 5s323ms 39s158ms 1m50s 11 1 0ms 7s433ms 7s433ms 0ms 0ms 7s433ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 17 0ms 25s600ms 6s313ms 5s515ms 25s600ms 50s805ms 14 9 0ms 1m50s 24s170ms 20s904ms 45s907ms 1m50s 15 1 0ms 5s838ms 5s838ms 0ms 0ms 5s838ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 41 0ms 26m10s 1m16s 1m40s 1m54s 26m10s 19 22 0ms 26m12s 2m8s 1m47s 2m10s 26m12s 20 2 0ms 8s350ms 8s338ms 0ms 8s326ms 8s350ms 21 7 0ms 11s35ms 6s18ms 0ms 11s35ms 31s97ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 14 00 2 0ms 9m16s 4m42s 0ms 0ms 9m24s 01 1 0ms 9s520ms 9s520ms 0ms 0ms 9s520ms 02 1 0ms 8s265ms 8s265ms 0ms 0ms 8s265ms 03 2 0ms 5s631ms 5s547ms 0ms 0ms 11s94ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 9 0ms 8s618ms 6s377ms 5s268ms 15s81ms 15s814ms 06 14 0ms 1m50s 17s375ms 10s339ms 39s538ms 1m50s 07 1 0ms 5s42ms 5s42ms 0ms 0ms 5s42ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 10 0ms 1m50s 27s240ms 39s323ms 55s822ms 1m50s 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 9 0ms 1m50s 24s46ms 20s862ms 45s713ms 1m50s 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 41 0ms 26m9s 1m16s 1m40s 1m54s 26m9s 19 21 0ms 26m12s 2m11s 1m49s 7m49s 26m12s 20 2 0ms 5s824ms 5s567ms 0ms 5s309ms 5s824ms 21 2 0ms 5s738ms 5s689ms 0ms 0ms 11s378ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 15 00 3 0ms 9m14s 3m22s 0ms 47s128ms 9m21s 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 5 0ms 29s496ms 10s906ms 0ms 5s143ms 29s496ms 03 1 0ms 5s811ms 5s811ms 0ms 0ms 5s811ms 04 3 0ms 2m12s 1m1s 0ms 25s662ms 2m12s 05 5 0ms 25s720ms 11s754ms 5s113ms 15s859ms 25s720ms 06 9 0ms 1m51s 24s82ms 20s784ms 45s702ms 1m51s 07 6 0ms 9s133ms 7s231ms 0ms 16s209ms 18s45ms 08 1 0ms 8s105ms 8s105ms 0ms 0ms 8s105ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 10 0ms 1m51s 22s268ms 20s740ms 45s669ms 1m51s 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 9 0ms 1m50s 24s117ms 20s779ms 45s953ms 1m50s 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 41 0ms 26m5s 1m16s 1m39s 1m54s 26m5s 19 21 0ms 26m9s 2m11s 1m40s 7m52s 26m9s 20 1 0ms 5s912ms 5s912ms 0ms 0ms 5s912ms 21 3 0ms 5s866ms 5s548ms 0ms 0ms 16s645ms 22 1 0ms 8s338ms 8s338ms 0ms 0ms 8s338ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Jan 16 00 2 0ms 9m12s 4m39s 0ms 0ms 9m19s 01 1 0ms 5s882ms 5s882ms 0ms 0ms 5s882ms 02 6 0ms 38s746ms 22s647ms 5s964ms 36s34ms 38s746ms 03 3 0ms 14s412ms 8s792ms 0ms 6s42ms 20s334ms 04 1 0ms 5s859ms 5s859ms 0ms 0ms 5s859ms 05 2 0ms 5s204ms 5s198ms 0ms 5s192ms 5s204ms 06 9 0ms 1m50s 24s14ms 20s812ms 45s690ms 1m50s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 7 0ms 33s855ms 12s952ms 11s286ms 22s203ms 33s855ms 09 1 0ms 6s31ms 6s31ms 0ms 0ms 6s31ms 10 9 0ms 1m50s 24s72ms 20s805ms 45s651ms 1m50s 11 1 0ms 5s985ms 5s985ms 0ms 0ms 5s985ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 5 0ms 5s591ms 5s442ms 0ms 0ms 27s210ms 14 9 0ms 1m51s 24s131ms 20s816ms 45s845ms 1m51s 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 1 0ms 7s466ms 7s466ms 0ms 0ms 7s466ms 18 41 0ms 26m4s 1m16s 1m40s 1m55s 26m4s 19 21 0ms 26m10s 2m11s 1m25s 2m10s 26m10s 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 Jan 17 00 2 0ms 9m9s 4m38s 0ms 0ms 9m16s 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 5s183ms 5s170ms 0ms 5s157ms 5s183ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 5s30ms 5s30ms 0ms 0ms 5s30ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 2 0ms 7s220ms 6s957ms 0ms 6s695ms 7s220ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 30 0ms 26m19s 1m35s 1m29s 7m44s 26m19s 19 23 0ms 26m14s 2m2s 1m22s 2m29s 26m14s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 2 0ms 12s823ms 10s742ms 0ms 8s661ms 12s823ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 11 00 1 0 9m11s 0ms 0ms 9m11s 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 5s227ms 0ms 0ms 5s232ms 06 1 0 5s947ms 0ms 0ms 5s947ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 32 1m31s 1m2s 1m25s 26m3s 19 0 21 2m10s 56s603ms 1m40s 26m9s 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 Jan 12 00 1 0 9m11s 0ms 0ms 9m11s 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 5s213ms 0ms 0ms 5s213ms 04 0 0 0ms 0ms 0ms 0ms 05 2 0 5s162ms 0ms 0ms 5s212ms 06 0 9 24s84ms 0ms 0ms 1m50s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 9 23s960ms 0ms 20s745ms 1m50s 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 9 24s65ms 0ms 0ms 1m50s 15 1 0 6s56ms 0ms 0ms 6s56ms 16 0 0 0ms 0ms 0ms 0ms 17 4 0 5s471ms 0ms 0ms 11s563ms 18 0 41 1m16s 1m11s 1m51s 26m11s 19 0 21 2m10s 44s773ms 1m21s 26m15s 20 0 0 0ms 0ms 0ms 0ms 21 8 0 13s809ms 0ms 11s628ms 36s547ms 22 2 0 5s421ms 0ms 0ms 5s435ms 23 0 0 0ms 0ms 0ms 0ms Jan 13 00 3 0 7m23s 0ms 0ms 12m49s 01 0 0 0ms 0ms 0ms 0ms 02 2 0 5s211ms 0ms 0ms 10s423ms 03 4 0 6s930ms 0ms 5s174ms 11s332ms 04 6 0 7m10s 0ms 5s60ms 29m1s 05 4 0 5s149ms 0ms 0ms 10s247ms 06 6 9 18s34ms 0ms 25s418ms 2m46s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 1 0 5s841ms 0ms 0ms 5s841ms 10 1 9 22s179ms 0ms 5s323ms 1m50s 11 1 0 7s433ms 0ms 0ms 7s433ms 12 0 0 0ms 0ms 0ms 0ms 13 17 0 6s313ms 0ms 5s515ms 50s805ms 14 0 9 24s170ms 0ms 20s904ms 1m50s 15 1 0 5s838ms 0ms 0ms 5s838ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 41 1m16s 1m2s 1m40s 26m10s 19 1 21 2m8s 48s607ms 1m21s 26m12s 20 2 0 8s338ms 0ms 0ms 8s350ms 21 7 0 6s18ms 0ms 0ms 31s97ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Jan 14 00 1 0 9m16s 0ms 0ms 9m16s 01 1 0 9s520ms 0ms 0ms 9s520ms 02 1 0 8s265ms 0ms 0ms 8s265ms 03 2 0 5s547ms 0ms 0ms 11s94ms 04 0 0 0ms 0ms 0ms 0ms 05 9 0 6s377ms 0ms 5s268ms 15s814ms 06 5 9 17s375ms 0ms 10s339ms 1m50s 07 1 0 5s42ms 0ms 0ms 5s42ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 1 9 27s240ms 0ms 39s323ms 1m50s 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 9 24s46ms 0ms 20s862ms 1m50s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 41 1m16s 1m11s 1m40s 26m9s 19 0 21 2m11s 55s253ms 1m49s 26m12s 20 2 0 5s567ms 0ms 0ms 5s824ms 21 2 0 5s689ms 0ms 0ms 11s378ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Jan 15 00 2 0 5m 0ms 0ms 9m14s 01 0 0 0ms 0ms 0ms 0ms 02 5 0 10s906ms 0ms 0ms 29s496ms 03 1 0 5s811ms 0ms 0ms 5s811ms 04 3 0 1m1s 0ms 0ms 2m12s 05 5 0 11s754ms 0ms 5s113ms 25s720ms 06 0 9 24s82ms 0ms 20s784ms 1m51s 07 6 0 7s231ms 0ms 0ms 18s45ms 08 1 0 8s105ms 0ms 0ms 8s105ms 09 0 0 0ms 0ms 0ms 0ms 10 1 9 22s268ms 0ms 20s740ms 1m51s 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 9 24s117ms 0ms 20s779ms 1m50s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 41 1m16s 1m11s 1m39s 26m5s 19 0 21 2m11s 58s447ms 1m40s 26m9s 20 1 0 5s912ms 0ms 0ms 5s912ms 21 3 0 5s548ms 0ms 0ms 16s645ms 22 1 0 8s338ms 0ms 0ms 8s338ms 23 0 0 0ms 0ms 0ms 0ms Jan 16 00 1 0 9m12s 0ms 0ms 9m12s 01 1 0 5s882ms 0ms 0ms 5s882ms 02 6 0 22s647ms 0ms 5s964ms 38s746ms 03 3 0 8s792ms 0ms 0ms 20s334ms 04 1 0 5s859ms 0ms 0ms 5s859ms 05 2 0 5s198ms 0ms 0ms 5s204ms 06 0 9 24s14ms 0ms 20s812ms 1m50s 07 0 0 0ms 0ms 0ms 0ms 08 7 0 12s952ms 0ms 11s286ms 33s855ms 09 1 0 6s31ms 0ms 0ms 6s31ms 10 0 9 24s72ms 0ms 20s805ms 1m50s 11 1 0 5s985ms 0ms 0ms 5s985ms 12 0 0 0ms 0ms 0ms 0ms 13 5 0 5s442ms 0ms 0ms 27s210ms 14 0 9 24s131ms 0ms 20s816ms 1m51s 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 1 0 7s466ms 0ms 0ms 7s466ms 18 0 41 1m16s 1m11s 1m40s 26m4s 19 0 21 2m11s 56s639ms 1m25s 26m10s 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 Jan 17 00 1 0 9m9s 0ms 0ms 9m9s 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 5s170ms 0ms 0ms 5s183ms 06 0 0 0ms 0ms 0ms 0ms 07 1 0 5s30ms 0ms 0ms 5s30ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 2 0 6s957ms 0ms 0ms 7s220ms 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 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 30 1m35s 1m2s 1m29s 26m19s 19 0 23 2m2s 54s207ms 1m22s 26m14s 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 2 0 10s742ms 0ms 0ms 12s823ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 11 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 Jan 12 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 Jan 13 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 Jan 14 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 Jan 15 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 Jan 16 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 Jan 17 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 11 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 1 1.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 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Jan 12 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 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 3 3.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 8 8.00 0.00% 22 0 2 2.00 0.00% 23 0 0 0.00 0.00% Jan 13 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 2 2.00 0.00% 03 0 4 4.00 0.00% 04 0 5 5.00 0.00% 05 1 4 4.00 25.00% 06 0 6 6.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.00 0.00% 10 0 1 1.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 15 15.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.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 1 1.00 0.00% 20 0 2 2.00 0.00% 21 0 7 7.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Jan 14 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 1 1.00 0.00% 03 0 2 2.00 0.00% 04 0 0 0.00 0.00% 05 0 9 9.00 0.00% 06 0 5 5.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 1 1.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 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 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Jan 15 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 5 5.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 5 5.00 0.00% 06 0 0 0.00 0.00% 07 0 6 6.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 1 1.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 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 1 1.00 0.00% 21 0 3 3.00 0.00% 22 0 1 1.00 0.00% 23 0 0 0.00 0.00% Jan 16 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 6 6.00 0.00% 03 0 3 3.00 0.00% 04 0 1 1.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 7 7.00 0.00% 09 0 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 5 5.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 1 1.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% Jan 17 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 1 1.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 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 2 2.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jan 11 00 82 0.02/s 01 81 0.02/s 02 78 0.02/s 03 81 0.02/s 04 78 0.02/s 05 96 0.03/s 06 78 0.02/s 07 76 0.02/s 08 73 0.02/s 09 85 0.02/s 10 77 0.02/s 11 76 0.02/s 12 78 0.02/s 13 73 0.02/s 14 79 0.02/s 15 79 0.02/s 16 79 0.02/s 17 74 0.02/s 18 83 0.02/s 19 80 0.02/s 20 79 0.02/s 21 75 0.02/s 22 77 0.02/s 23 80 0.02/s Jan 12 00 81 0.02/s 01 84 0.02/s 02 79 0.02/s 03 97 0.03/s 04 1,722 0.48/s 05 285 0.08/s 06 85 0.02/s 07 76 0.02/s 08 77 0.02/s 09 82 0.02/s 10 78 0.02/s 11 78 0.02/s 12 72 0.02/s 13 77 0.02/s 14 90 0.03/s 15 85 0.02/s 16 79 0.02/s 17 360 0.10/s 18 82 0.02/s 19 79 0.02/s 20 76 0.02/s 21 80 0.02/s 22 83 0.02/s 23 79 0.02/s Jan 13 00 86 0.02/s 01 80 0.02/s 02 120 0.03/s 03 99 0.03/s 04 315 0.09/s 05 629 0.17/s 06 180 0.05/s 07 75 0.02/s 08 110 0.03/s 09 77 0.02/s 10 86 0.02/s 11 76 0.02/s 12 76 0.02/s 13 360 0.10/s 14 78 0.02/s 15 76 0.02/s 16 78 0.02/s 17 80 0.02/s 18 84 0.02/s 19 75 0.02/s 20 73 0.02/s 21 78 0.02/s 22 81 0.02/s 23 79 0.02/s Jan 14 00 93 0.03/s 01 78 0.02/s 02 101 0.03/s 03 80 0.02/s 04 86 0.02/s 05 94 0.03/s 06 78 0.02/s 07 78 0.02/s 08 77 0.02/s 09 149 0.04/s 10 79 0.02/s 11 75 0.02/s 12 79 0.02/s 13 78 0.02/s 14 79 0.02/s 15 78 0.02/s 16 73 0.02/s 17 76 0.02/s 18 85 0.02/s 19 77 0.02/s 20 73 0.02/s 21 75 0.02/s 22 79 0.02/s 23 87 0.02/s Jan 15 00 82 0.02/s 01 81 0.02/s 02 310 0.09/s 03 77 0.02/s 04 85 0.02/s 05 90 0.03/s 06 81 0.02/s 07 88 0.02/s 08 81 0.02/s 09 79 0.02/s 10 80 0.02/s 11 77 0.02/s 12 77 0.02/s 13 79 0.02/s 14 80 0.02/s 15 78 0.02/s 16 76 0.02/s 17 78 0.02/s 18 84 0.02/s 19 73 0.02/s 20 81 0.02/s 21 75 0.02/s 22 79 0.02/s 23 74 0.02/s Jan 16 00 82 0.02/s 01 84 0.02/s 02 100 0.03/s 03 81 0.02/s 04 80 0.02/s 05 92 0.03/s 06 79 0.02/s 07 73 0.02/s 08 90 0.03/s 09 107 0.03/s 10 81 0.02/s 11 83 0.02/s 12 78 0.02/s 13 78 0.02/s 14 81 0.02/s 15 78 0.02/s 16 76 0.02/s 17 90 0.03/s 18 82 0.02/s 19 76 0.02/s 20 76 0.02/s 21 74 0.02/s 22 78 0.02/s 23 78 0.02/s Jan 17 00 129 0.04/s 01 1,108 0.31/s 02 77 0.02/s 03 80 0.02/s 04 76 0.02/s 05 92 0.03/s 06 102 0.03/s 07 93 0.03/s 08 79 0.02/s 09 79 0.02/s 10 81 0.02/s 11 77 0.02/s 12 78 0.02/s 13 81 0.02/s 14 85 0.02/s 15 81 0.02/s 16 80 0.02/s 17 75 0.02/s 18 80 0.02/s 19 77 0.02/s 20 79 0.02/s 21 73 0.02/s 22 77 0.02/s 23 79 0.02/s Day Hour Count Average Duration Average idle time Jan 11 00 82 29m44s 29m37s 01 81 28m42s 28m42s 02 78 31m43s 31m43s 03 81 30m30s 30m30s 04 78 30m52s 30m52s 05 96 25m8s 25m8s 06 78 30m54s 30m54s 07 76 30m54s 30m54s 08 73 32m11s 32m11s 09 85 28m52s 28m52s 10 77 30m15s 30m15s 11 76 31m24s 31m24s 12 77 31m29s 31m29s 13 73 31m23s 31m23s 14 83 2h43m12s 2h43m12s 15 79 30m36s 30m36s 16 79 30m57s 30m57s 17 74 31m11s 31m11s 18 82 30m9s 29m34s 19 81 30m26s 29m52s 20 79 30m29s 30m29s 21 75 30m24s 30m24s 22 77 30m45s 30m45s 23 80 30m37s 30m37s Jan 12 00 81 29m47s 29m40s 01 84 29m52s 29m52s 02 79 29m30s 29m30s 03 97 25m54s 25m54s 04 1,722 1m30s 1m30s 05 285 8m22s 8m22s 06 85 28m50s 28m48s 07 76 30m28s 30m28s 08 77 30m58s 30m58s 09 82 29m25s 29m25s 10 78 30m44s 30m41s 11 78 30m37s 30m37s 12 72 31m6s 31m6s 13 77 31m45s 31m45s 14 90 27m9s 27m6s 15 85 27m58s 27m58s 16 79 29m36s 29m36s 17 360 3h35m12s 3h35m12s 18 81 29m28s 28m49s 19 80 31m5s 30m31s 20 76 31m6s 31m6s 21 80 28m42s 28m41s 22 83 29m12s 29m12s 23 79 30m34s 30m34s Jan 13 00 86 28m42s 28m27s 01 80 30m16s 30m16s 02 120 19m53s 19m53s 03 96 24m50s 24m49s 04 318 12m39s 12m31s 05 617 4m6s 4m6s 06 192 12m26s 12m25s 07 75 31m25s 31m25s 08 110 24m45s 24m45s 09 77 30m42s 30m42s 10 83 28m5s 28m3s 11 72 31m43s 31m43s 12 79 35m34s 35m34s 13 360 16m2s 16m2s 14 77 31m5s 31m2s 15 76 31m23s 31m23s 16 78 31m52s 31m52s 17 77 31m17s 31m17s 18 83 29m33s 28m56s 19 80 41m6s 40m30s 20 78 58m44s 58m44s 21 78 30m29s 30m29s 22 81 29m59s 29m59s 23 79 30m58s 30m58s Jan 14 00 93 25m44s 25m38s 01 78 30m43s 30m43s 02 101 24m44s 24m44s 03 80 29m29s 29m29s 04 86 28m32s 28m32s 05 94 26m13s 26m12s 06 78 30m31s 30m28s 07 78 30m52s 30m52s 08 77 31m17s 31m17s 09 147 36m4s 36m4s 10 74 30m50s 30m47s 11 75 32m 32m 12 79 31m53s 31m53s 13 78 31m15s 31m15s 14 79 30m38s 30m35s 15 78 31m15s 31m15s 16 73 31m58s 31m58s 17 76 31m55s 31m55s 18 87 45m44s 45m8s 19 78 31m31s 30m55s 20 73 30m40s 30m39s 21 75 30m8s 30m8s 22 79 31m18s 31m18s 23 87 27m53s 27m53s Jan 15 00 82 29m30s 29m23s 01 81 30m35s 30m35s 02 310 8m1s 8m1s 03 77 31m40s 31m40s 04 84 29m20s 29m17s 05 91 25m58s 25m57s 06 81 29m25s 29m23s 07 88 26m32s 26m31s 08 81 29m18s 29m18s 09 79 29m9s 29m9s 10 84 1h36m32s 1h36m30s 11 77 31m35s 31m35s 12 77 31m32s 31m32s 13 79 31m13s 31m13s 14 80 30m29s 30m26s 15 78 31m26s 31m26s 16 76 30m54s 30m54s 17 78 30m57s 30m57s 18 83 29m20s 28m42s 19 74 32m26s 31m49s 20 81 30m13s 30m13s 21 75 29m26s 29m25s 22 79 30m46s 30m46s 23 74 31m37s 31m37s Jan 16 00 82 29m59s 29m52s 01 84 29m22s 29m22s 02 100 25m 24m59s 03 81 29m26s 29m25s 04 80 29m18s 29m18s 05 92 26m40s 26m40s 06 79 29m35s 29m32s 07 73 31m47s 31m47s 08 90 25m45s 25m44s 09 107 22m10s 22m10s 10 81 31m8s 31m5s 11 79 30m31s 30m31s 12 78 31m14s 31m14s 13 78 31m9s 31m9s 14 81 30m56s 30m53s 15 78 31m14s 31m14s 16 76 31m20s 31m20s 17 90 26m53s 26m53s 18 81 29m28s 28m49s 19 77 31m35s 30m59s 20 76 30m57s 30m57s 21 74 30m32s 30m32s 22 78 30m52s 30m52s 23 78 31m14s 31m14s Jan 17 00 129 18m20s 18m16s 01 1,108 2m17s 2m17s 02 77 31m13s 31m13s 03 80 30m45s 30m45s 04 76 31m19s 31m19s 05 92 26m16s 26m15s 06 102 22m33s 22m33s 07 93 24m38s 24m38s 08 79 30m46s 30m46s 09 79 31m10s 31m10s 10 81 29m39s 29m39s 11 77 30m55s 30m55s 12 78 30m55s 30m55s 13 81 30m38s 30m38s 14 85 28m55s 28m55s 15 81 29m47s 29m47s 16 80 30m52s 30m52s 17 75 31m8s 31m8s 18 79 29m59s 29m23s 19 78 31m24s 30m48s 20 79 30m47s 30m47s 21 73 30m55s 30m55s 22 77 31m2s 31m1s 23 79 30m50s 30m50s -
Connections
Established Connections
Key values
- 90 connections Connection Peak
- 2026-01-12 04:12:57 Date
Connections per database
Key values
- ctdprd51 Main Database
- 18,261 connections Total
Connections per user
Key values
- pubeu Main User
- 18,261 connections Total
-
Sessions
Simultaneous sessions
Key values
- 99 sessions Session Peak
- 2026-01-13 13:18:42 Date
Histogram of session times
Key values
- 12,535 1800000-3600000ms duration
Sessions per database
Key values
- ctdprd51 Main Database
- 18,261 sessions Total
Sessions per user
Key values
- pubeu Main User
- 18,261 sessions Total
Sessions per host
Key values
- 10.12.5.53 Main Host
- 18,261 sessions Total
Host Count Total Duration Average Duration 10.12.5.45 2,668 55d23h50m45s 30m13s 10.12.5.46 2,632 56d1h18m1s 30m40s 10.12.5.53 7,610 56d10h29m6s 10m40s 10.12.5.54 2,623 55d23h9m10s 30m43s 10.12.5.55 2,603 55d23h21m46s 30m57s 10.12.5.56 1 6m42s 6m42s 192.168.201.10 12 2d6h29m16s 4h32m26s 192.168.201.14 15 12d16h49m58s 20h19m19s 192.168.201.6 5 2d7h34m17s 11h6m51s ::1 92 55d20h12m6s 14h34m2s Sessions per application
Key values
- unknown Main Application
- 18,261 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 132,709 buffers Checkpoint Peak
- 2026-01-14 12:49:25 Date
- 1619.970 seconds Highest write time
- 0.034 seconds Sync time
Checkpoints Wal files
Key values
- 3 files Wal files usage Peak
- 2026-01-16 04:32:20 Date
Checkpoints distance
Key values
- 2,340.16 Mo Distance Peak
- 2026-01-14 12:49:25 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 11 00 279 28.124s 0.003s 28.196s 01 90 9.191s 0.002s 9.224s 02 1,036 103.934s 0.002s 104.02s 03 119 12.101s 0.002s 12.133s 04 5,868 587.602s 0.001s 587.636s 05 14,745 1,476.091s 0.005s 1,476.25s 06 159 16.097s 0.002s 16.127s 07 1,738 174.241s 0.003s 174.321s 08 237 23.921s 0.002s 23.952s 09 476 47.754s 0.002s 47.785s 10 148 15.001s 0.002s 15.031s 11 184 18.606s 0.002s 18.636s 12 67 6.883s 0.002s 6.914s 13 23 2.478s 0.002s 2.508s 14 496 49.845s 0.002s 49.875s 15 24 2.571s 0.002s 2.599s 16 10 1.087s 0.001s 1.102s 17 32 3.372s 0.002s 3.402s 18 127 12.954s 0.002s 12.985s 19 393 39.541s 0.003s 39.572s 20 45 4.678s 0.002s 4.708s 21 165 16.708s 0.002s 16.738s 22 82 8.39s 0.002s 8.42s 23 63,078 1,622.866s 0.002s 1,623.059s Jan 12 00 402 40.448s 0.004s 40.526s 01 4,248 425.447s 0.003s 425.524s 02 263 26.53s 0.002s 26.561s 03 39,640 1,632.293s 0.003s 1,632.433s 04 4,143 415.182s 0.002s 415.261s 05 2,980 298.534s 0.003s 298.604s 06 1,583 158.721s 0.003s 158.794s 07 4,433 443.93s 0.002s 444.006s 08 74,881 1,970.332s 0.004s 1,970.501s 09 252 25.415s 0.002s 25.486s 10 38 3.982s 0.002s 4.012s 11 109 11.091s 0.002s 11.12s 12 125 12.719s 0.002s 12.748s 13 5,392 539.836s 0.002s 539.875s 14 545 54.76s 0.002s 54.791s 15 456 45.851s 0.002s 45.88s 16 209 21.113s 0.002s 21.143s 17 168 16.923s 0.001s 16.938s 18 27 2.846s 0.001s 2.862s 19 3,409 341.484s 0.003s 341.515s 20 884 88.705s 0.003s 88.736s 21 952 95.529s 0.002s 95.606s 22 106 10.811s 0.002s 10.84s 23 39 4.094s 0.002s 4.124s Jan 13 00 818 82.182s 0.003s 82.253s 01 2,227 223.148s 0.003s 223.23s 02 52,089 1,761.823s 0.003s 1,761.984s 03 78,961 1,649.987s 0.004s 1,650.163s 04 51,138 1,624.804s 0.003s 1,624.967s 05 213 22.221s 0.035s 22.629s 06 689 69.205s 0.002s 69.236s 07 82 8.401s 0.002s 8.431s 08 4,300 430.52s 0.003s 430.599s 09 86 8.797s 0.002s 8.827s 10 129 13.091s 0.002s 13.122s 11 138 13.977s 0.002s 14.078s 12 426 42.885s 0.003s 42.916s 13 65 6.704s 0.002s 6.734s 14 53 5.485s 0.002s 5.513s 15 93 9.501s 0.002s 9.532s 16 571 57.364s 0.003s 57.396s 17 72 7.402s 0.002s 7.434s 18 81 8.28s 0.002s 8.312s 19 1,634 163.82s 0.003s 163.851s 20 52 5.396s 0.002s 5.427s 21 4,207 421.388s 0.002s 421.469s 22 110 11.187s 0.002s 11.217s 23 64 6.585s 0.002s 6.614s Jan 14 00 421 42.275s 0.002s 42.332s 01 82,503 2,128.845s 0.003s 2,129.052s 02 4,229 423.33s 0.001s 423.485s 03 56,793 1,817.346s 0.003s 1,817.44s 04 185 18.721s 0.002s 18.751s 05 1,775 177.978s 0.002s 178.05s 06 544 54.661s 0.002s 54.692s 07 290 29.236s 0.002s 29.267s 08 296 29.85s 0.002s 29.882s 09 585 58.775s 0.002s 58.849s 10 165 16.702s 0.002s 16.732s 11 705 70.699s 0.003s 70.729s 12 132,726 1,621.204s 0.002s 1,621.486s 13 20 2.158s 0.002s 2.188s 14 95 9.689s 0.002s 9.72s 15 101 10.303s 0.002s 10.333s 16 209 21.13s 0.002s 21.16s 17 32 3.292s 0.002s 3.323s 18 34 3.597s 0.002s 3.628s 19 26 2.799s 0.002s 2.829s 20 128 12.995s 0.002s 13.025s 21 73 7.488s 0.002s 7.518s 22 5,356 536.459s 0.003s 536.508s 23 57 5.892s 0.002s 5.922s Jan 15 00 329 33.136s 0.002s 33.207s 01 162 16.409s 0.002s 16.438s 02 196 19.836s 0.002s 19.866s 03 1,201 120.506s 0.003s 120.536s 04 3,297 330.471s 0.003s 330.562s 05 216 21.733s 0.002s 21.762s 06 1,392 139.579s 0.003s 139.657s 07 8,422 843.318s 0.004s 843.402s 08 6,040 604.89s 0.002s 604.959s 09 17,401 1,742.535s 0.004s 1,742.7s 10 742 74.482s 0.003s 74.513s 11 61,132 1,622.855s 0.003s 1,623.026s 12 62 6.383s 0.002s 6.412s 13 27 2.876s 0.002s 2.906s 14 392 39.428s 0.003s 39.46s 15 412 41.431s 0.003s 41.46s 16 17 1.863s 0.002s 1.893s 17 1,714 171.828s 0.003s 171.906s 18 70 7.233s 0.002s 7.263s 19 4,353 436.036s 0.003s 436.068s 20 56 5.785s 0.002s 5.814s 21 167 16.903s 0.002s 16.934s 22 2,341 234.652s 0.004s 234.732s 23 121 12.291s 0.002s 12.323s Jan 16 00 302 30.353s 0.002s 30.409s 01 10,157 1,017.075s 0.003s 1,017.183s 02 157 15.826s 0.002s 15.915s 03 179 18.131s 0.002s 18.159s 04 6,447 645.761s 0.002s 645.872s 05 1,821 182.56s 0.002s 182.644s 06 90 9.19s 0.002s 9.22s 07 1,538 154.217s 0.002s 154.301s 08 871 87.213s 0.002s 87.244s 09 205 20.719s 0.002s 20.752s 10 171 17.307s 0.002s 17.337s 11 188 19.006s 0.002s 19.038s 12 319 32.134s 0.002s 32.208s 13 54 5.578s 0.002s 5.608s 14 60 6.181s 0.002s 6.211s 15 41 4.275s 0.002s 4.306s 16 66 6.785s 0.002s 6.816s 17 927 93.018s 0.003s 93.048s 18 27 2.87s 0.002s 2.903s 19 6 0.688s 0.001s 0.703s 20 6,350 635.984s 0.003s 636.028s 21 70 7.18s 0.002s 7.21s 22 36 3.776s 0.002s 3.806s 23 42 4.375s 0.002s 4.406s Jan 17 00 337 33.941s 0.003s 34.012s 01 124 12.603s 0.002s 12.635s 02 109 11.092s 0.002s 11.122s 03 119 12.099s 0.002s 12.132s 04 29 3.075s 0.002s 3.106s 05 115 11.704s 0.002s 11.736s 06 58 5.987s 0.002s 6.019s 07 175 17.707s 0.002s 17.738s 08 140 14.194s 0.002s 14.224s 09 40 4.082s 0.002s 4.113s 10 107 10.893s 0.002s 10.924s 11 20 2.173s 0.002s 2.204s 12 44 4.576s 0.002s 4.607s 13 18 1.972s 0.002s 2.003s 14 24 2.571s 0.002s 2.602s 15 38 3.981s 0.002s 4.013s 16 23 2.475s 0.002s 2.507s 17 27 2.867s 0.002s 2.899s 18 10 1.083s 0.001s 1.098s 19 114 11.587s 0.002s 11.617s 20 36 3.775s 0.002s 3.865s 21 87 8.888s 0.002s 8.919s 22 53 5.481s 0.002s 5.511s 23 25 2.667s 0.002s 2.697s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 11 00 0 0 0 55 0.001s 0.002s 01 0 0 0 24 0.001s 0.002s 02 0 1 0 35 0.001s 0.002s 03 0 0 0 29 0.001s 0.002s 04 0 4 0 27 0.001s 0.001s 05 0 7 0 66 0.001s 0.003s 06 0 0 0 65 0.001s 0.002s 07 0 1 0 128 0.001s 0.002s 08 0 0 0 98 0.001s 0.002s 09 0 0 0 118 0.001s 0.002s 10 0 0 0 31 0.001s 0.002s 11 0 0 0 63 0.001s 0.002s 12 0 0 0 50 0.001s 0.002s 13 0 0 0 15 0.001s 0.002s 14 0 0 0 23 0.001s 0.002s 15 0 0 0 16 0.001s 0.002s 16 0 0 0 8 0.001s 0.001s 17 0 0 0 16 0.001s 0.002s 18 0 0 0 30 0.001s 0.002s 19 0 0 0 23 0.001s 0.002s 20 0 0 0 19 0.001s 0.002s 21 0 0 0 28 0.001s 0.002s 22 0 0 0 18 0.001s 0.002s 23 0 37 0 40 0.001s 0.002s Jan 12 00 0 1 0 67 0.001s 0.002s 01 0 2 0 49 0.001s 0.002s 02 0 0 0 37 0.001s 0.002s 03 0 26 0 44 0.001s 0.002s 04 0 3 0 45 0.001s 0.002s 05 0 1 0 45 0.001s 0.002s 06 0 1 0 41 0.001s 0.002s 07 0 3 0 86 0.001s 0.002s 08 0 36 0 101 0.001s 0.002s 09 0 1 0 28 0.001s 0.002s 10 0 0 0 18 0.001s 0.002s 11 0 0 0 55 0.001s 0.002s 12 0 0 0 20 0.001s 0.002s 13 0 3 0 39 0.001s 0.002s 14 0 0 0 19 0.001s 0.002s 15 0 0 0 18 0.001s 0.002s 16 0 0 0 68 0.001s 0.002s 17 0 0 0 59 0.001s 0.001s 18 0 0 0 10 0.001s 0.001s 19 0 0 0 16 0.001s 0.002s 20 0 0 0 33 0.001s 0.002s 21 0 1 0 43 0.001s 0.002s 22 0 0 0 20 0.001s 0.002s 23 0 0 0 15 0.001s 0.002s Jan 13 00 0 0 0 64 0.001s 0.002s 01 0 4 0 39 0.001s 0.002s 02 0 32 0 53 0.001s 0.002s 03 0 37 0 57 0.001s 0.002s 04 0 34 0 38 0.001s 0.002s 05 0 0 0 38 0.023s 0.003s 06 0 0 0 56 0.001s 0.002s 07 0 0 0 19 0.001s 0.002s 08 0 3 0 38 0.001s 0.002s 09 0 0 0 21 0.001s 0.002s 10 0 0 0 27 0.001s 0.002s 11 0 1 0 50 0.001s 0.002s 12 0 0 0 47 0.001s 0.002s 13 0 0 0 20 0.001s 0.002s 14 0 0 0 24 0.001s 0.002s 15 0 0 0 26 0.001s 0.002s 16 0 0 0 149 0.001s 0.002s 17 0 0 0 52 0.001s 0.002s 18 0 0 0 24 0.001s 0.002s 19 0 0 0 53 0.001s 0.002s 20 0 0 0 23 0.001s 0.002s 21 0 3 0 28 0.001s 0.002s 22 0 0 0 24 0.001s 0.002s 23 0 0 0 16 0.001s 0.002s Jan 14 00 0 0 0 52 0.001s 0.001s 01 0 39 0 69 0.001s 0.003s 02 0 35 0 27 0.001s 0.001s 03 0 4 0 85 0.001s 0.003s 04 0 0 0 31 0.001s 0.002s 05 0 1 0 49 0.001s 0.002s 06 0 0 0 74 0.001s 0.002s 07 0 0 0 123 0.001s 0.002s 08 0 0 0 115 0.001s 0.002s 09 0 1 0 86 0.001s 0.002s 10 0 0 0 69 0.001s 0.002s 11 0 0 0 77 0.001s 0.002s 12 0 73 0 37 0.001s 0.002s 13 0 0 0 13 0.001s 0.002s 14 0 0 0 25 0.001s 0.002s 15 0 0 0 56 0.001s 0.002s 16 0 0 0 102 0.001s 0.002s 17 0 0 0 20 0.001s 0.002s 18 0 0 0 20 0.001s 0.002s 19 0 0 0 14 0.001s 0.002s 20 0 0 0 28 0.001s 0.002s 21 0 0 0 20 0.001s 0.002s 22 0 4 0 41 0.001s 0.002s 23 0 0 0 19 0.001s 0.002s Jan 15 00 0 0 0 60 0.001s 0.002s 01 0 0 0 30 0.001s 0.002s 02 0 0 0 40 0.001s 0.002s 03 0 0 0 41 0.001s 0.002s 04 0 2 0 40 0.001s 0.002s 05 0 0 0 37 0.001s 0.002s 06 0 1 0 34 0.001s 0.002s 07 0 4 0 56 0.001s 0.002s 08 0 3 0 68 0.001s 0.001s 09 0 11 0 123 0.001s 0.003s 10 0 0 0 44 0.001s 0.002s 11 0 35 0 35 0.001s 0.002s 12 0 0 0 21 0.001s 0.002s 13 0 0 0 14 0.001s 0.002s 14 0 0 0 55 0.001s 0.002s 15 0 0 0 65 0.001s 0.002s 16 0 0 0 12 0.001s 0.002s 17 0 1 0 50 0.001s 0.002s 18 0 0 0 24 0.001s 0.002s 19 0 0 0 16 0.001s 0.002s 20 0 0 0 19 0.001s 0.002s 21 0 0 0 29 0.001s 0.002s 22 0 1 0 39 0.001s 0.002s 23 0 0 0 26 0.001s 0.002s Jan 16 00 0 0 0 51 0.001s 0.001s 01 0 6 0 67 0.001s 0.003s 02 0 0 1 27 0.001s 0.002s 03 0 0 0 37 0.001s 0.002s 04 0 0 3 51 0.001s 0.002s 05 0 0 1 39 0.001s 0.002s 06 0 0 0 27 0.001s 0.002s 07 0 0 1 37 0.001s 0.002s 08 0 0 0 118 0.001s 0.002s 09 0 0 0 64 0.001s 0.002s 10 0 0 0 38 0.001s 0.002s 11 0 0 0 72 0.001s 0.002s 12 0 1 0 115 0.001s 0.002s 13 0 0 0 19 0.001s 0.002s 14 0 0 0 22 0.001s 0.002s 15 0 0 0 18 0.001s 0.002s 16 0 0 0 31 0.001s 0.002s 17 0 0 0 30 0.001s 0.002s 18 0 0 0 15 0.001s 0.002s 19 0 0 0 6 0.001s 0.001s 20 0 0 0 25 0.001s 0.003s 21 0 0 0 20 0.001s 0.002s 22 0 0 0 16 0.001s 0.002s 23 0 0 0 14 0.001s 0.002s Jan 17 00 0 0 0 59 0.001s 0.002s 01 0 0 0 21 0.001s 0.002s 02 0 0 0 20 0.001s 0.002s 03 0 0 0 29 0.001s 0.002s 04 0 0 0 17 0.001s 0.002s 05 0 0 0 26 0.001s 0.002s 06 0 0 0 22 0.001s 0.002s 07 0 0 0 27 0.001s 0.002s 08 0 0 0 27 0.001s 0.002s 09 0 0 0 16 0.001s 0.002s 10 0 0 0 22 0.001s 0.002s 11 0 0 0 18 0.001s 0.002s 12 0 0 0 16 0.001s 0.002s 13 0 0 0 12 0.001s 0.002s 14 0 0 0 16 0.001s 0.002s 15 0 0 0 18 0.001s 0.002s 16 0 0 0 14 0.001s 0.002s 17 0 0 0 17 0.001s 0.002s 18 0 0 0 10 0.001s 0.001s 19 0 0 0 29 0.001s 0.002s 20 0 0 1 19 0.001s 0.002s 21 0 0 0 22 0.001s 0.002s 22 0 0 0 17 0.001s 0.002s 23 0 0 0 14 0.001s 0.002s Day Hour Count Avg time (sec) Jan 11 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 Jan 12 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 Jan 13 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 Jan 14 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 Jan 15 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 Jan 16 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 Jan 17 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jan 11 00 1,125.50 kB 2,112.50 kB 01 176.00 kB 1,731.50 kB 02 4,107.50 kB 7,514.50 kB 03 211.50 kB 6,138.00 kB 04 62,501.00 kB 62,501.00 kB 05 37,422.33 kB 59,383.00 kB 06 324.50 kB 47,217.50 kB 07 7,100.50 kB 39,540.00 kB 08 643.50 kB 32,193.50 kB 09 1,332.50 kB 26,297.50 kB 10 266.50 kB 21,416.50 kB 11 535.00 kB 17,407.00 kB 12 189.50 kB 14,179.00 kB 13 44.50 kB 11,493.00 kB 14 1,508.00 kB 9,596.50 kB 15 45.50 kB 7,781.50 kB 16 42.00 kB 6,641.00 kB 17 51.00 kB 5,686.00 kB 18 248.00 kB 4,653.50 kB 19 89.00 kB 3,782.50 kB 20 93.50 kB 3,082.50 kB 21 291.00 kB 2,535.00 kB 22 98.50 kB 2,090.00 kB 23 304,760.50 kB 578,956.50 kB Jan 12 00 1,355.50 kB 469,202.00 kB 01 21,766.00 kB 382,267.00 kB 02 413.50 kB 311,633.00 kB 03 212,539.00 kB 403,454.00 kB 04 21,255.50 kB 328,959.50 kB 05 13,654.50 kB 269,724.50 kB 06 2,901.00 kB 220,242.00 kB 07 21,864.00 kB 180,616.50 kB 08 302,950.00 kB 538,410.50 kB 09 354.00 kB 438,014.50 kB 10 97.50 kB 354,832.00 kB 11 244.00 kB 287,445.00 kB 12 108.50 kB 232,864.00 kB 13 28,232.50 kB 193,985.00 kB 14 74.00 kB 157,145.50 kB 15 64.50 kB 127,298.00 kB 16 330.00 kB 103,159.50 kB 17 716.00 kB 88,047.00 kB 18 30.00 kB 79,246.00 kB 19 65.00 kB 67,763.50 kB 20 2,986.00 kB 55,211.50 kB 21 3,388.50 kB 45,605.50 kB 22 179.00 kB 36,974.50 kB 23 91.50 kB 29,971.00 kB Jan 13 00 2,182.50 kB 24,681.50 kB 01 9,896.50 kB 21,009.00 kB 02 281,955.00 kB 520,234.50 kB 03 300,684.00 kB 565,722.00 kB 04 280,829.50 kB 533,522.00 kB 05 576.50 kB 432,231.00 kB 06 2,092.50 kB 350,401.00 kB 07 87.00 kB 283,975.00 kB 08 22,332.50 kB 234,245.00 kB 09 119.50 kB 189,777.00 kB 10 325.00 kB 153,781.50 kB 11 6,983.50 kB 125,274.00 kB 12 1,371.00 kB 102,321.00 kB 13 91.50 kB 82,929.00 kB 14 92.00 kB 67,187.50 kB 15 239.00 kB 54,468.50 kB 16 2,752.50 kB 44,644.00 kB 17 175.00 kB 36,183.50 kB 18 136.50 kB 29,345.50 kB 19 145.50 kB 23,787.00 kB 20 47.50 kB 19,285.00 kB 21 22,059.50 kB 41,824.00 kB 22 277.00 kB 33,913.50 kB 23 75.00 kB 27,500.50 kB Jan 14 00 3,100.00 kB 23,762.00 kB 01 212,261.33 kB 529,251.00 kB 02 44,280.00 kB 433,184.00 kB 03 196,582.00 kB 520,654.33 kB 04 331.50 kB 399,770.00 kB 05 6,724.00 kB 324,511.00 kB 06 3,208.00 kB 263,767.00 kB 07 791.00 kB 214,054.50 kB 08 678.50 kB 173,523.50 kB 09 1,544.50 kB 140,748.00 kB 10 371.50 kB 114,170.00 kB 11 2,225.50 kB 92,775.50 kB 12 599,132.50 kB 1,138,260.50 kB 13 46.50 kB 922,003.00 kB 14 225.00 kB 746,849.50 kB 15 167.00 kB 604,984.50 kB 16 614.00 kB 490,125.50 kB 17 58.00 kB 397,051.00 kB 18 45.50 kB 321,621.50 kB 19 60.00 kB 260,523.50 kB 20 274.50 kB 211,074.00 kB 21 131.00 kB 170,994.50 kB 22 27,633.00 kB 143,755.00 kB 23 96.00 kB 116,460.50 kB Jan 15 00 1,323.50 kB 94,588.00 kB 01 321.50 kB 76,664.00 kB 02 450.00 kB 62,175.00 kB 03 3,530.00 kB 51,051.00 kB 04 13,270.50 kB 42,701.50 kB 05 560.00 kB 35,839.00 kB 06 4,917.00 kB 29,989.00 kB 07 36,241.50 kB 59,895.00 kB 08 55,480.00 kB 57,088.00 kB 09 58,394.67 kB 87,284.33 kB 10 2,041.00 kB 82,999.50 kB 11 280,370.00 kB 532,599.50 kB 12 100.00 kB 431,424.50 kB 13 65.00 kB 349,467.50 kB 14 1,565.00 kB 283,233.00 kB 15 1,715.00 kB 229,881.00 kB 16 34.00 kB 186,209.00 kB 17 5,756.50 kB 151,569.00 kB 18 114.00 kB 123,143.50 kB 19 66.50 kB 99,760.50 kB 20 104.00 kB 80,824.00 kB 21 318.00 kB 65,510.00 kB 22 7,965.50 kB 54,122.50 kB 23 306.00 kB 44,369.50 kB Jan 16 00 2,767.00 kB 38,112.00 kB 01 36,001.33 kB 96,958.67 kB 02 229.50 kB 74,405.00 kB 03 466.00 kB 60,343.00 kB 04 30,180.00 kB 54,470.50 kB 05 7,416.00 kB 45,027.00 kB 06 115.00 kB 37,153.00 kB 07 4,984.00 kB 31,025.00 kB 08 3,897.50 kB 25,862.00 kB 09 480.50 kB 21,062.50 kB 10 308.00 kB 17,104.00 kB 11 435.50 kB 13,922.50 kB 12 1,225.00 kB 11,494.50 kB 13 110.00 kB 9,376.00 kB 14 80.50 kB 7,611.50 kB 15 70.50 kB 6,180.00 kB 16 110.00 kB 5,026.50 kB 17 2,827.50 kB 5,293.00 kB 18 52.00 kB 4,299.50 kB 19 22.00 kB 3,670.00 kB 20 162.67 kB 3,002.33 kB 21 106.50 kB 2,344.00 kB 22 84.00 kB 1,916.50 kB 23 71.00 kB 1,566.50 kB Jan 17 00 1,241.50 kB 2,333.00 kB 01 168.50 kB 1,920.50 kB 02 168.50 kB 1,588.00 kB 03 309.50 kB 1,334.50 kB 04 37.00 kB 1,100.00 kB 05 380.00 kB 932.00 kB 06 74.50 kB 798.00 kB 07 332.50 kB 699.50 kB 08 297.00 kB 629.00 kB 09 86.50 kB 529.50 kB 10 213.00 kB 456.00 kB 11 30.00 kB 391.00 kB 12 57.50 kB 326.50 kB 13 43.00 kB 273.50 kB 14 31.00 kB 227.00 kB 15 46.50 kB 192.00 kB 16 50.50 kB 166.00 kB 17 35.00 kB 142.50 kB 18 15.00 kB 123.00 kB 19 284.50 kB 287.00 kB 20 65.00 kB 395.50 kB 21 225.00 kB 363.50 kB 22 58.50 kB 334.50 kB 23 42.50 kB 279.50 kB -
Temporary Files
Size of temporary files
Key values
- 4.87 MiB Temp Files size Peak
- 2026-01-13 11:50:28 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-01-13 11:50:28 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 11 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 Jan 12 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 Jan 13 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 4 4.87 MiB 1.22 MiB 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 Jan 14 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 Jan 15 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 Jan 16 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 Jan 17 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 4 4.87 MiB 728.00 KiB 1.93 MiB 1.22 MiB vacuum full analyze edit.reference_contact;-
VACUUM FULL ANALYZE edit.reference_contact;
Date: 2026-01-13 11:50:28 Duration: 0ms
Queries generating the largest temporary files
Rank Size Query 1 1.93 MiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-01-13 11:50:28 ]
2 1.13 MiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-01-13 11:50:28 ]
3 1.09 MiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-01-13 11:50:28 ]
4 728.00 KiB VACUUM FULL ANALYZE edit.reference_contact;[ Date: 2026-01-13 11:50:28 ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.91 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-01-14 12:20:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database ctdprd51 - Date
Average Autovacuum Duration
Key values
- 6.91 sec Highest CPU-cost vacuum
Table pub2.term_set_enrichment_agent
Database ctdprd51 - 2026-01-14 12:20:08 Date
Analyzes per table
Key values
- pubc.log_query (107) Main table analyzed (database ctdprd51)
- 131 analyzes Total
Vacuums per table
Key values
- pubc.log_query (11) Main table vacuumed on database ctdprd51
- 24 vacuums Total
Index Buffer usage Skipped WAL usage Table Vacuums scans hits misses dirtied pins frozen records full page bytes ctdprd51.pubc.log_query 11 10 2,922 0 499 0 0 978 359 2,455,498 ctdprd51.pub2.term_set_enrichment_agent 5 0 468,578 0 102,728 0 0 234,008 17 13,923,266 ctdprd51.pub2.term_set_enrichment 5 0 9,984 0 3,683 0 0 4,757 10 354,178 ctdprd51.pg_catalog.pg_statistic 1 1 648 0 110 0 126 418 99 437,584 ctdprd51.pg_toast.pg_toast_2619 1 1 2,873 0 2,377 0 9,820 3,834 1,168 658,919 ctdprd51.pg_toast.pg_toast_486223 1 0 30 0 0 0 0 1 0 188 Total 24 12 485,035 2,816 109,397 0 9,946 243,996 1,653 17,829,633 Tuples removed per table
Key values
- pg_toast.pg_toast_2619 (4541) Main table with removed tuples on database ctdprd51
- 5267 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain ctdprd51.pg_toast.pg_toast_2619 1 1 4,541 22,272 0 0 12,592 ctdprd51.pg_catalog.pg_statistic 1 1 580 3,401 0 0 410 ctdprd51.pubc.log_query 11 10 146 11,713 0 0 470 ctdprd51.pub2.term_set_enrichment_agent 5 0 0 89,002,067 0 0 1,011,391 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 0 0 0 ctdprd51.pub2.term_set_enrichment 5 0 0 1,320,740 0 0 21,786 Total 24 12 5,267 90,360,193 0 0 1,046,649 Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Pages removed per tables
NO DATASET
Table Number of vacuums Index scans Tuples removed Pages removed ctdprd51.pub2.term_set_enrichment_agent 5 0 0 0 ctdprd51.pubc.log_query 11 10 146 0 ctdprd51.pg_catalog.pg_statistic 1 1 580 0 ctdprd51.pg_toast.pg_toast_2619 1 1 4541 0 ctdprd51.pg_toast.pg_toast_486223 1 0 0 0 ctdprd51.pub2.term_set_enrichment 5 0 0 0 Total 24 12 5,267 0 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 11 00 0 0 01 0 1 02 0 1 03 0 2 04 0 1 05 1 5 06 0 0 07 0 1 08 0 0 09 0 2 10 0 1 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 1 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 2 2 Jan 12 00 1 2 01 0 4 02 0 4 03 0 2 04 0 1 05 1 3 06 1 1 07 0 1 08 1 3 09 0 1 10 0 0 11 0 0 12 0 0 13 0 1 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 1 0 21 0 1 22 0 0 23 0 0 Jan 13 00 1 1 01 0 2 02 1 4 03 1 2 04 0 3 05 0 3 06 0 0 07 0 0 08 1 1 09 0 0 10 0 1 11 0 1 12 0 0 13 0 1 14 0 0 15 0 0 16 0 1 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 1 23 0 0 Jan 14 00 4 2 01 0 2 02 0 5 03 1 1 04 0 2 05 0 3 06 0 0 07 0 1 08 0 0 09 0 1 10 0 0 11 0 0 12 1 2 13 0 0 14 0 1 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 1 21 0 0 22 0 1 23 1 0 Jan 15 00 0 0 01 0 3 02 0 2 03 0 1 04 0 1 05 0 3 06 0 1 07 2 1 08 0 1 09 0 0 10 0 1 11 0 2 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 1 18 0 0 19 0 0 20 0 0 21 0 1 22 0 0 23 0 0 Jan 16 00 0 1 01 1 2 02 0 3 03 0 1 04 0 1 05 0 3 06 0 0 07 0 1 08 0 0 09 1 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 1 21 0 0 22 0 0 23 0 0 Jan 17 00 0 0 01 0 2 02 0 1 03 0 1 04 0 0 05 0 5 06 0 0 07 1 1 08 0 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 1 20 0 0 21 0 1 22 0 0 23 0 0 - 6.91 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
- 170 Total read queries
- 551 Total write queries
Queries by database
Key values
- unknown Main database
- 534 Requests
- 11h33m16s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 1,251 Requests
User Request type Count Duration edit Total 2 14s866ms select 2 14s866ms postgres Total 105 1h40m21s copy to 105 1h40m21s pubc Total 11 1h23m40s select 11 1h23m40s pubeu Total 267 2h19m22s select 267 2h19m22s qaeu Total 17 1m28s select 17 1m28s unknown Total 1,251 1d3h55m30s copy to 1,192 1d3h46m28s others 9 1m select 50 8m1s Duration by user
Key values
- 1d3h55m30s (unknown) Main time consuming user
User Request type Count Duration edit Total 2 14s866ms select 2 14s866ms postgres Total 105 1h40m21s copy to 105 1h40m21s pubc Total 11 1h23m40s select 11 1h23m40s pubeu Total 267 2h19m22s select 267 2h19m22s qaeu Total 17 1m28s select 17 1m28s unknown Total 1,251 1d3h55m30s copy to 1,192 1d3h46m28s others 9 1m select 50 8m1s Queries by host
Key values
- unknown Main host
- 1,653 Requests
- 1d9h20m38s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 672 Requests
- 12h50m44s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-01-15 19:29:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 450 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 26m19s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-17 18:43:46 ]
2 26m15s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-12 19:29:45 ]
3 26m14s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-17 19:29:58 ]
4 26m12s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-13 19:29:40 ]
5 26m12s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-14 19:29:37 ]
6 26m11s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-12 18:43:35 ]
7 26m10s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-16 19:29:34 ]
8 26m10s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-13 18:43:34 ]
9 26m9s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-14 18:43:34 ]
10 26m9s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-11 19:29:30 ]
11 26m9s COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-15 19:29:30 ]
12 26m5s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-15 18:43:29 ]
13 26m4s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-16 18:43:28 ]
14 26m3s COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;[ Date: 2026-01-11 18:43:28 ]
15 14m33s SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;[ Date: 2026-01-13 04:03:07 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
16 14m28s SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;[ Date: 2026-01-13 04:03:21 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
17 13m41s SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;[ Date: 2026-01-13 04:01:01 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
18 12m49s SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;[ Date: 2026-01-13 00:30:13 - Database: ctdprd51 - User: pubeu - Bind query: yes ]
19 9m16s /* * 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-01-14 00:09:18 - Database: ctdprd51 - User: pubc - Application: psql ]
20 9m14s /* * 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-01-15 00:09:15 - Database: ctdprd51 - User: pubc - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3h3m24s 7 26m9s 26m15s 26m12s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 11 19 1 26m9s 26m9s Jan 12 19 1 26m15s 26m15s Jan 13 19 1 26m12s 26m12s Jan 14 19 1 26m12s 26m12s Jan 15 19 1 26m9s 26m9s Jan 16 19 1 26m10s 26m10s Jan 17 19 1 26m14s 26m14s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 19:29:45 Duration: 26m15s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 19:29:58 Duration: 26m14s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 19:29:40 Duration: 26m12s
2 3h3m4s 7 26m3s 26m19s 26m9s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 11 18 1 26m3s 26m3s Jan 12 18 1 26m11s 26m11s Jan 13 18 1 26m10s 26m10s Jan 14 18 1 26m9s 26m9s Jan 15 18 1 26m5s 26m5s Jan 16 18 1 26m4s 26m4s Jan 17 18 1 26m19s 26m19s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 18:43:46 Duration: 26m19s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 18:43:35 Duration: 26m11s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 18:43:34 Duration: 26m10s
3 1h4m28s 7 9m9s 9m16s 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s Jan 12 00 1 9m11s 9m11s Jan 13 00 1 9m13s 9m13s Jan 14 00 1 9m16s 9m16s Jan 15 00 1 9m14s 9m14s Jan 16 00 1 9m12s 9m12s Jan 17 00 1 9m9s 9m9s [ User: pubc - Total duration: 1h4m28s - Times executed: 7 ]
[ Application: psql - Total duration: 1h4m28s - Times executed: 7 ]
-
/* * 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-01-14 00:09:18 Duration: 9m16s 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-01-15 00:09:15 Duration: 9m14s 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-01-13 00:09:33 Duration: 9m13s Database: ctdprd51 User: pubc Application: psql
4 55m33s 4 12m49s 14m33s 13m53s select g.id geneid, g.acc_txt acc, g.nm nm, g.nm nmhtml, g.secondary_nm secondarynm, g.has_chems haschems, g.has_diseases hasdiseases, g.has_exposures hasexposures, g.has_phenotypes hasphenotypes, count(*) over () fullrowcount from term g where g.id in (( select gcri.gene_id from dag_path pi inner join gene_chem_reference gcri on pi.descendant_object_id = gcri.chem_id inner join term ti on ti.id = pi.ancestor_object_id where upper(ti.nm) like ? and ti.object_type_id = ?) intersect ( select gt.gene_id from dag_path dp inner join gene_taxon gt on dp.descendant_object_id = gt.taxon_id inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ? union select gcr.gene_id from dag_path dp inner join gene_chem_reference gcr on dp.descendant_object_id = gcr.taxon_id inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ?) intersect ( select gi.id gene_id from term gi where gi.object_type_id = ? and upper(gi.nm) like ?) intersect ( select ai.gene_id from dag_path pi inner join gene_go_annot ai on pi.descendant_object_id = ai.go_term_id inner join db_link dbli on dbli.object_id = pi.ancestor_object_id where dbli.acc_txt = ? and dbli.type_cd = ? and dbli.object_type_id = ?) intersect ( select gd.gene_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id inner join gene_disease gd on dp.descendant_object_id = gd.disease_id where upper(t.nm) like ? and t.object_type_id = ? and gd.curated_reference_qty > ?)) order by g.nm_sort, g.id limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 13 00 1 12m49s 12m49s 04 3 42m43s 14m14s [ User: pubeu - Total duration: 55m33s - Times executed: 4 ]
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:03:07 Duration: 14m33s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:03:21 Duration: 14m28s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:01:01 Duration: 13m41s Database: ctdprd51 User: pubeu Bind query: yes
5 52m25s 7 7m27s 7m30s 7m29s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 11 19 1 7m29s 7m29s Jan 12 19 1 7m29s 7m29s Jan 13 19 1 7m28s 7m28s Jan 14 19 1 7m27s 7m27s Jan 15 19 1 7m30s 7m30s Jan 16 19 1 7m28s 7m28s Jan 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 19:42:25 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
6 52m 7 7m23s 7m27s 7m25s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 11 18 1 7m25s 7m25s Jan 12 18 1 7m25s 7m25s Jan 13 18 1 7m25s 7m25s Jan 14 18 1 7m23s 7m23s Jan 15 18 1 7m25s 7m25s Jan 16 18 1 7m26s 7m26s Jan 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-16 18:56:18 Duration: 7m26s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 18:56:18 Duration: 7m25s
7 50m4s 27 1m49s 2m7s 1m51s 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 #7
Day Hour Count Duration Avg duration Jan 11 19 1 1m49s 1m49s Jan 12 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 13 06 1 2m7s 2m7s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m52s 1m52s 19 1 1m50s 1m50s Jan 14 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 15 06 1 1m51s 1m51s 10 1 1m51s 1m51s 14 1 1m50s 1m50s 18 1 1m50s 1m50s 19 1 1m49s 1m49s Jan 16 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 17 19 1 1m50s 1m50s [ User: postgres - Total duration: 37m15s - Times executed: 20 ]
[ Application: pg_dump - Total duration: 37m15s - Times executed: 20 ]
-
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-01-13 06:07:08 Duration: 2m7s 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-01-13 18:06:54 Duration: 1m52s 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-01-14 18:06:53 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
8 11m46s 7 1m40s 1m41s 1m40s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 11 19 1 1m40s 1m40s Jan 12 19 1 1m41s 1m41s Jan 13 19 1 1m41s 1m41s Jan 14 19 1 1m40s 1m40s Jan 15 19 1 1m40s 1m40s Jan 16 19 1 1m41s 1m41s Jan 17 19 1 1m40s 1m40s -
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-12 19:33:12 Duration: 1m41s
-
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-16 19:33:00 Duration: 1m41s
-
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-13 19:33:06 Duration: 1m41s
9 11m40s 7 1m39s 1m40s 1m40s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 11 18 1 1m39s 1m39s Jan 12 18 1 1m40s 1m40s Jan 13 18 1 1m40s 1m40s Jan 14 18 1 1m40s 1m40s Jan 15 18 1 1m39s 1m39s Jan 16 18 1 1m40s 1m40s Jan 17 18 1 1m40s 1m40s -
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-17 18:47:11 Duration: 1m40s
-
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-13 18:46:59 Duration: 1m40s
-
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-12 18:47:00 Duration: 1m40s
10 10m42s 27 23s482ms 24s68ms 23s795ms 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 #10
Day Hour Count Duration Avg duration Jan 11 19 1 23s631ms 23s631ms Jan 12 06 1 23s869ms 23s869ms 10 1 23s691ms 23s691ms 14 1 23s920ms 23s920ms 18 1 23s789ms 23s789ms 19 1 23s655ms 23s655ms Jan 13 06 1 23s767ms 23s767ms 10 1 23s782ms 23s782ms 14 1 24s68ms 24s68ms 18 1 24s7ms 24s7ms 19 1 23s658ms 23s658ms Jan 14 06 1 23s992ms 23s992ms 10 1 23s904ms 23s904ms 14 1 23s836ms 23s836ms 18 1 23s731ms 23s731ms 19 1 23s482ms 23s482ms Jan 15 06 1 23s777ms 23s777ms 10 1 23s920ms 23s920ms 14 1 23s798ms 23s798ms 18 1 23s727ms 23s727ms 19 1 23s678ms 23s678ms Jan 16 06 1 23s788ms 23s788ms 10 1 23s808ms 23s808ms 14 1 23s863ms 23s863ms 18 1 23s885ms 23s885ms 19 1 23s703ms 23s703ms Jan 17 19 1 23s734ms 23s734ms -
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-01-13 14:07:16 Duration: 24s68ms
-
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-01-13 18:07:18 Duration: 24s7ms
-
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-01-14 06:07:17 Duration: 23s992ms
11 9m41s 7 1m22s 1m23s 1m23s copy pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 11 18 1 1m23s 1m23s Jan 12 18 1 1m23s 1m23s Jan 13 18 1 1m22s 1m22s Jan 14 18 1 1m22s 1m22s Jan 15 18 1 1m22s 1m22s Jan 16 18 1 1m23s 1m23s Jan 17 18 1 1m23s 1m23s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:58:07 Duration: 1m23s
-
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-16 18:58:08 Duration: 1m23s
-
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-12 18:58:15 Duration: 1m23s
12 8m28s 7 1m12s 1m12s 1m12s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 11 19 1 1m12s 1m12s Jan 12 19 1 1m12s 1m12s Jan 13 19 1 1m12s 1m12s Jan 14 19 1 1m12s 1m12s Jan 15 19 1 1m12s 1m12s Jan 16 19 1 1m12s 1m12s Jan 17 19 1 1m12s 1m12s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-17 19:01:23 Duration: 1m12s
-
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-13 19:01:07 Duration: 1m12s
-
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-12 19:01:10 Duration: 1m12s
13 8m25s 7 1m11s 1m12s 1m12s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 11 18 1 1m11s 1m11s Jan 12 18 1 1m11s 1m11s Jan 13 18 1 1m12s 1m12s Jan 14 18 1 1m12s 1m12s Jan 15 18 1 1m11s 1m11s Jan 16 18 1 1m12s 1m12s Jan 17 18 1 1m12s 1m12s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-13 18:15:05 Duration: 1m12s
-
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-17 18:15:06 Duration: 1m12s
-
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-16 18:15:04 Duration: 1m12s
14 8m10s 27 17s819ms 24s131ms 18s177ms 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 #14
Day Hour Count Duration Avg duration Jan 11 18 1 18s19ms 18s19ms Jan 12 06 1 17s834ms 17s834ms 10 1 17s855ms 17s855ms 14 1 18s51ms 18s51ms 18 2 35s959ms 17s979ms Jan 13 06 1 24s131ms 24s131ms 10 1 18s 18s 14 1 18s59ms 18s59ms 18 2 35s956ms 17s978ms Jan 14 06 1 17s938ms 17s938ms 10 1 17s960ms 17s960ms 14 1 17s943ms 17s943ms 18 2 35s969ms 17s984ms Jan 15 06 1 17s919ms 17s919ms 10 1 18s23ms 18s23ms 14 1 18s64ms 18s64ms 18 2 35s760ms 17s880ms Jan 16 06 1 17s861ms 17s861ms 10 1 17s894ms 17s894ms 14 1 17s984ms 17s984ms 18 2 35s728ms 17s864ms Jan 17 18 1 17s868ms 17s868ms [ User: postgres - Total duration: 8m10s - Times executed: 27 ]
[ Application: pg_dump - Total duration: 8m10s - Times executed: 27 ]
-
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-01-13 06:00:31 Duration: 24s131ms 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-01-12 18:00:20 Duration: 18s106ms 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-01-13 18:00:20 Duration: 18s97ms Database: ctdprd51 User: postgres Application: pg_dump
15 7m31s 7 1m4s 1m4s 1m4s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 11 18 1 1m4s 1m4s Jan 12 18 1 1m4s 1m4s Jan 13 18 1 1m4s 1m4s Jan 14 18 1 1m4s 1m4s Jan 15 18 1 1m4s 1m4s Jan 16 18 1 1m4s 1m4s Jan 17 18 1 1m4s 1m4s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-17 18:16:12 Duration: 1m4s
-
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-14 18:16:10 Duration: 1m4s
-
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-13 18:16:10 Duration: 1m4s
16 7m30s 7 1m3s 1m4s 1m4s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 11 19 1 1m4s 1m4s Jan 12 19 1 1m4s 1m4s Jan 13 19 1 1m4s 1m4s Jan 14 19 1 1m3s 1m3s Jan 15 19 1 1m4s 1m4s Jan 16 19 1 1m4s 1m4s Jan 17 19 1 1m4s 1m4s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-17 19:02:28 Duration: 1m4s
-
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-13 19:02:12 Duration: 1m4s
-
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-16 19:02:08 Duration: 1m4s
17 6m56s 27 15s215ms 15s662ms 15s423ms 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 #17
Day Hour Count Duration Avg duration Jan 11 19 1 15s314ms 15s314ms Jan 12 06 1 15s576ms 15s576ms 10 1 15s369ms 15s369ms 14 1 15s415ms 15s415ms 18 1 15s396ms 15s396ms 19 1 15s332ms 15s332ms Jan 13 06 1 15s441ms 15s441ms 10 1 15s376ms 15s376ms 14 1 15s662ms 15s662ms 18 1 15s485ms 15s485ms 19 1 15s381ms 15s381ms Jan 14 06 1 15s545ms 15s545ms 10 1 15s419ms 15s419ms 14 1 15s447ms 15s447ms 18 1 15s417ms 15s417ms 19 1 15s215ms 15s215ms Jan 15 06 1 15s431ms 15s431ms 10 1 15s433ms 15s433ms 14 1 15s529ms 15s529ms 18 1 15s453ms 15s453ms 19 1 15s329ms 15s329ms Jan 16 06 1 15s365ms 15s365ms 10 1 15s423ms 15s423ms 14 1 15s480ms 15s480ms 18 1 15s490ms 15s490ms 19 1 15s391ms 15s391ms Jan 17 19 1 15s319ms 15s319ms -
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-01-13 14:07:32 Duration: 15s662ms
-
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-01-12 06:07:32 Duration: 15s576ms
-
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-01-14 06:07:32 Duration: 15s545ms
18 6m31s 27 14s422ms 14s625ms 14s508ms 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 #18
Day Hour Count Duration Avg duration Jan 11 18 1 14s527ms 14s527ms Jan 12 06 1 14s528ms 14s528ms 10 1 14s542ms 14s542ms 14 1 14s508ms 14s508ms 18 2 29s56ms 14s528ms Jan 13 06 1 14s545ms 14s545ms 10 1 14s434ms 14s434ms 14 1 14s518ms 14s518ms 18 2 29s161ms 14s580ms Jan 14 06 1 14s625ms 14s625ms 10 1 14s423ms 14s423ms 14 1 14s509ms 14s509ms 18 2 28s932ms 14s466ms Jan 15 06 1 14s513ms 14s513ms 10 1 14s422ms 14s422ms 14 1 14s568ms 14s568ms 18 2 28s931ms 14s465ms Jan 16 06 1 14s462ms 14s462ms 10 1 14s534ms 14s534ms 14 1 14s525ms 14s525ms 18 2 28s924ms 14s462ms Jan 17 18 1 14s539ms 14s539ms -
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-01-14 06:00:50 Duration: 14s625ms
-
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-01-13 18:00:50 Duration: 14s624ms
-
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-01-15 14:00:50 Duration: 14s568ms
19 6m29s 27 14s330ms 14s530ms 14s425ms 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 #19
Day Hour Count Duration Avg duration Jan 11 18 1 14s395ms 14s395ms Jan 12 06 1 14s450ms 14s450ms 10 1 14s398ms 14s398ms 14 1 14s417ms 14s417ms 18 2 28s886ms 14s443ms Jan 13 06 1 14s422ms 14s422ms 10 1 14s373ms 14s373ms 14 1 14s465ms 14s465ms 18 2 28s924ms 14s462ms Jan 14 06 1 14s449ms 14s449ms 10 1 14s433ms 14s433ms 14 1 14s449ms 14s449ms 18 2 28s807ms 14s403ms Jan 15 06 1 14s447ms 14s447ms 10 1 14s425ms 14s425ms 14 1 14s410ms 14s410ms 18 2 28s826ms 14s413ms Jan 16 06 1 14s475ms 14s475ms 10 1 14s465ms 14s465ms 14 1 14s454ms 14s454ms 18 2 28s665ms 14s332ms Jan 17 18 1 14s438ms 14s438ms -
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-01-13 18:01:05 Duration: 14s530ms
-
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-01-15 18:11:05 Duration: 14s482ms
-
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-01-12 18:01:05 Duration: 14s481ms
20 6m19s 7 54s93ms 54s565ms 54s276ms copy pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 11 18 1 54s305ms 54s305ms Jan 12 18 1 54s376ms 54s376ms Jan 13 18 1 54s194ms 54s194ms Jan 14 18 1 54s245ms 54s245ms Jan 15 18 1 54s155ms 54s155ms Jan 16 18 1 54s93ms 54s93ms Jan 17 18 1 54s565ms 54s565ms -
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 18:13:45 Duration: 54s565ms
-
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 18:13:44 Duration: 54s376ms
-
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-11 18:13:45 Duration: 54s305ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 27 50m4s 1m49s 2m7s 1m51s copy pubc.log_query_archive (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, gene_set_txt, molecule_type_txt, volume_txt, first_page_txt, journal_query_type, journal_txt, is_review, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 11 19 1 1m49s 1m49s Jan 12 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 13 06 1 2m7s 2m7s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m52s 1m52s 19 1 1m50s 1m50s Jan 14 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 15 06 1 1m51s 1m51s 10 1 1m51s 1m51s 14 1 1m50s 1m50s 18 1 1m50s 1m50s 19 1 1m49s 1m49s Jan 16 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 17 19 1 1m50s 1m50s [ User: postgres - Total duration: 37m15s - Times executed: 20 ]
[ Application: pg_dump - Total duration: 37m15s - Times executed: 20 ]
-
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-01-13 06:07:08 Duration: 2m7s 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-01-13 18:06:54 Duration: 1m52s 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-01-14 18:06:53 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
2 27 10m42s 23s482ms 24s68ms 23s795ms copy pubc.log_query_bots (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 11 19 1 23s631ms 23s631ms Jan 12 06 1 23s869ms 23s869ms 10 1 23s691ms 23s691ms 14 1 23s920ms 23s920ms 18 1 23s789ms 23s789ms 19 1 23s655ms 23s655ms Jan 13 06 1 23s767ms 23s767ms 10 1 23s782ms 23s782ms 14 1 24s68ms 24s68ms 18 1 24s7ms 24s7ms 19 1 23s658ms 23s658ms Jan 14 06 1 23s992ms 23s992ms 10 1 23s904ms 23s904ms 14 1 23s836ms 23s836ms 18 1 23s731ms 23s731ms 19 1 23s482ms 23s482ms Jan 15 06 1 23s777ms 23s777ms 10 1 23s920ms 23s920ms 14 1 23s798ms 23s798ms 18 1 23s727ms 23s727ms 19 1 23s678ms 23s678ms Jan 16 06 1 23s788ms 23s788ms 10 1 23s808ms 23s808ms 14 1 23s863ms 23s863ms 18 1 23s885ms 23s885ms 19 1 23s703ms 23s703ms Jan 17 19 1 23s734ms 23s734ms -
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-01-13 14:07:16 Duration: 24s68ms
-
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-01-13 18:07:18 Duration: 24s7ms
-
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-01-14 06:07:17 Duration: 23s992ms
3 27 8m10s 17s819ms 24s131ms 18s177ms copy edit.db_link (object_id, object_type_id, acc_txt, db_id, type_cd, is_primary, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 11 18 1 18s19ms 18s19ms Jan 12 06 1 17s834ms 17s834ms 10 1 17s855ms 17s855ms 14 1 18s51ms 18s51ms 18 2 35s959ms 17s979ms Jan 13 06 1 24s131ms 24s131ms 10 1 18s 18s 14 1 18s59ms 18s59ms 18 2 35s956ms 17s978ms Jan 14 06 1 17s938ms 17s938ms 10 1 17s960ms 17s960ms 14 1 17s943ms 17s943ms 18 2 35s969ms 17s984ms Jan 15 06 1 17s919ms 17s919ms 10 1 18s23ms 18s23ms 14 1 18s64ms 18s64ms 18 2 35s760ms 17s880ms Jan 16 06 1 17s861ms 17s861ms 10 1 17s894ms 17s894ms 14 1 17s984ms 17s984ms 18 2 35s728ms 17s864ms Jan 17 18 1 17s868ms 17s868ms [ User: postgres - Total duration: 8m10s - Times executed: 27 ]
[ Application: pg_dump - Total duration: 8m10s - Times executed: 27 ]
-
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-01-13 06:00:31 Duration: 24s131ms 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-01-12 18:00:20 Duration: 18s106ms 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-01-13 18:00:20 Duration: 18s97ms Database: ctdprd51 User: postgres Application: pg_dump
4 27 6m56s 15s215ms 15s662ms 15s423ms copy pubc.log_query_bots_original (id, type_cd, query_tm, submission_qty, session_id, remote_addr, http_user_agent, server_nm, node_nm, results_qty, execution_ms, basic_query_type, basic_query_txt, gene_query_type, gene_txt, gene_form_type_txt, taxon_query_type, taxon_txt, chem_query_type, chem_txt, party_query_type, party_nm_txt, acc_txt, go_query_type, go_txt, disease_query_type, disease_txt, action_type_txt, action_degree_type_txt, from_yr, through_yr, title_abstract_txt, has_marray, pathway_query_type, pathway_txt, dag_txt, results_format_txt, batch_input_type_txt, gd_assn_type, p_val, p_val_type, input_term_qty, review_status, user_agent_pattern) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 11 19 1 15s314ms 15s314ms Jan 12 06 1 15s576ms 15s576ms 10 1 15s369ms 15s369ms 14 1 15s415ms 15s415ms 18 1 15s396ms 15s396ms 19 1 15s332ms 15s332ms Jan 13 06 1 15s441ms 15s441ms 10 1 15s376ms 15s376ms 14 1 15s662ms 15s662ms 18 1 15s485ms 15s485ms 19 1 15s381ms 15s381ms Jan 14 06 1 15s545ms 15s545ms 10 1 15s419ms 15s419ms 14 1 15s447ms 15s447ms 18 1 15s417ms 15s417ms 19 1 15s215ms 15s215ms Jan 15 06 1 15s431ms 15s431ms 10 1 15s433ms 15s433ms 14 1 15s529ms 15s529ms 18 1 15s453ms 15s453ms 19 1 15s329ms 15s329ms Jan 16 06 1 15s365ms 15s365ms 10 1 15s423ms 15s423ms 14 1 15s480ms 15s480ms 18 1 15s490ms 15s490ms 19 1 15s391ms 15s391ms Jan 17 19 1 15s319ms 15s319ms -
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-01-13 14:07:32 Duration: 15s662ms
-
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-01-12 06:07:32 Duration: 15s576ms
-
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-01-14 06:07:32 Duration: 15s545ms
5 27 6m31s 14s422ms 14s625ms 14s508ms copy edit.ixn_actor (ixn_id, position_seq, object_type_id, acc_txt, acc_db_id, object_nm, actor_form_type_id, qual_actor_form_type_id, seq_acc_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 11 18 1 14s527ms 14s527ms Jan 12 06 1 14s528ms 14s528ms 10 1 14s542ms 14s542ms 14 1 14s508ms 14s508ms 18 2 29s56ms 14s528ms Jan 13 06 1 14s545ms 14s545ms 10 1 14s434ms 14s434ms 14 1 14s518ms 14s518ms 18 2 29s161ms 14s580ms Jan 14 06 1 14s625ms 14s625ms 10 1 14s423ms 14s423ms 14 1 14s509ms 14s509ms 18 2 28s932ms 14s466ms Jan 15 06 1 14s513ms 14s513ms 10 1 14s422ms 14s422ms 14 1 14s568ms 14s568ms 18 2 28s931ms 14s465ms Jan 16 06 1 14s462ms 14s462ms 10 1 14s534ms 14s534ms 14 1 14s525ms 14s525ms 18 2 28s924ms 14s462ms Jan 17 18 1 14s539ms 14s539ms -
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-01-14 06:00:50 Duration: 14s625ms
-
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-01-13 18:00:50 Duration: 14s624ms
-
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-01-15 14:00:50 Duration: 14s568ms
6 27 6m29s 14s330ms 14s530ms 14s425ms copy edit.reference (id, title, journal_nm, issue, pages_txt, page_position_seq, volume, pub_dt_format_mask, pub_start_dt, pub_end_dt, pub_start_season_nm, pub_end_season_nm, is_review, is_author_list_complete, affiliation_txt, abstract_txt, create_by, create_tm, mod_by, mod_tm) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 11 18 1 14s395ms 14s395ms Jan 12 06 1 14s450ms 14s450ms 10 1 14s398ms 14s398ms 14 1 14s417ms 14s417ms 18 2 28s886ms 14s443ms Jan 13 06 1 14s422ms 14s422ms 10 1 14s373ms 14s373ms 14 1 14s465ms 14s465ms 18 2 28s924ms 14s462ms Jan 14 06 1 14s449ms 14s449ms 10 1 14s433ms 14s433ms 14 1 14s449ms 14s449ms 18 2 28s807ms 14s403ms Jan 15 06 1 14s447ms 14s447ms 10 1 14s425ms 14s425ms 14 1 14s410ms 14s410ms 18 2 28s826ms 14s413ms Jan 16 06 1 14s475ms 14s475ms 10 1 14s465ms 14s465ms 14 1 14s454ms 14s454ms 18 2 28s665ms 14s332ms Jan 17 18 1 14s438ms 14s438ms -
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-01-13 18:01:05 Duration: 14s530ms
-
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-01-15 18:11:05 Duration: 14s482ms
-
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-01-12 18:01:05 Duration: 14s481ms
7 27 3m15s 7s199ms 7s319ms 7s250ms 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 #7
Day Hour Count Duration Avg duration Jan 11 18 1 7s199ms 7s199ms Jan 12 06 1 7s211ms 7s211ms 10 1 7s230ms 7s230ms 14 1 7s263ms 7s263ms 18 2 14s549ms 7s274ms Jan 13 06 1 7s276ms 7s276ms 10 1 7s223ms 7s223ms 14 1 7s282ms 7s282ms 18 2 14s495ms 7s247ms Jan 14 06 1 7s319ms 7s319ms 10 1 7s265ms 7s265ms 14 1 7s252ms 7s252ms 18 2 14s488ms 7s244ms Jan 15 06 1 7s229ms 7s229ms 10 1 7s225ms 7s225ms 14 1 7s264ms 7s264ms 18 2 14s445ms 7s222ms Jan 16 06 1 7s258ms 7s258ms 10 1 7s202ms 7s202ms 14 1 7s297ms 7s297ms 18 2 14s523ms 7s261ms Jan 17 18 1 7s244ms 7s244ms -
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-01-14 06:00:29 Duration: 7s319ms
-
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-01-12 18:00:29 Duration: 7s308ms
-
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-01-16 14:00:29 Duration: 7s297ms
8 27 2m51s 6s299ms 6s452ms 6s361ms 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 #8
Day Hour Count Duration Avg duration Jan 11 18 1 6s335ms 6s335ms Jan 12 06 1 6s335ms 6s335ms 10 1 6s346ms 6s346ms 14 1 6s329ms 6s329ms 18 2 12s849ms 6s424ms Jan 13 06 1 6s382ms 6s382ms 10 1 6s326ms 6s326ms 14 1 6s438ms 6s438ms 18 2 12s829ms 6s414ms Jan 14 06 1 6s382ms 6s382ms 10 1 6s333ms 6s333ms 14 1 6s412ms 6s412ms 18 2 12s719ms 6s359ms Jan 15 06 1 6s336ms 6s336ms 10 1 6s314ms 6s314ms 14 1 6s369ms 6s369ms 18 2 12s640ms 6s320ms Jan 16 06 1 6s336ms 6s336ms 10 1 6s339ms 6s339ms 14 1 6s361ms 6s361ms 18 2 12s635ms 6s317ms Jan 17 18 1 6s391ms 6s391ms -
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-01-12 18:01:13 Duration: 6s452ms
-
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-01-13 18:11:12 Duration: 6s444ms
-
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-01-13 14:01:13 Duration: 6s438ms
9 27 2m42s 5s978ms 6s108ms 6s31ms 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 #9
Day Hour Count Duration Avg duration Jan 11 18 1 6s7ms 6s7ms Jan 12 06 1 5s988ms 5s988ms 10 1 6s10ms 6s10ms 14 1 6s86ms 6s86ms 18 2 12s76ms 6s38ms Jan 13 06 1 6s69ms 6s69ms 10 1 5s978ms 5s978ms 14 1 6s46ms 6s46ms 18 2 12s4ms 6s2ms Jan 14 06 1 6s17ms 6s17ms 10 1 6s77ms 6s77ms 14 1 6s7ms 6s7ms 18 2 12s61ms 6s30ms Jan 15 06 1 6s39ms 6s39ms 10 1 5s998ms 5s998ms 14 1 6s54ms 6s54ms 18 2 12s70ms 6s35ms Jan 16 06 1 6s108ms 6s108ms 10 1 6s19ms 6s19ms 14 1 6s37ms 6s37ms 18 2 12s17ms 6s8ms Jan 17 18 1 6s62ms 6s62ms -
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-01-16 06:00:35 Duration: 6s108ms
-
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-01-12 14:00:35 Duration: 6s86ms
-
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-01-14 10:00:35 Duration: 6s77ms
10 26 2m12s 5s17ms 5s272ms 5s88ms select t.nm, t.nm_html nmhtml, t.secondary_nm secondarynm, t.acc_txt acc, ? || t.nm accquerystr, t.has_chems haschems, t.has_diseases hasdiseases, t.has_exposures hasexposures, t.has_phenotypes hasphenotypes, count(*) over () fullrowcount from term t where t.object_type_id = ? and regexp_replace(upper(substring(t.nm, ?, ?)), ?, ?) = ? order by t.nm_sort limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 12 17 3 15s454ms 5s151ms Jan 13 04 2 10s136ms 5s68ms 05 2 10s247ms 5s123ms 06 5 25s418ms 5s83ms 13 14 1m11s 5s74ms [ User: pubeu - Total duration: 2m12s - Times executed: 26 ]
-
SELECT /* GeneBrowseTermsDAO */ t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, t.acc_txt acc, 'name:' || t.nm accQueryStr, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term t WHERE t.object_type_id = '4' AND REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') = 'A' ORDER BY t.nm_sort LIMIT 100;
Date: 2026-01-13 13:18:48 Duration: 5s272ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GeneBrowseTermsDAO */ t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, t.acc_txt acc, 'name:' || t.nm accQueryStr, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term t WHERE t.object_type_id = '4' AND REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') = 'A' ORDER BY t.nm_sort LIMIT 100;
Date: 2026-01-12 17:20:51 Duration: 5s214ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* GeneBrowseTermsDAO */ t.nm, t.nm_html nmHtml, t.secondary_nm secondaryNm, t.acc_txt acc, 'name:' || t.nm accQueryStr, t.has_chems hasChems, t.has_diseases hasDiseases, t.has_exposures hasExposures, t.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term t WHERE t.object_type_id = '4' AND REGEXP_REPLACE(UPPER(SUBSTRING(t.nm, 1, 1)), '[^A-Z]', '#') = 'A' ORDER BY t.nm_sort LIMIT 100;
Date: 2026-01-13 13:18:48 Duration: 5s155ms Database: ctdprd51 User: pubeu Bind query: yes
11 23 2m39s 5s14ms 11s628ms 6s938ms select d.nm diseasenm, d.acc_txt diseaseacc, d.acc_db_cd diseaseaccdbcd, d.id diseaseid, g.nm genesymbol, g.acc_txt geneacc, g.acc_db_cd geneaccdbcd, g.id geneid, gd.network_score networkscore, gd.indirect_chem_qty inferredcount, gd.reference_qty referencecount, gd.exposure_reference_qty exposurereferencecount, case when gd.curated_reference_qty > ? then ( select string_agg(a.action_type_cd || ? || a.action_type_nm, ?) from gene_disease_axn a where a.gene_id = gd.gene_id and a.disease_id = gd.disease_id) else null end actiontypes from gene_disease gd inner join term g on gd.gene_id = g.id inner join term d on gd.disease_id = d.id where gd.disease_id in ( select p.descendant_object_id from dag_path p where p.ancestor_object_id = ?) order by actiontypes, gd.network_score desc nulls last, g.nm_sort, d.nm_sort limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 12 21 1 11s628ms 11s628ms Jan 13 02 2 10s423ms 5s211ms 03 2 16s691ms 8s345ms 21 7 42s132ms 6s18ms Jan 14 03 2 11s94ms 5s547ms Jan 16 02 1 11s276ms 11s276ms 08 2 22s436ms 11s218ms 13 5 27s210ms 5s442ms Jan 17 10 1 6s695ms 6s695ms [ User: pubeu - Total duration: 2m5s - Times executed: 19 ]
-
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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-12 21:47:21 Duration: 11s628ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-16 08:41:46 Duration: 11s446ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort LIMIT 50;
Date: 2026-01-13 03:23:33 Duration: 11s332ms Bind query: yes
12 21 1m57s 5s30ms 6s839ms 5s579ms 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 #12
Day Hour Count Duration Avg duration Jan 12 03 1 5s213ms 5s213ms 22 2 10s842ms 5s421ms Jan 13 03 1 5s174ms 5s174ms 10 1 5s323ms 5s323ms 13 1 5s178ms 5s178ms Jan 14 07 1 5s42ms 5s42ms 20 2 11s134ms 5s567ms 21 2 11s378ms 5s689ms Jan 15 05 1 6s839ms 6s839ms 10 1 5s883ms 5s883ms 21 3 16s645ms 5s548ms Jan 16 01 1 5s882ms 5s882ms 02 1 5s964ms 5s964ms 04 1 5s859ms 5s859ms 08 1 5s776ms 5s776ms Jan 17 07 1 5s30ms 5s30ms [ User: pubeu - Total duration: 1m51s - Times executed: 20 ]
-
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 = '1397318' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-15 05:48:31 Duration: 6s839ms 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 = '1305189' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-16 02:11:27 Duration: 5s964ms 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 = '1320965' AND te.enriched_object_type_id = 5 ORDER BY te.corrected_p_val, d.abbr, gt.nm_sort LIMIT 50;
Date: 2026-01-15 10:16:02 Duration: 5s883ms Database: ctdprd51 User: pubeu Bind query: yes
13 16 1m22s 5s79ms 5s336ms 5s183ms 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 Jan 11 05 2 10s455ms 5s227ms Jan 12 05 2 10s325ms 5s162ms Jan 13 05 2 10s348ms 5s174ms Jan 14 05 2 10s415ms 5s207ms Jan 15 02 1 5s143ms 5s143ms 05 2 10s352ms 5s176ms Jan 16 02 1 5s153ms 5s153ms 05 2 10s396ms 5s198ms Jan 17 05 2 10s340ms 5s170ms [ User: pubeu - Total duration: 46s495ms - Times executed: 9 ]
[ User: qaeu - Total duration: 36s437ms - Times executed: 7 ]
-
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 = 1332236)) 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-01-14 05:43:42 Duration: 5s336ms 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 = 1332236)) 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-01-15 05:48:46 Duration: 5s238ms Database: ctdprd51 User: pubeu 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 = 1332236)) 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-01-11 05:43:39 Duration: 5s232ms Database: ctdprd51 User: qaeu Bind query: yes
14 10 58s615ms 5s773ms 5s970ms 5s861ms select ii.cd, count(ii.id) cnt from ( select ot.cd, tl.term_id id from object_type ot inner join term_label tl on ot.id = tl.object_type_id where tl.nm_fts @@ to_tsquery(?, ?) union select ?, r.id from reference r where r.title_abstract_fts @@ to_tsquery(?, ?) or r.id in ( select rpr.reference_id from reference_party_role rpr inner join reference_party rp on rpr.reference_party_id = rp.id where (substr(get_reference_party_nm_sort (rp.required_nm), ?, ?) like ?)) union select ot.cd, l.object_id from db_link l inner join object_type ot on l.object_type_id = ot.id where l.type_cd = ? and (upper(l.acc_txt) like ?)) ii group by ii.cd;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 12 21 5 29s306ms 5s861ms Jan 13 00 1 5s959ms 5s959ms 03 1 5s856ms 5s856ms 09 1 5s841ms 5s841ms 15 1 5s838ms 5s838ms Jan 15 03 1 5s811ms 5s811ms [ User: pubeu - Total duration: 41s135ms - Times executed: 7 ]
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CTD_CHEM_GENE_IXNS.TSV') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEM_GENE_IXNS.TSV') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_CHEM_GENE_IXNS.TSV')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CTD_CHEM_GENE_IXNS.TSV')) ii GROUP BY ii.cd;
Date: 2026-01-12 21:45:06 Duration: 5s970ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CTD_DISEASES_DRUGS') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_DISEASES_DRUGS') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_DISEASES_DRUGS')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CTD_DISEASES_DRUGS')) ii GROUP BY ii.cd;
Date: 2026-01-13 00:32:02 Duration: 5s959ms Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* BasicCountsDAO gen */ ii.cd, COUNT(ii.id) cnt FROM ( SELECT ot.cd, tl.term_id id FROM object_type ot INNER JOIN term_label tl ON ot.id = tl.object_type_id WHERE tl.nm_fts @@ to_tsquery('common.english_nostops', 'CTD_CHEM_GENE_IXNS.TSV.GZ') UNION SELECT 'reference', r.id FROM reference r WHERE r.title_abstract_fts @@ to_tsquery('pg_catalog.english', 'CTD_CHEM_GENE_IXNS.TSV.GZ') OR r.id IN ( SELECT rpr.reference_id FROM reference_party_role rpr INNER JOIN reference_party rp ON rpr.reference_party_id = rp.id WHERE (SUBSTR(get_reference_party_nm_sort (rp.required_nm), 1, 128) LIKE 'CTD_CHEM_GENE_IXNS.TSV.GZ')) UNION SELECT ot.cd, l.object_id FROM db_link l INNER JOIN object_type ot on l.object_type_id = ot.id WHERE l.type_cd = 'A' AND (upper(l.acc_txt) LIKE 'CTD_CHEM_GENE_IXNS.TSV.GZ')) ii GROUP BY ii.cd;
Date: 2026-01-12 21:44:48 Duration: 5s894ms Database: ctdprd51 User: pubeu Bind query: yes
15 8 3m19s 6s105ms 38s746ms 24s927ms 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 Jan 12 21 1 36s547ms 36s547ms Jan 15 02 4 49s387ms 12s346ms Jan 16 02 3 1m53s 37s829ms [ User: pubeu - Total duration: 3m19s - Times executed: 8 ]
-
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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-16 02:48:18 Duration: 38s746ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-16 02:49:19 Duration: 38s707ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-12 21:56:37 Duration: 36s547ms Database: ctdprd51 User: pubeu Bind query: yes
16 7 3h3m24s 26m9s 26m15s 26m12s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 11 19 1 26m9s 26m9s Jan 12 19 1 26m15s 26m15s Jan 13 19 1 26m12s 26m12s Jan 14 19 1 26m12s 26m12s Jan 15 19 1 26m9s 26m9s Jan 16 19 1 26m10s 26m10s Jan 17 19 1 26m14s 26m14s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 19:29:45 Duration: 26m15s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 19:29:58 Duration: 26m14s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 19:29:40 Duration: 26m12s
17 7 3h3m4s 26m3s 26m19s 26m9s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 11 18 1 26m3s 26m3s Jan 12 18 1 26m11s 26m11s Jan 13 18 1 26m10s 26m10s Jan 14 18 1 26m9s 26m9s Jan 15 18 1 26m5s 26m5s Jan 16 18 1 26m4s 26m4s Jan 17 18 1 26m19s 26m19s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 18:43:46 Duration: 26m19s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 18:43:35 Duration: 26m11s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 18:43:34 Duration: 26m10s
18 7 1h4m28s 9m9s 9m16s 9m12s select maint_query_logs_archive ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s Jan 12 00 1 9m11s 9m11s Jan 13 00 1 9m13s 9m13s Jan 14 00 1 9m16s 9m16s Jan 15 00 1 9m14s 9m14s Jan 16 00 1 9m12s 9m12s Jan 17 00 1 9m9s 9m9s [ User: pubc - Total duration: 1h4m28s - Times executed: 7 ]
[ Application: psql - Total duration: 1h4m28s - Times executed: 7 ]
-
/* * 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-01-14 00:09:18 Duration: 9m16s 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-01-15 00:09:15 Duration: 9m14s 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-01-13 00:09:33 Duration: 9m13s Database: ctdprd51 User: pubc Application: psql
19 7 52m25s 7m27s 7m30s 7m29s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 11 19 1 7m29s 7m29s Jan 12 19 1 7m29s 7m29s Jan 13 19 1 7m28s 7m28s Jan 14 19 1 7m27s 7m27s Jan 15 19 1 7m30s 7m30s Jan 16 19 1 7m28s 7m28s Jan 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 19:42:25 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
20 7 52m 7m23s 7m27s 7m25s copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 11 18 1 7m25s 7m25s Jan 12 18 1 7m25s 7m25s Jan 13 18 1 7m25s 7m25s Jan 14 18 1 7m23s 7m23s Jan 15 18 1 7m25s 7m25s Jan 16 18 1 7m26s 7m26s Jan 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-16 18:56:18 Duration: 7m26s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 18:56:18 Duration: 7m25s
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 26m9s 26m15s 26m12s 7 3h3m24s copy pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 11 19 1 26m9s 26m9s Jan 12 19 1 26m15s 26m15s Jan 13 19 1 26m12s 26m12s Jan 14 19 1 26m12s 26m12s Jan 15 19 1 26m9s 26m9s Jan 16 19 1 26m10s 26m10s Jan 17 19 1 26m14s 26m14s -
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 19:29:45 Duration: 26m15s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 19:29:58 Duration: 26m14s
-
COPY pub2.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 19:29:40 Duration: 26m12s
2 26m3s 26m19s 26m9s 7 3h3m4s copy pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 11 18 1 26m3s 26m3s Jan 12 18 1 26m11s 26m11s Jan 13 18 1 26m10s 26m10s Jan 14 18 1 26m9s 26m9s Jan 15 18 1 26m5s 26m5s Jan 16 18 1 26m4s 26m4s Jan 17 18 1 26m19s 26m19s -
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 18:43:46 Duration: 26m19s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 18:43:35 Duration: 26m11s
-
COPY pub1.gene_disease_reference (id, gene_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_chem_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-13 18:43:34 Duration: 26m10s
3 12m49s 14m33s 13m53s 4 55m33s select g.id geneid, g.acc_txt acc, g.nm nm, g.nm nmhtml, g.secondary_nm secondarynm, g.has_chems haschems, g.has_diseases hasdiseases, g.has_exposures hasexposures, g.has_phenotypes hasphenotypes, count(*) over () fullrowcount from term g where g.id in (( select gcri.gene_id from dag_path pi inner join gene_chem_reference gcri on pi.descendant_object_id = gcri.chem_id inner join term ti on ti.id = pi.ancestor_object_id where upper(ti.nm) like ? and ti.object_type_id = ?) intersect ( select gt.gene_id from dag_path dp inner join gene_taxon gt on dp.descendant_object_id = gt.taxon_id inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ? union select gcr.gene_id from dag_path dp inner join gene_chem_reference gcr on dp.descendant_object_id = gcr.taxon_id inner join dag_node n on n.id = dp.ancestor_dag_node_id where n.acc_txt = ? and n.dag_id = ?) intersect ( select gi.id gene_id from term gi where gi.object_type_id = ? and upper(gi.nm) like ?) intersect ( select ai.gene_id from dag_path pi inner join gene_go_annot ai on pi.descendant_object_id = ai.go_term_id inner join db_link dbli on dbli.object_id = pi.ancestor_object_id where dbli.acc_txt = ? and dbli.type_cd = ? and dbli.object_type_id = ?) intersect ( select gd.gene_id from term t inner join dag_path dp on t.id = dp.ancestor_object_id inner join gene_disease gd on dp.descendant_object_id = gd.disease_id where upper(t.nm) like ? and t.object_type_id = ? and gd.curated_reference_qty > ?)) order by g.nm_sort, g.id limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 13 00 1 12m49s 12m49s 04 3 42m43s 14m14s [ User: pubeu - Total duration: 55m33s - Times executed: 4 ]
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:03:07 Duration: 14m33s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:03:21 Duration: 14m28s Database: ctdprd51 User: pubeu Bind query: yes
-
SELECT /* AdvancedGeneQueryDAO.getData */ g.id geneId, g.acc_txt acc, g.nm nm, g.nm nmHtml, g.secondary_nm secondaryNm, g.has_chems hasChems, g.has_diseases hasDiseases, g.has_exposures hasExposures, g.has_phenotypes hasPhenotypes, COUNT(*) OVER () fullRowCount FROM term g WHERE g.id IN (( SELECT /* GAIQH.getChemWhereEquals.Name */ gcri.gene_id FROM dag_path pi INNER JOIN gene_chem_reference gcri ON pi.descendant_object_id = gcri.chem_id INNER JOIN term ti ON ti.id = pi.ancestor_object_id WHERE UPPER(ti.nm) LIKE 'BERBERINE' AND ti.object_type_id = 2) INTERSECT ( SELECT /* GAIQH.getTaxonWhereEquals.Acc */ gt.gene_id FROM dag_path dp INNER JOIN gene_taxon gt ON dp.descendant_object_id = gt.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7 UNION SELECT gcr.gene_id FROM dag_path dp INNER JOIN gene_chem_reference gcr ON dp.descendant_object_id = gcr.taxon_id INNER JOIN dag_node n ON n.id = dp.ancestor_dag_node_id WHERE n.acc_txt = '9606' AND n.dag_id = 7) INTERSECT ( SELECT /* GAIQH.getGeneWhereEquals.Name */ gi.id gene_id FROM term gi WHERE gi.object_type_id = 4 AND UPPER(gi.nm) LIKE 'OGT') INTERSECT ( SELECT /* IQH.getMasterGoWhereEquals.Gene */ ai.gene_id FROM dag_path pi INNER JOIN gene_go_annot ai ON pi.descendant_object_id = ai.go_term_id INNER JOIN db_link dbli ON dbli.object_id = pi.ancestor_object_id WHERE dbli.acc_txt = 'GO:0008150' AND dbli.type_cd = 'A' AND dbli.object_type_id = 5) INTERSECT ( SELECT /* IQH.getMasterDiseaseWhereEquals.Name.Gene */ gd.gene_id FROM term t INNER JOIN dag_path dp ON t.id = dp.ancestor_object_id INNER JOIN gene_disease gd ON dp.descendant_object_id = gd.disease_id WHERE UPPER(t.nm) LIKE 'NERVOUS SYSTEM DISEASES' AND t.object_type_id = 3 AND gd.curated_reference_qty > 0)) ORDER BY g.nm_sort, g.id LIMIT 50;
Date: 2026-01-13 04:01:01 Duration: 13m41s Database: ctdprd51 User: pubeu Bind query: yes
4 9m9s 9m16s 9m12s 7 1h4m28s select maint_query_logs_archive ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 11 00 1 9m11s 9m11s Jan 12 00 1 9m11s 9m11s Jan 13 00 1 9m13s 9m13s Jan 14 00 1 9m16s 9m16s Jan 15 00 1 9m14s 9m14s Jan 16 00 1 9m12s 9m12s Jan 17 00 1 9m9s 9m9s [ User: pubc - Total duration: 1h4m28s - Times executed: 7 ]
[ Application: psql - Total duration: 1h4m28s - Times executed: 7 ]
-
/* * 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-01-14 00:09:18 Duration: 9m16s 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-01-15 00:09:15 Duration: 9m14s 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-01-13 00:09:33 Duration: 9m13s Database: ctdprd51 User: pubc Application: psql
5 7m27s 7m30s 7m29s 7 52m25s copy pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 11 19 1 7m29s 7m29s Jan 12 19 1 7m29s 7m29s Jan 13 19 1 7m28s 7m28s Jan 14 19 1 7m27s 7m27s Jan 15 19 1 7m30s 7m30s Jan 16 19 1 7m28s 7m28s Jan 17 19 1 7m30s 7m30s -
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 19:42:54 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 19:42:25 Duration: 7m30s
-
COPY pub2.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 19:42:23 Duration: 7m29s
6 7m23s 7m27s 7m25s 7 52m copy pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 11 18 1 7m25s 7m25s Jan 12 18 1 7m25s 7m25s Jan 13 18 1 7m25s 7m25s Jan 14 18 1 7m23s 7m23s Jan 15 18 1 7m25s 7m25s Jan 16 18 1 7m26s 7m26s Jan 17 18 1 7m27s 7m27s -
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-17 18:56:38 Duration: 7m27s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-16 18:56:18 Duration: 7m26s
-
COPY pub1.term_enrichment_agent (term_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-15 18:56:18 Duration: 7m25s
7 1m49s 2m7s 1m51s 27 50m4s 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 #7
Day Hour Count Duration Avg duration Jan 11 19 1 1m49s 1m49s Jan 12 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 13 06 1 2m7s 2m7s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m52s 1m52s 19 1 1m50s 1m50s Jan 14 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m50s 1m50s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 15 06 1 1m51s 1m51s 10 1 1m51s 1m51s 14 1 1m50s 1m50s 18 1 1m50s 1m50s 19 1 1m49s 1m49s Jan 16 06 1 1m50s 1m50s 10 1 1m50s 1m50s 14 1 1m51s 1m51s 18 1 1m51s 1m51s 19 1 1m49s 1m49s Jan 17 19 1 1m50s 1m50s [ User: postgres - Total duration: 37m15s - Times executed: 20 ]
[ Application: pg_dump - Total duration: 37m15s - Times executed: 20 ]
-
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-01-13 06:07:08 Duration: 2m7s 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-01-13 18:06:54 Duration: 1m52s 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-01-14 18:06:53 Duration: 1m51s Database: ctdprd51 User: postgres Application: pg_dump
8 1m40s 1m41s 1m40s 7 11m46s copy pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 11 19 1 1m40s 1m40s Jan 12 19 1 1m41s 1m41s Jan 13 19 1 1m41s 1m41s Jan 14 19 1 1m40s 1m40s Jan 15 19 1 1m40s 1m40s Jan 16 19 1 1m41s 1m41s Jan 17 19 1 1m40s 1m40s -
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-12 19:33:12 Duration: 1m41s
-
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-16 19:33:00 Duration: 1m41s
-
COPY pub2.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-13 19:33:06 Duration: 1m41s
9 1m39s 1m40s 1m40s 7 11m40s copy pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 11 18 1 1m39s 1m39s Jan 12 18 1 1m40s 1m40s Jan 13 18 1 1m40s 1m40s Jan 14 18 1 1m40s 1m40s Jan 15 18 1 1m39s 1m39s Jan 16 18 1 1m40s 1m40s Jan 17 18 1 1m40s 1m40s -
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-17 18:47:11 Duration: 1m40s
-
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-13 18:46:59 Duration: 1m40s
-
COPY pub1.phenotype_term_reference (id, phenotype_id, term_id, term_object_type_id, reference_id, taxon_id, ixn_id, evidence_cd, source_cd, source_acc_txt, source_acc_db_id, term_reference_id, via_term_id, via_term_object_type_id, network_score, mod_tm) TO stdout;
Date: 2026-01-12 18:47:00 Duration: 1m40s
10 1m22s 1m23s 1m23s 7 9m41s copy pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 11 18 1 1m23s 1m23s Jan 12 18 1 1m23s 1m23s Jan 13 18 1 1m22s 1m22s Jan 14 18 1 1m22s 1m22s Jan 15 18 1 1m22s 1m22s Jan 16 18 1 1m23s 1m23s Jan 17 18 1 1m23s 1m23s -
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-11 18:58:07 Duration: 1m23s
-
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-16 18:58:08 Duration: 1m23s
-
COPY pub1.term_set_enrichment_agent (term_ids_digest, enriched_object_type_id, enriched_term_id, agent_term_id) TO stdout;
Date: 2026-01-12 18:58:15 Duration: 1m23s
11 1m12s 1m12s 1m12s 7 8m28s copy pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 11 19 1 1m12s 1m12s Jan 12 19 1 1m12s 1m12s Jan 13 19 1 1m12s 1m12s Jan 14 19 1 1m12s 1m12s Jan 15 19 1 1m12s 1m12s Jan 16 19 1 1m12s 1m12s Jan 17 19 1 1m12s 1m12s -
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-17 19:01:23 Duration: 1m12s
-
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-13 19:01:07 Duration: 1m12s
-
COPY pub2.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-12 19:01:10 Duration: 1m12s
12 1m11s 1m12s 1m12s 7 8m25s copy pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 11 18 1 1m11s 1m11s Jan 12 18 1 1m11s 1m11s Jan 13 18 1 1m12s 1m12s Jan 14 18 1 1m12s 1m12s Jan 15 18 1 1m11s 1m11s Jan 16 18 1 1m12s 1m12s Jan 17 18 1 1m12s 1m12s -
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-13 18:15:05 Duration: 1m12s
-
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-17 18:15:06 Duration: 1m12s
-
COPY pub1.dag_path (id, ancestor_dag_node_id, descendant_dag_node_id, ancestor_object_id, descendant_object_id, path_length, enumeration_txt) TO stdout;
Date: 2026-01-16 18:15:04 Duration: 1m12s
13 1m4s 1m4s 1m4s 7 7m31s copy pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 11 18 1 1m4s 1m4s Jan 12 18 1 1m4s 1m4s Jan 13 18 1 1m4s 1m4s Jan 14 18 1 1m4s 1m4s Jan 15 18 1 1m4s 1m4s Jan 16 18 1 1m4s 1m4s Jan 17 18 1 1m4s 1m4s -
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-17 18:16:12 Duration: 1m4s
-
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-14 18:16:10 Duration: 1m4s
-
COPY pub1.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-13 18:16:10 Duration: 1m4s
14 1m3s 1m4s 1m4s 7 7m30s copy pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 11 19 1 1m4s 1m4s Jan 12 19 1 1m4s 1m4s Jan 13 19 1 1m4s 1m4s Jan 14 19 1 1m3s 1m3s Jan 15 19 1 1m4s 1m4s Jan 16 19 1 1m4s 1m4s Jan 17 19 1 1m4s 1m4s -
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-17 19:02:28 Duration: 1m4s
-
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-13 19:02:12 Duration: 1m4s
-
COPY pub2.dag_path_step (dag_path_id, step_no, dag_node_id, dag_edge_type_id) TO stdout;
Date: 2026-01-16 19:02:08 Duration: 1m4s
15 54s93ms 54s565ms 54s276ms 7 6m19s copy pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 11 18 1 54s305ms 54s305ms Jan 12 18 1 54s376ms 54s376ms Jan 13 18 1 54s194ms 54s194ms Jan 14 18 1 54s245ms 54s245ms Jan 15 18 1 54s155ms 54s155ms Jan 16 18 1 54s93ms 54s93ms Jan 17 18 1 54s565ms 54s565ms -
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-17 18:13:45 Duration: 54s565ms
-
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-12 18:13:44 Duration: 54s376ms
-
COPY pub1.chem_disease_reference (id, chem_id, disease_id, reference_id, source_acc_txt, source_acc_db_id, via_gene_id, ixn_id, network_score, source_cd, mod_tm) TO stdout;
Date: 2026-01-11 18:13:45 Duration: 54s305ms
16 6s105ms 38s746ms 24s927ms 8 3m19s 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 #16
Day Hour Count Duration Avg duration Jan 12 21 1 36s547ms 36s547ms Jan 15 02 4 49s387ms 12s346ms Jan 16 02 3 1m53s 37s829ms [ User: pubeu - Total duration: 3m19s - Times executed: 8 ]
-
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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-16 02:48:18 Duration: 38s746ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-16 02:49:19 Duration: 38s707ms 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 = '2126896') ORDER BY actionTypes, gd.network_score DESC NULLS LAST, g.nm_sort, d.nm_sort;
Date: 2026-01-12 21:56:37 Duration: 36s547ms Database: ctdprd51 User: pubeu Bind query: yes
17 23s482ms 24s68ms 23s795ms 27 10m42s 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 #17
Day Hour Count Duration Avg duration Jan 11 19 1 23s631ms 23s631ms Jan 12 06 1 23s869ms 23s869ms 10 1 23s691ms 23s691ms 14 1 23s920ms 23s920ms 18 1 23s789ms 23s789ms 19 1 23s655ms 23s655ms Jan 13 06 1 23s767ms 23s767ms 10 1 23s782ms 23s782ms 14 1 24s68ms 24s68ms 18 1 24s7ms 24s7ms 19 1 23s658ms 23s658ms Jan 14 06 1 23s992ms 23s992ms 10 1 23s904ms 23s904ms 14 1 23s836ms 23s836ms 18 1 23s731ms 23s731ms 19 1 23s482ms 23s482ms Jan 15 06 1 23s777ms 23s777ms 10 1 23s920ms 23s920ms 14 1 23s798ms 23s798ms 18 1 23s727ms 23s727ms 19 1 23s678ms 23s678ms Jan 16 06 1 23s788ms 23s788ms 10 1 23s808ms 23s808ms 14 1 23s863ms 23s863ms 18 1 23s885ms 23s885ms 19 1 23s703ms 23s703ms Jan 17 19 1 23s734ms 23s734ms -
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-01-13 14:07:16 Duration: 24s68ms
-
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-01-13 18:07:18 Duration: 24s7ms
-
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-01-14 06:07:17 Duration: 23s992ms
18 17s819ms 24s131ms 18s177ms 27 8m10s 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 Jan 11 18 1 18s19ms 18s19ms Jan 12 06 1 17s834ms 17s834ms 10 1 17s855ms 17s855ms 14 1 18s51ms 18s51ms 18 2 35s959ms 17s979ms Jan 13 06 1 24s131ms 24s131ms 10 1 18s 18s 14 1 18s59ms 18s59ms 18 2 35s956ms 17s978ms Jan 14 06 1 17s938ms 17s938ms 10 1 17s960ms 17s960ms 14 1 17s943ms 17s943ms 18 2 35s969ms 17s984ms Jan 15 06 1 17s919ms 17s919ms 10 1 18s23ms 18s23ms 14 1 18s64ms 18s64ms 18 2 35s760ms 17s880ms Jan 16 06 1 17s861ms 17s861ms 10 1 17s894ms 17s894ms 14 1 17s984ms 17s984ms 18 2 35s728ms 17s864ms Jan 17 18 1 17s868ms 17s868ms [ User: postgres - Total duration: 8m10s - Times executed: 27 ]
[ Application: pg_dump - Total duration: 8m10s - Times executed: 27 ]
-
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-01-13 06:00:31 Duration: 24s131ms 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-01-12 18:00:20 Duration: 18s106ms 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-01-13 18:00:20 Duration: 18s97ms Database: ctdprd51 User: postgres Application: pg_dump
19 15s215ms 15s662ms 15s423ms 27 6m56s 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 #19
Day Hour Count Duration Avg duration Jan 11 19 1 15s314ms 15s314ms Jan 12 06 1 15s576ms 15s576ms 10 1 15s369ms 15s369ms 14 1 15s415ms 15s415ms 18 1 15s396ms 15s396ms 19 1 15s332ms 15s332ms Jan 13 06 1 15s441ms 15s441ms 10 1 15s376ms 15s376ms 14 1 15s662ms 15s662ms 18 1 15s485ms 15s485ms 19 1 15s381ms 15s381ms Jan 14 06 1 15s545ms 15s545ms 10 1 15s419ms 15s419ms 14 1 15s447ms 15s447ms 18 1 15s417ms 15s417ms 19 1 15s215ms 15s215ms Jan 15 06 1 15s431ms 15s431ms 10 1 15s433ms 15s433ms 14 1 15s529ms 15s529ms 18 1 15s453ms 15s453ms 19 1 15s329ms 15s329ms Jan 16 06 1 15s365ms 15s365ms 10 1 15s423ms 15s423ms 14 1 15s480ms 15s480ms 18 1 15s490ms 15s490ms 19 1 15s391ms 15s391ms Jan 17 19 1 15s319ms 15s319ms -
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-01-13 14:07:32 Duration: 15s662ms
-
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-01-12 06:07:32 Duration: 15s576ms
-
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-01-14 06:07:32 Duration: 15s545ms
20 14s422ms 14s625ms 14s508ms 27 6m31s 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 #20
Day Hour Count Duration Avg duration Jan 11 18 1 14s527ms 14s527ms Jan 12 06 1 14s528ms 14s528ms 10 1 14s542ms 14s542ms 14 1 14s508ms 14s508ms 18 2 29s56ms 14s528ms Jan 13 06 1 14s545ms 14s545ms 10 1 14s434ms 14s434ms 14 1 14s518ms 14s518ms 18 2 29s161ms 14s580ms Jan 14 06 1 14s625ms 14s625ms 10 1 14s423ms 14s423ms 14 1 14s509ms 14s509ms 18 2 28s932ms 14s466ms Jan 15 06 1 14s513ms 14s513ms 10 1 14s422ms 14s422ms 14 1 14s568ms 14s568ms 18 2 28s931ms 14s465ms Jan 16 06 1 14s462ms 14s462ms 10 1 14s534ms 14s534ms 14 1 14s525ms 14s525ms 18 2 28s924ms 14s462ms Jan 17 18 1 14s539ms 14s539ms -
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-01-14 06:00:50 Duration: 14s625ms
-
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-01-13 18:00:50 Duration: 14s624ms
-
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-01-15 14:00:50 Duration: 14s568ms
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
- 74,987 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 31 FATAL entries
- 34 ERROR entries
- 3 WARNING entries
- 60 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 31 Max number of times the same event was reported
- 128 Total events found
Rank Times reported Error 1 31 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 12 17 8 Jan 13 04 7 05 5 08 1 13 4 Jan 14 09 6 - ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
- 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-01-12 17:44:07
Statement: SELECT count(*) FROM pg_catalog.pg_stat_all_tables WHERE (n_dead_tup/(n_live_tup+n_dead_tup)::float8) > 0.2 AND (n_live_tup+n_dead_tup) > 50;
Date: 2026-01-12 17:44:21 Database: postgres Application: User: zbx_monitor Remote:
Statement: SELECT row_to_json (T) FROM ( SELECT sum(numbackends) as numbackends , sum(xact_commit) as xact_commit , sum(xact_rollback) as xact_rollback , sum(blks_read) as blks_read , sum(blks_hit) as blks_hit , sum(tup_returned) as tup_returned , sum(tup_fetched) as tup_fetched , sum(tup_inserted) as tup_inserted , sum(tup_updated) as tup_updated , sum(tup_deleted) as tup_deleted , sum(conflicts) as conflicts , sum(temp_files) as temp_files , sum(temp_bytes) as temp_bytes , sum(deadlocks) as deadlocks , sum(COALESCE(checksum_failures, 0)) as checksum_failures , sum(blk_read_time) as blk_read_time , sum(blk_write_time) as blk_write_time FROM pg_catalog.pg_stat_database ) T ;
Date: 2026-01-12 17:44:21
2 29 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 12 17 8 Jan 13 04 7 05 5 08 1 13 2 Jan 14 09 6 3 27 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 12 17 8 Jan 13 04 4 05 5 08 1 13 3 Jan 14 09 6 4 22 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 11 14 4 Jan 13 12 3 13 2 18 1 19 4 20 5 Jan 14 18 3 5 9 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 15 02 5 10 4 6 3 WARNING: is not a PostgreSQL server process
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 14 09 2 10 1 7 2 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 15 02 1 Jan 16 02 1 8 2 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #8
Day Hour Count Jan 15 08 2 - 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-01-15 08:00:31 Database: ctdprd51 Application: User: pubeu Remote:
9 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jan 12 02 2 - ERROR: syntax error at or near ")" at character 4810
Statement: select distinct e.reference_acc_txt as "Reference", pref.abbr_authors_txt as "Author", referenceExp.author_summary as "AuthorSummary", (Select STRING_AGG( distinct eventproject.project_nm, '|')) as "AssociatedStudyTitles", eevent.collection_start_yr as "EnrollmentStartYear", eevent.collection_end_yr as "EnrollmentEndYear", (Select STRING_AGG( distinct studyFactor.nm, '|')) as "StudyFactors", (Select STRING_AGG(distinct stressorSrcType.nm, '|')) as "StressorSourceCategory", stressor.chem_term_nm as "ExposureStressorName", stressor.src_details as "StressorSourceDetails", stressor.sample_qty as "NumberOfStressorSamples", stressor.note as "StressorNotes", ereceptor.qty as "NumberOfReceptors", ereceptor.description as "Receptors", ereceptor.term_nm as "ReceptorDescription", ereceptor.term_acc_txt as "ReceptorID", ereceptor.note as "ReceptorNotes", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(receptorTobaccoUse.pct as int),0)) || '% ' || tobaccoUse.nm, COALESCE(COALESCE(NULLIF(CAST(receptorTobaccoUse.pct as int),0)) || '% ' , tobaccoUse.nm)), '|')) as "SmokingStatus", ereceptor.age || ' ' || age_uom.nm as "Age", age_qualifier.nm as "AgeQualifier", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(pct as int),0)) || '% ' || gender.nm, COALESCE(COALESCE(NULLIF(CAST(pct as int),0)) || '% ' , gender.nm)), '|') from exp_receptor_gender expgender left outer join gender on expgender.gender_id=gender.id where exp_receptor_id = ereceptor.id ) as "Sex", (Select STRING_AGG(distinct COALESCE( COALESCE(NULLIF(CAST(receptorRace.pct as int),0)) || '% ' || race.nm, COALESCE(COALESCE(NULLIF(CAST(receptorRace.pct as int),0)) || '% ' , race.nm)), '|')) as "Race", (Select STRING_AGG( distinct eventAssayMethod.nm, '|')) as "Methods" , eevent.detection_limit as "DetectionLimit", eevent.detection_limit_uom as "DetectionLimitUnitsOfMeasurement", eevent.detection_freq as "DetectionFrequency", emedium.nm as "Medium", eevent.exp_marker_term_nm as "ExposureMarker", eevent.exp_marker_lvl as "MarkerLevel", eevent.assay_uom as "MarkerUnitsOfMeasurement", eevent.assay_measurement_stat as "MarkerMeasurementStatistic", eevent.assay_note as "AssayNotes", (Select STRING_AGG( distinct country.nm, '|')) as "StudyCountries", (Select STRING_AGG( distinct eventLocation.geographic_region_nm, '|')) as "StateOrProvince", (Select STRING_AGG( distinct eventLocation.locality_txt, '|')) as "CityTownRegionOrArea", eevent.note as "ExposureEventNotes", eiot.description as "OutcomeRelationship", outcome.disease_term_nm as "DiseaseName", outcome.phenotype_action_degree_type_nm as "PhenotypeActionDegreeType", outcome.phenotype_term_nm as "PhenotypeName", (Select STRING_AGG( distinct expAnatomy.anatomy_term_nm, '|')) as "Anatomy", outcome.note as "ExposureOutcomeNotes" from exposure e left outer join reference pref on pref.acc_txt = e.reference_acc_txt left outer join reference_exp referenceExp on referenceExp.reference_acc_txt = e.reference_acc_txt left outer join exp_study_factor expStudyFactor on referenceExp.id = expStudyFactor.reference_exp_id left outer join study_factor studyFactor on studyFactor.id = expStudyFactor.study_factor_id left outer join exp_event_project eventproject on eventproject.exp_event_id = e.exp_event_id inner join exp_stressor stressor on e.exp_stressor_id = stressor.id left outer join exp_receptor ereceptor on e.exp_receptor_id = ereceptor.id left outer join age_uom age_uom on ereceptor.age_uom_id = age_uom.id left outer join age_qualifier age_qualifier on ereceptor.age_qualifier_id = age_qualifier.id left outer join exp_event eevent on e.exp_event_id = eevent.id left outer join medium emedium on eevent.medium_id = emedium.id left outer join exp_stressor_stressor_src esss on stressor.id = esss.exp_stressor_id left outer join exp_stressor_src_type stressorSrcType on esss.exp_stressor_src_type_id = stressorSrcType.id left outer join exp_receptor_tobacco_use receptorTobaccoUse on ereceptor.id = receptorTobaccoUse.exp_receptor_id left outer join tobacco_use tobaccoUse on receptorTobaccoUse.tobacco_use_id = tobaccoUse.id left outer join exp_receptor_race receptorRace on ereceptor.id = receptorRace.exp_receptor_id left outer join race race on receptorRace.race_id = race.id left outer join exp_event_location eventLocation on eevent.id = eventLocation.exp_event_id left outer join country on eventLocation.country_id = country.id left outer join exp_outcome outcome on e.exp_outcome_id = outcome.id left outer join exp_outcome_ixn_type eiot on outcome.exp_outcome_ixn_type_id = eiot.id left outer join exp_anatomy expAnatomy on outcome.id = expAnatomy.exp_outcome_id left outer join exp_event_assay_method eventAssayMethod on eevent.id = eventAssayMethod.exp_event_id where ereceptor.term_acc_txt in (select acc_txt from term where id in )) or eevent.exp_marker_acc_txt in (select acc_txt from term where id in )) group by "Reference", "Author", "AuthorSummary", "EnrollmentStartYear", "EnrollmentEndYear", "ExposureStressorName", "StressorSourceDetails", "NumberOfStressorSamples", "StressorNotes", "NumberOfReceptors", "Receptors", "ReceptorDescription", "ReceptorID", "ReceptorNotes", "Age", "AgeQualifier", "DetectionLimit", "DetectionLimitUnitsOfMeasurement", "DetectionFrequency", "Medium", "ExposureMarker", "MarkerLevel", "MarkerUnitsOfMeasurement", "MarkerMeasurementStatistic", "AssayNotes", "ExposureEventNotes", "OutcomeRelationship", "DiseaseName", "PhenotypeActionDegreeType", "PhenotypeName", "ExposureOutcomeNotes", ereceptor.id, eventLocation.exp_event_id ;
Date: 2026-01-12 02:01:59 Database: ctdprd51 Application: User: pubeu Remote:
10 1 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jan 13 17 1 - ERROR: relation "cc_reference_curation" does not exist at character 17
Statement: select * from cc_reference_curation
Date: 2026-01-13 17:05:46 Database: ctdprd51 Application: pgAdmin 4 - CONN:8160214 User: pub2 Remote: