pgBadger-
Global information
- Generated on Mon Nov 17 09:35:20 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=15/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=15/h=23/m=00/PT1H.log
- Parsed 22,305 log entries in 1m1s
- Log start from 2025-11-10 18:00:59 to 2025-11-14 18:01:03
-
Overview
Global Stats
- 86 Number of unique normalized queries
- 240 Number of queries
- 1h33m2s Total query duration
- 2025-11-10 07:19:36 First query
- 2025-11-14 09:55:10 Last query
- 4 queries/s at 2025-11-10 08:13:56 Query peak
- 1h33m2s Total query duration
- 14s214ms Prepare/parse total duration
- 5s449ms Bind total duration
- 1h32m42s Execute total duration
- 3,687 Number of events
- 43 Number of unique normalized events
- 3,320 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
- 492 Number temporary file
- 720.55 MiB Max size of temporary file
- 17.23 MiB Average size of temporary file
- 4,647 Total number of sessions
- 147 sessions at 2025-11-09 19:47:23 Session peak
- 15d12h45m5s Total duration of sessions
- 4m48s Average duration of sessions
- 0 Average queries per session
- 1s201ms Average queries duration per session
- 4m47s Average idle time per session
- 4,644 Total number of connections
- 14 connections/s at 2025-11-13 10:04:05 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-10 08:13:56 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-11-10 08:12:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-10 08:13:56 Date
Queries duration
Key values
- 1h33m2s 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 09 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 10 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 15 0ms 9s621ms 7s777ms 0ms 33s543ms 1m12s 08 23 0ms 23s675ms 9s492ms 12s431ms 22s567ms 1m59s 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 4 0ms 8s142ms 7s648ms 0ms 6s380ms 24s213ms 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 11 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 10s427ms 10s427ms 0ms 0ms 10s427ms 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 8s960ms 6s913ms 12s576ms 15s814ms 49s69ms 08 6 0ms 9s906ms 9s152ms 0ms 25s480ms 29s433ms 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 8 0ms 7s364ms 6s331ms 7s159ms 15s248ms 20s882ms 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 12 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 10s761ms 10s761ms 0ms 0ms 10s761ms 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 11 0ms 9s838ms 7s77ms 13s315ms 19s285ms 26s85ms 08 12 0ms 8s457ms 6s573ms 11s763ms 24s827ms 26s23ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 1 0ms 11s78ms 11s78ms 0ms 0ms 11s78ms 11 3 0ms 3m7s 1m6s 0ms 6s622ms 3m7s 12 11 0ms 2m39s 41s272ms 31s764ms 49s954ms 2m39s 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 6s601ms 5s687ms 0ms 6s601ms 16s730ms 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 13 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 7s387ms 7s387ms 0ms 0ms 7s387ms 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 14 0ms 20s915ms 7s929ms 12s233ms 33s337ms 42s296ms 08 56 0ms 1m18s 15s404ms 1m46s 1m56s 2m58s 09 2 0ms 27m13s 13m55s 0ms 37s331ms 27m13s 10 4 0ms 3m34s 1m8s 0ms 9s391ms 3m34s 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 4 0ms 2m44s 46s384ms 6s9ms 9s201ms 2m44s 14 1 0ms 37s350ms 37s350ms 0ms 0ms 37s350ms 15 1 0ms 5s124ms 5s124ms 0ms 0ms 5s124ms 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 36 0ms 2m25s 19s491ms 1m56s 2m20s 2m25s 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 14 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 1 0ms 8s769ms 8s769ms 0ms 8s769ms 8s769ms 09 4 0ms 3m15s 1m3s 6s438ms 43s798ms 3m15s 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 15 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 Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 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 10 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 2 0 5s901ms 0ms 0ms 11s802ms 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 11 00 0 0 0ms 0ms 0ms 0ms 01 1 0 10s427ms 0ms 0ms 10s427ms 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 2 0 6s961ms 0ms 0ms 13s923ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 12 00 0 0 0ms 0ms 0ms 0ms 01 1 0 10s761ms 0ms 0ms 10s761ms 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 1 0 8s115ms 0ms 0ms 8s115ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 2 0 5s984ms 0ms 0ms 6s622ms 12 4 0 6s311ms 0ms 0ms 12s6ms 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 13 00 0 0 0ms 0ms 0ms 0ms 01 1 0 7s387ms 0ms 0ms 7s387ms 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 1 0 12s233ms 0ms 0ms 12s233ms 08 8 0 6s330ms 5s548ms 11s896ms 13s679ms 09 0 0 0ms 0ms 0ms 0ms 10 1 0 7s329ms 0ms 0ms 7s329ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 2 0 6s17ms 0ms 0ms 6s25ms 14 0 0 0ms 0ms 0ms 0ms 15 1 0 5s124ms 0ms 0ms 5s124ms 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 14 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 1 0 6s438ms 0ms 0ms 6s438ms 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 15 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 Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 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 10 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 9s52ms 0ms 0ms 0ms 08 1 1 0 0 5s610ms 0ms 0ms 5s75ms 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 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 1 0 0 0 6s959ms 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 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 0 0 8s131ms 0ms 0ms 0ms 08 2 0 0 0 5s202ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 11s78ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 3 0 42s632ms 0ms 0ms 46s177ms 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 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 1 0 0 20s915ms 0ms 0ms 0ms 08 2 0 0 6 31s849ms 0ms 17s812ms 1m18s 09 0 0 1 0 37s331ms 0ms 0ms 0ms 10 0 0 1 0 43s74ms 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 1 0 37s350ms 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 31s10ms 0ms 0ms 53s917ms 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 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 8s769ms 0ms 0ms 8s769ms 09 0 0 1 0 43s798ms 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 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 09 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 10 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 1 15 15.00 6.67% 08 0 23 23.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 4 4.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 11 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 6 6.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 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 12 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 11 11.00 0.00% 08 0 12 12.00 0.00% 09 0 0 0.00 0.00% 10 0 1 1.00 0.00% 11 0 3 3.00 0.00% 12 0 11 11.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 13 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 1 14 14.00 7.14% 08 0 4 4.00 0.00% 09 0 1 1.00 0.00% 10 0 4 4.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 4 4.00 0.00% 14 0 1 1.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 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 14 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 1 1.00 0.00% 09 0 4 4.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 15 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% Day Hour Count Average / Second Nov 09 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 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 Nov 10 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 23 0.01/s 07 31 0.01/s 08 40 0.01/s 09 52 0.01/s 10 57 0.02/s 11 64 0.02/s 12 46 0.01/s 13 40 0.01/s 14 47 0.01/s 15 42 0.01/s 16 43 0.01/s 17 52 0.01/s 18 44 0.01/s 19 49 0.01/s 20 23 0.01/s 21 40 0.01/s 22 42 0.01/s 23 27 0.01/s Nov 11 00 46 0.01/s 01 35 0.01/s 02 49 0.01/s 03 46 0.01/s 04 45 0.01/s 05 38 0.01/s 06 19 0.01/s 07 30 0.01/s 08 25 0.01/s 09 57 0.02/s 10 46 0.01/s 11 46 0.01/s 12 56 0.02/s 13 40 0.01/s 14 43 0.01/s 15 60 0.02/s 16 40 0.01/s 17 33 0.01/s 18 36 0.01/s 19 53 0.01/s 20 36 0.01/s 21 37 0.01/s 22 53 0.01/s 23 27 0.01/s Nov 12 00 26 0.01/s 01 35 0.01/s 02 52 0.01/s 03 44 0.01/s 04 48 0.01/s 05 44 0.01/s 06 41 0.01/s 07 40 0.01/s 08 37 0.01/s 09 38 0.01/s 10 68 0.02/s 11 75 0.02/s 12 58 0.02/s 13 47 0.01/s 14 34 0.01/s 15 50 0.01/s 16 42 0.01/s 17 31 0.01/s 18 25 0.01/s 19 44 0.01/s 20 38 0.01/s 21 34 0.01/s 22 64 0.02/s 23 33 0.01/s Nov 13 00 45 0.01/s 01 34 0.01/s 02 49 0.01/s 03 45 0.01/s 04 30 0.01/s 05 46 0.01/s 06 42 0.01/s 07 46 0.01/s 08 13 0.00/s 09 80 0.02/s 10 76 0.02/s 11 72 0.02/s 12 46 0.01/s 13 43 0.01/s 14 42 0.01/s 15 62 0.02/s 16 53 0.01/s 17 61 0.02/s 18 31 0.01/s 19 53 0.01/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 14 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 4 0.00/s 08 196 0.05/s 09 66 0.02/s 10 54 0.01/s 11 38 0.01/s 12 24 0.01/s 13 59 0.02/s 14 62 0.02/s 15 75 0.02/s 16 51 0.01/s 17 28 0.01/s 18 3 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 Nov 15 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 2 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 09 00 3 76ms 76ms 01 3 74ms 74ms 02 3 75ms 75ms 03 3 76ms 76ms 04 3 77ms 77ms 05 3 71ms 71ms 06 3 71ms 71ms 07 3 72ms 72ms 08 3 77ms 77ms 09 3 75ms 75ms 10 3 72ms 72ms 11 3 72ms 72ms 12 3 71ms 71ms 13 3 73ms 73ms 14 3 77ms 77ms 15 3 76ms 76ms 16 3 81ms 81ms 17 3 77ms 77ms 18 3 71ms 71ms 19 3 78ms 78ms 20 3 75ms 75ms 21 3 75ms 75ms 22 3 75ms 75ms 23 3 72ms 72ms Nov 10 00 3 72ms 72ms 01 3 70ms 70ms 02 3 73ms 73ms 03 3 71ms 71ms 04 3 71ms 71ms 05 3 73ms 73ms 06 20 2m32s 2m32s 07 28 1m58s 1m54s 08 43 3m17s 3m11s 09 52 1m56s 1m56s 10 56 1m42s 1m42s 11 62 1m36s 1m36s 12 49 1m50s 1m50s 13 38 2m10s 2m10s 14 48 1m44s 1m44s 15 43 1m54s 1m54s 16 43 1m57s 1m57s 17 48 1m40s 1m40s 18 48 30m9s 30m9s 19 45 1m49s 1m49s 20 28 3m15s 3m14s 21 39 2m7s 2m7s 22 42 1m52s 1m52s 23 27 2m36s 2m36s Nov 11 00 46 1m56s 1m56s 01 35 2m5s 2m5s 02 49 1m51s 1m51s 03 45 1m59s 1m59s 04 46 1m57s 1m57s 05 37 2m7s 2m7s 06 20 2m37s 2m37s 07 29 3m11s 3m8s 08 26 4m6s 4m4s 09 57 1m41s 1m41s 10 47 1m43s 1m43s 11 45 1m44s 1m44s 12 53 1m52s 1m52s 13 43 1m57s 1m57s 14 40 1m48s 1m48s 15 60 1m34s 1m34s 16 43 1m55s 1m55s 17 34 2m22s 2m22s 18 36 1h20m38s 1h20m38s 19 51 1m47s 1m47s 20 35 2m38s 2m37s 21 39 2m2s 2m2s 22 53 1m54s 1m54s 23 25 3m2s 3m2s Nov 12 00 29 2m37s 2m37s 01 34 2m9s 2m8s 02 49 1m47s 1m47s 03 45 1m47s 1m47s 04 50 1m48s 1m48s 05 44 1m53s 1m53s 06 41 1m50s 1m50s 07 40 2m17s 2m15s 08 37 2m40s 2m38s 09 38 2m11s 2m11s 10 66 2m17s 2m17s 11 71 2m17s 2m14s 12 63 4m2s 3m55s 13 45 3m38s 3m38s 14 33 2m7s 2m7s 15 47 1m54s 1m54s 16 49 13m5s 13m5s 17 30 2m45s 2m45s 18 24 1h59m58s 1h59m58s 19 44 1m47s 1m47s 20 40 2m27s 2m26s 21 34 2m22s 2m22s 22 62 1m41s 1m41s 23 33 2m19s 2m19s Nov 13 00 46 1m53s 1m53s 01 34 1m56s 1m56s 02 48 1m54s 1m54s 03 43 1m57s 1m57s 04 34 2m16s 2m16s 05 46 1m46s 1m46s 06 42 2m15s 2m15s 07 41 2m6s 2m3s 08 20 1h33m5s 1h32m21s 09 78 1m57s 1m36s 10 72 2m3s 2m 11 79 2m40s 2m40s 12 46 2m8s 2m8s 13 41 2m39s 2m34s 14 41 3m7s 3m6s 15 63 6m10s 6m10s 16 42 1m56s 1m56s 17 74 2m7s 2m7s 18 32 37m30s 37m30s 19 55 3m42s 3m29s 20 3 100ms 100ms 21 3 79ms 79ms 22 3 76ms 76ms 23 3 76ms 76ms Nov 14 00 3 67ms 67ms 01 3 69ms 69ms 02 3 72ms 72ms 03 3 69ms 69ms 04 3 69ms 69ms 05 3 71ms 71ms 06 3 70ms 70ms 07 4 1s331ms 1s331ms 08 194 13s59ms 13s14ms 09 58 1m50s 1m46s 10 58 3m12s 3m12s 11 38 4m22s 4m22s 12 24 3m51s 3m51s 13 59 9m45s 9m45s 14 63 7m35s 7m35s 15 74 3m22s 3m22s 16 50 5m56s 5m56s 17 32 3m3s 3m3s 18 6 3h3m53s 3h3m53s 19 3 71ms 71ms 20 3 80ms 80ms 21 3 73ms 73ms 22 3 69ms 69ms 23 3 72ms 72ms Nov 15 00 3 72ms 72ms 01 3 69ms 69ms 02 3 69ms 69ms 03 3 69ms 69ms 04 3 67ms 67ms 05 3 69ms 69ms 06 3 79ms 79ms 07 3 71ms 71ms 08 3 80ms 80ms 09 3 71ms 71ms 10 3 70ms 70ms 11 3 70ms 70ms 12 3 73ms 73ms 13 3 75ms 75ms 14 3 70ms 70ms 15 3 70ms 70ms 16 3 71ms 71ms 17 3 75ms 75ms 18 2 72ms 72ms 19 3 86ms 86ms 20 3 70ms 70ms 21 3 71ms 71ms 22 3 74ms 74ms 23 3 68ms 68ms -
Connections
Established Connections
Key values
- 14 connections Connection Peak
- 2025-11-13 10:04:05 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 4,644 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,644 connections Total
-
Sessions
Simultaneous sessions
Key values
- 147 sessions Session Peak
- 2025-11-09 19:47:23 Date
Histogram of session times
Key values
- 3,666 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 4,647 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,647 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,647 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,647 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'autotest_feat_batch' 6 6h14m24s 1h2m24s DBeaver 23.2.0 - Metadata 'autotest_feat_batch' 6 6h14m9s 1h2m21s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 6 5h53m34s 58m55s IntelliJ IDEA 2024.3.5 6 4h9m16s 41m32s PostgreSQL JDBC Driver 4,032 14d12h14m29s 5m10s [unknown] 573 1m6s 116ms pg_restore 8 1h28m23s 11m2s psql 10 29m40s 2m58s -
Temporary Files
Size of temporary files
Key values
- 400.82 MiB Temp Files size Peak
- 2025-11-13 19:39:49 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-11-12 12:12:37 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 09 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 10 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 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 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 4.19 MiB 4.19 MiB 11 29 120.52 MiB 4.16 MiB 12 51 218.12 MiB 4.28 MiB 13 1 4.19 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 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 1 4.19 MiB 4.19 MiB 08 166 3.81 GiB 23.53 MiB 09 1 4.19 MiB 4.19 MiB 10 25 106.85 MiB 4.27 MiB 11 2 8.38 MiB 4.19 MiB 12 0 0 0 13 25 106.91 MiB 4.28 MiB 14 0 0 0 15 0 0 0 16 1 4.19 MiB 4.19 MiB 17 1 4.19 MiB 4.19 MiB 18 0 0 0 19 154 3.75 GiB 24.95 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 1 4.19 MiB 4.19 MiB 09 27 113.33 MiB 4.20 MiB 10 1 4.19 MiB 4.19 MiB 11 0 0 0 12 0 0 0 13 1 4.19 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 2 9.49 MiB 4.75 MiB 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 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 30 213.88 MiB 2.48 MiB 28.90 MiB 7.13 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('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', '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-12 12:35:54 Duration: 6s828ms 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('202001021357', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021357', '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-13 13:57:27 Duration: 6s9ms 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('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', '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-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 6 651.47 MiB 3.91 MiB 625.75 MiB 108.58 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-13 19:39:40 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 6 15.24 MiB 2.24 MiB 2.93 MiB 2.54 MiB select goc.obj_num_id from gtp_obj_composition goc where position(? in goc.obj_compo_value) <> ?;-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION($1 in goc.obj_compo_value) <> 0;
Date: 2025-11-12 12:35:29 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
4 6 1.23 GiB 30.80 MiB 643.86 MiB 210.60 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-13 19:37:53 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6 573.98 MiB 50.93 MiB 273.83 MiB 95.66 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-13 19:39:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6 285.70 MiB 27.95 MiB 129.50 MiB 47.62 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-13 19:41:42 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6 26.30 MiB 3.45 MiB 5.84 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-13 19:42:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6 277.64 MiB 10.22 MiB 220.08 MiB 46.27 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-13 19:42:37 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6 541.92 MiB 13.13 MiB 260.31 MiB 90.32 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-13 19:40:50 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6 415.26 MiB 4.92 MiB 336.88 MiB 69.21 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-13 19:40:26 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 208.55 MiB 21.46 MiB 76.85 MiB 34.76 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-13 19:42:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 393.23 MiB 3.78 MiB 315.60 MiB 65.54 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-13 19:39:23 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6 1.83 GiB 114.52 MiB 720.55 MiB 311.74 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-13 19:38:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 6 411.01 MiB 21.57 MiB 294.83 MiB 68.50 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-13 19:41:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 6 207.97 MiB 28.25 MiB 52.59 MiB 34.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-13 19:39:36 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3 14.72 MiB 4.69 MiB 5.12 MiB 4.91 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-13 19:42:46 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 3 106.02 MiB 2.05 MiB 95.67 MiB 35.34 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-13 19:40:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 3 109.73 MiB 2.34 MiB 104.54 MiB 36.58 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-13 08:24:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-14 09:48:06 Duration: 3m15s 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-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
20 2 47.53 MiB 20.67 MiB 26.86 MiB 23.77 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-13 19:39:45 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 2 34.50 MiB 8.76 MiB 25.74 MiB 17.25 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-13 19:42:44 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 254.19 MiB 254.19 MiB 254.19 MiB 254.19 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-13 08:21:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 14.68 MiB 14.68 MiB 14.68 MiB 14.68 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-13 19:41:10 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 720.55 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-13 19:38:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 643.86 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-13 19:37:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 632.30 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-13 08:19:28 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 625.75 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-13 08:18:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 494.02 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-11-13 08:18:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 336.88 MiB ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);[ Date: 2025-11-13 19:40:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 315.60 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2025-11-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 294.83 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-13 08:22:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 273.83 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-13 19:39:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 260.31 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-13 19:40:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 254.19 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-13 08:21:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 220.08 MiB ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-11-13 08:23:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 219.42 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-13 08:23:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 147.72 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-13 08:20:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 129.50 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);[ Date: 2025-11-13 19:41:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 128.62 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-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 126.70 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-13 19:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 114.52 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-13 08:20:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 104.54 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-11-13 08:24:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 95.67 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-11-13 19:40:34 - 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 09 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 10 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 11 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 12 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 13 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 14 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 15 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
- 7 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 28 Total read queries
- 199 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 240 Requests
- 1h32m42s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 240 Requests
User Request type Count Duration a3dsupervisor Total 240 1h32m42s copy from 12 7m8s ddl 67 15m14s delete 9 5m9s insert 7 43s994ms others 13 47m49s select 28 3m13s tcl 101 12m49s update 3 35s42ms Duration by user
Key values
- 1h32m42s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 240 1h32m42s copy from 12 7m8s ddl 67 15m14s delete 9 5m9s insert 7 43s994ms others 13 47m49s select 28 3m13s tcl 101 12m49s update 3 35s42ms Queries by host
Key values
- 10.3.0.4 Main host
- 240 Requests
- 1h32m42s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 151 Requests
- 39m51s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-12 14:49:43 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 167 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 27m13s VACUUM ANALYSE;[ Date: 2025-11-13 09:11:53 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 3m34s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-13 10:12:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 3m15s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-14 09:48:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 3m7s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 11:56:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 2m44s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-13 13:55:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 2m39s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:33:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 2m25s VACUUM ANALYSE;[ Date: 2025-11-13 19:55:44 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 2m2s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-11-12 12:09:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 1m18s 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-13 08:18:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 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-13 19:37:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 49s954ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 12:03:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 46s177ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-12 12:22:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
13 44s373ms 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-13 08:21:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 43s798ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-14 09:55:10 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
15 43s644ms 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-13 08:20:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 43s74ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 10:16:59 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 42s542ms 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-13 08:17:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 37s350ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 14:00:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 37s331ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-11-13 09:16:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 35s577ms 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-13 19:37:15 - 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 29m39s 2 2m25s 27m13s 14m49s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 17m22s 6 2m2s 3m34s 2m53s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s Nov 14 10 1 3m15s 3m15s [ User: a3dsupervisor - Total duration: 17m22s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17m22s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-14 09:48:06 Duration: 3m15s 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-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 12m49s 101 5s10ms 23s675ms 7s615ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 10 08 14 1m47s 7s686ms 09 19 3m15s 10s279ms 21 4 30s594ms 7s648ms Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 12m49s - Times executed: 101 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12m42s - Times executed: 100 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s675ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s522ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s504ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 5m9s 9 8s769ms 49s954ms 34s366ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms Nov 14 09 1 8s769ms 8s769ms 10 1 43s798ms 43s798ms [ User: a3dsupervisor - Total duration: 5m9s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m9s - Times executed: 9 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms 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-12 12:22:11 Duration: 46s177ms 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-14 09:55:10 Duration: 43s798ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 2m24s 2 1m5s 1m18s 1m12s 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 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-13 08:18:19 Duration: 1m18s 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-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m19s 2 35s292ms 44s373ms 39s833ms 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 #6
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:21:34 Duration: 44s373ms 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-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m19s 2 35s390ms 43s644ms 39s517ms 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 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:20:49 Duration: 43s644ms 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-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m18s 2 35s577ms 42s542ms 39s60ms 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 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-13 08:17:42 Duration: 42s542ms 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-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m 2 27s700ms 32s916ms 30s308ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms 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-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 52s681ms 2 18s624ms 34s57ms 26s340ms 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 #10
Day Hour Count Duration Avg duration Nov 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
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-13 08:21:23 Duration: 34s57ms 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-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 48s381ms 2 23s753ms 24s628ms 24s190ms 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 #11
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms 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-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 47s403ms 5 9s201ms 9s900ms 9s480ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms Nov 13 11 1 9s391ms 9s391ms 14 1 9s201ms 9s201ms Nov 14 10 1 9s900ms 9s900ms [ User: a3dsupervisor - Total duration: 47s403ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 47s403ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-14 09:44:39 Duration: 9s900ms 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-12 12:31:10 Duration: 9s467ms 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-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 46s823ms 2 14s953ms 31s869ms 23s411ms 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 #13
Day Hour Count Duration Avg duration Nov 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
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-13 08:19:43 Duration: 31s869ms 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-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 43s462ms 7 5s443ms 7s636ms 6s208ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 13 09 7 43s462ms 6s208ms [ User: a3dsupervisor - Total duration: 43s462ms - Times executed: 7 ]
[ Application: pg_restore - Total duration: 43s462ms - Times executed: 7 ]
-
SELECT pg_catalog.lo_create('2804486');
Date: 2025-11-13 08:33:07 Duration: 7s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804017');
Date: 2025-11-13 08:30:32 Duration: 6s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804341');
Date: 2025-11-13 08:32:02 Duration: 6s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 40s802ms 2 16s95ms 24s706ms 20s401ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 38s904ms 6 5s202ms 8s131ms 6s484ms 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 #16
Day Hour Count Duration Avg duration Nov 10 09 1 6s145ms 6s145ms Nov 11 21 1 6s959ms 6s959ms Nov 12 08 1 8s131ms 8s131ms 09 2 10s404ms 5s202ms Nov 13 09 1 7s263ms 7s263ms [ User: a3dsupervisor - Total duration: 38s904ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s904ms - Times executed: 6 ]
-
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-12 07:26:10 Duration: 8s131ms 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-13 08:01:02 Duration: 7s263ms 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-11 20:42:33 Duration: 6s959ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 38s564ms 5 5s177ms 12s233ms 7s712ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms Nov 13 08 1 12s233ms 12s233ms 11 1 7s329ms 7s329ms 14 1 6s25ms 6s25ms [ User: a3dsupervisor - Total duration: 38s564ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s564ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-13 07:35:45 Duration: 12s233ms 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-12 12:11:42 Duration: 7s799ms 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-13 10:13:53 Duration: 7s329ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 38s172ms 2 18s48ms 20s123ms 19s86ms 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 13 09 1 18s48ms 18s48ms 20 1 20s123ms 20s123ms [ User: a3dsupervisor - Total duration: 38s172ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 38s172ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 19:38:05 Duration: 20s123ms 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-13 08:18:37 Duration: 18s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 36s408ms 2 17s48ms 19s360ms 18s204ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 13 09 1 17s48ms 17s48ms 20 1 19s360ms 19s360ms [ User: a3dsupervisor - Total duration: 36s408ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s408ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 19:39:11 Duration: 19s360ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 08:20:00 Duration: 17s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 35s901ms 2 13s18ms 22s883ms 17s950ms 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 13 09 1 22s883ms 22s883ms 20 1 13s18ms 13s18ms [ User: a3dsupervisor - Total duration: 35s901ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s901ms - Times executed: 2 ]
-
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-13 08:23:45 Duration: 22s883ms 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-13 19:41:59 Duration: 13s18ms 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 101 12m49s 5s10ms 23s675ms 7s615ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 08 14 1m47s 7s686ms 09 19 3m15s 10s279ms 21 4 30s594ms 7s648ms Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 12m49s - Times executed: 101 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12m42s - Times executed: 100 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s675ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s522ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s504ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 9 5m9s 8s769ms 49s954ms 34s366ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms Nov 14 09 1 8s769ms 8s769ms 10 1 43s798ms 43s798ms [ User: a3dsupervisor - Total duration: 5m9s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m9s - Times executed: 9 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms 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-12 12:22:11 Duration: 46s177ms 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-14 09:55:10 Duration: 43s798ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 7 43s462ms 5s443ms 7s636ms 6s208ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 09 7 43s462ms 6s208ms [ User: a3dsupervisor - Total duration: 43s462ms - Times executed: 7 ]
[ Application: pg_restore - Total duration: 43s462ms - Times executed: 7 ]
-
SELECT pg_catalog.lo_create('2804486');
Date: 2025-11-13 08:33:07 Duration: 7s636ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804017');
Date: 2025-11-13 08:30:32 Duration: 6s453ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2804341');
Date: 2025-11-13 08:32:02 Duration: 6s304ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6 17m22s 2m2s 3m34s 2m53s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s Nov 14 10 1 3m15s 3m15s [ User: a3dsupervisor - Total duration: 17m22s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17m22s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-14 09:48:06 Duration: 3m15s 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-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6 38s904ms 5s202ms 8s131ms 6s484ms 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 #5
Day Hour Count Duration Avg duration Nov 10 09 1 6s145ms 6s145ms Nov 11 21 1 6s959ms 6s959ms Nov 12 08 1 8s131ms 8s131ms 09 2 10s404ms 5s202ms Nov 13 09 1 7s263ms 7s263ms [ User: a3dsupervisor - Total duration: 38s904ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s904ms - Times executed: 6 ]
-
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-12 07:26:10 Duration: 8s131ms 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-13 08:01:02 Duration: 7s263ms 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-11 20:42:33 Duration: 6s959ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 5 47s403ms 9s201ms 9s900ms 9s480ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms Nov 13 11 1 9s391ms 9s391ms 14 1 9s201ms 9s201ms Nov 14 10 1 9s900ms 9s900ms [ User: a3dsupervisor - Total duration: 47s403ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 47s403ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-14 09:44:39 Duration: 9s900ms 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-12 12:31:10 Duration: 9s467ms 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-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5 38s564ms 5s177ms 12s233ms 7s712ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms Nov 13 08 1 12s233ms 12s233ms 11 1 7s329ms 7s329ms 14 1 6s25ms 6s25ms [ User: a3dsupervisor - Total duration: 38s564ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s564ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-13 07:35:45 Duration: 12s233ms 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-12 12:11:42 Duration: 7s799ms 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-13 10:13:53 Duration: 7s329ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 4 27s905ms 5s652ms 8s115ms 6s976ms select 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 Time consuming queries #8
Day Hour Count Duration Avg duration Nov 10 09 1 5s652ms 5s652ms Nov 11 21 1 6s958ms 6s958ms Nov 12 08 1 8s115ms 8s115ms Nov 13 09 1 7s179ms 7s179ms [ User: a3dsupervisor - Total duration: 27s905ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s905ms - Times executed: 4 ]
-
select 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 =;
Date: 2025-11-12 07:26:10 Duration: 8s115ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select 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 =;
Date: 2025-11-13 08:01:02 Duration: 7s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select 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 =;
Date: 2025-11-11 20:42:33 Duration: 6s958ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 4 23s626ms 5s347ms 6s828ms 5s906ms 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 #9
Day Hour Count Duration Avg duration Nov 12 12 1 5s347ms 5s347ms 13 2 12s268ms 6s134ms Nov 13 14 1 6s9ms 6s9ms [ User: a3dsupervisor - Total duration: 23s626ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 23s626ms - Times executed: 4 ]
-
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('202001021235', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021235', '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-12 12:35:54 Duration: 6s828ms 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('202001021357', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021357', '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-13 13:57:27 Duration: 6s9ms 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('202001021212', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021212', '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-12 12:12:22 Duration: 5s440ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
10 3 28s577ms 7s387ms 10s761ms 9s525ms 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 #10
Day Hour Count Duration Avg duration Nov 11 02 1 10s427ms 10s427ms Nov 12 02 1 10s761ms 10s761ms Nov 13 02 1 7s387ms 7s387ms [ User: a3dsupervisor - Total duration: 28s577ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28s577ms - Times executed: 3 ]
-
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-12 01:01:07 Duration: 10s761ms 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-11 01:01:26 Duration: 10s427ms 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-13 01:01:04 Duration: 7s387ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 2 29m39s 2m25s 27m13s 14m49s vacuum analyse;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 2 2m24s 1m5s 1m18s 1m12s 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 #12
Day Hour Count Duration Avg duration Nov 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-13 08:18:19 Duration: 1m18s 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-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2 1m19s 35s292ms 44s373ms 39s833ms 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 #13
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:21:34 Duration: 44s373ms 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-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 1m19s 35s390ms 43s644ms 39s517ms 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 #14
Day Hour Count Duration Avg duration Nov 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:20:49 Duration: 43s644ms 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-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 1m18s 35s577ms 42s542ms 39s60ms 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 #15
Day Hour Count Duration Avg duration Nov 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-13 08:17:42 Duration: 42s542ms 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-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 1m 27s700ms 32s916ms 30s308ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms 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-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 52s681ms 18s624ms 34s57ms 26s340ms 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 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
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-13 08:21:23 Duration: 34s57ms 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-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 48s381ms 23s753ms 24s628ms 24s190ms 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 #18
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms 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-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 46s823ms 14s953ms 31s869ms 23s411ms 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 #19
Day Hour Count Duration Avg duration Nov 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
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-13 08:19:43 Duration: 31s869ms 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-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2 40s802ms 16s95ms 24s706ms 20s401ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms 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 2m25s 27m13s 14m49s 2 29m39s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 10 1 27m13s 27m13s 20 1 2m25s 2m25s [ User: a3dsupervisor - Total duration: 29m39s - Times executed: 2 ]
[ Application: psql - Total duration: 29m39s - Times executed: 2 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:11:53 Duration: 27m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 19:55:44 Duration: 2m25s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 2m2s 3m34s 2m53s 6 17m22s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 12 12 1 3m7s 3m7s 13 2 4m41s 2m20s Nov 13 11 1 3m34s 3m34s 14 1 2m44s 2m44s Nov 14 10 1 3m15s 3m15s [ User: a3dsupervisor - Total duration: 17m22s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 17m22s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-11-13 10:12:38 Duration: 3m34s 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-14 09:48:06 Duration: 3m15s 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-12 11:56:54 Duration: 3m7s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 1m5s 1m18s 1m12s 2 2m24s 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 #3
Day Hour Count Duration Avg duration Nov 13 09 1 1m18s 1m18s 20 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 2 ]
-
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-13 08:18:19 Duration: 1m18s 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-13 19:37:45 Duration: 1m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 35s292ms 44s373ms 39s833ms 2 1m19s 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 #4
Day Hour Count Duration Avg duration Nov 13 09 1 44s373ms 44s373ms 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:21:34 Duration: 44s373ms 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-13 19:40:35 Duration: 35s292ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 35s390ms 43s644ms 39s517ms 2 1m19s 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 #5
Day Hour Count Duration Avg duration Nov 13 09 1 43s644ms 43s644ms 20 1 35s390ms 35s390ms [ User: a3dsupervisor - Total duration: 1m19s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m19s - Times executed: 2 ]
-
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-13 08:20:49 Duration: 43s644ms 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-13 19:39:49 Duration: 35s390ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 35s577ms 42s542ms 39s60ms 2 1m18s 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 #6
Day Hour Count Duration Avg duration Nov 13 09 1 42s542ms 42s542ms 20 1 35s577ms 35s577ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m18s - Times executed: 2 ]
-
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-13 08:17:42 Duration: 42s542ms 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-13 19:37:15 Duration: 35s577ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 8s769ms 49s954ms 34s366ms 9 5m9s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 12 11 1 11s78ms 11s78ms 13 3 2m7s 42s632ms Nov 13 10 1 37s331ms 37s331ms 11 1 43s74ms 43s74ms 15 1 37s350ms 37s350ms Nov 14 09 1 8s769ms 8s769ms 10 1 43s798ms 43s798ms [ User: a3dsupervisor - Total duration: 5m9s - Times executed: 9 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5m9s - Times executed: 9 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-12 12:03:13 Duration: 49s954ms 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-12 12:22:11 Duration: 46s177ms 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-14 09:55:10 Duration: 43s798ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 27s700ms 32s916ms 30s308ms 2 1m create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 13 09 1 32s916ms 32s916ms 20 1 27s700ms 27s700ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 2 ]
[ Application: pg_restore - Total duration: 1m - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-11-13 08:18:55 Duration: 32s916ms 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-13 19:38:22 Duration: 27s700ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 18s624ms 34s57ms 26s340ms 2 52s681ms 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 #9
Day Hour Count Duration Avg duration Nov 13 09 1 34s57ms 34s57ms 20 1 18s624ms 18s624ms [ User: a3dsupervisor - Total duration: 52s681ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 52s681ms - Times executed: 2 ]
-
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-13 08:21:23 Duration: 34s57ms 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-13 19:40:09 Duration: 18s624ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 23s753ms 24s628ms 24s190ms 2 48s381ms 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 #10
Day Hour Count Duration Avg duration Nov 13 09 1 24s628ms 24s628ms 20 1 23s753ms 23s753ms [ User: a3dsupervisor - Total duration: 48s381ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 48s381ms - Times executed: 2 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-11-13 08:18:07 Duration: 24s628ms 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-13 19:37:39 Duration: 23s753ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 14s953ms 31s869ms 23s411ms 2 46s823ms 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 13 09 1 31s869ms 31s869ms 20 1 14s953ms 14s953ms [ User: a3dsupervisor - Total duration: 46s823ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 46s823ms - Times executed: 2 ]
-
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-13 08:19:43 Duration: 31s869ms 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-13 19:38:52 Duration: 14s953ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 16s95ms 24s706ms 20s401ms 2 40s802ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 13 09 1 24s706ms 24s706ms 20 1 16s95ms 16s95ms [ User: a3dsupervisor - Total duration: 40s802ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 40s802ms - Times executed: 2 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 08:19:11 Duration: 24s706ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-13 19:38:28 Duration: 16s95ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 18s48ms 20s123ms 19s86ms 2 38s172ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 13 09 1 18s48ms 18s48ms 20 1 20s123ms 20s123ms [ User: a3dsupervisor - Total duration: 38s172ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 38s172ms - Times executed: 2 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-11-13 19:38:05 Duration: 20s123ms 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-13 08:18:37 Duration: 18s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 17s48ms 19s360ms 18s204ms 2 36s408ms create index i_gtp_obj_rel_vt_objp_vt on public.gtp_obj_rel_vt using btree (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 13 09 1 17s48ms 17s48ms 20 1 19s360ms 19s360ms [ User: a3dsupervisor - Total duration: 36s408ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 36s408ms - Times executed: 2 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 19:39:11 Duration: 19s360ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id_p, view_template_num_id);
Date: 2025-11-13 08:20:00 Duration: 17s48ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 13s18ms 22s883ms 17s950ms 2 35s901ms 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 #15
Day Hour Count Duration Avg duration Nov 13 09 1 22s883ms 22s883ms 20 1 13s18ms 13s18ms [ User: a3dsupervisor - Total duration: 35s901ms - Times executed: 2 ]
[ Application: pg_restore - Total duration: 35s901ms - Times executed: 2 ]
-
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-13 08:23:45 Duration: 22s883ms 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-13 19:41:59 Duration: 13s18ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 7s387ms 10s761ms 9s525ms 3 28s577ms 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 #16
Day Hour Count Duration Avg duration Nov 11 02 1 10s427ms 10s427ms Nov 12 02 1 10s761ms 10s761ms Nov 13 02 1 7s387ms 7s387ms [ User: a3dsupervisor - Total duration: 28s577ms - Times executed: 3 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 28s577ms - Times executed: 3 ]
-
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-12 01:01:07 Duration: 10s761ms 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-11 01:01:26 Duration: 10s427ms 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-13 01:01:04 Duration: 7s387ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 9s201ms 9s900ms 9s480ms 5 47s403ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 12 13 2 18s909ms 9s454ms Nov 13 11 1 9s391ms 9s391ms 14 1 9s201ms 9s201ms Nov 14 10 1 9s900ms 9s900ms [ User: a3dsupervisor - Total duration: 47s403ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 47s403ms - Times executed: 5 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-11-14 09:44:39 Duration: 9s900ms 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-12 12:31:10 Duration: 9s467ms 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-12 12:07:09 Duration: 9s442ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 5s177ms 12s233ms 7s712ms 5 38s564ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 12 13 2 12s976ms 6s488ms Nov 13 08 1 12s233ms 12s233ms 11 1 7s329ms 7s329ms 14 1 6s25ms 6s25ms [ User: a3dsupervisor - Total duration: 38s564ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 38s564ms - Times executed: 5 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-11-13 07:35:45 Duration: 12s233ms 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-12 12:11:42 Duration: 7s799ms 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-13 10:13:53 Duration: 7s329ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 5s10ms 23s675ms 7s615ms 101 12m49s commit;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 10 08 14 1m47s 7s686ms 09 19 3m15s 10s279ms 21 4 30s594ms 7s648ms Nov 11 08 13 1m29s 6s913ms 09 6 54s913ms 9s152ms 21 5 29s772ms 5s954ms Nov 12 08 9 1m1s 6s844ms 09 10 1m8s 6s847ms 21 7 39s810ms 5s687ms Nov 13 08 12 1m17s 6s489ms 09 2 13s323ms 6s661ms [ User: a3dsupervisor - Total duration: 12m49s - Times executed: 101 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12m42s - Times executed: 100 ]
[ Application: pg_restore - Total duration: 6s710ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s675ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s522ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 08:13:56 Duration: 23s504ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s652ms 8s115ms 6s976ms 4 27s905ms select 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 Time consuming queries #20
Day Hour Count Duration Avg duration Nov 10 09 1 5s652ms 5s652ms Nov 11 21 1 6s958ms 6s958ms Nov 12 08 1 8s115ms 8s115ms Nov 13 09 1 7s179ms 7s179ms [ User: a3dsupervisor - Total duration: 27s905ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s905ms - Times executed: 4 ]
-
select 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 =;
Date: 2025-11-12 07:26:10 Duration: 8s115ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select 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 =;
Date: 2025-11-13 08:01:02 Duration: 7s179ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select 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 =;
Date: 2025-11-11 20:42:33 Duration: 6s958ms 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 1 7s330ms 1 7s330ms 7s330ms 7s330ms UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Nov 14 08 1 7s330ms 7s330ms [ User: a3dsupervisor - Total duration: 9s52ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9s52ms - Times executed: 1 ]
-
UPDATE GED_DOCUMENT gd SET DEL_ACTION_NUM_ID = null, DOCUMENT_CONTENT_TO_REMOVE = 1 where gd.PROJECT_NUM_ID = 1 and gd.document_num_id not in ( select gd.document_num_id from gtp_att_template gat inner join gtp_obj_composition ga ON gat.att_template_num_id = ga.att_template_num_id and ga.obj_compo_value = TO_CHAR(gd.document_num_id) where gat.att_template_domain_code = 'FIL');
Date: 2025-11-10 07:59:37 Duration: 7s330ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s449ms 1 5s449ms 5s449ms 5s449ms select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Nov 14 09 1 5s449ms 5s449ms [ User: a3dsupervisor - Total duration: 5s75ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s75ms - Times executed: 1 ]
-
select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);
Date: 2025-11-10 08:13:37 Duration: 5s449ms Database: autotest_feat_batch User: autotest_feat_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 18,378 Log entries
Events distribution
Key values
- 0 PANIC entries
- 7 FATAL entries
- 3595 ERROR entries
- 85 WARNING entries
Most Frequent Errors/Events
Key values
- 3,320 Max number of times the same event was reported
- 3,687 Total events found
Rank Times reported Error 1 3,320 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 13 10 51 11 276 12 140 13 241 14 550 15 2 16 1 18 2 Nov 14 10 101 11 937 12 785 13 234 2 49 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 10 19 3 Nov 11 19 3 Nov 12 11 2 12 2 13 2 17 3 19 3 Nov 13 12 6 18 4 19 3 Nov 14 11 2 14 7 15 2 16 4 19 3 3 48 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 12 12 8 13 16 Nov 13 11 8 14 8 Nov 14 10 8 4 36 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 12 12 6 13 12 Nov 13 11 6 14 6 Nov 14 10 6 5 12 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 12 12 2 13 4 Nov 13 11 2 14 2 Nov 14 10 2 6 12 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 13 10 1 14 8 15 2 Nov 14 09 1 7 10 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 #7
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 8 10 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 9 10 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 10 10 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 11 10 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 #11
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 12 10 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 #12
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 13 10 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 #13
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 14 10 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 #14
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 15 10 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 #15
Day Hour Count Nov 13 10 1 20 1 Nov 14 09 8 16 6 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 17 6 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 #17
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 18 6 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 #18
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 19 6 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 20 6 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 #20
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 21 6 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 #21
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 22 6 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 23 6 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 24 6 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 25 6 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 26 6 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 #26
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 27 6 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 28 6 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #28
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 29 6 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #29
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 30 6 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #30
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 31 6 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #31
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 32 6 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 #32
Day Hour Count Nov 12 12 1 13 2 Nov 13 11 1 14 1 Nov 14 10 1 33 3 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #33
Day Hour Count Nov 13 18 3 34 3 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #34
Day Hour Count Nov 13 09 3 35 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #35
Day Hour Count Nov 12 14 2 36 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 #36
Day Hour Count Nov 13 09 1 20 1 37 2 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 #37
Day Hour Count Nov 12 12 1 13 1 38 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #38
Day Hour Count Nov 13 20 1 39 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #39
Day Hour Count Nov 13 09 1 40 1 WARNING: there is no transaction in progress
Times Reported Most Frequent Error / Event #40
Day Hour Count Nov 14 16 1 41 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #41
Day Hour Count Nov 13 09 1 42 1 FATAL: connection to client lostcall pack_gtp_dba.p_anonymization_ged()
Times Reported Most Frequent Error / Event #42
Day Hour Count Nov 12 12 1 43 1 LOG: could not send data to client: Broken pipecall pack_gtp_dba.p_anonymization_ged()
Times Reported Most Frequent Error / Event #43
Day Hour Count Nov 12 12 1