pgBadger-
Global information
- Generated on Mon Oct 6 09:36:25 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 26,980 log entries in 1m6s
- Log start from 2025-09-29 19:31:25 to 2025-10-04 17:00:56
-
Overview
Global Stats
- 43 Number of unique normalized queries
- 162 Number of queries
- 39m21s Total query duration
- 2025-09-29 06:12:50 First query
- 2025-10-03 19:52:03 Last query
- 2 queries/s at 2025-10-02 07:42:27 Query peak
- 39m21s Total query duration
- 47s60ms Prepare/parse total duration
- 33s265ms Bind total duration
- 38m Execute total duration
- 6,726 Number of events
- 19 Number of unique normalized events
- 6,404 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 1,046 Number temporary file
- 3.40 GiB Max size of temporary file
- 22.70 MiB Average size of temporary file
- 4,028 Total number of sessions
- 35 sessions at 2025-09-30 19:44:03 Session peak
- 12d7h43m55s Total duration of sessions
- 4m24s Average duration of sessions
- 0 Average queries per session
- 586ms Average queries duration per session
- 4m23s Average idle time per session
- 4,028 Total number of connections
- 11 connections/s at 2025-09-29 19:48:53 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-02 07:42:27 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-02 06:12:23 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-02 07:42:27 Date
Queries duration
Key values
- 39m21s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 29 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 3 0ms 6s503ms 5s748ms 5s140ms 5s600ms 6s503ms 07 2 0ms 14s401ms 9s961ms 0ms 5s521ms 14s401ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 5s154ms 5s154ms 0ms 5s154ms 5s154ms 19 25 0ms 1m12s 14s517ms 43s74ms 1m4s 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 Sep 30 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 2 0ms 5s914ms 5s873ms 0ms 5s833ms 5s914ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 5s836ms 5s836ms 0ms 5s836ms 5s836ms 19 27 0ms 1m26s 15s77ms 46s753ms 58s886ms 1m26s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 01 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 2 0ms 6s557ms 6s552ms 0ms 0ms 13s104ms 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 29 0ms 3m2s 19s886ms 56s864ms 1m27s 3m2s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 2 0ms 5s805ms 5s758ms 0ms 0ms 11s516ms 07 7 0ms 5s725ms 5s376ms 0ms 5s666ms 21s836ms 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 1m3s 13s536ms 51s45ms 52s459ms 1m3s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 2 0ms 5s513ms 5s503ms 0ms 0ms 11s7ms 07 3 0ms 10s401ms 7s87ms 0ms 10s401ms 10s861ms 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 30 0ms 56s93ms 14s253ms 56s93ms 56s482ms 1m3s 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 29 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 30 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 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 01 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 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 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 1 0 5s710ms 0ms 0ms 5s710ms 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 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 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 04 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 0 5s600ms 0ms 0ms 5s600ms 07 0 1 0 0 14s401ms 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 6s358ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 30 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 1 0 6s815ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 1 0 10s674ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 0 5s805ms 0ms 0ms 0ms 07 0 1 0 0 5s666ms 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 7s585ms 0ms 0ms 7s585ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 1 0 0 10s401ms 0ms 0ms 10s401ms 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 12s302ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 28 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 29 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 2 3 1.50 66.67% 07 0 2 2.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.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% Sep 30 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 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 1 1.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 01 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 1 2 2.00 50.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 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 2 7 3.50 28.57% 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 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 3 3.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 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 04 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 28 00 1 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 23 2 0.00/s Sep 29 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 17 0.00/s 06 19 0.01/s 07 26 0.01/s 08 24 0.01/s 09 18 0.01/s 10 11 0.00/s 11 23 0.01/s 12 15 0.00/s 13 25 0.01/s 14 8 0.00/s 15 19 0.01/s 16 11 0.00/s 17 14 0.00/s 18 17 0.00/s 19 374 0.10/s 20 31 0.01/s 21 18 0.01/s 22 9 0.00/s 23 17 0.00/s Sep 30 00 3 0.00/s 01 12 0.00/s 02 11 0.00/s 03 12 0.00/s 04 12 0.00/s 05 11 0.00/s 06 25 0.01/s 07 18 0.01/s 08 17 0.00/s 09 7 0.00/s 10 9 0.00/s 11 13 0.00/s 12 6 0.00/s 13 17 0.00/s 14 13 0.00/s 15 16 0.00/s 16 12 0.00/s 17 4 0.00/s 18 14 0.00/s 19 380 0.11/s 20 18 0.01/s 21 14 0.00/s 22 11 0.00/s 23 18 0.01/s Oct 01 00 16 0.00/s 01 15 0.00/s 02 16 0.00/s 03 15 0.00/s 04 10 0.00/s 05 13 0.00/s 06 22 0.01/s 07 21 0.01/s 08 15 0.00/s 09 13 0.00/s 10 18 0.01/s 11 14 0.00/s 12 15 0.00/s 13 22 0.01/s 14 13 0.00/s 15 16 0.00/s 16 6 0.00/s 17 13 0.00/s 18 11 0.00/s 19 374 0.10/s 20 31 0.01/s 21 24 0.01/s 22 15 0.00/s 23 13 0.00/s Oct 02 00 19 0.01/s 01 5 0.00/s 02 16 0.00/s 03 22 0.01/s 04 13 0.00/s 05 19 0.01/s 06 35 0.01/s 07 40 0.01/s 08 17 0.00/s 09 23 0.01/s 10 11 0.00/s 11 19 0.01/s 12 28 0.01/s 13 21 0.01/s 14 22 0.01/s 15 14 0.00/s 16 21 0.01/s 17 8 0.00/s 18 17 0.00/s 19 327 0.09/s 20 84 0.02/s 21 23 0.01/s 22 11 0.00/s 23 19 0.01/s Oct 03 00 13 0.00/s 01 14 0.00/s 02 18 0.01/s 03 12 0.00/s 04 14 0.00/s 05 20 0.01/s 06 30 0.01/s 07 28 0.01/s 08 12 0.00/s 09 19 0.01/s 10 13 0.00/s 11 8 0.00/s 12 15 0.00/s 13 5 0.00/s 14 19 0.01/s 15 25 0.01/s 16 7 0.00/s 17 7 0.00/s 18 19 0.01/s 19 357 0.10/s 20 61 0.02/s 21 13 0.00/s 22 14 0.00/s 23 22 0.01/s Oct 04 00 11 0.00/s 01 17 0.00/s 02 13 0.00/s 03 19 0.01/s 04 14 0.00/s 05 14 0.00/s 06 17 0.00/s 07 11 0.00/s 08 10 0.00/s 09 17 0.00/s 10 17 0.00/s 11 12 0.00/s 12 12 0.00/s 13 24 0.01/s 14 17 0.00/s 15 11 0.00/s 16 14 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 28 00 1 70ms 70ms 01 2 72ms 72ms 02 2 72ms 72ms 03 2 76ms 76ms 04 2 74ms 74ms 05 2 72ms 72ms 06 2 74ms 74ms 07 2 72ms 72ms 08 2 73ms 73ms 09 2 69ms 69ms 10 2 76ms 76ms 11 2 72ms 72ms 12 2 72ms 72ms 13 2 71ms 71ms 14 2 70ms 70ms 15 2 69ms 69ms 16 2 75ms 75ms 17 2 75ms 75ms 18 2 86ms 86ms 19 2 73ms 73ms 20 2 75ms 75ms 21 2 78ms 78ms 23 2 73ms 73ms Sep 29 00 2 72ms 72ms 01 2 73ms 73ms 02 2 69ms 69ms 03 2 76ms 76ms 04 2 73ms 73ms 05 15 2m12s 2m12s 06 18 1m9s 1m8s 07 24 1m16s 1m15s 08 27 58s132ms 58s132ms 09 18 57s810ms 57s810ms 10 11 58s385ms 58s385ms 11 23 1m12s 1m12s 12 15 54s452ms 54s452ms 13 25 1m2s 1m2s 14 8 57s225ms 57s225ms 15 17 1m8s 1m8s 16 13 1m8s 1m8s 17 14 1h39m1s 1h39m1s 18 19 11m27s 11m27s 19 368 6s710ms 5s723ms 20 35 1m1s 1m1s 21 18 1m22s 1m22s 22 9 59s36ms 59s36ms 23 14 1m10s 1m10s Sep 30 00 6 52s203ms 52s203ms 01 9 1m 1m 02 13 1m11s 1m11s 03 13 35m48s 35m48s 04 12 1m4s 1m4s 05 11 1m 1m 06 24 1m51s 1m50s 07 19 2m27s 2m27s 08 17 20m53s 20m53s 09 7 1m34s 1m34s 10 9 1m11s 1m11s 11 13 1m12s 1m12s 12 6 47s222ms 47s222ms 13 17 1m22s 1m22s 14 13 26m32s 26m32s 15 16 1m11s 1m11s 16 12 1m1s 1m1s 17 4 5h54m2s 5h54m2s 18 16 13m11s 13m11s 19 373 6s365ms 5s274ms 20 23 1m21s 1m21s 21 14 10m37s 10m37s 22 11 53s359ms 53s359ms 23 18 1m2s 1m2s Oct 01 00 16 1m5s 1m5s 01 15 16m39s 16m39s 02 16 1m52s 1m52s 03 15 57s690ms 57s690ms 04 10 1m3s 1m3s 05 13 1m1s 1m1s 06 21 1m41s 1m41s 07 22 2m8s 2m8s 08 15 1m 1m 09 13 54s702ms 54s702ms 10 18 1m2s 1m2s 11 14 58s441ms 58s441ms 12 15 53s79ms 53s79ms 13 22 1m3s 1m3s 14 13 1m1s 1m1s 15 16 54s859ms 54s859ms 16 6 40s406ms 40s406ms 17 13 2h47m55s 2h47m55s 18 13 16m14s 16m14s 19 372 7s891ms 6s341ms 20 31 42s657ms 42s657ms 21 24 1m11s 1m11s 22 15 1m12s 1m12s 23 13 1m6s 1m6s Oct 02 00 19 1m20s 1m20s 01 5 1m1s 1m1s 02 16 27m34s 27m34s 03 22 3m23s 3m23s 04 13 6m 6m 05 19 1m15s 1m15s 06 34 1m25s 1m25s 07 40 2m8s 2m7s 08 18 15m29s 15m29s 09 23 3m11s 3m11s 10 11 1m8s 1m8s 11 19 1m11s 1m11s 12 28 1m4s 1m4s 13 21 1m14s 1m14s 14 22 57s356ms 57s356ms 15 14 1m4s 1m4s 16 21 1m19s 1m19s 17 8 3h34m57s 3h34m57s 18 19 11m40s 11m40s 19 325 6s295ms 5s212ms 20 84 31s468ms 31s468ms 21 19 1m12s 1m12s 22 15 1m12s 1m12s 23 19 1m3s 1m3s Oct 03 00 13 1m6s 1m6s 01 14 1m6s 1m6s 02 18 1m 1m 03 12 56s869ms 56s869ms 04 14 1m11s 1m11s 05 20 30m18s 30m18s 06 29 1m30s 1m30s 07 29 1m47s 1m46s 08 12 1m10s 1m10s 09 19 52s234ms 52s234ms 10 13 1m12s 1m12s 11 8 53s864ms 53s864ms 12 11 1m 1m 13 9 47s931ms 47s931ms 14 19 56s904ms 56s904ms 15 25 1h11m3s 1h11m3s 16 7 8m15s 8m15s 17 7 23m57s 23m57s 18 21 10m28s 10m28s 19 352 6s975ms 5s760ms 20 64 38s507ms 38s507ms 21 13 10m43s 10m43s 22 14 2m19s 2m19s 23 18 1m3s 1m3s Oct 04 00 15 8m56s 8m56s 01 17 1m8s 1m8s 02 13 1m10s 1m10s 03 19 12m43s 12m43s 04 12 1m7s 1m7s 05 15 1m9s 1m9s 06 18 1m3s 1m3s 07 11 54s485ms 54s485ms 08 10 1m1s 1m1s 09 17 1m4s 1m4s 10 17 25m20s 25m20s 11 12 1m2s 1m2s 12 12 1m4s 1m4s 13 21 1m2s 1m2s 14 20 1m9s 1m9s 15 11 1m18s 1m18s 16 14 23m59s 23m59s 17 4 5h30m54s 5h30m54s 18 2 191ms 191ms 19 2 89ms 89ms 20 2 77ms 77ms 21 2 77ms 77ms 22 2 75ms 75ms 23 2 78ms 78ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-29 19:48:53 Date
Connections per database
Key values
- autotest_api_batch Main Database
- 4,028 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,028 connections Total
-
Sessions
Simultaneous sessions
Key values
- 35 sessions Session Peak
- 2025-09-30 19:44:03 Date
Histogram of session times
Key values
- 1,851 0-500ms duration
Sessions per database
Key values
- autotest_api_batch Main Database
- 4,028 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,028 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,028 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 385.41 MiB Temp Files size Peak
- 2025-10-03 19:47:02 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-09-29 19:39:45 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 23 0 0 0 Sep 29 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 205 4.62 GiB 23.06 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Sep 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 209 4.63 GiB 22.69 MiB 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 204 4.63 GiB 23.23 MiB 20 3 7.68 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 204 4.63 GiB 23.23 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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.63 GiB 23.04 MiB 20 5 12.81 MiB 2.56 MiB 21 0 0 0 22 0 0 0 23 0 0 0 Oct 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 23 0 0 Sep 29 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 30 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 01 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 02 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 11 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
- 1 Total read queries
- 151 Total write queries
Queries by database
Key values
- autotest_api_batch Main database
- 162 Requests
- 38m (autotest_api_batch)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 162 Requests
User Request type Count Duration a3dsupervisor Total 162 38m ddl 122 23m55s delete 5 43s737ms insert 2 11s406ms others 10 10m46s select 1 5s710ms tcl 19 1m46s update 3 30s468ms Duration by user
Key values
- 38m (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 162 38m ddl 122 23m55s delete 5 43s737ms insert 2 11s406ms others 10 10m46s select 1 5s710ms tcl 19 1m46s update 3 30s468ms Queries by host
Key values
- 10.3.0.4 Main host
- 162 Requests
- 38m (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- psql Main application
- 132 Requests
- 34m42s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-30 20:46:06 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 94 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 3m2s VACUUM ANALYZE;[ Date: 2025-10-01 19:44:49 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m26s VACUUM ANALYZE;[ Date: 2025-09-30 19:42:41 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m12s VACUUM ANALYZE;[ Date: 2025-09-29 19:47:28 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m3s VACUUM ANALYZE;[ Date: 2025-10-02 19:40:20 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 56s93ms VACUUM ANALYZE;[ Date: 2025-10-03 19:48:51 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 47s58ms VACUUM ANALYSE;[ Date: 2025-10-03 19:50:16 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 41s40ms CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);[ Date: 2025-10-01 19:38:02 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 40s54ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-03 19:47:02 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 38s710ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-30 19:40:31 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 37s883ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-10-02 19:38:21 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 37s835ms 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-01 19:40:58 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 35s928ms VACUUM ANALYSE;[ Date: 2025-09-29 19:48:12 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 35s60ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-01 19:38:47 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 34s864ms VACUUM ANALYSE;[ Date: 2025-10-01 19:45:31 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 34s438ms VACUUM ANALYSE;[ Date: 2025-10-02 19:41:10 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 34s229ms VACUUM ANALYSE;[ Date: 2025-09-30 19:43:21 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 33s471ms ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);[ Date: 2025-09-29 19:45:19 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 29s206ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-09-30 19:38:29 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 25s401ms CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);[ Date: 2025-10-01 19:34:17 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
20 25s384ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-02 19:36:10 - Database: autotest_api_batch - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 7m40s 5 56s93ms 3m2s 1m32s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 21 1 1m12s 1m12s Sep 30 21 1 1m26s 1m26s Oct 01 21 1 3m2s 3m2s Oct 02 21 1 1m3s 1m3s Oct 03 21 1 56s93ms 56s93ms [ User: a3dsupervisor - Total duration: 7m40s - Times executed: 5 ]
[ Application: psql - Total duration: 7m40s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-01 19:44:49 Duration: 3m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 19:42:41 Duration: 1m26s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-29 19:47:28 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 3m7s 5 33s471ms 40s54ms 37s590ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 21 1 33s471ms 33s471ms Sep 30 21 1 38s710ms 38s710ms Oct 01 21 1 37s835ms 37s835ms Oct 02 21 1 37s883ms 37s883ms Oct 03 21 1 40s54ms 40s54ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: psql - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 19:47:02 Duration: 40s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 19:40:31 Duration: 38s710ms 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-02 19:38:21 Duration: 37s883ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m6s 5 34s229ms 47s58ms 37s303ms vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 21 1 35s928ms 35s928ms Sep 30 21 1 34s229ms 34s229ms Oct 01 21 1 34s864ms 34s864ms Oct 02 21 1 34s438ms 34s438ms Oct 03 21 1 47s58ms 47s58ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 5 ]
[ Application: psql - Total duration: 3m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 19:50:16 Duration: 47s58ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 19:48:12 Duration: 35s928ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-01 19:45:31 Duration: 34s864ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 2m6s 5 16s495ms 35s60ms 25s309ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 21 1 16s495ms 16s495ms Sep 30 21 1 29s206ms 29s206ms Oct 01 21 1 35s60ms 35s60ms Oct 02 21 1 25s384ms 25s384ms Oct 03 21 1 20s398ms 20s398ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-01 19:38:47 Duration: 35s60ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 19:38:29 Duration: 29s206ms 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-02 19:36:10 Duration: 25s384ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 1m46s 19 5s36ms 6s557ms 5s623ms commit;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 08 2 11s644ms 5s822ms 09 1 5s521ms 5s521ms 20 1 5s154ms 5s154ms Sep 30 08 2 11s747ms 5s873ms 20 1 5s836ms 5s836ms Oct 01 09 2 13s104ms 6s552ms Oct 02 09 6 31s966ms 5s327ms Oct 03 08 2 11s7ms 5s503ms 09 2 10s861ms 5s430ms [ User: a3dsupervisor - Total duration: 1m46s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m46s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s557ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s546ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 06:23:12 Duration: 6s503ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 1m31s 5 9s806ms 25s401ms 18s315ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 21 1 15s581ms 15s581ms Sep 30 21 1 22s453ms 22s453ms Oct 01 21 1 25s401ms 25s401ms Oct 02 21 1 9s806ms 9s806ms Oct 03 21 1 18s335ms 18s335ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: psql - Total duration: 1m31s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-01 19:34:17 Duration: 25s401ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-30 19:34:53 Duration: 22s453ms 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-03 19:40:56 Duration: 18s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 1m18s 5 7s711ms 41s40ms 15s632ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 21 1 8s574ms 8s574ms Sep 30 21 1 12s379ms 12s379ms Oct 01 21 1 41s40ms 41s40ms Oct 02 21 1 7s711ms 7s711ms Oct 03 21 1 8s458ms 8s458ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-01 19:38:02 Duration: 41s40ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-30 19:37:52 Duration: 12s379ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-29 19:42:53 Duration: 8s574ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 1m13s 5 11s558ms 17s588ms 14s654ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 21 1 11s558ms 11s558ms Sep 30 21 1 14s27ms 14s27ms Oct 01 21 1 16s170ms 16s170ms Oct 02 21 1 13s928ms 13s928ms Oct 03 21 1 17s588ms 17s588ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-03 19:46:07 Duration: 17s588ms 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-01 19:40:06 Duration: 16s170ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-30 19:39:40 Duration: 14s27ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1m3s 5 9s619ms 15s633ms 12s795ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 21 1 13s231ms 13s231ms Sep 30 21 1 11s396ms 11s396ms Oct 01 21 1 9s619ms 9s619ms Oct 02 21 1 15s633ms 15s633ms Oct 03 21 1 14s97ms 14s97ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 19:37:06 Duration: 15s633ms 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-03 19:45:42 Duration: 14s97ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-29 19:44:12 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m3s 5 11s39ms 17s773ms 12s704ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 21 1 11s316ms 11s316ms Sep 30 21 1 11s793ms 11s793ms Oct 01 21 1 11s599ms 11s599ms Oct 02 21 1 11s39ms 11s39ms Oct 03 21 1 17s773ms 17s773ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-03 19:44:59 Duration: 17s773ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 19:38:41 Duration: 11s793ms 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-01 19:38:59 Duration: 11s599ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m2s 5 9s425ms 15s584ms 12s567ms 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 #11
Day Hour Count Duration Avg duration Sep 29 21 1 15s584ms 15s584ms Sep 30 21 1 12s349ms 12s349ms Oct 01 21 1 13s49ms 13s49ms Oct 02 21 1 9s425ms 9s425ms Oct 03 21 1 12s430ms 12s430ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-29 19:42:04 Duration: 15s584ms 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-01 19:36:35 Duration: 13s49ms 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-03 19:43:27 Duration: 12s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1m2s 5 8s959ms 16s953ms 12s562ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 21 1 12s419ms 12s419ms Sep 30 21 1 15s515ms 15s515ms Oct 01 21 1 8s959ms 8s959ms Oct 02 21 1 8s962ms 8s962ms Oct 03 21 1 16s953ms 16s953ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 19:41:35 Duration: 16s953ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-30 19:35:30 Duration: 15s515ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 19:40:26 Duration: 12s419ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 58s94ms 5 10s666ms 13s504ms 11s618ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 21 1 11s713ms 11s713ms Sep 30 21 1 10s997ms 10s997ms Oct 01 21 1 11s211ms 11s211ms Oct 02 21 1 10s666ms 10s666ms Oct 03 21 1 13s504ms 13s504ms [ User: a3dsupervisor - Total duration: 58s94ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s94ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-03 19:43:14 Duration: 13s504ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-29 19:41:48 Duration: 11s713ms 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-01 19:36:22 Duration: 11s211ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 56s214ms 5 6s553ms 13s890ms 11s242ms 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 #14
Day Hour Count Duration Avg duration Sep 29 21 1 11s631ms 11s631ms Sep 30 21 1 6s553ms 6s553ms Oct 01 21 1 13s666ms 13s666ms Oct 02 21 1 10s473ms 10s473ms Oct 03 21 1 13s890ms 13s890ms [ User: a3dsupervisor - Total duration: 56s214ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s214ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-03 19:43:51 Duration: 13s890ms 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-01 19:36:58 Duration: 13s666ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 19:42:28 Duration: 11s631ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 48s996ms 5 8s217ms 12s198ms 9s799ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 21 1 12s198ms 12s198ms Sep 30 21 1 8s913ms 8s913ms Oct 01 21 1 9s165ms 9s165ms Oct 02 21 1 8s217ms 8s217ms Oct 03 21 1 10s501ms 10s501ms [ User: a3dsupervisor - Total duration: 48s996ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s996ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:16 Duration: 12s198ms 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-03 19:43:37 Duration: 10s501ms 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-01 19:36:44 Duration: 9s165ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 46s980ms 5 6s792ms 11s691ms 9s396ms 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 #16
Day Hour Count Duration Avg duration Sep 29 21 1 9s523ms 9s523ms Sep 30 21 1 11s483ms 11s483ms Oct 01 21 1 11s691ms 11s691ms Oct 02 21 1 7s490ms 7s490ms Oct 03 21 1 6s792ms 6s792ms [ User: a3dsupervisor - Total duration: 46s980ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s980ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 19:37:10 Duration: 11s691ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-30 19:37:32 Duration: 11s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:37 Duration: 9s523ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 44s286ms 5 6s863ms 10s887ms 8s857ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 21 1 8s490ms 8s490ms Sep 30 21 1 6s863ms 6s863ms Oct 01 21 1 10s794ms 10s794ms Oct 02 21 1 7s250ms 7s250ms Oct 03 21 1 10s887ms 10s887ms [ User: a3dsupervisor - Total duration: 44s286ms - Times executed: 5 ]
[ Application: psql - Total duration: 44s286ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-03 19:41:46 Duration: 10s887ms 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-01 19:35:04 Duration: 10s794ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-29 19:40:35 Duration: 8s490ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 43s737ms 5 6s358ms 12s302ms 8s747ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 21 1 6s358ms 6s358ms Sep 30 21 1 6s815ms 6s815ms Oct 01 21 1 10s674ms 10s674ms Oct 02 21 1 7s585ms 7s585ms Oct 03 21 1 12s302ms 12s302ms [ User: a3dsupervisor - Total duration: 43s737ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s737ms - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-03 19:52:03 Duration: 12s302ms 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-01 19:47:51 Duration: 10s674ms 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-02 19:42:56 Duration: 7s585ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 38s690ms 5 6s678ms 9s989ms 7s738ms 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 Sep 29 21 1 6s678ms 6s678ms Sep 30 21 1 7s207ms 7s207ms Oct 01 21 1 9s989ms 9s989ms Oct 02 21 1 7s601ms 7s601ms Oct 03 21 1 7s213ms 7s213ms [ User: a3dsupervisor - Total duration: 38s690ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s690ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-10-01 19:37:20 Duration: 9s989ms 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-02 19:35:29 Duration: 7s601ms 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-03 19:44:05 Duration: 7s213ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 38s350ms 5 6s325ms 10s480ms 7s670ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 21 1 6s325ms 6s325ms Sep 30 21 1 8s136ms 8s136ms Oct 01 21 1 10s480ms 10s480ms Oct 02 21 1 6s988ms 6s988ms Oct 03 21 1 6s419ms 6s419ms [ User: a3dsupervisor - Total duration: 38s350ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s350ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-01 19:39:29 Duration: 10s480ms 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-09-30 19:39:06 Duration: 8s136ms 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-02 19:36:47 Duration: 6s988ms 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 19 1m46s 5s36ms 6s557ms 5s623ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 2 11s644ms 5s822ms 09 1 5s521ms 5s521ms 20 1 5s154ms 5s154ms Sep 30 08 2 11s747ms 5s873ms 20 1 5s836ms 5s836ms Oct 01 09 2 13s104ms 6s552ms Oct 02 09 6 31s966ms 5s327ms Oct 03 08 2 11s7ms 5s503ms 09 2 10s861ms 5s430ms [ User: a3dsupervisor - Total duration: 1m46s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m46s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s557ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s546ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 06:23:12 Duration: 6s503ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 7m40s 56s93ms 3m2s 1m32s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 21 1 1m12s 1m12s Sep 30 21 1 1m26s 1m26s Oct 01 21 1 3m2s 3m2s Oct 02 21 1 1m3s 1m3s Oct 03 21 1 56s93ms 56s93ms [ User: a3dsupervisor - Total duration: 7m40s - Times executed: 5 ]
[ Application: psql - Total duration: 7m40s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-01 19:44:49 Duration: 3m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 19:42:41 Duration: 1m26s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-29 19:47:28 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 3m7s 33s471ms 40s54ms 37s590ms alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 21 1 33s471ms 33s471ms Sep 30 21 1 38s710ms 38s710ms Oct 01 21 1 37s835ms 37s835ms Oct 02 21 1 37s883ms 37s883ms Oct 03 21 1 40s54ms 40s54ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: psql - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 19:47:02 Duration: 40s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 19:40:31 Duration: 38s710ms 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-02 19:38:21 Duration: 37s883ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 3m6s 34s229ms 47s58ms 37s303ms vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 21 1 35s928ms 35s928ms Sep 30 21 1 34s229ms 34s229ms Oct 01 21 1 34s864ms 34s864ms Oct 02 21 1 34s438ms 34s438ms Oct 03 21 1 47s58ms 47s58ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 5 ]
[ Application: psql - Total duration: 3m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 19:50:16 Duration: 47s58ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 19:48:12 Duration: 35s928ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-01 19:45:31 Duration: 34s864ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 5 2m6s 16s495ms 35s60ms 25s309ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 29 21 1 16s495ms 16s495ms Sep 30 21 1 29s206ms 29s206ms Oct 01 21 1 35s60ms 35s60ms Oct 02 21 1 25s384ms 25s384ms Oct 03 21 1 20s398ms 20s398ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-01 19:38:47 Duration: 35s60ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 19:38:29 Duration: 29s206ms 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-02 19:36:10 Duration: 25s384ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 5 1m31s 9s806ms 25s401ms 18s315ms create index i_fk_gtp_obj_compo_history_new_unit on gtp_history_obj_compo (obj_compo_new_unit_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 21 1 15s581ms 15s581ms Sep 30 21 1 22s453ms 22s453ms Oct 01 21 1 25s401ms 25s401ms Oct 02 21 1 9s806ms 9s806ms Oct 03 21 1 18s335ms 18s335ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: psql - Total duration: 1m31s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-01 19:34:17 Duration: 25s401ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-30 19:34:53 Duration: 22s453ms 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-03 19:40:56 Duration: 18s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 1m18s 7s711ms 41s40ms 15s632ms create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 21 1 8s574ms 8s574ms Sep 30 21 1 12s379ms 12s379ms Oct 01 21 1 41s40ms 41s40ms Oct 02 21 1 7s711ms 7s711ms Oct 03 21 1 8s458ms 8s458ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-01 19:38:02 Duration: 41s40ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-30 19:37:52 Duration: 12s379ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-29 19:42:53 Duration: 8s574ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 1m13s 11s558ms 17s588ms 14s654ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 21 1 11s558ms 11s558ms Sep 30 21 1 14s27ms 14s27ms Oct 01 21 1 16s170ms 16s170ms Oct 02 21 1 13s928ms 13s928ms Oct 03 21 1 17s588ms 17s588ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-03 19:46:07 Duration: 17s588ms 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-01 19:40:06 Duration: 16s170ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-30 19:39:40 Duration: 14s27ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 5 1m3s 9s619ms 15s633ms 12s795ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 21 1 13s231ms 13s231ms Sep 30 21 1 11s396ms 11s396ms Oct 01 21 1 9s619ms 9s619ms Oct 02 21 1 15s633ms 15s633ms Oct 03 21 1 14s97ms 14s97ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 19:37:06 Duration: 15s633ms 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-03 19:45:42 Duration: 14s97ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-29 19:44:12 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 5 1m3s 11s39ms 17s773ms 12s704ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 21 1 11s316ms 11s316ms Sep 30 21 1 11s793ms 11s793ms Oct 01 21 1 11s599ms 11s599ms Oct 02 21 1 11s39ms 11s39ms Oct 03 21 1 17s773ms 17s773ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-03 19:44:59 Duration: 17s773ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 19:38:41 Duration: 11s793ms 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-01 19:38:59 Duration: 11s599ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m2s 9s425ms 15s584ms 12s567ms 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 #11
Day Hour Count Duration Avg duration Sep 29 21 1 15s584ms 15s584ms Sep 30 21 1 12s349ms 12s349ms Oct 01 21 1 13s49ms 13s49ms Oct 02 21 1 9s425ms 9s425ms Oct 03 21 1 12s430ms 12s430ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-29 19:42:04 Duration: 15s584ms 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-01 19:36:35 Duration: 13s49ms 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-03 19:43:27 Duration: 12s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m2s 8s959ms 16s953ms 12s562ms create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 21 1 12s419ms 12s419ms Sep 30 21 1 15s515ms 15s515ms Oct 01 21 1 8s959ms 8s959ms Oct 02 21 1 8s962ms 8s962ms Oct 03 21 1 16s953ms 16s953ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 19:41:35 Duration: 16s953ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-30 19:35:30 Duration: 15s515ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 19:40:26 Duration: 12s419ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 5 58s94ms 10s666ms 13s504ms 11s618ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 21 1 11s713ms 11s713ms Sep 30 21 1 10s997ms 10s997ms Oct 01 21 1 11s211ms 11s211ms Oct 02 21 1 10s666ms 10s666ms Oct 03 21 1 13s504ms 13s504ms [ User: a3dsupervisor - Total duration: 58s94ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s94ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-03 19:43:14 Duration: 13s504ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-29 19:41:48 Duration: 11s713ms 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-01 19:36:22 Duration: 11s211ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 56s214ms 6s553ms 13s890ms 11s242ms 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 #14
Day Hour Count Duration Avg duration Sep 29 21 1 11s631ms 11s631ms Sep 30 21 1 6s553ms 6s553ms Oct 01 21 1 13s666ms 13s666ms Oct 02 21 1 10s473ms 10s473ms Oct 03 21 1 13s890ms 13s890ms [ User: a3dsupervisor - Total duration: 56s214ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s214ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-03 19:43:51 Duration: 13s890ms 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-01 19:36:58 Duration: 13s666ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 19:42:28 Duration: 11s631ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 48s996ms 8s217ms 12s198ms 9s799ms create index i_gtp_obj_rel_vt_ntt_p on gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 21 1 12s198ms 12s198ms Sep 30 21 1 8s913ms 8s913ms Oct 01 21 1 9s165ms 9s165ms Oct 02 21 1 8s217ms 8s217ms Oct 03 21 1 10s501ms 10s501ms [ User: a3dsupervisor - Total duration: 48s996ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s996ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:16 Duration: 12s198ms 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-03 19:43:37 Duration: 10s501ms 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-01 19:36:44 Duration: 9s165ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 46s980ms 6s792ms 11s691ms 9s396ms 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 #16
Day Hour Count Duration Avg duration Sep 29 21 1 9s523ms 9s523ms Sep 30 21 1 11s483ms 11s483ms Oct 01 21 1 11s691ms 11s691ms Oct 02 21 1 7s490ms 7s490ms Oct 03 21 1 6s792ms 6s792ms [ User: a3dsupervisor - Total duration: 46s980ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s980ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 19:37:10 Duration: 11s691ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-30 19:37:32 Duration: 11s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:37 Duration: 9s523ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 44s286ms 6s863ms 10s887ms 8s857ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 21 1 8s490ms 8s490ms Sep 30 21 1 6s863ms 6s863ms Oct 01 21 1 10s794ms 10s794ms Oct 02 21 1 7s250ms 7s250ms Oct 03 21 1 10s887ms 10s887ms [ User: a3dsupervisor - Total duration: 44s286ms - Times executed: 5 ]
[ Application: psql - Total duration: 44s286ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-03 19:41:46 Duration: 10s887ms 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-01 19:35:04 Duration: 10s794ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-29 19:40:35 Duration: 8s490ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 43s737ms 6s358ms 12s302ms 8s747ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 21 1 6s358ms 6s358ms Sep 30 21 1 6s815ms 6s815ms Oct 01 21 1 10s674ms 10s674ms Oct 02 21 1 7s585ms 7s585ms Oct 03 21 1 12s302ms 12s302ms [ User: a3dsupervisor - Total duration: 43s737ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s737ms - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-03 19:52:03 Duration: 12s302ms 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-01 19:47:51 Duration: 10s674ms 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-02 19:42:56 Duration: 7s585ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 5 38s690ms 6s678ms 9s989ms 7s738ms 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 Sep 29 21 1 6s678ms 6s678ms Sep 30 21 1 7s207ms 7s207ms Oct 01 21 1 9s989ms 9s989ms Oct 02 21 1 7s601ms 7s601ms Oct 03 21 1 7s213ms 7s213ms [ User: a3dsupervisor - Total duration: 38s690ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s690ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-10-01 19:37:20 Duration: 9s989ms 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-02 19:35:29 Duration: 7s601ms 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-03 19:44:05 Duration: 7s213ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 38s350ms 6s325ms 10s480ms 7s670ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 21 1 6s325ms 6s325ms Sep 30 21 1 8s136ms 8s136ms Oct 01 21 1 10s480ms 10s480ms Oct 02 21 1 6s988ms 6s988ms Oct 03 21 1 6s419ms 6s419ms [ User: a3dsupervisor - Total duration: 38s350ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s350ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-01 19:39:29 Duration: 10s480ms 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-09-30 19:39:06 Duration: 8s136ms 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-02 19:36:47 Duration: 6s988ms 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 56s93ms 3m2s 1m32s 5 7m40s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 21 1 1m12s 1m12s Sep 30 21 1 1m26s 1m26s Oct 01 21 1 3m2s 3m2s Oct 02 21 1 1m3s 1m3s Oct 03 21 1 56s93ms 56s93ms [ User: a3dsupervisor - Total duration: 7m40s - Times executed: 5 ]
[ Application: psql - Total duration: 7m40s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-01 19:44:49 Duration: 3m2s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-30 19:42:41 Duration: 1m26s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-29 19:47:28 Duration: 1m12s Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 33s471ms 40s54ms 37s590ms 5 3m7s alter table gtp_obj_rel_vt add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 21 1 33s471ms 33s471ms Sep 30 21 1 38s710ms 38s710ms Oct 01 21 1 37s835ms 37s835ms Oct 02 21 1 37s883ms 37s883ms Oct 03 21 1 40s54ms 40s54ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: psql - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-10-03 19:47:02 Duration: 40s54ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_rel_vt ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-30 19:40:31 Duration: 38s710ms 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-02 19:38:21 Duration: 37s883ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 34s229ms 47s58ms 37s303ms 5 3m6s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 21 1 35s928ms 35s928ms Sep 30 21 1 34s229ms 34s229ms Oct 01 21 1 34s864ms 34s864ms Oct 02 21 1 34s438ms 34s438ms Oct 03 21 1 47s58ms 47s58ms [ User: a3dsupervisor - Total duration: 3m6s - Times executed: 5 ]
[ Application: psql - Total duration: 3m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-03 19:50:16 Duration: 47s58ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-29 19:48:12 Duration: 35s928ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-01 19:45:31 Duration: 34s864ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 16s495ms 35s60ms 25s309ms 5 2m6s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 29 21 1 16s495ms 16s495ms Sep 30 21 1 29s206ms 29s206ms Oct 01 21 1 35s60ms 35s60ms Oct 02 21 1 25s384ms 25s384ms Oct 03 21 1 20s398ms 20s398ms [ User: a3dsupervisor - Total duration: 2m6s - Times executed: 5 ]
[ Application: psql - Total duration: 2m6s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-01 19:38:47 Duration: 35s60ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-30 19:38:29 Duration: 29s206ms 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-02 19:36:10 Duration: 25s384ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 9s806ms 25s401ms 18s315ms 5 1m31s 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 #5
Day Hour Count Duration Avg duration Sep 29 21 1 15s581ms 15s581ms Sep 30 21 1 22s453ms 22s453ms Oct 01 21 1 25s401ms 25s401ms Oct 02 21 1 9s806ms 9s806ms Oct 03 21 1 18s335ms 18s335ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 5 ]
[ Application: psql - Total duration: 1m31s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-10-01 19:34:17 Duration: 25s401ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-30 19:34:53 Duration: 22s453ms 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-03 19:40:56 Duration: 18s335ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 7s711ms 41s40ms 15s632ms 5 1m18s create index i_history_compo_action on gtp_history_obj_compo (action_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 29 21 1 8s574ms 8s574ms Sep 30 21 1 12s379ms 12s379ms Oct 01 21 1 41s40ms 41s40ms Oct 02 21 1 7s711ms 7s711ms Oct 03 21 1 8s458ms 8s458ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-10-01 19:38:02 Duration: 41s40ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-30 19:37:52 Duration: 12s379ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_action ON gtp_history_obj_compo (action_num_id);
Date: 2025-09-29 19:42:53 Duration: 8s574ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 11s558ms 17s588ms 14s654ms 5 1m13s 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 #7
Day Hour Count Duration Avg duration Sep 29 21 1 11s558ms 11s558ms Sep 30 21 1 14s27ms 14s27ms Oct 01 21 1 16s170ms 16s170ms Oct 02 21 1 13s928ms 13s928ms Oct 03 21 1 17s588ms 17s588ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 5 ]
[ Application: psql - Total duration: 1m13s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-10-03 19:46:07 Duration: 17s588ms 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-01 19:40:06 Duration: 16s170ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-30 19:39:40 Duration: 14s27ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 9s619ms 15s633ms 12s795ms 5 1m3s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 21 1 13s231ms 13s231ms Sep 30 21 1 11s396ms 11s396ms Oct 01 21 1 9s619ms 9s619ms Oct 02 21 1 15s633ms 15s633ms Oct 03 21 1 14s97ms 14s97ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-02 19:37:06 Duration: 15s633ms 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-03 19:45:42 Duration: 14s97ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-29 19:44:12 Duration: 13s231ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 11s39ms 17s773ms 12s704ms 5 1m3s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 21 1 11s316ms 11s316ms Sep 30 21 1 11s793ms 11s793ms Oct 01 21 1 11s599ms 11s599ms Oct 02 21 1 11s39ms 11s39ms Oct 03 21 1 17s773ms 17s773ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 5 ]
[ Application: psql - Total duration: 1m3s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-03 19:44:59 Duration: 17s773ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-30 19:38:41 Duration: 11s793ms 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-01 19:38:59 Duration: 11s599ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 9s425ms 15s584ms 12s567ms 5 1m2s 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 #10
Day Hour Count Duration Avg duration Sep 29 21 1 15s584ms 15s584ms Sep 30 21 1 12s349ms 12s349ms Oct 01 21 1 13s49ms 13s49ms Oct 02 21 1 9s425ms 9s425ms Oct 03 21 1 12s430ms 12s430ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt ON gtp_obj_rel_vt (node_tree_type_num_id, view_template_num_id);
Date: 2025-09-29 19:42:04 Duration: 15s584ms 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-01 19:36:35 Duration: 13s49ms 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-03 19:43:27 Duration: 12s430ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 8s959ms 16s953ms 12s562ms 5 1m2s create index i_fk_gtp_obj_rel_vt_rel on gtp_obj_rel_vt (relation_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 29 21 1 12s419ms 12s419ms Sep 30 21 1 15s515ms 15s515ms Oct 01 21 1 8s959ms 8s959ms Oct 02 21 1 8s962ms 8s962ms Oct 03 21 1 16s953ms 16s953ms [ User: a3dsupervisor - Total duration: 1m2s - Times executed: 5 ]
[ Application: psql - Total duration: 1m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-10-03 19:41:35 Duration: 16s953ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-30 19:35:30 Duration: 15s515ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_rel ON gtp_obj_rel_vt (relation_num_id);
Date: 2025-09-29 19:40:26 Duration: 12s419ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 10s666ms 13s504ms 11s618ms 5 58s94ms 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 Sep 29 21 1 11s713ms 11s713ms Sep 30 21 1 10s997ms 10s997ms Oct 01 21 1 11s211ms 11s211ms Oct 02 21 1 10s666ms 10s666ms Oct 03 21 1 13s504ms 13s504ms [ User: a3dsupervisor - Total duration: 58s94ms - Times executed: 5 ]
[ Application: psql - Total duration: 58s94ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-03 19:43:14 Duration: 13s504ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-29 19:41:48 Duration: 11s713ms 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-01 19:36:22 Duration: 11s211ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 6s553ms 13s890ms 11s242ms 5 56s214ms 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 #13
Day Hour Count Duration Avg duration Sep 29 21 1 11s631ms 11s631ms Sep 30 21 1 6s553ms 6s553ms Oct 01 21 1 13s666ms 13s666ms Oct 02 21 1 10s473ms 10s473ms Oct 03 21 1 13s890ms 13s890ms [ User: a3dsupervisor - Total duration: 56s214ms - Times executed: 5 ]
[ Application: psql - Total duration: 56s214ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-10-03 19:43:51 Duration: 13s890ms 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-01 19:36:58 Duration: 13s666ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_obj_vt ON gtp_obj_rel_vt (obj_num_id, view_template_num_id);
Date: 2025-09-29 19:42:28 Duration: 11s631ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 8s217ms 12s198ms 9s799ms 5 48s996ms 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 #14
Day Hour Count Duration Avg duration Sep 29 21 1 12s198ms 12s198ms Sep 30 21 1 8s913ms 8s913ms Oct 01 21 1 9s165ms 9s165ms Oct 02 21 1 8s217ms 8s217ms Oct 03 21 1 10s501ms 10s501ms [ User: a3dsupervisor - Total duration: 48s996ms - Times executed: 5 ]
[ Application: psql - Total duration: 48s996ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_ntt_p ON gtp_obj_rel_vt (node_tree_type_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:16 Duration: 12s198ms 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-03 19:43:37 Duration: 10s501ms 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-01 19:36:44 Duration: 9s165ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 6s792ms 11s691ms 9s396ms 5 46s980ms create index i_gtp_obj_rel_vt_objp_vt on gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 21 1 9s523ms 9s523ms Sep 30 21 1 11s483ms 11s483ms Oct 01 21 1 11s691ms 11s691ms Oct 02 21 1 7s490ms 7s490ms Oct 03 21 1 6s792ms 6s792ms [ User: a3dsupervisor - Total duration: 46s980ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s980ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-10-01 19:37:10 Duration: 11s691ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-30 19:37:32 Duration: 11s483ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_rel_vt_objp_vt ON gtp_obj_rel_vt (obj_num_id_p, view_template_num_id);
Date: 2025-09-29 19:42:37 Duration: 9s523ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 6s863ms 10s887ms 8s857ms 5 44s286ms create index i_fk_gtp_obj_rel_vt_relt on gtp_obj_rel_vt (rel_template_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 21 1 8s490ms 8s490ms Sep 30 21 1 6s863ms 6s863ms Oct 01 21 1 10s794ms 10s794ms Oct 02 21 1 7s250ms 7s250ms Oct 03 21 1 10s887ms 10s887ms [ User: a3dsupervisor - Total duration: 44s286ms - Times executed: 5 ]
[ Application: psql - Total duration: 44s286ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-10-03 19:41:46 Duration: 10s887ms 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-01 19:35:04 Duration: 10s794ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_fk_gtp_obj_rel_vt_relt ON gtp_obj_rel_vt (rel_template_num_id);
Date: 2025-09-29 19:40:35 Duration: 8s490ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 6s358ms 12s302ms 8s747ms 5 43s737ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 21 1 6s358ms 6s358ms Sep 30 21 1 6s815ms 6s815ms Oct 01 21 1 10s674ms 10s674ms Oct 02 21 1 7s585ms 7s585ms Oct 03 21 1 12s302ms 12s302ms [ User: a3dsupervisor - Total duration: 43s737ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s737ms - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-03 19:52:03 Duration: 12s302ms 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-01 19:47:51 Duration: 10s674ms 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-02 19:42:56 Duration: 7s585ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 6s678ms 9s989ms 7s738ms 5 38s690ms create index i_gtp_obj_rel_vt_objt_vt on gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 21 1 6s678ms 6s678ms Sep 30 21 1 7s207ms 7s207ms Oct 01 21 1 9s989ms 9s989ms Oct 02 21 1 7s601ms 7s601ms Oct 03 21 1 7s213ms 7s213ms [ User: a3dsupervisor - Total duration: 38s690ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s690ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_rel_vt_objt_vt ON gtp_obj_rel_vt (obj_template_num_id, view_template_num_id);
Date: 2025-10-01 19:37:20 Duration: 9s989ms 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-02 19:35:29 Duration: 7s601ms 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-03 19:44:05 Duration: 7s213ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 6s325ms 10s480ms 7s670ms 5 38s350ms 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 Sep 29 21 1 6s325ms 6s325ms Sep 30 21 1 8s136ms 8s136ms Oct 01 21 1 10s480ms 10s480ms Oct 02 21 1 6s988ms 6s988ms Oct 03 21 1 6s419ms 6s419ms [ User: a3dsupervisor - Total duration: 38s350ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s350ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-01 19:39:29 Duration: 10s480ms 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-09-30 19:39:06 Duration: 8s136ms 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-02 19:36:47 Duration: 6s988ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5s36ms 6s557ms 5s623ms 19 1m46s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 2 11s644ms 5s822ms 09 1 5s521ms 5s521ms 20 1 5s154ms 5s154ms Sep 30 08 2 11s747ms 5s873ms 20 1 5s836ms 5s836ms Oct 01 09 2 13s104ms 6s552ms Oct 02 09 6 31s966ms 5s327ms Oct 03 08 2 11s7ms 5s503ms 09 2 10s861ms 5s430ms [ User: a3dsupervisor - Total duration: 1m46s - Times executed: 19 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m46s - Times executed: 19 ]
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s557ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-01 07:02:05 Duration: 6s546ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 06:23:12 Duration: 6s503ms Database: autotest_api_batch User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5s700ms 1 5s700ms 5s700ms 5s700ms select 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 = $1;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 04 09 1 5s700ms 5s700ms [ User: a3dsupervisor - Total duration: 5s666ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s666ms - Times executed: 1 ]
-
select 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 = $1;
Date: 2025-10-02 07:46:35 Duration: 5s700ms Database: autotest_api_batch User: autotest_api_batch Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 20,092 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 6646 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 6,404 Max number of times the same event was reported
- 6,726 Total events found
Rank Times reported Error 1 6,404 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 29 22 834 23 193 Sep 30 22 779 23 755 Oct 01 22 831 23 245 00 2 Oct 02 21 179 22 645 23 546 00 53 Oct 03 06 1 22 826 23 466 00 49 2 101 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 29 19 2 21 11 22 5 Sep 30 19 2 21 16 Oct 01 19 5 21 12 22 4 Oct 02 19 5 22 16 Oct 03 17 4 19 2 22 15 Oct 04 19 2 3 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 29 21 16 Sep 30 21 16 Oct 01 21 16 Oct 02 21 16 Oct 03 21 16 4 55 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 29 21 11 Sep 30 21 11 Oct 01 21 11 Oct 02 22 11 Oct 03 22 11 5 25 ERROR: function convert(...) does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 29 22 5 Sep 30 21 5 Oct 01 21 1 22 4 Oct 02 22 5 Oct 03 22 5 6 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 7 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 8 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 9 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 10 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 11 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 12 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 13 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 14 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 15 5 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 02 21 1 Oct 03 21 1 16 4 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 01 20 2 Oct 02 09 2 17 4 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 #17
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 1 Oct 03 21 1 18 2 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 #18
Day Hour Count Sep 30 21 1 Oct 01 21 1 19 1 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
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 02 09 1