pgBadger-
Global information
- Generated on Mon Oct 13 09:35:06 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=11/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=11/h=23/m=00/PT1H.log
- Parsed 25,423 log entries in 1m3s
- Log start from 2025-10-06 08:54:40 to 2025-10-10 23:00:02
-
Overview
Global Stats
- 88 Number of unique normalized queries
- 285 Number of queries
- 1h24m52s Total query duration
- 2025-10-06 06:13:37 First query
- 2025-10-11 00:00:36 Last query
- 3 queries/s at 2025-10-10 06:58:23 Query peak
- 1h24m52s Total query duration
- 53s552ms Prepare/parse total duration
- 22s727ms Bind total duration
- 1h23m36s Execute total duration
- 5,535 Number of events
- 47 Number of unique normalized events
- 5,088 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
- 952 Number temporary file
- 1.12 GiB Max size of temporary file
- 22.44 MiB Average size of temporary file
- 4,252 Total number of sessions
- 34 sessions at 2025-10-07 07:45:08 Session peak
- 22d4h15m42s Total duration of sessions
- 7m30s Average duration of sessions
- 0 Average queries per session
- 1s197ms Average queries duration per session
- 7m29s Average idle time per session
- 4,251 Total number of connections
- 11 connections/s at 2025-10-07 18:56:59 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-10 06:58:23 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-08 19:34:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-10 06:58:23 Date
Queries duration
Key values
- 1h24m52s 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 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 06 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 26 0ms 8s294ms 6s366ms 19s818ms 34s809ms 45s823ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 9s675ms 9s675ms 0ms 0ms 9s675ms 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 36 0ms 1m48s 20s21ms 1m49s 3m6s 3m6s 19 5 0ms 6s356ms 5s974ms 0ms 0ms 29s870ms 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 07 00 1 0ms 5s335ms 5s335ms 0ms 5s335ms 5s335ms 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 9s528ms 6s636ms 5s400ms 10s634ms 30s422ms 07 6 0ms 46s367ms 16s896ms 0ms 28s30ms 46s367ms 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 38 0ms 1m48s 19s410ms 1m50s 1m55s 2m30s 19 2 0ms 5s749ms 5s437ms 5s125ms 5s749ms 5s749ms 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 08 00 1 0ms 5s414ms 5s414ms 0ms 5s414ms 5s414ms 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 5s982ms 5s421ms 5s46ms 5s215ms 22s267ms 07 1 0ms 11s497ms 11s497ms 0ms 0ms 11s497ms 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 34 0ms 2m4s 21s367ms 2m4s 2m11s 2m45s 19 8 0ms 6s174ms 5s592ms 15s645ms 17s734ms 17s734ms 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 09 00 1 0ms 5s60ms 5s60ms 0ms 5s60ms 5s60ms 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 8s385ms 6s689ms 0ms 0ms 40s134ms 07 9 0ms 4m8s 39s647ms 19s307ms 45s989ms 4m8s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 5 0ms 4m24s 1m6s 16s300ms 43s114ms 4m24s 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 37 0ms 2m13s 20s32ms 1m55s 2m13s 2m31s 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 10 00 1 0ms 5s707ms 5s707ms 0ms 5s707ms 5s707ms 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 13 0ms 7s702ms 5s865ms 15s483ms 16s975ms 19s967ms 07 7 0ms 11s17ms 6s89ms 5s7ms 11s267ms 15s329ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 32 0ms 1m46s 23s454ms 2m3s 2m13s 2m31s 19 1 0ms 11s469ms 11s469ms 0ms 11s469ms 11s469ms 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 11 00 1 0ms 5s667ms 5s667ms 0ms 5s667ms 5s667ms 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 05 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 07 00 1 0 5s335ms 0ms 0ms 5s335ms 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 Oct 08 00 1 0 5s414ms 0ms 0ms 5s414ms 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 5s161ms 0ms 0ms 5s161ms 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 2 0 5s209ms 0ms 0ms 10s418ms 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 09 00 1 0 5s60ms 0ms 0ms 5s60ms 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 5 0 8s392ms 0ms 8s339ms 19s307ms 08 0 0 0ms 0ms 0ms 0ms 09 2 0 8s150ms 0ms 0ms 16s300ms 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 10 00 1 0 5s707ms 0ms 0ms 5s707ms 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 Oct 11 00 1 0 5s667ms 0ms 0ms 5s667ms 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 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 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 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 9s675ms 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 29s284ms 0ms 23s686ms 1m14s 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 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 0 5s308ms 0ms 0ms 5s308ms 07 0 1 2 0 27s455ms 0ms 0ms 28s30ms 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 29s852ms 0ms 0ms 59s790ms 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 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 0 5s156ms 0ms 0ms 0ms 07 0 0 1 0 11s497ms 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 30s313ms 0ms 9s53ms 1m 19 1 0 0 0 5s226ms 0ms 0ms 5s226ms 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 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 2 0 27s303ms 0ms 0ms 45s989ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 1 0 43s114ms 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 30s424ms 0ms 16s276ms 1m52s 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 10 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 1 0 0 7s702ms 0ms 0ms 7s702ms 07 0 0 1 0 11s17ms 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 6 34s357ms 0ms 0ms 1m3s 19 0 0 1 0 11s469ms 0ms 0ms 11s469ms 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 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 06 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 1 26 26.00 3.85% 07 0 0 0.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 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 5 5.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 07 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 6 6.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 2 2.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 08 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 3 6 2.00 50.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 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 8 8.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 09 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 9 9.00 0.00% 08 0 0 0.00 0.00% 09 0 5 5.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 10 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 3 13 4.33 23.08% 07 0 7 7.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 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 11 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 05 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Oct 06 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 23 0.01/s 06 29 0.01/s 07 47 0.01/s 08 81 0.02/s 09 88 0.02/s 10 60 0.02/s 11 50 0.01/s 12 89 0.02/s 13 119 0.03/s 14 64 0.02/s 15 44 0.01/s 16 40 0.01/s 17 23 0.01/s 18 53 0.01/s 19 29 0.01/s 20 27 0.01/s 21 28 0.01/s 22 20 0.01/s 23 32 0.01/s Oct 07 00 31 0.01/s 01 23 0.01/s 02 20 0.01/s 03 22 0.01/s 04 23 0.01/s 05 28 0.01/s 06 26 0.01/s 07 58 0.02/s 08 43 0.01/s 09 47 0.01/s 10 25 0.01/s 11 18 0.01/s 12 61 0.02/s 13 60 0.02/s 14 53 0.01/s 15 39 0.01/s 16 26 0.01/s 17 38 0.01/s 18 65 0.02/s 19 22 0.01/s 20 14 0.00/s 21 15 0.00/s 22 24 0.01/s 23 34 0.01/s Oct 08 00 27 0.01/s 01 19 0.01/s 02 22 0.01/s 03 22 0.01/s 04 28 0.01/s 05 26 0.01/s 06 30 0.01/s 07 62 0.02/s 08 25 0.01/s 09 43 0.01/s 10 25 0.01/s 11 30 0.01/s 12 20 0.01/s 13 28 0.01/s 14 24 0.01/s 15 21 0.01/s 16 36 0.01/s 17 35 0.01/s 18 62 0.02/s 19 19 0.01/s 20 21 0.01/s 21 23 0.01/s 22 26 0.01/s 23 16 0.00/s Oct 09 00 21 0.01/s 01 25 0.01/s 02 15 0.00/s 03 15 0.00/s 04 25 0.01/s 05 17 0.00/s 06 31 0.01/s 07 35 0.01/s 08 60 0.02/s 09 51 0.01/s 10 23 0.01/s 11 19 0.01/s 12 31 0.01/s 13 21 0.01/s 14 42 0.01/s 15 22 0.01/s 16 21 0.01/s 17 42 0.01/s 18 56 0.02/s 19 26 0.01/s 20 26 0.01/s 21 20 0.01/s 22 19 0.01/s 23 16 0.00/s Oct 10 00 29 0.01/s 01 23 0.01/s 02 19 0.01/s 03 24 0.01/s 04 17 0.00/s 05 22 0.01/s 06 29 0.01/s 07 42 0.01/s 08 88 0.02/s 09 26 0.01/s 10 21 0.01/s 11 26 0.01/s 12 28 0.01/s 13 18 0.01/s 14 26 0.01/s 15 46 0.01/s 16 22 0.01/s 17 36 0.01/s 18 46 0.01/s 19 26 0.01/s 20 36 0.01/s 21 22 0.01/s 22 25 0.01/s 23 34 0.01/s Oct 11 00 14 0.00/s 01 18 0.01/s 02 22 0.01/s 03 19 0.01/s 04 13 0.00/s 05 20 0.01/s 06 33 0.01/s 07 21 0.01/s 08 26 0.01/s 09 14 0.00/s 10 21 0.01/s 11 15 0.00/s 12 20 0.01/s 13 19 0.01/s 14 17 0.00/s 15 13 0.00/s 16 13 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 Day Hour Count Average Duration Average idle time Oct 05 00 2 79ms 79ms 01 2 77ms 77ms 02 2 74ms 74ms 03 2 75ms 75ms 04 2 74ms 74ms 05 2 79ms 79ms 06 2 75ms 75ms 07 2 80ms 80ms 08 2 74ms 74ms 09 2 81ms 81ms 10 2 76ms 76ms 11 2 73ms 73ms 12 2 74ms 74ms 13 2 74ms 74ms 14 2 91ms 91ms 15 2 73ms 73ms 16 2 78ms 78ms 17 2 71ms 71ms 18 2 86ms 86ms 19 2 76ms 76ms 20 2 75ms 75ms 21 2 74ms 74ms 22 2 75ms 75ms 23 2 82ms 82ms Oct 06 00 2 74ms 74ms 01 2 72ms 72ms 02 2 76ms 76ms 03 2 73ms 73ms 04 2 101ms 101ms 05 20 2m17s 2m17s 06 24 3m30s 3m23s 07 50 2m24s 2m24s 08 64 3m27s 3m27s 09 95 5m14s 5m14s 10 66 1m53s 1m53s 11 51 1m50s 1m50s 12 85 6m10s 6m10s 13 122 3m3s 3m3s 14 70 4m25s 4m25s 15 43 1m55s 1m55s 16 40 1m54s 1m54s 17 23 1h54s 1h54s 18 53 4m15s 4m2s 19 25 4m17s 4m16s 20 31 2m36s 2m36s 21 28 3m44s 3m44s 22 20 3m39s 3m39s 23 32 3m24s 3m24s Oct 07 00 31 2m38s 2m38s 01 23 3m41s 3m41s 02 20 3m57s 3m57s 03 22 3m21s 3m21s 04 19 3m17s 3m17s 05 32 3m59s 3m59s 06 24 2m11s 2m9s 07 57 3m37s 3m36s 08 43 4m46s 4m46s 09 48 10m18s 10m18s 10 25 3m16s 3m16s 11 18 1m17s 1m17s 12 61 6m58s 6m58s 13 48 8m4s 8m4s 14 65 3m44s 3m44s 15 41 6m44s 6m44s 16 24 3m44s 3m44s 17 41 1h6m51s 1h6m51s 18 61 3m27s 3m15s 19 22 3m28s 3m27s 20 18 1m9s 1m9s 21 15 8m41s 8m41s 22 24 4m50s 4m50s 23 34 1m57s 1m57s Oct 08 00 27 4m26s 4m25s 01 19 3m30s 3m30s 02 22 3m50s 3m50s 03 22 3m56s 3m56s 04 28 3m4s 3m4s 05 26 3m8s 3m8s 06 28 1m55s 1m54s 07 62 4m12s 4m12s 08 25 6m 6m 09 43 4m37s 4m37s 10 23 13m23s 13m23s 11 32 3m19s 3m19s 12 20 5m17s 5m17s 13 28 8m14s 8m14s 14 24 4m55s 4m55s 15 22 21m29s 21m29s 16 38 7m8s 7m8s 17 34 1h19m51s 1h19m51s 18 59 3m53s 3m41s 19 22 1m58s 1m56s 20 21 4m53s 4m53s 21 23 4m13s 4m13s 22 26 3m54s 3m54s 23 16 5m49s 5m49s Oct 09 00 21 1m13s 1m12s 01 25 6m5s 6m5s 02 15 2m42s 2m42s 03 11 1m7s 1m7s 04 24 7m19s 7m19s 05 22 2m42s 2m42s 06 27 4m39s 4m38s 07 40 4m22s 4m13s 08 53 3m49s 3m49s 09 57 4m 3m54s 10 23 3m20s 3m20s 11 19 3m51s 3m51s 12 30 9m59s 9m59s 13 18 2m16s 2m16s 14 47 3m12s 3m12s 15 21 9m35s 9m35s 16 22 2m46s 2m46s 17 42 1h5m8s 1h5m8s 18 53 4m7s 3m53s 19 28 3m16s 3m16s 20 27 2m43s 2m43s 21 18 4m2s 4m2s 22 20 1m10s 1m10s 23 17 1m12s 1m12s Oct 10 00 28 7m58s 7m58s 01 24 3m50s 3m50s 02 19 3m41s 3m41s 03 24 3m23s 3m23s 04 17 4m53s 4m53s 05 22 2m14s 2m14s 06 26 1m56s 1m53s 07 43 7m21s 7m20s 08 87 2m28s 2m28s 09 29 8m11s 8m11s 10 21 4m23s 4m23s 11 26 2m45s 2m45s 12 28 2m50s 2m50s 13 18 4m 4m 14 26 3m48s 3m48s 15 46 54m25s 54m25s 16 22 3m23s 3m23s 17 36 8m34s 8m34s 18 24 8m8s 7m37s 19 48 56s852ms 56s613ms 20 36 4m 4m 21 22 4m16s 4m16s 22 25 3m8s 3m8s 23 34 3m17s 3m17s Oct 11 00 14 3m21s 3m21s 01 18 4m9s 4m9s 02 22 4m45s 4m45s 03 19 1m8s 1m8s 04 13 9m28s 9m28s 05 20 4m46s 4m46s 06 31 3m5s 3m5s 07 23 3m13s 3m13s 08 26 1m55s 1m55s 09 14 4m49s 4m49s 10 21 6m18s 6m18s 11 15 3m1s 3m1s 12 20 5m22s 5m22s 13 19 3m49s 3m49s 14 17 4m39s 4m39s 15 13 1m11s 1m11s 16 13 11m5s 11m5s 17 5 8h50m15s 8h50m15s 18 2 78ms 78ms 19 2 84ms 84ms 20 2 89ms 89ms 21 2 88ms 88ms 22 2 77ms 77ms 23 2 74ms 74ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-07 18:56:59 Date
Connections per database
Key values
- autotest_feat_batch Main Database
- 4,251 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,251 connections Total
-
Sessions
Simultaneous sessions
Key values
- 34 sessions Session Peak
- 2025-10-07 07:45:08 Date
Histogram of session times
Key values
- 3,275 60000-600000ms duration
Sessions per database
Key values
- autotest_feat_batch Main Database
- 4,252 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,252 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,252 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,252 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 395.20 MiB Temp Files size Peak
- 2025-10-09 18:40:07 Date
Number of temporary files
Key values
- 9 per second Temp Files Peak
- 2025-10-07 18:43:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 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 06 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 0 0 0 07 0 0 0 08 2 8.38 MiB 4.19 MiB 09 2 8.38 MiB 4.19 MiB 10 0 0 0 11 0 0 0 12 3 12.56 MiB 4.19 MiB 13 4 16.75 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 166 4.05 GiB 24.96 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 2 8.38 MiB 4.19 MiB 08 1 4.19 MiB 4.19 MiB 09 2 8.38 MiB 4.19 MiB 10 0 0 0 11 0 0 0 12 1 4.19 MiB 4.19 MiB 13 3 12.56 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 1 4.19 MiB 4.19 MiB 16 0 0 0 17 0 0 0 18 154 3.95 GiB 26.27 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 2 8.38 MiB 4.19 MiB 08 0 0 0 09 1 4.19 MiB 4.19 MiB 10 1 4.19 MiB 4.19 MiB 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 1 4.19 MiB 4.19 MiB 17 0 0 0 18 178 4.11 GiB 23.62 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 1 4.19 MiB 4.19 MiB 07 25 106.86 MiB 4.27 MiB 08 2 8.38 MiB 4.19 MiB 09 25 108.82 MiB 4.35 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 1 4.19 MiB 4.19 MiB 14 1 4.19 MiB 4.19 MiB 15 0 0 0 16 0 0 0 17 0 0 0 18 186 4.20 GiB 23.13 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 2 8.38 MiB 4.19 MiB 08 2 8.38 MiB 4.19 MiB 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 179 4.19 GiB 23.97 MiB 19 1 4.19 MiB 4.19 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 109.24 MiB 2.38 MiB 28.83 MiB 6.83 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('202001020727', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101020727', '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-09 07:27:22 Duration: 7s906ms 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('202001020926', 'YYYYMMDDHH24MI') and cons.date_stamped <= TO_DATE('202101020926', '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-09 09:26:34 Duration: 6s775ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
2 15 967.80 MiB 22.05 MiB 532.44 MiB 64.52 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-10 18:45:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 1.27 GiB 19.30 MiB 298.17 MiB 86.77 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-10 18:44:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 1.59 GiB 12.80 MiB 521.34 MiB 108.22 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-10 18:45:05 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 339.48 MiB 3.55 MiB 58.50 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-10 18:46:15 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15 515.46 MiB 7.88 MiB 91.70 MiB 34.36 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-10 18:46:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15 2.25 GiB 35.29 MiB 541.55 MiB 153.45 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-10 18:41:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 15 394.09 MiB 17.62 MiB 38.65 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-10 18:46:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 15 890.51 MiB 50.95 MiB 71.39 MiB 59.37 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-10 18:44:58 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 15 5.35 GiB 115.48 MiB 1.12 GiB 365.45 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-10 18:40:06 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 14 1.34 GiB 26.23 MiB 337.96 MiB 97.72 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-10 18:43:03 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 14 219.88 MiB 3.25 MiB 128.23 MiB 15.71 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-10 18:43:59 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 13 62.40 MiB 2.48 MiB 13.34 MiB 4.80 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-09 07:27:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
14 12 522.77 MiB 3.71 MiB 208.83 MiB 43.56 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-10 18:46:34 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 12 52.59 MiB 2.53 MiB 7.95 MiB 4.38 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2025-10-10 18:46:39 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 10 414.41 MiB 2.21 MiB 228.23 MiB 41.44 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-10 18:46:25 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 10 1.82 GiB 4.02 MiB 1.00 GiB 186.19 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-09 18:39:57 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 6 316.20 MiB 1.99 MiB 257.71 MiB 52.70 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-10 18:43:48 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 12.86 MiB 2.24 MiB 2.93 MiB 2.57 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-09 09:26:13 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
20 4 98.33 MiB 8.88 MiB 64.20 MiB 24.58 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-10 18:46:38 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 2 80.44 MiB 9.90 MiB 70.54 MiB 40.22 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-10-09 18:39:54 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 2 205.52 MiB 68.51 MiB 137.01 MiB 102.76 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-10 18:44:17 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 2 11.35 MiB 2.56 MiB 8.79 MiB 5.68 MiB call pack_gtp_dba.p_anonymize_dcp ();-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-09 09:24:36 Duration: 4m24s 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-09 07:25:13 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver
24 1 154.89 MiB 154.89 MiB 154.89 MiB 154.89 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-07 18:41:47 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 369.90 MiB 369.90 MiB 369.90 MiB 369.90 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-10 18:42:11 Duration: 0ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
26 1 1.00 GiB 1.00 GiB 1.00 GiB 1.00 GiB add constraint fk_att_temp_category_modifier foreign key (att_template_category_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_att_temp_category_modifier FOREIGN KEY (att_template_category_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-09 18:37:40 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-10 18:40:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.09 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-06 18:28:50 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1.00 GiB ADD CONSTRAINT fk_att_temp_category_modifier FOREIGN KEY (att_template_category_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-09 18:37:40 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.00 GiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-08 18:38:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 934.69 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-07 18:38:15 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 541.55 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-07 18:37:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 532.44 MiB ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);[ Date: 2025-10-08 18:42:58 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 521.34 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-09 18:42:24 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 490.52 MiB ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-09 18:39:16 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 481.38 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-08 18:39:54 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 477.04 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-10-10 18:45:05 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 404.91 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-06 18:30:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 396.59 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-07 18:39:09 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 369.90 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-10 18:42:11 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 346.40 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-08 18:39:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 338.56 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-10 18:41:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 337.96 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-10 18:43:03 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 334.77 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-06 18:29:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 330.41 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-10-09 18:38:31 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 313.82 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-09 18:40:55 - 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 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 09 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 10 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 28 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 4 8s536ms 2s134ms relation 4 8s536ms 2s134ms ExclusiveLock 7 7s767ms 1s109ms extension 7 7s767ms 1s109ms ShareLock 5 6s193ms 1s238ms relation 5 6s193ms 1s238ms ShareRowExclusiveLock 6 9s157ms 1s526ms relation 6 9s157ms 1s526ms ShareUpdateExclusiveLock 6 6s248ms 1s41ms relation 6 6s248ms 1s41ms Total 28 37s902ms 1s353ms 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
- 15 Total read queries
- 260 Total write queries
Queries by database
Key values
- autotest_feat_batch Main database
- 285 Requests
- 1h23m36s (autotest_feat_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 286 Requests
User Request type Count Duration a3dsupervisor Total 286 1h23m41s copy from 30 16m52s ddl 138 34m9s delete 13 4m8s insert 3 15s691ms others 10 18m42s select 16 1m46s tcl 74 7m30s update 2 15s669ms Duration by user
Key values
- 1h23m41s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 286 1h23m41s copy from 30 16m52s ddl 138 34m9s delete 13 4m8s insert 3 15s691ms others 10 18m42s select 16 1m46s tcl 74 7m30s update 2 15s669ms Queries by host
Key values
- 10.3.0.4 Main host
- 286 Requests
- 1h23m41s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 168 Requests
- 51m1s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-08 16:10:00 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 159 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 4m24s call pack_gtp_dba.p_anonymize_dcp ();[ Date: 2025-10-09 09:24:36 - 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-09 07:25:13 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
3 2m13s VACUUM ANALYSE;[ Date: 2025-10-09 18:55:43 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 2m4s VACUUM ANALYSE;[ Date: 2025-10-08 18:55:42 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 1m48s VACUUM ANALYSE;[ Date: 2025-10-06 18:47:51 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 1m48s VACUUM ANALYSE;[ Date: 2025-10-07 18:55:39 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 1m46s VACUUM ANALYSE;[ Date: 2025-10-10 18:58:20 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 1m17s 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-08 18:38:23 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 1m17s 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-09 18:37:57 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 1m14s 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-07 18:37:46 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 1m14s 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-06 18:29:01 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 1m14s 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-10 18:40:19 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 51s108ms CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2025-10-07 18:38:38 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 47s444ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-10 18:41:06 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 46s367ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-07 07:09:34 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 45s989ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-09 07:30:22 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 43s499ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-06 18:29:45 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 43s114ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-09 09:29:33 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 39s418ms 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-09 18:40:07 - Database: autotest_feat_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 37s144ms CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2025-10-08 18:39:01 - 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 9m41s 5 1m46s 2m13s 1m56s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 20 1 1m48s 1m48s Oct 07 20 1 1m48s 1m48s Oct 08 20 1 2m4s 2m4s Oct 09 20 1 2m13s 2m13s Oct 10 20 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 9m41s - Times executed: 5 ]
[ Application: psql - Total duration: 9m41s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-09 18:55:43 Duration: 2m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-08 18:55:42 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 18:47:51 Duration: 1m48s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 8m32s 2 4m8s 4m24s 4m16s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 09 09 1 4m8s 4m8s 11 1 4m24s 4m24s [ User: a3dsupervisor - Total duration: 8m32s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m32s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-09 09:24:36 Duration: 4m24s 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-09 07:25:13 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 7m30s 74 5s7ms 9s528ms 6s86ms commit;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 08 26 2m45s 6s366ms 21 5 29s870ms 5s974ms Oct 07 08 6 41s149ms 6s858ms 09 2 11s412ms 5s706ms 21 2 10s875ms 5s437ms Oct 08 08 4 22s211ms 5s552ms 21 5 29s94ms 5s818ms Oct 09 08 6 40s134ms 6s689ms Oct 10 08 12 1m8s 5s712ms 09 6 31s605ms 5s267ms [ User: a3dsupervisor - Total duration: 7m30s - Times executed: 74 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m30s - Times executed: 74 ]
-
COMMIT;
Date: 2025-10-07 06:27:05 Duration: 9s528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-09 06:48:51 Duration: 8s385ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-06 06:49:56 Duration: 8s294ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 6m18s 5 1m14s 1m17s 1m15s 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 #4
Day Hour Count Duration Avg duration Oct 06 20 1 1m14s 1m14s Oct 07 20 1 1m14s 1m14s Oct 08 20 1 1m17s 1m17s Oct 09 20 1 1m17s 1m17s Oct 10 20 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m18s - 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-08 18:38:23 Duration: 1m17s 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-09 18:37:57 Duration: 1m17s 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-07 18:37:46 Duration: 1m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 4m8s 13 6s495ms 46s367ms 19s141ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 10 1 9s675ms 9s675ms 20 1 6s933ms 6s933ms Oct 07 09 2 1m14s 37s198ms 20 1 6s495ms 6s495ms Oct 08 09 1 11s497ms 11s497ms 20 1 9s53ms 9s53ms Oct 09 09 2 54s607ms 27s303ms 11 1 43s114ms 43s114ms 20 1 10s578ms 10s578ms Oct 10 09 1 11s17ms 11s17ms 21 1 11s469ms 11s469ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-07 07:09:34 Duration: 46s367ms 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-09 07:30:22 Duration: 45s989ms 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-09 09:29:33 Duration: 43s114ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 3m11s 5 29s58ms 47s444ms 38s322ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 20 1 43s499ms 43s499ms Oct 07 20 1 29s58ms 29s58ms Oct 08 20 1 37s144ms 37s144ms Oct 09 20 1 34s466ms 34s466ms Oct 10 20 1 47s444ms 47s444ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-10 18:41:06 Duration: 47s444ms 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-06 18:29:45 Duration: 43s499ms 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-08 18:39:01 Duration: 37s144ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 3m1s 5 33s680ms 39s418ms 36s243ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 20 1 36s476ms 36s476ms Oct 07 20 1 35s117ms 35s117ms Oct 08 20 1 33s680ms 33s680ms Oct 09 20 1 39s418ms 39s418ms Oct 10 20 1 36s524ms 36s524ms [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m1s - 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-09 18:40:07 Duration: 39s418ms 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-10 18:43:04 Duration: 36s524ms 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-06 18:31:25 Duration: 36s476ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 2m57s 5 24s830ms 51s108ms 35s404ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 20 1 32s897ms 32s897ms Oct 07 20 1 51s108ms 51s108ms Oct 08 20 1 33s735ms 33s735ms Oct 09 20 1 24s830ms 24s830ms Oct 10 20 1 34s450ms 34s450ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-07 18:38:38 Duration: 51s108ms 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-10 18:41:15 Duration: 34s450ms 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-08 18:39:09 Duration: 33s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 2m57s 5 34s754ms 36s208ms 35s403ms 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 06 20 1 35s749ms 35s749ms Oct 07 20 1 34s899ms 34s899ms Oct 08 20 1 34s754ms 34s754ms Oct 09 20 1 35s405ms 35s405ms Oct 10 20 1 36s208ms 36s208ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - 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-10 18:39:41 Duration: 36s208ms 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-06 18:28:22 Duration: 35s749ms 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-09 18:37:15 Duration: 35s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 2m56s 5 33s594ms 36s406ms 35s262ms 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 06 20 1 36s406ms 36s406ms Oct 07 20 1 36s207ms 36s207ms Oct 08 20 1 33s594ms 33s594ms Oct 09 20 1 33s968ms 33s968ms Oct 10 20 1 36s135ms 36s135ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-06 18:32:06 Duration: 36s406ms 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-07 18:40:50 Duration: 36s207ms 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-10 18:43:48 Duration: 36s135ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 2m6s 5 24s381ms 26s935ms 25s250ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 20 1 26s935ms 26s935ms Oct 07 20 1 24s885ms 24s885ms Oct 08 20 1 24s381ms 24s381ms Oct 09 20 1 24s673ms 24s673ms Oct 10 20 1 25s376ms 25s376ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - 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-06 18:28:50 Duration: 26s935ms 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-10 18:40:06 Duration: 25s376ms 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-07 18:37:31 Duration: 24s885ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 1m59s 5 17s630ms 27s772ms 23s955ms 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 #12
Day Hour Count Duration Avg duration Oct 06 20 1 23s686ms 23s686ms Oct 07 20 1 23s582ms 23s582ms Oct 08 20 1 27s105ms 27s105ms Oct 09 20 1 17s630ms 17s630ms Oct 10 20 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 1m59s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m59s - 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-10 18:43:35 Duration: 27s772ms 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-08 18:41:32 Duration: 27s105ms 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-06 18:31:49 Duration: 23s686ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 1m49s 5 14s188ms 32s679ms 21s980ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 20 1 14s188ms 14s188ms Oct 07 20 1 19s10ms 19s10ms Oct 08 20 1 22s182ms 22s182ms Oct 09 20 1 21s841ms 21s841ms Oct 10 20 1 32s679ms 32s679ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - 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-10 18:42:11 Duration: 32s679ms 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-08 18:39:52 Duration: 22s182ms 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-09 18:39:11 Duration: 21s841ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 1m49s 5 13s840ms 33s808ms 21s807ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 20 1 27s940ms 27s940ms Oct 07 20 1 16s136ms 16s136ms Oct 08 20 1 17s311ms 17s311ms Oct 09 20 1 13s840ms 13s840ms Oct 10 20 1 33s808ms 33s808ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-10 18:40:40 Duration: 33s808ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-06 18:29:18 Duration: 27s940ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-08 18:38:23 Duration: 17s311ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1m30s 5 11s196ms 24s713ms 18s78ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 20 1 24s713ms 24s713ms Oct 07 20 1 11s196ms 11s196ms Oct 08 20 1 20s310ms 20s310ms Oct 09 20 1 16s573ms 16s573ms Oct 10 20 1 17s599ms 17s599ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-06 18:30:17 Duration: 24s713ms 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-08 18:39:36 Duration: 20s310ms 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-10 18:41:38 Duration: 17s599ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 1m30s 5 15s660ms 20s414ms 18s17ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 20 1 15s660ms 15s660ms Oct 07 20 1 20s414ms 20s414ms Oct 08 20 1 17s389ms 17s389ms Oct 09 20 1 17s832ms 17s832ms Oct 10 20 1 18s789ms 18s789ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-07 18:39:25 Duration: 20s414ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-10 18:42:11 Duration: 18s789ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-09 18:39:16 Duration: 17s832ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1m27s 5 13s912ms 22s857ms 17s505ms 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 06 20 1 13s912ms 13s912ms Oct 07 20 1 14s580ms 14s580ms Oct 08 20 1 19s898ms 19s898ms Oct 09 20 1 16s276ms 16s276ms Oct 10 20 1 22s857ms 22s857ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m27s - 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-10 18:41:37 Duration: 22s857ms 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-08 18:39:29 Duration: 19s898ms 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-09 18:38:49 Duration: 16s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1m25s 5 13s187ms 20s664ms 17s155ms 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 06 20 1 13s187ms 13s187ms Oct 07 20 1 14s253ms 14s253ms Oct 08 20 1 19s671ms 19s671ms Oct 09 20 1 20s664ms 20s664ms Oct 10 20 1 18s 18s [ 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-09 18:42:10 Duration: 20s664ms 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-08 18:42:51 Duration: 19s671ms 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-10 18:44:58 Duration: 18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1m22s 5 12s439ms 25s87ms 16s565ms 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 06 20 1 16s917ms 16s917ms Oct 07 20 1 25s87ms 25s87ms Oct 08 20 1 12s439ms 12s439ms Oct 09 20 1 13s893ms 13s893ms Oct 10 20 1 14s487ms 14s487ms [ 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-07 18:39:04 Duration: 25s87ms 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-06 18:30:22 Duration: 16s917ms 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-10 18:41:52 Duration: 14s487ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1m13s 5 8s963ms 21s943ms 14s711ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 20 1 13s941ms 13s941ms Oct 07 20 1 18s253ms 18s253ms Oct 08 20 1 10s454ms 10s454ms Oct 09 20 1 21s943ms 21s943ms Oct 10 20 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m13s - Times executed: 5 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-09 18:43:41 Duration: 21s943ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-07 18:42:50 Duration: 18s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-06 18:34:06 Duration: 13s941ms 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 74 7m30s 5s7ms 9s528ms 6s86ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 08 26 2m45s 6s366ms 21 5 29s870ms 5s974ms Oct 07 08 6 41s149ms 6s858ms 09 2 11s412ms 5s706ms 21 2 10s875ms 5s437ms Oct 08 08 4 22s211ms 5s552ms 21 5 29s94ms 5s818ms Oct 09 08 6 40s134ms 6s689ms Oct 10 08 12 1m8s 5s712ms 09 6 31s605ms 5s267ms [ User: a3dsupervisor - Total duration: 7m30s - Times executed: 74 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m30s - Times executed: 74 ]
-
COMMIT;
Date: 2025-10-07 06:27:05 Duration: 9s528ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-09 06:48:51 Duration: 8s385ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-06 06:49:56 Duration: 8s294ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 13 4m8s 6s495ms 46s367ms 19s141ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 10 1 9s675ms 9s675ms 20 1 6s933ms 6s933ms Oct 07 09 2 1m14s 37s198ms 20 1 6s495ms 6s495ms Oct 08 09 1 11s497ms 11s497ms 20 1 9s53ms 9s53ms Oct 09 09 2 54s607ms 27s303ms 11 1 43s114ms 43s114ms 20 1 10s578ms 10s578ms Oct 10 09 1 11s17ms 11s17ms 21 1 11s469ms 11s469ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-07 07:09:34 Duration: 46s367ms 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-09 07:30:22 Duration: 45s989ms 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-09 09:29:33 Duration: 43s114ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 9m41s 1m46s 2m13s 1m56s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 20 1 1m48s 1m48s Oct 07 20 1 1m48s 1m48s Oct 08 20 1 2m4s 2m4s Oct 09 20 1 2m13s 2m13s Oct 10 20 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 9m41s - Times executed: 5 ]
[ Application: psql - Total duration: 9m41s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-09 18:55:43 Duration: 2m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-08 18:55:42 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 18:47:51 Duration: 1m48s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 6m18s 1m14s 1m17s 1m15s 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 #4
Day Hour Count Duration Avg duration Oct 06 20 1 1m14s 1m14s Oct 07 20 1 1m14s 1m14s Oct 08 20 1 1m17s 1m17s Oct 09 20 1 1m17s 1m17s Oct 10 20 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m18s - 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-08 18:38:23 Duration: 1m17s 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-09 18:37:57 Duration: 1m17s 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-07 18:37:46 Duration: 1m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 5 3m11s 29s58ms 47s444ms 38s322ms create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 20 1 43s499ms 43s499ms Oct 07 20 1 29s58ms 29s58ms Oct 08 20 1 37s144ms 37s144ms Oct 09 20 1 34s466ms 34s466ms Oct 10 20 1 47s444ms 47s444ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-10 18:41:06 Duration: 47s444ms 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-06 18:29:45 Duration: 43s499ms 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-08 18:39:01 Duration: 37s144ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5 3m1s 33s680ms 39s418ms 36s243ms alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 20 1 36s476ms 36s476ms Oct 07 20 1 35s117ms 35s117ms Oct 08 20 1 33s680ms 33s680ms Oct 09 20 1 39s418ms 39s418ms Oct 10 20 1 36s524ms 36s524ms [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m1s - 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-09 18:40:07 Duration: 39s418ms 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-10 18:43:04 Duration: 36s524ms 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-06 18:31:25 Duration: 36s476ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5 2m57s 24s830ms 51s108ms 35s404ms create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 20 1 32s897ms 32s897ms Oct 07 20 1 51s108ms 51s108ms Oct 08 20 1 33s735ms 33s735ms Oct 09 20 1 24s830ms 24s830ms Oct 10 20 1 34s450ms 34s450ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-07 18:38:38 Duration: 51s108ms 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-10 18:41:15 Duration: 34s450ms 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-08 18:39:09 Duration: 33s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 2m57s 34s754ms 36s208ms 35s403ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 20 1 35s749ms 35s749ms Oct 07 20 1 34s899ms 34s899ms Oct 08 20 1 34s754ms 34s754ms Oct 09 20 1 35s405ms 35s405ms Oct 10 20 1 36s208ms 36s208ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - 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-10 18:39:41 Duration: 36s208ms 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-06 18:28:22 Duration: 35s749ms 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-09 18:37:15 Duration: 35s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 2m56s 33s594ms 36s406ms 35s262ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 06 20 1 36s406ms 36s406ms Oct 07 20 1 36s207ms 36s207ms Oct 08 20 1 33s594ms 33s594ms Oct 09 20 1 33s968ms 33s968ms Oct 10 20 1 36s135ms 36s135ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-06 18:32:06 Duration: 36s406ms 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-07 18:40:50 Duration: 36s207ms 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-10 18:43:48 Duration: 36s135ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 2m6s 24s381ms 26s935ms 25s250ms create index i_fk_gtp_obj_rel_vt_rel on public.gtp_obj_rel_vt using btree (relation_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 20 1 26s935ms 26s935ms Oct 07 20 1 24s885ms 24s885ms Oct 08 20 1 24s381ms 24s381ms Oct 09 20 1 24s673ms 24s673ms Oct 10 20 1 25s376ms 25s376ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - 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-06 18:28:50 Duration: 26s935ms 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-10 18:40:06 Duration: 25s376ms 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-07 18:37:31 Duration: 24s885ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 1m59s 17s630ms 27s772ms 23s955ms 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 #11
Day Hour Count Duration Avg duration Oct 06 20 1 23s686ms 23s686ms Oct 07 20 1 23s582ms 23s582ms Oct 08 20 1 27s105ms 27s105ms Oct 09 20 1 17s630ms 17s630ms Oct 10 20 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 1m59s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m59s - 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-10 18:43:35 Duration: 27s772ms 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-08 18:41:32 Duration: 27s105ms 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-06 18:31:49 Duration: 23s686ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 1m49s 14s188ms 32s679ms 21s980ms create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 20 1 14s188ms 14s188ms Oct 07 20 1 19s10ms 19s10ms Oct 08 20 1 22s182ms 22s182ms Oct 09 20 1 21s841ms 21s841ms Oct 10 20 1 32s679ms 32s679ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - 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-10 18:42:11 Duration: 32s679ms 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-08 18:39:52 Duration: 22s182ms 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-09 18:39:11 Duration: 21s841ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 1m49s 13s840ms 33s808ms 21s807ms create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 20 1 27s940ms 27s940ms Oct 07 20 1 16s136ms 16s136ms Oct 08 20 1 17s311ms 17s311ms Oct 09 20 1 13s840ms 13s840ms Oct 10 20 1 33s808ms 33s808ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-10 18:40:40 Duration: 33s808ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-06 18:29:18 Duration: 27s940ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-08 18:38:23 Duration: 17s311ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 1m30s 11s196ms 24s713ms 18s78ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 20 1 24s713ms 24s713ms Oct 07 20 1 11s196ms 11s196ms Oct 08 20 1 20s310ms 20s310ms Oct 09 20 1 16s573ms 16s573ms Oct 10 20 1 17s599ms 17s599ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-06 18:30:17 Duration: 24s713ms 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-08 18:39:36 Duration: 20s310ms 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-10 18:41:38 Duration: 17s599ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 1m30s 15s660ms 20s414ms 18s17ms create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 20 1 15s660ms 15s660ms Oct 07 20 1 20s414ms 20s414ms Oct 08 20 1 17s389ms 17s389ms Oct 09 20 1 17s832ms 17s832ms Oct 10 20 1 18s789ms 18s789ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-07 18:39:25 Duration: 20s414ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-10 18:42:11 Duration: 18s789ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-09 18:39:16 Duration: 17s832ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 1m27s 13s912ms 22s857ms 17s505ms 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 06 20 1 13s912ms 13s912ms Oct 07 20 1 14s580ms 14s580ms Oct 08 20 1 19s898ms 19s898ms Oct 09 20 1 16s276ms 16s276ms Oct 10 20 1 22s857ms 22s857ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m27s - 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-10 18:41:37 Duration: 22s857ms 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-08 18:39:29 Duration: 19s898ms 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-09 18:38:49 Duration: 16s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 1m25s 13s187ms 20s664ms 17s155ms alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 20 1 13s187ms 13s187ms Oct 07 20 1 14s253ms 14s253ms Oct 08 20 1 19s671ms 19s671ms Oct 09 20 1 20s664ms 20s664ms Oct 10 20 1 18s 18s [ 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-09 18:42:10 Duration: 20s664ms 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-08 18:42:51 Duration: 19s671ms 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-10 18:44:58 Duration: 18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 1m22s 12s439ms 25s87ms 16s565ms 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 #18
Day Hour Count Duration Avg duration Oct 06 20 1 16s917ms 16s917ms Oct 07 20 1 25s87ms 25s87ms Oct 08 20 1 12s439ms 12s439ms Oct 09 20 1 13s893ms 13s893ms Oct 10 20 1 14s487ms 14s487ms [ 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-07 18:39:04 Duration: 25s87ms 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-06 18:30:22 Duration: 16s917ms 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-10 18:41:52 Duration: 14s487ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 1m13s 8s963ms 21s943ms 14s711ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 20 1 13s941ms 13s941ms Oct 07 20 1 18s253ms 18s253ms Oct 08 20 1 10s454ms 10s454ms Oct 09 20 1 21s943ms 21s943ms Oct 10 20 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m13s - Times executed: 5 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-09 18:43:41 Duration: 21s943ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-07 18:42:50 Duration: 18s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-06 18:34:06 Duration: 13s941ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 1m13s 11s535ms 17s233ms 14s707ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 20 1 17s233ms 17s233ms Oct 07 20 1 15s231ms 15s231ms Oct 08 20 1 11s535ms 11s535ms Oct 09 20 1 15s455ms 15s455ms Oct 10 20 1 14s81ms 14s81ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m13s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-06 18:33:41 Duration: 17s233ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-09 18:43:04 Duration: 15s455ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-07 18:42:17 Duration: 15s231ms 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 4m8s 4m24s 4m16s 2 8m32s call pack_gtp_dba.p_anonymize_dcp ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 09 09 1 4m8s 4m8s 11 1 4m24s 4m24s [ User: a3dsupervisor - Total duration: 8m32s - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8m32s - Times executed: 2 ]
-
call pack_gtp_dba.p_anonymize_dcp ();
Date: 2025-10-09 09:24:36 Duration: 4m24s 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-09 07:25:13 Duration: 4m8s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 1m46s 2m13s 1m56s 5 9m41s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 20 1 1m48s 1m48s Oct 07 20 1 1m48s 1m48s Oct 08 20 1 2m4s 2m4s Oct 09 20 1 2m13s 2m13s Oct 10 20 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 9m41s - Times executed: 5 ]
[ Application: psql - Total duration: 9m41s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-09 18:55:43 Duration: 2m13s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-08 18:55:42 Duration: 2m4s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 18:47:51 Duration: 1m48s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m14s 1m17s 1m15s 5 6m18s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 20 1 1m14s 1m14s Oct 07 20 1 1m14s 1m14s Oct 08 20 1 1m17s 1m17s Oct 09 20 1 1m17s 1m17s Oct 10 20 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m18s - 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-08 18:38:23 Duration: 1m17s 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-09 18:37:57 Duration: 1m17s 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-07 18:37:46 Duration: 1m14s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 29s58ms 47s444ms 38s322ms 5 3m11s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 20 1 43s499ms 43s499ms Oct 07 20 1 29s58ms 29s58ms Oct 08 20 1 37s144ms 37s144ms Oct 09 20 1 34s466ms 34s466ms Oct 10 20 1 47s444ms 47s444ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2025-10-10 18:41:06 Duration: 47s444ms 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-06 18:29:45 Duration: 43s499ms 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-08 18:39:01 Duration: 37s144ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 33s680ms 39s418ms 36s243ms 5 3m1s alter table only public.gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 20 1 36s476ms 36s476ms Oct 07 20 1 35s117ms 35s117ms Oct 08 20 1 33s680ms 33s680ms Oct 09 20 1 39s418ms 39s418ms Oct 10 20 1 36s524ms 36s524ms [ User: a3dsupervisor - Total duration: 3m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m1s - 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-09 18:40:07 Duration: 39s418ms 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-10 18:43:04 Duration: 36s524ms 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-06 18:31:25 Duration: 36s476ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 24s830ms 51s108ms 35s404ms 5 2m57s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 20 1 32s897ms 32s897ms Oct 07 20 1 51s108ms 51s108ms Oct 08 20 1 33s735ms 33s735ms Oct 09 20 1 24s830ms 24s830ms Oct 10 20 1 34s450ms 34s450ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2025-10-07 18:38:38 Duration: 51s108ms 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-10 18:41:15 Duration: 34s450ms 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-08 18:39:09 Duration: 33s735ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 34s754ms 36s208ms 35s403ms 5 2m57s 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 06 20 1 35s749ms 35s749ms Oct 07 20 1 34s899ms 34s899ms Oct 08 20 1 34s754ms 34s754ms Oct 09 20 1 35s405ms 35s405ms Oct 10 20 1 36s208ms 36s208ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - 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-10 18:39:41 Duration: 36s208ms 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-06 18:28:22 Duration: 35s749ms 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-09 18:37:15 Duration: 35s405ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 33s594ms 36s406ms 35s262ms 5 2m56s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 20 1 36s406ms 36s406ms Oct 07 20 1 36s207ms 36s207ms Oct 08 20 1 33s594ms 33s594ms Oct 09 20 1 33s968ms 33s968ms Oct 10 20 1 36s135ms 36s135ms [ User: a3dsupervisor - Total duration: 2m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m56s - 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-06 18:32:06 Duration: 36s406ms 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-07 18:40:50 Duration: 36s207ms 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-10 18:43:48 Duration: 36s135ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 24s381ms 26s935ms 25s250ms 5 2m6s 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 #9
Day Hour Count Duration Avg duration Oct 06 20 1 26s935ms 26s935ms Oct 07 20 1 24s885ms 24s885ms Oct 08 20 1 24s381ms 24s381ms Oct 09 20 1 24s673ms 24s673ms Oct 10 20 1 25s376ms 25s376ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m6s - 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-06 18:28:50 Duration: 26s935ms 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-10 18:40:06 Duration: 25s376ms 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-07 18:37:31 Duration: 24s885ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 17s630ms 27s772ms 23s955ms 5 1m59s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 20 1 23s686ms 23s686ms Oct 07 20 1 23s582ms 23s582ms Oct 08 20 1 27s105ms 27s105ms Oct 09 20 1 17s630ms 17s630ms Oct 10 20 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 1m59s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m59s - 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-10 18:43:35 Duration: 27s772ms 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-08 18:41:32 Duration: 27s105ms 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-06 18:31:49 Duration: 23s686ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 14s188ms 32s679ms 21s980ms 5 1m49s create index i_gtp_obj_rel_vt_ntt_p on public.gtp_obj_rel_vt using btree (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 20 1 14s188ms 14s188ms Oct 07 20 1 19s10ms 19s10ms Oct 08 20 1 22s182ms 22s182ms Oct 09 20 1 21s841ms 21s841ms Oct 10 20 1 32s679ms 32s679ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - 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-10 18:42:11 Duration: 32s679ms 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-08 18:39:52 Duration: 22s182ms 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-09 18:39:11 Duration: 21s841ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 13s840ms 33s808ms 21s807ms 5 1m49s create index i_fk_gtp_obj_rel_vt_relt on public.gtp_obj_rel_vt using btree (rel_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 20 1 27s940ms 27s940ms Oct 07 20 1 16s136ms 16s136ms Oct 08 20 1 17s311ms 17s311ms Oct 09 20 1 13s840ms 13s840ms Oct 10 20 1 33s808ms 33s808ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-10 18:40:40 Duration: 33s808ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-06 18:29:18 Duration: 27s940ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON public.gtp_obj_rel_vt USING btree (rel_template_num_id);
Date: 2025-10-08 18:38:23 Duration: 17s311ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6s495ms 46s367ms 19s141ms 13 4m8s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 10 1 9s675ms 9s675ms 20 1 6s933ms 6s933ms Oct 07 09 2 1m14s 37s198ms 20 1 6s495ms 6s495ms Oct 08 09 1 11s497ms 11s497ms 20 1 9s53ms 9s53ms Oct 09 09 2 54s607ms 27s303ms 11 1 43s114ms 43s114ms 20 1 10s578ms 10s578ms Oct 10 09 1 11s17ms 11s17ms 21 1 11s469ms 11s469ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 13 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m8s - Times executed: 13 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-07 07:09:34 Duration: 46s367ms 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-09 07:30:22 Duration: 45s989ms 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-09 09:29:33 Duration: 43s114ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 11s196ms 24s713ms 18s78ms 5 1m30s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 20 1 24s713ms 24s713ms Oct 07 20 1 11s196ms 11s196ms Oct 08 20 1 20s310ms 20s310ms Oct 09 20 1 16s573ms 16s573ms Oct 10 20 1 17s599ms 17s599ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-06 18:30:17 Duration: 24s713ms 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-08 18:39:36 Duration: 20s310ms 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-10 18:41:38 Duration: 17s599ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 15s660ms 20s414ms 18s17ms 5 1m30s create index i_gtp_obj_rel_vt_obj_vt on public.gtp_obj_rel_vt using btree (obj_num_id, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 20 1 15s660ms 15s660ms Oct 07 20 1 20s414ms 20s414ms Oct 08 20 1 17s389ms 17s389ms Oct 09 20 1 17s832ms 17s832ms Oct 10 20 1 18s789ms 18s789ms [ User: a3dsupervisor - Total duration: 1m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m30s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-07 18:39:25 Duration: 20s414ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-10 18:42:11 Duration: 18s789ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON public.gtp_obj_rel_vt USING btree (obj_num_id, view_template_num_id);
Date: 2025-10-09 18:39:16 Duration: 17s832ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 13s912ms 22s857ms 17s505ms 5 1m27s 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 06 20 1 13s912ms 13s912ms Oct 07 20 1 14s580ms 14s580ms Oct 08 20 1 19s898ms 19s898ms Oct 09 20 1 16s276ms 16s276ms Oct 10 20 1 22s857ms 22s857ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m27s - 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-10 18:41:37 Duration: 22s857ms 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-08 18:39:29 Duration: 19s898ms 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-09 18:38:49 Duration: 16s276ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 13s187ms 20s664ms 17s155ms 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 #17
Day Hour Count Duration Avg duration Oct 06 20 1 13s187ms 13s187ms Oct 07 20 1 14s253ms 14s253ms Oct 08 20 1 19s671ms 19s671ms Oct 09 20 1 20s664ms 20s664ms Oct 10 20 1 18s 18s [ 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-09 18:42:10 Duration: 20s664ms 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-08 18:42:51 Duration: 19s671ms 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-10 18:44:58 Duration: 18s Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 12s439ms 25s87ms 16s565ms 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 #18
Day Hour Count Duration Avg duration Oct 06 20 1 16s917ms 16s917ms Oct 07 20 1 25s87ms 25s87ms Oct 08 20 1 12s439ms 12s439ms Oct 09 20 1 13s893ms 13s893ms Oct 10 20 1 14s487ms 14s487ms [ 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-07 18:39:04 Duration: 25s87ms 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-06 18:30:22 Duration: 16s917ms 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-10 18:41:52 Duration: 14s487ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 8s963ms 21s943ms 14s711ms 5 1m13s copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 20 1 13s941ms 13s941ms Oct 07 20 1 18s253ms 18s253ms Oct 08 20 1 10s454ms 10s454ms Oct 09 20 1 21s943ms 21s943ms Oct 10 20 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m13s - Times executed: 5 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-09 18:43:41 Duration: 21s943ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-07 18:42:50 Duration: 18s253ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) FROM stdin;
Date: 2025-10-06 18:34:06 Duration: 13s941ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 11s535ms 17s233ms 14s707ms 5 1m13s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 20 1 17s233ms 17s233ms Oct 07 20 1 15s231ms 15s231ms Oct 08 20 1 11s535ms 11s535ms Oct 09 20 1 15s455ms 15s455ms Oct 10 20 1 14s81ms 14s81ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 1m13s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-06 18:33:41 Duration: 17s233ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-09 18:43:04 Duration: 15s455ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-07 18:42:17 Duration: 15s231ms Database: autotest_feat_batch User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
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
- 19,603 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 5506 ERROR entries
- 28 WARNING entries
Most Frequent Errors/Events
Key values
- 5,088 Max number of times the same event was reported
- 5,535 Total events found
Rank Times reported Error 1 5,088 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 06 21 90 22 400 23 208 00 230 01 2 Oct 07 02 3 03 1 21 90 22 371 23 97 00 282 01 31 Oct 08 21 99 22 639 23 48 00 699 01 36 Oct 09 02 1 03 4 04 1 21 100 22 465 23 89 00 340 01 32 Oct 10 21 53 22 261 23 125 00 260 01 31 2 182 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 06 10 2 11 10 14 12 15 28 16 4 19 2 Oct 07 09 11 10 4 11 4 14 21 15 21 16 2 17 4 19 3 Oct 08 09 2 11 2 12 2 17 2 18 2 19 3 Oct 09 09 2 10 5 11 10 16 4 19 3 Oct 10 09 2 10 4 11 2 17 3 19 3 Oct 11 19 3 3 118 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 09 11 118 4 16 WARNING: NO Sequence found_2 for OBJ_ID (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 09 09 8 11 8 5 12 WARNING: NO Sequence found for OBJ_ID (...)
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 09 09 6 11 6 6 7 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 3 Oct 10 20 1 7 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 #7
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 8 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 #8
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 9 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 #9
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 10 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 11 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 12 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 13 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 #13
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 14 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 15 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 #15
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 16 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 #16
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 09 20 1 Oct 10 20 1 17 4 ERROR: invalid input syntax for type bigint: ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 09 09 2 11 2 18 4 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 06 20 1 Oct 07 20 1 Oct 08 20 1 Oct 10 20 1 19 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 #19
Day Hour Count Oct 07 20 2 Oct 10 20 1 20 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: PACK_GTP_CONSTANTS.FIELD_SEPARATORSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 09 09 1 11 1 21 2 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 #21
Day Hour Count Oct 08 20 1 Oct 09 20 1 22 2 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 #22
Day Hour Count Oct 09 09 1 11 1 23 2 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 #23
Day Hour Count Oct 06 20 1 Oct 07 20 1 24 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: TESTSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #24
Day Hour Count Oct 09 09 1 11 1 25 2 ERROR: OBJ_ID nullcall pack_gtp_trigger.p_update_gtp_obj_name(...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 09 09 1 11 1 26 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #26
Day Hour Count Oct 09 09 1 11 1 27 2 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 #27
Day Hour Count Oct 09 09 1 11 1 28 2 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 #28
Day Hour Count Oct 08 20 1 Oct 09 20 1 29 2 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 #29
Day Hour Count Oct 08 08 2 30 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #30
Day Hour Count Oct 09 09 1 11 1 31 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: bidonSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #31
Day Hour Count Oct 09 09 1 11 1 32 2 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 #32
Day Hour Count Oct 07 20 1 Oct 10 20 1 33 2 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 #33
Day Hour Count Oct 09 09 1 11 1 34 2 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 #34
Day Hour Count Oct 08 08 2 35 2 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 #35
Day Hour Count Oct 09 09 1 11 1 36 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: testSELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #36
Day Hour Count Oct 09 09 1 11 1 37 2 ERROR: value too long for type character varying(...)SELECT pack_gtp_trigger.f_insert_history_obj_action(...)
Times Reported Most Frequent Error / Event #37
Day Hour Count Oct 09 09 1 11 1 38 2 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 #38
Day Hour Count Oct 09 09 1 11 1 39 2 ERROR: EXCEPTION IN public.const2int: value is not convertible to integer: SELECT 'const2int', public.const2int()
Times Reported Most Frequent Error / Event #39
Day Hour Count Oct 09 09 1 11 1 40 2 ERROR: EXCEPTION IN public.constant key is not defined: bidonSELECT 'const', public.const()
Times Reported Most Frequent Error / Event #40
Day Hour Count Oct 09 09 1 11 1 41 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const2text', public.const2text()
Times Reported Most Frequent Error / Event #41
Day Hour Count Oct 09 09 1 11 1 42 2 ERROR: EXCEPTION IN public.constant key is not defined: SELECT 'const', public.const()
Times Reported Most Frequent Error / Event #42
Day Hour Count Oct 09 09 1 11 1 43 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #43
Day Hour Count Oct 07 15 1 44 1 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 #44
Day Hour Count Oct 09 11 1 45 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (...)
Times Reported Most Frequent Error / Event #45
Day Hour Count Oct 10 20 1 46 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #46
Day Hour Count Oct 07 09 1 47 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 #47
Day Hour Count Oct 10 20 1