pgBadger-
Global information
- Generated on Mon Oct 27 09:36:39 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=25/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=25/h=23/m=00/PT1H.log
- Parsed 56,620 log entries in 1m40s
- Log start from 2025-10-20 06:13:01 to 2025-10-25 17:01:35
-
Overview
Global Stats
- 46 Number of unique normalized queries
- 216 Number of queries
- 47m45s Total query duration
- 2025-10-20 06:23:13 First query
- 2025-10-24 20:33:17 Last query
- 5 queries/s at 2025-10-23 06:59:16 Query peak
- 47m45s Total query duration
- 43s1ms Prepare/parse total duration
- 47s297ms Bind total duration
- 46m15s Execute total duration
- 13,854 Number of events
- 24 Number of unique normalized events
- 13,609 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,012 Number temporary file
- 2.37 GiB Max size of temporary file
- 16.63 MiB Average size of temporary file
- 9,150 Total number of sessions
- 89 sessions at 2025-10-19 16:52:09 Session peak
- 25d5h17m12s Total duration of sessions
- 3m58s Average duration of sessions
- 0 Average queries per session
- 313ms Average queries duration per session
- 3m57s Average idle time per session
- 9,139 Total number of connections
- 11 connections/s at 2025-10-22 06:27:53 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2025-10-23 06:59:16 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-10-22 06:57:14 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2025-10-24 07:05:43 Date
Queries duration
Key values
- 47m45s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 19 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Oct 20 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 28 0ms 1m15s 15s153ms 51s844ms 54s697ms 1m15s 07 4 0ms 18s128ms 8s659ms 0ms 5s989ms 18s128ms 08 1 0ms 6s91ms 6s91ms 0ms 0ms 6s91ms 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 3 0ms 6s921ms 6s917ms 0ms 0ms 20s753ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 1 0ms 31s82ms 31s82ms 0ms 0ms 31s82ms 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 21 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 21 0ms 52s916ms 16s13ms 35s9ms 53s279ms 1m33s 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 1 0ms 16s158ms 16s158ms 0ms 0ms 16s158ms 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 1 0ms 5s59ms 5s59ms 0ms 0ms 5s59ms 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 4 0ms 5s779ms 5s507ms 0ms 0ms 22s28ms 19 3 0ms 5s9ms 5s7ms 0ms 0ms 15s21ms 20 1 0ms 30s413ms 30s413ms 0ms 0ms 30s413ms 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 22 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 50 0ms 1m11s 14s85ms 1m3s 1m11s 1m21s 07 1 0ms 6s86ms 6s86ms 0ms 0ms 6s86ms 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 4 0ms 6s881ms 5s708ms 0ms 5s874ms 10s78ms 19 3 0ms 6s76ms 5s990ms 0ms 0ms 17s971ms 20 1 0ms 31s238ms 31s238ms 0ms 0ms 31s238ms 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 23 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 41 0ms 55s809ms 12s952ms 55s452ms 1m2s 1m46s 07 7 0ms 7s416ms 6s219ms 0ms 0ms 30s925ms 08 1 0ms 15s515ms 15s515ms 0ms 0ms 15s515ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 2 0ms 5s391ms 5s388ms 0ms 0ms 10s777ms 19 3 0ms 6s58ms 5s990ms 0ms 0ms 17s970ms 20 1 0ms 14s956ms 14s956ms 0ms 0ms 14s956ms 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 24 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 23 0ms 53s251ms 13s772ms 33s909ms 44s372ms 53s251ms 07 7 0ms 12s14ms 9s934ms 0ms 5s305ms 58s291ms 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 3 0ms 5s700ms 5s342ms 0ms 5s700ms 10s325ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 1 0ms 15s278ms 15s278ms 0ms 0ms 15s278ms 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 25 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) Oct 19 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 20 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 5 20s514ms 0ms 0ms 51s844ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 6s91ms 0ms 0ms 6s91ms 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 1 0 31s82ms 0ms 0ms 31s82ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 21 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 4 22s635ms 0ms 0ms 1m1s 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 1 0 5s59ms 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 1 0 5s2ms 0ms 0ms 5s2ms 20 1 0 30s413ms 0ms 0ms 30s413ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 22 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 3 5 20s992ms 0ms 17s857ms 1m6s 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 1 0 5s41ms 0ms 0ms 5s41ms 19 0 0 0ms 0ms 0ms 0ms 20 1 0 31s238ms 0ms 0ms 31s238ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 23 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 5 17s99ms 0ms 0ms 1m46s 07 2 0 5s807ms 0ms 0ms 11s614ms 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 1 0 14s956ms 0ms 0ms 14s956ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 24 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 4 10s425ms 0ms 0ms 33s909ms 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 1 0 15s278ms 0ms 0ms 15s278ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Oct 25 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) Oct 19 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 20 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 1 0 13s972ms 0ms 0ms 0ms 07 0 0 2 0 12s59ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 21 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 1 0 10s204ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 1 0 16s158ms 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 2 0 0 0 5s9ms 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 22 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 5 1 1 0 9s348ms 0ms 0ms 13s540ms 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 1 0 0 0 5s37ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 2 1 2 0 10s585ms 0ms 0ms 11s762ms 07 1 0 0 0 6s111ms 0ms 0ms 0ms 08 0 0 1 0 15s515ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 24 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 1 0 8s706ms 0ms 0ms 5s790ms 07 1 0 1 0 8s407ms 0ms 0ms 5s305ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Oct 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 19 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Oct 20 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 5 5.00 3.85% 07 2 4 2.00 50.00% 08 0 1 1.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 3 3.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.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 21 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 1 1.00 5.26% 07 0 0 0.00 0.00% 08 0 1 1.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 1 1.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 4 4.00 0.00% 19 0 3 3.00 0.00% 20 0 1 1.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 22 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 24 24.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 4 4.00 0.00% 19 0 3 3.00 0.00% 20 0 1 1.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 23 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 16 8.00 5.13% 07 0 7 7.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 2 2.00 0.00% 19 0 3 3.00 0.00% 20 0 1 1.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 24 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 5 5.00 0.00% 07 0 7 7.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 3 3.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.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 25 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 Oct 19 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Oct 20 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 20 0.01/s 06 341 0.09/s 07 103 0.03/s 08 98 0.03/s 09 42 0.01/s 10 58 0.02/s 11 60 0.02/s 12 87 0.02/s 13 89 0.02/s 14 43 0.01/s 15 65 0.02/s 16 46 0.01/s 17 37 0.01/s 18 32 0.01/s 19 43 0.01/s 20 55 0.02/s 21 52 0.01/s 22 47 0.01/s 23 48 0.01/s Oct 21 00 44 0.01/s 01 31 0.01/s 02 52 0.01/s 03 49 0.01/s 04 42 0.01/s 05 35 0.01/s 06 361 0.10/s 07 56 0.02/s 08 104 0.03/s 09 127 0.04/s 10 87 0.02/s 11 52 0.01/s 12 126 0.04/s 13 108 0.03/s 14 50 0.01/s 15 59 0.02/s 16 90 0.03/s 17 34 0.01/s 18 44 0.01/s 19 60 0.02/s 20 59 0.02/s 21 55 0.02/s 22 48 0.01/s 23 51 0.01/s Oct 22 00 51 0.01/s 01 52 0.01/s 02 48 0.01/s 03 38 0.01/s 04 43 0.01/s 05 41 0.01/s 06 338 0.09/s 07 61 0.02/s 08 47 0.01/s 09 54 0.01/s 10 60 0.02/s 11 62 0.02/s 12 56 0.02/s 13 66 0.02/s 14 48 0.01/s 15 62 0.02/s 16 58 0.02/s 17 36 0.01/s 18 57 0.02/s 19 64 0.02/s 20 50 0.01/s 21 49 0.01/s 22 53 0.01/s 23 62 0.02/s Oct 23 00 50 0.01/s 01 47 0.01/s 02 58 0.02/s 03 64 0.02/s 04 53 0.01/s 05 36 0.01/s 06 334 0.09/s 07 57 0.02/s 08 164 0.05/s 09 106 0.03/s 10 37 0.01/s 11 55 0.02/s 12 59 0.02/s 13 50 0.01/s 14 52 0.01/s 15 51 0.01/s 16 56 0.02/s 17 36 0.01/s 18 59 0.02/s 19 55 0.02/s 20 50 0.01/s 21 51 0.01/s 22 56 0.02/s 23 54 0.01/s Oct 24 00 57 0.02/s 01 33 0.01/s 02 44 0.01/s 03 47 0.01/s 04 29 0.01/s 05 54 0.01/s 06 367 0.10/s 07 67 0.02/s 08 56 0.02/s 09 60 0.02/s 10 62 0.02/s 11 49 0.01/s 12 68 0.02/s 13 51 0.01/s 14 64 0.02/s 15 68 0.02/s 16 68 0.02/s 17 46 0.01/s 18 49 0.01/s 19 64 0.02/s 20 51 0.01/s 21 55 0.02/s 22 71 0.02/s 23 55 0.02/s Oct 25 00 49 0.01/s 01 53 0.01/s 02 62 0.02/s 03 55 0.02/s 04 54 0.01/s 05 54 0.01/s 06 63 0.02/s 07 60 0.02/s 08 45 0.01/s 09 64 0.02/s 10 45 0.01/s 11 81 0.02/s 12 60 0.02/s 13 56 0.02/s 14 43 0.01/s 15 67 0.02/s 16 53 0.01/s 17 5 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 Oct 19 00 3 75ms 75ms 01 3 74ms 74ms 02 3 74ms 74ms 03 3 79ms 79ms 04 3 75ms 75ms 05 3 75ms 75ms 06 3 76ms 76ms 07 3 73ms 73ms 08 3 79ms 79ms 09 3 82ms 82ms 10 3 77ms 77ms 11 3 75ms 75ms 12 3 77ms 77ms 13 3 75ms 75ms 14 3 74ms 74ms 15 3 80ms 80ms 16 3 72ms 72ms 17 3 80ms 80ms 18 3 82ms 82ms 19 3 74ms 74ms 20 3 72ms 72ms 21 3 72ms 72ms 22 3 71ms 71ms 23 3 72ms 72ms Oct 20 00 3 80ms 80ms 01 3 70ms 70ms 02 3 71ms 71ms 03 3 73ms 73ms 04 3 71ms 71ms 05 20 2m39s 2m39s 06 340 26s281ms 25s33ms 07 102 1m57s 1m57s 08 100 3m50s 3m50s 09 42 1m12s 1m12s 10 58 1m12s 1m12s 11 55 1m21s 1m21s 12 90 1m41s 1m41s 13 91 3m17s 3m17s 14 43 1m16s 1m16s 15 60 3m1s 3m1s 16 47 1m20s 1m20s 17 37 52m8s 52m8s 18 33 1m27s 1m26s 19 45 1m29s 1m29s 20 55 1m13s 1m12s 21 52 1m17s 1m17s 22 47 1m11s 1m11s 23 48 1m14s 1m14s Oct 21 00 38 1m12s 1m12s 01 37 1m14s 1m14s 02 52 1m15s 1m15s 03 49 1m14s 1m14s 04 42 1m10s 1m10s 05 38 1h6s 1h6s 06 354 26s671ms 25s721ms 07 58 1m51s 1m51s 08 96 1m26s 1m26s 09 127 1m26s 1m26s 10 97 7m15s 7m15s 11 47 1m16s 1m16s 12 127 2m19s 2m19s 13 107 2m51s 2m51s 14 55 8m56s 8m56s 15 59 1m16s 1m16s 16 90 1m17s 1m17s 17 31 1h2m4s 1h2m4s 18 43 1m29s 1m29s 19 64 1m26s 1m26s 20 59 1m20s 1m19s 21 55 1m20s 1m20s 22 48 1m19s 1m19s 23 51 24m23s 24m23s Oct 22 00 51 1m17s 1m17s 01 52 1m18s 1m18s 02 48 1m16s 1m16s 03 38 1m12s 1m12s 04 43 1m22s 1m22s 05 44 24m39s 24m39s 06 338 25s477ms 23s394ms 07 61 1m44s 1m44s 08 48 2m24s 2m24s 09 54 1m34s 1m34s 10 60 1m23s 1m23s 11 59 1m25s 1m25s 12 57 1m20s 1m20s 13 66 1m20s 1m20s 14 50 6m47s 6m47s 15 62 1m21s 1m21s 16 58 1m23s 1m23s 17 36 53m42s 53m42s 18 53 1m37s 1m37s 19 62 1m30s 1m30s 20 53 1m23s 1m23s 21 45 1m21s 1m21s 22 57 1m20s 1m20s 23 62 1m17s 1m17s Oct 23 00 49 1m18s 1m18s 01 47 1m19s 1m19s 02 59 1m19s 1m19s 03 64 1m18s 1m18s 04 53 1m18s 1m18s 05 39 58m38s 58m38s 06 328 25s191ms 23s572ms 07 60 1m52s 1m51s 08 156 2m32s 2m32s 09 109 2m41s 2m41s 10 41 5m53s 5m53s 11 57 5m33s 5m33s 12 59 1m20s 1m20s 13 46 1m16s 1m16s 14 54 1m11s 1m11s 15 53 3m38s 3m38s 16 56 1m17s 1m17s 17 36 53m21s 53m21s 18 59 1m23s 1m23s 19 58 1m25s 1m25s 20 50 1m18s 1m18s 21 47 1m19s 1m19s 22 60 1m16s 1m16s 23 54 1m14s 1m14s Oct 24 00 57 1m16s 1m16s 01 33 1m16s 1m16s 02 44 1m19s 1m19s 03 47 1m13s 1m13s 04 29 1m28s 1m28s 05 57 40m15s 40m15s 06 364 26s256ms 25s386ms 07 66 1m40s 1m39s 08 60 1m18s 1m18s 09 60 1m19s 1m19s 10 62 1m20s 1m20s 11 49 1m32s 1m32s 12 64 1m17s 1m17s 13 55 1m10s 1m10s 14 64 1m17s 1m17s 15 68 24m13s 24m13s 16 68 1m18s 1m18s 17 42 8m59s 8m59s 18 53 1m26s 1m26s 19 64 1m23s 1m23s 20 52 1m19s 1m19s 21 51 1m18s 1m18s 22 75 1m21s 1m21s 23 51 1m19s 1m19s Oct 25 00 50 1m25s 1m25s 01 56 1m20s 1m20s 02 62 1m15s 1m15s 03 55 1m23s 1m23s 04 54 1m21s 1m21s 05 54 1m18s 1m18s 06 63 1m16s 1m16s 07 60 1m15s 1m15s 08 45 1m23s 1m23s 09 62 1m14s 1m14s 10 47 1m26s 1m26s 11 81 1m15s 1m15s 12 57 1m17s 1m17s 13 59 1m22s 1m22s 14 43 1m18s 1m18s 15 65 1m19s 1m19s 16 55 1m19s 1m19s 17 8 8h53m12s 8h53m12s 18 2 78ms 78ms 19 2 78ms 78ms 20 2 78ms 78ms 21 2 79ms 79ms 22 2 72ms 72ms 23 2 75ms 75ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-10-22 06:27:53 Date
Connections per database
Key values
- reftk Main Database
- 9,139 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 9,139 connections Total
-
Sessions
Simultaneous sessions
Key values
- 89 sessions Session Peak
- 2025-10-19 16:52:09 Date
Histogram of session times
Key values
- 7,072 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 9,150 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 9,150 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 9,150 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 9,150 sessions Total
Application Count Total Duration Average Duration DBeaver 25.0.5 - Main 'reftk' 5 9h36m14s 1h55m14s DBeaver 25.0.5 - Metadata 'reftk' 5 9h35m50s 1h55m10s DBeaver 25.0.5 - Read PostgreSQL database list 5 3s521ms 704ms DBeaver 25.1.0 - Main 'reftk' 2 1h41m56s 50m58s DBeaver 25.1.0 - Metadata 'reftk' 2 1h41m55s 50m57s DBeaver 25.1.0 - SQLEditor 'Script-1.sql' 1 39s609ms 39s609ms IntelliJ IDEA 2025.2.3 1 11s185ms 11s185ms PostgreSQL JDBC Driver 7,215 24d1h33m55s 4m48s [unknown] 471 54s930ms 116ms pg_dump 15 3h56m24s 15m45s psql 1,428 1h9m7s 2s904ms -
Temporary Files
Size of temporary files
Key values
- 240.84 MiB Temp Files size Peak
- 2025-10-24 06:21:42 Date
Number of temporary files
Key values
- 7 per second Temp Files Peak
- 2025-10-24 06:20:52 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 19 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 1 4.33 MiB 4.33 MiB 06 202 3.28 GiB 16.61 MiB 07 1 4.33 MiB 4.33 MiB 08 1 4.33 MiB 4.33 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 1 4.33 MiB 4.33 MiB 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 21 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 200 3.28 GiB 16.77 MiB 07 0 0 0 08 1 4.33 MiB 4.33 MiB 09 0 0 0 10 0 0 0 11 1 4.33 MiB 4.33 MiB 12 2 8.66 MiB 4.33 MiB 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 22 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 200 3.28 GiB 16.78 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 23 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 201 3.28 GiB 16.72 MiB 07 0 0 0 08 3 12.98 MiB 4.33 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 198 3.28 GiB 16.96 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Oct 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 20 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 21 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 22 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 23 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 24 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 25 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
- 6 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
- 16 Total read queries
- 190 Total write queries
Queries by database
Key values
- reftk Main database
- 216 Requests
- 46m15s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 216 Requests
User Request type Count Duration a3dsupervisor Total 216 46m15s copy to 23 8m3s ddl 79 14m31s delete 11 2m13s insert 13 1m38s others 10 8m13s select 16 3m14s tcl 62 7m59s update 2 21s604ms Duration by user
Key values
- 46m15s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 216 46m15s copy to 23 8m3s ddl 79 14m31s delete 11 2m13s insert 13 1m38s others 10 8m13s select 16 3m14s tcl 62 7m59s update 2 21s604ms Queries by host
Key values
- 10.3.0.4 Main host
- 216 Requests
- 46m15s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 104 Requests
- 22m44s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-24 13:00:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 128 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m15s VACUUM ANALYZE;[ Date: 2025-10-20 06:29:27 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m11s VACUUM ANALYZE;[ Date: 2025-10-22 06:26:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 1m6s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-22 06:37:41 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 55s809ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-23 06:43:04 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 55s452ms VACUUM ANALYZE;[ Date: 2025-10-23 06:31:23 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 53s251ms VACUUM ANALYZE;[ Date: 2025-10-24 06:24:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 52s916ms VACUUM ANALYZE;[ Date: 2025-10-21 06:26:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 51s844ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-20 06:40:50 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 42s633ms VACUUM ANALYSE;[ Date: 2025-10-24 06:25:34 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
10 40s935ms VACUUM ANALYSE;[ Date: 2025-10-21 06:26:58 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 35s599ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-23 06:27:56 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 35s357ms VACUUM ANALYSE;[ Date: 2025-10-20 06:30:10 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 32s873ms VACUUM ANALYSE;[ Date: 2025-10-23 06:32:03 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 32s778ms VACUUM ANALYSE;[ Date: 2025-10-22 06:27:25 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 31s238ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-22 20:33:10 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 31s82ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-20 20:33:33 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 30s990ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-10-21 06:38:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 30s413ms select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;[ Date: 2025-10-21 20:33:38 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 28s577ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-10-21 06:36:54 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 28s309ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-10-20 06:25:23 - Database: reftk - 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 7m59s 62 5s7ms 22s44ms 7s727ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 08 4 22s339ms 5s584ms 09 2 10s520ms 5s260ms 20 3 20s753ms 6s917ms Oct 21 20 4 22s28ms 5s507ms Oct 22 08 14 2m43s 11s710ms 09 1 6s86ms 6s86ms 20 2 12s755ms 6s377ms 21 3 17s971ms 5s990ms Oct 23 08 9 1m 6s740ms 09 4 25s809ms 6s452ms 20 2 10s777ms 5s388ms 21 3 17s970ms 5s990ms Oct 24 08 3 18s696ms 6s232ms 09 5 52s729ms 10s545ms 20 3 16s26ms 5s342ms [ User: a3dsupervisor - Total duration: 7m59s - Times executed: 62 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m59s - Times executed: 62 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s44ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 18s191ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 17s181ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5m8s 5 52s916ms 1m15s 1m1s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 20 08 1 1m15s 1m15s Oct 21 08 1 52s916ms 52s916ms Oct 22 08 1 1m11s 1m11s Oct 23 08 1 55s452ms 55s452ms Oct 24 08 1 53s251ms 53s251ms [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: psql - Total duration: 5m8s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-20 06:29:27 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-22 06:26:45 Duration: 1m11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-23 06:31:23 Duration: 55s452ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m38s 5 16s201ms 1m6s 43s723ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 20 08 1 51s844ms 51s844ms Oct 21 08 1 28s577ms 28s577ms Oct 22 08 1 1m6s 1m6s Oct 23 08 1 55s809ms 55s809ms Oct 24 08 1 16s201ms 16s201ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-22 06:37:41 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-23 06:43:04 Duration: 55s809ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-20 06:40:50 Duration: 51s844ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 3m4s 5 32s778ms 42s633ms 36s915ms vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 20 08 1 35s357ms 35s357ms Oct 21 08 1 40s935ms 40s935ms Oct 22 08 1 32s778ms 32s778ms Oct 23 08 1 32s873ms 32s873ms Oct 24 08 1 42s633ms 42s633ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 5 ]
[ Application: psql - Total duration: 3m4s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 06:25:34 Duration: 42s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-20 06:30:10 Duration: 35s357ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 2m5s 5 15s436ms 35s599ms 25s47ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 08 1 28s309ms 28s309ms Oct 21 08 1 15s436ms 15s436ms Oct 22 08 1 26s785ms 26s785ms Oct 23 08 1 35s599ms 35s599ms Oct 24 08 1 19s104ms 19s104ms [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 5 ]
[ Application: psql - Total duration: 2m5s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-23 06:27:56 Duration: 35s599ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-20 06:25:23 Duration: 28s309ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-22 06:23:02 Duration: 26s785ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 2m2s 5 14s956ms 31s238ms 24s593ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 22 1 31s82ms 31s82ms Oct 21 22 1 30s413ms 30s413ms Oct 22 22 1 31s238ms 31s238ms Oct 23 22 1 14s956ms 14s956ms Oct 24 22 1 15s278ms 15s278ms [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m2s - Times executed: 5 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-22 20:33:10 Duration: 31s238ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-20 20:33:33 Duration: 31s82ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1m50s 8 10s204ms 18s128ms 13s863ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 20 08 1 13s972ms 13s972ms 09 1 18s128ms 18s128ms Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms Oct 22 08 1 13s540ms 13s540ms Oct 23 08 1 11s762ms 11s762ms 10 1 15s515ms 15s515ms Oct 24 08 1 11s623ms 11s623ms [ User: a3dsupervisor - Total duration: 1m50s - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m50s - Times executed: 8 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 07:16:02 Duration: 18s128ms Database: reftk 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-21 08:41:43 Duration: 16s158ms Database: reftk 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-23 08:08:50 Duration: 15s515ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 1m40s 5 8s865ms 30s990ms 20s170ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 20 08 1 17s38ms 17s38ms Oct 21 08 1 30s990ms 30s990ms Oct 22 08 1 26s588ms 26s588ms Oct 23 08 1 17s369ms 17s369ms Oct 24 08 1 8s865ms 8s865ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-22 06:38:23 Duration: 26s588ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-23 06:43:40 Duration: 17s369ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m40s 5 19s339ms 20s454ms 20s3ms 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 Oct 20 08 1 19s339ms 19s339ms Oct 21 08 1 19s716ms 19s716ms Oct 22 08 1 20s80ms 20s80ms Oct 23 08 1 20s428ms 20s428ms Oct 24 08 1 20s454ms 20s454ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: psql - Total duration: 1m40s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-24 06:22:33 Duration: 20s454ms Database: reftk 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-23 06:29:03 Duration: 20s428ms Database: reftk 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-22 06:24:11 Duration: 20s80ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m33s 12 5s9ms 12s912ms 7s761ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms Oct 22 08 5 40s358ms 8s71ms 20 1 5s37ms 5s37ms Oct 23 08 2 25s823ms 12s911ms 09 1 6s111ms 6s111ms Oct 24 08 1 5s790ms 5s790ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m33s - Times executed: 12 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s912ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-22 06:57:14 Duration: 9s416ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
11 1m29s 5 13s757ms 20s434ms 17s802ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 08 1 20s434ms 20s434ms Oct 21 08 1 18s846ms 18s846ms Oct 22 08 1 13s757ms 13s757ms Oct 23 08 1 18s691ms 18s691ms Oct 24 08 1 17s280ms 17s280ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 5 ]
[ Application: psql - Total duration: 1m29s - 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-20 06:26:58 Duration: 20s434ms Database: reftk 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-21 06:24:16 Duration: 18s846ms Database: reftk 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-23 06:29:29 Duration: 18s691ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 1m16s 5 7s794ms 27s188ms 15s387ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 08 1 9s360ms 9s360ms Oct 21 08 1 23s840ms 23s840ms Oct 22 08 1 27s188ms 27s188ms Oct 23 08 1 8s754ms 8s754ms Oct 24 08 1 7s794ms 7s794ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-22 06:38:50 Duration: 27s188ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-20 06:41:35 Duration: 9s360ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 1m15s 5 12s171ms 18s425ms 15s127ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 20 08 1 16s399ms 16s399ms Oct 21 08 1 12s423ms 12s423ms Oct 22 08 1 18s425ms 18s425ms Oct 23 08 1 12s171ms 12s171ms Oct 24 08 1 16s215ms 16s215ms [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 5 ]
[ Application: psql - Total duration: 1m15s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-22 06:23:20 Duration: 18s425ms Database: reftk 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-20 06:25:39 Duration: 16s399ms Database: reftk 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-24 06:21:42 Duration: 16s215ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1m7s 5 10s666ms 17s542ms 13s403ms 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 #14
Day Hour Count Duration Avg duration Oct 20 08 1 11s348ms 11s348ms Oct 21 08 1 10s666ms 10s666ms Oct 22 08 1 17s542ms 17s542ms Oct 23 08 1 12s155ms 12s155ms Oct 24 08 1 15s306ms 15s306ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - 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-22 06:20:34 Duration: 17s542ms Database: reftk 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-24 06:19:32 Duration: 15s306ms Database: reftk 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-23 06:25:05 Duration: 12s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1m5s 5 11s433ms 15s757ms 13s181ms 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 #15
Day Hour Count Duration Avg duration Oct 20 08 1 12s277ms 12s277ms Oct 21 08 1 11s464ms 11s464ms Oct 22 08 1 15s757ms 15s757ms Oct 23 08 1 14s974ms 14s974ms Oct 24 08 1 11s433ms 11s433ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-22 06:22:10 Duration: 15s757ms Database: reftk 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-23 06:26:56 Duration: 14s974ms Database: reftk 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-20 06:24:38 Duration: 12s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 47s427ms 5 7s359ms 12s835ms 9s485ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 08 1 8s768ms 8s768ms Oct 21 08 1 7s359ms 7s359ms Oct 22 08 1 9s412ms 9s412ms Oct 23 08 1 12s835ms 12s835ms Oct 24 08 1 9s52ms 9s52ms [ User: a3dsupervisor - Total duration: 47s427ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s427ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-23 06:28:21 Duration: 12s835ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-22 06:23:29 Duration: 9s412ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-24 06:21:51 Duration: 9s52ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 45s973ms 3 8s842ms 18s687ms 15s324ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 08 1 18s443ms 18s443ms Oct 23 08 1 18s687ms 18s687ms Oct 24 08 1 8s842ms 8s842ms [ User: a3dsupervisor - Total duration: 45s973ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 45s973ms - Times executed: 3 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-23 06:43:23 Duration: 18s687ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-20 06:41:08 Duration: 18s443ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-24 06:35:45 Duration: 8s842ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 41s920ms 5 7s629ms 9s214ms 8s384ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 20 08 1 9s214ms 9s214ms Oct 21 08 1 7s805ms 7s805ms Oct 22 08 1 8s583ms 8s583ms Oct 23 08 1 8s688ms 8s688ms Oct 24 08 1 7s629ms 7s629ms [ User: a3dsupervisor - Total duration: 41s920ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s920ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-20 06:26:08 Duration: 9s214ms Database: reftk 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-23 06:28:40 Duration: 8s688ms Database: reftk 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-22 06:23:48 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 41s780ms 5 5s790ms 12s102ms 8s356ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 20 08 1 5s790ms 5s790ms Oct 21 08 1 8s551ms 8s551ms Oct 22 08 1 7s186ms 7s186ms Oct 23 08 1 12s102ms 12s102ms Oct 24 08 1 8s148ms 8s148ms [ User: a3dsupervisor - Total duration: 41s780ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s780ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-23 06:29:47 Duration: 12s102ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-24 06:23:12 Duration: 8s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 38s712ms 5 6s627ms 9s759ms 7s742ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 20 08 1 7s325ms 7s325ms Oct 21 08 1 8s108ms 8s108ms Oct 22 08 1 6s627ms 6s627ms Oct 23 08 1 9s759ms 9s759ms Oct 24 08 1 6s891ms 6s891ms [ User: a3dsupervisor - Total duration: 38s712ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s712ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-23 06:26:41 Duration: 9s759ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-20 06:24:26 Duration: 7s325ms Database: reftk 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 62 7m59s 5s7ms 22s44ms 7s727ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 08 4 22s339ms 5s584ms 09 2 10s520ms 5s260ms 20 3 20s753ms 6s917ms Oct 21 20 4 22s28ms 5s507ms Oct 22 08 14 2m43s 11s710ms 09 1 6s86ms 6s86ms 20 2 12s755ms 6s377ms 21 3 17s971ms 5s990ms Oct 23 08 9 1m 6s740ms 09 4 25s809ms 6s452ms 20 2 10s777ms 5s388ms 21 3 17s970ms 5s990ms Oct 24 08 3 18s696ms 6s232ms 09 5 52s729ms 10s545ms 20 3 16s26ms 5s342ms [ User: a3dsupervisor - Total duration: 7m59s - Times executed: 62 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m59s - Times executed: 62 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s44ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 18s191ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 17s181ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 12 1m33s 5s9ms 12s912ms 7s761ms insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms Oct 22 08 5 40s358ms 8s71ms 20 1 5s37ms 5s37ms Oct 23 08 2 25s823ms 12s911ms 09 1 6s111ms 6s111ms Oct 24 08 1 5s790ms 5s790ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m33s - Times executed: 12 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s912ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-22 06:57:14 Duration: 9s416ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 8 1m50s 10s204ms 18s128ms 13s863ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 20 08 1 13s972ms 13s972ms 09 1 18s128ms 18s128ms Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms Oct 22 08 1 13s540ms 13s540ms Oct 23 08 1 11s762ms 11s762ms 10 1 15s515ms 15s515ms Oct 24 08 1 11s623ms 11s623ms [ User: a3dsupervisor - Total duration: 1m50s - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m50s - Times executed: 8 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 07:16:02 Duration: 18s128ms Database: reftk 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-21 08:41:43 Duration: 16s158ms Database: reftk 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-23 08:08:50 Duration: 15s515ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 5 5m8s 52s916ms 1m15s 1m1s vacuum analyze;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 20 08 1 1m15s 1m15s Oct 21 08 1 52s916ms 52s916ms Oct 22 08 1 1m11s 1m11s Oct 23 08 1 55s452ms 55s452ms Oct 24 08 1 53s251ms 53s251ms [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: psql - Total duration: 5m8s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-20 06:29:27 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-22 06:26:45 Duration: 1m11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-23 06:31:23 Duration: 55s452ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 5 3m38s 16s201ms 1m6s 43s723ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 08 1 51s844ms 51s844ms Oct 21 08 1 28s577ms 28s577ms Oct 22 08 1 1m6s 1m6s Oct 23 08 1 55s809ms 55s809ms Oct 24 08 1 16s201ms 16s201ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-22 06:37:41 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-23 06:43:04 Duration: 55s809ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-20 06:40:50 Duration: 51s844ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 5 3m4s 32s778ms 42s633ms 36s915ms vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 08 1 35s357ms 35s357ms Oct 21 08 1 40s935ms 40s935ms Oct 22 08 1 32s778ms 32s778ms Oct 23 08 1 32s873ms 32s873ms Oct 24 08 1 42s633ms 42s633ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 5 ]
[ Application: psql - Total duration: 3m4s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 06:25:34 Duration: 42s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-20 06:30:10 Duration: 35s357ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 5 2m5s 15s436ms 35s599ms 25s47ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 20 08 1 28s309ms 28s309ms Oct 21 08 1 15s436ms 15s436ms Oct 22 08 1 26s785ms 26s785ms Oct 23 08 1 35s599ms 35s599ms Oct 24 08 1 19s104ms 19s104ms [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 5 ]
[ Application: psql - Total duration: 2m5s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-23 06:27:56 Duration: 35s599ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-20 06:25:23 Duration: 28s309ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-22 06:23:02 Duration: 26s785ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 2m2s 14s956ms 31s238ms 24s593ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 20 22 1 31s82ms 31s82ms Oct 21 22 1 30s413ms 30s413ms Oct 22 22 1 31s238ms 31s238ms Oct 23 22 1 14s956ms 14s956ms Oct 24 22 1 15s278ms 15s278ms [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m2s - Times executed: 5 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-22 20:33:10 Duration: 31s238ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-20 20:33:33 Duration: 31s82ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
9 5 1m40s 8s865ms 30s990ms 20s170ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 20 08 1 17s38ms 17s38ms Oct 21 08 1 30s990ms 30s990ms Oct 22 08 1 26s588ms 26s588ms Oct 23 08 1 17s369ms 17s369ms Oct 24 08 1 8s865ms 8s865ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-22 06:38:23 Duration: 26s588ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-23 06:43:40 Duration: 17s369ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 5 1m40s 19s339ms 20s454ms 20s3ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 20 08 1 19s339ms 19s339ms Oct 21 08 1 19s716ms 19s716ms Oct 22 08 1 20s80ms 20s80ms Oct 23 08 1 20s428ms 20s428ms Oct 24 08 1 20s454ms 20s454ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: psql - Total duration: 1m40s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-24 06:22:33 Duration: 20s454ms Database: reftk 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-23 06:29:03 Duration: 20s428ms Database: reftk 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-22 06:24:11 Duration: 20s80ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m29s 13s757ms 20s434ms 17s802ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 08 1 20s434ms 20s434ms Oct 21 08 1 18s846ms 18s846ms Oct 22 08 1 13s757ms 13s757ms Oct 23 08 1 18s691ms 18s691ms Oct 24 08 1 17s280ms 17s280ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 5 ]
[ Application: psql - Total duration: 1m29s - 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-20 06:26:58 Duration: 20s434ms Database: reftk 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-21 06:24:16 Duration: 18s846ms Database: reftk 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-23 06:29:29 Duration: 18s691ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m16s 7s794ms 27s188ms 15s387ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 08 1 9s360ms 9s360ms Oct 21 08 1 23s840ms 23s840ms Oct 22 08 1 27s188ms 27s188ms Oct 23 08 1 8s754ms 8s754ms Oct 24 08 1 7s794ms 7s794ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-22 06:38:50 Duration: 27s188ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-20 06:41:35 Duration: 9s360ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 5 1m15s 12s171ms 18s425ms 15s127ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 20 08 1 16s399ms 16s399ms Oct 21 08 1 12s423ms 12s423ms Oct 22 08 1 18s425ms 18s425ms Oct 23 08 1 12s171ms 12s171ms Oct 24 08 1 16s215ms 16s215ms [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 5 ]
[ Application: psql - Total duration: 1m15s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-22 06:23:20 Duration: 18s425ms Database: reftk 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-20 06:25:39 Duration: 16s399ms Database: reftk 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-24 06:21:42 Duration: 16s215ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 1m7s 10s666ms 17s542ms 13s403ms 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 #14
Day Hour Count Duration Avg duration Oct 20 08 1 11s348ms 11s348ms Oct 21 08 1 10s666ms 10s666ms Oct 22 08 1 17s542ms 17s542ms Oct 23 08 1 12s155ms 12s155ms Oct 24 08 1 15s306ms 15s306ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - 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-22 06:20:34 Duration: 17s542ms Database: reftk 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-24 06:19:32 Duration: 15s306ms Database: reftk 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-23 06:25:05 Duration: 12s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5 1m5s 11s433ms 15s757ms 13s181ms 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 #15
Day Hour Count Duration Avg duration Oct 20 08 1 12s277ms 12s277ms Oct 21 08 1 11s464ms 11s464ms Oct 22 08 1 15s757ms 15s757ms Oct 23 08 1 14s974ms 14s974ms Oct 24 08 1 11s433ms 11s433ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-22 06:22:10 Duration: 15s757ms Database: reftk 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-23 06:26:56 Duration: 14s974ms Database: reftk 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-20 06:24:38 Duration: 12s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 47s427ms 7s359ms 12s835ms 9s485ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 08 1 8s768ms 8s768ms Oct 21 08 1 7s359ms 7s359ms Oct 22 08 1 9s412ms 9s412ms Oct 23 08 1 12s835ms 12s835ms Oct 24 08 1 9s52ms 9s52ms [ User: a3dsupervisor - Total duration: 47s427ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s427ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-23 06:28:21 Duration: 12s835ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-22 06:23:29 Duration: 9s412ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-24 06:21:51 Duration: 9s52ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 41s920ms 7s629ms 9s214ms 8s384ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 08 1 9s214ms 9s214ms Oct 21 08 1 7s805ms 7s805ms Oct 22 08 1 8s583ms 8s583ms Oct 23 08 1 8s688ms 8s688ms Oct 24 08 1 7s629ms 7s629ms [ User: a3dsupervisor - Total duration: 41s920ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s920ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-20 06:26:08 Duration: 9s214ms Database: reftk 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-23 06:28:40 Duration: 8s688ms Database: reftk 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-22 06:23:48 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 41s780ms 5s790ms 12s102ms 8s356ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 20 08 1 5s790ms 5s790ms Oct 21 08 1 8s551ms 8s551ms Oct 22 08 1 7s186ms 7s186ms Oct 23 08 1 12s102ms 12s102ms Oct 24 08 1 8s148ms 8s148ms [ User: a3dsupervisor - Total duration: 41s780ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s780ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-23 06:29:47 Duration: 12s102ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-24 06:23:12 Duration: 8s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 38s712ms 6s627ms 9s759ms 7s742ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 20 08 1 7s325ms 7s325ms Oct 21 08 1 8s108ms 8s108ms Oct 22 08 1 6s627ms 6s627ms Oct 23 08 1 9s759ms 9s759ms Oct 24 08 1 6s891ms 6s891ms [ User: a3dsupervisor - Total duration: 38s712ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s712ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-23 06:26:41 Duration: 9s759ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-20 06:24:26 Duration: 7s325ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5 29s525ms 5s709ms 6s59ms 5s905ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 20 08 1 5s709ms 5s709ms Oct 21 08 1 5s975ms 5s975ms Oct 22 08 1 5s996ms 5s996ms Oct 23 08 1 5s784ms 5s784ms Oct 24 08 1 6s59ms 6s59ms [ User: a3dsupervisor - Total duration: 29s525ms - Times executed: 5 ]
[ Application: psql - Total duration: 29s525ms - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-24 06:22:41 Duration: 6s59ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-22 06:24:21 Duration: 5s996ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-21 06:23:58 Duration: 5s975ms Database: reftk 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 52s916ms 1m15s 1m1s 5 5m8s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 20 08 1 1m15s 1m15s Oct 21 08 1 52s916ms 52s916ms Oct 22 08 1 1m11s 1m11s Oct 23 08 1 55s452ms 55s452ms Oct 24 08 1 53s251ms 53s251ms [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: psql - Total duration: 5m8s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-10-20 06:29:27 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-22 06:26:45 Duration: 1m11s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-10-23 06:31:23 Duration: 55s452ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 16s201ms 1m6s 43s723ms 5 3m38s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 20 08 1 51s844ms 51s844ms Oct 21 08 1 28s577ms 28s577ms Oct 22 08 1 1m6s 1m6s Oct 23 08 1 55s809ms 55s809ms Oct 24 08 1 16s201ms 16s201ms [ User: a3dsupervisor - Total duration: 3m38s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m38s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-22 06:37:41 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-23 06:43:04 Duration: 55s809ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-20 06:40:50 Duration: 51s844ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 32s778ms 42s633ms 36s915ms 5 3m4s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 20 08 1 35s357ms 35s357ms Oct 21 08 1 40s935ms 40s935ms Oct 22 08 1 32s778ms 32s778ms Oct 23 08 1 32s873ms 32s873ms Oct 24 08 1 42s633ms 42s633ms [ User: a3dsupervisor - Total duration: 3m4s - Times executed: 5 ]
[ Application: psql - Total duration: 3m4s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-10-24 06:25:34 Duration: 42s633ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-21 06:26:58 Duration: 40s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-20 06:30:10 Duration: 35s357ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 15s436ms 35s599ms 25s47ms 5 2m5s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 20 08 1 28s309ms 28s309ms Oct 21 08 1 15s436ms 15s436ms Oct 22 08 1 26s785ms 26s785ms Oct 23 08 1 35s599ms 35s599ms Oct 24 08 1 19s104ms 19s104ms [ User: a3dsupervisor - Total duration: 2m5s - Times executed: 5 ]
[ Application: psql - Total duration: 2m5s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-23 06:27:56 Duration: 35s599ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-20 06:25:23 Duration: 28s309ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-10-22 06:23:02 Duration: 26s785ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 14s956ms 31s238ms 24s593ms 5 2m2s select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 20 22 1 31s82ms 31s82ms Oct 21 22 1 30s413ms 30s413ms Oct 22 22 1 31s238ms 31s238ms Oct 23 22 1 14s956ms 14s956ms Oct 24 22 1 15s278ms 15s278ms [ User: a3dsupervisor - Total duration: 2m2s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m2s - Times executed: 5 ]
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-22 20:33:10 Duration: 31s238ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-20 20:33:33 Duration: 31s82ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select ceahp1_0.HISTORY_NUM_ID, ceahp1_1.HISTORY_ACTION, ceahp1_1.HISTORY_DATE, ceahp1_1.OBJ_NUM_ID, ceahp1_1.OBJ_TEMPLATE_A3D_ID, ceahp1_0.ALERT_SRC_NUM_ID, ceahp1_0.ALERT_TYPE_A3D_ID from GTP_CW_ENG_ALERT ceahp1_0 join GTP_CW_ENG_HISTORY ceahp1_1 on ceahp1_0.HISTORY_NUM_ID = ceahp1_1.HISTORY_NUM_ID where ceahp1_1.HISTORY_ACTION = and ceahp1_1.OBJ_TEMPLATE_A3D_ID = and ceahp1_1.OBJ_NUM_ID = and ceahp1_0.ALERT_TYPE_A3D_ID = and ceahp1_0.ALERT_SRC_NUM_ID is null order by ceahp1_1.HISTORY_DATE desc fetch first rows only;
Date: 2025-10-21 20:33:38 Duration: 30s413ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 8s865ms 30s990ms 20s170ms 5 1m40s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 20 08 1 17s38ms 17s38ms Oct 21 08 1 30s990ms 30s990ms Oct 22 08 1 26s588ms 26s588ms Oct 23 08 1 17s369ms 17s369ms Oct 24 08 1 8s865ms 8s865ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m40s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-21 06:38:05 Duration: 30s990ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-22 06:38:23 Duration: 26s588ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-23 06:43:40 Duration: 17s369ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 19s339ms 20s454ms 20s3ms 5 1m40s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 20 08 1 19s339ms 19s339ms Oct 21 08 1 19s716ms 19s716ms Oct 22 08 1 20s80ms 20s80ms Oct 23 08 1 20s428ms 20s428ms Oct 24 08 1 20s454ms 20s454ms [ User: a3dsupervisor - Total duration: 1m40s - Times executed: 5 ]
[ Application: psql - Total duration: 1m40s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-10-24 06:22:33 Duration: 20s454ms Database: reftk 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-23 06:29:03 Duration: 20s428ms Database: reftk 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-22 06:24:11 Duration: 20s80ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 13s757ms 20s434ms 17s802ms 5 1m29s 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 Oct 20 08 1 20s434ms 20s434ms Oct 21 08 1 18s846ms 18s846ms Oct 22 08 1 13s757ms 13s757ms Oct 23 08 1 18s691ms 18s691ms Oct 24 08 1 17s280ms 17s280ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 5 ]
[ Application: psql - Total duration: 1m29s - 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-20 06:26:58 Duration: 20s434ms Database: reftk 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-21 06:24:16 Duration: 18s846ms Database: reftk 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-23 06:29:29 Duration: 18s691ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 7s794ms 27s188ms 15s387ms 5 1m16s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 20 08 1 9s360ms 9s360ms Oct 21 08 1 23s840ms 23s840ms Oct 22 08 1 27s188ms 27s188ms Oct 23 08 1 8s754ms 8s754ms Oct 24 08 1 7s794ms 7s794ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m16s - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-22 06:38:50 Duration: 27s188ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-21 06:38:29 Duration: 23s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-20 06:41:35 Duration: 9s360ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 8s842ms 18s687ms 15s324ms 3 45s973ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 20 08 1 18s443ms 18s443ms Oct 23 08 1 18s687ms 18s687ms Oct 24 08 1 8s842ms 8s842ms [ User: a3dsupervisor - Total duration: 45s973ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 45s973ms - Times executed: 3 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-23 06:43:23 Duration: 18s687ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-20 06:41:08 Duration: 18s443ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-10-24 06:35:45 Duration: 8s842ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 12s171ms 18s425ms 15s127ms 5 1m15s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 20 08 1 16s399ms 16s399ms Oct 21 08 1 12s423ms 12s423ms Oct 22 08 1 18s425ms 18s425ms Oct 23 08 1 12s171ms 12s171ms Oct 24 08 1 16s215ms 16s215ms [ User: a3dsupervisor - Total duration: 1m15s - Times executed: 5 ]
[ Application: psql - Total duration: 1m15s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-10-22 06:23:20 Duration: 18s425ms Database: reftk 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-20 06:25:39 Duration: 16s399ms Database: reftk 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-24 06:21:42 Duration: 16s215ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 10s204ms 18s128ms 13s863ms 8 1m50s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 20 08 1 13s972ms 13s972ms 09 1 18s128ms 18s128ms Oct 21 08 1 10s204ms 10s204ms 10 1 16s158ms 16s158ms Oct 22 08 1 13s540ms 13s540ms Oct 23 08 1 11s762ms 11s762ms 10 1 15s515ms 15s515ms Oct 24 08 1 11s623ms 11s623ms [ User: a3dsupervisor - Total duration: 1m50s - Times executed: 8 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m50s - Times executed: 8 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-10-20 07:16:02 Duration: 18s128ms Database: reftk 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-21 08:41:43 Duration: 16s158ms Database: reftk 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-23 08:08:50 Duration: 15s515ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 10s666ms 17s542ms 13s403ms 5 1m7s 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 #13
Day Hour Count Duration Avg duration Oct 20 08 1 11s348ms 11s348ms Oct 21 08 1 10s666ms 10s666ms Oct 22 08 1 17s542ms 17s542ms Oct 23 08 1 12s155ms 12s155ms Oct 24 08 1 15s306ms 15s306ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 5 ]
[ Application: psql - Total duration: 1m7s - 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-22 06:20:34 Duration: 17s542ms Database: reftk 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-24 06:19:32 Duration: 15s306ms Database: reftk 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-23 06:25:05 Duration: 12s155ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 11s433ms 15s757ms 13s181ms 5 1m5s create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 20 08 1 12s277ms 12s277ms Oct 21 08 1 11s464ms 11s464ms Oct 22 08 1 15s757ms 15s757ms Oct 23 08 1 14s974ms 14s974ms Oct 24 08 1 11s433ms 11s433ms [ User: a3dsupervisor - Total duration: 1m5s - Times executed: 5 ]
[ Application: psql - Total duration: 1m5s - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-10-22 06:22:10 Duration: 15s757ms Database: reftk 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-23 06:26:56 Duration: 14s974ms Database: reftk 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-20 06:24:38 Duration: 12s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 7s359ms 12s835ms 9s485ms 5 47s427ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 20 08 1 8s768ms 8s768ms Oct 21 08 1 7s359ms 7s359ms Oct 22 08 1 9s412ms 9s412ms Oct 23 08 1 12s835ms 12s835ms Oct 24 08 1 9s52ms 9s52ms [ User: a3dsupervisor - Total duration: 47s427ms - Times executed: 5 ]
[ Application: psql - Total duration: 47s427ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-23 06:28:21 Duration: 12s835ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-22 06:23:29 Duration: 9s412ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-10-24 06:21:51 Duration: 9s52ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 7s629ms 9s214ms 8s384ms 5 41s920ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 20 08 1 9s214ms 9s214ms Oct 21 08 1 7s805ms 7s805ms Oct 22 08 1 8s583ms 8s583ms Oct 23 08 1 8s688ms 8s688ms Oct 24 08 1 7s629ms 7s629ms [ User: a3dsupervisor - Total duration: 41s920ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s920ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-10-20 06:26:08 Duration: 9s214ms Database: reftk 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-23 06:28:40 Duration: 8s688ms Database: reftk 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-22 06:23:48 Duration: 8s583ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5s790ms 12s102ms 8s356ms 5 41s780ms alter table gtp_obj_composition add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 20 08 1 5s790ms 5s790ms Oct 21 08 1 8s551ms 8s551ms Oct 22 08 1 7s186ms 7s186ms Oct 23 08 1 12s102ms 12s102ms Oct 24 08 1 8s148ms 8s148ms [ User: a3dsupervisor - Total duration: 41s780ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s780ms - Times executed: 5 ]
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-23 06:29:47 Duration: 12s102ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-21 06:24:30 Duration: 8s551ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_obj_composition ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2025-10-24 06:23:12 Duration: 8s148ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5s9ms 12s912ms 7s761ms 12 1m33s insert into applicative_lock (lock_creator, lock_date, lock_duration, lock_extensions_number, lock_host_name, lock_informations, lock_name, lock_session_id, lock_timeout_date, lock_type, lock_key) values (,,,,,,,,,,);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 21 21 2 10s18ms 5s9ms Oct 22 08 5 40s358ms 8s71ms 20 1 5s37ms 5s37ms Oct 23 08 2 25s823ms 12s911ms 09 1 6s111ms 6s111ms Oct 24 08 1 5s790ms 5s790ms [ User: a3dsupervisor - Total duration: 1m33s - Times executed: 12 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m33s - Times executed: 12 ]
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s912ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-23 06:59:16 Duration: 12s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
insert into APPLICATIVE_LOCK (LOCK_CREATOR, LOCK_DATE, LOCK_DURATION, LOCK_EXTENSIONS_NUMBER, LOCK_HOST_NAME, LOCK_INFORMATIONS, LOCK_NAME, LOCK_SESSION_ID, LOCK_TIMEOUT_DATE, LOCK_TYPE, LOCK_KEY) values (,,,,,,,,,,);
Date: 2025-10-22 06:57:14 Duration: 9s416ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
19 6s627ms 9s759ms 7s742ms 5 38s712ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 20 08 1 7s325ms 7s325ms Oct 21 08 1 8s108ms 8s108ms Oct 22 08 1 6s627ms 6s627ms Oct 23 08 1 9s759ms 9s759ms Oct 24 08 1 6s891ms 6s891ms [ User: a3dsupervisor - Total duration: 38s712ms - Times executed: 5 ]
[ Application: psql - Total duration: 38s712ms - Times executed: 5 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-23 06:26:41 Duration: 9s759ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-21 06:22:04 Duration: 8s108ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-10-20 06:24:26 Duration: 7s325ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 5s7ms 22s44ms 7s727ms 62 7m59s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 20 08 4 22s339ms 5s584ms 09 2 10s520ms 5s260ms 20 3 20s753ms 6s917ms Oct 21 20 4 22s28ms 5s507ms Oct 22 08 14 2m43s 11s710ms 09 1 6s86ms 6s86ms 20 2 12s755ms 6s377ms 21 3 17s971ms 5s990ms Oct 23 08 9 1m 6s740ms 09 4 25s809ms 6s452ms 20 2 10s777ms 5s388ms 21 3 17s970ms 5s990ms Oct 24 08 3 18s696ms 6s232ms 09 5 52s729ms 10s545ms 20 3 16s26ms 5s342ms [ User: a3dsupervisor - Total duration: 7m59s - Times executed: 62 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 7m59s - Times executed: 62 ]
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 22s44ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 18s191ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-10-22 06:58:51 Duration: 17s181ms Database: reftk 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 8s440ms 1 8s440ms 8s440ms 8s440ms 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;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 25 08 1 8s440ms 8s440ms [ User: a3dsupervisor - Total duration: 5s264ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s264ms - 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;
Date: 2025-10-23 06:57:16 Duration: 8s440ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
2 6s183ms 1 6s183ms 6s183ms 6s183ms 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 #2
Day Hour Count Duration Avg duration 06 1 6s183ms 6s183ms [ User: a3dsupervisor - Total duration: 5s88ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 5s88ms - 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-23 06:57:16 Duration: 6s183ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 42,550 Log entries
Events distribution
Key values
- 0 PANIC entries
- 22 FATAL entries
- 13752 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 13,609 Max number of times the same event was reported
- 13,854 Total events found
Rank Times reported Error 1 13,609 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 20 08 126 09 213 10 203 11 291 12 310 13 587 14 231 15 200 16 234 17 16 18 168 Oct 21 08 94 09 240 10 641 11 121 12 401 13 766 14 204 15 226 16 15 17 200 18 20 Oct 22 08 89 09 247 10 250 11 636 12 144 13 532 14 157 15 190 16 90 17 206 18 79 Oct 23 08 95 09 384 10 47 11 709 12 95 13 344 14 800 15 151 16 238 17 10 18 204 19 113 20 2 21 2 Oct 24 08 94 09 277 10 77 11 290 12 141 13 521 14 296 15 113 16 120 17 204 18 129 19 26 2 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 20 08 16 Oct 21 08 16 Oct 22 08 16 Oct 23 08 16 Oct 24 08 16 3 76 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 20 10 4 15 2 17 2 19 3 Oct 21 12 6 14 11 16 2 19 7 Oct 22 16 2 19 7 Oct 23 10 6 12 2 13 2 19 3 Oct 24 17 4 19 7 Oct 25 19 6 4 13 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 21 01 13 5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 21 01 9 6 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 #6
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 7 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 #7
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 8 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 #8
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 9 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 10 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 11 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 #11
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 12 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 13 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 #13
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 14 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 #14
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 15 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #15
Day Hour Count Oct 20 08 1 Oct 21 08 1 Oct 22 08 1 Oct 23 08 1 Oct 24 08 1 16 4 ERROR: current transaction is aborted, commands ignored until end of transaction blockset lock_timeout = 0
Times Reported Most Frequent Error / Event #16
Day Hour Count Oct 20 14 3 Oct 21 12 1 17 4 ERROR: canceling statement due to lock timeoutselect LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE
Times Reported Most Frequent Error / Event #17
Day Hour Count Oct 20 14 3 Oct 21 12 1 18 2 ERROR: could not obtain lock on row in relation "..." SELECT toNotif.action_num_id FROM gtp_history_obj_action toNotif WHERE toNotif.action_num_id = FOR UPDATE NOWAIT
Times Reported Most Frequent Error / Event #18
Day Hour Count Oct 23 11 2 19 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (...)
Times Reported Most Frequent Error / Event #19
Day Hour Count Oct 22 08 1 Oct 23 08 1 20 1 ERROR: column "..." is of type smallint but expression is of type boolean
Times Reported Most Frequent Error / Event #20
Day Hour Count Oct 20 09 1 21 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON gtp_monthly_history (...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Oct 23 08 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Oct 20 08 1 23 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 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #23
Day Hour Count Oct 23 08 1 24 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 #24
Day Hour Count Oct 23 08 1