pgBadger-
Global information
- Generated on Mon Oct 20 09:35:13 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=18/h=23/m=00/PT1H.log
- Parsed 27,687 log entries in 1m3s
- Log start from 2025-10-13 17:01:48 to 2025-10-18 17:01:10
-
Overview
Global Stats
- 103 Number of unique normalized queries
- 355 Number of queries
- 2h14m33s Total query duration
- 2025-10-13 06:14:12 First query
- 2025-10-18 00:01:16 Last query
- 4 queries/s at 2025-10-14 15:41:11 Query peak
- 2h14m33s Total query duration
- 27s996ms Prepare/parse total duration
- 10s600ms Bind total duration
- 2h13m54s Execute total duration
- 6,267 Number of events
- 52 Number of unique normalized events
- 5,661 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
- 1,046 Number temporary file
- 1.12 GiB Max size of temporary file
- 20.42 MiB Average size of temporary file
- 4,447 Total number of sessions
- 80 sessions at 2025-10-18 17:50:23 Session peak
- 22d8h48m42s Total duration of sessions
- 7m14s Average duration of sessions
- 0 Average queries per session
- 1s815ms Average queries duration per session
- 7m12s Average idle time per session
- 4,446 Total number of connections
- 11 connections/s at 2025-10-15 18:57:08 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-10-14 15:41:11 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-13 06:14:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-10-16 19:45:21 Date
Queries duration
Key values
- 2h14m33s 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) Oct 12 00 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 Oct 13 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 14 0ms 18s957ms 6s911ms 0ms 18s957ms 36s741ms 07 13 0ms 25s967ms 8s250ms 18s403ms 25s967ms 34s740ms 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 39 0ms 1m56s 19s856ms 2m12s 2m26s 3m6s 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 Oct 14 00 1 0ms 5s735ms 5s735ms 0ms 5s735ms 5s735ms 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 7 0ms 12s599ms 6s890ms 7s249ms 12s644ms 15s739ms 07 1 0ms 5s254ms 5s254ms 0ms 0ms 5s254ms 08 1 0ms 17s850ms 17s850ms 0ms 0ms 17s850ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 9 0ms 4m 42s434ms 32s802ms 50s528ms 4m 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 5 0ms 3m24s 1m17s 0ms 9s326ms 6m12s 13 12 0ms 3m47s 50s545ms 28s196ms 1m8s 7m10s 14 5 0ms 3m39s 1m3s 9s434ms 1m15s 3m39s 15 11 0ms 3m42s 1m1s 36s291ms 47s46ms 9m17s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 35 0ms 2m20s 21s76ms 2m23s 2m46s 2m46s 19 3 0ms 6s574ms 5s974ms 0ms 0ms 17s924ms 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 Oct 15 00 1 0ms 5s731ms 5s731ms 0ms 5s731ms 5s731ms 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 18 0ms 7s746ms 6s42ms 18s178ms 28s807ms 34s217ms 07 1 0ms 6s118ms 6s118ms 0ms 0ms 6s118ms 08 1 0ms 20s465ms 20s465ms 0ms 0ms 20s465ms 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 7 0ms 4m8s 50s651ms 14s330ms 1m1s 4m8s 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 1 0ms 4m36s 4m36s 0ms 0ms 4m36s 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 36 0ms 2m12s 21s581ms 2m1s 2m12s 2m50s 19 1 0ms 5s12ms 5s12ms 0ms 5s12ms 5s12ms 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 Oct 16 00 1 0ms 5s656ms 5s656ms 0ms 5s656ms 5s656ms 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 6 0ms 43s718ms 21s219ms 5s547ms 42s148ms 43s718ms 07 27 0ms 11s517ms 6s593ms 23s718ms 29s384ms 42s662ms 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 35 0ms 2m4s 20s347ms 2m3s 2m4s 2m19s 19 9 0ms 7s650ms 6s228ms 0ms 10s227ms 45s825ms 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 Oct 17 00 1 0ms 5s993ms 5s993ms 0ms 5s993ms 5s993ms 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 7 0ms 8s57ms 6s224ms 8s57ms 13s699ms 15s720ms 07 1 0ms 5s956ms 5s956ms 0ms 0ms 5s956ms 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 7 0ms 4m3s 57s562ms 1m6s 4m3s 4m3s 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 38 0ms 1m54s 19s996ms 1m54s 2m 3m 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 Oct 18 00 1 0ms 5s975ms 5s975ms 0ms 5s975ms 5s975ms 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) Oct 12 00 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 Oct 13 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 2 0 5s259ms 0ms 0ms 10s519ms 07 2 0 6s147ms 0ms 0ms 6s465ms 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 Oct 14 00 1 0 5s735ms 0ms 0ms 5s735ms 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 6 0 13s354ms 0ms 13s948ms 32s802ms 11 0 0 0ms 0ms 0ms 0ms 12 1 0 7s123ms 0ms 0ms 7s123ms 13 7 0 10s547ms 0ms 7s860ms 24s925ms 14 2 0 6s217ms 0ms 0ms 12s434ms 15 5 0 11s587ms 0ms 6s117ms 36s291ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 1 0 5s439ms 0ms 0ms 5s439ms 19 1 0 5s343ms 0ms 0ms 5s343ms 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 Oct 15 00 1 0 5s731ms 0ms 0ms 5s731ms 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 4 0 8s281ms 0ms 6s37ms 14s330ms 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 Oct 16 00 1 0 5s656ms 0ms 0ms 5s656ms 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 1 0 42s148ms 0ms 0ms 42s148ms 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 Oct 17 00 1 0 5s993ms 0ms 0ms 5s993ms 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 4 0 20s389ms 0ms 13s668ms 55s176ms 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 Oct 18 00 1 0 5s975ms 0ms 0ms 5s975ms 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) Oct 12 00 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 Oct 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 1 0 1 0 12s111ms 0ms 0ms 5s264ms 07 1 1 0 0 16s277ms 0ms 0ms 6s587ms 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 1 6 32s427ms 0ms 12s728ms 1m5s 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 Oct 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 1 0 0 12s599ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 17s850ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 1 0 50s528ms 0ms 0ms 50s528ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 1 1 0 0 1m24s 0ms 0ms 9s48ms 13 1 0 3 0 2m5s 0ms 0ms 3m5s 14 0 0 1 0 1m15s 0ms 0ms 0ms 15 0 0 1 0 47s46ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 6 30s351ms 0ms 17s529ms 1m19s 19 1 0 0 0 6s5ms 0ms 0ms 6s5ms 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 Oct 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 1 0 20s465ms 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 1 0 1m1s 0ms 0ms 1m1s 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 1 0 0 4m36s 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 1 7 29s53ms 0ms 8s442ms 39s126ms 19 1 0 0 0 5s12ms 0ms 0ms 5s12ms 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 Oct 16 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 1 1 0 31s785ms 0ms 0ms 19s851ms 07 2 0 0 0 6s398ms 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 1 6 30s546ms 0ms 7s906ms 54s553ms 19 2 0 0 0 6s227ms 0ms 0ms 12s455ms 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 Oct 17 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 1 0 1m6s 0ms 0ms 1m6s 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 1 6 31s100ms 0ms 14s44ms 1m 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 Oct 18 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 Oct 12 00 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% Oct 13 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 2 14 7.00 14.29% 07 0 13 13.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 1 1.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% Oct 14 00 0 1 1.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 1 7 7.00 14.29% 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 9 9.00 0.00% 11 0 0 0.00 0.00% 12 0 5 5.00 0.00% 13 0 12 12.00 0.00% 14 0 5 5.00 0.00% 15 0 11 11.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 1 3 3.00 33.33% 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% Oct 15 00 0 1 1.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 18 18.00 0.00% 07 0 1 1.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 7 7.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 1 1.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.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% Oct 16 00 0 1 1.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 6 6.00 0.00% 07 0 27 27.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 1 1.00 0.00% 19 0 9 9.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% Oct 17 00 0 1 1.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 7 7.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 7 7.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 1 1.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% Oct 18 00 0 1 1.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 Oct 12 00 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Oct 13 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 29 0.01/s 06 47 0.01/s 07 38 0.01/s 08 59 0.02/s 09 56 0.02/s 10 42 0.01/s 11 64 0.02/s 12 37 0.01/s 13 50 0.01/s 14 60 0.02/s 15 35 0.01/s 16 43 0.01/s 17 40 0.01/s 18 61 0.02/s 19 14 0.00/s 20 34 0.01/s 21 29 0.01/s 22 29 0.01/s 23 16 0.00/s Oct 14 00 27 0.01/s 01 11 0.00/s 02 16 0.00/s 03 21 0.01/s 04 25 0.01/s 05 14 0.00/s 06 48 0.01/s 07 29 0.01/s 08 56 0.02/s 09 49 0.01/s 10 36 0.01/s 11 23 0.01/s 12 68 0.02/s 13 59 0.02/s 14 57 0.02/s 15 26 0.01/s 16 22 0.01/s 17 32 0.01/s 18 47 0.01/s 19 26 0.01/s 20 30 0.01/s 21 37 0.01/s 22 28 0.01/s 23 25 0.01/s Oct 15 00 19 0.01/s 01 20 0.01/s 02 27 0.01/s 03 23 0.01/s 04 21 0.01/s 05 23 0.01/s 06 30 0.01/s 07 25 0.01/s 08 67 0.02/s 09 36 0.01/s 10 71 0.02/s 11 33 0.01/s 12 23 0.01/s 13 76 0.02/s 14 49 0.01/s 15 65 0.02/s 16 25 0.01/s 17 28 0.01/s 18 62 0.02/s 19 12 0.00/s 20 17 0.00/s 21 31 0.01/s 22 21 0.01/s 23 25 0.01/s Oct 16 00 19 0.01/s 01 34 0.01/s 02 29 0.01/s 03 20 0.01/s 04 40 0.01/s 05 29 0.01/s 06 46 0.01/s 07 36 0.01/s 08 28 0.01/s 09 43 0.01/s 10 29 0.01/s 11 17 0.00/s 12 23 0.01/s 13 34 0.01/s 14 35 0.01/s 15 27 0.01/s 16 31 0.01/s 17 33 0.01/s 18 60 0.02/s 19 30 0.01/s 20 27 0.01/s 21 49 0.01/s 22 31 0.01/s 23 27 0.01/s Oct 17 00 16 0.00/s 01 20 0.01/s 02 28 0.01/s 03 27 0.01/s 04 27 0.01/s 05 15 0.00/s 06 30 0.01/s 07 32 0.01/s 08 21 0.01/s 09 26 0.01/s 10 32 0.01/s 11 19 0.01/s 12 34 0.01/s 13 37 0.01/s 14 34 0.01/s 15 44 0.01/s 16 34 0.01/s 17 35 0.01/s 18 64 0.02/s 19 24 0.01/s 20 34 0.01/s 21 24 0.01/s 22 36 0.01/s 23 28 0.01/s Oct 18 00 28 0.01/s 01 19 0.01/s 02 16 0.00/s 03 23 0.01/s 04 25 0.01/s 05 25 0.01/s 06 19 0.01/s 07 20 0.01/s 08 22 0.01/s 09 33 0.01/s 10 31 0.01/s 11 29 0.01/s 12 30 0.01/s 13 28 0.01/s 14 36 0.01/s 15 24 0.01/s 16 39 0.01/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 Day Hour Count Average Duration Average idle time Oct 12 00 2 72ms 72ms 02 2 71ms 71ms 03 2 74ms 74ms 04 2 83ms 83ms 05 2 73ms 73ms 06 2 79ms 79ms 07 2 79ms 79ms 08 2 81ms 81ms 09 2 82ms 82ms 10 2 79ms 79ms 11 2 76ms 76ms 12 2 77ms 77ms 13 2 77ms 77ms 14 2 75ms 75ms 15 2 75ms 75ms 16 2 78ms 78ms 17 2 83ms 83ms 18 2 99ms 99ms 19 2 78ms 78ms 20 2 74ms 74ms 21 2 77ms 77ms 22 2 75ms 75ms 23 2 78ms 78ms Oct 13 00 2 74ms 74ms 01 2 75ms 75ms 02 2 87ms 87ms 03 2 77ms 77ms 04 2 73ms 73ms 05 26 2m13s 2m13s 06 45 2m13s 2m11s 07 41 3m33s 3m30s 08 55 1m42s 1m42s 09 56 1m49s 1m49s 10 46 1m58s 1m58s 11 64 1m45s 1m45s 12 36 23m48s 23m48s 13 46 3m1s 3m1s 14 63 3m7s 3m7s 15 37 18m45s 18m45s 16 41 2m 2m 17 43 22m47s 22m47s 18 58 3m47s 3m33s 19 17 3m4s 3m4s 20 34 3m35s 3m35s 21 29 2m31s 2m31s 22 25 4m16s 4m16s 23 20 2m52s 2m52s Oct 14 00 27 4m10s 4m9s 01 11 6m30s 6m30s 02 16 3m27s 3m27s 03 21 3m17s 3m17s 04 25 3m12s 3m12s 05 14 5m39s 5m39s 06 46 2m48s 2m47s 07 29 4m58s 4m58s 08 56 2m14s 2m13s 09 48 5m4s 5m4s 10 36 3m42s 3m32s 11 26 2m46s 2m46s 12 62 3m11s 3m5s 13 62 6m9s 5m59s 14 57 4m1s 3m55s 15 29 10m9s 9m45s 16 22 5m36s 5m36s 17 32 1h24m56s 1h24m56s 18 47 3m4s 2m49s 19 26 2m26s 2m25s 20 30 4m26s 4m26s 21 37 2m 2m 22 28 4m11s 4m11s 23 23 3m45s 3m45s Oct 15 00 21 1m58s 1m57s 01 20 4m25s 4m25s 02 27 4m3s 4m3s 03 20 4m 4m 04 24 2m45s 2m45s 05 23 2m19s 2m19s 06 29 3m22s 3m18s 07 26 6m22s 6m22s 08 63 2m31s 2m30s 09 35 2m34s 2m34s 10 64 8m24s 8m24s 11 36 3m9s 3m9s 12 27 25m 24m47s 13 69 8m29s 8m29s 14 55 13m54s 13m54s 15 71 8m48s 8m44s 16 25 2m48s 2m48s 17 28 1h37m37s 1h37m37s 18 59 3m41s 3m27s 19 15 1m48s 1m48s 20 17 7m32s 7m32s 21 31 2m45s 2m45s 22 21 3m5s 3m5s 23 25 2m13s 2m13s Oct 16 00 19 6m40s 6m39s 01 34 2m42s 2m42s 02 27 3m 3m 03 22 2m44s 2m44s 04 40 2m51s 2m51s 05 29 2m49s 2m49s 06 40 2m52s 2m49s 07 39 2m5s 2m 08 28 4m58s 4m58s 09 46 11m37s 11m37s 10 28 3m3s 3m3s 11 18 4m5s 4m5s 12 21 3m5s 3m5s 13 35 3m3s 3m3s 14 35 2m25s 2m25s 15 25 3m30s 3m30s 16 31 2m37s 2m37s 17 35 1h17m12s 1h17m12s 18 57 3m39s 3m26s 19 33 3m22s 3m20s 20 27 3m7s 3m7s 21 49 2m20s 2m20s 22 29 2m54s 2m54s 23 25 3m52s 3m52s Oct 17 00 20 3m57s 3m57s 01 20 2m36s 2m36s 02 28 3m58s 3m58s 03 26 3m29s 3m29s 04 28 3m1s 3m1s 05 15 3m52s 3m52s 06 27 1m39s 1m37s 07 35 46m44s 46m44s 08 21 3m25s 3m25s 09 26 3m 3m 10 31 3m8s 3m8s 11 20 4m6s 3m46s 12 34 4m30s 4m30s 13 36 2m38s 2m38s 14 35 2m37s 2m37s 15 44 24m20s 24m20s 16 34 2m24s 2m24s 17 35 7m56s 7m56s 18 59 3m51s 3m38s 19 26 3m13s 3m13s 20 37 2m35s 2m35s 21 24 3m41s 3m41s 22 36 2m35s 2m35s 23 27 3m20s 3m20s Oct 18 00 29 2m57s 2m57s 01 19 3m44s 3m44s 02 16 4m45s 4m45s 03 23 3m8s 3m8s 04 25 3m37s 3m37s 05 25 3m9s 3m9s 06 19 3m7s 3m7s 07 19 4m42s 4m42s 08 23 2m22s 2m22s 09 33 3m21s 3m21s 10 28 3m16s 3m16s 11 32 2m40s 2m40s 12 30 2m49s 2m49s 13 28 2m55s 2m55s 14 36 2m36s 2m36s 15 24 3m8s 3m8s 16 38 2m41s 2m41s 17 7 6h18m43s 6h18m43s 18 3 93ms 93ms 19 3 79ms 79ms 20 3 74ms 74ms 21 3 74ms 74ms 22 3 76ms 76ms 23 3 72ms 72ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-15 18:57:08 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 4,446 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,446 connections Total
-
Sessions
Simultaneous sessions
Key values
- 80 sessions Session Peak
- 2025-10-18 17:50:23 Date
Histogram of session times
Key values
- 3,382 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 4,447 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,447 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,447 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,447 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 404.25 MiB Temp Files size Peak
- 2025-10-15 18:40:10 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-10-13 18:42:44 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 12 00 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 Oct 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 1 4.19 MiB 4.19 MiB 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 164 3.97 GiB 24.76 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 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 1 4.19 MiB 4.19 MiB 10 25 106.86 MiB 4.27 MiB 11 0 0 0 12 29 122.31 MiB 4.22 MiB 13 24 105.91 MiB 4.41 MiB 14 25 108.79 MiB 4.35 MiB 15 26 109.16 MiB 4.20 MiB 16 0 0 0 17 0 0 0 18 177 4.04 GiB 23.38 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 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 2 8.38 MiB 4.19 MiB 09 0 0 0 10 2 8.38 MiB 4.19 MiB 11 0 0 0 12 26 111.06 MiB 4.27 MiB 13 2 8.38 MiB 4.19 MiB 14 0 0 0 15 3 12.56 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 173 4.07 GiB 24.10 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 16 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 171 4.02 GiB 24.08 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 25 106.87 MiB 4.27 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 167 3.95 GiB 24.23 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 18 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 28 156.07 MiB 2.48 MiB 15.63 MiB 5.57 MiB 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_0.alert_type_a3d_id = ? and ceahp1_1.obj_template_a3d_id = ? and ceahp1_1.obj_num_id = ? order by ceahp1_1.history_date desc;-
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 = $1 and ceahp1_0.ALERT_TYPE_A3D_ID = $2 and ceahp1_1.OBJ_TEMPLATE_A3D_ID = $3 and ceahp1_1.OBJ_NUM_ID = $4 order by ceahp1_1.HISTORY_DATE desc;
Date: 2025-10-17 11:44:18 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 15 463.23 MiB 24.67 MiB 41.50 MiB 30.88 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-10-17 18:41:29 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 145.84 MiB 2.69 MiB 40.16 MiB 9.72 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-10-17 18:41:27 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 5.30 GiB 109.62 MiB 1.12 GiB 361.54 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-10-17 18:38:32 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 682.11 MiB 2.75 MiB 310.02 MiB 45.47 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-10-17 18:41:33 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15 1.54 GiB 11.68 MiB 473.81 MiB 104.81 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-10-17 18:41:02 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15 2.39 GiB 35.29 MiB 707.97 MiB 163.40 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-10-17 18:37:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 13 667.19 MiB 1.95 MiB 482.22 MiB 51.32 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-10-17 18:42:10 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 13 890.48 MiB 50.93 MiB 178.09 MiB 68.50 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-10-17 18:40:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 12 60.60 MiB 2.25 MiB 9.90 MiB 5.05 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-10-17 18:42:20 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 12 315.26 MiB 20.44 MiB 30.12 MiB 26.27 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-10-16 18:41:43 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 12 201.80 MiB 3.35 MiB 83.97 MiB 16.82 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-10-16 18:41:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 12 358.32 MiB 8.38 MiB 88.34 MiB 29.86 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-10-16 18:41:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 12 271.57 MiB 3.77 MiB 57.88 MiB 22.63 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-10-16 18:41:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 11 1.25 GiB 20.02 MiB 553.08 MiB 116.52 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-10-17 18:39:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 11 1.72 GiB 25.66 MiB 1014.33 MiB 159.73 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-10-17 18:36:49 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 11 40.19 MiB 2.24 MiB 8.79 MiB 3.65 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-17 11:40:55 Duration: 4m3s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
18 6 15.17 MiB 2.24 MiB 2.93 MiB 2.53 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-10-15 12:39:22 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
19 6 52.38 MiB 2.55 MiB 12.09 MiB 8.73 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-10-17 18:42:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 110.26 MiB 2.32 MiB 31.13 MiB 22.05 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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-10-14 10:42:32 Duration: 12s873ms 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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-10-14 15:43:28 Duration: 8s842ms 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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-10-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
21 3 1.29 GiB 58.63 MiB 829.91 MiB 438.76 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-16 18:36:16 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 2 553.26 MiB 44.38 MiB 508.88 MiB 276.63 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-10-14 18:30:19 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 35.83 MiB 35.83 MiB 35.83 MiB 35.83 MiB add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:41:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 369.92 MiB 369.92 MiB 369.92 MiB 369.92 MiB add constraint fk_gtp_obj_compo_category foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_category FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-13 18:38:41 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 209.32 MiB 209.32 MiB 209.32 MiB 209.32 MiB add constraint fk_gtp_obj_rel_vt_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-17 18:40:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
26 1 68.50 MiB 68.50 MiB 68.50 MiB 68.50 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-10-17 18:40:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
27 1 437.35 MiB 437.35 MiB 437.35 MiB 437.35 MiB add constraint fk_dependence_obj_type_compo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_dependence_obj_type_compo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-15 18:41:01 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.12 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-13 18:37:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.06 GiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-15 18:37:30 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1014.33 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-17 18:36:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 829.91 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-10-16 18:36:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 714.15 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-10-14 18:24:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 707.97 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-14 18:24:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 692.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-10-16 18:37:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 553.08 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-17 18:39:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 508.88 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2025-10-13 18:40:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 504.46 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-10-17 18:38:32 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 482.22 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-15 18:39:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 473.81 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-14 18:28:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 437.35 MiB ADD CONSTRAINT fk_dependence_obj_type_compo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-15 18:41:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 427.72 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2025-10-14 18:25:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 369.92 MiB ADD CONSTRAINT fk_gtp_obj_compo_category FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-13 18:38:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 342.90 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-13 18:37:49 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 334.96 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-16 18:37:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 332.52 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-17 18:37:41 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 331.10 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-15 18:38:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 322.54 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-16 18:40:38 - 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 Oct 12 00 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 Oct 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 Oct 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 Oct 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 Oct 16 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 Oct 17 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 Oct 18 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
- 36 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 6 15s466ms 2s577ms relation 6 15s466ms 2s577ms ExclusiveLock 6 6s582ms 1s97ms extension 6 6s582ms 1s97ms ShareLock 13 19m57s 1m32s relation 5 5s11ms 1s2ms transaction 8 19m52s 2m29s ShareRowExclusiveLock 6 6s504ms 1s84ms relation 6 6s504ms 1s84ms ShareUpdateExclusiveLock 5 5s389ms 1s77ms relation 5 5s389ms 1s77ms Total 36 20m31s 34s202ms 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
- 41 Total read queries
- 296 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 355 Requests
- 2h13m54s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 356 Requests
User Request type Count Duration a3dsupervisor Total 356 2h14m copy from 31 17m14s ddl 139 33m32s delete 17 12m25s insert 10 7m14s others 18 34m59s select 42 7m36s tcl 94 15m13s update 5 5m43s Duration by user
Key values
- 2h14m (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 356 2h14m copy from 31 17m14s ddl 139 33m32s delete 17 12m25s insert 10 7m14s others 18 34m59s select 42 7m36s tcl 94 15m13s update 5 5m43s Queries by host
Key values
- 10.3.0.4 Main host
- 356 Requests
- 2h14m (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 177 Requests
- 1h12m22s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-14 14:39:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 185 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 4m36s update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;[ Date: 2025-10-15 15:19:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
2 4m8s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-15 12:36:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 4m3s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-17 11:40:55 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 4m call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 10:39:48 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
5 3m47s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-14 13:05:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
6 3m42s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
7 3m39s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 14:38:26 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
8 3m33s COMMIT;[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
9 3m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-14 12:56:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
10 3m5s delete from GTP_LOG_CONNECTION where LOG_DATE <;[ Date: 2025-10-14 13:05:36 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
11 2m38s insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);[ Date: 2025-10-14 12:56:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 2m20s VACUUM ANALYSE;[ Date: 2025-10-14 18:42:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 2m12s VACUUM ANALYSE;[ Date: 2025-10-15 18:55:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 2m4s VACUUM ANALYSE;[ Date: 2025-10-16 18:55:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 1m56s VACUUM ANALYSE;[ Date: 2025-10-13 18:55:25 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 1m54s VACUUM ANALYSE;[ Date: 2025-10-17 18:55:08 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 1m45s COMMIT;[ Date: 2025-10-14 15:41:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 1m20s 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-10-16 18:36:37 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m19s 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-10-15 18:37:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m19s 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-10-14 18:24:24 - 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 22m58s 6 3m24s 4m8s 3m49s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s Oct 15 14 1 4m8s 4m8s Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 22m58s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m58s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s 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-10-17 11:40:55 Duration: 4m3s 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-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 15m13s 94 5s6ms 3m33s 9s718ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 08 10 1m2s 6s201ms 09 9 1m2s 6s934ms 20 1 5s228ms 5s228ms Oct 14 08 6 35s633ms 5s938ms 09 1 5s254ms 5s254ms 17 3 5m35s 1m51s 21 1 6s574ms 6s574ms Oct 15 08 18 1m48s 6s42ms 09 1 6s118ms 6s118ms Oct 16 08 3 21s596ms 7s198ms 09 25 2m45s 6s608ms 21 7 43s598ms 6s228ms Oct 17 08 7 43s574ms 6s224ms 09 1 5s956ms 5s956ms 20 1 6s261ms 6s261ms [ User: a3dsupervisor - Total duration: 15m13s - Times executed: 94 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m2s - Times executed: 92 ]
[ Application: pg_restore - Total duration: 11s490ms - Times executed: 2 ]
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 3m33s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 1m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 15s567ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 10m28s 5 1m54s 2m20s 2m5s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 20 1 1m56s 1m56s Oct 14 20 1 2m20s 2m20s Oct 15 20 1 2m12s 2m12s Oct 16 20 1 2m4s 2m4s Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: psql - Total duration: 10m28s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 18:55:16 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 9m19s 16 12s728ms 1m15s 34s984ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 08 1 18s957ms 18s957ms 20 1 12s728ms 12s728ms Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms Oct 16 08 1 43s718ms 43s718ms 20 1 12s983ms 12s983ms Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 9m19s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9m19s - Times executed: 16 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-10-14 13:14:22 Duration: 1m8s 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-10-17 11:48:32 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6m33s 5 1m16s 1m20s 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 20 1 1m17s 1m17s Oct 14 20 1 1m19s 1m19s Oct 15 20 1 1m19s 1m19s Oct 16 20 1 1m20s 1m20s Oct 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m33s - Times executed: 5 ]
-
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-10-16 18:36:37 Duration: 1m20s 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-10-15 18:37:46 Duration: 1m19s 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-10-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6m26s 2 2m38s 3m47s 3m13s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 14 1 2m38s 2m38s 15 1 3m47s 3m47s [ User: a3dsupervisor - Total duration: 6m26s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m26s - Times executed: 2 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 13:05:36 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 12:56:25 Duration: 2m38s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 4m36s 1 4m36s 4m36s 4m36s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 15 17 1 4m36s 4m36s [ User: a3dsupervisor - Total duration: 4m36s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m36s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-10-15 15:19:50 Duration: 4m36s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 3m5s 1 3m5s 3m5s 3m5s delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 15 1 3m5s 3m5s [ User: a3dsupervisor - Total duration: 3m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m5s - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-10-14 13:05:36 Duration: 3m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 2m58s 5 35s292ms 35s987ms 35s625ms 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 #9
Day Hour Count Duration Avg duration Oct 13 20 1 35s973ms 35s973ms Oct 14 20 1 35s472ms 35s472ms Oct 15 20 1 35s402ms 35s402ms Oct 16 20 1 35s987ms 35s987ms Oct 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
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-10-16 18:35:53 Duration: 35s987ms 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-10-13 18:36:35 Duration: 35s973ms 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-10-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2m54s 5 32s34ms 39s344ms 34s823ms 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 #10
Day Hour Count Duration Avg duration Oct 13 20 1 32s811ms 32s811ms Oct 14 20 1 36s240ms 36s240ms Oct 15 20 1 39s344ms 39s344ms Oct 16 20 1 33s684ms 33s684ms Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m54s - Times executed: 5 ]
-
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-10-15 18:40:10 Duration: 39s344ms 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-10-14 18:26:35 Duration: 36s240ms 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-10-16 18:38:49 Duration: 33s684ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2m50s 5 31s33ms 39s126ms 34s2ms 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 #11
Day Hour Count Duration Avg duration Oct 13 20 1 35s373ms 35s373ms Oct 14 20 1 31s228ms 31s228ms Oct 15 20 1 39s126ms 39s126ms Oct 16 20 1 31s33ms 31s33ms Oct 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m50s - Times executed: 5 ]
-
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-10-15 18:41:04 Duration: 39s126ms 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-10-13 18:40:09 Duration: 35s373ms 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-10-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 2m40s 5 27s456ms 36s677ms 32s139ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 1 32s405ms 32s405ms Oct 14 20 1 27s456ms 27s456ms Oct 15 20 1 36s677ms 36s677ms Oct 16 20 1 27s980ms 27s980ms Oct 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 2m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m40s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms 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-10-17 18:37:41 Duration: 36s180ms 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-10-13 18:37:49 Duration: 32s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2m36s 5 26s157ms 35s248ms 31s309ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 20 1 35s248ms 35s248ms Oct 14 20 1 26s157ms 26s157ms Oct 15 20 1 34s906ms 34s906ms Oct 16 20 1 27s689ms 27s689ms Oct 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 2m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m36s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-13 18:37:52 Duration: 35s248ms 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-10-15 18:38:32 Duration: 34s906ms 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-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2m15s 5 23s519ms 30s184ms 27s80ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 20 1 30s184ms 30s184ms Oct 14 20 1 24s799ms 24s799ms Oct 15 20 1 30s125ms 30s125ms Oct 16 20 1 23s519ms 23s519ms Oct 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 2m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m15s - Times executed: 5 ]
-
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-10-13 18:40:00 Duration: 30s184ms 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-10-15 18:40:52 Duration: 30s125ms 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-10-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2m8s 5 23s381ms 29s391ms 25s726ms 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 #15
Day Hour Count Duration Avg duration Oct 13 20 1 25s964ms 25s964ms Oct 14 20 1 24s554ms 24s554ms Oct 15 20 1 29s391ms 29s391ms Oct 16 20 1 23s381ms 23s381ms Oct 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms 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-10-13 18:37:01 Duration: 25s964ms 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-10-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2m1s 5 18s46ms 28s69ms 24s211ms 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 #16
Day Hour Count Duration Avg duration Oct 13 20 1 18s46ms 18s46ms Oct 14 20 1 23s141ms 23s141ms Oct 15 20 1 28s69ms 28s69ms Oct 16 20 1 26s602ms 26s602ms Oct 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m1s - Times executed: 5 ]
-
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-10-15 18:39:20 Duration: 28s69ms 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-10-16 18:38:08 Duration: 26s602ms 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-10-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1m37s 5 17s385ms 21s579ms 19s440ms 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 #17
Day Hour Count Duration Avg duration Oct 13 20 1 20s429ms 20s429ms Oct 14 20 1 17s529ms 17s529ms Oct 15 20 1 20s276ms 20s276ms Oct 16 20 1 21s579ms 21s579ms Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m37s - Times executed: 5 ]
-
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-10-16 18:37:41 Duration: 21s579ms 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-10-13 18:38:13 Duration: 20s429ms 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-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1m32s 7 9s145ms 31s59ms 13s248ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 12 1 11s1ms 11s1ms 14 1 9s326ms 9s326ms 15 1 31s59ms 31s59ms 16 1 9s434ms 9s434ms 17 1 9s145ms 9s145ms Oct 15 14 1 11s651ms 11s651ms Oct 17 13 1 11s120ms 11s120ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m32s - Times executed: 7 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 13:00:23 Duration: 31s59ms 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-10-15 12:32:21 Duration: 11s651ms 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-10-17 11:36:38 Duration: 11s120ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 1m31s 5 16s389ms 21s200ms 18s231ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 1 17s991ms 17s991ms Oct 14 20 1 16s389ms 16s389ms Oct 15 20 1 17s26ms 17s26ms Oct 16 20 1 18s547ms 18s547ms Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m31s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 18:37:42 Duration: 18s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-13 18:38:25 Duration: 17s991ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1m25s 5 13s993ms 18s937ms 17s45ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 20 1 18s937ms 18s937ms Oct 14 20 1 17s964ms 17s964ms Oct 15 20 1 18s612ms 18s612ms Oct 16 20 1 15s717ms 15s717ms Oct 17 20 1 13s993ms 13s993ms [ User: a3dsupervisor - Total duration: 1m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m25s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-13 18:41:11 Duration: 18s937ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-14 18:28:32 Duration: 17s964ms 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 94 15m13s 5s6ms 3m33s 9s718ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 10 1m2s 6s201ms 09 9 1m2s 6s934ms 20 1 5s228ms 5s228ms Oct 14 08 6 35s633ms 5s938ms 09 1 5s254ms 5s254ms 17 3 5m35s 1m51s 21 1 6s574ms 6s574ms Oct 15 08 18 1m48s 6s42ms 09 1 6s118ms 6s118ms Oct 16 08 3 21s596ms 7s198ms 09 25 2m45s 6s608ms 21 7 43s598ms 6s228ms Oct 17 08 7 43s574ms 6s224ms 09 1 5s956ms 5s956ms 20 1 6s261ms 6s261ms [ User: a3dsupervisor - Total duration: 15m13s - Times executed: 94 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 15m2s - Times executed: 92 ]
[ Application: pg_restore - Total duration: 11s490ms - Times executed: 2 ]
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 3m33s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 1m45s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-14 15:41:11 Duration: 15s567ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 16 9m19s 12s728ms 1m15s 34s984ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 08 1 18s957ms 18s957ms 20 1 12s728ms 12s728ms Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms Oct 16 08 1 43s718ms 43s718ms 20 1 12s983ms 12s983ms Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 9m19s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9m19s - Times executed: 16 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-10-14 13:14:22 Duration: 1m8s 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-10-17 11:48:32 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 7 1m32s 9s145ms 31s59ms 13s248ms call pack_gtp_dba.p_anonymization_ged ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 12 1 11s1ms 11s1ms 14 1 9s326ms 9s326ms 15 1 31s59ms 31s59ms 16 1 9s434ms 9s434ms 17 1 9s145ms 9s145ms Oct 15 14 1 11s651ms 11s651ms Oct 17 13 1 11s120ms 11s120ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m32s - Times executed: 7 ]
-
call pack_gtp_dba.p_anonymization_ged ();
Date: 2025-10-14 13:00:23 Duration: 31s59ms 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-10-15 12:32:21 Duration: 11s651ms 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-10-17 11:36:38 Duration: 11s120ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 7 54s958ms 6s272ms 12s873ms 7s851ms 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 #4
Day Hour Count Duration Avg duration Oct 14 12 1 12s873ms 12s873ms 14 1 7s123ms 7s123ms 15 1 6s707ms 6s707ms 16 1 6s669ms 6s669ms 17 1 8s842ms 8s842ms Oct 15 14 1 6s272ms 6s272ms Oct 17 13 1 6s470ms 6s470ms [ User: a3dsupervisor - Total duration: 54s958ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 54s958ms - Times executed: 7 ]
-
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('202001021042', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021042', '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-10-14 10:42:32 Duration: 12s873ms 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('202001021543', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021543', '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-10-14 15:43:28 Duration: 8s842ms 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('202001021258', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101021258', '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-10-14 12:58:37 Duration: 7s123ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 6 22m58s 3m24s 4m8s 3m49s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s Oct 15 14 1 4m8s 4m8s Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 22m58s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m58s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s 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-10-17 11:40:55 Duration: 4m3s 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-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 6 1m20s 5s765ms 42s148ms 13s383ms select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 12 1 9s66ms 9s66ms 15 1 6s303ms 6s303ms 16 1 5s765ms 5s765ms 17 1 10s529ms 10s529ms Oct 15 14 1 6s485ms 6s485ms Oct 16 08 1 42s148ms 42s148ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m20s - Times executed: 6 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-16 06:53:39 Duration: 42s148ms 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-10-14 15:42:57 Duration: 10s529ms 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-10-14 10:41:52 Duration: 9s66ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 5 10m28s 1m54s 2m20s 2m5s vacuum analyse;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 20 1 1m56s 1m56s Oct 14 20 1 2m20s 2m20s Oct 15 20 1 2m12s 2m12s Oct 16 20 1 2m4s 2m4s Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: psql - Total duration: 10m28s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 18:55:16 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 6m33s 1m16s 1m20s 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;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 20 1 1m17s 1m17s Oct 14 20 1 1m19s 1m19s Oct 15 20 1 1m19s 1m19s Oct 16 20 1 1m20s 1m20s Oct 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m33s - Times executed: 5 ]
-
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-10-16 18:36:37 Duration: 1m20s 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-10-15 18:37:46 Duration: 1m19s 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-10-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 2m58s 35s292ms 35s987ms 35s625ms 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 #9
Day Hour Count Duration Avg duration Oct 13 20 1 35s973ms 35s973ms Oct 14 20 1 35s472ms 35s472ms Oct 15 20 1 35s402ms 35s402ms Oct 16 20 1 35s987ms 35s987ms Oct 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
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-10-16 18:35:53 Duration: 35s987ms 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-10-13 18:36:35 Duration: 35s973ms 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-10-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 2m54s 32s34ms 39s344ms 34s823ms 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 #10
Day Hour Count Duration Avg duration Oct 13 20 1 32s811ms 32s811ms Oct 14 20 1 36s240ms 36s240ms Oct 15 20 1 39s344ms 39s344ms Oct 16 20 1 33s684ms 33s684ms Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m54s - Times executed: 5 ]
-
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-10-15 18:40:10 Duration: 39s344ms 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-10-14 18:26:35 Duration: 36s240ms 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-10-16 18:38:49 Duration: 33s684ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 2m50s 31s33ms 39s126ms 34s2ms 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 #11
Day Hour Count Duration Avg duration Oct 13 20 1 35s373ms 35s373ms Oct 14 20 1 31s228ms 31s228ms Oct 15 20 1 39s126ms 39s126ms Oct 16 20 1 31s33ms 31s33ms Oct 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m50s - Times executed: 5 ]
-
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-10-15 18:41:04 Duration: 39s126ms 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-10-13 18:40:09 Duration: 35s373ms 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-10-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 2m40s 27s456ms 36s677ms 32s139ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 1 32s405ms 32s405ms Oct 14 20 1 27s456ms 27s456ms Oct 15 20 1 36s677ms 36s677ms Oct 16 20 1 27s980ms 27s980ms Oct 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 2m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m40s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms 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-10-17 18:37:41 Duration: 36s180ms 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-10-13 18:37:49 Duration: 32s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 2m36s 26s157ms 35s248ms 31s309ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 20 1 35s248ms 35s248ms Oct 14 20 1 26s157ms 26s157ms Oct 15 20 1 34s906ms 34s906ms Oct 16 20 1 27s689ms 27s689ms Oct 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 2m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m36s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-13 18:37:52 Duration: 35s248ms 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-10-15 18:38:32 Duration: 34s906ms 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-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 2m15s 23s519ms 30s184ms 27s80ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 13 20 1 30s184ms 30s184ms Oct 14 20 1 24s799ms 24s799ms Oct 15 20 1 30s125ms 30s125ms Oct 16 20 1 23s519ms 23s519ms Oct 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 2m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m15s - Times executed: 5 ]
-
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-10-13 18:40:00 Duration: 30s184ms 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-10-15 18:40:52 Duration: 30s125ms 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-10-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 2m8s 23s381ms 29s391ms 25s726ms 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 #15
Day Hour Count Duration Avg duration Oct 13 20 1 25s964ms 25s964ms Oct 14 20 1 24s554ms 24s554ms Oct 15 20 1 29s391ms 29s391ms Oct 16 20 1 23s381ms 23s381ms Oct 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms 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-10-13 18:37:01 Duration: 25s964ms 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-10-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 2m1s 18s46ms 28s69ms 24s211ms 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 #16
Day Hour Count Duration Avg duration Oct 13 20 1 18s46ms 18s46ms Oct 14 20 1 23s141ms 23s141ms Oct 15 20 1 28s69ms 28s69ms Oct 16 20 1 26s602ms 26s602ms Oct 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m1s - Times executed: 5 ]
-
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-10-15 18:39:20 Duration: 28s69ms 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-10-16 18:38:08 Duration: 26s602ms 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-10-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 1m37s 17s385ms 21s579ms 19s440ms 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 #17
Day Hour Count Duration Avg duration Oct 13 20 1 20s429ms 20s429ms Oct 14 20 1 17s529ms 17s529ms Oct 15 20 1 20s276ms 20s276ms Oct 16 20 1 21s579ms 21s579ms Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m37s - Times executed: 5 ]
-
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-10-16 18:37:41 Duration: 21s579ms 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-10-13 18:38:13 Duration: 20s429ms 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-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 1m31s 16s389ms 21s200ms 18s231ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 20 1 17s991ms 17s991ms Oct 14 20 1 16s389ms 16s389ms Oct 15 20 1 17s26ms 17s26ms Oct 16 20 1 18s547ms 18s547ms Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m31s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 18:37:42 Duration: 18s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-13 18:38:25 Duration: 17s991ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 1m25s 13s993ms 18s937ms 17s45ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 1 18s937ms 18s937ms Oct 14 20 1 17s964ms 17s964ms Oct 15 20 1 18s612ms 18s612ms Oct 16 20 1 15s717ms 15s717ms Oct 17 20 1 13s993ms 13s993ms [ User: a3dsupervisor - Total duration: 1m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m25s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-13 18:41:11 Duration: 18s937ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-14 18:28:32 Duration: 17s964ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 1m22s 11s398ms 21s397ms 16s453ms create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 20 1 15s758ms 15s758ms Oct 14 20 1 21s382ms 21s382ms Oct 15 20 1 12s328ms 12s328ms Oct 16 20 1 21s397ms 21s397ms Oct 17 20 1 11s398ms 11s398ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-16 18:36:52 Duration: 21s397ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-14 18:24:41 Duration: 21s382ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-13 18:38:28 Duration: 15s758ms 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 4m36s 4m36s 4m36s 1 4m36s update gtp_background_task set canceling_user_num_id =, export_file_name =, server_id =, source_file_name =, source_obj_num_id =, task_active_status =, task_create_date =, task_current_progress =, task_current_step =, task_end_date =, task_error_message =, task_last_update =, task_log =, task_max_progress =, task_max_step =, task_origin =, task_parameters =, task_report =, task_service_name =, task_start_date =, task_state =, task_status =, task_sub_type =, user_num_id = where task_num_id =;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 15 17 1 4m36s 4m36s [ User: a3dsupervisor - Total duration: 4m36s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m36s - Times executed: 1 ]
-
update GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID =, EXPORT_FILE_NAME =, SERVER_ID =, SOURCE_FILE_NAME =, SOURCE_OBJ_NUM_ID =, TASK_ACTIVE_STATUS =, TASK_CREATE_DATE =, TASK_CURRENT_PROGRESS =, TASK_CURRENT_STEP =, TASK_END_DATE =, TASK_ERROR_MESSAGE =, TASK_LAST_UPDATE =, TASK_LOG =, TASK_MAX_PROGRESS =, TASK_MAX_STEP =, TASK_ORIGIN =, TASK_PARAMETERS =, TASK_REPORT =, TASK_SERVICE_NAME =, TASK_START_DATE =, TASK_STATE =, TASK_STATUS =, TASK_SUB_TYPE =, USER_NUM_ID = where TASK_NUM_ID =;
Date: 2025-10-15 15:19:50 Duration: 4m36s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 3m24s 4m8s 3m49s 6 22m58s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 12 1 4m 4m 14 1 3m24s 3m24s 16 1 3m39s 3m39s 17 1 3m42s 3m42s Oct 15 14 1 4m8s 4m8s Oct 17 13 1 4m3s 4m3s [ User: a3dsupervisor - Total duration: 22m58s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 22m58s - Times executed: 6 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-15 12:36:45 Duration: 4m8s 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-10-17 11:40:55 Duration: 4m3s 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-10-14 10:39:48 Duration: 4m Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 2m38s 3m47s 3m13s 2 6m26s insert into batch_scenario_run (creation_date, creator_num_id, end_date, modification_date, modifier_num_id, batch_scenario_num_id, start_date, state, status, batch_scenario_run_id) values (,,,,,,,,,);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 14 1 2m38s 2m38s 15 1 3m47s 3m47s [ User: a3dsupervisor - Total duration: 6m26s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 6m26s - Times executed: 2 ]
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 13:05:36 Duration: 3m47s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into BATCH_SCENARIO_RUN (CREATION_DATE, CREATOR_NUM_ID, END_DATE, MODIFICATION_DATE, MODIFIER_NUM_ID, BATCH_SCENARIO_NUM_ID, START_DATE, STATE, STATUS, BATCH_SCENARIO_RUN_ID) values (,,,,,,,,,);
Date: 2025-10-14 12:56:25 Duration: 2m38s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 3m5s 3m5s 3m5s 1 3m5s delete from gtp_log_connection where log_date <;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 15 1 3m5s 3m5s [ User: a3dsupervisor - Total duration: 3m5s - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m5s - Times executed: 1 ]
-
delete from GTP_LOG_CONNECTION where LOG_DATE <;
Date: 2025-10-14 13:05:36 Duration: 3m5s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 1m54s 2m20s 2m5s 5 10m28s vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 20 1 1m56s 1m56s Oct 14 20 1 2m20s 2m20s Oct 15 20 1 2m12s 2m12s Oct 16 20 1 2m4s 2m4s Oct 17 20 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: psql - Total duration: 10m28s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-14 18:42:13 Duration: 2m20s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 18:55:42 Duration: 2m12s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-16 18:55:16 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1m16s 1m20s 1m18s 5 6m33s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 13 20 1 1m17s 1m17s Oct 14 20 1 1m19s 1m19s Oct 15 20 1 1m19s 1m19s Oct 16 20 1 1m20s 1m20s Oct 17 20 1 1m16s 1m16s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m33s - Times executed: 5 ]
-
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-10-16 18:36:37 Duration: 1m20s 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-10-15 18:37:46 Duration: 1m19s 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-10-14 18:24:24 Duration: 1m19s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 35s292ms 35s987ms 35s625ms 5 2m58s copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 13 20 1 35s973ms 35s973ms Oct 14 20 1 35s472ms 35s472ms Oct 15 20 1 35s402ms 35s402ms Oct 16 20 1 35s987ms 35s987ms Oct 17 20 1 35s292ms 35s292ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
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-10-16 18:35:53 Duration: 35s987ms 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-10-13 18:36:35 Duration: 35s973ms 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-10-14 18:23:40 Duration: 35s472ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 12s728ms 1m15s 34s984ms 16 9m19s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 08 1 18s957ms 18s957ms 20 1 12s728ms 12s728ms Oct 14 10 1 17s850ms 17s850ms 12 1 50s528ms 50s528ms 15 2 1m28s 44s341ms 16 1 1m15s 1m15s 17 1 47s46ms 47s46ms 20 1 15s28ms 15s28ms Oct 15 10 1 20s465ms 20s465ms 14 1 1m1s 1m1s 20 1 13s975ms 13s975ms Oct 16 08 1 43s718ms 43s718ms 20 1 12s983ms 12s983ms Oct 17 13 1 1m6s 1m6s 20 1 14s44ms 14s44ms [ User: a3dsupervisor - Total duration: 9m19s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 9m19s - Times executed: 16 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-14 14:44:09 Duration: 1m15s 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-10-14 13:14:22 Duration: 1m8s 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-10-17 11:48:32 Duration: 1m6s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 32s34ms 39s344ms 34s823ms 5 2m54s 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 #9
Day Hour Count Duration Avg duration Oct 13 20 1 32s811ms 32s811ms Oct 14 20 1 36s240ms 36s240ms Oct 15 20 1 39s344ms 39s344ms Oct 16 20 1 33s684ms 33s684ms Oct 17 20 1 32s34ms 32s34ms [ User: a3dsupervisor - Total duration: 2m54s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m54s - Times executed: 5 ]
-
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-10-15 18:40:10 Duration: 39s344ms 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-10-14 18:26:35 Duration: 36s240ms 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-10-16 18:38:49 Duration: 33s684ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 31s33ms 39s126ms 34s2ms 5 2m50s 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 #10
Day Hour Count Duration Avg duration Oct 13 20 1 35s373ms 35s373ms Oct 14 20 1 31s228ms 31s228ms Oct 15 20 1 39s126ms 39s126ms Oct 16 20 1 31s33ms 31s33ms Oct 17 20 1 33s252ms 33s252ms [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m50s - Times executed: 5 ]
-
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-10-15 18:41:04 Duration: 39s126ms 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-10-13 18:40:09 Duration: 35s373ms 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-10-17 18:39:50 Duration: 33s252ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 27s456ms 36s677ms 32s139ms 5 2m40s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 20 1 32s405ms 32s405ms Oct 14 20 1 27s456ms 27s456ms Oct 15 20 1 36s677ms 36s677ms Oct 16 20 1 27s980ms 27s980ms Oct 17 20 1 36s180ms 36s180ms [ User: a3dsupervisor - Total duration: 2m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m40s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-15 18:38:22 Duration: 36s677ms 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-10-17 18:37:41 Duration: 36s180ms 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-10-13 18:37:49 Duration: 32s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 26s157ms 35s248ms 31s309ms 5 2m36s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 20 1 35s248ms 35s248ms Oct 14 20 1 26s157ms 26s157ms Oct 15 20 1 34s906ms 34s906ms Oct 16 20 1 27s689ms 27s689ms Oct 17 20 1 32s545ms 32s545ms [ User: a3dsupervisor - Total duration: 2m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m36s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-13 18:37:52 Duration: 35s248ms 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-10-15 18:38:32 Duration: 34s906ms 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-10-17 18:37:45 Duration: 32s545ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 23s519ms 30s184ms 27s80ms 5 2m15s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 20 1 30s184ms 30s184ms Oct 14 20 1 24s799ms 24s799ms Oct 15 20 1 30s125ms 30s125ms Oct 16 20 1 23s519ms 23s519ms Oct 17 20 1 26s775ms 26s775ms [ User: a3dsupervisor - Total duration: 2m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m15s - Times executed: 5 ]
-
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-10-13 18:40:00 Duration: 30s184ms 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-10-15 18:40:52 Duration: 30s125ms 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-10-17 18:39:43 Duration: 26s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 23s381ms 29s391ms 25s726ms 5 2m8s 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 #14
Day Hour Count Duration Avg duration Oct 13 20 1 25s964ms 25s964ms Oct 14 20 1 24s554ms 24s554ms Oct 15 20 1 29s391ms 29s391ms Oct 16 20 1 23s381ms 23s381ms Oct 17 20 1 25s341ms 25s341ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON public.gtp_obj_rel_vt USING btree (relation_num_id);
Date: 2025-10-15 18:37:31 Duration: 29s391ms 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-10-13 18:37:01 Duration: 25s964ms 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-10-17 18:36:50 Duration: 25s341ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 18s46ms 28s69ms 24s211ms 5 2m1s create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 20 1 18s46ms 18s46ms Oct 14 20 1 23s141ms 23s141ms Oct 15 20 1 28s69ms 28s69ms Oct 16 20 1 26s602ms 26s602ms Oct 17 20 1 25s195ms 25s195ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m1s - Times executed: 5 ]
-
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-10-15 18:39:20 Duration: 28s69ms 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-10-16 18:38:08 Duration: 26s602ms 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-10-17 18:38:29 Duration: 25s195ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 17s385ms 21s579ms 19s440ms 5 1m37s 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 #16
Day Hour Count Duration Avg duration Oct 13 20 1 20s429ms 20s429ms Oct 14 20 1 17s529ms 17s529ms Oct 15 20 1 20s276ms 20s276ms Oct 16 20 1 21s579ms 21s579ms Oct 17 20 1 17s385ms 17s385ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m37s - Times executed: 5 ]
-
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-10-16 18:37:41 Duration: 21s579ms 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-10-13 18:38:13 Duration: 20s429ms 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-10-15 18:38:52 Duration: 20s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 16s389ms 21s200ms 18s231ms 5 1m31s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 13 20 1 17s991ms 17s991ms Oct 14 20 1 16s389ms 16s389ms Oct 15 20 1 17s26ms 17s26ms Oct 16 20 1 18s547ms 18s547ms Oct 17 20 1 21s200ms 21s200ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m31s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-17 18:38:15 Duration: 21s200ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-16 18:37:42 Duration: 18s547ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-13 18:38:25 Duration: 17s991ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 13s993ms 18s937ms 17s45ms 5 1m25s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 20 1 18s937ms 18s937ms Oct 14 20 1 17s964ms 17s964ms Oct 15 20 1 18s612ms 18s612ms Oct 16 20 1 15s717ms 15s717ms Oct 17 20 1 13s993ms 13s993ms [ User: a3dsupervisor - Total duration: 1m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m25s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-13 18:41:11 Duration: 18s937ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 18:42:12 Duration: 18s612ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-14 18:28:32 Duration: 17s964ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 11s398ms 21s397ms 16s453ms 5 1m22s create index i_gtp_obj_rel_vt_ntt on public.gtp_obj_rel_vt using btree (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 20 1 15s758ms 15s758ms Oct 14 20 1 21s382ms 21s382ms Oct 15 20 1 12s328ms 12s328ms Oct 16 20 1 21s397ms 21s397ms Oct 17 20 1 11s398ms 11s398ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m22s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-16 18:36:52 Duration: 21s397ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-14 18:24:41 Duration: 21s382ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON public.gtp_obj_rel_vt USING btree (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-13 18:38:28 Duration: 15s758ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5s765ms 42s148ms 13s383ms 6 1m20s select goc.obj_num_id from gtp_obj_composition goc where position(in goc.obj_compo_value) <> ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 12 1 9s66ms 9s66ms 15 1 6s303ms 6s303ms 16 1 5s765ms 5s765ms 17 1 10s529ms 10s529ms Oct 15 14 1 6s485ms 6s485ms Oct 16 08 1 42s148ms 42s148ms [ User: a3dsupervisor - Total duration: 1m20s - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m20s - Times executed: 6 ]
-
SELECT goc.obj_num_id FROM GTP_OBJ_COMPOSITION goc WHERE POSITION(in goc.obj_compo_value) <> 0;
Date: 2025-10-16 06:53:39 Duration: 42s148ms 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-10-14 15:42:57 Duration: 10s529ms 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-10-14 10:41:52 Duration: 9s66ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 21,065 Log entries
Events distribution
Key values
- 0 PANIC entries
- 3 FATAL entries
- 6166 ERROR entries
- 98 WARNING entries
Most Frequent Errors/Events
Key values
- 5,661 Max number of times the same event was reported
- 6,267 Total events found
Rank Times reported Error 1 5,661 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 13 21 88 22 242 23 229 00 314 01 4 Oct 14 21 101 22 740 23 89 00 670 01 28 Oct 15 02 1 05 1 21 92 22 364 23 251 00 168 01 2 Oct 16 02 1 21 108 22 221 23 242 00 635 Oct 17 02 2 03 1 04 2 21 96 22 369 23 159 00 277 01 164 2 195 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 14 12 39 14 5 15 73 16 39 17 39 3 81 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 13 17 2 19 3 Oct 14 11 4 14 4 15 2 16 2 17 2 19 3 Oct 15 10 2 12 9 14 2 15 4 17 20 19 3 Oct 16 11 2 19 3 Oct 17 09 5 17 3 19 3 Oct 18 19 3 4 56 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 14 12 8 14 8 15 8 16 8 17 8 Oct 15 14 8 Oct 17 13 8 5 42 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 14 12 6 14 6 15 6 16 6 17 6 Oct 15 14 6 Oct 17 13 6 6 14 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 14 12 2 14 2 15 2 16 2 17 2 Oct 15 14 2 Oct 17 13 2 7 7 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 8 7 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 9 7 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 10 7 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 #10
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 11 7 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 #11
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 12 7 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 13 7 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #13
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 14 7 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 #14
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 15 7 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 #15
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 16 7 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 17 7 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 18 7 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 19 7 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 #19
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 20 7 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 21 7 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 22 7 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 23 7 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 #23
Day Hour Count Oct 14 12 1 14 1 15 1 16 1 17 1 Oct 15 14 1 Oct 17 13 1 24 6 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #24
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 2 25 6 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 14 14 1 15 1 17 4 26 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 27 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #27
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 28 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #28
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 29 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #29
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 30 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 31 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 32 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #32
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 33 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #33
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 34 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #34
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 35 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #35
Day Hour Count Oct 13 20 1 Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 36 4 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #36
Day Hour Count Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 37 4 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_rel_vt_ntt_p ON public.gtp_obj_rel_vt USING btree (...)
Times Reported Most Frequent Error / Event #37
Day Hour Count Oct 14 20 1 Oct 15 20 1 Oct 16 20 1 Oct 17 20 1 38 3 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #38
Day Hour Count Oct 14 15 2 Oct 17 11 1 39 3 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 #39
Day Hour Count Oct 17 20 3 40 3 LOG: process ... still waiting for ShareLock on transaction ... after ... msinsert into BATCH_SCENARIO_RUN (...) values (...)
Times Reported Most Frequent Error / Event #40
Day Hour Count Oct 14 14 2 15 1 41 3 LOG: process ... still waiting for ShareLock on transaction ... after ... msCOMMIT
Times Reported Most Frequent Error / Event #41
Day Hour Count Oct 14 17 3 42 3 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0
Times Reported Most Frequent Error / Event #42
Day Hour Count Oct 13 09 1 Oct 16 08 2 43 3 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #43
Day Hour Count Oct 13 21 1 Oct 16 08 2 44 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msdelete from GTP_LOG_CONNECTION where LOG_DATE <
Times Reported Most Frequent Error / Event #44
Day Hour Count Oct 14 15 2 45 2 LOG: process ... still waiting for ShareLock on transaction ... after ... msupdate GTP_BACKGROUND_TASK set CANCELING_USER_NUM_ID=,EXPORT_FILE_NAME=,SERVER_ID=,SOURCE_FILE_NAME=,SOURCE_OBJ_NUM_ID=,TASK_ACTIVE_STATUS=,TASK_CREATE_DATE=,TASK_CURRENT_PROGRESS=,TASK_CURRENT_STEP=,TASK_END_DATE=,TASK_ERROR_MESSAGE=,TASK_LAST_UPDATE=,TASK_LOG=,TASK_MAX_PROGRESS=,TASK_MAX_STEP=,TASK_ORIGIN=,TASK_PARAMETERS=,TASK_REPORT=,TASK_SERVICE_NAME=,TASK_START_DATE=,TASK_STATE=,TASK_STATUS=,TASK_SUB_TYPE=,USER_NUM_ID= where TASK_NUM_ID=
Times Reported Most Frequent Error / Event #45
Day Hour Count Oct 15 17 2 46 1 LOG: process ... still waiting for ShareLock on transaction ... after ... msUPDATE LOG_SESSION SET SESSION_STATUS = WHERE SESSION_STATUS = AND SERVER_ID =
Times Reported Most Frequent Error / Event #46
Day Hour Count Oct 14 14 1 47 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_dep_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #47
Day Hour Count Oct 14 20 1 48 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (...) REFERENCES public.gtp_relation(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #48
Day Hour Count Oct 16 20 1 49 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (...) REFERENCES public.gtp_obj_template(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #49
Day Hour Count Oct 13 20 1 50 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #50
Day Hour Count Oct 13 20 1 51 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 #51
Day Hour Count Oct 13 20 1 52 1 ERROR: deadlock detectedcall pack_gtp_dba.p_anonymize_dcp()
Times Reported Most Frequent Error / Event #52
Day Hour Count Oct 14 15 1 - ERROR: deadlock detectedcall pack_gtp_dba.p_anonymize_dcp()
Date: 2025-10-14 13:05:36 Database: autotest_feat_batch Application: PostgreSQL JDBC Driver User: a3dsupervisor Remote: 10.3.0.4