pgBadger-
Global information
- Generated on Mon Nov 17 09:35:18 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=15/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=15/h=23/m=00/PT1H.log
- Parsed 7,300 log entries in 59s
- Log start from 2025-11-10 07:46:02 to 2025-11-14 07:53:32
-
Overview
Global Stats
- 54 Number of unique normalized queries
- 163 Number of queries
- 1h10m50s Total query duration
- 2025-11-10 07:45:56 First query
- 2025-11-14 07:54:35 Last query
- 1 queries/s at 2025-11-10 08:21:29 Query peak
- 1h10m50s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h10m50s Execute total duration
- 69 Number of events
- 5 Number of unique normalized events
- 64 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
- 977 Number temporary file
- 3.04 GiB Max size of temporary file
- 21.69 MiB Average size of temporary file
- 1,952 Total number of sessions
- 147 sessions at 2025-11-09 19:47:23 Session peak
- 3h34m23s Total duration of sessions
- 6s589ms Average duration of sessions
- 0 Average queries per session
- 2s177ms Average queries duration per session
- 4s412ms Average idle time per session
- 1,951 Total number of connections
- 10 connections/s at 2025-11-10 07:44:47 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-10 08:21:29 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-10 08:21:29 Date
Queries duration
Key values
- 1h10m50s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 10 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 24 0ms 1m52s 15s718ms 55s377ms 1m52s 1m52s 08 11 0ms 15m8s 2m20s 3m11s 15m8s 15m8s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 11 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 28 0ms 1m18s 15s197ms 56s407ms 1m24s 1m24s 08 17 0ms 6m45s 45s800ms 2m23s 6m45s 6m45s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 12 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 26 0ms 53s405ms 12s967ms 1m4s 1m28s 1m28s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 13 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 29 0ms 1m14s 14s196ms 58s147ms 1m14s 1m14s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 14 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 28 0ms 1m4s 13s433ms 46s921ms 1m4s 1m4s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 15 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 10 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 10 1m3s 1m27s 2m48s 3m11s 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 11 00 0 0 0ms 0ms 0ms 0ms 01 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 6 14s666ms 0ms 26s184ms 1m1s 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 12 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 3 6s345ms 0ms 0ms 19s37ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 13 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 3 6s518ms 0ms 0ms 19s554ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 14 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 4 7s608ms 0ms 0ms 30s432ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 15 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 09 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 10 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 12 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 09 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 10 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 11 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 12 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 13 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 09 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 10 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 243 0.07/s 08 4 0.00/s 09 9 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 11 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 285 0.08/s 08 12 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 12 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 294 0.08/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 4 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 13 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 294 0.08/s 08 3 0.00/s 09 3 0.00/s 10 4 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 4 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 14 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 295 0.08/s 08 6 0.00/s 09 6 0.00/s 10 14 0.00/s 11 4 0.00/s 12 4 0.00/s 13 9 0.00/s 14 4 0.00/s 15 10 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 15 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 2 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 09 00 3 75ms 75ms 01 3 78ms 78ms 02 3 76ms 76ms 03 3 72ms 72ms 04 3 75ms 75ms 05 3 70ms 70ms 06 3 73ms 73ms 07 3 70ms 70ms 08 3 74ms 74ms 09 3 76ms 76ms 10 3 71ms 71ms 11 3 69ms 69ms 12 3 72ms 72ms 13 3 74ms 74ms 14 3 75ms 75ms 15 3 72ms 72ms 16 3 72ms 72ms 17 3 74ms 74ms 18 3 75ms 75ms 19 3 77ms 77ms 20 3 68ms 68ms 21 3 77ms 77ms 22 3 74ms 74ms 23 3 71ms 71ms Nov 10 00 3 70ms 70ms 01 3 71ms 71ms 02 3 78ms 78ms 03 3 70ms 70ms 04 3 70ms 70ms 05 3 72ms 72ms 06 3 71ms 71ms 07 243 3s344ms 1s791ms 08 5 9m1s 3m53s 09 9 233ms 233ms 10 3 75ms 75ms 11 3 76ms 76ms 12 3 75ms 75ms 13 3 84ms 84ms 14 3 70ms 70ms 15 3 71ms 71ms 16 3 75ms 75ms 17 3 70ms 70ms 18 3 84ms 84ms 19 3 222ms 222ms 20 3 108ms 108ms 21 3 78ms 78ms 22 3 72ms 72ms 23 3 72ms 72ms Nov 11 00 3 73ms 73ms 01 3 67ms 67ms 02 3 70ms 70ms 03 3 79ms 79ms 04 3 75ms 75ms 05 3 67ms 67ms 06 3 69ms 69ms 07 284 3s623ms 2s125ms 08 13 2m35s 1m35s 09 3 77ms 77ms 10 3 76ms 76ms 11 3 68ms 68ms 12 3 70ms 70ms 13 3 69ms 69ms 14 3 73ms 73ms 15 3 75ms 75ms 16 3 70ms 70ms 17 3 67ms 67ms 18 3 76ms 76ms 19 3 74ms 74ms 20 3 127ms 127ms 21 3 71ms 71ms 22 3 79ms 79ms 23 3 80ms 80ms Nov 12 00 3 99ms 99ms 01 3 70ms 70ms 02 3 75ms 75ms 03 3 67ms 67ms 04 3 69ms 69ms 05 3 69ms 69ms 06 3 75ms 75ms 07 293 2s958ms 1s808ms 08 4 6m 6m 09 3 71ms 71ms 10 3 71ms 71ms 11 3 69ms 69ms 12 3 242ms 242ms 13 4 180ms 180ms 14 3 74ms 74ms 15 3 70ms 70ms 16 3 72ms 72ms 17 3 96ms 96ms 18 3 86ms 86ms 19 3 71ms 71ms 20 3 114ms 114ms 21 3 88ms 88ms 22 3 71ms 71ms 23 3 68ms 68ms Nov 13 00 3 68ms 68ms 01 3 68ms 68ms 02 3 65ms 65ms 03 3 70ms 70ms 04 3 74ms 74ms 05 3 67ms 67ms 06 3 79ms 79ms 07 293 3s181ms 1s776ms 08 4 5m51s 5m51s 09 3 89ms 89ms 10 4 194ms 194ms 11 3 76ms 76ms 12 3 73ms 73ms 13 3 108ms 108ms 14 3 100ms 100ms 15 3 126ms 126ms 16 4 159ms 159ms 17 3 68ms 68ms 18 3 71ms 71ms 19 3 100ms 100ms 20 3 106ms 106ms 21 3 79ms 79ms 22 3 73ms 73ms 23 3 72ms 72ms Nov 14 00 3 67ms 67ms 01 3 71ms 71ms 02 3 71ms 71ms 03 3 68ms 68ms 04 3 70ms 70ms 05 3 73ms 73ms 06 3 69ms 69ms 07 294 3s93ms 1s813ms 08 7 1m38s 1m38s 09 6 184ms 184ms 10 14 254ms 254ms 11 4 134ms 134ms 12 4 133ms 133ms 13 9 215ms 215ms 14 4 123ms 123ms 15 10 251ms 251ms 16 3 81ms 81ms 17 3 88ms 88ms 18 3 85ms 85ms 19 3 69ms 69ms 20 3 74ms 74ms 21 3 72ms 72ms 22 3 78ms 78ms 23 3 75ms 75ms Nov 15 00 3 73ms 73ms 01 3 74ms 74ms 02 3 67ms 67ms 03 3 69ms 69ms 04 3 68ms 68ms 05 3 69ms 69ms 06 3 71ms 71ms 07 3 72ms 72ms 08 3 71ms 71ms 09 3 72ms 72ms 10 3 71ms 71ms 11 3 68ms 68ms 12 3 71ms 71ms 13 3 80ms 80ms 14 3 71ms 71ms 15 3 75ms 75ms 16 3 86ms 86ms 17 3 75ms 75ms 18 2 70ms 70ms 19 3 75ms 75ms 20 3 69ms 69ms 21 3 70ms 70ms 22 3 70ms 70ms 23 3 69ms 69ms -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2025-11-10 07:44:47 Date
Connections per database
Key values
- autotest Main Database
- 1,951 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,951 connections Total
-
Sessions
Simultaneous sessions
Key values
- 147 sessions Session Peak
- 2025-11-09 19:47:23 Date
Histogram of session times
Key values
- 1,784 0-500ms duration
Sessions per database
Key values
- autotest Main Database
- 1,952 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,952 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,952 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 387.03 MiB Temp Files size Peak
- 2025-11-13 07:48:04 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-11-12 07:49:35 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 09 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 195 4.18 GiB 21.94 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 Nov 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 184 4.03 GiB 22.44 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 Nov 12 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 202 4.17 GiB 21.14 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 Nov 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 197 4.16 GiB 21.60 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 Nov 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 199 4.16 GiB 21.38 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 Nov 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 09 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 10 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 12 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 14 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 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
- 153 Total write queries
Queries by database
Key values
- autotest Main database
- 163 Requests
- 1h10m50s (autotest)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 163 Requests
User Request type Count Duration a3dsupervisor Total 163 1h10m50s copy to 26 13m12s ddl 127 26m26s others 10 31m11s Duration by user
Key values
- 1h10m50s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 163 1h10m50s copy to 26 13m12s ddl 127 26m26s others 10 31m11s Queries by host
Key values
- 10.3.0.4 Main host
- 163 Requests
- 1h10m50s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 137 Requests
- 57m37s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-15 06:29:00 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 83 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 15m8s VACUUM ANALYSE;[ Date: 2025-11-10 08:09:28 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 6m45s VACUUM ANALYZE;[ Date: 2025-11-11 08:09:56 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 3m1s 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-11-10 08:14:04 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 2m48s 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-11-10 08:17:11 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 2m23s VACUUM ANALYSE;[ Date: 2025-11-11 08:12:26 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 1m52s VACUUM ANALYZE;[ Date: 2025-11-10 07:54:13 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 1m27s 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-11-10 08:18:44 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 1m18s 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-11-11 07:56:14 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 1m14s VACUUM ANALYZE;[ Date: 2025-11-13 07:50:10 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 1m7s 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-11-10 08:20:29 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 1m4s VACUUM ANALYZE;[ Date: 2025-11-14 07:52:47 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 53s405ms VACUUM ANALYZE;[ Date: 2025-11-12 07:55:00 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 48s847ms 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-11-10 08:21:29 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 41s930ms 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-11-13 07:48:06 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 39s855ms 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-11-10 07:51:06 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 39s649ms 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-11-12 07:53:23 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 38s486ms VACUUM ANALYSE;[ Date: 2025-11-13 07:51:00 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 38s150ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-11-11 07:49:27 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 36s346ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_obj_p FOREIGN KEY (obj_num_id_p) REFERENCES gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-11 08:01:30 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 35s921ms VACUUM ANALYSE;[ Date: 2025-11-14 07:53:32 - Database: autotest - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 19m21s 5 35s379ms 15m8s 3m52s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 09 1 15m8s 15m8s Nov 11 09 1 2m23s 2m23s Nov 12 08 1 35s379ms 35s379ms Nov 13 08 1 38s486ms 38s486ms Nov 14 08 1 35s921ms 35s921ms [ User: a3dsupervisor - Total duration: 19m21s - Times executed: 5 ]
[ Application: psql - Total duration: 19m21s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-10 08:09:28 Duration: 15m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-11 08:12:26 Duration: 2m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 07:51:00 Duration: 38s486ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 11m49s 5 53s405ms 6m45s 2m21s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 08 1 1m52s 1m52s Nov 11 09 1 6m45s 6m45s Nov 12 08 1 53s405ms 53s405ms Nov 13 08 1 1m14s 1m14s Nov 14 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 11m49s - Times executed: 5 ]
[ Application: psql - Total duration: 11m49s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-11 08:09:56 Duration: 6m45s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-10 07:54:13 Duration: 1m52s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-13 07:50:10 Duration: 1m14s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m49s 5 29s488ms 1m18s 45s922ms 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 Nov 10 08 1 39s855ms 39s855ms Nov 11 08 1 1m18s 1m18s Nov 12 08 1 39s649ms 39s649ms Nov 13 08 1 41s930ms 41s930ms Nov 14 08 1 29s488ms 29s488ms [ User: a3dsupervisor - Total duration: 3m49s - Times executed: 5 ]
[ Application: psql - Total duration: 3m49s - 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-11-11 07:56:14 Duration: 1m18s 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-11-13 07:48:06 Duration: 41s930ms 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-11-10 07:51:06 Duration: 39s855ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 3m38s 5 6s230ms 2m48s 43s799ms 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 Nov 10 09 1 2m48s 2m48s Nov 11 09 1 29s461ms 29s461ms Nov 12 08 1 7s626ms 7s626ms Nov 13 08 1 6s230ms 6s230ms Nov 14 08 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - 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-11-10 08:17:11 Duration: 2m48s 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-11-11 08:13:37 Duration: 29s461ms 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-11-12 07:56:19 Duration: 7s626ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 3m34s 5 5s882ms 3m1s 42s869ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 10 09 1 3m1s 3m1s Nov 11 09 1 14s478ms 14s478ms Nov 12 08 1 6s303ms 6s303ms Nov 13 08 1 5s882ms 5s882ms Nov 14 08 1 6s607ms 6s607ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m34s - 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-11-10 08:14:04 Duration: 3m1s 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-11-11 08:13:04 Duration: 14s478ms 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-11-14 07:54:06 Duration: 6s607ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 2m6s 5 13s109ms 38s150ms 25s365ms 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 #6
Day Hour Count Duration Avg duration Nov 10 08 1 28s447ms 28s447ms Nov 11 08 1 38s150ms 38s150ms Nov 12 08 1 15s783ms 15s783ms Nov 13 08 1 13s109ms 13s109ms Nov 14 08 1 31s339ms 31s339ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - 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-11-11 07:49:27 Duration: 38s150ms 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-11-14 07:45:54 Duration: 31s339ms 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-11-10 07:45:56 Duration: 28s447ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m56s 4 7s441ms 1m27s 29s7ms 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 Nov 10 09 1 1m27s 1m27s Nov 11 09 1 9s827ms 9s827ms Nov 13 08 1 7s441ms 7s441ms Nov 14 08 1 11s564ms 11s564ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m56s - 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-11-10 08:18:44 Duration: 1m27s 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-11-14 07:54:26 Duration: 11s564ms 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-11-11 08:13:47 Duration: 9s827ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1m37s 4 5s107ms 1m7s 24s495ms 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 #8
Day Hour Count Duration Avg duration Nov 10 09 1 1m7s 1m7s Nov 11 09 1 20s292ms 20s292ms Nov 12 08 1 5s107ms 5s107ms Nov 14 08 1 5s279ms 5s279ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m37s - Times executed: 4 ]
-
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-11-10 08:20:29 Duration: 1m7s 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-11-11 08:14:19 Duration: 20s292ms 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-11-14 07:54:35 Duration: 5s279ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m28s 5 12s381ms 22s944ms 17s622ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 10 08 1 12s381ms 12s381ms Nov 11 08 1 19s392ms 19s392ms Nov 12 08 1 18s526ms 18s526ms Nov 13 08 1 22s944ms 22s944ms Nov 14 08 1 14s869ms 14s869ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: psql - Total duration: 1m28s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-13 07:45:57 Duration: 22s944ms 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-11-11 07:52:53 Duration: 19s392ms 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-11-12 07:51:30 Duration: 18s526ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m27s 5 14s424ms 21s321ms 17s480ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 10 08 1 21s321ms 21s321ms Nov 11 08 1 18s601ms 18s601ms Nov 12 08 1 15s625ms 15s625ms Nov 13 08 1 14s424ms 14s424ms Nov 14 08 1 17s432ms 17s432ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - 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-11-10 07:50:17 Duration: 21s321ms 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-11-11 07:54:01 Duration: 18s601ms 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-11-14 07:50:11 Duration: 17s432ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 58s9ms 5 5s551ms 18s880ms 11s601ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 10 08 1 13s203ms 13s203ms Nov 11 08 1 18s880ms 18s880ms Nov 12 08 1 10s58ms 10s58ms Nov 13 08 1 5s551ms 5s551ms Nov 14 08 1 10s314ms 10s314ms [ User: a3dsupervisor - Total duration: 58s9ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s9ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-11 07:50:00 Duration: 18s880ms 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-11-10 07:46:26 Duration: 13s203ms 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-11-14 07:46:26 Duration: 10s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 55s831ms 5 9s989ms 12s50ms 11s166ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 10 08 1 11s794ms 11s794ms Nov 11 08 1 11s896ms 11s896ms Nov 12 08 1 9s989ms 9s989ms Nov 13 08 1 10s101ms 10s101ms Nov 14 08 1 12s50ms 12s50ms [ User: a3dsupervisor - Total duration: 55s831ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s831ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-14 07:46:38 Duration: 12s50ms 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-11-11 07:50:12 Duration: 11s896ms 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-11-10 07:46:38 Duration: 11s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 54s739ms 2 5s892ms 48s847ms 27s369ms 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 #13
Day Hour Count Duration Avg duration Nov 10 09 1 48s847ms 48s847ms Nov 11 09 1 5s892ms 5s892ms [ User: a3dsupervisor - Total duration: 54s739ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 54s739ms - Times executed: 2 ]
-
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-11-10 08:21:29 Duration: 48s847ms 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-11-11 08:14:26 Duration: 5s892ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 54s563ms 4 6s620ms 33s851ms 13s640ms alter table pe_consumption_10min add constraint pk_pe_consumption_10min primary key (consumption_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 10 08 1 7s308ms 7s308ms Nov 11 08 1 33s851ms 33s851ms Nov 13 08 1 6s620ms 6s620ms Nov 14 08 1 6s782ms 6s782ms [ User: a3dsupervisor - Total duration: 54s563ms - Times executed: 4 ]
[ Application: psql - Total duration: 54s563ms - Times executed: 4 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-11 07:57:41 Duration: 33s851ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-10 07:51:20 Duration: 7s308ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-14 07:51:03 Duration: 6s782ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 53s440ms 5 7s244ms 18s342ms 10s688ms 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 Nov 10 08 1 8s40ms 8s40ms Nov 11 08 1 10s234ms 10s234ms Nov 12 08 1 7s244ms 7s244ms Nov 13 08 1 18s342ms 18s342ms Nov 14 08 1 9s579ms 9s579ms [ User: a3dsupervisor - Total duration: 53s440ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s440ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-13 07:45:23 Duration: 18s342ms 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-11-11 07:52:25 Duration: 10s234ms 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-11-14 07:48:42 Duration: 9s579ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 53s327ms 5 9s525ms 12s838ms 10s665ms 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 #16
Day Hour Count Duration Avg duration Nov 10 08 1 9s672ms 9s672ms Nov 11 08 1 9s571ms 9s571ms Nov 12 08 1 11s720ms 11s720ms Nov 13 08 1 12s838ms 12s838ms Nov 14 08 1 9s525ms 9s525ms [ User: a3dsupervisor - Total duration: 53s327ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s327ms - 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-11-13 07:44:09 Duration: 12s838ms 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-11-12 07:50:13 Duration: 11s720ms 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-11-10 07:47:52 Duration: 9s672ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 50s894ms 5 8s242ms 12s 10s178ms 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 Nov 10 08 1 10s426ms 10s426ms Nov 11 08 1 10s900ms 10s900ms Nov 12 08 1 8s242ms 8s242ms Nov 13 08 1 12s 12s Nov 14 08 1 9s324ms 9s324ms [ User: a3dsupervisor - Total duration: 50s894ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s894ms - 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-11-13 07:44:21 Duration: 12s 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-11-11 07:51:38 Duration: 10s900ms 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-11-10 07:48:03 Duration: 10s426ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 50s502ms 5 6s954ms 15s412ms 10s100ms create index i_fk_month_histo_att on gtp_monthly_history (att_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 10 08 1 8s309ms 8s309ms Nov 11 08 1 15s412ms 15s412ms Nov 12 08 1 8s346ms 8s346ms Nov 13 08 1 6s954ms 6s954ms Nov 14 08 1 11s480ms 11s480ms [ User: a3dsupervisor - Total duration: 50s502ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s502ms - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-11 07:50:28 Duration: 15s412ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-14 07:46:51 Duration: 11s480ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-12 07:48:57 Duration: 8s346ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 50s23ms 5 6s533ms 14s47ms 10s4ms 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 Nov 10 08 1 6s533ms 6s533ms Nov 11 08 1 12s608ms 12s608ms Nov 12 08 1 7s269ms 7s269ms Nov 13 08 1 14s47ms 14s47ms Nov 14 08 1 9s565ms 9s565ms [ User: a3dsupervisor - Total duration: 50s23ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s23ms - 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-11-13 07:44:46 Duration: 14s47ms 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-11-11 07:52:00 Duration: 12s608ms 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-11-14 07:48:16 Duration: 9s565ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 47s315ms 5 8s64ms 10s956ms 9s463ms 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 #20
Day Hour Count Duration Avg duration Nov 10 08 1 9s122ms 9s122ms Nov 11 08 1 9s143ms 9s143ms Nov 12 08 1 10s28ms 10s28ms Nov 13 08 1 10s956ms 10s956ms Nov 14 08 1 8s64ms 8s64ms [ User: a3dsupervisor - Total duration: 47s315ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s315ms - 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-11-13 07:44:32 Duration: 10s956ms 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-11-12 07:50:31 Duration: 10s28ms 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-11-11 07:51:47 Duration: 9s143ms 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 19m21s 35s379ms 15m8s 3m52s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 09 1 15m8s 15m8s Nov 11 09 1 2m23s 2m23s Nov 12 08 1 35s379ms 35s379ms Nov 13 08 1 38s486ms 38s486ms Nov 14 08 1 35s921ms 35s921ms [ User: a3dsupervisor - Total duration: 19m21s - Times executed: 5 ]
[ Application: psql - Total duration: 19m21s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-10 08:09:28 Duration: 15m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-11 08:12:26 Duration: 2m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 07:51:00 Duration: 38s486ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 5 11m49s 53s405ms 6m45s 2m21s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 08 1 1m52s 1m52s Nov 11 09 1 6m45s 6m45s Nov 12 08 1 53s405ms 53s405ms Nov 13 08 1 1m14s 1m14s Nov 14 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 11m49s - Times executed: 5 ]
[ Application: psql - Total duration: 11m49s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-11 08:09:56 Duration: 6m45s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-10 07:54:13 Duration: 1m52s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-13 07:50:10 Duration: 1m14s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 3m49s 29s488ms 1m18s 45s922ms 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 Nov 10 08 1 39s855ms 39s855ms Nov 11 08 1 1m18s 1m18s Nov 12 08 1 39s649ms 39s649ms Nov 13 08 1 41s930ms 41s930ms Nov 14 08 1 29s488ms 29s488ms [ User: a3dsupervisor - Total duration: 3m49s - Times executed: 5 ]
[ Application: psql - Total duration: 3m49s - 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-11-11 07:56:14 Duration: 1m18s 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-11-13 07:48:06 Duration: 41s930ms 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-11-10 07:51:06 Duration: 39s855ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 3m38s 6s230ms 2m48s 43s799ms 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 Nov 10 09 1 2m48s 2m48s Nov 11 09 1 29s461ms 29s461ms Nov 12 08 1 7s626ms 7s626ms Nov 13 08 1 6s230ms 6s230ms Nov 14 08 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - 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-11-10 08:17:11 Duration: 2m48s 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-11-11 08:13:37 Duration: 29s461ms 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-11-12 07:56:19 Duration: 7s626ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5 3m34s 5s882ms 3m1s 42s869ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 10 09 1 3m1s 3m1s Nov 11 09 1 14s478ms 14s478ms Nov 12 08 1 6s303ms 6s303ms Nov 13 08 1 5s882ms 5s882ms Nov 14 08 1 6s607ms 6s607ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m34s - 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-11-10 08:14:04 Duration: 3m1s 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-11-11 08:13:04 Duration: 14s478ms 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-11-14 07:54:06 Duration: 6s607ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 5 2m6s 13s109ms 38s150ms 25s365ms 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 #6
Day Hour Count Duration Avg duration Nov 10 08 1 28s447ms 28s447ms Nov 11 08 1 38s150ms 38s150ms Nov 12 08 1 15s783ms 15s783ms Nov 13 08 1 13s109ms 13s109ms Nov 14 08 1 31s339ms 31s339ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - 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-11-11 07:49:27 Duration: 38s150ms 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-11-14 07:45:54 Duration: 31s339ms 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-11-10 07:45:56 Duration: 28s447ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 1m28s 12s381ms 22s944ms 17s622ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 10 08 1 12s381ms 12s381ms Nov 11 08 1 19s392ms 19s392ms Nov 12 08 1 18s526ms 18s526ms Nov 13 08 1 22s944ms 22s944ms Nov 14 08 1 14s869ms 14s869ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: psql - Total duration: 1m28s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-13 07:45:57 Duration: 22s944ms 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-11-11 07:52:53 Duration: 19s392ms 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-11-12 07:51:30 Duration: 18s526ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 1m27s 14s424ms 21s321ms 17s480ms 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 #8
Day Hour Count Duration Avg duration Nov 10 08 1 21s321ms 21s321ms Nov 11 08 1 18s601ms 18s601ms Nov 12 08 1 15s625ms 15s625ms Nov 13 08 1 14s424ms 14s424ms Nov 14 08 1 17s432ms 17s432ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - 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-11-10 07:50:17 Duration: 21s321ms 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-11-11 07:54:01 Duration: 18s601ms 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-11-14 07:50:11 Duration: 17s432ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 5 58s9ms 5s551ms 18s880ms 11s601ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 10 08 1 13s203ms 13s203ms Nov 11 08 1 18s880ms 18s880ms Nov 12 08 1 10s58ms 10s58ms Nov 13 08 1 5s551ms 5s551ms Nov 14 08 1 10s314ms 10s314ms [ User: a3dsupervisor - Total duration: 58s9ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s9ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-11 07:50:00 Duration: 18s880ms 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-11-10 07:46:26 Duration: 13s203ms 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-11-14 07:46:26 Duration: 10s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 55s831ms 9s989ms 12s50ms 11s166ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 10 08 1 11s794ms 11s794ms Nov 11 08 1 11s896ms 11s896ms Nov 12 08 1 9s989ms 9s989ms Nov 13 08 1 10s101ms 10s101ms Nov 14 08 1 12s50ms 12s50ms [ User: a3dsupervisor - Total duration: 55s831ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s831ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-14 07:46:38 Duration: 12s50ms 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-11-11 07:50:12 Duration: 11s896ms 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-11-10 07:46:38 Duration: 11s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 53s440ms 7s244ms 18s342ms 10s688ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 10 08 1 8s40ms 8s40ms Nov 11 08 1 10s234ms 10s234ms Nov 12 08 1 7s244ms 7s244ms Nov 13 08 1 18s342ms 18s342ms Nov 14 08 1 9s579ms 9s579ms [ User: a3dsupervisor - Total duration: 53s440ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s440ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-13 07:45:23 Duration: 18s342ms 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-11-11 07:52:25 Duration: 10s234ms 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-11-14 07:48:42 Duration: 9s579ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 53s327ms 9s525ms 12s838ms 10s665ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 10 08 1 9s672ms 9s672ms Nov 11 08 1 9s571ms 9s571ms Nov 12 08 1 11s720ms 11s720ms Nov 13 08 1 12s838ms 12s838ms Nov 14 08 1 9s525ms 9s525ms [ User: a3dsupervisor - Total duration: 53s327ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s327ms - 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-11-13 07:44:09 Duration: 12s838ms 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-11-12 07:50:13 Duration: 11s720ms 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-11-10 07:47:52 Duration: 9s672ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 50s894ms 8s242ms 12s 10s178ms 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 #13
Day Hour Count Duration Avg duration Nov 10 08 1 10s426ms 10s426ms Nov 11 08 1 10s900ms 10s900ms Nov 12 08 1 8s242ms 8s242ms Nov 13 08 1 12s 12s Nov 14 08 1 9s324ms 9s324ms [ User: a3dsupervisor - Total duration: 50s894ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s894ms - 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-11-13 07:44:21 Duration: 12s 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-11-11 07:51:38 Duration: 10s900ms 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-11-10 07:48:03 Duration: 10s426ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 50s502ms 6s954ms 15s412ms 10s100ms create index i_fk_month_histo_att on gtp_monthly_history (att_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 10 08 1 8s309ms 8s309ms Nov 11 08 1 15s412ms 15s412ms Nov 12 08 1 8s346ms 8s346ms Nov 13 08 1 6s954ms 6s954ms Nov 14 08 1 11s480ms 11s480ms [ User: a3dsupervisor - Total duration: 50s502ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s502ms - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-11 07:50:28 Duration: 15s412ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-14 07:46:51 Duration: 11s480ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-12 07:48:57 Duration: 8s346ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 50s23ms 6s533ms 14s47ms 10s4ms 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 #15
Day Hour Count Duration Avg duration Nov 10 08 1 6s533ms 6s533ms Nov 11 08 1 12s608ms 12s608ms Nov 12 08 1 7s269ms 7s269ms Nov 13 08 1 14s47ms 14s47ms Nov 14 08 1 9s565ms 9s565ms [ User: a3dsupervisor - Total duration: 50s23ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s23ms - 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-11-13 07:44:46 Duration: 14s47ms 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-11-11 07:52:00 Duration: 12s608ms 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-11-14 07:48:16 Duration: 9s565ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 47s315ms 8s64ms 10s956ms 9s463ms 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 #16
Day Hour Count Duration Avg duration Nov 10 08 1 9s122ms 9s122ms Nov 11 08 1 9s143ms 9s143ms Nov 12 08 1 10s28ms 10s28ms Nov 13 08 1 10s956ms 10s956ms Nov 14 08 1 8s64ms 8s64ms [ User: a3dsupervisor - Total duration: 47s315ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s315ms - 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-11-13 07:44:32 Duration: 10s956ms 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-11-12 07:50:31 Duration: 10s28ms 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-11-11 07:51:47 Duration: 9s143ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 47s146ms 7s183ms 12s696ms 9s429ms 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 #17
Day Hour Count Duration Avg duration Nov 10 08 1 12s696ms 12s696ms Nov 11 08 1 7s183ms 7s183ms Nov 12 08 1 11s717ms 11s717ms Nov 13 08 1 8s304ms 8s304ms Nov 14 08 1 7s245ms 7s245ms [ User: a3dsupervisor - Total duration: 47s146ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s146ms - 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-11-10 07:48:31 Duration: 12s696ms 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-11-12 07:50:50 Duration: 11s717ms 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-11-13 07:44:54 Duration: 8s304ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 41s338ms 6s80ms 10s189ms 8s267ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 10 08 1 6s80ms 6s80ms Nov 11 08 1 7s995ms 7s995ms Nov 12 08 1 7s746ms 7s746ms Nov 13 08 1 10s189ms 10s189ms Nov 14 08 1 9s327ms 9s327ms [ User: a3dsupervisor - Total duration: 41s338ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s338ms - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-13 07:46:40 Duration: 10s189ms 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-11-14 07:49:48 Duration: 9s327ms 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-11-11 07:53:35 Duration: 7s995ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 38s619ms 6s690ms 9s31ms 7s723ms 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 #19
Day Hour Count Duration Avg duration Nov 10 08 1 6s690ms 6s690ms Nov 11 08 1 6s989ms 6s989ms Nov 12 08 1 7s93ms 7s93ms Nov 13 08 1 9s31ms 9s31ms Nov 14 08 1 8s813ms 8s813ms [ User: a3dsupervisor - Total duration: 38s619ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s619ms - 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-11-13 07:45:03 Duration: 9s31ms 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-11-14 07:48:32 Duration: 8s813ms 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-11-12 07:50:57 Duration: 7s93ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 38s66ms 6s179ms 11s534ms 7s613ms 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 Nov 10 08 1 11s534ms 11s534ms Nov 11 08 1 7s287ms 7s287ms Nov 12 08 1 6s460ms 6s460ms Nov 13 08 1 6s179ms 6s179ms Nov 14 08 1 6s606ms 6s606ms [ User: a3dsupervisor - Total duration: 38s66ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s66ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-10 07:49:42 Duration: 11s534ms 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-11-11 07:53:24 Duration: 7s287ms 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-11-14 07:49:36 Duration: 6s606ms 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 35s379ms 15m8s 3m52s 5 19m21s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 09 1 15m8s 15m8s Nov 11 09 1 2m23s 2m23s Nov 12 08 1 35s379ms 35s379ms Nov 13 08 1 38s486ms 38s486ms Nov 14 08 1 35s921ms 35s921ms [ User: a3dsupervisor - Total duration: 19m21s - Times executed: 5 ]
[ Application: psql - Total duration: 19m21s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-10 08:09:28 Duration: 15m8s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-11 08:12:26 Duration: 2m23s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-13 07:51:00 Duration: 38s486ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 53s405ms 6m45s 2m21s 5 11m49s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 08 1 1m52s 1m52s Nov 11 09 1 6m45s 6m45s Nov 12 08 1 53s405ms 53s405ms Nov 13 08 1 1m14s 1m14s Nov 14 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 11m49s - Times executed: 5 ]
[ Application: psql - Total duration: 11m49s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-11 08:09:56 Duration: 6m45s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-10 07:54:13 Duration: 1m52s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-13 07:50:10 Duration: 1m14s Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 29s488ms 1m18s 45s922ms 5 3m49s 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 Nov 10 08 1 39s855ms 39s855ms Nov 11 08 1 1m18s 1m18s Nov 12 08 1 39s649ms 39s649ms Nov 13 08 1 41s930ms 41s930ms Nov 14 08 1 29s488ms 29s488ms [ User: a3dsupervisor - Total duration: 3m49s - Times executed: 5 ]
[ Application: psql - Total duration: 3m49s - 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-11-11 07:56:14 Duration: 1m18s 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-11-13 07:48:06 Duration: 41s930ms 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-11-10 07:51:06 Duration: 39s855ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 6s230ms 2m48s 43s799ms 5 3m38s 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 Nov 10 09 1 2m48s 2m48s Nov 11 09 1 29s461ms 29s461ms Nov 12 08 1 7s626ms 7s626ms Nov 13 08 1 6s230ms 6s230ms Nov 14 08 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - 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-11-10 08:17:11 Duration: 2m48s 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-11-11 08:13:37 Duration: 29s461ms 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-11-12 07:56:19 Duration: 7s626ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5s882ms 3m1s 42s869ms 5 3m34s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 10 09 1 3m1s 3m1s Nov 11 09 1 14s478ms 14s478ms Nov 12 08 1 6s303ms 6s303ms Nov 13 08 1 5s882ms 5s882ms Nov 14 08 1 6s607ms 6s607ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m34s - 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-11-10 08:14:04 Duration: 3m1s 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-11-11 08:13:04 Duration: 14s478ms 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-11-14 07:54:06 Duration: 6s607ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 7s441ms 1m27s 29s7ms 4 1m56s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 10 09 1 1m27s 1m27s Nov 11 09 1 9s827ms 9s827ms Nov 13 08 1 7s441ms 7s441ms Nov 14 08 1 11s564ms 11s564ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m56s - 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-11-10 08:18:44 Duration: 1m27s 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-11-14 07:54:26 Duration: 11s564ms 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-11-11 08:13:47 Duration: 9s827ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 5s892ms 48s847ms 27s369ms 2 54s739ms 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 #7
Day Hour Count Duration Avg duration Nov 10 09 1 48s847ms 48s847ms Nov 11 09 1 5s892ms 5s892ms [ User: a3dsupervisor - Total duration: 54s739ms - Times executed: 2 ]
[ Application: pg_dump - Total duration: 54s739ms - Times executed: 2 ]
-
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-11-10 08:21:29 Duration: 48s847ms 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-11-11 08:14:26 Duration: 5s892ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 13s109ms 38s150ms 25s365ms 5 2m6s 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 Nov 10 08 1 28s447ms 28s447ms Nov 11 08 1 38s150ms 38s150ms Nov 12 08 1 15s783ms 15s783ms Nov 13 08 1 13s109ms 13s109ms Nov 14 08 1 31s339ms 31s339ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - 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-11-11 07:49:27 Duration: 38s150ms 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-11-14 07:45:54 Duration: 31s339ms 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-11-10 07:45:56 Duration: 28s447ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 5s107ms 1m7s 24s495ms 4 1m37s 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 #9
Day Hour Count Duration Avg duration Nov 10 09 1 1m7s 1m7s Nov 11 09 1 20s292ms 20s292ms Nov 12 08 1 5s107ms 5s107ms Nov 14 08 1 5s279ms 5s279ms [ User: a3dsupervisor - Total duration: 1m37s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m37s - Times executed: 4 ]
-
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-11-10 08:20:29 Duration: 1m7s 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-11-11 08:14:19 Duration: 20s292ms 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-11-14 07:54:35 Duration: 5s279ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 12s381ms 22s944ms 17s622ms 5 1m28s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 10 08 1 12s381ms 12s381ms Nov 11 08 1 19s392ms 19s392ms Nov 12 08 1 18s526ms 18s526ms Nov 13 08 1 22s944ms 22s944ms Nov 14 08 1 14s869ms 14s869ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: psql - Total duration: 1m28s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-13 07:45:57 Duration: 22s944ms 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-11-11 07:52:53 Duration: 19s392ms 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-11-12 07:51:30 Duration: 18s526ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 14s424ms 21s321ms 17s480ms 5 1m27s 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 #11
Day Hour Count Duration Avg duration Nov 10 08 1 21s321ms 21s321ms Nov 11 08 1 18s601ms 18s601ms Nov 12 08 1 15s625ms 15s625ms Nov 13 08 1 14s424ms 14s424ms Nov 14 08 1 17s432ms 17s432ms [ User: a3dsupervisor - Total duration: 1m27s - Times executed: 5 ]
[ Application: psql - Total duration: 1m27s - 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-11-10 07:50:17 Duration: 21s321ms 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-11-11 07:54:01 Duration: 18s601ms 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-11-14 07:50:11 Duration: 17s432ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 6s620ms 33s851ms 13s640ms 4 54s563ms alter table pe_consumption_10min add constraint pk_pe_consumption_10min primary key (consumption_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 10 08 1 7s308ms 7s308ms Nov 11 08 1 33s851ms 33s851ms Nov 13 08 1 6s620ms 6s620ms Nov 14 08 1 6s782ms 6s782ms [ User: a3dsupervisor - Total duration: 54s563ms - Times executed: 4 ]
[ Application: psql - Total duration: 54s563ms - Times executed: 4 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-11 07:57:41 Duration: 33s851ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-10 07:51:20 Duration: 7s308ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-11-14 07:51:03 Duration: 6s782ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5s551ms 18s880ms 11s601ms 5 58s9ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 10 08 1 13s203ms 13s203ms Nov 11 08 1 18s880ms 18s880ms Nov 12 08 1 10s58ms 10s58ms Nov 13 08 1 5s551ms 5s551ms Nov 14 08 1 10s314ms 10s314ms [ User: a3dsupervisor - Total duration: 58s9ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s9ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-11-11 07:50:00 Duration: 18s880ms 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-11-10 07:46:26 Duration: 13s203ms 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-11-14 07:46:26 Duration: 10s314ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 9s989ms 12s50ms 11s166ms 5 55s831ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 10 08 1 11s794ms 11s794ms Nov 11 08 1 11s896ms 11s896ms Nov 12 08 1 9s989ms 9s989ms Nov 13 08 1 10s101ms 10s101ms Nov 14 08 1 12s50ms 12s50ms [ User: a3dsupervisor - Total duration: 55s831ms - Times executed: 5 ]
[ Application: psql - Total duration: 55s831ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-11-14 07:46:38 Duration: 12s50ms 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-11-11 07:50:12 Duration: 11s896ms 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-11-10 07:46:38 Duration: 11s794ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 7s244ms 18s342ms 10s688ms 5 53s440ms 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 Nov 10 08 1 8s40ms 8s40ms Nov 11 08 1 10s234ms 10s234ms Nov 12 08 1 7s244ms 7s244ms Nov 13 08 1 18s342ms 18s342ms Nov 14 08 1 9s579ms 9s579ms [ User: a3dsupervisor - Total duration: 53s440ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s440ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-11-13 07:45:23 Duration: 18s342ms 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-11-11 07:52:25 Duration: 10s234ms 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-11-14 07:48:42 Duration: 9s579ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 9s525ms 12s838ms 10s665ms 5 53s327ms 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 #16
Day Hour Count Duration Avg duration Nov 10 08 1 9s672ms 9s672ms Nov 11 08 1 9s571ms 9s571ms Nov 12 08 1 11s720ms 11s720ms Nov 13 08 1 12s838ms 12s838ms Nov 14 08 1 9s525ms 9s525ms [ User: a3dsupervisor - Total duration: 53s327ms - Times executed: 5 ]
[ Application: psql - Total duration: 53s327ms - 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-11-13 07:44:09 Duration: 12s838ms 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-11-12 07:50:13 Duration: 11s720ms 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-11-10 07:47:52 Duration: 9s672ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 8s242ms 12s 10s178ms 5 50s894ms 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 Nov 10 08 1 10s426ms 10s426ms Nov 11 08 1 10s900ms 10s900ms Nov 12 08 1 8s242ms 8s242ms Nov 13 08 1 12s 12s Nov 14 08 1 9s324ms 9s324ms [ User: a3dsupervisor - Total duration: 50s894ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s894ms - 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-11-13 07:44:21 Duration: 12s 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-11-11 07:51:38 Duration: 10s900ms 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-11-10 07:48:03 Duration: 10s426ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 6s954ms 15s412ms 10s100ms 5 50s502ms create index i_fk_month_histo_att on gtp_monthly_history (att_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 10 08 1 8s309ms 8s309ms Nov 11 08 1 15s412ms 15s412ms Nov 12 08 1 8s346ms 8s346ms Nov 13 08 1 6s954ms 6s954ms Nov 14 08 1 11s480ms 11s480ms [ User: a3dsupervisor - Total duration: 50s502ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s502ms - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-11 07:50:28 Duration: 15s412ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-14 07:46:51 Duration: 11s480ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (att_template_num_id);
Date: 2025-11-12 07:48:57 Duration: 8s346ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 6s533ms 14s47ms 10s4ms 5 50s23ms 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 Nov 10 08 1 6s533ms 6s533ms Nov 11 08 1 12s608ms 12s608ms Nov 12 08 1 7s269ms 7s269ms Nov 13 08 1 14s47ms 14s47ms Nov 14 08 1 9s565ms 9s565ms [ User: a3dsupervisor - Total duration: 50s23ms - Times executed: 5 ]
[ Application: psql - Total duration: 50s23ms - 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-11-13 07:44:46 Duration: 14s47ms 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-11-11 07:52:00 Duration: 12s608ms 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-11-14 07:48:16 Duration: 9s565ms Database: autotest User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 8s64ms 10s956ms 9s463ms 5 47s315ms 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 #20
Day Hour Count Duration Avg duration Nov 10 08 1 9s122ms 9s122ms Nov 11 08 1 9s143ms 9s143ms Nov 12 08 1 10s28ms 10s28ms Nov 13 08 1 10s956ms 10s956ms Nov 14 08 1 8s64ms 8s64ms [ User: a3dsupervisor - Total duration: 47s315ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s315ms - 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-11-13 07:44:32 Duration: 10s956ms 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-11-12 07:50:31 Duration: 10s28ms 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-11-11 07:51:47 Duration: 9s143ms 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
- 7,068 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 5 ERROR entries
- 64 WARNING entries
Most Frequent Errors/Events
Key values
- 64 Max number of times the same event was reported
- 69 Total events found
Rank Times reported Error 1 64 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 11 08 16 Nov 12 08 16 Nov 13 08 16 Nov 14 08 16 2 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 #2
Day Hour Count Nov 10 08 1 Nov 12 08 1 3 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (...)
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 11 08 1 4 1 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 14 09 1 5 1 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 #5
Day Hour Count Nov 12 08 1