pgBadger-
Global information
- Generated on Mon Oct 13 09:35:35 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 44,778 log entries in 1m32s
- Log start from 2025-10-06 06:11:01 to 2025-10-10 15:18:28
-
Overview
Global Stats
- 41 Number of unique normalized queries
- 196 Number of queries
- 45m31s Total query duration
- 2025-10-06 06:20:34 First query
- 2025-10-10 11:23:01 Last query
- 3 queries/s at 2025-10-09 06:48:37 Query peak
- 45m31s Total query duration
- 19s145ms Prepare/parse total duration
- 25s510ms Bind total duration
- 44m47s Execute total duration
- 10,754 Number of events
- 19 Number of unique normalized events
- 10,549 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 1,005 Number temporary file
- 2.34 GiB Max size of temporary file
- 16.10 MiB Average size of temporary file
- 7,282 Total number of sessions
- 37 sessions at 2025-10-07 07:34:54 Session peak
- 20d2h10m13s Total duration of sessions
- 3m58s Average duration of sessions
- 0 Average queries per session
- 375ms Average queries duration per session
- 3m57s Average idle time per session
- 7,286 Total number of connections
- 14 connections/s at 2025-10-09 11:50:58 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-09 06:48:37 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-07 06:47:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-09 06:48:37 Date
Queries duration
Key values
- 45m31s 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 32 0ms 55s498ms 11s834ms 46s711ms 49s802ms 1m29s 07 2 0ms 7s108ms 6s312ms 0ms 0ms 7s108ms 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 2 0ms 5s42ms 5s30ms 0ms 0ms 10s60ms 19 7 0ms 6s356ms 5s807ms 0ms 5s147ms 35s502ms 20 1 0ms 28s948ms 28s948ms 0ms 0ms 28s948ms 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 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 1m48s 19s966ms 1m 1m20s 1m48s 07 4 0ms 7s91ms 6s499ms 0ms 6s254ms 19s741ms 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 2 0ms 5s767ms 5s685ms 0ms 0ms 11s370ms 19 4 0ms 5s802ms 5s322ms 0ms 0ms 21s291ms 20 1 0ms 32s620ms 32s620ms 0ms 0ms 32s620ms 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 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 33 0ms 47s324ms 13s936ms 48s559ms 54s49ms 59s637ms 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 1 0ms 5s120ms 5s120ms 0ms 0ms 5s120ms 19 5 0ms 5s832ms 5s567ms 0ms 0ms 17s422ms 20 1 0ms 31s842ms 31s842ms 0ms 0ms 31s842ms 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 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 32 0ms 1m24s 18s145ms 56s675ms 1m11s 1m24s 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 1 0ms 6s373ms 6s373ms 0ms 0ms 6s373ms 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 9 0ms 7s20ms 5s933ms 0ms 11s48ms 25s776ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 1 0ms 30s73ms 30s73ms 0ms 0ms 30s73ms 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 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 51s136ms 11s469ms 21s740ms 36s567ms 51s248ms 07 4 0ms 5s637ms 5s340ms 0ms 5s9ms 11s268ms 08 1 0ms 10s433ms 10s433ms 0ms 0ms 10s433ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 1 0ms 1m20s 1m20s 0ms 0ms 1m20s 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 11 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 5 9s656ms 0ms 0ms 48s283ms 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 1 0 28s948ms 0ms 0ms 28s948ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 07 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 5 33s424ms 0ms 10s491ms 1m48s 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 1 0 32s620ms 0ms 0ms 32s620ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 08 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 7 20s421ms 0ms 0ms 54s49ms 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 1 0 5s168ms 0ms 0ms 5s168ms 20 1 0 31s842ms 0ms 0ms 31s842ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 09 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 8 35s878ms 0ms 43s155ms 1m24s 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 1 0 30s73ms 0ms 0ms 30s73ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 10 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 4 10s505ms 0ms 0ms 25s553ms 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 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) 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 1 0 5s577ms 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 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 1 0 5s571ms 0ms 0ms 5s310ms 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 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 1 0 7s490ms 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 1 0 0 0 5s244ms 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 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 1 0 8s580ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 1 0 6s373ms 0ms 0ms 6s373ms 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 1 0 0 0 6s740ms 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 10 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 1 0 7s378ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 10s433ms 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 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 9 9.00 3.33% 07 0 2 2.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 2 2.00 0.00% 19 0 7 7.00 0.00% 20 0 1 1.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 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 4 4.00 4.17% 07 0 4 4.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 2 2.00 0.00% 19 0 4 4.00 0.00% 20 0 1 1.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 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 5 5.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 1 1.00 0.00% 19 0 5 5.00 0.00% 20 0 1 1.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 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 7 7.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 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 9 9.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.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 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 9 9.00 4.17% 07 0 4 4.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 1 1.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 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 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second 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 18 0.01/s 06 362 0.10/s 07 53 0.01/s 08 56 0.02/s 09 41 0.01/s 10 45 0.01/s 11 59 0.02/s 12 44 0.01/s 13 65 0.02/s 14 55 0.02/s 15 51 0.01/s 16 41 0.01/s 17 45 0.01/s 18 58 0.02/s 19 37 0.01/s 20 42 0.01/s 21 56 0.02/s 22 46 0.01/s 23 43 0.01/s Oct 07 00 50 0.01/s 01 53 0.01/s 02 61 0.02/s 03 45 0.01/s 04 43 0.01/s 05 37 0.01/s 06 355 0.10/s 07 51 0.01/s 08 56 0.02/s 09 55 0.02/s 10 44 0.01/s 11 56 0.02/s 12 51 0.01/s 13 59 0.02/s 14 59 0.02/s 15 54 0.01/s 16 40 0.01/s 17 39 0.01/s 18 52 0.01/s 19 68 0.02/s 20 57 0.02/s 21 42 0.01/s 22 56 0.02/s 23 60 0.02/s Oct 08 00 66 0.02/s 01 53 0.01/s 02 46 0.01/s 03 41 0.01/s 04 51 0.01/s 05 40 0.01/s 06 350 0.10/s 07 43 0.01/s 08 42 0.01/s 09 58 0.02/s 10 57 0.02/s 11 50 0.01/s 12 58 0.02/s 13 49 0.01/s 14 54 0.01/s 15 54 0.01/s 16 57 0.02/s 17 36 0.01/s 18 49 0.01/s 19 44 0.01/s 20 62 0.02/s 21 63 0.02/s 22 50 0.01/s 23 56 0.02/s Oct 09 00 67 0.02/s 01 72 0.02/s 02 53 0.01/s 03 55 0.02/s 04 52 0.01/s 05 45 0.01/s 06 354 0.10/s 07 53 0.01/s 08 3 0.00/s 09 6 0.00/s 10 2 0.00/s 11 62 0.02/s 12 59 0.02/s 13 74 0.02/s 14 69 0.02/s 15 56 0.02/s 16 72 0.02/s 17 53 0.01/s 18 67 0.02/s 19 57 0.02/s 20 66 0.02/s 21 45 0.01/s 22 46 0.01/s 23 57 0.02/s Oct 10 00 52 0.01/s 01 50 0.01/s 02 66 0.02/s 03 56 0.02/s 04 56 0.02/s 05 45 0.01/s 06 354 0.10/s 07 58 0.02/s 08 112 0.03/s 09 109 0.03/s 10 82 0.02/s 11 131 0.04/s 12 92 0.03/s 13 40 0.01/s 14 11 0.00/s 15 16 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 11 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 Day Hour Count Average Duration Average idle time Oct 05 00 2 73ms 73ms 01 2 77ms 77ms 02 2 76ms 76ms 03 2 76ms 76ms 04 2 72ms 72ms 05 2 72ms 72ms 06 2 79ms 79ms 07 2 74ms 74ms 08 2 73ms 73ms 09 2 73ms 73ms 10 2 75ms 75ms 11 2 74ms 74ms 12 2 72ms 72ms 13 2 95ms 95ms 14 2 89ms 89ms 15 2 73ms 73ms 16 2 83ms 83ms 17 2 82ms 82ms 18 2 81ms 81ms 19 2 83ms 83ms 20 2 75ms 75ms 21 2 76ms 76ms 22 2 73ms 73ms 23 2 77ms 77ms Oct 06 00 2 75ms 75ms 01 2 73ms 73ms 02 2 77ms 77ms 03 2 73ms 73ms 04 2 103ms 103ms 05 18 3m7s 3m7s 06 358 28s81ms 27s23ms 07 50 2m4s 2m3s 08 57 1m16s 1m16s 09 41 1m29s 1m29s 10 42 1m23s 1m23s 11 62 10m37s 10m37s 12 43 1m25s 1m25s 13 69 1m18s 1m18s 14 55 1m24s 1m24s 15 50 1m23s 1m23s 16 42 1m28s 1m28s 17 44 44m10s 44m10s 18 59 1m24s 1m24s 19 33 1m23s 1m22s 20 42 1m22s 1m22s 21 56 1m20s 1m20s 22 42 1m22s 1m22s 23 47 1m14s 1m14s Oct 07 00 50 1m20s 1m20s 01 53 1m13s 1m13s 02 61 1m19s 1m19s 03 45 1m21s 1m21s 04 42 1m14s 1m14s 05 41 55m41s 55m41s 06 348 26s824ms 25s332ms 07 51 1m52s 1m51s 08 56 1m16s 1m16s 09 55 1m19s 1m19s 10 45 1m19s 1m19s 11 59 1m24s 1m24s 12 51 1m16s 1m16s 13 58 1m14s 1m14s 14 60 1m12s 1m12s 15 50 1m17s 1m17s 16 44 1m24s 1m24s 17 39 49m29s 49m29s 18 52 1m27s 1m27s 19 64 1m18s 1m18s 20 60 1m10s 1m9s 21 42 1m15s 1m15s 22 57 1m13s 1m13s 23 60 1m13s 1m13s Oct 08 00 62 1m19s 1m19s 01 54 1m9s 1m9s 02 45 1m10s 1m10s 03 41 1m10s 1m10s 04 55 1m12s 1m12s 05 43 53m3s 53m3s 06 346 29s585ms 28s256ms 07 41 2m 2m 08 42 1m31s 1m31s 09 61 1m24s 1m24s 10 57 1m23s 1m23s 11 50 1m29s 1m29s 12 57 1m19s 1m19s 13 49 1m28s 1m28s 14 55 1m21s 1m21s 15 52 1m29s 1m29s 16 57 1m19s 1m19s 17 38 51m3s 51m3s 18 49 1m37s 1m37s 19 44 1m39s 1m39s 20 58 1m19s 1m18s 21 65 1m17s 1m17s 22 52 1m13s 1m13s 23 56 1m21s 1m21s Oct 09 00 67 1m16s 1m16s 01 68 1m15s 1m15s 02 57 1m22s 1m22s 03 55 1m22s 1m22s 04 52 1m26s 1m26s 05 48 48m6s 48m6s 06 348 24s185ms 22s516ms 07 57 5m15s 5m15s 08 2 84ms 84ms 09 6 74ms 74ms 10 2 80ms 80ms 11 47 15m1s 15m1s 12 70 6m3s 6m3s 13 75 2m3s 2m3s 14 69 1m16s 1m16s 15 59 11m56s 11m56s 16 72 1m19s 1m19s 17 53 17m2s 17m2s 18 67 1m28s 1m27s 19 56 1m26s 1m26s 20 67 1m19s 1m19s 21 44 1m18s 1m18s 22 47 1m27s 1m27s 23 57 1m25s 1m25s Oct 10 00 51 1m24s 1m24s 01 51 1m23s 1m23s 02 66 1m16s 1m16s 03 56 1m22s 1m22s 04 56 1m20s 1m20s 05 48 47m53s 47m53s 06 350 26s371ms 25s519ms 07 59 1m34s 1m33s 08 109 5m36s 5m36s 09 108 2m54s 2m54s 10 80 4m55s 4m55s 11 133 2m58s 2m58s 12 94 3m49s 3m49s 13 40 4m3s 4m3s 14 11 6m9s 6m9s 15 21 1h5m34s 1h5m34s 16 2 86ms 86ms 17 2 77ms 77ms 18 2 135ms 135ms 19 2 107ms 107ms 20 2 93ms 93ms 21 2 89ms 89ms 22 2 76ms 76ms 23 2 88ms 88ms Oct 11 00 2 118ms 118ms 01 2 93ms 93ms 02 2 75ms 75ms 03 2 79ms 79ms 04 2 75ms 75ms 05 2 78ms 78ms 06 2 78ms 78ms 07 2 81ms 81ms 08 2 76ms 76ms 09 2 76ms 76ms 10 2 75ms 75ms 11 2 79ms 79ms 12 2 80ms 80ms 13 2 82ms 82ms 14 2 78ms 78ms 15 2 74ms 74ms 16 2 75ms 75ms 17 2 79ms 79ms 18 2 76ms 76ms 19 2 79ms 79ms 20 2 85ms 85ms 21 2 82ms 82ms 22 2 77ms 77ms 23 2 73ms 73ms -
Connections
Established Connections
Key values
- 14 connections Connection Peak
- 2025-10-09 11:50:58 Date
Connections per database
Key values
- reftk Main Database
- 7,286 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 7,286 connections Total
-
Sessions
Simultaneous sessions
Key values
- 37 sessions Session Peak
- 2025-10-07 07:34:54 Date
Histogram of session times
Key values
- 5,215 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 7,282 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 7,282 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 7,282 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 7,282 sessions Total
Application Count Total Duration Average Duration DBeaver 23.2.0 - Main 'reftk' 4 16h41m10s 4h10m17s DBeaver 23.2.0 - Metadata 'reftk' 4 16h39m49s 4h9m57s DBeaver 23.2.0 - SQLEditor 'Script-1.sql' 1 6h7m41s 6h7m41s DBeaver 23.2.0 - SQLEditor 'Script-3.sql' 2 6h35m47s 3h17m53s DBeaver 23.2.0 - SQLEditor 'Script-4.sql' 1 3h12m45s 3h12m45s PostgreSQL JDBC Driver 5,363 17d19h25m18s 4m46s [unknown] 447 47s751ms 106ms pg_dump 15 4h11m48s 16m47s psql 1,445 1h15m4s 3s117ms -
Temporary Files
Size of temporary files
Key values
- 224.27 MiB Temp Files size Peak
- 2025-10-09 06:25:59 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-09 06:23:29 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.33 MiB 4.33 MiB 06 199 3.22 GiB 16.59 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 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 198 3.23 GiB 16.69 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 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 198 3.23 GiB 16.70 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 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 204 3.24 GiB 16.26 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 1 4.33 MiB 4.33 MiB 12 1 4.33 MiB 4.33 MiB 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 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 195 2.84 GiB 14.90 MiB 07 0 0 0 08 2 8.66 MiB 4.33 MiB 09 1 4.33 MiB 4.33 MiB 10 1 4.34 MiB 4.34 MiB 11 0 0 0 12 3 13.01 MiB 4.34 MiB 13 1 4.34 MiB 4.34 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 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 -
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
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 7 Total read queries
- 179 Total write queries
Queries by database
Key values
- reftk Main database
- 196 Requests
- 44m47s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 196 Requests
User Request type Count Duration a3dsupervisor Total 196 44m47s copy to 29 12m23s ddl 76 14m11s delete 7 51s666ms insert 3 17s295ms others 10 7m6s select 7 2m19s tcl 64 7m37s Duration by user
Key values
- 44m47s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 196 44m47s copy to 29 12m23s ddl 76 14m11s delete 7 51s666ms insert 3 17s295ms others 10 7m6s select 7 2m19s tcl 64 7m37s Queries by host
Key values
- 10.3.0.4 Main host
- 196 Requests
- 44m47s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 86 Requests
- 21m18s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-07 15:52:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 128 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m48s 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) TO stdout;[ Date: 2025-10-07 06:42:23 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 1m24s 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) TO stdout;[ Date: 2025-10-09 06:41:59 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 1m20s COMMIT;[ Date: 2025-10-10 11:23:01 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
4 1m5s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-09 06:40:34 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 55s498ms VACUUM ANALYZE;[ Date: 2025-10-06 06:26:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 52s633ms VACUUM ANALYZE;[ Date: 2025-10-07 06:29:25 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 51s136ms VACUUM ANALYZE;[ Date: 2025-10-10 06:25:41 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 47s840ms 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) TO stdout;[ Date: 2025-10-07 06:43:11 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 47s653ms VACUUM ANALYZE;[ Date: 2025-10-09 06:29:30 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 47s324ms VACUUM ANALYZE;[ Date: 2025-10-08 06:26:29 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 43s155ms 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) TO stdout;[ Date: 2025-10-09 06:42:42 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 41s828ms 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) TO stdout;[ Date: 2025-10-09 06:43:24 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 40s341ms 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) TO stdout;[ Date: 2025-10-08 06:37:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 36s792ms 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) TO stdout;[ Date: 2025-10-08 06:38:40 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 36s567ms VACUUM ANALYSE;[ Date: 2025-10-10 06:26:32 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 34s265ms VACUUM ANALYSE;[ Date: 2025-10-06 06:26:56 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 34s31ms VACUUM ANALYSE;[ Date: 2025-10-07 06:30:07 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 33s991ms VACUUM ANALYSE;[ Date: 2025-10-09 06:30:11 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 33s313ms VACUUM ANALYSE;[ Date: 2025-10-08 06:27:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 32s620ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-07 20:33:54 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7m37s 64 5s1ms 1m20s 7s146ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 08 8 59s981ms 7s497ms 09 2 12s625ms 6s312ms 20 2 10s60ms 5s30ms 21 7 40s650ms 5s807ms Oct 07 09 4 25s996ms 6s499ms 20 2 11s370ms 5s685ms 21 4 21s291ms 5s322ms Oct 08 08 4 20s833ms 5s208ms 20 1 5s120ms 5s120ms 21 3 17s422ms 5s807ms Oct 09 08 6 40s67ms 6s677ms 20 8 46s665ms 5s833ms Oct 10 08 8 43s266ms 5s408ms 09 4 21s360ms 5s340ms 13 1 1m20s 1m20s [ User: a3dsupervisor - Total duration: 7m37s - Times executed: 64 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m37s - Times executed: 64 ]
-
COMMIT;
Date: 2025-10-10 11:23:01 Duration: 1m20s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-06 06:49:56 Duration: 9s156ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-09 06:48:51 Duration: 8s391ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m14s 5 47s324ms 55s498ms 50s849ms vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 08 1 55s498ms 55s498ms Oct 07 08 1 52s633ms 52s633ms Oct 08 08 1 47s324ms 47s324ms Oct 09 08 1 47s653ms 47s653ms Oct 10 08 1 51s136ms 51s136ms [ User: a3dsupervisor - Total duration: 4m14s - Times executed: 5 ]
[ Application: psql - Total duration: 4m14s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-06 06:26:15 Duration: 55s498ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-07 06:29:25 Duration: 52s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-10 06:25:41 Duration: 51s136ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4m5s 5 15s526ms 1m48s 49s93ms 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) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 08 1 15s526ms 15s526ms Oct 07 08 1 1m48s 1m48s Oct 08 08 1 40s341ms 40s341ms Oct 09 08 1 1m5s 1m5s Oct 10 08 1 15s860ms 15s860ms [ User: a3dsupervisor - Total duration: 4m5s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m5s - 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) TO stdout;
Date: 2025-10-07 06:42:23 Duration: 1m48s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-09 06:40:34 Duration: 1m5s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:37:45 Duration: 40s341ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 2m52s 5 33s313ms 36s567ms 34s433ms vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 08 1 34s265ms 34s265ms Oct 07 08 1 34s31ms 34s31ms Oct 08 08 1 33s313ms 33s313ms Oct 09 08 1 33s991ms 33s991ms Oct 10 08 1 36s567ms 36s567ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: psql - Total duration: 2m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-10 06:26:32 Duration: 36s567ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 06:26:56 Duration: 34s265ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-07 06:30:07 Duration: 34s31ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 2m49s 5 9s692ms 1m24s 33s911ms 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) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 08 1 9s888ms 9s888ms Oct 07 08 1 47s840ms 47s840ms Oct 08 08 1 17s257ms 17s257ms Oct 09 08 1 1m24s 1m24s Oct 10 08 1 9s692ms 9s692ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m49s - 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) TO stdout;
Date: 2025-10-09 06:41:59 Duration: 1m24s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:11 Duration: 47s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:03 Duration: 17s257ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 2m10s 5 8s963ms 43s155ms 26s144ms 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 08 1 9s203ms 9s203ms Oct 07 08 1 32s605ms 32s605ms Oct 08 08 1 36s792ms 36s792ms Oct 09 08 1 43s155ms 43s155ms Oct 10 08 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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) TO stdout;
Date: 2025-10-09 06:42:42 Duration: 43s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:40 Duration: 36s792ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:44 Duration: 32s605ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 2m3s 4 28s948ms 32s620ms 30s871ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 22 1 28s948ms 28s948ms Oct 07 22 1 32s620ms 32s620ms Oct 08 22 1 31s842ms 31s842ms Oct 09 22 1 30s73ms 30s73ms [ User: a3dsupervisor - Total duration: 2m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m3s - Times executed: 4 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-07 20:33:54 Duration: 32s620ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-08 20:33:29 Duration: 31s842ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-09 20:33:14 Duration: 30s73ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1m43s 5 7s504ms 41s828ms 20s700ms 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) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 08 1 8s71ms 8s71ms Oct 07 08 1 26s111ms 26s111ms Oct 08 08 1 19s987ms 19s987ms Oct 09 08 1 41s828ms 41s828ms Oct 10 08 1 7s504ms 7s504ms [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m43s - 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) TO stdout;
Date: 2025-10-09 06:43:24 Duration: 41s828ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:10 Duration: 26s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:00 Duration: 19s987ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m37s 4 16s798ms 27s786ms 24s383ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 06 08 1 27s786ms 27s786ms Oct 07 08 1 27s707ms 27s707ms Oct 08 08 1 25s242ms 25s242ms Oct 09 08 1 16s798ms 16s798ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 4 ]
[ Application: psql - Total duration: 1m37s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-06 06:22:54 Duration: 27s786ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-07 06:26:01 Duration: 27s707ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-08 06:23:10 Duration: 25s242ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m33s 5 13s850ms 23s888ms 18s757ms alter table 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 #10
Day Hour Count Duration Avg duration Oct 06 08 1 23s888ms 23s888ms Oct 07 08 1 19s6ms 19s6ms Oct 08 08 1 19s548ms 19s548ms Oct 09 08 1 17s494ms 17s494ms Oct 10 08 1 13s850ms 13s850ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: psql - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE 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-06 06:24:21 Duration: 23s888ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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 06:24:39 Duration: 19s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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-07 06:27:35 Duration: 19s6ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m27s 5 14s647ms 21s204ms 17s422ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 08 1 14s647ms 14s647ms Oct 07 08 1 21s204ms 21s204ms Oct 08 08 1 15s445ms 15s445ms Oct 09 08 1 16s198ms 16s198ms Oct 10 08 1 19s617ms 19s617ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-07 06:27:10 Duration: 21s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-10 06:23:29 Duration: 19s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-09 06:27:19 Duration: 16s198ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1m14s 5 12s86ms 18s117ms 14s931ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 08 1 13s103ms 13s103ms Oct 07 08 1 18s117ms 18s117ms Oct 08 08 1 15s364ms 15s364ms Oct 09 08 1 12s86ms 12s86ms Oct 10 08 1 15s986ms 15s986ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-07 06:25:12 Duration: 18s117ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-10 06:21:05 Duration: 15s986ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-08 06:22:23 Duration: 15s364ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1m13s 5 11s763ms 17s897ms 14s619ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 08 1 11s763ms 11s763ms Oct 07 08 1 13s456ms 13s456ms Oct 08 08 1 14s556ms 14s556ms Oct 09 08 1 17s897ms 17s897ms Oct 10 08 1 15s425ms 15s425ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-09 06:23:48 Duration: 17s897ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-10 06:19:24 Duration: 15s425ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-08 06:20:13 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1m4s 4 13s190ms 18s10ms 16s119ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 08 1 13s190ms 13s190ms Oct 07 08 1 18s10ms 18s10ms Oct 08 08 1 17s9ms 17s9ms Oct 09 08 1 16s267ms 16s267ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: psql - Total duration: 1m4s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-07 06:26:19 Duration: 18s10ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-08 06:23:27 Duration: 17s9ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-09 06:25:59 Duration: 16s267ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1m1s 4 5s593ms 29s969ms 15s251ms 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) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 08 1 5s593ms 5s593ms Oct 07 08 1 8s583ms 8s583ms Oct 08 08 1 16s859ms 16s859ms Oct 09 08 1 29s969ms 29s969ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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) TO stdout;
Date: 2025-10-09 06:43:54 Duration: 29s969ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:16 Duration: 16s859ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:18 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 51s666ms 7 5s577ms 10s433ms 7s380ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 08 1 5s577ms 5s577ms Oct 07 08 1 5s831ms 5s831ms Oct 08 08 1 7s490ms 7s490ms Oct 09 08 1 8s580ms 8s580ms 13 1 6s373ms 6s373ms Oct 10 08 1 7s378ms 7s378ms 10 1 10s433ms 10s433ms [ User: a3dsupervisor - Total duration: 51s666ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s666ms - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-10 08:25:27 Duration: 10s433ms Database: reftk 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 06:33:47 Duration: 8s580ms Database: reftk 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-08 06:31:32 Duration: 7s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
17 47s142ms 5 8s396ms 10s350ms 9s428ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 08 1 8s396ms 8s396ms Oct 07 08 1 9s1ms 9s1ms Oct 08 08 1 9s105ms 9s105ms Oct 09 08 1 10s350ms 10s350ms Oct 10 08 1 10s288ms 10s288ms [ User: a3dsupervisor - Total duration: 47s142ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s142ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-09 06:26:56 Duration: 10s350ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-10 06:23:07 Duration: 10s288ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-08 06:23:55 Duration: 9s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 47s125ms 5 6s296ms 14s379ms 9s425ms alter table gtp_obj_composition 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);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 08 1 6s638ms 6s638ms Oct 07 08 1 14s379ms 14s379ms Oct 08 08 1 10s721ms 10s721ms Oct 09 08 1 6s296ms 6s296ms Oct 10 08 1 9s90ms 9s90ms [ User: a3dsupervisor - Total duration: 47s125ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s125ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition 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-07 06:27:55 Duration: 14s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:58 Duration: 10s721ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:05 Duration: 9s90ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 43s566ms 5 7s281ms 11s579ms 8s713ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 08 1 8s203ms 8s203ms Oct 07 08 1 8s221ms 8s221ms Oct 08 08 1 8s280ms 8s280ms Oct 09 08 1 11s579ms 11s579ms Oct 10 08 1 7s281ms 7s281ms [ User: a3dsupervisor - Total duration: 43s566ms - Times executed: 5 ]
[ Application: psql - Total duration: 43s566ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-09 06:26:11 Duration: 11s579ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-08 06:23:35 Duration: 8s280ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-07 06:26:27 Duration: 8s221ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 31s998ms 4 6s728ms 9s756ms 7s999ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 08 1 6s831ms 6s831ms Oct 07 08 1 9s756ms 9s756ms Oct 08 08 1 8s682ms 8s682ms Oct 09 08 1 6s728ms 6s728ms [ User: a3dsupervisor - Total duration: 31s998ms - Times executed: 4 ]
[ Application: psql - Total duration: 31s998ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-07 06:24:54 Duration: 9s756ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-08 06:22:08 Duration: 8s682ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-06 06:21:41 Duration: 6s831ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 64 7m37s 5s1ms 1m20s 7s146ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 08 8 59s981ms 7s497ms 09 2 12s625ms 6s312ms 20 2 10s60ms 5s30ms 21 7 40s650ms 5s807ms Oct 07 09 4 25s996ms 6s499ms 20 2 11s370ms 5s685ms 21 4 21s291ms 5s322ms Oct 08 08 4 20s833ms 5s208ms 20 1 5s120ms 5s120ms 21 3 17s422ms 5s807ms Oct 09 08 6 40s67ms 6s677ms 20 8 46s665ms 5s833ms Oct 10 08 8 43s266ms 5s408ms 09 4 21s360ms 5s340ms 13 1 1m20s 1m20s [ User: a3dsupervisor - Total duration: 7m37s - Times executed: 64 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m37s - Times executed: 64 ]
-
COMMIT;
Date: 2025-10-10 11:23:01 Duration: 1m20s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-06 06:49:56 Duration: 9s156ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-09 06:48:51 Duration: 8s391ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 7 51s666ms 5s577ms 10s433ms 7s380ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 08 1 5s577ms 5s577ms Oct 07 08 1 5s831ms 5s831ms Oct 08 08 1 7s490ms 7s490ms Oct 09 08 1 8s580ms 8s580ms 13 1 6s373ms 6s373ms Oct 10 08 1 7s378ms 7s378ms 10 1 10s433ms 10s433ms [ User: a3dsupervisor - Total duration: 51s666ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s666ms - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-10 08:25:27 Duration: 10s433ms Database: reftk 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 06:33:47 Duration: 8s580ms Database: reftk 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-08 06:31:32 Duration: 7s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 4m14s 47s324ms 55s498ms 50s849ms vacuum analyze;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 08 1 55s498ms 55s498ms Oct 07 08 1 52s633ms 52s633ms Oct 08 08 1 47s324ms 47s324ms Oct 09 08 1 47s653ms 47s653ms Oct 10 08 1 51s136ms 51s136ms [ User: a3dsupervisor - Total duration: 4m14s - Times executed: 5 ]
[ Application: psql - Total duration: 4m14s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-06 06:26:15 Duration: 55s498ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-07 06:29:25 Duration: 52s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-10 06:25:41 Duration: 51s136ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 4m5s 15s526ms 1m48s 49s93ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 08 1 15s526ms 15s526ms Oct 07 08 1 1m48s 1m48s Oct 08 08 1 40s341ms 40s341ms Oct 09 08 1 1m5s 1m5s Oct 10 08 1 15s860ms 15s860ms [ User: a3dsupervisor - Total duration: 4m5s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m5s - 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) TO stdout;
Date: 2025-10-07 06:42:23 Duration: 1m48s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-09 06:40:34 Duration: 1m5s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:37:45 Duration: 40s341ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5 2m52s 33s313ms 36s567ms 34s433ms vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 08 1 34s265ms 34s265ms Oct 07 08 1 34s31ms 34s31ms Oct 08 08 1 33s313ms 33s313ms Oct 09 08 1 33s991ms 33s991ms Oct 10 08 1 36s567ms 36s567ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: psql - Total duration: 2m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-10 06:26:32 Duration: 36s567ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 06:26:56 Duration: 34s265ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-07 06:30:07 Duration: 34s31ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 5 2m49s 9s692ms 1m24s 33s911ms 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 08 1 9s888ms 9s888ms Oct 07 08 1 47s840ms 47s840ms Oct 08 08 1 17s257ms 17s257ms Oct 09 08 1 1m24s 1m24s Oct 10 08 1 9s692ms 9s692ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m49s - 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) TO stdout;
Date: 2025-10-09 06:41:59 Duration: 1m24s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:11 Duration: 47s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:03 Duration: 17s257ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 5 2m10s 8s963ms 43s155ms 26s144ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 08 1 9s203ms 9s203ms Oct 07 08 1 32s605ms 32s605ms Oct 08 08 1 36s792ms 36s792ms Oct 09 08 1 43s155ms 43s155ms Oct 10 08 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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) TO stdout;
Date: 2025-10-09 06:42:42 Duration: 43s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:40 Duration: 36s792ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:44 Duration: 32s605ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 5 1m43s 7s504ms 41s828ms 20s700ms 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) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 08 1 8s71ms 8s71ms Oct 07 08 1 26s111ms 26s111ms Oct 08 08 1 19s987ms 19s987ms Oct 09 08 1 41s828ms 41s828ms Oct 10 08 1 7s504ms 7s504ms [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m43s - 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) TO stdout;
Date: 2025-10-09 06:43:24 Duration: 41s828ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:10 Duration: 26s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:00 Duration: 19s987ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5 1m33s 13s850ms 23s888ms 18s757ms alter table 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 #9
Day Hour Count Duration Avg duration Oct 06 08 1 23s888ms 23s888ms Oct 07 08 1 19s6ms 19s6ms Oct 08 08 1 19s548ms 19s548ms Oct 09 08 1 17s494ms 17s494ms Oct 10 08 1 13s850ms 13s850ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: psql - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE 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-06 06:24:21 Duration: 23s888ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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 06:24:39 Duration: 19s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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-07 06:27:35 Duration: 19s6ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 1m27s 14s647ms 21s204ms 17s422ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 08 1 14s647ms 14s647ms Oct 07 08 1 21s204ms 21s204ms Oct 08 08 1 15s445ms 15s445ms Oct 09 08 1 16s198ms 16s198ms Oct 10 08 1 19s617ms 19s617ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-07 06:27:10 Duration: 21s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-10 06:23:29 Duration: 19s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-09 06:27:19 Duration: 16s198ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m14s 12s86ms 18s117ms 14s931ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 08 1 13s103ms 13s103ms Oct 07 08 1 18s117ms 18s117ms Oct 08 08 1 15s364ms 15s364ms Oct 09 08 1 12s86ms 12s86ms Oct 10 08 1 15s986ms 15s986ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-07 06:25:12 Duration: 18s117ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-10 06:21:05 Duration: 15s986ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-08 06:22:23 Duration: 15s364ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m13s 11s763ms 17s897ms 14s619ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 08 1 11s763ms 11s763ms Oct 07 08 1 13s456ms 13s456ms Oct 08 08 1 14s556ms 14s556ms Oct 09 08 1 17s897ms 17s897ms Oct 10 08 1 15s425ms 15s425ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-09 06:23:48 Duration: 17s897ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-10 06:19:24 Duration: 15s425ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-08 06:20:13 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 47s142ms 8s396ms 10s350ms 9s428ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 08 1 8s396ms 8s396ms Oct 07 08 1 9s1ms 9s1ms Oct 08 08 1 9s105ms 9s105ms Oct 09 08 1 10s350ms 10s350ms Oct 10 08 1 10s288ms 10s288ms [ User: a3dsupervisor - Total duration: 47s142ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s142ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-09 06:26:56 Duration: 10s350ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-10 06:23:07 Duration: 10s288ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-08 06:23:55 Duration: 9s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 47s125ms 6s296ms 14s379ms 9s425ms alter table gtp_obj_composition 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);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 08 1 6s638ms 6s638ms Oct 07 08 1 14s379ms 14s379ms Oct 08 08 1 10s721ms 10s721ms Oct 09 08 1 6s296ms 6s296ms Oct 10 08 1 9s90ms 9s90ms [ User: a3dsupervisor - Total duration: 47s125ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s125ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition 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-07 06:27:55 Duration: 14s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:58 Duration: 10s721ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:05 Duration: 9s90ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 43s566ms 7s281ms 11s579ms 8s713ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 08 1 8s203ms 8s203ms Oct 07 08 1 8s221ms 8s221ms Oct 08 08 1 8s280ms 8s280ms Oct 09 08 1 11s579ms 11s579ms Oct 10 08 1 7s281ms 7s281ms [ User: a3dsupervisor - Total duration: 43s566ms - Times executed: 5 ]
[ Application: psql - Total duration: 43s566ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-09 06:26:11 Duration: 11s579ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-08 06:23:35 Duration: 8s280ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-07 06:26:27 Duration: 8s221ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 31s841ms 5s424ms 7s491ms 6s368ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 08 1 5s916ms 5s916ms Oct 07 08 1 5s424ms 5s424ms Oct 08 08 1 5s707ms 5s707ms Oct 09 08 1 7s301ms 7s301ms Oct 10 08 1 7s491ms 7s491ms [ User: a3dsupervisor - Total duration: 31s841ms - Times executed: 5 ]
[ Application: psql - Total duration: 31s841ms - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-10 06:23:37 Duration: 7s491ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-09 06:27:30 Duration: 7s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-06 06:23:58 Duration: 5s916ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 4 2m3s 28s948ms 32s620ms 30s871ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 22 1 28s948ms 28s948ms Oct 07 22 1 32s620ms 32s620ms Oct 08 22 1 31s842ms 31s842ms Oct 09 22 1 30s73ms 30s73ms [ User: a3dsupervisor - Total duration: 2m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m3s - Times executed: 4 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-07 20:33:54 Duration: 32s620ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-08 20:33:29 Duration: 31s842ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-09 20:33:14 Duration: 30s73ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 4 1m37s 16s798ms 27s786ms 24s383ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 08 1 27s786ms 27s786ms Oct 07 08 1 27s707ms 27s707ms Oct 08 08 1 25s242ms 25s242ms Oct 09 08 1 16s798ms 16s798ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 4 ]
[ Application: psql - Total duration: 1m37s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-06 06:22:54 Duration: 27s786ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-07 06:26:01 Duration: 27s707ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-08 06:23:10 Duration: 25s242ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 4 1m4s 13s190ms 18s10ms 16s119ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 08 1 13s190ms 13s190ms Oct 07 08 1 18s10ms 18s10ms Oct 08 08 1 17s9ms 17s9ms Oct 09 08 1 16s267ms 16s267ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: psql - Total duration: 1m4s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-07 06:26:19 Duration: 18s10ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-08 06:23:27 Duration: 17s9ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-09 06:25:59 Duration: 16s267ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 4 1m1s 5s593ms 29s969ms 15s251ms 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) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 08 1 5s593ms 5s593ms Oct 07 08 1 8s583ms 8s583ms Oct 08 08 1 16s859ms 16s859ms Oct 09 08 1 29s969ms 29s969ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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) TO stdout;
Date: 2025-10-09 06:43:54 Duration: 29s969ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:16 Duration: 16s859ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:18 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 47s324ms 55s498ms 50s849ms 5 4m14s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 06 08 1 55s498ms 55s498ms Oct 07 08 1 52s633ms 52s633ms Oct 08 08 1 47s324ms 47s324ms Oct 09 08 1 47s653ms 47s653ms Oct 10 08 1 51s136ms 51s136ms [ User: a3dsupervisor - Total duration: 4m14s - Times executed: 5 ]
[ Application: psql - Total duration: 4m14s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-06 06:26:15 Duration: 55s498ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-07 06:29:25 Duration: 52s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-10 06:25:41 Duration: 51s136ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 15s526ms 1m48s 49s93ms 5 4m5s 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) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 06 08 1 15s526ms 15s526ms Oct 07 08 1 1m48s 1m48s Oct 08 08 1 40s341ms 40s341ms Oct 09 08 1 1m5s 1m5s Oct 10 08 1 15s860ms 15s860ms [ User: a3dsupervisor - Total duration: 4m5s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4m5s - 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) TO stdout;
Date: 2025-10-07 06:42:23 Duration: 1m48s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-09 06:40:34 Duration: 1m5s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:37:45 Duration: 40s341ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 33s313ms 36s567ms 34s433ms 5 2m52s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 06 08 1 34s265ms 34s265ms Oct 07 08 1 34s31ms 34s31ms Oct 08 08 1 33s313ms 33s313ms Oct 09 08 1 33s991ms 33s991ms Oct 10 08 1 36s567ms 36s567ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: psql - Total duration: 2m52s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-10 06:26:32 Duration: 36s567ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-06 06:26:56 Duration: 34s265ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-07 06:30:07 Duration: 34s31ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 9s692ms 1m24s 33s911ms 5 2m49s 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 06 08 1 9s888ms 9s888ms Oct 07 08 1 47s840ms 47s840ms Oct 08 08 1 17s257ms 17s257ms Oct 09 08 1 1m24s 1m24s Oct 10 08 1 9s692ms 9s692ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m49s - 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) TO stdout;
Date: 2025-10-09 06:41:59 Duration: 1m24s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:11 Duration: 47s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:03 Duration: 17s257ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 28s948ms 32s620ms 30s871ms 4 2m3s select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 06 22 1 28s948ms 28s948ms Oct 07 22 1 32s620ms 32s620ms Oct 08 22 1 31s842ms 31s842ms Oct 09 22 1 30s73ms 30s73ms [ User: a3dsupervisor - Total duration: 2m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m3s - Times executed: 4 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-07 20:33:54 Duration: 32s620ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-08 20:33:29 Duration: 31s842ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-09 20:33:14 Duration: 30s73ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 8s963ms 43s155ms 26s144ms 5 2m10s 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 06 08 1 9s203ms 9s203ms Oct 07 08 1 32s605ms 32s605ms Oct 08 08 1 36s792ms 36s792ms Oct 09 08 1 43s155ms 43s155ms Oct 10 08 1 8s963ms 8s963ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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) TO stdout;
Date: 2025-10-09 06:42:42 Duration: 43s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:38:40 Duration: 36s792ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:43:44 Duration: 32s605ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 16s798ms 27s786ms 24s383ms 4 1m37s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 06 08 1 27s786ms 27s786ms Oct 07 08 1 27s707ms 27s707ms Oct 08 08 1 25s242ms 25s242ms Oct 09 08 1 16s798ms 16s798ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 4 ]
[ Application: psql - Total duration: 1m37s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-06 06:22:54 Duration: 27s786ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-07 06:26:01 Duration: 27s707ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-08 06:23:10 Duration: 25s242ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 7s504ms 41s828ms 20s700ms 5 1m43s 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) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 06 08 1 8s71ms 8s71ms Oct 07 08 1 26s111ms 26s111ms Oct 08 08 1 19s987ms 19s987ms Oct 09 08 1 41s828ms 41s828ms Oct 10 08 1 7s504ms 7s504ms [ User: a3dsupervisor - Total duration: 1m43s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m43s - 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) TO stdout;
Date: 2025-10-09 06:43:24 Duration: 41s828ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:10 Duration: 26s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:00 Duration: 19s987ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 13s850ms 23s888ms 18s757ms 5 1m33s alter table 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 #9
Day Hour Count Duration Avg duration Oct 06 08 1 23s888ms 23s888ms Oct 07 08 1 19s6ms 19s6ms Oct 08 08 1 19s548ms 19s548ms Oct 09 08 1 17s494ms 17s494ms Oct 10 08 1 13s850ms 13s850ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 5 ]
[ Application: psql - Total duration: 1m33s - Times executed: 5 ]
-
ALTER TABLE 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-06 06:24:21 Duration: 23s888ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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 06:24:39 Duration: 19s548ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE 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-07 06:27:35 Duration: 19s6ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 14s647ms 21s204ms 17s422ms 5 1m27s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 06 08 1 14s647ms 14s647ms Oct 07 08 1 21s204ms 21s204ms Oct 08 08 1 15s445ms 15s445ms Oct 09 08 1 16s198ms 16s198ms Oct 10 08 1 19s617ms 19s617ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-07 06:27:10 Duration: 21s204ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-10 06:23:29 Duration: 19s617ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-09 06:27:19 Duration: 16s198ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 13s190ms 18s10ms 16s119ms 4 1m4s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 06 08 1 13s190ms 13s190ms Oct 07 08 1 18s10ms 18s10ms Oct 08 08 1 17s9ms 17s9ms Oct 09 08 1 16s267ms 16s267ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: psql - Total duration: 1m4s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-07 06:26:19 Duration: 18s10ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-08 06:23:27 Duration: 17s9ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-09 06:25:59 Duration: 16s267ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5s593ms 29s969ms 15s251ms 4 1m1s 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) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 06 08 1 5s593ms 5s593ms Oct 07 08 1 8s583ms 8s583ms Oct 08 08 1 16s859ms 16s859ms Oct 09 08 1 29s969ms 29s969ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m1s - Times executed: 4 ]
-
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) TO stdout;
Date: 2025-10-09 06:43:54 Duration: 29s969ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-08 06:39:16 Duration: 16s859ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-10-07 06:44:18 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 12s86ms 18s117ms 14s931ms 5 1m14s create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 06 08 1 13s103ms 13s103ms Oct 07 08 1 18s117ms 18s117ms Oct 08 08 1 15s364ms 15s364ms Oct 09 08 1 12s86ms 12s86ms Oct 10 08 1 15s986ms 15s986ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 5 ]
[ Application: psql - Total duration: 1m14s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-07 06:25:12 Duration: 18s117ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-10 06:21:05 Duration: 15s986ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-08 06:22:23 Duration: 15s364ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 11s763ms 17s897ms 14s619ms 5 1m13s create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 06 08 1 11s763ms 11s763ms Oct 07 08 1 13s456ms 13s456ms Oct 08 08 1 14s556ms 14s556ms Oct 09 08 1 17s897ms 17s897ms Oct 10 08 1 15s425ms 15s425ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-09 06:23:48 Duration: 17s897ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-10 06:19:24 Duration: 15s425ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-08 06:20:13 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 8s396ms 10s350ms 9s428ms 5 47s142ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 06 08 1 8s396ms 8s396ms Oct 07 08 1 9s1ms 9s1ms Oct 08 08 1 9s105ms 9s105ms Oct 09 08 1 10s350ms 10s350ms Oct 10 08 1 10s288ms 10s288ms [ User: a3dsupervisor - Total duration: 47s142ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s142ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-09 06:26:56 Duration: 10s350ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-10 06:23:07 Duration: 10s288ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-08 06:23:55 Duration: 9s105ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 6s296ms 14s379ms 9s425ms 5 47s125ms alter table gtp_obj_composition 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);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 06 08 1 6s638ms 6s638ms Oct 07 08 1 14s379ms 14s379ms Oct 08 08 1 10s721ms 10s721ms Oct 09 08 1 6s296ms 6s296ms Oct 10 08 1 9s90ms 9s90ms [ User: a3dsupervisor - Total duration: 47s125ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s125ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition 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-07 06:27:55 Duration: 14s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:58 Duration: 10s721ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition 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 06:24:05 Duration: 9s90ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 7s281ms 11s579ms 8s713ms 5 43s566ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 06 08 1 8s203ms 8s203ms Oct 07 08 1 8s221ms 8s221ms Oct 08 08 1 8s280ms 8s280ms Oct 09 08 1 11s579ms 11s579ms Oct 10 08 1 7s281ms 7s281ms [ User: a3dsupervisor - Total duration: 43s566ms - Times executed: 5 ]
[ Application: psql - Total duration: 43s566ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-09 06:26:11 Duration: 11s579ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-08 06:23:35 Duration: 8s280ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-07 06:26:27 Duration: 8s221ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 6s728ms 9s756ms 7s999ms 4 31s998ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 06 08 1 6s831ms 6s831ms Oct 07 08 1 9s756ms 9s756ms Oct 08 08 1 8s682ms 8s682ms Oct 09 08 1 6s728ms 6s728ms [ User: a3dsupervisor - Total duration: 31s998ms - Times executed: 4 ]
[ Application: psql - Total duration: 31s998ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-07 06:24:54 Duration: 9s756ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-08 06:22:08 Duration: 8s682ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-06 06:21:41 Duration: 6s831ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5s577ms 10s433ms 7s380ms 7 51s666ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 06 08 1 5s577ms 5s577ms Oct 07 08 1 5s831ms 5s831ms Oct 08 08 1 7s490ms 7s490ms Oct 09 08 1 8s580ms 8s580ms 13 1 6s373ms 6s373ms Oct 10 08 1 7s378ms 7s378ms 10 1 10s433ms 10s433ms [ User: a3dsupervisor - Total duration: 51s666ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 51s666ms - Times executed: 7 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-10 08:25:27 Duration: 10s433ms Database: reftk 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 06:33:47 Duration: 8s580ms Database: reftk 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-08 06:31:32 Duration: 7s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s1ms 1m20s 7s146ms 64 7m37s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 06 08 8 59s981ms 7s497ms 09 2 12s625ms 6s312ms 20 2 10s60ms 5s30ms 21 7 40s650ms 5s807ms Oct 07 09 4 25s996ms 6s499ms 20 2 11s370ms 5s685ms 21 4 21s291ms 5s322ms Oct 08 08 4 20s833ms 5s208ms 20 1 5s120ms 5s120ms 21 3 17s422ms 5s807ms Oct 09 08 6 40s67ms 6s677ms 20 8 46s665ms 5s833ms Oct 10 08 8 43s266ms 5s408ms 09 4 21s360ms 5s340ms 13 1 1m20s 1m20s [ User: a3dsupervisor - Total duration: 7m37s - Times executed: 64 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m37s - Times executed: 64 ]
-
COMMIT;
Date: 2025-10-10 11:23:01 Duration: 1m20s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-06 06:49:56 Duration: 9s156ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-09 06:48:51 Duration: 8s391ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 11s463ms 1 11s463ms 11s463ms 11s463ms select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 10 09 1 11s463ms 11s463ms [ User: a3dsupervisor - Total duration: 5s82ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s82ms - Times executed: 1 ]
-
select glmp1_0.LOG_METRIC_NUM_ID, glmp1_0.LOG_DATE, glmp1_0.METRIC_AVERAGE_VALUE, glmp1_0.METRIC_MAX_VALUE, glmp1_0.METRIC_MIN_VALUE, glmp1_0.METRIC_NAME, glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between $1 and $2 and (glmp1_0.METRIC_NAME is null or glmp1_0.METRIC_NAME = $3);
Date: 2025-10-10 07:00:25 Duration: 11s463ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 33,828 Log entries
Events distribution
Key values
- 0 PANIC entries
- 2 FATAL entries
- 10671 ERROR entries
- 81 WARNING entries
Most Frequent Errors/Events
Key values
- 10,549 Max number of times the same event was reported
- 10,754 Total events found
Rank Times reported Error 1 10,549 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 08 133 09 608 10 44 11 716 12 96 13 658 14 214 15 5 18 1 Oct 07 08 94 09 244 10 232 11 291 12 314 13 405 14 216 15 5 Oct 08 08 93 09 240 10 253 11 182 12 338 13 824 14 21 15 1 16 1 Oct 09 08 94 09 187 13 75 14 68 15 292 16 205 17 287 18 760 Oct 10 08 91 09 240 10 467 11 503 12 87 13 714 14 236 15 14 2 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 06 08 16 Oct 07 08 16 Oct 08 08 16 Oct 09 08 16 Oct 10 08 16 3 64 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 06 13 3 19 8 Oct 07 19 3 Oct 08 19 3 Oct 09 08 2 09 1 19 5 Oct 10 10 3 12 13 14 16 17 7 4 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 13 1 Oct 10 08 1 5 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 #5
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 6 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 7 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 8 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 #8
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 9 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 #9
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 10 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 #10
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 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 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 12 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 #12
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 13 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 #13
Day Hour Count Oct 06 08 1 Oct 07 08 1 Oct 08 08 1 Oct 09 08 1 Oct 10 08 1 14 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 #14
Day Hour Count Oct 07 21 2 15 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (...)
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 07 08 1 Oct 08 08 1 16 2 ERROR: could not obtain lock on row in relation "..." SELECT toNotif.action_num_id FROM gtp_history_obj_action toNotif WHERE toNotif.action_num_id = FOR UPDATE NOWAIT
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 10 11 1 14 1 17 2 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 10 12 2 18 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (...)
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 08 08 1 19 1 WARNING: there is no transaction in progress
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 10 13 1