pgBadger-
Global information
- Generated on Mon Nov 10 09:35:57 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=08/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=08/h=23/m=00/PT1H.log
- Parsed 30,013 log entries in 1m3s
- Log start from 2025-11-03 09:05:04 to 2025-11-08 18:01:12
-
Overview
Global Stats
- 96 Number of unique normalized queries
- 353 Number of queries
- 1h49m50s Total query duration
- 2025-11-03 07:15:41 First query
- 2025-11-08 01:00:57 Last query
- 4 queries/s at 2025-11-07 20:50:13 Query peak
- 1h49m50s Total query duration
- 5s679ms Prepare/parse total duration
- 6s148ms Bind total duration
- 1h49m38s Execute total duration
- 5,292 Number of events
- 55 Number of unique normalized events
- 4,669 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 939 Number temporary file
- 1.41 GiB Max size of temporary file
- 17.81 MiB Average size of temporary file
- 5,917 Total number of sessions
- 158 sessions at 2025-11-08 16:59:29 Session peak
- 26d9h40m20s Total duration of sessions
- 6m25s Average duration of sessions
- 0 Average queries per session
- 1s113ms Average queries duration per session
- 6m24s Average idle time per session
- 5,908 Total number of connections
- 19 connections/s at 2025-11-05 14:44:27 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-07 20:50:13 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-06 07:56:16 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-07 20:50:13 Date
Queries duration
Key values
- 1h49m50s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 23 0ms 12s325ms 7s638ms 23s195ms 43s748ms 45s647ms 08 6 0ms 8s496ms 6s816ms 0ms 5s600ms 35s301ms 09 11 0ms 3m24s 46s871ms 10s241ms 49s738ms 3m24s 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 1 0ms 1m30s 1m30s 0ms 0ms 1m30s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 7 0ms 7s442ms 6s100ms 0ms 17s676ms 18s881ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 6s490ms 6s490ms 0ms 0ms 6s490ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 13 0ms 9s422ms 7s383ms 0ms 24s695ms 54s467ms 08 10 0ms 15s900ms 8s554ms 0ms 18s976ms 49s708ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 1 0ms 6s979ms 6s979ms 0ms 0ms 6s979ms 13 5 0ms 3m14s 59s9ms 0ms 11s837ms 4m9s 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 5 0ms 3m45s 55s341ms 0ms 14s185ms 3m45s 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 34 0ms 2m6s 20s226ms 2m5s 2m6s 2m39s 20 6 0ms 6s662ms 5s846ms 0ms 0ms 35s76ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 5s98ms 5s98ms 0ms 0ms 5s98ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 5 0ms 6s384ms 5s844ms 0ms 12s741ms 16s481ms 08 2 0ms 6s977ms 6s942ms 0ms 6s908ms 6s977ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 3 0ms 10s371ms 7s515ms 5s110ms 7s65ms 10s371ms 11 6 0ms 3m26s 43s981ms 5s602ms 34s13ms 3m26s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 40 0ms 2m50s 19s878ms 2m6s 2m31s 2m50s 20 12 0ms 11s547ms 7s32ms 12s773ms 25s257ms 46s362ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 6s342ms 6s342ms 0ms 0ms 6s342ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 15 0ms 9s414ms 6s594ms 16s828ms 17s718ms 52s417ms 08 11 0ms 5s943ms 5s466ms 5s667ms 10s400ms 33s943ms 09 1 0ms 5s588ms 5s588ms 0ms 0ms 5s588ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 12 0ms 3m21s 50s61ms 40s35ms 3m21s 4m16s 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 6 0ms 2m49s 42s449ms 20s472ms 55s333ms 2m49s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 35 0ms 1m46s 19s37ms 2m10s 3m5s 3m5s 20 2 0ms 6s677ms 6s500ms 0ms 6s324ms 6s677ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 07 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 5s939ms 5s939ms 0ms 0ms 5s939ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 13 0ms 9s163ms 7s320ms 9s163ms 25s318ms 39s279ms 08 10 0ms 6s821ms 6s277ms 0ms 18s194ms 44s583ms 09 2 0ms 6s918ms 6s14ms 0ms 5s109ms 6s918ms 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 6 0ms 3m17s 1m5s 5s30ms 10s526ms 5m22s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 37 0ms 1m54s 17s770ms 1m40s 1m54s 2m49s 20 8 0ms 12s733ms 9s262ms 7s971ms 20s81ms 46s44ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 08 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 5s790ms 5s790ms 0ms 5s790ms 5s790ms 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 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 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 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0 0ms 0ms 0ms 0ms 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 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 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 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 03 00 0 0 0ms 0ms 0ms 0ms 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 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 5 0 5s829ms 0ms 0ms 7s430ms 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 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 04 00 0 0 0ms 0ms 0ms 0ms 01 1 0 6s490ms 0ms 0ms 6s490ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 6s979ms 0ms 0ms 6s979ms 13 1 0 6s223ms 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 2 0 7s92ms 0ms 0ms 14s185ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 05 00 0 0 0ms 0ms 0ms 0ms 01 1 0 5s98ms 0ms 0ms 5s98ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 1 0 7s65ms 0ms 0ms 7s65ms 11 4 0 5s861ms 0ms 0ms 17s843ms 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 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 06 00 0 0 0ms 0ms 0ms 0ms 01 1 0 6s342ms 0ms 0ms 6s342ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 3 0 8s671ms 0ms 0ms 26s13ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 5 0 6s988ms 0ms 6s927ms 7s277ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 3 0 6s824ms 0ms 0ms 20s472ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 07 00 0 0 0ms 0ms 0ms 0ms 01 1 0 5s939ms 0ms 0ms 5s939ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 2 0 7s97ms 0ms 0ms 14s195ms 08 1 0 6s227ms 0ms 0ms 6s227ms 09 1 0 5s109ms 0ms 0ms 5s109ms 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 2 0 6s25ms 0ms 0ms 7s21ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 08 00 0 0 0ms 0ms 0ms 0ms 01 1 0 5s790ms 0ms 0ms 5s790ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 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 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 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 Nov 03 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 2 0 0 8s327ms 0ms 0ms 7s961ms 08 0 0 1 0 7s735ms 0ms 0ms 0ms 09 0 0 2 0 41s306ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 1 0 0 1m30s 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 Nov 04 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 2 0 0 0 10s456ms 0ms 0ms 5s12ms 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 1 0 27s412ms 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 1 0 27s893ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 6 30s484ms 0ms 0ms 59s179ms 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 Nov 05 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 1 0 0 5s52ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 5s110ms 0ms 0ms 0ms 11 0 0 1 0 34s13ms 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 7 26s985ms 0ms 8s626ms 38s857ms 20 2 0 0 0 8s437ms 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 Nov 06 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 1 1 0 0 8s3ms 0ms 0ms 6s600ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 1 0 5s588ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 3 0 1m3s 0ms 0ms 57s284ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 1 0 55s333ms 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 6 30s473ms 0ms 8s502ms 1m41s 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 Nov 07 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 1 1 0 0 8s637ms 0ms 0ms 8s112ms 08 0 0 1 0 6s229ms 0ms 0ms 6s229ms 09 0 0 1 0 6s918ms 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 1 1 0 1m25s 0ms 0ms 45s398ms 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 6 30s163ms 0ms 0ms 54s290ms 20 1 0 0 0 12s733ms 0ms 0ms 12s733ms 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 Nov 08 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 Nov 02 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 0 0.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 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% Nov 03 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 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 23 23.00 0.00% 08 0 6 6.00 0.00% 09 0 11 11.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 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 7 7.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 04 00 0 0 0.00 0.00% 01 0 1 1.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 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 13 13.00 0.00% 08 0 10 10.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 1 1.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 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 6 6.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 05 00 0 0 0.00 0.00% 01 0 1 1.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 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 5 5.00 0.00% 08 0 2 2.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.00 0.00% 11 0 6 6.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 12 12.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 06 00 0 0 0.00 0.00% 01 0 1 1.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 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 15 15.00 0.00% 08 1 11 11.00 9.09% 09 0 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 12 12.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 6 6.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 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 07 00 0 0 0.00 0.00% 01 0 1 1.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 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 13 13.00 0.00% 08 0 10 10.00 0.00% 09 0 2 2.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 6 6.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 8 8.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 08 00 0 0 0.00 0.00% 01 0 1 1.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 0 0.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 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% Day Hour Count Average / Second Nov 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Nov 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 28 0.01/s 07 37 0.01/s 08 49 0.01/s 09 84 0.02/s 10 87 0.02/s 11 44 0.01/s 12 45 0.01/s 13 83 0.02/s 14 38 0.01/s 15 58 0.02/s 16 74 0.02/s 17 53 0.01/s 18 42 0.01/s 19 49 0.01/s 20 38 0.01/s 21 39 0.01/s 22 44 0.01/s 23 51 0.01/s Nov 04 00 43 0.01/s 01 41 0.01/s 02 54 0.01/s 03 40 0.01/s 04 49 0.01/s 05 39 0.01/s 06 47 0.01/s 07 43 0.01/s 08 44 0.01/s 09 51 0.01/s 10 101 0.03/s 11 67 0.02/s 12 65 0.02/s 13 123 0.03/s 14 85 0.02/s 15 92 0.03/s 16 153 0.04/s 17 44 0.01/s 18 37 0.01/s 19 61 0.02/s 20 38 0.01/s 21 48 0.01/s 22 44 0.01/s 23 58 0.02/s Nov 05 00 32 0.01/s 01 38 0.01/s 02 49 0.01/s 03 45 0.01/s 04 42 0.01/s 05 34 0.01/s 06 34 0.01/s 07 52 0.01/s 08 38 0.01/s 09 44 0.01/s 10 46 0.01/s 11 44 0.01/s 12 31 0.01/s 13 36 0.01/s 14 79 0.02/s 15 66 0.02/s 16 36 0.01/s 17 21 0.01/s 18 31 0.01/s 19 65 0.02/s 20 31 0.01/s 21 33 0.01/s 22 38 0.01/s 23 20 0.01/s Nov 06 00 20 0.01/s 01 28 0.01/s 02 17 0.00/s 03 31 0.01/s 04 17 0.00/s 05 23 0.01/s 06 30 0.01/s 07 37 0.01/s 08 60 0.02/s 09 67 0.02/s 10 59 0.02/s 11 43 0.01/s 12 29 0.01/s 13 52 0.01/s 14 49 0.01/s 15 42 0.01/s 16 24 0.01/s 17 19 0.01/s 18 14 0.00/s 19 54 0.01/s 20 38 0.01/s 21 30 0.01/s 22 26 0.01/s 23 42 0.01/s Nov 07 00 30 0.01/s 01 36 0.01/s 02 30 0.01/s 03 38 0.01/s 04 37 0.01/s 05 39 0.01/s 06 15 0.00/s 07 37 0.01/s 08 43 0.01/s 09 74 0.02/s 10 84 0.02/s 11 90 0.03/s 12 60 0.02/s 13 53 0.01/s 14 119 0.03/s 15 52 0.01/s 16 60 0.02/s 17 43 0.01/s 18 29 0.01/s 19 62 0.02/s 20 20 0.01/s 21 30 0.01/s 22 27 0.01/s 23 21 0.01/s Nov 08 00 29 0.01/s 01 33 0.01/s 02 16 0.00/s 03 18 0.01/s 04 28 0.01/s 05 30 0.01/s 06 26 0.01/s 07 25 0.01/s 08 23 0.01/s 09 31 0.01/s 10 23 0.01/s 11 23 0.01/s 12 16 0.00/s 13 26 0.01/s 14 25 0.01/s 15 23 0.01/s 16 25 0.01/s 17 32 0.01/s 18 6 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 02 00 2 75ms 75ms 01 2 76ms 76ms 02 2 79ms 79ms 03 2 74ms 74ms 04 2 75ms 75ms 05 2 74ms 74ms 06 2 78ms 78ms 07 2 74ms 74ms 08 2 76ms 76ms 09 2 73ms 73ms 10 2 74ms 74ms 11 2 72ms 72ms 12 2 77ms 77ms 13 2 114ms 114ms 14 2 73ms 73ms 15 2 77ms 77ms 16 2 82ms 82ms 17 2 85ms 85ms 18 2 79ms 79ms 19 2 74ms 74ms 20 2 81ms 81ms 21 2 74ms 74ms 22 2 73ms 73ms 23 2 73ms 73ms Nov 03 00 2 72ms 72ms 01 2 75ms 75ms 02 2 76ms 76ms 03 2 74ms 74ms 04 2 72ms 72ms 05 2 75ms 75ms 06 24 2m17s 2m17s 07 36 2m32s 2m27s 08 41 2m28s 2m27s 09 91 2m52s 2m46s 10 79 2m29s 2m29s 11 50 3m24s 3m23s 12 48 8m45s 8m45s 13 82 5m51s 5m51s 14 38 4m23s 4m23s 15 56 8m42s 8m42s 16 80 2m4s 2m4s 17 52 1m42s 1m42s 18 41 35m22s 35m22s 19 50 1m50s 1m50s 20 38 2m37s 2m36s 21 40 2m18s 2m18s 22 43 2m2s 2m2s 23 51 1m53s 1m53s Nov 04 00 43 2m2s 2m2s 01 39 2m16s 2m16s 02 53 1m43s 1m43s 03 44 1m58s 1m58s 04 48 1m56s 1m56s 05 40 2m14s 2m14s 06 46 1m50s 1m50s 07 44 2m17s 2m15s 08 45 2m25s 2m24s 09 52 1m47s 1m47s 10 93 1m14s 1m14s 11 70 2m51s 2m51s 12 57 4m21s 4m20s 13 122 24m44s 24m41s 14 88 3m36s 3m36s 15 96 14m57s 14m57s 16 155 3m13s 3m13s 17 48 2m28s 2m23s 18 37 9m27s 9m27s 19 58 3m47s 3m35s 20 40 2m4s 2m3s 21 49 3m4s 3m4s 22 44 2m19s 2m19s 23 54 1m53s 1m53s Nov 05 00 36 2m28s 2m28s 01 38 3m3s 3m2s 02 49 2m34s 2m34s 03 41 2m28s 2m28s 04 46 2m32s 2m32s 05 34 2m34s 2m34s 06 34 2m51s 2m51s 07 51 2m16s 2m16s 08 39 2m57s 2m57s 09 44 2m55s 2m55s 10 40 2m47s 2m47s 11 43 4m4s 3m57s 12 33 10m57s 10m57s 13 40 3m35s 3m35s 14 71 2m52s 2m52s 15 65 4m6s 4m6s 16 46 19m1s 19m1s 17 21 1m19s 1m19s 18 31 1h29m16s 1h29m16s 19 65 3m13s 3m 20 34 2m2s 2m 21 33 4m3s 4m3s 22 38 2m12s 2m12s 23 20 1m14s 1m14s Nov 06 00 20 6m27s 6m27s 01 28 3m14s 3m14s 02 17 5m47s 5m47s 03 29 2m33s 2m33s 04 19 5m 5m 05 23 3m28s 3m28s 06 30 3m21s 3m21s 07 36 2m44s 2m41s 08 54 3m4s 3m3s 09 69 3m30s 3m30s 10 57 4m5s 4m5s 11 48 9m49s 9m36s 12 29 2m56s 2m56s 13 46 2m38s 2m38s 14 54 2m55s 2m50s 15 45 24m15s 24m15s 16 24 3m22s 3m22s 17 19 3m27s 3m27s 18 14 3h12m26s 3h12m26s 19 51 4m53s 4m40s 20 40 2m49s 2m49s 21 29 2m54s 2m54s 22 28 2m58s 2m58s 23 42 2m25s 2m25s Nov 07 00 26 2m43s 2m43s 01 40 2m40s 2m40s 02 30 3m22s 3m22s 03 38 2m31s 2m31s 04 37 2m18s 2m18s 05 38 2m44s 2m44s 06 16 4m3s 4m3s 07 40 2m41s 2m39s 08 36 4m1s 4m 09 73 1m51s 1m51s 10 87 7m56s 7m56s 11 89 4m8s 4m8s 12 57 7m50s 7m50s 13 57 5m39s 5m39s 14 122 29m38s 29m34s 15 56 6m21s 6m21s 16 60 4m32s 4m32s 17 40 2m 2m 18 30 9m33s 9m33s 19 60 3m38s 3m27s 20 23 4m2s 3m59s 21 30 2m59s 2m59s 22 27 2m55s 2m55s 23 17 4m41s 4m41s Nov 08 00 33 2m53s 2m53s 01 30 2m50s 2m50s 02 19 3m45s 3m45s 03 18 4m37s 4m37s 04 28 1m58s 1m58s 05 25 3m43s 3m43s 06 31 2m50s 2m50s 07 21 3m37s 3m37s 08 27 3m20s 3m20s 09 31 2m41s 2m41s 10 22 3m5s 3m5s 11 21 5m25s 5m25s 12 19 3m51s 3m51s 13 26 3m15s 3m15s 14 22 3m1s 3m1s 15 26 3m41s 3m41s 16 23 3m31s 3m31s 17 34 2m5s 2m5s 18 9 4h57m13s 4h57m13s 19 3 76ms 76ms 20 3 104ms 104ms 21 3 72ms 72ms 22 3 73ms 73ms 23 3 68ms 68ms -
Connections
Established Connections
Key values
- 19 connections Connection Peak
- 2025-11-05 14:44:27 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 5,908 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 5,908 connections Total
-
Sessions
Simultaneous sessions
Key values
- 158 sessions Session Peak
- 2025-11-08 16:59:29 Date
Histogram of session times
Key values
- 4,752 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 5,917 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 5,917 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 5,917 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 5,917 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 5 16h37m 3h19m24s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 5 16h31m4s 3h18m12s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 7 11h40m48s 1h40m6s DBeaver 24.0.0 - Main 'autotest_feat_batch' 1 9m24s 9m24s DBeaver 24.0.0 - Metadata 'autotest_feat_batch' 1 9m23s 9m23s DBeaver 25.1.0 - Main 'autotest_feat_batch' 3 3h2m26s 1h48s DBeaver 25.1.0 - Metadata 'autotest_feat_batch' 2 3h2m22s 1h31m11s DBeaver 25.1.0 - SQLEditor 'Script-1.sql' 2 3h2m18s 1h31m9s IntelliJ IDEA 2024.3.5 46 1d13h13m4s 48m32s IntelliJ IDEA 2025.2.4 2 10s217ms 5s108ms PostgreSQL JDBC Driver 5,291 22d11h51m42s 6m7s [unknown] 516 59s508ms 115ms pg_restore 16 2h10m54s 8m10s psql 20 8m38s 25s933ms -
Temporary Files
Size of temporary files
Key values
- 400.84 MiB Temp Files size Peak
- 2025-11-04 19:40:35 Date
Number of temporary files
Key values
- 9 per second Temp Files Peak
- 2025-11-07 19:43:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 02 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 Nov 03 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 1 4.19 MiB 4.19 MiB 07 0 0 0 08 1 4.19 MiB 4.19 MiB 09 51 219.89 MiB 4.31 MiB 10 1 4.19 MiB 4.19 MiB 11 0 0 0 12 0 0 0 13 2 8.38 MiB 4.19 MiB 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 Nov 04 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 2 8.38 MiB 4.19 MiB 11 1 4.19 MiB 4.19 MiB 12 0 0 0 13 31 130.13 MiB 4.20 MiB 14 3 12.56 MiB 4.19 MiB 15 5 20.94 MiB 4.19 MiB 16 6 25.12 MiB 4.19 MiB 17 26 109.19 MiB 4.20 MiB 18 0 0 0 19 172 3.86 GiB 23.01 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 05 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 3 9.36 MiB 3.12 MiB 11 22 99.47 MiB 4.52 MiB 12 0 0 0 13 1 4.19 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 2 8.38 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 160 3.70 GiB 23.71 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 06 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 5 23.17 MiB 4.63 MiB 10 1 4.19 MiB 4.19 MiB 11 49 211.55 MiB 4.32 MiB 12 0 0 0 13 1 4.19 MiB 4.19 MiB 14 25 106.88 MiB 4.28 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 162 3.81 GiB 24.11 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 07 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 2 8.38 MiB 4.19 MiB 10 2 8.38 MiB 4.19 MiB 11 4 16.75 MiB 4.19 MiB 12 2 8.38 MiB 4.19 MiB 13 2 8.38 MiB 4.19 MiB 14 28 119.50 MiB 4.27 MiB 15 2 8.38 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 163 3.77 GiB 23.68 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 08 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 34 333.80 MiB 2.30 MiB 31.34 MiB 9.82 MiB select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021131', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021131', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-06 11:31:16 Duration: 7s145ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021123', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021123', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-06 11:23:18 Duration: 6s361ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021105', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021105', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-05 11:05:37 Duration: 6s346ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 12 1.46 GiB 29.39 MiB 578.13 MiB 124.89 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-07 19:39:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 12 52.59 MiB 2.57 MiB 7.63 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-11-07 19:43:08 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 12 507.96 MiB 3.34 MiB 403.86 MiB 42.33 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-07 19:39:40 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 12 439.85 MiB 21.91 MiB 103.54 MiB 36.65 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-11-07 19:42:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 12 286.68 MiB 8.73 MiB 88.32 MiB 23.89 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-07 19:42:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 12 434.24 MiB 3.88 MiB 241.88 MiB 36.19 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2025-11-07 19:42:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 12 877.45 MiB 13.48 MiB 339.12 MiB 73.12 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2025-11-07 19:42:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 12 416.87 MiB 17.86 MiB 142.02 MiB 34.74 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-11-07 19:41:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 12 270.98 MiB 3.00 MiB 163.10 MiB 22.58 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2025-11-07 19:42:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 11 882.83 MiB 50.98 MiB 177.99 MiB 80.26 MiB add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);-
ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-07 19:41:09 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 10 4.44 GiB 106.48 MiB 1.41 GiB 454.64 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:38:12 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 9 109.76 MiB 3.33 MiB 40.00 MiB 12.20 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-06 19:41:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 9 923.93 MiB 28.74 MiB 450.80 MiB 102.66 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-07 19:41:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 8 26.59 MiB 2.24 MiB 8.79 MiB 3.32 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-03 09:31:37 Duration: 3m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
16 7 741.73 MiB 22.49 MiB 298.35 MiB 105.96 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-07 19:41:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 88.44 MiB 1.97 MiB 53.28 MiB 17.69 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2025-11-07 19:43:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 4 1.11 GiB 16.69 MiB 824.22 MiB 282.96 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-07 19:40:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 4 104.88 MiB 3.59 MiB 42.84 MiB 26.22 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2025-11-07 19:43:00 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 3 25.77 MiB 2.09 MiB 20.89 MiB 8.59 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2025-11-06 19:38:42 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 967.95 MiB 967.95 MiB 967.95 MiB 967.95 MiB add constraint fk_relation_creator foreign key (relation_creator) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_relation_creator FOREIGN KEY (relation_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-05 19:30:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 321.90 MiB 321.90 MiB 321.90 MiB 321.90 MiB add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-07 19:41:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 187.80 MiB 187.80 MiB 187.80 MiB 187.80 MiB add constraint fk_gtp_obj_rel_vt_relt foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-06 19:40:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 236.21 MiB 236.21 MiB 236.21 MiB 236.21 MiB add constraint fk_gtp_obj_rel_vt_rel foreign key (relation_num_id) references public.gtp_relation (relation_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (relation_num_id) REFERENCES public.gtp_relation (relation_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-04 19:41:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.41 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-07 19:38:12 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.08 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-06 19:36:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 967.95 MiB ADD CONSTRAINT fk_relation_creator FOREIGN KEY (relation_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-05 19:30:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 824.22 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-11-04 19:38:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 625.84 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-04 19:39:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 609.69 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-11-05 19:30:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 578.13 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-07 19:39:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 450.80 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-06 19:39:18 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 403.86 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-06 19:37:47 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 339.12 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-04 19:42:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 331.88 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-05 19:30:27 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 321.90 MiB ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-07 19:41:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 298.35 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-05 19:33:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 241.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-04 19:40:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 236.21 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (relation_num_id) REFERENCES public.gtp_relation (relation_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-04 19:41:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 195.96 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-11-07 19:40:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 187.80 MiB ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-06 19:40:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 177.99 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 19:34:56 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 170.80 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-06 19:40:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 169.81 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-04 19:38:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 02 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 22 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 1 55s75ms 55s75ms relation 1 55s75ms 55s75ms AccessShareLock 4 9s225ms 2s306ms relation 4 9s225ms 2s306ms ExclusiveLock 2 2s172ms 1s86ms extension 2 2s172ms 1s86ms ShareLock 7 5m46s 49s537ms relation 2 2s261ms 1s130ms transaction 5 5m44s 1m8s ShareRowExclusiveLock 5 6s741ms 1s348ms relation 5 6s741ms 1s348ms ShareUpdateExclusiveLock 3 3s18ms 1s6ms relation 3 3s18ms 1s6ms Total 22 7m2s 19s226ms 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
- 36 Total read queries
- 294 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 353 Requests
- 1h49m38s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 354 Requests
User Request type Count Duration a3dsupervisor Total 354 1h49m44s copy from 25 12m15s ddl 116 25m48s delete 15 8m13s insert 7 1m8s others 23 39m57s select 37 4m1s tcl 124 14m7s update 7 4m12s Duration by user
Key values
- 1h49m44s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 354 1h49m44s copy from 25 12m15s ddl 116 25m48s delete 15 8m13s insert 7 1m8s others 23 39m57s select 37 4m1s tcl 124 14m7s update 7 4m12s Queries by host
Key values
- 10.3.0.4 Main host
- 354 Requests
- 1h49m44s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 207 Requests
- 1h2m51s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-04 21:03:18 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 224 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m45s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-04 17:07:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 3m26s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-05 11:03:21 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-03 09:31:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 3m21s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-06 11:21:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 3m17s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-07 14:27:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 3m14s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-04 13:08:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 2m59s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-03 09:51:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 2m50s VACUUM ANALYSE;[ Date: 2025-11-05 19:49:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 2m49s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-06 14:06:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 2m11s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-06 11:27:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 2m6s VACUUM ANALYSE;[ Date: 2025-11-04 19:55:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 2m5s delete from GTP_LOG_SESSION where LOG_DATE <;[ Date: 2025-11-06 11:27:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 2m5s UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;[ Date: 2025-11-07 14:27:52 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 1m54s VACUUM ANALYSE;[ Date: 2025-11-07 19:56:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 1m46s VACUUM ANALYSE;[ Date: 2025-11-06 19:53:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 1m30s update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;[ Date: 2025-11-03 11:15:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 1m6s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-11-04 19:38:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m5s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-11-05 19:30:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m5s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-11-07 19:38:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m4s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;[ Date: 2025-11-06 19:36:29 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 28m30s 9 2m11s 3m45s 3m10s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 10 2 6m24s 3m12s Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s Nov 05 12 1 3m26s 3m26s Nov 06 12 2 5m32s 2m46s 15 1 2m49s 2m49s Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 28m30s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28m30s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-03 09:31:37 Duration: 3m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 14m7s 124 5s14ms 13s469ms 6s833ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 08 21 2m39s 7s572ms 09 5 33s165ms 6s633ms 21 7 42s706ms 6s100ms Nov 04 08 13 1m35s 7s383ms 09 8 1m4s 8s78ms 20 1 5s782ms 5s782ms 21 6 35s76ms 5s846ms Nov 05 08 4 24s170ms 6s42ms 09 2 13s885ms 6s942ms 21 10 1m7s 6s751ms Nov 06 08 10 56s893ms 5s689ms 09 11 1m 5s466ms 21 2 13s1ms 6s500ms Nov 07 08 9 1m3s 7s76ms 09 8 50s320ms 6s290ms 21 7 1m1s 8s766ms [ User: a3dsupervisor - Total duration: 14m7s - Times executed: 124 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m1s - Times executed: 123 ]
[ Application: pg_restore - Total duration: 5s782ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 13s469ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s325ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s316ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 8m37s 4 1m46s 2m50s 2m9s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s Nov 05 20 1 2m50s 2m50s Nov 06 20 1 1m46s 1m46s Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 8m37s - Times executed: 4 ]
[ Application: psql - Total duration: 8m37s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5m54s 12 5s110ms 57s284ms 29s513ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 10 2 1m22s 41s306ms Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms Nov 06 10 1 5s588ms 5s588ms 12 2 1m3s 31s939ms 15 1 55s333ms 55s333ms Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 5m54s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m54s - Times executed: 12 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 11:35:01 Duration: 57s284ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 14:13:06 Duration: 55s333ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-03 09:56:25 Duration: 49s738ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 4m23s 4 1m4s 1m6s 1m5s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 04 20 1 1m6s 1m6s Nov 05 20 1 1m5s 1m5s Nov 06 20 1 1m4s 1m4s Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m23s - Times executed: 4 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2m23s 4 31s573ms 40s543ms 35s801ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 20 1 38s668ms 38s668ms Nov 05 20 1 31s573ms 31s573ms Nov 06 20 1 40s543ms 40s543ms Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:38:43 Duration: 40s543ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 2m20s 4 34s149ms 36s372ms 35s31ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 04 20 1 34s877ms 34s877ms Nov 05 20 1 34s149ms 34s149ms Nov 06 20 1 36s372ms 36s372ms Nov 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 4 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-06 19:36:00 Duration: 36s372ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2m16s 4 31s617ms 38s857ms 34s119ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 04 20 1 32s693ms 32s693ms Nov 05 20 1 38s857ms 38s857ms Nov 06 20 1 33s308ms 33s308ms Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-06 19:39:24 Duration: 33s308ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 2m5s 1 2m5s 2m5s 2m5s delete from gtp_log_session where log_date <;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 06 12 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
delete from GTP_LOG_SESSION where LOG_DATE <;
Date: 2025-11-06 11:27:57 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 2m5s 1 2m5s 2m5s 2m5s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 07 15 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-11-07 14:27:52 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1m54s 9 9s89ms 32s802ms 12s700ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 10 2 19s535ms 9s767ms Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms Nov 05 11 1 10s371ms 10s371ms Nov 06 12 2 43s766ms 21s883ms 15 1 9s89ms 9s89ms Nov 07 15 1 10s526ms 10s526ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:25:32 Duration: 32s802ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:17:43 Duration: 10s964ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 1m49s 4 21s172ms 32s515ms 27s297ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 04 20 1 32s515ms 32s515ms Nov 05 20 1 24s130ms 24s130ms Nov 06 20 1 31s373ms 31s373ms Nov 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:37:47 Duration: 31s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1m42s 4 24s825ms 27s131ms 25s680ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 04 20 1 25s485ms 25s485ms Nov 05 20 1 24s825ms 24s825ms Nov 06 20 1 25s278ms 25s278ms Nov 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 1m42s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m42s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-06 19:36:26 Duration: 25s278ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1m38s 4 22s672ms 26s486ms 24s526ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 04 20 1 26s486ms 26s486ms Nov 05 20 1 23s299ms 23s299ms Nov 06 20 1 25s647ms 25s647ms Nov 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 1m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m38s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-06 19:39:11 Duration: 25s647ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1m32s 4 19s439ms 25s563ms 23s120ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 04 20 1 23s481ms 23s481ms Nov 05 20 1 19s439ms 19s439ms Nov 06 20 1 25s563ms 25s563ms Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-06 19:36:54 Duration: 25s563ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1m30s 1 1m30s 1m30s 1m30s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 12 1 1m30s 1m30s [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m30s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-11-03 11:15:03 Duration: 1m30s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 1m22s 4 16s551ms 27s902ms 20s728ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 20 1 20s297ms 20s297ms Nov 05 20 1 27s902ms 27s902ms Nov 06 20 1 18s161ms 18s161ms Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-06 19:36:59 Duration: 18s161ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1m21s 4 13s179ms 30s252ms 20s344ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 04 20 1 13s783ms 13s783ms Nov 05 20 1 30s252ms 30s252ms Nov 06 20 1 24s159ms 24s159ms Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-06 19:39:59 Duration: 24s159ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 19:42:46 Duration: 13s783ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1m4s 4 13s163ms 21s983ms 16s45ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 20 1 14s195ms 14s195ms Nov 05 20 1 21s983ms 21s983ms Nov 06 20 1 14s839ms 14s839ms Nov 07 20 1 13s163ms 13s163ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m4s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 19:34:43 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-06 19:40:31 Duration: 14s839ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-04 19:42:11 Duration: 14s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1m3s 4 13s449ms 18s453ms 15s944ms create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 04 20 1 15s829ms 15s829ms Nov 05 20 1 18s453ms 18s453ms Nov 06 20 1 16s44ms 16s44ms Nov 07 20 1 13s449ms 13s449ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m3s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-05 19:31:52 Duration: 18s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-06 19:38:03 Duration: 16s44ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-04 19:39:56 Duration: 15s829ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 124 14m7s 5s14ms 13s469ms 6s833ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 21 2m39s 7s572ms 09 5 33s165ms 6s633ms 21 7 42s706ms 6s100ms Nov 04 08 13 1m35s 7s383ms 09 8 1m4s 8s78ms 20 1 5s782ms 5s782ms 21 6 35s76ms 5s846ms Nov 05 08 4 24s170ms 6s42ms 09 2 13s885ms 6s942ms 21 10 1m7s 6s751ms Nov 06 08 10 56s893ms 5s689ms 09 11 1m 5s466ms 21 2 13s1ms 6s500ms Nov 07 08 9 1m3s 7s76ms 09 8 50s320ms 6s290ms 21 7 1m1s 8s766ms [ User: a3dsupervisor - Total duration: 14m7s - Times executed: 124 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 14m1s - Times executed: 123 ]
[ Application: pg_restore - Total duration: 5s782ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-04 08:00:19 Duration: 13s469ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s325ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s316ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 12 5m54s 5s110ms 57s284ms 29s513ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 10 2 1m22s 41s306ms Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms Nov 06 10 1 5s588ms 5s588ms 12 2 1m3s 31s939ms 15 1 55s333ms 55s333ms Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 5m54s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m54s - Times executed: 12 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 11:35:01 Duration: 57s284ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 14:13:06 Duration: 55s333ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-03 09:56:25 Duration: 49s738ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 9 28m30s 2m11s 3m45s 3m10s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 10 2 6m24s 3m12s Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s Nov 05 12 1 3m26s 3m26s Nov 06 12 2 5m32s 2m46s 15 1 2m49s 2m49s Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 28m30s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28m30s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-03 09:31:37 Duration: 3m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 9 1m54s 9s89ms 32s802ms 12s700ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 10 2 19s535ms 9s767ms Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms Nov 05 11 1 10s371ms 10s371ms Nov 06 12 2 43s766ms 21s883ms 15 1 9s89ms 9s89ms Nov 07 15 1 10s526ms 10s526ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:25:32 Duration: 32s802ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:17:43 Duration: 10s964ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 9 53s820ms 5s30ms 7s145ms 5s980ms select objrech.obj_num_id as cpid, consos.datestamped, consos.sumval, consos.sumkwh, consos.sumco2, consos.type, consos.time_period from gtp_obj objrech inner join gtp_obj_template temp on objrech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (...) left join ( select cons.counting_point_num_id as pointid, cons.date_stamped as datestamped, sum(cons.value) as sumval, sum(cons.value_kwh) as sumkwh, sum(cons.value_co2) as sumco2, cons.type, cons.time_period from pe_consumption_10min cons where cons.type in (...) and cons.date_stamped >= to_date(?, ?) and cons.date_stamped <= to_date(?, ?) group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointid = objrech.obj_num_id where objrech.obj_num_id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 10 2 10s585ms 5s292ms Nov 04 14 1 6s223ms 6s223ms 18 1 6s99ms 6s99ms Nov 05 12 1 6s346ms 6s346ms Nov 06 12 2 13s506ms 6s753ms 15 1 6s27ms 6s27ms Nov 07 15 1 5s30ms 5s30ms [ User: a3dsupervisor - Total duration: 53s820ms - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 53s820ms - Times executed: 9 ]
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021131', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021131', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-06 11:31:16 Duration: 7s145ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021123', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021123', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-06 11:23:18 Duration: 6s361ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select objRech.obj_num_id as cpId, consos.dateStamped, consos.sumVal, consos.sumKwh, consos.sumCo2, consos.type, consos.time_period from gtp_obj objRech inner join gtp_obj_template temp on objRech.obj_template_num_id = temp.obj_template_num_id and temp.obj_template_a3d_num_id in (28, 449, 450) left join ( select cons.counting_point_num_id as pointId, cons.date_stamped as dateStamped, sum(cons.value) as sumVal, sum(cons.value_kwh) as sumKwh, sum(cons.value_co2) as sumCo2, cons.type, cons.time_period from PE_CONSUMPTION_10MIN cons where cons.type in (1, 3, 2) and cons.date_stamped >= TO_DATE('202001021105', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021105', 'YYYYMMDDHH24MI') group by cons.counting_point_num_id, cons.date_stamped, cons.type, cons.time_period) consos on consos.pointId = objRech.obj_num_id where objRech.obj_num_id in (97837, 397649, 3978356);
Date: 2025-11-05 11:05:37 Duration: 6s346ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 5 39s406ms 5s12ms 9s407ms 7s881ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 09 1 5s12ms 5s12ms Nov 05 21 2 16s874ms 8s437ms Nov 06 08 1 9s407ms 9s407ms Nov 07 08 1 8s112ms 8s112ms [ User: a3dsupervisor - Total duration: 39s406ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s406ms - Times executed: 5 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-06 07:56:16 Duration: 9s407ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s437ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s436ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5 35s773ms 6s979ms 7s430ms 7s154ms select cehp1_0.history_num_id, case when cehp1_1.history_num_id is not null then ? when cehp1_0.history_num_id is not null then ? end, cehp1_0.history_action, cehp1_0.history_date, cehp1_0.obj_num_id, cehp1_0.obj_template_a3d_id, cehp1_1.alert_src_num_id, cehp1_1.alert_type_a3d_id from gtp_cw_eng_history cehp1_0 left join gtp_cw_eng_alert cehp1_1 on cehp1_0.history_num_id = cehp1_1.history_num_id where cehp1_0.history_action = and cehp1_0.obj_template_a3d_id = and cehp1_0.obj_num_id = order by cehp1_0.history_date desc fetch first rows only;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 10 1 7s430ms 7s430ms Nov 04 13 1 6s979ms 6s979ms Nov 05 11 1 7s65ms 7s65ms Nov 06 12 1 7s277ms 7s277ms Nov 07 15 1 7s21ms 7s21ms [ User: a3dsupervisor - Total duration: 35s773ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 35s773ms - Times executed: 5 ]
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-03 09:18:46 Duration: 7s430ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-06 11:13:57 Duration: 7s277ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select cehp1_0.HISTORY_NUM_ID, case when cehp1_1.HISTORY_NUM_ID is not null then 1 when cehp1_0.HISTORY_NUM_ID is not null then 0 end, cehp1_0.HISTORY_ACTION, cehp1_0.HISTORY_DATE, cehp1_0.OBJ_NUM_ID, cehp1_0.OBJ_TEMPLATE_A3D_ID, cehp1_1.ALERT_SRC_NUM_ID, cehp1_1.ALERT_TYPE_A3D_ID from GTP_CW_ENG_HISTORY cehp1_0 left join GTP_CW_ENG_ALERT cehp1_1 on cehp1_0.HISTORY_NUM_ID = cehp1_1.HISTORY_NUM_ID where cehp1_0.HISTORY_ACTION = and cehp1_0.OBJ_TEMPLATE_A3D_ID = and cehp1_0.OBJ_NUM_ID = order by cehp1_0.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-05 10:54:52 Duration: 7s65ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 5 32s654ms 5s109ms 8s86ms 6s530ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 10 1 5s462ms 5s462ms Nov 04 18 1 8s86ms 8s86ms Nov 05 12 1 6s379ms 6s379ms Nov 06 15 1 7s617ms 7s617ms Nov 07 10 1 5s109ms 5s109ms [ User: a3dsupervisor - Total duration: 32s654ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 32s654ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-04 17:08:19 Duration: 8s86ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-06 14:08:18 Duration: 7s617ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-05 11:05:06 Duration: 6s379ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 5 29s662ms 5s98ms 6s490ms 5s932ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 04 02 1 6s490ms 6s490ms Nov 05 02 1 5s98ms 5s98ms Nov 06 02 1 6s342ms 6s342ms Nov 07 02 1 5s939ms 5s939ms Nov 08 02 1 5s790ms 5s790ms [ User: a3dsupervisor - Total duration: 29s662ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s662ms - Times executed: 5 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-04 01:01:11 Duration: 6s490ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-06 01:01:18 Duration: 6s342ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-11-07 01:00:46 Duration: 5s939ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 4 8m37s 1m46s 2m50s 2m9s vacuum analyse;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s Nov 05 20 1 2m50s 2m50s Nov 06 20 1 1m46s 1m46s Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 8m37s - Times executed: 4 ]
[ Application: psql - Total duration: 8m37s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 4 4m23s 1m4s 1m6s 1m5s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 04 20 1 1m6s 1m6s Nov 05 20 1 1m5s 1m5s Nov 06 20 1 1m4s 1m4s Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m23s - Times executed: 4 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4 2m23s 31s573ms 40s543ms 35s801ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 04 20 1 38s668ms 38s668ms Nov 05 20 1 31s573ms 31s573ms Nov 06 20 1 40s543ms 40s543ms Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:38:43 Duration: 40s543ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 4 2m20s 34s149ms 36s372ms 35s31ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 04 20 1 34s877ms 34s877ms Nov 05 20 1 34s149ms 34s149ms Nov 06 20 1 36s372ms 36s372ms Nov 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 4 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-06 19:36:00 Duration: 36s372ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 4 2m16s 31s617ms 38s857ms 34s119ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 04 20 1 32s693ms 32s693ms Nov 05 20 1 38s857ms 38s857ms Nov 06 20 1 33s308ms 33s308ms Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-06 19:39:24 Duration: 33s308ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 1m49s 21s172ms 32s515ms 27s297ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 04 20 1 32s515ms 32s515ms Nov 05 20 1 24s130ms 24s130ms Nov 06 20 1 31s373ms 31s373ms Nov 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:37:47 Duration: 31s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4 1m42s 24s825ms 27s131ms 25s680ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 04 20 1 25s485ms 25s485ms Nov 05 20 1 24s825ms 24s825ms Nov 06 20 1 25s278ms 25s278ms Nov 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 1m42s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m42s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-06 19:36:26 Duration: 25s278ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 4 1m38s 22s672ms 26s486ms 24s526ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 20 1 26s486ms 26s486ms Nov 05 20 1 23s299ms 23s299ms Nov 06 20 1 25s647ms 25s647ms Nov 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 1m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m38s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-06 19:39:11 Duration: 25s647ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 4 1m32s 19s439ms 25s563ms 23s120ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 04 20 1 23s481ms 23s481ms Nov 05 20 1 19s439ms 19s439ms Nov 06 20 1 25s563ms 25s563ms Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-06 19:36:54 Duration: 25s563ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 4 1m22s 16s551ms 27s902ms 20s728ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 20 1 20s297ms 20s297ms Nov 05 20 1 27s902ms 27s902ms Nov 06 20 1 18s161ms 18s161ms Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-06 19:36:59 Duration: 18s161ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 4 1m21s 13s179ms 30s252ms 20s344ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 04 20 1 13s783ms 13s783ms Nov 05 20 1 30s252ms 30s252ms Nov 06 20 1 24s159ms 24s159ms Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-06 19:39:59 Duration: 24s159ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 19:42:46 Duration: 13s783ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m11s 3m45s 3m10s 9 28m30s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 10 2 6m24s 3m12s Nov 04 14 1 3m14s 3m14s 18 1 3m45s 3m45s Nov 05 12 1 3m26s 3m26s Nov 06 12 2 5m32s 2m46s 15 1 2m49s 2m49s Nov 07 15 1 3m17s 3m17s [ User: a3dsupervisor - Total duration: 28m30s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28m30s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-04 17:07:01 Duration: 3m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-05 11:03:21 Duration: 3m26s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-03 09:31:37 Duration: 3m24s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m46s 2m50s 2m9s 4 8m37s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 04 20 1 2m6s 2m6s Nov 05 20 1 2m50s 2m50s Nov 06 20 1 1m46s 1m46s Nov 07 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 8m37s - Times executed: 4 ]
[ Application: psql - Total duration: 8m37s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 19:49:15 Duration: 2m50s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-04 19:55:38 Duration: 2m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 19:56:08 Duration: 1m54s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 2m5s 2m5s 2m5s 1 2m5s delete from gtp_log_session where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 06 12 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
delete from GTP_LOG_SESSION where LOG_DATE <;
Date: 2025-11-06 11:27:57 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 2m5s 2m5s 2m5s 1 2m5s update log_session set session_status = where session_status = and server_id =;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 07 15 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m5s - Times executed: 1 ]
-
UPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =;
Date: 2025-11-07 14:27:52 Duration: 2m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m30s 1m30s 1m30s 1 1m30s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 12 1 1m30s 1m30s [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m30s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-11-03 11:15:03 Duration: 1m30s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m4s 1m6s 1m5s 4 4m23s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 04 20 1 1m6s 1m6s Nov 05 20 1 1m5s 1m5s Nov 06 20 1 1m4s 1m4s Nov 07 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m23s - Times executed: 4 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-04 19:38:22 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-05 19:30:25 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-07 19:38:16 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 31s573ms 40s543ms 35s801ms 4 2m23s alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 04 20 1 38s668ms 38s668ms Nov 05 20 1 31s573ms 31s573ms Nov 06 20 1 40s543ms 40s543ms Nov 07 20 1 32s419ms 32s419ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:38:43 Duration: 40s543ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:40:35 Duration: 38s668ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-07 19:40:16 Duration: 32s419ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 34s149ms 36s372ms 35s31ms 4 2m20s copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 04 20 1 34s877ms 34s877ms Nov 05 20 1 34s149ms 34s149ms Nov 06 20 1 36s372ms 36s372ms Nov 07 20 1 34s725ms 34s725ms [ User: a3dsupervisor - Total duration: 2m20s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m20s - Times executed: 4 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-06 19:36:00 Duration: 36s372ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-04 19:37:50 Duration: 34s877ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) FROM stdin;
Date: 2025-11-07 19:37:45 Duration: 34s725ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 31s617ms 38s857ms 34s119ms 4 2m16s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 04 20 1 32s693ms 32s693ms Nov 05 20 1 38s857ms 38s857ms Nov 06 20 1 33s308ms 33s308ms Nov 07 20 1 31s617ms 31s617ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-05 19:33:05 Duration: 38s857ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-06 19:39:24 Duration: 33s308ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-11-04 19:41:15 Duration: 32s693ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5s110ms 57s284ms 29s513ms 12 5m54s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 10 2 1m22s 41s306ms Nov 04 14 1 27s412ms 27s412ms 18 1 27s893ms 27s893ms Nov 05 11 1 5s110ms 5s110ms 12 1 34s13ms 34s13ms Nov 06 10 1 5s588ms 5s588ms 12 2 1m3s 31s939ms 15 1 55s333ms 55s333ms Nov 07 10 1 6s918ms 6s918ms 15 1 45s398ms 45s398ms [ User: a3dsupervisor - Total duration: 5m54s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m54s - Times executed: 12 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 11:35:01 Duration: 57s284ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-06 14:13:06 Duration: 55s333ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-03 09:56:25 Duration: 49s738ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 21s172ms 32s515ms 27s297ms 4 1m49s create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 04 20 1 32s515ms 32s515ms Nov 05 20 1 24s130ms 24s130ms Nov 06 20 1 31s373ms 31s373ms Nov 07 20 1 21s172ms 21s172ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-04 19:39:39 Duration: 32s515ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-06 19:37:47 Duration: 31s373ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-11-05 19:31:33 Duration: 24s130ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 24s825ms 27s131ms 25s680ms 4 1m42s create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 04 20 1 25s485ms 25s485ms Nov 05 20 1 24s825ms 24s825ms Nov 06 20 1 25s278ms 25s278ms Nov 07 20 1 27s131ms 27s131ms [ User: a3dsupervisor - Total duration: 1m42s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m42s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-07 19:38:13 Duration: 27s131ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-04 19:38:16 Duration: 25s485ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-06 19:36:26 Duration: 25s278ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 22s672ms 26s486ms 24s526ms 4 1m38s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 04 20 1 26s486ms 26s486ms Nov 05 20 1 23s299ms 23s299ms Nov 06 20 1 25s647ms 25s647ms Nov 07 20 1 22s672ms 22s672ms [ User: a3dsupervisor - Total duration: 1m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m38s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-04 19:41:04 Duration: 26s486ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-06 19:39:11 Duration: 25s647ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-11-05 19:32:47 Duration: 23s299ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 19s439ms 25s563ms 23s120ms 4 1m32s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 04 20 1 23s481ms 23s481ms Nov 05 20 1 19s439ms 19s439ms Nov 06 20 1 25s563ms 25s563ms Nov 07 20 1 23s996ms 23s996ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-06 19:36:54 Duration: 25s563ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-07 19:38:40 Duration: 23s996ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-04 19:38:45 Duration: 23s481ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 16s551ms 27s902ms 20s728ms 4 1m22s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 04 20 1 20s297ms 20s297ms Nov 05 20 1 27s902ms 27s902ms Nov 06 20 1 18s161ms 18s161ms Nov 07 20 1 16s551ms 16s551ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-05 19:30:55 Duration: 27s902ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-04 19:38:52 Duration: 20s297ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-06 19:36:59 Duration: 18s161ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 13s179ms 30s252ms 20s344ms 4 1m21s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 04 20 1 13s783ms 13s783ms Nov 05 20 1 30s252ms 30s252ms Nov 06 20 1 24s159ms 24s159ms Nov 07 20 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 1m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m21s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-05 19:34:36 Duration: 30s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-06 19:39:59 Duration: 24s159ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-11-04 19:42:46 Duration: 13s783ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 13s163ms 21s983ms 16s45ms 4 1m4s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 04 20 1 14s195ms 14s195ms Nov 05 20 1 21s983ms 21s983ms Nov 06 20 1 14s839ms 14s839ms Nov 07 20 1 13s163ms 13s163ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m4s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 19:34:43 Duration: 21s983ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-06 19:40:31 Duration: 14s839ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-04 19:42:11 Duration: 14s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 13s449ms 18s453ms 15s944ms 4 1m3s create index i_gtp_obj_rel_vt_objt_vt on public.gtp_obj_rel_vt using btree (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 04 20 1 15s829ms 15s829ms Nov 05 20 1 18s453ms 18s453ms Nov 06 20 1 16s44ms 16s44ms Nov 07 20 1 13s449ms 13s449ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m3s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-05 19:31:52 Duration: 18s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-06 19:38:03 Duration: 16s44ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON public.gtp_obj_rel_vt USING btree (obj_template_num_id, view_template_num_id);
Date: 2025-11-04 19:39:56 Duration: 15s829ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 9s89ms 32s802ms 12s700ms 9 1m54s call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 10 2 19s535ms 9s767ms Nov 04 14 1 11s837ms 11s837ms 18 1 9s179ms 9s179ms Nov 05 11 1 10s371ms 10s371ms Nov 06 12 2 43s766ms 21s883ms 15 1 9s89ms 9s89ms Nov 07 15 1 10s526ms 10s526ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m54s - Times executed: 9 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:25:32 Duration: 32s802ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-04 13:04:38 Duration: 11s837ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-06 11:17:43 Duration: 10s964ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s12ms 9s407ms 7s881ms 5 39s406ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 04 09 1 5s12ms 5s12ms Nov 05 21 2 16s874ms 8s437ms Nov 06 08 1 9s407ms 9s407ms Nov 07 08 1 8s112ms 8s112ms [ User: a3dsupervisor - Total duration: 39s406ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 39s406ms - Times executed: 5 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-06 07:56:16 Duration: 9s407ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s437ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-11-05 20:41:58 Duration: 8s436ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 24,368 Log entries
Events distribution
Key values
- 0 PANIC entries
- 3 FATAL entries
- 5163 ERROR entries
- 126 WARNING entries
Most Frequent Errors/Events
Key values
- 4,669 Max number of times the same event was reported
- 5,292 Total events found
Rank Times reported Error 1 4,669 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 04 21 90 22 486 23 98 00 645 Nov 05 01 30 02 9 21 420 22 100 23 295 00 67 Nov 06 01 3 02 2 05 1 06 1 21 106 22 349 23 94 00 734 Nov 07 01 10 21 106 22 227 23 245 00 548 Nov 08 01 3 2 228 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 03 10 4 13 2 14 6 16 3 19 3 Nov 04 11 7 12 3 13 5 14 5 15 11 16 29 17 22 19 3 Nov 05 13 2 14 2 16 10 17 5 19 3 Nov 06 10 10 11 3 12 5 14 2 19 3 Nov 07 10 2 11 7 12 16 13 4 14 14 15 18 16 7 17 3 19 3 Nov 08 19 6 3 72 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 03 10 16 Nov 04 14 8 18 8 Nov 05 12 8 Nov 06 12 16 15 8 Nov 07 15 8 4 54 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 03 10 12 Nov 04 14 6 18 6 Nov 05 12 6 Nov 06 12 12 15 6 Nov 07 15 6 5 18 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 03 10 4 Nov 04 14 2 18 2 Nov 05 12 2 Nov 06 12 4 15 2 Nov 07 15 2 6 11 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 3 7 9 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 8 9 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 9 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 10 9 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 11 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 12 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 13 9 LOG: process ... still waiting for ShareLock on transaction ... after ... msselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 14 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 15 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 16 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_TIME_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 17 9 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 18 9 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 19 9 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 20 9 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.DATE_DB_FORMATSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 21 9 ERROR: null value in column "..." of relation "..." violates not-null constraintSELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 22 9 ERROR: canceling statement due to lock timeoutselect task.task_num_id from gtp_background_task task where task.task_num_id= FOR UPDATE
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 03 10 2 Nov 04 14 1 18 1 Nov 05 12 1 Nov 06 12 2 15 1 Nov 07 15 1 23 7 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 05 12 1 Nov 07 10 3 11 3 24 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 25 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 26 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 27 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 28 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #28
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 29 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #29
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 30 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #30
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 31 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 32 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #32
Day Hour Count Nov 04 14 1 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 33 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #33
Day Hour Count Nov 04 20 1 Nov 05 20 1 Nov 06 20 1 Nov 07 20 1 34 4 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #34
Day Hour Count Nov 03 10 1 Nov 04 18 3 35 4 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #35
Day Hour Count Nov 04 08 2 Nov 06 08 2 36 3 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #36
Day Hour Count Nov 04 20 1 Nov 06 20 1 Nov 07 20 1 37 3 ERROR: function length(...) does not exist
Times Reported Most Frequent Error / Event #37
Day Hour Count Nov 04 14 1 17 2 38 2 ERROR: canceling statement due to lock timeoutselect LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE
Times Reported Most Frequent Error / Event #38
Day Hour Count Nov 07 15 2 39 2 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #39
Day Hour Count Nov 05 20 1 Nov 07 20 1 40 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #40
Day Hour Count Nov 06 11 2 41 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt
Times Reported Most Frequent Error / Event #41
Day Hour Count Nov 04 20 1 Nov 06 20 1 42 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (...)
Times Reported Most Frequent Error / Event #42
Day Hour Count Nov 04 20 1 Nov 05 20 1 43 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms -- REVOKE ALL ON FUNCTION a3d_gtp_reftk.touppernoaccent (...) FROM PUBLIC; DROP TRIGGER IF EXISTS t_bef_ins_er_gtp_obj ON gtp_obj CASCADE
Times Reported Most Frequent Error / Event #43
Day Hour Count Nov 04 14 2 44 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID=,EXPORT_FILE_NAME=,SERVER_ID=,SOURCE_FILE_NAME=,SOURCE_OBJ_NUM_ID=,TASK_ACTIVE_STATUS=,TASK_CREATE_DATE=,TASK_CURRENT_PROGRESS=,TASK_CURRENT_STEP=,TASK_END_DATE=,TASK_ERROR_MESSAGE=,TASK_LAST_UPDATE=,TASK_LOG=,TASK_MAX_PROGRESS=,TASK_MAX_STEP=,TASK_ORIGIN=,TASK_PARAMETERS=,TASK_REPORT=,TASK_SERVICE_NAME=,TASK_START_DATE=,TASK_STATE=,TASK_STATUS=,TASK_SUB_TYPE=,USER_NUM_ID= where TASK_NUM_ID=
Times Reported Most Frequent Error / Event #44
Day Hour Count Nov 03 12 2 45 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msdelete from GTP_LOG_SESSION where LOG_DATE <
Times Reported Most Frequent Error / Event #45
Day Hour Count Nov 06 12 2 46 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_GROUP (...) values (...)
Times Reported Most Frequent Error / Event #46
Day Hour Count Nov 05 11 1 47 1 ERROR: null value in column "..." of relation "..." violates not-null constraintINSERT INTO MAPPING(...) VALUES(...)
Times Reported Most Frequent Error / Event #47
Day Hour Count Nov 06 11 1 48 1 ERROR: column "..." is of type oid but expression is of type bytea
Times Reported Most Frequent Error / Event #48
Day Hour Count Nov 04 14 1 49 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #49
Day Hour Count Nov 06 10 1 50 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate gtp_cache_host set last_seen = current_timestamp where host = and port =
Times Reported Most Frequent Error / Event #50
Day Hour Count Nov 04 18 1 51 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history
Times Reported Most Frequent Error / Event #51
Day Hour Count Nov 07 20 1 52 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockselect bpp1_0.BATCH_PROCESS_NUM_ID,bpp1_0.CREATOR_NUM_ID,bpp1_0.MODIFIER_NUM_ID,bpp1_0.BATCH_PROCESS_COMMENT,bpp1_0.CREATION_DATE,bpp1_0.BATCH_PROCESS_EXECUTION_ORDER,bpp1_0.MODIFICATION_DATE,bpp1_0.BATCH_PROCESS_NAME,bpp1_0.BATCH_SCENARIO_NUM_ID,bpp1_0.BATCH_PROCESS_SETTINGS,bpp1_0.BATCH_PROCESS_TYPE_CODE,bpp1_0.BATCH_PROCESS_UNIQUE_CODE from BATCH_PROCESS bpp1_0 where bpp1_0.BATCH_PROCESS_NAME= fetch first rows only
Times Reported Most Frequent Error / Event #52
Day Hour Count Nov 06 11 1 53 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_relation
Times Reported Most Frequent Error / Event #53
Day Hour Count Nov 05 20 1 54 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msUPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =
Times Reported Most Frequent Error / Event #54
Day Hour Count Nov 07 15 1 55 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (...) REFERENCES public.gtp_rel_template(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #55
Day Hour Count Nov 07 20 1