pgBadger-
Global information
- Generated on Mon Oct 20 09:35:11 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=18/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=18/h=23/m=00/PT1H.log
- Parsed 63,917 log entries in 1m1s
- Log start from 2025-10-13 19:32:26 to 2025-10-18 17:01:10
-
Overview
Global Stats
- 38 Number of unique normalized queries
- 147 Number of queries
- 33m38s Total query duration
- 2025-10-13 06:14:12 First query
- 2025-10-18 00:01:37 Last query
- 2 queries/s at 2025-10-14 06:28:40 Query peak
- 33m38s Total query duration
- 41s2ms Prepare/parse total duration
- 10s604ms Bind total duration
- 32m46s Execute total duration
- 26,281 Number of events
- 19 Number of unique normalized events
- 16,814 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
- 825 Number temporary file
- 3.43 GiB Max size of temporary file
- 23.25 MiB Average size of temporary file
- 3,409 Total number of sessions
- 80 sessions at 2025-10-18 17:50:22 Session peak
- 11d23h15m1s Total duration of sessions
- 5m3s Average duration of sessions
- 0 Average queries per session
- 591ms Average queries duration per session
- 5m2s Average idle time per session
- 3,407 Total number of connections
- 11 connections/s at 2025-10-13 19:50:00 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-14 06:28:40 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-18 00:01:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-14 06:28:40 Date
Queries duration
Key values
- 33m38s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 13 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 9 0ms 6s735ms 5s554ms 10s295ms 16s503ms 17s243ms 07 7 0ms 13s72ms 7s64ms 12s66ms 18s545ms 18s842ms 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 26 0ms 1m12s 16s237ms 46s3ms 56s135ms 1m12s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 14 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 3 0ms 6s69ms 5s529ms 0ms 5s142ms 11s446ms 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 2 0ms 6s74ms 6s62ms 0ms 12s125ms 12s125ms 19 26 0ms 1m16s 15s733ms 44s42ms 1m11s 1m56s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 15 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 8 0ms 7s147ms 6s11ms 0ms 10s652ms 23s415ms 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 25 0ms 1m17s 17s244ms 48s586ms 1m5s 1m17s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 13 0ms 9s48ms 6s891ms 12s603ms 16s786ms 17s966ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 2 0ms 7s147ms 6s85ms 0ms 12s170ms 12s170ms 19 23 0ms 1m10s 17s36ms 59s446ms 1m7s 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 Oct 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 5s244ms 5s243ms 0ms 0ms 10s486ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 18 00 1 0ms 23s680ms 23s680ms 23s680ms 23s680ms 23s680ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 13 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 5s493ms 0ms 0ms 5s738ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 14 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 15 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 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 Oct 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 Oct 18 00 1 0 23s680ms 0ms 23s680ms 23s680ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 12 00 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 2 0 0 0 5s501ms 0ms 0ms 5s260ms 07 1 0 0 0 5s472ms 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 1 0 18s212ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 1 0 12s654ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 15 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 1 0 13s380ms 0ms 0ms 13s380ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 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 1 1 0 0 7s223ms 0ms 0ms 7s153ms 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 1 0 18s852ms 0ms 0ms 18s852ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 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 Oct 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 Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 12 00 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 13 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 1 9 9.00 11.11% 07 0 7 7.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 1 3 3.00 33.33% 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 2 2.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 1 8 8.00 12.50% 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 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 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 0 0.00 0.00% 07 1 13 13.00 7.69% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 2 2.00 0.00% 19 0 1 1.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 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 1 2 2.00 50.00% 07 1 0 0.00 100.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 18 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Oct 12 00 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Oct 13 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 20 0.01/s 06 33 0.01/s 07 25 0.01/s 08 16 0.00/s 09 10 0.00/s 10 10 0.00/s 11 3 0.00/s 12 12 0.00/s 13 6 0.00/s 14 9 0.00/s 15 14 0.00/s 16 12 0.00/s 17 10 0.00/s 18 10 0.00/s 19 365 0.10/s 20 42 0.01/s 21 12 0.00/s 22 23 0.01/s 23 18 0.01/s Oct 14 00 13 0.00/s 01 14 0.00/s 02 16 0.00/s 03 11 0.00/s 04 15 0.00/s 05 15 0.00/s 06 20 0.01/s 07 27 0.01/s 08 10 0.00/s 09 7 0.00/s 10 13 0.00/s 11 9 0.00/s 12 9 0.00/s 13 15 0.00/s 14 6 0.00/s 15 11 0.00/s 16 9 0.00/s 17 8 0.00/s 18 13 0.00/s 19 380 0.11/s 20 33 0.01/s 21 23 0.01/s 22 22 0.01/s 23 15 0.00/s Oct 15 00 16 0.00/s 01 17 0.00/s 02 10 0.00/s 03 5 0.00/s 04 15 0.00/s 05 19 0.01/s 06 27 0.01/s 07 20 0.01/s 08 21 0.01/s 09 17 0.00/s 10 14 0.00/s 11 16 0.00/s 12 15 0.00/s 13 15 0.00/s 14 14 0.00/s 15 15 0.00/s 16 16 0.00/s 17 12 0.00/s 18 10 0.00/s 19 329 0.09/s 20 79 0.02/s 21 7 0.00/s 22 13 0.00/s 23 11 0.00/s Oct 16 00 10 0.00/s 01 12 0.00/s 02 13 0.00/s 03 15 0.00/s 04 14 0.00/s 05 15 0.00/s 06 25 0.01/s 07 36 0.01/s 08 16 0.00/s 09 11 0.00/s 10 10 0.00/s 11 14 0.00/s 12 10 0.00/s 13 27 0.01/s 14 10 0.00/s 15 7 0.00/s 16 16 0.00/s 17 11 0.00/s 18 14 0.00/s 19 327 0.09/s 20 90 0.03/s 21 27 0.01/s 22 22 0.01/s 23 22 0.01/s Oct 17 00 13 0.00/s 01 7 0.00/s 02 13 0.00/s 03 10 0.00/s 04 10 0.00/s 05 9 0.00/s 06 35 0.01/s 07 15 0.00/s 08 14 0.00/s 09 17 0.00/s 10 13 0.00/s 11 22 0.01/s 12 20 0.01/s 13 15 0.00/s 14 14 0.00/s 15 15 0.00/s 16 14 0.00/s 17 9 0.00/s 18 23 0.01/s 19 3 0.00/s 20 7 0.00/s 21 4 0.00/s 22 10 0.00/s 23 12 0.00/s Oct 18 00 6 0.00/s 01 12 0.00/s 02 3 0.00/s 03 13 0.00/s 04 12 0.00/s 05 5 0.00/s 06 10 0.00/s 07 10 0.00/s 08 7 0.00/s 09 8 0.00/s 10 6 0.00/s 11 8 0.00/s 12 6 0.00/s 13 7 0.00/s 14 10 0.00/s 15 9 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Oct 12 00 2 75ms 75ms 02 2 72ms 72ms 03 2 74ms 74ms 04 2 77ms 77ms 05 2 75ms 75ms 06 2 76ms 76ms 07 2 85ms 85ms 08 2 84ms 84ms 09 2 77ms 77ms 10 2 76ms 76ms 11 2 75ms 75ms 12 2 81ms 81ms 13 2 84ms 84ms 14 2 78ms 78ms 15 2 78ms 78ms 16 2 79ms 79ms 17 2 82ms 82ms 18 2 90ms 90ms 19 2 88ms 88ms 20 2 72ms 72ms 21 2 74ms 74ms 22 2 73ms 73ms 23 2 77ms 77ms Oct 13 00 2 75ms 75ms 01 2 77ms 77ms 02 2 91ms 91ms 03 2 74ms 74ms 04 2 76ms 76ms 05 18 1m11s 1m11s 06 32 1m22s 1m20s 07 27 1m30s 1m28s 08 16 41s917ms 41s917ms 09 10 24m20s 24m20s 10 10 1m2s 1m2s 11 3 72ms 72ms 12 12 54s674ms 54s674ms 13 6 41s282ms 41s282ms 14 9 50s759ms 50s759ms 15 14 1m4s 1m4s 16 12 59s360ms 59s360ms 17 10 1h54m29s 1h54m29s 18 12 17m31s 17m31s 19 363 6s651ms 5s488ms 20 42 41s519ms 41s519ms 21 12 1m1s 1m1s 22 19 1m1s 1m1s 23 22 11m23s 11m23s Oct 14 00 13 3m30s 3m30s 01 14 5m54s 5m54s 02 15 4m43s 4m43s 03 12 58s191ms 58s191ms 04 14 1m 1m 05 16 1m5s 1m5s 06 20 1m53s 1m52s 07 27 1m15s 1m15s 08 10 43s100ms 43s100ms 09 7 40s38ms 40s38ms 10 13 51s263ms 51s263ms 11 9 42s701ms 42s701ms 12 9 48s304ms 48s304ms 13 15 43s160ms 43s160ms 14 6 36s121ms 36s121ms 15 11 1h14m48s 1h14m48s 16 9 4m8s 4m8s 17 8 2h44m24s 2h44m24s 18 15 13m48s 13m47s 19 377 6s82ms 4s997ms 20 34 1m22s 1m22s 21 23 1m11s 1m11s 22 22 1m16s 1m16s 23 15 1m24s 1m24s Oct 15 00 16 1m1s 1m1s 01 17 1m 1m 02 10 1m 1m 03 5 28s909ms 28s909ms 04 15 55s701ms 55s701ms 05 19 1m4s 1m4s 06 26 1m36s 1m34s 07 21 1m34s 1m34s 08 21 37m58s 37m58s 09 17 43s872ms 43s872ms 10 14 54s845ms 54s845ms 11 16 12m19s 12m19s 12 15 57s823ms 57s823ms 13 15 1m2s 1m2s 14 14 57s481ms 57s481ms 15 15 59s191ms 59s191ms 16 16 55s229ms 55s229ms 17 12 2h12m52s 2h12m52s 18 12 17m11s 17m11s 19 327 7s940ms 6s622ms 20 79 23s206ms 23s206ms 21 7 48s257ms 48s257ms 22 13 1m9s 1m9s 23 11 54s581ms 54s581ms Oct 16 00 10 45s752ms 45s752ms 01 12 57s980ms 57s980ms 02 13 1m 1m 03 15 32m13s 32m13s 04 14 1m1s 1m1s 05 15 10m5s 10m5s 06 24 1m39s 1m39s 07 37 1m50s 1m48s 08 16 10m50s 10m50s 09 11 8m48s 8m48s 10 10 1m9s 1m9s 11 14 59s582ms 59s582ms 12 9 33s743ms 33s743ms 13 29 44s203ms 44s203ms 14 9 54s406ms 54s406ms 15 8 49s421ms 49s421ms 16 16 59s102ms 59s102ms 17 11 2h34m33s 2h34m33s 18 16 13m5s 13m5s 19 325 6s183ms 4s977ms 20 90 32s326ms 32s326ms 21 23 1m33s 1m33s 22 26 8m18s 8m18s 23 22 1m31s 1m31s Oct 17 00 13 1m13s 1m13s 01 7 34s696ms 34s696ms 02 10 51s986ms 51s986ms 03 13 58s199ms 58s199ms 04 10 53s475ms 53s475ms 05 9 48s248ms 48s248ms 06 33 1m29s 1m29s 07 17 1h10m10s 1h10m10s 08 14 1m6s 1m6s 09 17 1m 1m 10 13 52s404ms 52s404ms 11 22 12m8s 12m8s 12 20 34s580ms 34s580ms 13 15 54s832ms 54s832ms 14 14 52s407ms 52s407ms 15 15 49m4s 49m4s 16 14 7m55s 7m55s 17 9 13m40s 13m40s 18 23 3m30s 3m30s 19 3 97ms 97ms 20 7 25m10s 25m10s 21 4 48s734ms 48s734ms 22 10 52s294ms 52s294ms 23 12 53s372ms 53s372ms Oct 18 00 6 30m57s 30m53s 01 12 7m9s 7m9s 02 3 70ms 70ms 03 13 12m55s 12m55s 04 12 1m34s 1m34s 05 5 43s640ms 43s640ms 06 10 52s959ms 52s959ms 07 10 54s638ms 54s638ms 08 7 41s27ms 41s27ms 09 8 33s682ms 33s682ms 10 6 42s8ms 42s8ms 11 8 59m44s 59m44s 12 6 5m48s 5m48s 13 7 41s744ms 41s744ms 14 10 47s212ms 47s212ms 15 9 38s768ms 38s768ms 16 3 73ms 73ms 17 5 5h40m36s 5h40m36s 18 3 81ms 81ms 19 3 79ms 79ms 20 3 78ms 78ms 21 3 75ms 75ms 22 3 74ms 74ms 23 3 74ms 74ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-13 19:50:00 Date
Connections per database
Key values
- autotest_api_batch Main Database
- 3,407 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 3,407 connections Total
-
Sessions
Simultaneous sessions
Key values
- 80 sessions Session Peak
- 2025-10-18 17:50:22 Date
Histogram of session times
Key values
- 1,734 0-500ms duration
Sessions per database
Key values
- autotest_api_batch Main Database
- 3,409 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 3,409 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 3,409 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 385.43 MiB Temp Files size Peak
- 2025-10-15 19:42:53 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-14 19:36:42 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 12 00 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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.67 GiB 23.66 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 206 4.68 GiB 23.26 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 200 4.67 GiB 23.91 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 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.68 GiB 23.71 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 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 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 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 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 12 00 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 14 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 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 Oct 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 Oct 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 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3 Total read queries
- 136 Total write queries
Queries by database
Key values
- autotest_api_batch Main database
- 147 Requests
- 32m46s (autotest_api_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 148 Requests
User Request type Count Duration a3dsupervisor Total 148 33m10s ddl 88 18m29s delete 4 1m3s insert 4 23s629ms others 8 8m1s select 4 58s348ms tcl 39 4m6s update 1 7s292ms Duration by user
Key values
- 33m10s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 148 33m10s ddl 88 18m29s delete 4 1m3s insert 4 23s629ms others 8 8m1s select 4 58s348ms tcl 39 4m6s update 1 7s292ms Queries by host
Key values
- 10.3.0.4 Main host
- 148 Requests
- 33m10s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 96 Requests
- 26m31s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-15 00:22:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 90 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m17s VACUUM ANALYZE;[ Date: 2025-10-15 19:45:41 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m16s VACUUM ANALYZE;[ Date: 2025-10-14 19:42:00 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m12s VACUUM ANALYZE;[ Date: 2025-10-13 19:48:34 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m10s VACUUM ANALYZE;[ Date: 2025-10-16 19:47:32 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 59s446ms VACUUM ANALYSE;[ Date: 2025-10-16 19:49:20 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 45s877ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-15 19:42:54 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 44s908ms VACUUM ANALYSE;[ Date: 2025-10-13 19:49:26 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 43s754ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-14 19:37:27 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 43s51ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-16 19:45:33 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 40s318ms VACUUM ANALYSE;[ Date: 2025-10-15 19:46:30 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 40s177ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-14 19:39:44 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 40s95ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-13 19:46:31 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 39s816ms VACUUM ANALYSE;[ Date: 2025-10-14 19:42:48 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 32s811ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-16 19:43:13 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 28s619ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-13 19:44:16 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 25s466ms ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);[ Date: 2025-10-15 19:43:41 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 24s913ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-10-13 19:40:44 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 23s680ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-18 00:01:37 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 21s81ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-10-15 19:41:59 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 18s852ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2025-10-16 19:51:17 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m56s 4 1m10s 1m17s 1m14s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 21 1 1m12s 1m12s Oct 14 21 1 1m16s 1m16s Oct 15 21 1 1m17s 1m17s Oct 16 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 4m56s - Times executed: 4 ]
[ Application: psql - Total duration: 4m56s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-10-15 19:45:41 Duration: 1m17s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-14 19:42:00 Duration: 1m16s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 19:48:34 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 4m6s 39 5s22ms 13s72ms 6s322ms commit;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 08 5 28s4ms 5s600ms 09 6 43s981ms 7s330ms Oct 14 08 3 16s589ms 5s529ms 20 2 12s125ms 6s62ms Oct 15 08 8 48s89ms 6s11ms Oct 16 09 11 1m15s 6s830ms 20 2 12s170ms 6s85ms Oct 17 08 2 10s486ms 5s243ms [ User: a3dsupervisor - Total duration: 4m6s - Times executed: 39 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m6s - Times executed: 39 ]
-
COMMIT;
Date: 2025-10-13 07:00:16 Duration: 13s72ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-16 07:39:22 Duration: 9s48ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-16 07:39:22 Duration: 8s917ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 3m4s 4 39s816ms 59s446ms 46s122ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 21 1 44s908ms 44s908ms Oct 14 21 1 39s816ms 39s816ms Oct 15 21 1 40s318ms 40s318ms Oct 16 21 1 59s446ms 59s446ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 4 ]
[ Application: psql - Total duration: 3m4s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-10-16 19:49:20 Duration: 59s446ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-13 19:49:26 Duration: 44s908ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 19:46:30 Duration: 40s318ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 2m49s 4 40s95ms 45s877ms 42s300ms 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 #4
Day Hour Count Duration Avg duration Oct 13 21 1 40s95ms 40s95ms Oct 14 21 1 40s177ms 40s177ms Oct 15 21 1 45s877ms 45s877ms Oct 16 21 1 43s51ms 43s51ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 4 ]
[ Application: psql - Total duration: 2m49s - Times executed: 4 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 19:42:54 Duration: 45s877ms 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-10-16 19:45:33 Duration: 43s51ms 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-10-14 19:39:44 Duration: 40s177ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 2m1s 4 15s988ms 43s754ms 30s293ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 21 1 28s619ms 28s619ms Oct 14 21 1 43s754ms 43s754ms Oct 15 21 1 15s988ms 15s988ms Oct 16 21 1 32s811ms 32s811ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 4 ]
[ Application: psql - Total duration: 2m1s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 19:37:27 Duration: 43s754ms 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-10-16 19:43:13 Duration: 32s811ms 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-10-13 19:44:16 Duration: 28s619ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1m7s 4 12s256ms 21s81ms 16s896ms 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 Oct 13 21 1 16s189ms 16s189ms Oct 14 21 1 18s59ms 18s59ms Oct 15 21 1 21s81ms 21s81ms Oct 16 21 1 12s256ms 12s256ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 19:41:59 Duration: 21s81ms 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-10-14 19:38:54 Duration: 18s59ms 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-10-13 19:45:39 Duration: 16s189ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m6s 4 13s122ms 24s913ms 16s705ms 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 Oct 13 21 1 24s913ms 24s913ms Oct 14 21 1 15s486ms 15s486ms Oct 15 21 1 13s122ms 13s122ms Oct 16 21 1 13s300ms 13s300ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: psql - Total duration: 1m6s - 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-10-13 19:40:44 Duration: 24s913ms 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-10-14 19:34:20 Duration: 15s486ms 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-10-16 19:40:19 Duration: 13s300ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1m3s 4 12s654ms 18s852ms 15s775ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 21 1 18s212ms 18s212ms Oct 14 21 1 12s654ms 12s654ms Oct 15 21 1 13s380ms 13s380ms Oct 16 21 1 18s852ms 18s852ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-16 19:51:17 Duration: 18s852ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-13 19:51:07 Duration: 18s212ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 19:49:32 Duration: 13s380ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 57s739ms 4 6s980ms 18s534ms 14s434ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 21 1 15s538ms 15s538ms Oct 14 21 1 16s686ms 16s686ms Oct 15 21 1 18s534ms 18s534ms Oct 16 21 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 57s739ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s739ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-15 19:40:53 Duration: 18s534ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-14 19:37:55 Duration: 16s686ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-13 19:44:44 Duration: 15s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 55s335ms 4 12s403ms 15s495ms 13s833ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 21 1 12s403ms 12s403ms Oct 14 21 1 13s692ms 13s692ms Oct 15 21 1 15s495ms 15s495ms Oct 16 21 1 13s744ms 13s744ms [ User: a3dsupervisor - Total duration: 55s335ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s335ms - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 19:41:31 Duration: 15s495ms 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-10-16 19:44:15 Duration: 13s744ms 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-10-14 19:38:29 Duration: 13s692ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 52s350ms 4 11s468ms 16s389ms 13s87ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 21 1 11s977ms 11s977ms Oct 14 21 1 11s468ms 11s468ms Oct 15 21 1 12s515ms 12s515ms Oct 16 21 1 16s389ms 16s389ms [ User: a3dsupervisor - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 19:43:29 Duration: 16s389ms 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-10-15 19:40:35 Duration: 12s515ms 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-10-13 19:44:28 Duration: 11s977ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 47s98ms 4 10s728ms 14s114ms 11s774ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 21 1 10s963ms 10s963ms Oct 14 21 1 11s291ms 11s291ms Oct 15 21 1 14s114ms 14s114ms Oct 16 21 1 10s728ms 10s728ms [ User: a3dsupervisor - Total duration: 47s98ms - Times executed: 4 ]
[ Application: psql - Total duration: 47s98ms - 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-10-15 19:38:54 Duration: 14s114ms 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-10-14 19:35:46 Duration: 11s291ms 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-10-13 19:42:38 Duration: 10s963ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 45s46ms 4 9s264ms 14s692ms 11s261ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 21 1 11s734ms 11s734ms Oct 14 21 1 9s264ms 9s264ms Oct 15 21 1 14s692ms 14s692ms Oct 16 21 1 9s355ms 9s355ms [ User: a3dsupervisor - Total duration: 45s46ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s46ms - 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-10-15 19:39:42 Duration: 14s692ms 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-10-13 19:43:20 Duration: 11s734ms 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-10-16 19:42:20 Duration: 9s355ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 45s43ms 4 9s296ms 14s168ms 11s260ms 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 #14
Day Hour Count Duration Avg duration Oct 13 21 1 11s388ms 11s388ms Oct 14 21 1 10s190ms 10s190ms Oct 15 21 1 14s168ms 14s168ms Oct 16 21 1 9s296ms 9s296ms [ User: a3dsupervisor - Total duration: 45s43ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s43ms - 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-10-15 19:39:08 Duration: 14s168ms 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-10-13 19:42:50 Duration: 11s388ms 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-10-14 19:35:56 Duration: 10s190ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 39s417ms 4 5s828ms 14s723ms 9s854ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 21 1 14s723ms 14s723ms Oct 14 21 1 5s828ms 5s828ms Oct 15 21 1 11s787ms 11s787ms Oct 16 21 1 7s77ms 7s77ms [ User: a3dsupervisor - Total duration: 39s417ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s417ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-13 19:41:17 Duration: 14s723ms 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-10-15 19:37:30 Duration: 11s787ms 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-10-16 19:40:35 Duration: 7s77ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 39s135ms 4 8s217ms 12s415ms 9s783ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 21 1 8s217ms 8s217ms Oct 14 21 1 8s660ms 8s660ms Oct 15 21 1 12s415ms 12s415ms Oct 16 21 1 9s842ms 9s842ms [ User: a3dsupervisor - Total duration: 39s135ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s135ms - 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-10-15 19:39:20 Duration: 12s415ms 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-10-16 19:42:03 Duration: 9s842ms 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-10-14 19:36:05 Duration: 8s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 35s233ms 2 9s767ms 25s466ms 17s616ms alter table pe_consumption_10min add constraint pk_pe_consumption_10min primary key (consumption_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 21 1 9s767ms 9s767ms Oct 15 21 1 25s466ms 25s466ms [ User: a3dsupervisor - Total duration: 35s233ms - Times executed: 2 ]
[ Application: psql - Total duration: 35s233ms - Times executed: 2 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-15 19:43:41 Duration: 25s466ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-14 19:39:58 Duration: 9s767ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 34s349ms 4 7s357ms 10s75ms 8s587ms 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 #18
Day Hour Count Duration Avg duration Oct 13 21 1 10s75ms 10s75ms Oct 14 21 1 9s168ms 9s168ms Oct 15 21 1 7s357ms 7s357ms Oct 16 21 1 7s748ms 7s748ms [ User: a3dsupervisor - Total duration: 34s349ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s349ms - 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-10-13 19:43:08 Duration: 10s75ms 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-10-14 19:36:14 Duration: 9s168ms 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-10-16 19:42:11 Duration: 7s748ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 30s793ms 4 6s93ms 11s634ms 7s698ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 21 1 6s93ms 6s93ms Oct 14 21 1 6s366ms 6s366ms Oct 15 21 1 6s698ms 6s698ms Oct 16 21 1 11s634ms 11s634ms [ User: a3dsupervisor - Total duration: 30s793ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s793ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 19:43:59 Duration: 11s634ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-15 19:41:14 Duration: 6s698ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 19:38:12 Duration: 6s366ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 30s63ms 4 6s809ms 7s846ms 7s515ms 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 #20
Day Hour Count Duration Avg duration Oct 13 21 1 6s809ms 6s809ms Oct 14 21 1 7s796ms 7s796ms Oct 15 21 1 7s611ms 7s611ms Oct 16 21 1 7s846ms 7s846ms [ User: a3dsupervisor - Total duration: 30s63ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s63ms - 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-10-16 19:42:28 Duration: 7s846ms 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-10-14 19:36:31 Duration: 7s796ms 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-10-15 19:39:50 Duration: 7s611ms 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 39 4m6s 5s22ms 13s72ms 6s322ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 08 5 28s4ms 5s600ms 09 6 43s981ms 7s330ms Oct 14 08 3 16s589ms 5s529ms 20 2 12s125ms 6s62ms Oct 15 08 8 48s89ms 6s11ms Oct 16 09 11 1m15s 6s830ms 20 2 12s170ms 6s85ms Oct 17 08 2 10s486ms 5s243ms [ User: a3dsupervisor - Total duration: 4m6s - Times executed: 39 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4m6s - Times executed: 39 ]
-
COMMIT;
Date: 2025-10-13 07:00:16 Duration: 13s72ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-16 07:39:22 Duration: 9s48ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-16 07:39:22 Duration: 8s917ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4 4m56s 1m10s 1m17s 1m14s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 21 1 1m12s 1m12s Oct 14 21 1 1m16s 1m16s Oct 15 21 1 1m17s 1m17s Oct 16 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 4m56s - Times executed: 4 ]
[ Application: psql - Total duration: 4m56s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-10-15 19:45:41 Duration: 1m17s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-14 19:42:00 Duration: 1m16s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 19:48:34 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4 3m4s 39s816ms 59s446ms 46s122ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 21 1 44s908ms 44s908ms Oct 14 21 1 39s816ms 39s816ms Oct 15 21 1 40s318ms 40s318ms Oct 16 21 1 59s446ms 59s446ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 4 ]
[ Application: psql - Total duration: 3m4s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-10-16 19:49:20 Duration: 59s446ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-13 19:49:26 Duration: 44s908ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 19:46:30 Duration: 40s318ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 4 2m49s 40s95ms 45s877ms 42s300ms 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 #4
Day Hour Count Duration Avg duration Oct 13 21 1 40s95ms 40s95ms Oct 14 21 1 40s177ms 40s177ms Oct 15 21 1 45s877ms 45s877ms Oct 16 21 1 43s51ms 43s51ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 4 ]
[ Application: psql - Total duration: 2m49s - Times executed: 4 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 19:42:54 Duration: 45s877ms 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-10-16 19:45:33 Duration: 43s51ms 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-10-14 19:39:44 Duration: 40s177ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 4 2m1s 15s988ms 43s754ms 30s293ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 13 21 1 28s619ms 28s619ms Oct 14 21 1 43s754ms 43s754ms Oct 15 21 1 15s988ms 15s988ms Oct 16 21 1 32s811ms 32s811ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 4 ]
[ Application: psql - Total duration: 2m1s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 19:37:27 Duration: 43s754ms 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-10-16 19:43:13 Duration: 32s811ms 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-10-13 19:44:16 Duration: 28s619ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 4 1m7s 12s256ms 21s81ms 16s896ms 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 Oct 13 21 1 16s189ms 16s189ms Oct 14 21 1 18s59ms 18s59ms Oct 15 21 1 21s81ms 21s81ms Oct 16 21 1 12s256ms 12s256ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 19:41:59 Duration: 21s81ms 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-10-14 19:38:54 Duration: 18s59ms 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-10-13 19:45:39 Duration: 16s189ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 4 1m6s 13s122ms 24s913ms 16s705ms 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 Oct 13 21 1 24s913ms 24s913ms Oct 14 21 1 15s486ms 15s486ms Oct 15 21 1 13s122ms 13s122ms Oct 16 21 1 13s300ms 13s300ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: psql - Total duration: 1m6s - 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-10-13 19:40:44 Duration: 24s913ms 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-10-14 19:34:20 Duration: 15s486ms 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-10-16 19:40:19 Duration: 13s300ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 4 1m3s 12s654ms 18s852ms 15s775ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 21 1 18s212ms 18s212ms Oct 14 21 1 12s654ms 12s654ms Oct 15 21 1 13s380ms 13s380ms Oct 16 21 1 18s852ms 18s852ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-16 19:51:17 Duration: 18s852ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-13 19:51:07 Duration: 18s212ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 19:49:32 Duration: 13s380ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 4 57s739ms 6s980ms 18s534ms 14s434ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 21 1 15s538ms 15s538ms Oct 14 21 1 16s686ms 16s686ms Oct 15 21 1 18s534ms 18s534ms Oct 16 21 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 57s739ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s739ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-15 19:40:53 Duration: 18s534ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-14 19:37:55 Duration: 16s686ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-13 19:44:44 Duration: 15s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 4 55s335ms 12s403ms 15s495ms 13s833ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 21 1 12s403ms 12s403ms Oct 14 21 1 13s692ms 13s692ms Oct 15 21 1 15s495ms 15s495ms Oct 16 21 1 13s744ms 13s744ms [ User: a3dsupervisor - Total duration: 55s335ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s335ms - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 19:41:31 Duration: 15s495ms 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-10-16 19:44:15 Duration: 13s744ms 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-10-14 19:38:29 Duration: 13s692ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 4 52s350ms 11s468ms 16s389ms 13s87ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 21 1 11s977ms 11s977ms Oct 14 21 1 11s468ms 11s468ms Oct 15 21 1 12s515ms 12s515ms Oct 16 21 1 16s389ms 16s389ms [ User: a3dsupervisor - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 19:43:29 Duration: 16s389ms 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-10-15 19:40:35 Duration: 12s515ms 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-10-13 19:44:28 Duration: 11s977ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 4 47s98ms 10s728ms 14s114ms 11s774ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 21 1 10s963ms 10s963ms Oct 14 21 1 11s291ms 11s291ms Oct 15 21 1 14s114ms 14s114ms Oct 16 21 1 10s728ms 10s728ms [ User: a3dsupervisor - Total duration: 47s98ms - Times executed: 4 ]
[ Application: psql - Total duration: 47s98ms - 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-10-15 19:38:54 Duration: 14s114ms 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-10-14 19:35:46 Duration: 11s291ms 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-10-13 19:42:38 Duration: 10s963ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 4 45s46ms 9s264ms 14s692ms 11s261ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 21 1 11s734ms 11s734ms Oct 14 21 1 9s264ms 9s264ms Oct 15 21 1 14s692ms 14s692ms Oct 16 21 1 9s355ms 9s355ms [ User: a3dsupervisor - Total duration: 45s46ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s46ms - 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-10-15 19:39:42 Duration: 14s692ms 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-10-13 19:43:20 Duration: 11s734ms 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-10-16 19:42:20 Duration: 9s355ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 4 45s43ms 9s296ms 14s168ms 11s260ms 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 #14
Day Hour Count Duration Avg duration Oct 13 21 1 11s388ms 11s388ms Oct 14 21 1 10s190ms 10s190ms Oct 15 21 1 14s168ms 14s168ms Oct 16 21 1 9s296ms 9s296ms [ User: a3dsupervisor - Total duration: 45s43ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s43ms - 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-10-15 19:39:08 Duration: 14s168ms 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-10-13 19:42:50 Duration: 11s388ms 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-10-14 19:35:56 Duration: 10s190ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 4 39s417ms 5s828ms 14s723ms 9s854ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 21 1 14s723ms 14s723ms Oct 14 21 1 5s828ms 5s828ms Oct 15 21 1 11s787ms 11s787ms Oct 16 21 1 7s77ms 7s77ms [ User: a3dsupervisor - Total duration: 39s417ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s417ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-13 19:41:17 Duration: 14s723ms 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-10-15 19:37:30 Duration: 11s787ms 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-10-16 19:40:35 Duration: 7s77ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 4 39s135ms 8s217ms 12s415ms 9s783ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 21 1 8s217ms 8s217ms Oct 14 21 1 8s660ms 8s660ms Oct 15 21 1 12s415ms 12s415ms Oct 16 21 1 9s842ms 9s842ms [ User: a3dsupervisor - Total duration: 39s135ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s135ms - 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-10-15 19:39:20 Duration: 12s415ms 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-10-16 19:42:03 Duration: 9s842ms 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-10-14 19:36:05 Duration: 8s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 4 34s349ms 7s357ms 10s75ms 8s587ms 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 #17
Day Hour Count Duration Avg duration Oct 13 21 1 10s75ms 10s75ms Oct 14 21 1 9s168ms 9s168ms Oct 15 21 1 7s357ms 7s357ms Oct 16 21 1 7s748ms 7s748ms [ User: a3dsupervisor - Total duration: 34s349ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s349ms - 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-10-13 19:43:08 Duration: 10s75ms 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-10-14 19:36:14 Duration: 9s168ms 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-10-16 19:42:11 Duration: 7s748ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 4 30s793ms 6s93ms 11s634ms 7s698ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 21 1 6s93ms 6s93ms Oct 14 21 1 6s366ms 6s366ms Oct 15 21 1 6s698ms 6s698ms Oct 16 21 1 11s634ms 11s634ms [ User: a3dsupervisor - Total duration: 30s793ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s793ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 19:43:59 Duration: 11s634ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-15 19:41:14 Duration: 6s698ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 19:38:12 Duration: 6s366ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 4 30s63ms 6s809ms 7s846ms 7s515ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 21 1 6s809ms 6s809ms Oct 14 21 1 7s796ms 7s796ms Oct 15 21 1 7s611ms 7s611ms Oct 16 21 1 7s846ms 7s846ms [ User: a3dsupervisor - Total duration: 30s63ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s63ms - 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-10-16 19:42:28 Duration: 7s846ms 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-10-14 19:36:31 Duration: 7s796ms 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-10-15 19:39:50 Duration: 7s611ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 4 29s652ms 5s952ms 9s387ms 7s413ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 21 1 9s387ms 9s387ms Oct 14 21 1 6s151ms 6s151ms Oct 15 21 1 8s160ms 8s160ms Oct 16 21 1 5s952ms 5s952ms [ User: a3dsupervisor - Total duration: 29s652ms - Times executed: 4 ]
[ Application: psql - Total duration: 29s652ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-13 19:41:26 Duration: 9s387ms 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-10-15 19:37:38 Duration: 8s160ms 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-10-14 19:34:42 Duration: 6s151ms 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 1m10s 1m17s 1m14s 4 4m56s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 13 21 1 1m12s 1m12s Oct 14 21 1 1m16s 1m16s Oct 15 21 1 1m17s 1m17s Oct 16 21 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 4m56s - Times executed: 4 ]
[ Application: psql - Total duration: 4m56s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-10-15 19:45:41 Duration: 1m17s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-14 19:42:00 Duration: 1m16s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-13 19:48:34 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 39s816ms 59s446ms 46s122ms 4 3m4s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 13 21 1 44s908ms 44s908ms Oct 14 21 1 39s816ms 39s816ms Oct 15 21 1 40s318ms 40s318ms Oct 16 21 1 59s446ms 59s446ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 4 ]
[ Application: psql - Total duration: 3m4s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-10-16 19:49:20 Duration: 59s446ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-13 19:49:26 Duration: 44s908ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-15 19:46:30 Duration: 40s318ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 40s95ms 45s877ms 42s300ms 4 2m49s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 13 21 1 40s95ms 40s95ms Oct 14 21 1 40s177ms 40s177ms Oct 15 21 1 45s877ms 45s877ms Oct 16 21 1 43s51ms 43s51ms [ User: a3dsupervisor - Total duration: 2m49s - Times executed: 4 ]
[ Application: psql - Total duration: 2m49s - Times executed: 4 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-15 19:42:54 Duration: 45s877ms 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-10-16 19:45:33 Duration: 43s51ms 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-10-14 19:39:44 Duration: 40s177ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 15s988ms 43s754ms 30s293ms 4 2m1s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 13 21 1 28s619ms 28s619ms Oct 14 21 1 43s754ms 43s754ms Oct 15 21 1 15s988ms 15s988ms Oct 16 21 1 32s811ms 32s811ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 4 ]
[ Application: psql - Total duration: 2m1s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-14 19:37:27 Duration: 43s754ms 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-10-16 19:43:13 Duration: 32s811ms 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-10-13 19:44:16 Duration: 28s619ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 9s767ms 25s466ms 17s616ms 2 35s233ms alter table pe_consumption_10min add constraint pk_pe_consumption_10min primary key (consumption_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 21 1 9s767ms 9s767ms Oct 15 21 1 25s466ms 25s466ms [ User: a3dsupervisor - Total duration: 35s233ms - Times executed: 2 ]
[ Application: psql - Total duration: 35s233ms - Times executed: 2 ]
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-15 19:43:41 Duration: 25s466ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE pe_consumption_10min ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-10-14 19:39:58 Duration: 9s767ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 12s256ms 21s81ms 16s896ms 4 1m7s 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 Oct 13 21 1 16s189ms 16s189ms Oct 14 21 1 18s59ms 18s59ms Oct 15 21 1 21s81ms 21s81ms Oct 16 21 1 12s256ms 12s256ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-15 19:41:59 Duration: 21s81ms 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-10-14 19:38:54 Duration: 18s59ms 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-10-13 19:45:39 Duration: 16s189ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 13s122ms 24s913ms 16s705ms 4 1m6s 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 Oct 13 21 1 24s913ms 24s913ms Oct 14 21 1 15s486ms 15s486ms Oct 15 21 1 13s122ms 13s122ms Oct 16 21 1 13s300ms 13s300ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: psql - Total duration: 1m6s - 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-10-13 19:40:44 Duration: 24s913ms 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-10-14 19:34:20 Duration: 15s486ms 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-10-16 19:40:19 Duration: 13s300ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 12s654ms 18s852ms 15s775ms 4 1m3s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 13 21 1 18s212ms 18s212ms Oct 14 21 1 12s654ms 12s654ms Oct 15 21 1 13s380ms 13s380ms Oct 16 21 1 18s852ms 18s852ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-16 19:51:17 Duration: 18s852ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-13 19:51:07 Duration: 18s212ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-15 19:49:32 Duration: 13s380ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 6s980ms 18s534ms 14s434ms 4 57s739ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 13 21 1 15s538ms 15s538ms Oct 14 21 1 16s686ms 16s686ms Oct 15 21 1 18s534ms 18s534ms Oct 16 21 1 6s980ms 6s980ms [ User: a3dsupervisor - Total duration: 57s739ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s739ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-15 19:40:53 Duration: 18s534ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-14 19:37:55 Duration: 16s686ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-13 19:44:44 Duration: 15s538ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 12s403ms 15s495ms 13s833ms 4 55s335ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 13 21 1 12s403ms 12s403ms Oct 14 21 1 13s692ms 13s692ms Oct 15 21 1 15s495ms 15s495ms Oct 16 21 1 13s744ms 13s744ms [ User: a3dsupervisor - Total duration: 55s335ms - Times executed: 4 ]
[ Application: psql - Total duration: 55s335ms - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-15 19:41:31 Duration: 15s495ms 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-10-16 19:44:15 Duration: 13s744ms 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-10-14 19:38:29 Duration: 13s692ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 11s468ms 16s389ms 13s87ms 4 52s350ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 13 21 1 11s977ms 11s977ms Oct 14 21 1 11s468ms 11s468ms Oct 15 21 1 12s515ms 12s515ms Oct 16 21 1 16s389ms 16s389ms [ User: a3dsupervisor - Total duration: 52s350ms - Times executed: 4 ]
[ Application: psql - Total duration: 52s350ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-16 19:43:29 Duration: 16s389ms 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-10-15 19:40:35 Duration: 12s515ms 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-10-13 19:44:28 Duration: 11s977ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 10s728ms 14s114ms 11s774ms 4 47s98ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 13 21 1 10s963ms 10s963ms Oct 14 21 1 11s291ms 11s291ms Oct 15 21 1 14s114ms 14s114ms Oct 16 21 1 10s728ms 10s728ms [ User: a3dsupervisor - Total duration: 47s98ms - Times executed: 4 ]
[ Application: psql - Total duration: 47s98ms - 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-10-15 19:38:54 Duration: 14s114ms 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-10-14 19:35:46 Duration: 11s291ms 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-10-13 19:42:38 Duration: 10s963ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 9s264ms 14s692ms 11s261ms 4 45s46ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 13 21 1 11s734ms 11s734ms Oct 14 21 1 9s264ms 9s264ms Oct 15 21 1 14s692ms 14s692ms Oct 16 21 1 9s355ms 9s355ms [ User: a3dsupervisor - Total duration: 45s46ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s46ms - 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-10-15 19:39:42 Duration: 14s692ms 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-10-13 19:43:20 Duration: 11s734ms 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-10-16 19:42:20 Duration: 9s355ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 9s296ms 14s168ms 11s260ms 4 45s43ms 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 #14
Day Hour Count Duration Avg duration Oct 13 21 1 11s388ms 11s388ms Oct 14 21 1 10s190ms 10s190ms Oct 15 21 1 14s168ms 14s168ms Oct 16 21 1 9s296ms 9s296ms [ User: a3dsupervisor - Total duration: 45s43ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s43ms - 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-10-15 19:39:08 Duration: 14s168ms 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-10-13 19:42:50 Duration: 11s388ms 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-10-14 19:35:56 Duration: 10s190ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5s828ms 14s723ms 9s854ms 4 39s417ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 13 21 1 14s723ms 14s723ms Oct 14 21 1 5s828ms 5s828ms Oct 15 21 1 11s787ms 11s787ms Oct 16 21 1 7s77ms 7s77ms [ User: a3dsupervisor - Total duration: 39s417ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s417ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-13 19:41:17 Duration: 14s723ms 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-10-15 19:37:30 Duration: 11s787ms 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-10-16 19:40:35 Duration: 7s77ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 8s217ms 12s415ms 9s783ms 4 39s135ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 13 21 1 8s217ms 8s217ms Oct 14 21 1 8s660ms 8s660ms Oct 15 21 1 12s415ms 12s415ms Oct 16 21 1 9s842ms 9s842ms [ User: a3dsupervisor - Total duration: 39s135ms - Times executed: 4 ]
[ Application: psql - Total duration: 39s135ms - 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-10-15 19:39:20 Duration: 12s415ms 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-10-16 19:42:03 Duration: 9s842ms 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-10-14 19:36:05 Duration: 8s660ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 7s357ms 10s75ms 8s587ms 4 34s349ms 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 #17
Day Hour Count Duration Avg duration Oct 13 21 1 10s75ms 10s75ms Oct 14 21 1 9s168ms 9s168ms Oct 15 21 1 7s357ms 7s357ms Oct 16 21 1 7s748ms 7s748ms [ User: a3dsupervisor - Total duration: 34s349ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s349ms - 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-10-13 19:43:08 Duration: 10s75ms 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-10-14 19:36:14 Duration: 9s168ms 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-10-16 19:42:11 Duration: 7s748ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 6s93ms 11s634ms 7s698ms 4 30s793ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 13 21 1 6s93ms 6s93ms Oct 14 21 1 6s366ms 6s366ms Oct 15 21 1 6s698ms 6s698ms Oct 16 21 1 11s634ms 11s634ms [ User: a3dsupervisor - Total duration: 30s793ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s793ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-16 19:43:59 Duration: 11s634ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-15 19:41:14 Duration: 6s698ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-14 19:38:12 Duration: 6s366ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 6s809ms 7s846ms 7s515ms 4 30s63ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 13 21 1 6s809ms 6s809ms Oct 14 21 1 7s796ms 7s796ms Oct 15 21 1 7s611ms 7s611ms Oct 16 21 1 7s846ms 7s846ms [ User: a3dsupervisor - Total duration: 30s63ms - Times executed: 4 ]
[ Application: psql - Total duration: 30s63ms - 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-10-16 19:42:28 Duration: 7s846ms 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-10-14 19:36:31 Duration: 7s796ms 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-10-15 19:39:50 Duration: 7s611ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5s952ms 9s387ms 7s413ms 4 29s652ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 13 21 1 9s387ms 9s387ms Oct 14 21 1 6s151ms 6s151ms Oct 15 21 1 8s160ms 8s160ms Oct 16 21 1 5s952ms 5s952ms [ User: a3dsupervisor - Total duration: 29s652ms - Times executed: 4 ]
[ Application: psql - Total duration: 29s652ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-13 19:41:26 Duration: 9s387ms 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-10-15 19:37:38 Duration: 8s160ms 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-10-14 19:34:42 Duration: 6s151ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 37,489 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 26217 ERROR entries
- 64 WARNING entries
Most Frequent Errors/Events
Key values
- 16,814 Max number of times the same event was reported
- 26,281 Total events found
Rank Times reported Error 1 16,814 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 14 21 174 22 738 23 738 00 738 01 739 Oct 15 02 739 03 739 04 739 05 738 06 740 07 739 08 690 09 720 10 739 11 740 12 739 13 740 14 739 15 740 16 739 17 739 18 739 19 501 20 688 2 9,213 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 13 22 777 23 289 00 583 01 2 Oct 14 22 788 23 543 00 370 01 315 Oct 15 22 784 23 830 00 334 01 509 Oct 16 22 784 23 1,020 00 378 01 766 Oct 17 02 141 3 82 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 13 19 2 21 11 22 5 Oct 14 19 2 21 15 22 1 Oct 15 19 2 22 16 Oct 16 19 2 22 16 Oct 17 09 4 17 2 19 2 Oct 18 19 2 4 64 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 13 21 16 Oct 14 21 16 Oct 15 21 16 Oct 16 21 16 5 44 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 13 21 11 Oct 14 21 11 Oct 15 22 11 Oct 16 22 11 6 20 ERROR: function convert(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 13 22 5 Oct 14 21 4 22 1 Oct 15 22 5 Oct 16 22 5 7 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 #7
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 8 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 #8
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 9 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 #9
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 10 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 #10
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 11 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 #11
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 12 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 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 Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 14 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 15 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 #15
Day Hour Count Oct 13 21 1 Oct 14 21 1 Oct 15 21 1 Oct 16 21 1 16 3 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 #16
Day Hour Count Oct 13 08 1 Oct 15 20 2 17 3 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 13 21 1 Oct 15 21 1 Oct 16 21 1 18 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (...)
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 13 21 1 19 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 #19
Day Hour Count Oct 13 21 1