pgBadger-
Global information
- Generated on Mon Oct 6 09:36:24 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 6,788 log entries in 1m5s
- Log start from 2025-09-29 06:37:03 to 2025-10-03 07:07:14
-
Overview
Global Stats
- 61 Number of unique normalized queries
- 177 Number of queries
- 1h8m25s Total query duration
- 2025-09-29 06:45:01 First query
- 2025-10-03 07:07:58 Last query
- 1 queries/s at 2025-10-01 06:46:31 Query peak
- 1h8m25s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h8m25s Execute total duration
- 85 Number of events
- 4 Number of unique normalized events
- 80 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
- 976 Number temporary file
- 3.15 GiB Max size of temporary file
- 22.48 MiB Average size of temporary file
- 1,761 Total number of sessions
- 28 sessions at 2025-10-02 06:54:55 Session peak
- 3h31m53s Total duration of sessions
- 7s219ms Average duration of sessions
- 0 Average queries per session
- 2s331ms Average queries duration per session
- 4s888ms Average idle time per session
- 1,761 Total number of connections
- 11 connections/s at 2025-09-30 06:41:39 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-01 06:46:31 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-01 06:46:31 Date
Queries duration
Key values
- 1h8m25s 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) Sep 28 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 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 29 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 31 0ms 51s372ms 15s261ms 1m8s 1m22s 1m22s 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 Sep 30 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 35 0ms 2m15s 22s797ms 1m58s 2m56s 2m56s 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 01 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 29 0ms 43s478ms 12s403ms 49s582ms 1m6s 1m6s 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 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 16 0ms 41s632ms 17s445ms 56s588ms 1m7s 1m7s 07 33 0ms 6m4s 32s353ms 3m5s 6m4s 6m4s 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 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 24 0ms 4m2s 20s984ms 1m2s 4m9s 4m9s 07 9 0ms 5m15s 1m9s 5m23s 5m23s 5m23s 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 04 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) Sep 28 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 23 0 0 0ms 0ms 0ms 0ms Sep 29 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 6 21s808ms 0ms 43s192ms 51s372ms 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 Sep 30 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 51s546ms 39s948ms 1m58s 2m56s 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 01 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 3 7s17ms 0ms 5s375ms 15s677ms 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 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 6 14s422ms 0ms 32s173ms 54s359ms 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 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 8 38s672ms 1m14s 2m27s 2m27s 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 04 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) Sep 28 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 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 29 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 Sep 30 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 01 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 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 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 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 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 Sep 28 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% 23 0 0 0.00 0.00% Sep 29 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% Sep 30 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 01 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 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 04 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 Sep 28 00 1 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 23 2 0.00/s Sep 29 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 281 0.08/s 07 2 0.00/s 08 2 0.00/s 09 3 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 Sep 30 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 281 0.08/s 07 2 0.00/s 08 2 0.00/s 09 3 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 01 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 292 0.08/s 07 3 0.00/s 08 2 0.00/s 09 3 0.00/s 10 3 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 3 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 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 282 0.08/s 07 13 0.00/s 08 3 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 5 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 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 280 0.08/s 07 3 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 04 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 Sep 28 00 1 74ms 74ms 01 2 83ms 83ms 02 2 72ms 72ms 03 2 72ms 72ms 04 2 69ms 69ms 05 2 72ms 72ms 06 2 78ms 78ms 07 2 74ms 74ms 08 2 70ms 70ms 09 2 70ms 70ms 10 2 74ms 74ms 11 2 72ms 72ms 12 2 71ms 71ms 13 2 72ms 72ms 14 2 71ms 71ms 15 2 72ms 72ms 16 2 74ms 74ms 17 2 79ms 79ms 18 2 72ms 72ms 19 2 71ms 71ms 20 2 77ms 77ms 21 2 73ms 73ms 23 2 74ms 74ms Sep 29 00 2 70ms 70ms 01 2 70ms 70ms 02 2 69ms 69ms 03 2 71ms 71ms 04 2 76ms 76ms 05 2 72ms 72ms 06 280 2s650ms 960ms 07 3 8m36s 8m36s 08 2 292ms 292ms 09 3 287ms 287ms 10 2 234ms 234ms 11 2 119ms 119ms 12 2 91ms 91ms 13 2 78ms 78ms 14 2 78ms 78ms 15 2 121ms 121ms 16 2 193ms 193ms 17 2 102ms 102ms 18 2 73ms 73ms 19 2 134ms 134ms 20 2 108ms 108ms 21 2 72ms 72ms 22 2 71ms 71ms 23 2 77ms 77ms Sep 30 00 2 77ms 77ms 01 2 74ms 74ms 02 2 68ms 68ms 03 2 68ms 68ms 04 2 73ms 73ms 05 2 70ms 70ms 06 280 2s638ms 0ms 07 3 8m58s 8m58s 08 2 139ms 139ms 09 3 280ms 280ms 10 2 110ms 110ms 11 2 102ms 102ms 12 2 74ms 74ms 13 2 316ms 316ms 14 2 151ms 151ms 15 2 106ms 106ms 16 2 76ms 76ms 17 2 76ms 76ms 18 2 77ms 77ms 19 2 266ms 266ms 20 2 119ms 119ms 21 2 75ms 75ms 22 2 77ms 77ms 23 2 70ms 70ms Oct 01 00 2 74ms 74ms 01 2 79ms 79ms 02 2 70ms 70ms 03 2 72ms 72ms 04 2 72ms 72ms 05 2 75ms 75ms 06 291 3s117ms 1s881ms 07 4 5m46s 5m46s 08 2 88ms 88ms 09 3 152ms 152ms 10 3 135ms 135ms 11 2 76ms 76ms 12 2 81ms 81ms 13 2 74ms 74ms 14 2 77ms 77ms 15 3 129ms 129ms 16 2 78ms 78ms 17 2 76ms 76ms 18 2 81ms 81ms 19 2 224ms 224ms 20 2 105ms 105ms 21 2 71ms 71ms 22 2 72ms 72ms 23 2 72ms 72ms Oct 02 00 2 70ms 70ms 01 2 75ms 75ms 02 2 75ms 75ms 03 2 82ms 82ms 04 2 73ms 73ms 05 2 73ms 73ms 06 281 2s868ms 1s875ms 07 14 2m39s 1m23s 08 3 174ms 174ms 09 2 79ms 79ms 10 2 81ms 81ms 11 2 79ms 79ms 12 2 88ms 88ms 13 2 75ms 75ms 14 5 220ms 220ms 15 2 110ms 110ms 16 2 104ms 104ms 17 2 78ms 78ms 18 2 87ms 87ms 19 2 227ms 227ms 20 2 96ms 96ms 21 2 76ms 76ms 22 2 76ms 76ms 23 2 78ms 78ms Oct 03 00 2 75ms 75ms 01 2 75ms 75ms 02 2 77ms 77ms 03 2 74ms 74ms 04 2 77ms 77ms 05 2 76ms 76ms 06 279 3s265ms 1s460ms 07 4 7m29s 4m53s 08 2 98ms 98ms 09 2 77ms 77ms 10 2 76ms 76ms 11 2 79ms 79ms 12 2 78ms 78ms 13 2 82ms 82ms 14 2 76ms 76ms 15 2 77ms 77ms 16 2 76ms 76ms 17 2 78ms 78ms 18 2 151ms 151ms 19 2 174ms 174ms 20 2 119ms 119ms 21 2 76ms 76ms 22 2 96ms 96ms 23 2 73ms 73ms Oct 04 00 2 80ms 80ms 01 2 72ms 72ms 02 2 71ms 71ms 03 2 76ms 76ms 04 2 71ms 71ms 05 2 73ms 73ms 06 2 77ms 77ms 07 2 89ms 89ms 08 2 79ms 79ms 09 2 81ms 81ms 10 2 79ms 79ms 11 2 74ms 74ms 12 2 73ms 73ms 13 2 73ms 73ms 14 2 77ms 77ms 15 2 76ms 76ms 16 2 74ms 74ms 17 2 75ms 75ms 18 2 91ms 91ms 19 2 80ms 80ms 20 2 74ms 74ms 21 2 76ms 76ms 22 2 75ms 75ms 23 2 84ms 84ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-30 06:41:39 Date
Connections per database
Key values
- autotest Main Database
- 1,761 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,761 connections Total
-
Sessions
Simultaneous sessions
Key values
- 28 sessions Session Peak
- 2025-10-02 06:54:55 Date
Histogram of session times
Key values
- 1,591 0-500ms duration
Sessions per database
Key values
- autotest Main Database
- 1,761 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,761 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,761 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.02 MiB Temp Files size Peak
- 2025-09-30 06:47:41 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-01 06:41:33 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 28 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 23 0 0 0 Sep 29 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 4.31 GiB 22.30 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 Sep 30 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 196 4.30 GiB 22.46 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 01 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 197 4.29 GiB 22.32 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 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 150 3.13 GiB 21.37 MiB 07 42 1.11 GiB 27.12 MiB 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 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 193 4.28 GiB 22.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 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 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 Sep 28 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 23 0 0 Sep 29 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 Sep 30 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 01 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 02 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 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
- 0 Total read queries
- 166 Total write queries
Queries by database
Key values
- autotest Main database
- 177 Requests
- 1h8m25s (autotest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 177 Requests
User Request type Count Duration a3dsupervisor Total 177 1h8m25s copy to 31 16m ddl 135 30m18s others 11 22m7s Duration by user
Key values
- 1h8m25s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 177 1h8m25s copy to 31 16m ddl 135 30m18s others 11 22m7s Queries by host
Key values
- 10.3.0.4 Main host
- 177 Requests
- 1h8m25s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 146 Requests
- 52m25s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-03 06:52:26 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 98 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 6m4s VACUUM ANALYZE;[ Date: 2025-10-02 07:16:32 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 5m15s VACUUM ANALYSE;[ Date: 2025-10-03 07:02:03 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 4m2s VACUUM ANALYZE;[ Date: 2025-10-03 06:56:33 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 3m5s ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-02 07:05:21 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 2m27s 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-03 07:06:38 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 2m15s COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-30 06:57:04 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 2m13s VACUUM ANALYSE;[ Date: 2025-10-02 07:19:19 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 1m58s 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-09-30 06:53:25 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 1m8s VACUUM ANALYZE;[ Date: 2025-09-30 06:49:38 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 1m6s 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-03 07:03:58 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 51s372ms COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;[ Date: 2025-09-29 06:54:48 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 49s892ms 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-09-30 06:54:20 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 48s181ms VACUUM ANALYZE;[ Date: 2025-09-29 06:52:07 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 43s478ms VACUUM ANALYZE;[ Date: 2025-10-01 06:48:34 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 41s913ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-30 06:47:41 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 41s632ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-02 06:59:14 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 37s510ms CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);[ Date: 2025-10-02 06:58:08 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 36s587ms VACUUM ANALYSE;[ Date: 2025-09-30 06:50:21 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 36s1ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-03 06:51:34 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 35s702ms 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-09-29 06:55:33 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12m46s 5 43s478ms 6m4s 2m33s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 1 48s181ms 48s181ms Sep 30 08 1 1m8s 1m8s Oct 01 08 1 43s478ms 43s478ms Oct 02 09 1 6m4s 6m4s Oct 03 08 1 4m2s 4m2s [ User: a3dsupervisor - Total duration: 12m46s - Times executed: 5 ]
[ Application: psql - Total duration: 12m46s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-02 07:16:32 Duration: 6m4s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-03 06:56:33 Duration: 4m2s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 06:49:38 Duration: 1m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 9m13s 5 33s904ms 5m15s 1m50s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 08 1 34s240ms 34s240ms Sep 30 08 1 36s587ms 36s587ms Oct 01 08 1 33s904ms 33s904ms Oct 02 09 1 2m13s 2m13s Oct 03 09 1 5m15s 5m15s [ User: a3dsupervisor - Total duration: 9m13s - Times executed: 5 ]
[ Application: psql - Total duration: 9m13s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 07:02:03 Duration: 5m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 07:19:19 Duration: 2m13s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-30 06:50:21 Duration: 36s587ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5m33s 5 34s8ms 3m5s 1m6s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 08 1 35s680ms 35s680ms Sep 30 08 1 41s913ms 41s913ms Oct 01 08 1 34s8ms 34s8ms Oct 02 09 1 3m5s 3m5s Oct 03 08 1 36s1ms 36s1ms [ User: a3dsupervisor - Total duration: 5m33s - Times executed: 5 ]
[ Application: psql - Total duration: 5m33s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 07:05:21 Duration: 3m5s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:47:41 Duration: 41s913ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 06:51:34 Duration: 36s1ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5m28s 5 8s830ms 2m27s 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 08 1 18s949ms 18s949ms Sep 30 08 1 1m58s 1m58s Oct 01 08 1 8s830ms 8s830ms Oct 02 09 1 34s966ms 34s966ms Oct 03 09 1 2m27s 2m27s [ User: a3dsupervisor - Total duration: 5m28s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5m28s - 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-03 07:06:38 Duration: 2m27s Database: autotest 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-09-30 06:53:25 Duration: 1m58s Database: autotest 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-02 07:20:42 Duration: 34s966ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 3m53s 5 5s375ms 2m15s 46s701ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 08 1 51s372ms 51s372ms Sep 30 08 1 2m15s 2m15s Oct 01 08 1 5s375ms 5s375ms Oct 02 09 1 15s525ms 15s525ms Oct 03 09 1 25s844ms 25s844ms [ User: a3dsupervisor - Total duration: 3m53s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m53s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-30 06:57:04 Duration: 2m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-29 06:54:48 Duration: 51s372ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-03 07:07:40 Duration: 25s844ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 2m21s 5 21s771ms 41s632ms 28s269ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 08 1 28s506ms 28s506ms Sep 30 08 1 24s864ms 24s864ms Oct 01 08 1 21s771ms 21s771ms Oct 02 08 1 41s632ms 41s632ms Oct 03 08 1 24s571ms 24s571ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: psql - Total duration: 2m21s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-02 06:59:14 Duration: 41s632ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-29 06:48:35 Duration: 28s506ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 06:45:42 Duration: 24s864ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m58s 5 6s847ms 1m6s 23s780ms 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 #7
Day Hour Count Duration Avg duration Sep 29 08 1 7s413ms 7s413ms Sep 30 08 1 28s599ms 28s599ms Oct 01 08 1 6s847ms 6s847ms Oct 02 09 1 9s291ms 9s291ms Oct 03 09 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m58s - 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-03 07:03:58 Duration: 1m6s Database: autotest 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-09-30 06:51:14 Duration: 28s599ms Database: autotest 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-02 07:20:05 Duration: 9s291ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1m35s 4 9s925ms 49s892ms 23s781ms 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 #8
Day Hour Count Duration Avg duration Sep 29 08 1 9s925ms 9s925ms Sep 30 08 1 49s892ms 49s892ms Oct 02 09 1 10s102ms 10s102ms Oct 03 09 1 25s204ms 25s204ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-30 06:54:20 Duration: 49s892ms Database: autotest 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-03 07:07:05 Duration: 25s204ms Database: autotest 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-02 07:20:53 Duration: 10s102ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m31s 4 7s27ms 35s702ms 22s934ms 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 #9
Day Hour Count Duration Avg duration Sep 29 08 1 35s702ms 35s702ms Sep 30 08 1 34s191ms 34s191ms Oct 02 09 1 7s27ms 7s27ms Oct 03 09 1 14s815ms 14s815ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m31s - 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-09-29 06:55:33 Duration: 35s702ms Database: autotest 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-09-30 06:57:44 Duration: 34s191ms Database: autotest 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-03 07:07:58 Duration: 14s815ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 1m11s 5 13s703ms 15s239ms 14s340ms 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 #10
Day Hour Count Duration Avg duration Sep 29 08 1 13s703ms 13s703ms Sep 30 08 1 15s43ms 15s43ms Oct 01 08 1 15s239ms 15s239ms Oct 02 08 1 13s754ms 13s754ms Oct 03 08 1 13s963ms 13s963ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 5 ]
[ Application: psql - Total duration: 1m11s - 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-01 06:41:49 Duration: 15s239ms Database: autotest 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-09-30 06:42:17 Duration: 15s43ms Database: autotest 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-03 06:46:23 Duration: 13s963ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m9s 5 11s895ms 18s683ms 13s856ms 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 Sep 29 08 1 13s115ms 13s115ms Sep 30 08 1 12s133ms 12s133ms Oct 01 08 1 13s454ms 13s454ms Oct 02 09 1 18s683ms 18s683ms Oct 03 08 1 11s895ms 11s895ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 07:00:50 Duration: 18s683ms Database: autotest 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-01 06:45:59 Duration: 13s454ms Database: autotest 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-09-29 06:49:25 Duration: 13s115ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1m7s 5 6s656ms 23s425ms 13s586ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 08 1 11s307ms 11s307ms Sep 30 08 1 6s656ms 6s656ms Oct 01 08 1 11s993ms 11s993ms Oct 02 08 1 23s425ms 23s425ms Oct 03 08 1 14s551ms 14s551ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-02 06:57:05 Duration: 23s425ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-03 06:48:51 Duration: 14s551ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 06:44:22 Duration: 11s993ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 1m5s 5 11s375ms 15s144ms 13s194ms 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 Sep 29 08 1 15s144ms 15s144ms Sep 30 08 1 11s375ms 11s375ms Oct 01 08 1 12s321ms 12s321ms Oct 02 08 1 13s495ms 13s495ms Oct 03 08 1 13s633ms 13s633ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-09-29 06:47:05 Duration: 15s144ms Database: autotest 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-03 06:48:10 Duration: 13s633ms Database: autotest 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-02 06:55:45 Duration: 13s495ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1m5s 5 8s808ms 16s668ms 13s124ms 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 #14
Day Hour Count Duration Avg duration Sep 29 08 1 8s808ms 8s808ms Sep 30 08 1 11s599ms 11s599ms Oct 01 08 1 13s907ms 13s907ms Oct 02 09 1 14s640ms 14s640ms Oct 03 08 1 16s668ms 16s668ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-03 06:50:48 Duration: 16s668ms Database: autotest 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-02 07:01:24 Duration: 14s640ms Database: autotest 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-01 06:46:19 Duration: 13s907ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1m5s 4 7s945ms 37s510ms 16s366ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 08 1 7s945ms 7s945ms Sep 30 08 1 11s917ms 11s917ms Oct 02 08 1 37s510ms 37s510ms Oct 03 08 1 8s93ms 8s93ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 4 ]
[ Application: psql - Total duration: 1m5s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-02 06:58:08 Duration: 37s510ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-30 06:45:10 Duration: 11s917ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-03 06:49:08 Duration: 8s93ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 1m1s 5 9s723ms 16s605ms 12s329ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 08 1 9s723ms 9s723ms Sep 30 08 1 11s546ms 11s546ms Oct 01 08 1 16s605ms 16s605ms Oct 02 08 1 13s981ms 13s981ms Oct 03 08 1 9s787ms 9s787ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 5 ]
[ Application: psql - Total duration: 1m1s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-01 06:45:19 Duration: 16s605ms Database: autotest 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-02 06:59:28 Duration: 13s981ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 06:45:53 Duration: 11s546ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 1m 5 9s714ms 14s653ms 12s54ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 1 12s363ms 12s363ms Sep 30 08 1 11s762ms 11s762ms Oct 01 08 1 9s714ms 9s714ms Oct 02 08 1 11s780ms 11s780ms Oct 03 08 1 14s653ms 14s653ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 5 ]
[ Application: psql - Total duration: 1m - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 06:46:49 Duration: 14s653ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 06:45:28 Duration: 12s363ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-02 06:54:01 Duration: 11s780ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 59s180ms 5 8s43ms 20s794ms 11s836ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 08 1 8s69ms 8s69ms Sep 30 08 1 12s958ms 12s958ms Oct 01 08 1 9s314ms 9s314ms Oct 02 08 1 20s794ms 20s794ms Oct 03 08 1 8s43ms 8s43ms [ User: a3dsupervisor - Total duration: 59s180ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s180ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 06:56:21 Duration: 20s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:44:32 Duration: 12s958ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-01 06:43:59 Duration: 9s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 58s114ms 5 8s351ms 20s178ms 11s622ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 10s475ms 10s475ms Sep 30 08 1 8s378ms 8s378ms Oct 01 08 1 10s731ms 10s731ms Oct 02 08 1 20s178ms 20s178ms Oct 03 08 1 8s351ms 8s351ms [ User: a3dsupervisor - Total duration: 58s114ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s114ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-02 06:56:42 Duration: 20s178ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-01 06:44:10 Duration: 10s731ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 06:47:33 Duration: 10s475ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 56s800ms 5 8s846ms 15s615ms 11s360ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 8s846ms 8s846ms Sep 30 08 1 10s189ms 10s189ms Oct 01 08 1 11s755ms 11s755ms Oct 02 08 1 15s615ms 15s615ms Oct 03 08 1 10s393ms 10s393ms [ User: a3dsupervisor - Total duration: 56s800ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s800ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-02 06:56:01 Duration: 15s615ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-01 06:43:49 Duration: 11s755ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-03 06:48:21 Duration: 10s393ms Database: autotest 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 5 12m46s 43s478ms 6m4s 2m33s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 1 48s181ms 48s181ms Sep 30 08 1 1m8s 1m8s Oct 01 08 1 43s478ms 43s478ms Oct 02 09 1 6m4s 6m4s Oct 03 08 1 4m2s 4m2s [ User: a3dsupervisor - Total duration: 12m46s - Times executed: 5 ]
[ Application: psql - Total duration: 12m46s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-02 07:16:32 Duration: 6m4s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-03 06:56:33 Duration: 4m2s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 06:49:38 Duration: 1m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 5 9m13s 33s904ms 5m15s 1m50s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 08 1 34s240ms 34s240ms Sep 30 08 1 36s587ms 36s587ms Oct 01 08 1 33s904ms 33s904ms Oct 02 09 1 2m13s 2m13s Oct 03 09 1 5m15s 5m15s [ User: a3dsupervisor - Total duration: 9m13s - Times executed: 5 ]
[ Application: psql - Total duration: 9m13s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 07:02:03 Duration: 5m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 07:19:19 Duration: 2m13s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-30 06:50:21 Duration: 36s587ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 5m33s 34s8ms 3m5s 1m6s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 08 1 35s680ms 35s680ms Sep 30 08 1 41s913ms 41s913ms Oct 01 08 1 34s8ms 34s8ms Oct 02 09 1 3m5s 3m5s Oct 03 08 1 36s1ms 36s1ms [ User: a3dsupervisor - Total duration: 5m33s - Times executed: 5 ]
[ Application: psql - Total duration: 5m33s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 07:05:21 Duration: 3m5s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:47:41 Duration: 41s913ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 06:51:34 Duration: 36s1ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 5m28s 8s830ms 2m27s 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 08 1 18s949ms 18s949ms Sep 30 08 1 1m58s 1m58s Oct 01 08 1 8s830ms 8s830ms Oct 02 09 1 34s966ms 34s966ms Oct 03 09 1 2m27s 2m27s [ User: a3dsupervisor - Total duration: 5m28s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5m28s - 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-03 07:06:38 Duration: 2m27s Database: autotest 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-09-30 06:53:25 Duration: 1m58s Database: autotest 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-02 07:20:42 Duration: 34s966ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5 3m53s 5s375ms 2m15s 46s701ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 08 1 51s372ms 51s372ms Sep 30 08 1 2m15s 2m15s Oct 01 08 1 5s375ms 5s375ms Oct 02 09 1 15s525ms 15s525ms Oct 03 09 1 25s844ms 25s844ms [ User: a3dsupervisor - Total duration: 3m53s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m53s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-30 06:57:04 Duration: 2m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-29 06:54:48 Duration: 51s372ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-03 07:07:40 Duration: 25s844ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 5 2m21s 21s771ms 41s632ms 28s269ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 08 1 28s506ms 28s506ms Sep 30 08 1 24s864ms 24s864ms Oct 01 08 1 21s771ms 21s771ms Oct 02 08 1 41s632ms 41s632ms Oct 03 08 1 24s571ms 24s571ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: psql - Total duration: 2m21s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-02 06:59:14 Duration: 41s632ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-29 06:48:35 Duration: 28s506ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 06:45:42 Duration: 24s864ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 1m58s 6s847ms 1m6s 23s780ms 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 #7
Day Hour Count Duration Avg duration Sep 29 08 1 7s413ms 7s413ms Sep 30 08 1 28s599ms 28s599ms Oct 01 08 1 6s847ms 6s847ms Oct 02 09 1 9s291ms 9s291ms Oct 03 09 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m58s - 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-03 07:03:58 Duration: 1m6s Database: autotest 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-09-30 06:51:14 Duration: 28s599ms Database: autotest 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-02 07:20:05 Duration: 9s291ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 5 1m11s 13s703ms 15s239ms 14s340ms 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 #8
Day Hour Count Duration Avg duration Sep 29 08 1 13s703ms 13s703ms Sep 30 08 1 15s43ms 15s43ms Oct 01 08 1 15s239ms 15s239ms Oct 02 08 1 13s754ms 13s754ms Oct 03 08 1 13s963ms 13s963ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 5 ]
[ Application: psql - Total duration: 1m11s - 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-01 06:41:49 Duration: 15s239ms Database: autotest 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-09-30 06:42:17 Duration: 15s43ms Database: autotest 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-03 06:46:23 Duration: 13s963ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 5 1m9s 11s895ms 18s683ms 13s856ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 08 1 13s115ms 13s115ms Sep 30 08 1 12s133ms 12s133ms Oct 01 08 1 13s454ms 13s454ms Oct 02 09 1 18s683ms 18s683ms Oct 03 08 1 11s895ms 11s895ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 07:00:50 Duration: 18s683ms Database: autotest 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-01 06:45:59 Duration: 13s454ms Database: autotest 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-09-29 06:49:25 Duration: 13s115ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 1m7s 6s656ms 23s425ms 13s586ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 08 1 11s307ms 11s307ms Sep 30 08 1 6s656ms 6s656ms Oct 01 08 1 11s993ms 11s993ms Oct 02 08 1 23s425ms 23s425ms Oct 03 08 1 14s551ms 14s551ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-02 06:57:05 Duration: 23s425ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-03 06:48:51 Duration: 14s551ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 06:44:22 Duration: 11s993ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m5s 11s375ms 15s144ms 13s194ms 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 Sep 29 08 1 15s144ms 15s144ms Sep 30 08 1 11s375ms 11s375ms Oct 01 08 1 12s321ms 12s321ms Oct 02 08 1 13s495ms 13s495ms Oct 03 08 1 13s633ms 13s633ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-09-29 06:47:05 Duration: 15s144ms Database: autotest 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-03 06:48:10 Duration: 13s633ms Database: autotest 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-02 06:55:45 Duration: 13s495ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m5s 8s808ms 16s668ms 13s124ms 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 #12
Day Hour Count Duration Avg duration Sep 29 08 1 8s808ms 8s808ms Sep 30 08 1 11s599ms 11s599ms Oct 01 08 1 13s907ms 13s907ms Oct 02 09 1 14s640ms 14s640ms Oct 03 08 1 16s668ms 16s668ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-03 06:50:48 Duration: 16s668ms Database: autotest 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-02 07:01:24 Duration: 14s640ms Database: autotest 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-01 06:46:19 Duration: 13s907ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 1m1s 9s723ms 16s605ms 12s329ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 08 1 9s723ms 9s723ms Sep 30 08 1 11s546ms 11s546ms Oct 01 08 1 16s605ms 16s605ms Oct 02 08 1 13s981ms 13s981ms Oct 03 08 1 9s787ms 9s787ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 5 ]
[ Application: psql - Total duration: 1m1s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-01 06:45:19 Duration: 16s605ms Database: autotest 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-02 06:59:28 Duration: 13s981ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 06:45:53 Duration: 11s546ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 1m 9s714ms 14s653ms 12s54ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 29 08 1 12s363ms 12s363ms Sep 30 08 1 11s762ms 11s762ms Oct 01 08 1 9s714ms 9s714ms Oct 02 08 1 11s780ms 11s780ms Oct 03 08 1 14s653ms 14s653ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 5 ]
[ Application: psql - Total duration: 1m - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 06:46:49 Duration: 14s653ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 06:45:28 Duration: 12s363ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-02 06:54:01 Duration: 11s780ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 59s180ms 8s43ms 20s794ms 11s836ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 08 1 8s69ms 8s69ms Sep 30 08 1 12s958ms 12s958ms Oct 01 08 1 9s314ms 9s314ms Oct 02 08 1 20s794ms 20s794ms Oct 03 08 1 8s43ms 8s43ms [ User: a3dsupervisor - Total duration: 59s180ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s180ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 06:56:21 Duration: 20s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:44:32 Duration: 12s958ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-01 06:43:59 Duration: 9s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 58s114ms 8s351ms 20s178ms 11s622ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 08 1 10s475ms 10s475ms Sep 30 08 1 8s378ms 8s378ms Oct 01 08 1 10s731ms 10s731ms Oct 02 08 1 20s178ms 20s178ms Oct 03 08 1 8s351ms 8s351ms [ User: a3dsupervisor - Total duration: 58s114ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s114ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-02 06:56:42 Duration: 20s178ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-01 06:44:10 Duration: 10s731ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 06:47:33 Duration: 10s475ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 56s800ms 8s846ms 15s615ms 11s360ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 1 8s846ms 8s846ms Sep 30 08 1 10s189ms 10s189ms Oct 01 08 1 11s755ms 11s755ms Oct 02 08 1 15s615ms 15s615ms Oct 03 08 1 10s393ms 10s393ms [ User: a3dsupervisor - Total duration: 56s800ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s800ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-02 06:56:01 Duration: 15s615ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-01 06:43:49 Duration: 11s755ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-03 06:48:21 Duration: 10s393ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 55s120ms 6s994ms 21s862ms 11s24ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 08 1 6s994ms 6s994ms Sep 30 08 1 10s852ms 10s852ms Oct 01 08 1 7s839ms 7s839ms Oct 02 08 1 21s862ms 21s862ms Oct 03 08 1 7s571ms 7s571ms [ User: a3dsupervisor - Total duration: 55s120ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s120ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-10-02 06:57:27 Duration: 21s862ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-30 06:44:58 Duration: 10s852ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-10-01 06:44:29 Duration: 7s839ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 48s469ms 8s78ms 12s399ms 9s693ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 8s492ms 8s492ms Sep 30 08 1 12s399ms 12s399ms Oct 01 08 1 8s78ms 8s78ms Oct 02 08 1 10s88ms 10s88ms Oct 03 08 1 9s409ms 9s409ms [ User: a3dsupervisor - Total duration: 48s469ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s469ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-30 06:42:51 Duration: 12s399ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-02 06:54:11 Duration: 10s88ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-03 06:46:58 Duration: 9s409ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 40s157ms 6s783ms 9s528ms 8s31ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 9s528ms 9s528ms Sep 30 08 1 7s9ms 7s9ms Oct 01 08 1 7s372ms 7s372ms Oct 02 09 1 9s463ms 9s463ms Oct 03 08 1 6s783ms 6s783ms [ User: a3dsupervisor - Total duration: 40s157ms - Times executed: 5 ]
[ Application: psql - Total duration: 40s157ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-29 06:49:10 Duration: 9s528ms Database: autotest 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-02 07:00:27 Duration: 9s463ms Database: autotest 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-01 06:45:44 Duration: 7s372ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 43s478ms 6m4s 2m33s 5 12m46s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 1 48s181ms 48s181ms Sep 30 08 1 1m8s 1m8s Oct 01 08 1 43s478ms 43s478ms Oct 02 09 1 6m4s 6m4s Oct 03 08 1 4m2s 4m2s [ User: a3dsupervisor - Total duration: 12m46s - Times executed: 5 ]
[ Application: psql - Total duration: 12m46s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-02 07:16:32 Duration: 6m4s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-03 06:56:33 Duration: 4m2s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 06:49:38 Duration: 1m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 33s904ms 5m15s 1m50s 5 9m13s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 08 1 34s240ms 34s240ms Sep 30 08 1 36s587ms 36s587ms Oct 01 08 1 33s904ms 33s904ms Oct 02 09 1 2m13s 2m13s Oct 03 09 1 5m15s 5m15s [ User: a3dsupervisor - Total duration: 9m13s - Times executed: 5 ]
[ Application: psql - Total duration: 9m13s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 07:02:03 Duration: 5m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 07:19:19 Duration: 2m13s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-30 06:50:21 Duration: 36s587ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 34s8ms 3m5s 1m6s 5 5m33s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 08 1 35s680ms 35s680ms Sep 30 08 1 41s913ms 41s913ms Oct 01 08 1 34s8ms 34s8ms Oct 02 09 1 3m5s 3m5s Oct 03 08 1 36s1ms 36s1ms [ User: a3dsupervisor - Total duration: 5m33s - Times executed: 5 ]
[ Application: psql - Total duration: 5m33s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 07:05:21 Duration: 3m5s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:47:41 Duration: 41s913ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 06:51:34 Duration: 36s1ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 8s830ms 2m27s 1m5s 5 5m28s 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 Sep 29 08 1 18s949ms 18s949ms Sep 30 08 1 1m58s 1m58s Oct 01 08 1 8s830ms 8s830ms Oct 02 09 1 34s966ms 34s966ms Oct 03 09 1 2m27s 2m27s [ User: a3dsupervisor - Total duration: 5m28s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 5m28s - 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-03 07:06:38 Duration: 2m27s Database: autotest 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-09-30 06:53:25 Duration: 1m58s Database: autotest 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-02 07:20:42 Duration: 34s966ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5s375ms 2m15s 46s701ms 5 3m53s copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 08 1 51s372ms 51s372ms Sep 30 08 1 2m15s 2m15s Oct 01 08 1 5s375ms 5s375ms Oct 02 09 1 15s525ms 15s525ms Oct 03 09 1 25s844ms 25s844ms [ User: a3dsupervisor - Total duration: 3m53s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m53s - Times executed: 5 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-30 06:57:04 Duration: 2m15s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-29 06:54:48 Duration: 51s372ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-10-03 07:07:40 Duration: 25s844ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 21s771ms 41s632ms 28s269ms 5 2m21s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 08 1 28s506ms 28s506ms Sep 30 08 1 24s864ms 24s864ms Oct 01 08 1 21s771ms 21s771ms Oct 02 08 1 41s632ms 41s632ms Oct 03 08 1 24s571ms 24s571ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: psql - Total duration: 2m21s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-02 06:59:14 Duration: 41s632ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-29 06:48:35 Duration: 28s506ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 06:45:42 Duration: 24s864ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 9s925ms 49s892ms 23s781ms 4 1m35s 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 Sep 29 08 1 9s925ms 9s925ms Sep 30 08 1 49s892ms 49s892ms Oct 02 09 1 10s102ms 10s102ms Oct 03 09 1 25s204ms 25s204ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m35s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-30 06:54:20 Duration: 49s892ms Database: autotest 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-03 07:07:05 Duration: 25s204ms Database: autotest 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-02 07:20:53 Duration: 10s102ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 6s847ms 1m6s 23s780ms 5 1m58s 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 #8
Day Hour Count Duration Avg duration Sep 29 08 1 7s413ms 7s413ms Sep 30 08 1 28s599ms 28s599ms Oct 01 08 1 6s847ms 6s847ms Oct 02 09 1 9s291ms 9s291ms Oct 03 09 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 1m58s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m58s - 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-03 07:03:58 Duration: 1m6s Database: autotest 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-09-30 06:51:14 Duration: 28s599ms Database: autotest 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-02 07:20:05 Duration: 9s291ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 7s27ms 35s702ms 22s934ms 4 1m31s 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 #9
Day Hour Count Duration Avg duration Sep 29 08 1 35s702ms 35s702ms Sep 30 08 1 34s191ms 34s191ms Oct 02 09 1 7s27ms 7s27ms Oct 03 09 1 14s815ms 14s815ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m31s - 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-09-29 06:55:33 Duration: 35s702ms Database: autotest 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-09-30 06:57:44 Duration: 34s191ms Database: autotest 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-03 07:07:58 Duration: 14s815ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 7s945ms 37s510ms 16s366ms 4 1m5s create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 08 1 7s945ms 7s945ms Sep 30 08 1 11s917ms 11s917ms Oct 02 08 1 37s510ms 37s510ms Oct 03 08 1 8s93ms 8s93ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 4 ]
[ Application: psql - Total duration: 1m5s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-02 06:58:08 Duration: 37s510ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-30 06:45:10 Duration: 11s917ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-03 06:49:08 Duration: 8s93ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 13s703ms 15s239ms 14s340ms 5 1m11s 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 #11
Day Hour Count Duration Avg duration Sep 29 08 1 13s703ms 13s703ms Sep 30 08 1 15s43ms 15s43ms Oct 01 08 1 15s239ms 15s239ms Oct 02 08 1 13s754ms 13s754ms Oct 03 08 1 13s963ms 13s963ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 5 ]
[ Application: psql - Total duration: 1m11s - 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-01 06:41:49 Duration: 15s239ms Database: autotest 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-09-30 06:42:17 Duration: 15s43ms Database: autotest 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-03 06:46:23 Duration: 13s963ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 11s895ms 18s683ms 13s856ms 5 1m9s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 08 1 13s115ms 13s115ms Sep 30 08 1 12s133ms 12s133ms Oct 01 08 1 13s454ms 13s454ms Oct 02 09 1 18s683ms 18s683ms Oct 03 08 1 11s895ms 11s895ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 5 ]
[ Application: psql - Total duration: 1m9s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 07:00:50 Duration: 18s683ms Database: autotest 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-01 06:45:59 Duration: 13s454ms Database: autotest 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-09-29 06:49:25 Duration: 13s115ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 6s656ms 23s425ms 13s586ms 5 1m7s create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 08 1 11s307ms 11s307ms Sep 30 08 1 6s656ms 6s656ms Oct 01 08 1 11s993ms 11s993ms Oct 02 08 1 23s425ms 23s425ms Oct 03 08 1 14s551ms 14s551ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-02 06:57:05 Duration: 23s425ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-03 06:48:51 Duration: 14s551ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 06:44:22 Duration: 11s993ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 11s375ms 15s144ms 13s194ms 5 1m5s 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 #14
Day Hour Count Duration Avg duration Sep 29 08 1 15s144ms 15s144ms Sep 30 08 1 11s375ms 11s375ms Oct 01 08 1 12s321ms 12s321ms Oct 02 08 1 13s495ms 13s495ms Oct 03 08 1 13s633ms 13s633ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-09-29 06:47:05 Duration: 15s144ms Database: autotest 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-03 06:48:10 Duration: 13s633ms Database: autotest 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-02 06:55:45 Duration: 13s495ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 8s808ms 16s668ms 13s124ms 5 1m5s 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 #15
Day Hour Count Duration Avg duration Sep 29 08 1 8s808ms 8s808ms Sep 30 08 1 11s599ms 11s599ms Oct 01 08 1 13s907ms 13s907ms Oct 02 09 1 14s640ms 14s640ms Oct 03 08 1 16s668ms 16s668ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - 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-03 06:50:48 Duration: 16s668ms Database: autotest 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-02 07:01:24 Duration: 14s640ms Database: autotest 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-01 06:46:19 Duration: 13s907ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 9s723ms 16s605ms 12s329ms 5 1m1s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 08 1 9s723ms 9s723ms Sep 30 08 1 11s546ms 11s546ms Oct 01 08 1 16s605ms 16s605ms Oct 02 08 1 13s981ms 13s981ms Oct 03 08 1 9s787ms 9s787ms [ User: a3dsupervisor - Total duration: 1m1s - Times executed: 5 ]
[ Application: psql - Total duration: 1m1s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-01 06:45:19 Duration: 16s605ms Database: autotest 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-02 06:59:28 Duration: 13s981ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 06:45:53 Duration: 11s546ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 9s714ms 14s653ms 12s54ms 5 1m create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 1 12s363ms 12s363ms Sep 30 08 1 11s762ms 11s762ms Oct 01 08 1 9s714ms 9s714ms Oct 02 08 1 11s780ms 11s780ms Oct 03 08 1 14s653ms 14s653ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 5 ]
[ Application: psql - Total duration: 1m - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 06:46:49 Duration: 14s653ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 06:45:28 Duration: 12s363ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-02 06:54:01 Duration: 11s780ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 8s43ms 20s794ms 11s836ms 5 59s180ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 08 1 8s69ms 8s69ms Sep 30 08 1 12s958ms 12s958ms Oct 01 08 1 9s314ms 9s314ms Oct 02 08 1 20s794ms 20s794ms Oct 03 08 1 8s43ms 8s43ms [ User: a3dsupervisor - Total duration: 59s180ms - Times executed: 5 ]
[ Application: psql - Total duration: 59s180ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-02 06:56:21 Duration: 20s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 06:44:32 Duration: 12s958ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-01 06:43:59 Duration: 9s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 8s351ms 20s178ms 11s622ms 5 58s114ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 10s475ms 10s475ms Sep 30 08 1 8s378ms 8s378ms Oct 01 08 1 10s731ms 10s731ms Oct 02 08 1 20s178ms 20s178ms Oct 03 08 1 8s351ms 8s351ms [ User: a3dsupervisor - Total duration: 58s114ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s114ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-02 06:56:42 Duration: 20s178ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-01 06:44:10 Duration: 10s731ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 06:47:33 Duration: 10s475ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 8s846ms 15s615ms 11s360ms 5 56s800ms create index i_gtp_obj_rel_vt_ntt on gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 8s846ms 8s846ms Sep 30 08 1 10s189ms 10s189ms Oct 01 08 1 11s755ms 11s755ms Oct 02 08 1 15s615ms 15s615ms Oct 03 08 1 10s393ms 10s393ms [ User: a3dsupervisor - Total duration: 56s800ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s800ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-02 06:56:01 Duration: 15s615ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-01 06:43:49 Duration: 11s755ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-10-03 06:48:21 Duration: 10s393ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 6,526 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 5 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 80 Max number of times the same event was reported
- 85 Total events found
Rank Times reported Error 1 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 29 08 16 Sep 30 08 16 Oct 01 08 16 Oct 02 08 16 Oct 03 08 16 2 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_pe_consumption_10min_cp ON pe_consumption_10min (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 29 08 1 Sep 30 08 1 3 2 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 #3
Day Hour Count Sep 29 08 1 Sep 30 08 1 4 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_pe_consumption_hourly_cp ON pe_consumption_hourly (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 29 08 1