pgBadger-
Global information
- Generated on Mon Sep 22 15:58:52 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=19/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=19/h=23/m=00/PT1H.log
- Parsed 624,224 log entries in 1m43s
- Log start from 2025-09-16 00:00:03 to 2025-09-19 23:55:01
-
Overview
Global Stats
- 37 Number of unique normalized queries
- 110 Number of queries
- 23m32s Total query duration
- 2025-09-16 06:51:14 First query
- 2025-09-19 20:06:13 Last query
- 2 queries/s at 2025-09-16 07:32:15 Query peak
- 23m32s Total query duration
- 5s97ms Prepare/parse total duration
- 0ms Bind total duration
- 23m27s Execute total duration
- 306,017 Number of events
- 25 Number of unique normalized events
- 305,751 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
- 764 Number temporary file
- 3.35 GiB Max size of temporary file
- 22.26 MiB Average size of temporary file
- 3,728 Total number of sessions
- 32 sessions at 2025-09-16 06:32:07 Session peak
- 9d7h7m29s Total duration of sessions
- 3m35s Average duration of sessions
- 0 Average queries per session
- 379ms Average queries duration per session
- 3m35s Average idle time per session
- 3,731 Total number of connections
- 12 connections/s at 2025-09-17 19:56:46 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-16 07:32:15 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-16 07:32:15 Date
Queries duration
Key values
- 23m32s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 16 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 1 0ms 5s25ms 5s25ms 0ms 0ms 5s25ms 07 3 0ms 6s31ms 5s759ms 0ms 0ms 12s49ms 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 27 0ms 1m2s 14s401ms 57s536ms 1m3s 1m10s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 17 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 2 0ms 10s592ms 10s551ms 0ms 0ms 21s102ms 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 12 0ms 15s939ms 9s125ms 31s421ms 53s975ms 53s975ms 20 7 0ms 15s615ms 11s818ms 56s563ms 56s563ms 56s563ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 18 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 24 0ms 1m12s 15s347ms 46s486ms 51s854ms 1m48s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 19 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 4 0ms 5s420ms 5s173ms 0ms 5s80ms 10s194ms 07 1 0ms 5s13ms 5s13ms 0ms 0ms 5s13ms 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 19 0ms 29s440ms 10s315ms 49s698ms 50s270ms 52s424ms 20 10 0ms 50s625ms 19s331ms 0ms 47s814ms 50s625ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 16 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 Sep 17 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 Sep 18 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 Sep 19 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 16 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 17 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 18 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 16 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 1 1.00 0.00% 07 0 3 3.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 17 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 2 2.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 18 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 19 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 1 4 4.00 25.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 16 00 24 0.01/s 01 25 0.01/s 02 29 0.01/s 03 25 0.01/s 04 19 0.01/s 05 25 0.01/s 06 30 0.01/s 07 28 0.01/s 08 31 0.01/s 09 20 0.01/s 10 29 0.01/s 11 17 0.00/s 12 14 0.00/s 13 26 0.01/s 14 39 0.01/s 15 29 0.01/s 16 23 0.01/s 17 12 0.00/s 18 20 0.01/s 19 373 0.10/s 20 38 0.01/s 21 32 0.01/s 22 17 0.00/s 23 25 0.01/s Sep 17 00 35 0.01/s 01 32 0.01/s 02 20 0.01/s 03 22 0.01/s 04 25 0.01/s 05 27 0.01/s 06 23 0.01/s 07 43 0.01/s 08 17 0.00/s 09 23 0.01/s 10 18 0.01/s 11 21 0.01/s 12 31 0.01/s 13 25 0.01/s 14 23 0.01/s 15 46 0.01/s 16 23 0.01/s 17 15 0.00/s 18 12 0.00/s 19 281 0.08/s 20 2 0.00/s 21 2 0.00/s 22 48 0.01/s 23 25 0.01/s Sep 18 00 28 0.01/s 01 24 0.01/s 02 24 0.01/s 03 13 0.00/s 04 23 0.01/s 05 42 0.01/s 06 30 0.01/s 07 27 0.01/s 08 33 0.01/s 09 25 0.01/s 10 27 0.01/s 11 26 0.01/s 12 36 0.01/s 13 19 0.01/s 14 37 0.01/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 317 0.09/s 20 86 0.02/s 21 29 0.01/s 22 16 0.00/s 23 39 0.01/s Sep 19 00 28 0.01/s 01 26 0.01/s 02 31 0.01/s 03 27 0.01/s 04 24 0.01/s 05 35 0.01/s 06 34 0.01/s 07 33 0.01/s 08 30 0.01/s 09 35 0.01/s 10 41 0.01/s 11 28 0.01/s 12 30 0.01/s 13 32 0.01/s 14 21 0.01/s 15 31 0.01/s 16 32 0.01/s 17 21 0.01/s 18 19 0.01/s 19 275 0.08/s 20 121 0.03/s 21 23 0.01/s 22 31 0.01/s 23 25 0.01/s Day Hour Count Average Duration Average idle time Sep 16 00 23 1m22s 1m22s 01 26 1m20s 1m20s 02 28 1m19s 1m19s 03 25 1m22s 1m22s 04 20 1m25s 1m25s 05 25 1m18s 1m18s 06 27 1m51s 1m51s 07 28 1m50s 1m50s 08 31 1m37s 1m37s 09 20 1m19s 1m19s 10 29 1m19s 1m19s 11 17 1m27s 1m27s 12 14 1m15s 1m15s 13 23 1m18s 1m18s 14 42 48s57ms 48s57ms 15 29 1m18s 1m18s 16 23 1m19s 1m19s 17 12 3h32m10s 3h32m10s 18 22 8m40s 8m40s 19 370 7s597ms 6s546ms 20 39 1m 1m 21 31 1m23s 1m23s 22 18 1m27s 1m27s 23 25 1m18s 1m18s Sep 17 00 35 1m21s 1m21s 01 32 1m21s 1m21s 02 18 1m14s 1m14s 03 24 1m27s 1m27s 04 25 1m15s 1m15s 05 27 1m20s 1m20s 06 23 2m9s 2m8s 07 42 1m58s 1m58s 08 18 1m51s 1m51s 09 22 58s609ms 58s609ms 10 19 1m3s 1m3s 11 21 1m19s 1m19s 12 30 1m7s 1m7s 13 25 1m11s 1m11s 14 24 1m20s 1m20s 15 46 1m17s 1m17s 16 23 1m23s 1m23s 17 12 3h34m38s 3h34m38s 18 17 10m27s 10m27s 19 280 1s439ms 1s48ms 20 3 6m44s 6m16s 21 2 70ms 70ms 22 46 1m1s 1m1s 23 25 1m25s 1m25s Sep 18 00 27 1m31s 1m31s 01 25 1m26s 1m26s 02 24 1m18s 1m18s 03 13 1m27s 1m27s 04 22 1m30s 1m30s 05 43 1m19s 1m19s 06 30 1m47s 1m47s 07 27 1m17s 1m17s 08 33 1m16s 1m16s 09 25 1m2s 1m2s 10 27 2m53s 2m53s 11 26 1m21s 1m21s 12 36 1m25s 1m25s 13 19 1m20s 1m20s 14 39 50m40s 50m40s 15 2 80ms 80ms 16 2 70ms 70ms 17 2 73ms 73ms 18 2 70ms 70ms 19 315 6s402ms 5s233ms 20 86 35s485ms 35s485ms 21 29 1m16s 1m16s 22 15 1m19s 1m19s 23 40 1m17s 1m17s Sep 19 00 28 1m19s 1m19s 01 25 1m16s 1m16s 02 32 1m22s 1m22s 03 27 1m22s 1m22s 04 24 1m22s 1m22s 05 34 1m17s 1m17s 06 34 1m43s 1m42s 07 34 1m58s 1m57s 08 30 1m12s 1m12s 09 34 34s885ms 34s885ms 10 42 43s49ms 43s49ms 11 28 1m20s 1m20s 12 30 1m8s 1m8s 13 32 58s519ms 58s519ms 14 21 1m17s 1m17s 15 31 1m40s 1m40s 16 32 1m12s 1m12s 17 20 2h8m43s 2h8m43s 18 20 1m37s 1m37s 19 276 44s243ms 43s533ms 20 120 31s115ms 29s504ms 21 23 1m20s 1m20s 22 30 1m17s 1m17s 23 26 1m19s 1m19s -
Connections
Established Connections
Key values
- 12 connections Connection Peak
- 2025-09-17 19:56:46 Date
Connections per database
Key values
- autotest_api_batch Main Database
- 3,731 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 3,731 connections Total
-
Sessions
Simultaneous sessions
Key values
- 32 sessions Session Peak
- 2025-09-16 06:32:07 Date
Histogram of session times
Key values
- 1,970 60000-600000ms duration
Sessions per database
Key values
- autotest_api_batch Main Database
- 3,728 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 3,728 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 3,728 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 385.41 MiB Temp Files size Peak
- 2025-09-18 19:42:02 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-09-16 19:31:28 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 16 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 202 4.56 GiB 23.14 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Sep 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 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 108 1.66 GiB 15.70 MiB 20 36 1.20 GiB 34.23 MiB 21 0 0 0 22 1 4.19 MiB 4.19 MiB 23 0 0 0 Sep 18 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 201 4.57 GiB 23.28 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Sep 19 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 156 3.38 GiB 22.16 MiB 20 50 1.21 GiB 24.79 MiB 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 16 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 18 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 19 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
- 9 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
- 104 Total write queries
Queries by database
Key values
- autotest_api_batch Main database
- 110 Requests
- 23m27s (autotest_api_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 144 Requests
User Request type Count Duration a3dsupervisor Total 144 30m22s ddl 120 22m29s others 8 6m18s tcl 16 1m34s Duration by user
Key values
- 30m22s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 144 30m22s ddl 120 22m29s others 8 6m18s tcl 16 1m34s Queries by host
Key values
- 10.3.0.4 Main host
- 144 Requests
- 30m22s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 99 Requests
- 22m18s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-16 11:25:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 56 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m12s VACUUM ANALYZE;[ Date: 2025-09-18 19:44:07 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m2s VACUUM ANALYZE;[ Date: 2025-09-16 19:37:47 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 50s625ms VACUUM ANALYZE;[ Date: 2025-09-19 20:03:20 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 42s9ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-19 20:01:40 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 38s159ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-16 19:35:55 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 37s651ms VACUUM ANALYSE;[ Date: 2025-09-19 20:06:13 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 35s491ms VACUUM ANALYSE;[ Date: 2025-09-18 19:44:50 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 33s888ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-18 19:42:02 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 31s52ms VACUUM ANALYSE;[ Date: 2025-09-16 19:38:26 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 29s440ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-19 19:59:24 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 22s294ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-16 19:33:35 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 19s315ms 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-09-16 19:35:02 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 19s199ms 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-09-19 20:00:48 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 17s912ms CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);[ Date: 2025-09-19 19:56:21 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 17s514ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-09-16 19:30:06 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 17s142ms 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-09-18 19:41:10 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 15s939ms CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);[ Date: 2025-09-17 19:59:53 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 15s929ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-09-16 19:33:51 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 15s901ms ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-18 19:40:46 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 15s769ms CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);[ Date: 2025-09-18 19:40:02 - Database: autotest_api_batch - 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 3m6s 3 50s625ms 1m12s 1m2s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 21 1 1m2s 1m2s Sep 18 21 1 1m12s 1m12s Sep 19 22 1 50s625ms 50s625ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 3 ]
[ Application: psql - Total duration: 3m6s - Times executed: 3 ]
-
VACUUM ANALYZE;
Date: 2025-09-18 19:44:07 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-16 19:37:47 Duration: 1m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-19 20:03:20 Duration: 50s625ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m54s 3 33s888ms 42s9ms 38s19ms 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 #2
Day Hour Count Duration Avg duration Sep 16 21 1 38s159ms 38s159ms Sep 18 21 1 33s888ms 33s888ms Sep 19 22 1 42s9ms 42s9ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 3 ]
[ Application: psql - Total duration: 1m54s - Times executed: 3 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 20:01:40 Duration: 42s9ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:35:55 Duration: 38s159ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-18 19:42:02 Duration: 33s888ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 1m44s 3 31s52ms 37s651ms 34s731ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 16 21 1 31s52ms 31s52ms Sep 18 21 1 35s491ms 35s491ms Sep 19 22 1 37s651ms 37s651ms [ User: a3dsupervisor - Total duration: 1m44s - Times executed: 3 ]
[ Application: psql - Total duration: 1m44s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2025-09-19 20:06:13 Duration: 37s651ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-18 19:44:50 Duration: 35s491ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-16 19:38:26 Duration: 31s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 1m22s 4 15s319ms 29s440ms 20s667ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 21 1 22s294ms 22s294ms Sep 17 22 1 15s615ms 15s615ms Sep 18 21 1 15s319ms 15s319ms Sep 19 21 1 29s440ms 29s440ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: psql - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-19 19:59:24 Duration: 29s440ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-16 19:33:35 Duration: 22s294ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-17 20:01:25 Duration: 15s615ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1m9s 11 5s 10s592ms 6s283ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 16 08 1 5s25ms 5s25ms 09 3 17s277ms 5s759ms Sep 17 08 2 21s102ms 10s551ms Sep 19 08 4 20s695ms 5s173ms 09 1 5s13ms 5s13ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 11 ]
-
COMMIT;
Date: 2025-09-17 06:57:26 Duration: 10s592ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-17 06:57:27 Duration: 10s510ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-16 07:32:15 Duration: 6s31ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 55s657ms 3 17s142ms 19s315ms 18s552ms 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 #6
Day Hour Count Duration Avg duration Sep 16 21 1 19s315ms 19s315ms Sep 18 21 1 17s142ms 17s142ms Sep 19 22 1 19s199ms 19s199ms [ User: a3dsupervisor - Total duration: 55s657ms - Times executed: 3 ]
[ Application: psql - Total duration: 55s657ms - Times executed: 3 ]
-
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-09-16 19:35:02 Duration: 19s315ms Database: autotest_api_batch 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-09-19 20:00:48 Duration: 19s199ms Database: autotest_api_batch 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-09-18 19:41:10 Duration: 17s142ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 54s111ms 4 11s404ms 17s514ms 13s527ms 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 #7
Day Hour Count Duration Avg duration Sep 16 21 1 17s514ms 17s514ms Sep 17 21 1 11s456ms 11s456ms Sep 18 21 1 13s735ms 13s735ms Sep 19 21 1 11s404ms 11s404ms [ User: a3dsupervisor - Total duration: 54s111ms - Times executed: 4 ]
[ Application: psql - Total duration: 54s111ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-16 19:30:06 Duration: 17s514ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-18 19:36:38 Duration: 13s735ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-17 19:57:25 Duration: 11s456ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 53s772ms 4 10s594ms 17s912ms 13s443ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 16 21 1 10s594ms 10s594ms Sep 17 21 1 12s653ms 12s653ms Sep 18 21 1 12s611ms 12s611ms Sep 19 21 1 17s912ms 17s912ms [ User: a3dsupervisor - Total duration: 53s772ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s772ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-19 19:56:21 Duration: 17s912ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-17 19:57:53 Duration: 12s653ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-18 19:37:08 Duration: 12s611ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 51s294ms 4 10s424ms 15s939ms 12s823ms 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 #9
Day Hour Count Duration Avg duration Sep 16 21 1 13s374ms 13s374ms Sep 17 21 1 15s939ms 15s939ms Sep 18 21 1 11s555ms 11s555ms Sep 19 21 1 10s424ms 10s424ms [ User: a3dsupervisor - Total duration: 51s294ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s294ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-17 19:59:53 Duration: 15s939ms Database: autotest_api_batch 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-09-16 19:32:03 Duration: 13s374ms Database: autotest_api_batch 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-09-18 19:38:25 Duration: 11s555ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 48s798ms 4 8s457ms 13s660ms 12s199ms 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 #10
Day Hour Count Duration Avg duration Sep 16 21 1 13s660ms 13s660ms Sep 17 22 1 13s548ms 13s548ms Sep 18 21 1 8s457ms 8s457ms Sep 19 21 1 13s132ms 13s132ms [ User: a3dsupervisor - Total duration: 48s798ms - Times executed: 4 ]
[ Application: psql - Total duration: 48s798ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:32:25 Duration: 13s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-17 20:00:20 Duration: 13s548ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 19:58:19 Duration: 13s132ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 43s958ms 4 8s64ms 13s179ms 10s989ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 16 21 1 12s769ms 12s769ms Sep 17 21 1 9s944ms 9s944ms Sep 18 21 1 8s64ms 8s64ms Sep 19 21 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 43s958ms - Times executed: 4 ]
[ Application: psql - Total duration: 43s958ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-19 19:56:34 Duration: 13s179ms Database: autotest_api_batch 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-09-16 19:30:42 Duration: 12s769ms Database: autotest_api_batch 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-09-17 19:58:03 Duration: 9s944ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 42s39ms 3 10s340ms 15s929ms 14s13ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 16 21 1 15s929ms 15s929ms Sep 18 21 1 15s769ms 15s769ms Sep 19 21 1 10s340ms 10s340ms [ User: a3dsupervisor - Total duration: 42s39ms - Times executed: 3 ]
[ Application: psql - Total duration: 42s39ms - Times executed: 3 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-16 19:33:51 Duration: 15s929ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-18 19:40:02 Duration: 15s769ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-19 19:59:35 Duration: 10s340ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 41s193ms 4 8s280ms 12s987ms 10s298ms 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 Sep 16 21 1 9s160ms 9s160ms Sep 17 22 1 12s987ms 12s987ms Sep 18 21 1 10s764ms 10s764ms Sep 19 21 1 8s280ms 8s280ms [ User: a3dsupervisor - Total duration: 41s193ms - Times executed: 4 ]
[ Application: psql - Total duration: 41s193ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-17 20:00:06 Duration: 12s987ms Database: autotest_api_batch 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-09-18 19:38:36 Duration: 10s764ms Database: autotest_api_batch 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-09-16 19:32:12 Duration: 9s160ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 38s837ms 4 6s928ms 11s951ms 9s709ms 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 #14
Day Hour Count Duration Avg duration Sep 16 21 1 11s4ms 11s4ms Sep 17 22 1 8s952ms 8s952ms Sep 18 21 1 11s951ms 11s951ms Sep 19 21 1 6s928ms 6s928ms [ User: a3dsupervisor - Total duration: 38s837ms - Times executed: 4 ]
[ Application: psql - Total duration: 38s837ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-18 19:39:07 Duration: 11s951ms Database: autotest_api_batch 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-09-16 19:32:45 Duration: 11s4ms Database: autotest_api_batch 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-09-17 20:00:39 Duration: 8s952ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 37s957ms 3 8s968ms 15s901ms 12s652ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 16 21 1 13s86ms 13s86ms Sep 18 21 1 15s901ms 15s901ms Sep 19 22 1 8s968ms 8s968ms [ User: a3dsupervisor - Total duration: 37s957ms - Times executed: 3 ]
[ Application: psql - Total duration: 37s957ms - Times executed: 3 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-18 19:40:46 Duration: 15s901ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-16 19:34:35 Duration: 13s86ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 20:00:21 Duration: 8s968ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 37s890ms 4 8s92ms 10s544ms 9s472ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 21 1 8s789ms 8s789ms Sep 17 22 1 10s544ms 10s544ms Sep 18 21 1 10s464ms 10s464ms Sep 19 21 1 8s92ms 8s92ms [ User: a3dsupervisor - Total duration: 37s890ms - Times executed: 4 ]
[ Application: psql - Total duration: 37s890ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-17 20:00:31 Duration: 10s544ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-18 19:38:55 Duration: 10s464ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-16 19:32:34 Duration: 8s789ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 36s467ms 4 6s681ms 11s470ms 9s116ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 16 21 1 11s470ms 11s470ms Sep 17 22 1 10s553ms 10s553ms Sep 18 21 1 7s762ms 7s762ms Sep 19 21 1 6s681ms 6s681ms [ User: a3dsupervisor - Total duration: 36s467ms - Times executed: 4 ]
[ Application: psql - Total duration: 36s467ms - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-16 19:33:05 Duration: 11s470ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-17 20:01:01 Duration: 10s553ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-18 19:39:23 Duration: 7s762ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 33s544ms 4 7s154ms 10s530ms 8s386ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 21 1 7s786ms 7s786ms Sep 17 22 1 10s530ms 10s530ms Sep 18 21 1 8s72ms 8s72ms Sep 19 21 1 7s154ms 7s154ms [ User: a3dsupervisor - Total duration: 33s544ms - Times executed: 4 ]
[ Application: psql - Total duration: 33s544ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-17 20:00:50 Duration: 10s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-18 19:39:15 Duration: 8s72ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-16 19:32:53 Duration: 7s786ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 30s200ms 3 8s558ms 12s598ms 10s66ms alter table pe_consumption_10min add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 16 21 1 8s558ms 8s558ms Sep 18 21 1 12s598ms 12s598ms Sep 19 22 1 9s43ms 9s43ms [ User: a3dsupervisor - Total duration: 30s200ms - Times executed: 3 ]
[ Application: psql - Total duration: 30s200ms - Times executed: 3 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-18 19:42:23 Duration: 12s598ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-19 20:02:00 Duration: 9s43ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-16 19:36:11 Duration: 8s558ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 29s174ms 4 5s900ms 10s350ms 7s293ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 21 1 6s941ms 6s941ms Sep 17 21 1 10s350ms 10s350ms Sep 18 21 1 5s982ms 5s982ms Sep 19 21 1 5s900ms 5s900ms [ User: a3dsupervisor - Total duration: 29s174ms - Times executed: 4 ]
[ Application: psql - Total duration: 29s174ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-17 19:59:37 Duration: 10s350ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-16 19:31:49 Duration: 6s941ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-18 19:38:13 Duration: 5s982ms Database: autotest_api_batch 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 11 1m9s 5s 10s592ms 6s283ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 08 1 5s25ms 5s25ms 09 3 17s277ms 5s759ms Sep 17 08 2 21s102ms 10s551ms Sep 19 08 4 20s695ms 5s173ms 09 1 5s13ms 5s13ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 11 ]
-
COMMIT;
Date: 2025-09-17 06:57:26 Duration: 10s592ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-17 06:57:27 Duration: 10s510ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-16 07:32:15 Duration: 6s31ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4 1m22s 15s319ms 29s440ms 20s667ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 16 21 1 22s294ms 22s294ms Sep 17 22 1 15s615ms 15s615ms Sep 18 21 1 15s319ms 15s319ms Sep 19 21 1 29s440ms 29s440ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: psql - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-19 19:59:24 Duration: 29s440ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-16 19:33:35 Duration: 22s294ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-17 20:01:25 Duration: 15s615ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4 54s111ms 11s404ms 17s514ms 13s527ms 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 #3
Day Hour Count Duration Avg duration Sep 16 21 1 17s514ms 17s514ms Sep 17 21 1 11s456ms 11s456ms Sep 18 21 1 13s735ms 13s735ms Sep 19 21 1 11s404ms 11s404ms [ User: a3dsupervisor - Total duration: 54s111ms - Times executed: 4 ]
[ Application: psql - Total duration: 54s111ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-16 19:30:06 Duration: 17s514ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-18 19:36:38 Duration: 13s735ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-17 19:57:25 Duration: 11s456ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 4 53s772ms 10s594ms 17s912ms 13s443ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 21 1 10s594ms 10s594ms Sep 17 21 1 12s653ms 12s653ms Sep 18 21 1 12s611ms 12s611ms Sep 19 21 1 17s912ms 17s912ms [ User: a3dsupervisor - Total duration: 53s772ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s772ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-19 19:56:21 Duration: 17s912ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-17 19:57:53 Duration: 12s653ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-18 19:37:08 Duration: 12s611ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 4 51s294ms 10s424ms 15s939ms 12s823ms 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 #5
Day Hour Count Duration Avg duration Sep 16 21 1 13s374ms 13s374ms Sep 17 21 1 15s939ms 15s939ms Sep 18 21 1 11s555ms 11s555ms Sep 19 21 1 10s424ms 10s424ms [ User: a3dsupervisor - Total duration: 51s294ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s294ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-17 19:59:53 Duration: 15s939ms Database: autotest_api_batch 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-09-16 19:32:03 Duration: 13s374ms Database: autotest_api_batch 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-09-18 19:38:25 Duration: 11s555ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 4 48s798ms 8s457ms 13s660ms 12s199ms 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 #6
Day Hour Count Duration Avg duration Sep 16 21 1 13s660ms 13s660ms Sep 17 22 1 13s548ms 13s548ms Sep 18 21 1 8s457ms 8s457ms Sep 19 21 1 13s132ms 13s132ms [ User: a3dsupervisor - Total duration: 48s798ms - Times executed: 4 ]
[ Application: psql - Total duration: 48s798ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:32:25 Duration: 13s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-17 20:00:20 Duration: 13s548ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 19:58:19 Duration: 13s132ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 4 43s958ms 8s64ms 13s179ms 10s989ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 16 21 1 12s769ms 12s769ms Sep 17 21 1 9s944ms 9s944ms Sep 18 21 1 8s64ms 8s64ms Sep 19 21 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 43s958ms - Times executed: 4 ]
[ Application: psql - Total duration: 43s958ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-19 19:56:34 Duration: 13s179ms Database: autotest_api_batch 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-09-16 19:30:42 Duration: 12s769ms Database: autotest_api_batch 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-09-17 19:58:03 Duration: 9s944ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 4 41s193ms 8s280ms 12s987ms 10s298ms 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 #8
Day Hour Count Duration Avg duration Sep 16 21 1 9s160ms 9s160ms Sep 17 22 1 12s987ms 12s987ms Sep 18 21 1 10s764ms 10s764ms Sep 19 21 1 8s280ms 8s280ms [ User: a3dsupervisor - Total duration: 41s193ms - Times executed: 4 ]
[ Application: psql - Total duration: 41s193ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-17 20:00:06 Duration: 12s987ms Database: autotest_api_batch 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-09-18 19:38:36 Duration: 10s764ms Database: autotest_api_batch 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-09-16 19:32:12 Duration: 9s160ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 4 38s837ms 6s928ms 11s951ms 9s709ms 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 #9
Day Hour Count Duration Avg duration Sep 16 21 1 11s4ms 11s4ms Sep 17 22 1 8s952ms 8s952ms Sep 18 21 1 11s951ms 11s951ms Sep 19 21 1 6s928ms 6s928ms [ User: a3dsupervisor - Total duration: 38s837ms - Times executed: 4 ]
[ Application: psql - Total duration: 38s837ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-18 19:39:07 Duration: 11s951ms Database: autotest_api_batch 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-09-16 19:32:45 Duration: 11s4ms Database: autotest_api_batch 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-09-17 20:00:39 Duration: 8s952ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 4 37s890ms 8s92ms 10s544ms 9s472ms 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 #10
Day Hour Count Duration Avg duration Sep 16 21 1 8s789ms 8s789ms Sep 17 22 1 10s544ms 10s544ms Sep 18 21 1 10s464ms 10s464ms Sep 19 21 1 8s92ms 8s92ms [ User: a3dsupervisor - Total duration: 37s890ms - Times executed: 4 ]
[ Application: psql - Total duration: 37s890ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-17 20:00:31 Duration: 10s544ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-18 19:38:55 Duration: 10s464ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-16 19:32:34 Duration: 8s789ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 4 36s467ms 6s681ms 11s470ms 9s116ms 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 Sep 16 21 1 11s470ms 11s470ms Sep 17 22 1 10s553ms 10s553ms Sep 18 21 1 7s762ms 7s762ms Sep 19 21 1 6s681ms 6s681ms [ User: a3dsupervisor - Total duration: 36s467ms - Times executed: 4 ]
[ Application: psql - Total duration: 36s467ms - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-16 19:33:05 Duration: 11s470ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-17 20:01:01 Duration: 10s553ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-18 19:39:23 Duration: 7s762ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 4 33s544ms 7s154ms 10s530ms 8s386ms 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 #12
Day Hour Count Duration Avg duration Sep 16 21 1 7s786ms 7s786ms Sep 17 22 1 10s530ms 10s530ms Sep 18 21 1 8s72ms 8s72ms Sep 19 21 1 7s154ms 7s154ms [ User: a3dsupervisor - Total duration: 33s544ms - Times executed: 4 ]
[ Application: psql - Total duration: 33s544ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-17 20:00:50 Duration: 10s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-18 19:39:15 Duration: 8s72ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-16 19:32:53 Duration: 7s786ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 4 29s174ms 5s900ms 10s350ms 7s293ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 16 21 1 6s941ms 6s941ms Sep 17 21 1 10s350ms 10s350ms Sep 18 21 1 5s982ms 5s982ms Sep 19 21 1 5s900ms 5s900ms [ User: a3dsupervisor - Total duration: 29s174ms - Times executed: 4 ]
[ Application: psql - Total duration: 29s174ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-17 19:59:37 Duration: 10s350ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-16 19:31:49 Duration: 6s941ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-18 19:38:13 Duration: 5s982ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 3 3m6s 50s625ms 1m12s 1m2s vacuum analyze;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 16 21 1 1m2s 1m2s Sep 18 21 1 1m12s 1m12s Sep 19 22 1 50s625ms 50s625ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 3 ]
[ Application: psql - Total duration: 3m6s - Times executed: 3 ]
-
VACUUM ANALYZE;
Date: 2025-09-18 19:44:07 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-16 19:37:47 Duration: 1m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-19 20:03:20 Duration: 50s625ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 3 1m54s 33s888ms 42s9ms 38s19ms 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 #15
Day Hour Count Duration Avg duration Sep 16 21 1 38s159ms 38s159ms Sep 18 21 1 33s888ms 33s888ms Sep 19 22 1 42s9ms 42s9ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 3 ]
[ Application: psql - Total duration: 1m54s - Times executed: 3 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 20:01:40 Duration: 42s9ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:35:55 Duration: 38s159ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-18 19:42:02 Duration: 33s888ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 3 1m44s 31s52ms 37s651ms 34s731ms vacuum analyse;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 21 1 31s52ms 31s52ms Sep 18 21 1 35s491ms 35s491ms Sep 19 22 1 37s651ms 37s651ms [ User: a3dsupervisor - Total duration: 1m44s - Times executed: 3 ]
[ Application: psql - Total duration: 1m44s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2025-09-19 20:06:13 Duration: 37s651ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-18 19:44:50 Duration: 35s491ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-16 19:38:26 Duration: 31s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 3 55s657ms 17s142ms 19s315ms 18s552ms 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 #17
Day Hour Count Duration Avg duration Sep 16 21 1 19s315ms 19s315ms Sep 18 21 1 17s142ms 17s142ms Sep 19 22 1 19s199ms 19s199ms [ User: a3dsupervisor - Total duration: 55s657ms - Times executed: 3 ]
[ Application: psql - Total duration: 55s657ms - Times executed: 3 ]
-
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-09-16 19:35:02 Duration: 19s315ms Database: autotest_api_batch 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-09-19 20:00:48 Duration: 19s199ms Database: autotest_api_batch 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-09-18 19:41:10 Duration: 17s142ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 3 42s39ms 10s340ms 15s929ms 14s13ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 21 1 15s929ms 15s929ms Sep 18 21 1 15s769ms 15s769ms Sep 19 21 1 10s340ms 10s340ms [ User: a3dsupervisor - Total duration: 42s39ms - Times executed: 3 ]
[ Application: psql - Total duration: 42s39ms - Times executed: 3 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-16 19:33:51 Duration: 15s929ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-18 19:40:02 Duration: 15s769ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-19 19:59:35 Duration: 10s340ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 3 37s957ms 8s968ms 15s901ms 12s652ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 16 21 1 13s86ms 13s86ms Sep 18 21 1 15s901ms 15s901ms Sep 19 22 1 8s968ms 8s968ms [ User: a3dsupervisor - Total duration: 37s957ms - Times executed: 3 ]
[ Application: psql - Total duration: 37s957ms - Times executed: 3 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-18 19:40:46 Duration: 15s901ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-16 19:34:35 Duration: 13s86ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 20:00:21 Duration: 8s968ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 3 30s200ms 8s558ms 12s598ms 10s66ms alter table pe_consumption_10min add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 21 1 8s558ms 8s558ms Sep 18 21 1 12s598ms 12s598ms Sep 19 22 1 9s43ms 9s43ms [ User: a3dsupervisor - Total duration: 30s200ms - Times executed: 3 ]
[ Application: psql - Total duration: 30s200ms - Times executed: 3 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-18 19:42:23 Duration: 12s598ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-19 20:02:00 Duration: 9s43ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-16 19:36:11 Duration: 8s558ms Database: autotest_api_batch 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 50s625ms 1m12s 1m2s 3 3m6s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 21 1 1m2s 1m2s Sep 18 21 1 1m12s 1m12s Sep 19 22 1 50s625ms 50s625ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 3 ]
[ Application: psql - Total duration: 3m6s - Times executed: 3 ]
-
VACUUM ANALYZE;
Date: 2025-09-18 19:44:07 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-16 19:37:47 Duration: 1m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-19 20:03:20 Duration: 50s625ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 33s888ms 42s9ms 38s19ms 3 1m54s 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 #2
Day Hour Count Duration Avg duration Sep 16 21 1 38s159ms 38s159ms Sep 18 21 1 33s888ms 33s888ms Sep 19 22 1 42s9ms 42s9ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 3 ]
[ Application: psql - Total duration: 1m54s - Times executed: 3 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 20:01:40 Duration: 42s9ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:35:55 Duration: 38s159ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-18 19:42:02 Duration: 33s888ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 31s52ms 37s651ms 34s731ms 3 1m44s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 16 21 1 31s52ms 31s52ms Sep 18 21 1 35s491ms 35s491ms Sep 19 22 1 37s651ms 37s651ms [ User: a3dsupervisor - Total duration: 1m44s - Times executed: 3 ]
[ Application: psql - Total duration: 1m44s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2025-09-19 20:06:13 Duration: 37s651ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-18 19:44:50 Duration: 35s491ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-16 19:38:26 Duration: 31s52ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 15s319ms 29s440ms 20s667ms 4 1m22s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 21 1 22s294ms 22s294ms Sep 17 22 1 15s615ms 15s615ms Sep 18 21 1 15s319ms 15s319ms Sep 19 21 1 29s440ms 29s440ms [ User: a3dsupervisor - Total duration: 1m22s - Times executed: 4 ]
[ Application: psql - Total duration: 1m22s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-19 19:59:24 Duration: 29s440ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-16 19:33:35 Duration: 22s294ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-17 20:01:25 Duration: 15s615ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 17s142ms 19s315ms 18s552ms 3 55s657ms 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 #5
Day Hour Count Duration Avg duration Sep 16 21 1 19s315ms 19s315ms Sep 18 21 1 17s142ms 17s142ms Sep 19 22 1 19s199ms 19s199ms [ User: a3dsupervisor - Total duration: 55s657ms - Times executed: 3 ]
[ Application: psql - Total duration: 55s657ms - Times executed: 3 ]
-
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-09-16 19:35:02 Duration: 19s315ms Database: autotest_api_batch 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-09-19 20:00:48 Duration: 19s199ms Database: autotest_api_batch 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-09-18 19:41:10 Duration: 17s142ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 10s340ms 15s929ms 14s13ms 3 42s39ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 16 21 1 15s929ms 15s929ms Sep 18 21 1 15s769ms 15s769ms Sep 19 21 1 10s340ms 10s340ms [ User: a3dsupervisor - Total duration: 42s39ms - Times executed: 3 ]
[ Application: psql - Total duration: 42s39ms - Times executed: 3 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-16 19:33:51 Duration: 15s929ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-18 19:40:02 Duration: 15s769ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-19 19:59:35 Duration: 10s340ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 11s404ms 17s514ms 13s527ms 4 54s111ms 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 #7
Day Hour Count Duration Avg duration Sep 16 21 1 17s514ms 17s514ms Sep 17 21 1 11s456ms 11s456ms Sep 18 21 1 13s735ms 13s735ms Sep 19 21 1 11s404ms 11s404ms [ User: a3dsupervisor - Total duration: 54s111ms - Times executed: 4 ]
[ Application: psql - Total duration: 54s111ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-16 19:30:06 Duration: 17s514ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-18 19:36:38 Duration: 13s735ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-17 19:57:25 Duration: 11s456ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 10s594ms 17s912ms 13s443ms 4 53s772ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 16 21 1 10s594ms 10s594ms Sep 17 21 1 12s653ms 12s653ms Sep 18 21 1 12s611ms 12s611ms Sep 19 21 1 17s912ms 17s912ms [ User: a3dsupervisor - Total duration: 53s772ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s772ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-19 19:56:21 Duration: 17s912ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-17 19:57:53 Duration: 12s653ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-18 19:37:08 Duration: 12s611ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 10s424ms 15s939ms 12s823ms 4 51s294ms 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 #9
Day Hour Count Duration Avg duration Sep 16 21 1 13s374ms 13s374ms Sep 17 21 1 15s939ms 15s939ms Sep 18 21 1 11s555ms 11s555ms Sep 19 21 1 10s424ms 10s424ms [ User: a3dsupervisor - Total duration: 51s294ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s294ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-17 19:59:53 Duration: 15s939ms Database: autotest_api_batch 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-09-16 19:32:03 Duration: 13s374ms Database: autotest_api_batch 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-09-18 19:38:25 Duration: 11s555ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 8s968ms 15s901ms 12s652ms 3 37s957ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 16 21 1 13s86ms 13s86ms Sep 18 21 1 15s901ms 15s901ms Sep 19 22 1 8s968ms 8s968ms [ User: a3dsupervisor - Total duration: 37s957ms - Times executed: 3 ]
[ Application: psql - Total duration: 37s957ms - Times executed: 3 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-18 19:40:46 Duration: 15s901ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-16 19:34:35 Duration: 13s86ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-19 20:00:21 Duration: 8s968ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 8s457ms 13s660ms 12s199ms 4 48s798ms 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 #11
Day Hour Count Duration Avg duration Sep 16 21 1 13s660ms 13s660ms Sep 17 22 1 13s548ms 13s548ms Sep 18 21 1 8s457ms 8s457ms Sep 19 21 1 13s132ms 13s132ms [ User: a3dsupervisor - Total duration: 48s798ms - Times executed: 4 ]
[ Application: psql - Total duration: 48s798ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-16 19:32:25 Duration: 13s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-17 20:00:20 Duration: 13s548ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-19 19:58:19 Duration: 13s132ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 8s64ms 13s179ms 10s989ms 4 43s958ms 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 Sep 16 21 1 12s769ms 12s769ms Sep 17 21 1 9s944ms 9s944ms Sep 18 21 1 8s64ms 8s64ms Sep 19 21 1 13s179ms 13s179ms [ User: a3dsupervisor - Total duration: 43s958ms - Times executed: 4 ]
[ Application: psql - Total duration: 43s958ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-19 19:56:34 Duration: 13s179ms Database: autotest_api_batch 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-09-16 19:30:42 Duration: 12s769ms Database: autotest_api_batch 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-09-17 19:58:03 Duration: 9s944ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 8s280ms 12s987ms 10s298ms 4 41s193ms 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 Sep 16 21 1 9s160ms 9s160ms Sep 17 22 1 12s987ms 12s987ms Sep 18 21 1 10s764ms 10s764ms Sep 19 21 1 8s280ms 8s280ms [ User: a3dsupervisor - Total duration: 41s193ms - Times executed: 4 ]
[ Application: psql - Total duration: 41s193ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-17 20:00:06 Duration: 12s987ms Database: autotest_api_batch 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-09-18 19:38:36 Duration: 10s764ms Database: autotest_api_batch 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-09-16 19:32:12 Duration: 9s160ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 8s558ms 12s598ms 10s66ms 3 30s200ms alter table pe_consumption_10min add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 16 21 1 8s558ms 8s558ms Sep 18 21 1 12s598ms 12s598ms Sep 19 22 1 9s43ms 9s43ms [ User: a3dsupervisor - Total duration: 30s200ms - Times executed: 3 ]
[ Application: psql - Total duration: 30s200ms - Times executed: 3 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-18 19:42:23 Duration: 12s598ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-19 20:02:00 Duration: 9s43ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2025-09-16 19:36:11 Duration: 8s558ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 6s928ms 11s951ms 9s709ms 4 38s837ms 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 #15
Day Hour Count Duration Avg duration Sep 16 21 1 11s4ms 11s4ms Sep 17 22 1 8s952ms 8s952ms Sep 18 21 1 11s951ms 11s951ms Sep 19 21 1 6s928ms 6s928ms [ User: a3dsupervisor - Total duration: 38s837ms - Times executed: 4 ]
[ Application: psql - Total duration: 38s837ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-18 19:39:07 Duration: 11s951ms Database: autotest_api_batch 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-09-16 19:32:45 Duration: 11s4ms Database: autotest_api_batch 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-09-17 20:00:39 Duration: 8s952ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 8s92ms 10s544ms 9s472ms 4 37s890ms create index i_gtp_obj_rel_vt_obj_vt on gtp_obj_rel_vt (obj_num_id, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 21 1 8s789ms 8s789ms Sep 17 22 1 10s544ms 10s544ms Sep 18 21 1 10s464ms 10s464ms Sep 19 21 1 8s92ms 8s92ms [ User: a3dsupervisor - Total duration: 37s890ms - Times executed: 4 ]
[ Application: psql - Total duration: 37s890ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-17 20:00:31 Duration: 10s544ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-18 19:38:55 Duration: 10s464ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-16 19:32:34 Duration: 8s789ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 6s681ms 11s470ms 9s116ms 4 36s467ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 16 21 1 11s470ms 11s470ms Sep 17 22 1 10s553ms 10s553ms Sep 18 21 1 7s762ms 7s762ms Sep 19 21 1 6s681ms 6s681ms [ User: a3dsupervisor - Total duration: 36s467ms - Times executed: 4 ]
[ Application: psql - Total duration: 36s467ms - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-16 19:33:05 Duration: 11s470ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-17 20:01:01 Duration: 10s553ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-18 19:39:23 Duration: 7s762ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 7s154ms 10s530ms 8s386ms 4 33s544ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 21 1 7s786ms 7s786ms Sep 17 22 1 10s530ms 10s530ms Sep 18 21 1 8s72ms 8s72ms Sep 19 21 1 7s154ms 7s154ms [ User: a3dsupervisor - Total duration: 33s544ms - Times executed: 4 ]
[ Application: psql - Total duration: 33s544ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-17 20:00:50 Duration: 10s530ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-18 19:39:15 Duration: 8s72ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-09-16 19:32:53 Duration: 7s786ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5s900ms 10s350ms 7s293ms 4 29s174ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 16 21 1 6s941ms 6s941ms Sep 17 21 1 10s350ms 10s350ms Sep 18 21 1 5s982ms 5s982ms Sep 19 21 1 5s900ms 5s900ms [ User: a3dsupervisor - Total duration: 29s174ms - Times executed: 4 ]
[ Application: psql - Total duration: 29s174ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-17 19:59:37 Duration: 10s350ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-16 19:31:49 Duration: 6s941ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-18 19:38:13 Duration: 5s982ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5s 10s592ms 6s283ms 11 1m9s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 08 1 5s25ms 5s25ms 09 3 17s277ms 5s759ms Sep 17 08 2 21s102ms 10s551ms Sep 19 08 4 20s695ms 5s173ms 09 1 5s13ms 5s13ms [ User: a3dsupervisor - Total duration: 1m9s - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m9s - Times executed: 11 ]
-
COMMIT;
Date: 2025-09-17 06:57:26 Duration: 10s592ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-17 06:57:27 Duration: 10s510ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-16 07:32:15 Duration: 6s31ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 318,097 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 305931 ERROR entries
- 86 WARNING entries
Most Frequent Errors/Events
Key values
- 305,751 Max number of times the same event was reported
- 306,017 Total events found
Rank Times reported Error 1 305,751 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 16 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 3,544 09 3,600 10 3,600 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 2,932 20 3,428 21 1,140 22 3,610 23 3,600 00 3,600 01 3,600 Sep 17 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 3,553 09 3,600 10 3,600 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 2,872 20 3,427 00 3,120 01 3,600 Sep 18 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 3,577 09 3,600 10 3,600 11 3,600 12 3,610 13 3,600 14 3,600 15 3,610 16 882 21 720 22 3,600 23 3,599 00 3,610 01 3,600 Sep 19 02 3,600 03 3,600 04 3,600 05 3,590 06 3,610 07 3,600 08 3,556 09 3,600 10 3,610 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,610 17 3,600 18 3,610 19 2,926 20 3,600 21 545 22 3,060 23 3,600 00 3,600 01 3,600 2 64 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 16 21 16 Sep 17 21 16 Sep 18 21 16 Sep 19 21 16 3 56 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 16 19 2 21 11 22 5 Sep 17 19 2 22 1 Sep 18 22 16 Sep 19 19 3 22 16 4 33 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 16 21 11 Sep 18 22 11 Sep 19 22 11 5 22 WARNING: permission denied to vacuum "...", skipping it
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 16 21 22 6 20 ERROR: column "..." is of type smallint but expression is of type boolean
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 17 00 20 7 15 ERROR: function convert(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 16 22 5 Sep 18 22 5 Sep 19 22 5 8 5 ERROR: function to_char(...) does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 17 00 1 Sep 18 04 1 08 1 12 1 16 1 9 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 10 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 11 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 12 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 13 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 14 4 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 17 09 1 Sep 18 08 2 Sep 19 08 1 15 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 16 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 17 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 18 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #18
Day Hour Count Sep 16 21 1 Sep 17 00 1 Sep 18 21 1 Sep 19 22 1 19 3 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 16 21 1 Sep 18 21 1 Sep 19 22 1 20 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_pe_consumption_10min_cp ON pe_consumption_10min (...)
Times Reported Most Frequent Error / Event #20
Day Hour Count Sep 17 21 1 Sep 19 21 1 21 2 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #21
Day Hour Count Sep 17 00 1 Sep 18 02 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON gtp_obj_composition (...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Sep 18 21 1 23 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in (...))
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 18 12 1 24 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (...)
Times Reported Most Frequent Error / Event #24
Day Hour Count Sep 17 21 1 25 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #25
Day Hour Count Sep 18 16 1