pgBadger-
Global information
- Generated on Mon Nov 10 09:36:26 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=08/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=08/h=23/m=00/PT1H.log
- Parsed 64,816 log entries in 1m32s
- Log start from 2025-11-03 07:12:07 to 2025-11-08 18:01:12
-
Overview
Global Stats
- 42 Number of unique normalized queries
- 248 Number of queries
- 51m42s Total query duration
- 2025-11-03 07:22:30 First query
- 2025-11-07 21:33:08 Last query
- 5 queries/s at 2025-11-07 08:01:40 Query peak
- 51m42s Total query duration
- 19s996ms Prepare/parse total duration
- 0ms Bind total duration
- 51m22s Execute total duration
- 19,394 Number of events
- 24 Number of unique normalized events
- 19,199 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,010 Number temporary file
- 2.42 GiB Max size of temporary file
- 16.87 MiB Average size of temporary file
- 8,172 Total number of sessions
- 157 sessions at 2025-11-08 16:58:46 Session peak
- 23d13h31m10s Total duration of sessions
- 4m9s Average duration of sessions
- 0 Average queries per session
- 379ms Average queries duration per session
- 4m8s Average idle time per session
- 8,171 Total number of connections
- 11 connections/s at 2025-11-06 07:31:53 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2025-11-07 08:01:40 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-06 07:56:16 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2025-11-07 08:01:40 Date
Queries duration
Key values
- 51m42s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 34 0ms 54s332ms 14s732ms 53s542ms 1m2s 1m14s 08 5 0ms 9s921ms 8s228ms 0ms 0ms 35s639ms 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 8 0ms 8s218ms 6s705ms 0ms 25s889ms 27s755ms 21 1 0ms 15s379ms 15s379ms 0ms 0ms 15s379ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 28 0ms 1m6s 13s288ms 36s4ms 44s957ms 1m6s 08 12 0ms 11s892ms 7s302ms 0ms 17s341ms 46s341ms 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 3 0ms 6s391ms 6s93ms 0ms 0ms 18s280ms 20 6 0ms 6s534ms 5s630ms 0ms 0ms 33s780ms 21 1 0ms 15s531ms 15s531ms 0ms 0ms 15s531ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 26 0ms 46s92ms 16s701ms 44s149ms 53s825ms 1m 08 3 0ms 6s860ms 6s84ms 0ms 5s318ms 6s860ms 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 10 0ms 8s544ms 7s408ms 0ms 6s464ms 46s114ms 21 1 0ms 15s410ms 15s410ms 0ms 0ms 15s410ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 06 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 41 0ms 1m15s 15s575ms 53s419ms 1m2s 1m56s 08 9 0ms 5s879ms 5s335ms 10s124ms 11s81ms 15s859ms 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 2 0ms 10s265ms 9s894ms 0ms 0ms 19s788ms 20 3 0ms 5s800ms 5s334ms 0ms 0ms 10s203ms 21 1 0ms 15s290ms 15s290ms 0ms 0ms 15s290ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 07 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 29 0ms 50s562ms 16s416ms 50s411ms 1m7s 1m13s 08 12 0ms 8s385ms 6s475ms 0ms 38s17ms 39s688ms 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 3 0ms 5s462ms 5s371ms 0ms 0ms 16s115ms 20 9 0ms 12s314ms 8s835ms 0ms 18s738ms 44s665ms 21 1 0ms 15s106ms 15s106ms 0ms 0ms 15s106ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 08 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 5 27s495ms 0ms 0ms 1m14s 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 1 0 15s379ms 0ms 0ms 15s379ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 04 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 4 11s972ms 0ms 0ms 31s37ms 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 1 0 5s503ms 0ms 0ms 5s503ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 15s531ms 0ms 0ms 15s531ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 05 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 6 25s765ms 0ms 0ms 1m 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 2 0 8s497ms 0ms 0ms 16s994ms 21 1 0 15s410ms 0ms 0ms 15s410ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 06 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 3 6 28s822ms 0ms 0ms 1m56s 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 1 0 15s290ms 0ms 0ms 15s290ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 07 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 3 8 17s717ms 0ms 25s912ms 1m13s 08 1 0 6s226ms 0ms 0ms 6s226ms 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 10s118ms 0ms 0ms 10s118ms 21 1 0 15s106ms 0ms 0ms 15s106ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 08 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 1 0 10s620ms 0ms 0ms 5s703ms 08 0 1 0 0 9s921ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 1 0 11s583ms 0ms 0ms 5s616ms 08 1 0 0 0 5s8ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 05 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 1 0 18s560ms 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 1 0 0 0 8s536ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 1 0 12s801ms 0ms 0ms 9s406ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 1 0 1 0 15s10ms 0ms 0ms 9s617ms 08 0 0 2 0 6s946ms 0ms 0ms 6s243ms 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 1 0 0 0 12s314ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Nov 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 1 15 15.00 3.12% 08 1 5 5.00 20.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 8 8.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 04 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 10 10.00 0.00% 08 0 12 12.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 3 3.00 0.00% 20 0 6 6.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 05 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 4 4.00 0.00% 08 0 3 3.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 10 10.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 06 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 15 15.00 0.00% 08 1 9 9.00 11.11% 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 2 2.00 0.00% 20 0 3 3.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 07 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 5 5.00 0.00% 08 0 12 12.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 3 3.00 0.00% 20 0 9 9.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Nov 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 20 0.01/s 07 354 0.10/s 08 74 0.02/s 09 77 0.02/s 10 70 0.02/s 11 56 0.02/s 12 61 0.02/s 13 76 0.02/s 14 72 0.02/s 15 82 0.02/s 16 73 0.02/s 17 55 0.02/s 18 50 0.01/s 19 55 0.02/s 20 59 0.02/s 21 56 0.02/s 22 56 0.02/s 23 63 0.02/s Nov 04 00 42 0.01/s 01 60 0.02/s 02 40 0.01/s 03 41 0.01/s 04 40 0.01/s 05 61 0.02/s 06 41 0.01/s 07 350 0.10/s 08 59 0.02/s 09 30 0.01/s 10 21 0.01/s 11 26 0.01/s 12 44 0.01/s 13 39 0.01/s 14 30 0.01/s 15 30 0.01/s 16 47 0.01/s 17 53 0.01/s 18 35 0.01/s 19 59 0.02/s 20 50 0.01/s 21 61 0.02/s 22 51 0.01/s 23 55 0.02/s Nov 05 00 75 0.02/s 01 56 0.02/s 02 58 0.02/s 03 75 0.02/s 04 54 0.01/s 05 53 0.01/s 06 50 0.01/s 07 342 0.10/s 08 64 0.02/s 09 55 0.02/s 10 55 0.02/s 11 55 0.02/s 12 64 0.02/s 13 52 0.01/s 14 47 0.01/s 15 68 0.02/s 16 47 0.01/s 17 59 0.02/s 18 36 0.01/s 19 56 0.02/s 20 56 0.02/s 21 45 0.01/s 22 32 0.01/s 23 64 0.02/s Nov 06 00 52 0.01/s 01 60 0.02/s 02 47 0.01/s 03 54 0.01/s 04 45 0.01/s 05 56 0.02/s 06 38 0.01/s 07 349 0.10/s 08 43 0.01/s 09 47 0.01/s 10 60 0.02/s 11 54 0.01/s 12 59 0.02/s 13 56 0.02/s 14 49 0.01/s 15 43 0.01/s 16 49 0.01/s 17 50 0.01/s 18 23 0.01/s 19 64 0.02/s 20 40 0.01/s 21 38 0.01/s 22 52 0.01/s 23 48 0.01/s Nov 07 00 42 0.01/s 01 49 0.01/s 02 59 0.02/s 03 46 0.01/s 04 42 0.01/s 05 42 0.01/s 06 39 0.01/s 07 350 0.10/s 08 53 0.01/s 09 20 0.01/s 10 27 0.01/s 11 12 0.00/s 12 24 0.01/s 13 21 0.01/s 14 56 0.02/s 15 64 0.02/s 16 75 0.02/s 17 41 0.01/s 18 49 0.01/s 19 55 0.02/s 20 57 0.02/s 21 46 0.01/s 22 44 0.01/s 23 71 0.02/s Nov 08 00 59 0.02/s 01 54 0.01/s 02 49 0.01/s 03 55 0.02/s 04 52 0.01/s 05 44 0.01/s 06 40 0.01/s 07 51 0.01/s 08 50 0.01/s 09 48 0.01/s 10 47 0.01/s 11 52 0.01/s 12 36 0.01/s 13 45 0.01/s 14 33 0.01/s 15 59 0.02/s 16 40 0.01/s 17 27 0.01/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 02 00 2 72ms 72ms 01 2 71ms 71ms 02 2 74ms 74ms 03 2 75ms 75ms 04 2 78ms 78ms 05 2 72ms 72ms 06 2 75ms 75ms 07 2 72ms 72ms 08 2 72ms 72ms 09 2 71ms 71ms 10 2 74ms 74ms 11 2 77ms 77ms 12 2 73ms 73ms 13 2 238ms 238ms 14 2 74ms 74ms 15 2 81ms 81ms 16 2 78ms 78ms 17 2 79ms 79ms 18 2 76ms 76ms 19 2 76ms 76ms 20 2 75ms 75ms 21 2 72ms 72ms 22 2 78ms 78ms 23 2 74ms 74ms Nov 03 00 2 75ms 75ms 01 2 81ms 81ms 02 2 73ms 73ms 03 2 85ms 85ms 04 2 74ms 74ms 05 2 74ms 74ms 06 20 3m11s 3m11s 07 348 27s304ms 25s865ms 08 77 1m40s 1m39s 09 77 1m16s 1m16s 10 66 1m22s 1m22s 11 60 1m31s 1m31s 12 61 1m41s 1m41s 13 73 1m17s 1m17s 14 72 1m25s 1m25s 15 81 1m14s 1m14s 16 74 1m38s 1m38s 17 58 13m23s 13m23s 18 50 39m1s 39m1s 19 55 1m15s 1m15s 20 59 1m28s 1m27s 21 56 1m21s 1m20s 22 56 1m13s 1m13s 23 61 1m25s 1m25s Nov 04 00 44 1m14s 1m14s 01 60 1m15s 1m15s 02 40 1m15s 1m15s 03 41 1m15s 1m15s 04 40 1m21s 1m21s 05 61 1m16s 1m16s 06 44 52m17s 52m17s 07 345 25s830ms 24s751ms 08 57 2m1s 2m 09 30 3m28s 3m28s 10 24 16m43s 16m43s 11 26 4m43s 4m43s 12 43 2m54s 2m54s 13 40 2m29s 2m29s 14 30 2m43s 2m43s 15 31 50m1s 50m1s 16 47 1m19s 1m19s 17 49 1m27s 1m27s 18 39 12m8s 12m8s 19 59 1m24s 1m23s 20 50 1m25s 1m24s 21 61 1m21s 1m21s 22 47 1m28s 1m28s 23 59 1m17s 1m17s Nov 05 00 75 1m16s 1m16s 01 56 1m19s 1m19s 02 58 1m18s 1m18s 03 71 1m16s 1m16s 04 58 1m20s 1m20s 05 49 1m16s 1m16s 06 57 40m42s 40m42s 07 338 24s61ms 22s776ms 08 64 2m 2m 09 58 1m38s 1m38s 10 52 1m34s 1m34s 11 58 1m29s 1m29s 12 61 1m35s 1m35s 13 55 1m42s 1m42s 14 47 1m48s 1m48s 15 68 1m21s 1m21s 16 47 1m32s 1m32s 17 59 1m30s 1m30s 18 34 56m11s 56m11s 19 58 1m32s 1m32s 20 56 1m26s 1m25s 21 40 1m14s 1m13s 22 36 1m21s 1m21s 23 61 1m16s 1m16s Nov 06 00 56 1m14s 1m14s 01 59 1m13s 1m13s 02 44 1m18s 1m18s 03 53 1m13s 1m13s 04 50 1m14s 1m14s 05 56 1m13s 1m13s 06 41 55m57s 55m57s 07 345 26s366ms 24s515ms 08 44 1m55s 1m54s 09 47 1m19s 1m19s 10 57 1m24s 1m24s 11 57 1m23s 1m23s 12 56 1m18s 1m18s 13 58 1m12s 1m12s 14 47 1m5s 1m5s 15 46 1m13s 1m13s 16 49 1m19s 1m19s 17 50 1m19s 1m19s 18 23 1h23m12s 1h23m12s 19 64 1m26s 1m26s 20 40 1m46s 1m45s 21 38 1m37s 1m37s 22 48 1m30s 1m30s 23 50 1m29s 1m29s Nov 07 00 44 1m36s 1m36s 01 49 1m23s 1m23s 02 58 1m28s 1m28s 03 47 1m31s 1m31s 04 42 1m27s 1m27s 05 38 1m35s 1m35s 06 46 49m52s 49m52s 07 346 24s717ms 23s341ms 08 53 2m11s 2m10s 09 20 2m28s 2m28s 10 27 2m46s 2m46s 11 9 8m2s 8m2s 12 27 4m8s 4m8s 13 20 55s30ms 55s30ms 14 58 23m42s 23m42s 15 61 1m25s 1m25s 16 78 5m58s 5m58s 17 41 1m11s 1m11s 18 49 8m6s 8m6s 19 55 1m24s 1m23s 20 56 1m27s 1m25s 21 46 1m9s 1m8s 22 44 1m15s 1m15s 23 71 1m12s 1m12s Nov 08 00 59 1m18s 1m18s 01 54 1m14s 1m14s 02 49 1m13s 1m13s 03 55 1m14s 1m14s 04 52 1m10s 1m10s 05 44 1m10s 1m10s 06 40 1m11s 1m11s 07 48 1m14s 1m14s 08 53 1m13s 1m13s 09 48 1m16s 1m16s 10 47 1m14s 1m14s 11 52 1m15s 1m15s 12 35 1m12s 1m12s 13 46 1m17s 1m17s 14 33 1m7s 1m7s 15 59 1m13s 1m13s 16 39 1m23s 1m23s 17 28 1m11s 1m11s 18 6 11h51m30s 11h51m30s 19 3 82ms 82ms 20 3 103ms 103ms 21 3 71ms 71ms 22 3 68ms 68ms 23 3 69ms 69ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-11-06 07:31:53 Date
Connections per database
Key values
- reftk Main Database
- 8,171 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 8,171 connections Total
-
Sessions
Simultaneous sessions
Key values
- 157 sessions Session Peak
- 2025-11-08 16:58:46 Date
Histogram of session times
Key values
- 6,066 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 8,172 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 8,172 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 8,172 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 8,172 sessions Total
Application Count Total Duration Average Duration DBeaver 24.2.1 - Main 'reftk' 3 6h35m20s 2h11m46s DBeaver 24.2.1 - Metadata 'reftk' 3 6h35m2s 2h11m40s DBeaver 24.2.1 - SQLEditor 'Script-368.sql' 3 6h34m58s 2h11m39s IntelliJ IDEA 2024.3.5 1 475ms 475ms PostgreSQL JDBC Driver 6,182 22d12h35m36s 5m14s [unknown] 520 1m1s 117ms pg_dump 15 3h52m32s 15m30s psql 1,445 1h16m36s 3s181ms -
Temporary Files
Size of temporary files
Key values
- 256.34 MiB Temp Files size Peak
- 2025-11-07 07:28:19 Date
Number of temporary files
Key values
- 9 per second Temp Files Peak
- 2025-11-06 07:24:27 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 1 4.33 MiB 4.33 MiB 07 202 3.32 GiB 16.84 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 204 3.33 GiB 16.71 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 05 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 198 3.32 GiB 17.17 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 202 3.33 GiB 16.88 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 07 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 203 3.34 GiB 16.84 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Nov 02 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 08 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
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 16 Total read queries
- 220 Total write queries
Queries by database
Key values
- reftk Main database
- 248 Requests
- 51m22s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 248 Requests
User Request type Count Duration a3dsupervisor Total 248 51m22s copy to 29 12m21s ddl 68 13m38s delete 7 1m42s insert 7 56s201ms others 12 7m22s select 16 2m47s tcl 108 12m23s update 1 9s921ms Duration by user
Key values
- 51m22s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 248 51m22s copy to 29 12m21s ddl 68 13m38s delete 7 1m42s insert 7 56s201ms others 12 7m22s select 16 2m47s tcl 108 12m23s update 1 9s921ms Queries by host
Key values
- 10.3.0.4 Main host
- 248 Requests
- 51m22s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 139 Requests
- 21m1s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-04 10:52:07 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 157 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m15s COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-11-06 07:42:01 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 1m6s VACUUM ANALYZE;[ Date: 2025-11-04 07:26:27 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 54s332ms VACUUM ANALYZE;[ Date: 2025-11-03 07:27:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 53s961ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-11-06 07:43:36 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 50s562ms VACUUM ANALYZE;[ Date: 2025-11-07 07:31:24 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 46s92ms VACUUM ANALYZE;[ Date: 2025-11-05 07:32:51 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 45s605ms VACUUM ANALYZE;[ Date: 2025-11-06 07:30:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 41s142ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-11-06 07:42:42 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 39s775ms COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;[ Date: 2025-11-05 07:43:52 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 39s423ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2025-11-06 07:27:01 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 36s607ms VACUUM ANALYSE;[ Date: 2025-11-03 07:28:30 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
12 36s491ms 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-11-05 07:45:22 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 34s722ms VACUUM ANALYSE;[ Date: 2025-11-06 07:31:26 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
14 34s422ms COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;[ Date: 2025-11-07 07:43:10 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 34s30ms 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-11-06 07:44:10 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 33s86ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-11-05 07:44:46 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 33s56ms VACUUM ANALYSE;[ Date: 2025-11-07 07:32:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
18 32s847ms VACUUM ANALYSE;[ Date: 2025-11-05 07:33:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
19 32s225ms COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;[ Date: 2025-11-03 07:38:41 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 31s925ms COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;[ Date: 2025-11-03 07:39:13 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 12m23s 108 5s56ms 12s318ms 6s882ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 13 1m52s 8s663ms 09 4 31s218ms 7s804ms 21 8 53s644ms 6s705ms Nov 04 08 8 57s994ms 7s249ms 09 11 1m22s 7s511ms 20 2 12s776ms 6s388ms 21 6 33s780ms 5s630ms Nov 05 08 3 19s141ms 6s380ms 09 3 18s254ms 6s84ms 21 7 48s558ms 6s936ms Nov 06 08 10 58s99ms 5s809ms 09 9 48s21ms 5s335ms 20 2 19s788ms 9s894ms 21 3 16s4ms 5s334ms Nov 07 09 9 57s586ms 6s398ms 20 3 16s115ms 5s371ms 21 7 57s84ms 8s154ms [ User: a3dsupervisor - Total duration: 12m23s - Times executed: 108 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12m23s - Times executed: 108 ]
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s318ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s317ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s304ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m23s 5 45s605ms 1m6s 52s621ms vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 08 1 54s332ms 54s332ms Nov 04 08 1 1m6s 1m6s Nov 05 08 1 46s92ms 46s92ms Nov 06 08 1 45s605ms 45s605ms Nov 07 08 1 50s562ms 50s562ms [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 5 ]
[ Application: psql - Total duration: 4m23s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-04 07:26:27 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-03 07:27:44 Duration: 54s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-07 07:31:24 Duration: 50s562ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m16s 5 21s276ms 1m15s 39s299ms 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 Nov 03 08 1 30s591ms 30s591ms Nov 04 08 1 21s276ms 21s276ms Nov 05 08 1 39s775ms 39s775ms Nov 06 08 1 1m15s 1m15s Nov 07 08 1 29s540ms 29s540ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-11-06 07:42:01 Duration: 1m15s 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-11-05 07:43:52 Duration: 39s775ms 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-11-03 07:38:09 Duration: 30s591ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 2m48s 5 31s301ms 36s607ms 33s707ms vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 08 1 36s607ms 36s607ms Nov 04 08 1 31s301ms 31s301ms Nov 05 08 1 32s847ms 32s847ms Nov 06 08 1 34s722ms 34s722ms Nov 07 08 1 33s56ms 33s56ms [ User: a3dsupervisor - Total duration: 2m48s - Times executed: 5 ]
[ Application: psql - Total duration: 2m48s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-03 07:28:30 Duration: 36s607ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 07:31:26 Duration: 34s722ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 07:32:05 Duration: 33s56ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 2m21s 5 8s739ms 53s961ms 28s335ms 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 #5
Day Hour Count Duration Avg duration Nov 03 08 1 31s925ms 31s925ms Nov 04 08 1 8s739ms 8s739ms Nov 05 08 1 33s86ms 33s86ms Nov 06 08 1 53s961ms 53s961ms Nov 07 08 1 13s965ms 13s965ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m21s - 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-11-06 07:43:36 Duration: 53s961ms 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-11-05 07:44:46 Duration: 33s86ms 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-11-03 07:39:13 Duration: 31s925ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 2m16s 5 16s337ms 39s423ms 27s396ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 08 1 16s337ms 16s337ms Nov 04 08 1 25s387ms 25s387ms Nov 05 08 1 24s818ms 24s818ms Nov 06 08 1 39s423ms 39s423ms Nov 07 08 1 31s17ms 31s17ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 5 ]
[ Application: psql - Total duration: 2m16s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 07:27:01 Duration: 39s423ms 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-11-07 07:28:06 Duration: 31s17ms 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-11-04 07:22:56 Duration: 25s387ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 2m10s 5 8s113ms 36s491ms 26s33ms 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 #7
Day Hour Count Duration Avg duration Nov 03 08 1 26s993ms 26s993ms Nov 04 08 1 8s113ms 8s113ms Nov 05 08 1 36s491ms 36s491ms Nov 06 08 1 34s30ms 34s30ms Nov 07 08 1 24s541ms 24s541ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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-11-05 07:45:22 Duration: 36s491ms 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-11-06 07:44:10 Duration: 34s30ms 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-11-03 07:39:40 Duration: 26s993ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1m56s 5 9s761ms 41s142ms 23s355ms 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 #8
Day Hour Count Duration Avg duration Nov 03 08 1 32s225ms 32s225ms Nov 04 08 1 9s761ms 9s761ms Nov 05 08 1 20s738ms 20s738ms Nov 06 08 1 41s142ms 41s142ms Nov 07 08 1 12s911ms 12s911ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-06 07:42:42 Duration: 41s142ms 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-11-03 07:38:41 Duration: 32s225ms 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-11-05 07:44:13 Duration: 20s738ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1m35s 5 17s690ms 20s961ms 19s174ms 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 #9
Day Hour Count Duration Avg duration Nov 03 08 1 18s214ms 18s214ms Nov 04 08 1 17s690ms 17s690ms Nov 05 08 1 20s961ms 20s961ms Nov 06 08 1 18s948ms 18s948ms Nov 07 08 1 20s58ms 20s58ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 5 ]
[ Application: psql - Total duration: 1m35s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 07:31:12 Duration: 20s961ms 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-11-07 07:29:41 Duration: 20s58ms 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-11-06 07:28:44 Duration: 18s948ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m32s 5 15s388ms 23s241ms 18s434ms 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 Nov 03 08 1 19s261ms 19s261ms Nov 04 08 1 15s955ms 15s955ms Nov 05 08 1 15s388ms 15s388ms Nov 06 08 1 23s241ms 23s241ms Nov 07 08 1 18s327ms 18s327ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 5 ]
[ Application: psql - Total duration: 1m32s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-06 07:28:14 Duration: 23s241ms 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-11-03 07:25:28 Duration: 19s261ms 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-11-07 07:29:14 Duration: 18s327ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 1m28s 5 15s536ms 20s404ms 17s649ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 08 1 15s536ms 15s536ms Nov 04 08 1 17s550ms 17s550ms Nov 05 08 1 18s560ms 18s560ms Nov 06 08 1 16s197ms 16s197ms Nov 07 08 1 20s404ms 20s404ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m28s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 07:35:53 Duration: 20s404ms 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-11-05 07:37:48 Duration: 18s560ms 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-11-04 07:30:54 Duration: 17s550ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 1m23s 4 12s882ms 34s422ms 20s885ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 08 1 15s740ms 15s740ms Nov 05 08 1 12s882ms 12s882ms Nov 06 08 1 20s498ms 20s498ms Nov 07 08 1 34s422ms 34s422ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-07 07:43:10 Duration: 34s422ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-06 07:44:31 Duration: 20s498ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-03 07:39:56 Duration: 15s740ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 1m18s 5 12s829ms 18s517ms 15s740ms 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 Nov 03 08 1 15s745ms 15s745ms Nov 04 08 1 17s775ms 17s775ms Nov 05 08 1 13s834ms 13s834ms Nov 06 08 1 18s517ms 18s517ms Nov 07 08 1 12s829ms 12s829ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 07:27:19 Duration: 18s517ms 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-11-04 07:23:14 Duration: 17s775ms 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-11-03 07:24:39 Duration: 15s745ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 1m16s 5 15s106ms 15s531ms 15s343ms 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 #14
Day Hour Count Duration Avg duration Nov 03 22 1 15s379ms 15s379ms Nov 04 22 1 15s531ms 15s531ms Nov 05 22 1 15s410ms 15s410ms Nov 06 22 1 15s290ms 15s290ms Nov 07 22 1 15s106ms 15s106ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m16s - 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-11-04 21:33:19 Duration: 15s531ms 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-11-05 21:33:22 Duration: 15s410ms 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-11-03 21:33:22 Duration: 15s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 1m5s 5 11s392ms 15s76ms 13s114ms 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 Nov 03 08 1 12s982ms 12s982ms Nov 04 08 1 11s392ms 11s392ms Nov 05 08 1 12s226ms 12s226ms Nov 06 08 1 15s76ms 15s76ms Nov 07 08 1 13s894ms 13s894ms [ 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-11-06 07:26:00 Duration: 15s76ms 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-11-07 07:27:20 Duration: 13s894ms 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-11-03 07:23:48 Duration: 12s982ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 57s914ms 5 9s880ms 13s104ms 11s582ms 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 #16
Day Hour Count Duration Avg duration Nov 03 08 1 11s908ms 11s908ms Nov 04 08 1 11s763ms 11s763ms Nov 05 08 1 13s104ms 13s104ms Nov 06 08 1 11s257ms 11s257ms Nov 07 08 1 9s880ms 9s880ms [ User: a3dsupervisor - Total duration: 57s914ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s914ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 07:27:33 Duration: 13s104ms 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-11-03 07:22:30 Duration: 11s908ms 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-11-04 07:20:44 Duration: 11s763ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 49s291ms 5 7s614ms 15s98ms 9s858ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 08 1 7s643ms 7s643ms Nov 04 08 1 10s949ms 10s949ms Nov 05 08 1 7s985ms 7s985ms Nov 06 08 1 7s614ms 7s614ms Nov 07 08 1 15s98ms 15s98ms [ User: a3dsupervisor - Total duration: 49s291ms - Times executed: 5 ]
[ Application: psql - Total duration: 49s291ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 07:28:34 Duration: 15s98ms 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-11-04 07:23:25 Duration: 10s949ms 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-11-05 07:30:02 Duration: 7s985ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 46s911ms 5 7s279ms 13s887ms 9s382ms 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 Nov 03 08 1 8s705ms 8s705ms Nov 04 08 1 7s279ms 7s279ms Nov 05 08 1 13s887ms 13s887ms Nov 06 08 1 8s711ms 8s711ms Nov 07 08 1 8s328ms 8s328ms [ User: a3dsupervisor - Total duration: 46s911ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s911ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-05 07:30:27 Duration: 13s887ms 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-11-06 07:27:47 Duration: 8s711ms 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-11-03 07:25:06 Duration: 8s705ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 43s887ms 6 5s8ms 9s617ms 7s314ms 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 #19
Day Hour Count Duration Avg duration Nov 03 08 1 5s703ms 5s703ms Nov 04 08 1 5s616ms 5s616ms 09 1 5s8ms 5s8ms Nov 05 21 1 8s536ms 8s536ms Nov 06 08 1 9s406ms 9s406ms Nov 07 08 1 9s617ms 9s617ms [ User: a3dsupervisor - Total duration: 43s887ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s887ms - Times executed: 6 ]
-
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-11-07 07:56:25 Duration: 9s617ms 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-11-06 07:56:16 Duration: 9s406ms 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-11-05 20:41:58 Duration: 8s536ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 43s685ms 3 7s946ms 24s119ms 14s561ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 05 08 1 11s620ms 11s620ms Nov 06 08 1 7s946ms 7s946ms Nov 07 08 1 24s119ms 24s119ms [ User: a3dsupervisor - Total duration: 43s685ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 43s685ms - Times executed: 3 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-07 07:43:34 Duration: 24s119ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-05 07:45:47 Duration: 11s620ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-06 07:44:39 Duration: 7s946ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 108 12m23s 5s56ms 12s318ms 6s882ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 13 1m52s 8s663ms 09 4 31s218ms 7s804ms 21 8 53s644ms 6s705ms Nov 04 08 8 57s994ms 7s249ms 09 11 1m22s 7s511ms 20 2 12s776ms 6s388ms 21 6 33s780ms 5s630ms Nov 05 08 3 19s141ms 6s380ms 09 3 18s254ms 6s84ms 21 7 48s558ms 6s936ms Nov 06 08 10 58s99ms 5s809ms 09 9 48s21ms 5s335ms 20 2 19s788ms 9s894ms 21 3 16s4ms 5s334ms Nov 07 09 9 57s586ms 6s398ms 20 3 16s115ms 5s371ms 21 7 57s84ms 8s154ms [ User: a3dsupervisor - Total duration: 12m23s - Times executed: 108 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 12m23s - Times executed: 108 ]
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s318ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s317ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-03 07:59:05 Duration: 12s304ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6 43s887ms 5s8ms 9s617ms 7s314ms 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 Nov 03 08 1 5s703ms 5s703ms Nov 04 08 1 5s616ms 5s616ms 09 1 5s8ms 5s8ms Nov 05 21 1 8s536ms 8s536ms Nov 06 08 1 9s406ms 9s406ms Nov 07 08 1 9s617ms 9s617ms [ User: a3dsupervisor - Total duration: 43s887ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s887ms - Times executed: 6 ]
-
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-11-07 07:56:25 Duration: 9s617ms 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-11-06 07:56:16 Duration: 9s406ms 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-11-05 20:41:58 Duration: 8s536ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 4m23s 45s605ms 1m6s 52s621ms vacuum analyze;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 08 1 54s332ms 54s332ms Nov 04 08 1 1m6s 1m6s Nov 05 08 1 46s92ms 46s92ms Nov 06 08 1 45s605ms 45s605ms Nov 07 08 1 50s562ms 50s562ms [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 5 ]
[ Application: psql - Total duration: 4m23s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-04 07:26:27 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-03 07:27:44 Duration: 54s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-07 07:31:24 Duration: 50s562ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 3m16s 21s276ms 1m15s 39s299ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 08 1 30s591ms 30s591ms Nov 04 08 1 21s276ms 21s276ms Nov 05 08 1 39s775ms 39s775ms Nov 06 08 1 1m15s 1m15s Nov 07 08 1 29s540ms 29s540ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-11-06 07:42:01 Duration: 1m15s 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-11-05 07:43:52 Duration: 39s775ms 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-11-03 07:38:09 Duration: 30s591ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 5 2m48s 31s301ms 36s607ms 33s707ms vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 08 1 36s607ms 36s607ms Nov 04 08 1 31s301ms 31s301ms Nov 05 08 1 32s847ms 32s847ms Nov 06 08 1 34s722ms 34s722ms Nov 07 08 1 33s56ms 33s56ms [ User: a3dsupervisor - Total duration: 2m48s - Times executed: 5 ]
[ Application: psql - Total duration: 2m48s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-03 07:28:30 Duration: 36s607ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 07:31:26 Duration: 34s722ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 07:32:05 Duration: 33s56ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 5 2m21s 8s739ms 53s961ms 28s335ms copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 08 1 31s925ms 31s925ms Nov 04 08 1 8s739ms 8s739ms Nov 05 08 1 33s86ms 33s86ms Nov 06 08 1 53s961ms 53s961ms Nov 07 08 1 13s965ms 13s965ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m21s - 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-11-06 07:43:36 Duration: 53s961ms 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-11-05 07:44:46 Duration: 33s86ms 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-11-03 07:39:13 Duration: 31s925ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 5 2m16s 16s337ms 39s423ms 27s396ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 03 08 1 16s337ms 16s337ms Nov 04 08 1 25s387ms 25s387ms Nov 05 08 1 24s818ms 24s818ms Nov 06 08 1 39s423ms 39s423ms Nov 07 08 1 31s17ms 31s17ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 5 ]
[ Application: psql - Total duration: 2m16s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 07:27:01 Duration: 39s423ms 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-11-07 07:28:06 Duration: 31s17ms 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-11-04 07:22:56 Duration: 25s387ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 5 2m10s 8s113ms 36s491ms 26s33ms 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 #8
Day Hour Count Duration Avg duration Nov 03 08 1 26s993ms 26s993ms Nov 04 08 1 8s113ms 8s113ms Nov 05 08 1 36s491ms 36s491ms Nov 06 08 1 34s30ms 34s30ms Nov 07 08 1 24s541ms 24s541ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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-11-05 07:45:22 Duration: 36s491ms 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-11-06 07:44:10 Duration: 34s30ms 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-11-03 07:39:40 Duration: 26s993ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5 1m56s 9s761ms 41s142ms 23s355ms 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 #9
Day Hour Count Duration Avg duration Nov 03 08 1 32s225ms 32s225ms Nov 04 08 1 9s761ms 9s761ms Nov 05 08 1 20s738ms 20s738ms Nov 06 08 1 41s142ms 41s142ms Nov 07 08 1 12s911ms 12s911ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-06 07:42:42 Duration: 41s142ms 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-11-03 07:38:41 Duration: 32s225ms 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-11-05 07:44:13 Duration: 20s738ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 5 1m35s 17s690ms 20s961ms 19s174ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 08 1 18s214ms 18s214ms Nov 04 08 1 17s690ms 17s690ms Nov 05 08 1 20s961ms 20s961ms Nov 06 08 1 18s948ms 18s948ms Nov 07 08 1 20s58ms 20s58ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 5 ]
[ Application: psql - Total duration: 1m35s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 07:31:12 Duration: 20s961ms 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-11-07 07:29:41 Duration: 20s58ms 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-11-06 07:28:44 Duration: 18s948ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 5 1m32s 15s388ms 23s241ms 18s434ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 08 1 19s261ms 19s261ms Nov 04 08 1 15s955ms 15s955ms Nov 05 08 1 15s388ms 15s388ms Nov 06 08 1 23s241ms 23s241ms Nov 07 08 1 18s327ms 18s327ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 5 ]
[ Application: psql - Total duration: 1m32s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-06 07:28:14 Duration: 23s241ms 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-11-03 07:25:28 Duration: 19s261ms 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-11-07 07:29:14 Duration: 18s327ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 5 1m28s 15s536ms 20s404ms 17s649ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 08 1 15s536ms 15s536ms Nov 04 08 1 17s550ms 17s550ms Nov 05 08 1 18s560ms 18s560ms Nov 06 08 1 16s197ms 16s197ms Nov 07 08 1 20s404ms 20s404ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m28s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 07:35:53 Duration: 20s404ms 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-11-05 07:37:48 Duration: 18s560ms 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-11-04 07:30:54 Duration: 17s550ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 5 1m18s 12s829ms 18s517ms 15s740ms 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 Nov 03 08 1 15s745ms 15s745ms Nov 04 08 1 17s775ms 17s775ms Nov 05 08 1 13s834ms 13s834ms Nov 06 08 1 18s517ms 18s517ms Nov 07 08 1 12s829ms 12s829ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 07:27:19 Duration: 18s517ms 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-11-04 07:23:14 Duration: 17s775ms 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-11-03 07:24:39 Duration: 15s745ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 5 1m16s 15s106ms 15s531ms 15s343ms 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 #14
Day Hour Count Duration Avg duration Nov 03 22 1 15s379ms 15s379ms Nov 04 22 1 15s531ms 15s531ms Nov 05 22 1 15s410ms 15s410ms Nov 06 22 1 15s290ms 15s290ms Nov 07 22 1 15s106ms 15s106ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m16s - 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-11-04 21:33:19 Duration: 15s531ms 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-11-05 21:33:22 Duration: 15s410ms 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-11-03 21:33:22 Duration: 15s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 5 1m5s 11s392ms 15s76ms 13s114ms 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 Nov 03 08 1 12s982ms 12s982ms Nov 04 08 1 11s392ms 11s392ms Nov 05 08 1 12s226ms 12s226ms Nov 06 08 1 15s76ms 15s76ms Nov 07 08 1 13s894ms 13s894ms [ 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-11-06 07:26:00 Duration: 15s76ms 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-11-07 07:27:20 Duration: 13s894ms 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-11-03 07:23:48 Duration: 12s982ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5 57s914ms 9s880ms 13s104ms 11s582ms 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 #16
Day Hour Count Duration Avg duration Nov 03 08 1 11s908ms 11s908ms Nov 04 08 1 11s763ms 11s763ms Nov 05 08 1 13s104ms 13s104ms Nov 06 08 1 11s257ms 11s257ms Nov 07 08 1 9s880ms 9s880ms [ User: a3dsupervisor - Total duration: 57s914ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s914ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 07:27:33 Duration: 13s104ms 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-11-03 07:22:30 Duration: 11s908ms 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-11-04 07:20:44 Duration: 11s763ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5 49s291ms 7s614ms 15s98ms 9s858ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 08 1 7s643ms 7s643ms Nov 04 08 1 10s949ms 10s949ms Nov 05 08 1 7s985ms 7s985ms Nov 06 08 1 7s614ms 7s614ms Nov 07 08 1 15s98ms 15s98ms [ User: a3dsupervisor - Total duration: 49s291ms - Times executed: 5 ]
[ Application: psql - Total duration: 49s291ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 07:28:34 Duration: 15s98ms 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-11-04 07:23:25 Duration: 10s949ms 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-11-05 07:30:02 Duration: 7s985ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 5 46s911ms 7s279ms 13s887ms 9s382ms 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 Nov 03 08 1 8s705ms 8s705ms Nov 04 08 1 7s279ms 7s279ms Nov 05 08 1 13s887ms 13s887ms Nov 06 08 1 8s711ms 8s711ms Nov 07 08 1 8s328ms 8s328ms [ User: a3dsupervisor - Total duration: 46s911ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s911ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-05 07:30:27 Duration: 13s887ms 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-11-06 07:27:47 Duration: 8s711ms 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-11-03 07:25:06 Duration: 8s705ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5 43s511ms 5s503ms 10s118ms 8s702ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 20 1 5s503ms 5s503ms Nov 05 21 1 8s544ms 8s544ms Nov 06 08 1 9s409ms 9s409ms Nov 07 08 1 9s935ms 9s935ms 21 1 10s118ms 10s118ms [ User: a3dsupervisor - Total duration: 43s511ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s511ms - Times executed: 5 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-07 20:50:13 Duration: 10s118ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-07 07:56:25 Duration: 9s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-06 07:56:16 Duration: 9s409ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5 41s315ms 5s963ms 10s870ms 8s263ms 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 #20
Day Hour Count Duration Avg duration Nov 03 08 1 8s325ms 8s325ms Nov 04 08 1 8s462ms 8s462ms Nov 05 08 1 10s870ms 10s870ms Nov 06 08 1 7s693ms 7s693ms Nov 07 08 1 5s963ms 5s963ms [ User: a3dsupervisor - Total duration: 41s315ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s315ms - 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-11-05 07:31:28 Duration: 10s870ms 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-11-04 07:24:39 Duration: 8s462ms 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-11-03 07:26:08 Duration: 8s325ms 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 45s605ms 1m6s 52s621ms 5 4m23s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 08 1 54s332ms 54s332ms Nov 04 08 1 1m6s 1m6s Nov 05 08 1 46s92ms 46s92ms Nov 06 08 1 45s605ms 45s605ms Nov 07 08 1 50s562ms 50s562ms [ User: a3dsupervisor - Total duration: 4m23s - Times executed: 5 ]
[ Application: psql - Total duration: 4m23s - Times executed: 5 ]
-
VACUUM ANALYZE;
Date: 2025-11-04 07:26:27 Duration: 1m6s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-03 07:27:44 Duration: 54s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-11-07 07:31:24 Duration: 50s562ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 21s276ms 1m15s 39s299ms 5 3m16s 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 Nov 03 08 1 30s591ms 30s591ms Nov 04 08 1 21s276ms 21s276ms Nov 05 08 1 39s775ms 39s775ms Nov 06 08 1 1m15s 1m15s Nov 07 08 1 29s540ms 29s540ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-11-06 07:42:01 Duration: 1m15s 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-11-05 07:43:52 Duration: 39s775ms 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-11-03 07:38:09 Duration: 30s591ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 31s301ms 36s607ms 33s707ms 5 2m48s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 08 1 36s607ms 36s607ms Nov 04 08 1 31s301ms 31s301ms Nov 05 08 1 32s847ms 32s847ms Nov 06 08 1 34s722ms 34s722ms Nov 07 08 1 33s56ms 33s56ms [ User: a3dsupervisor - Total duration: 2m48s - Times executed: 5 ]
[ Application: psql - Total duration: 2m48s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-03 07:28:30 Duration: 36s607ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 07:31:26 Duration: 34s722ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 07:32:05 Duration: 33s56ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 8s739ms 53s961ms 28s335ms 5 2m21s 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 #4
Day Hour Count Duration Avg duration Nov 03 08 1 31s925ms 31s925ms Nov 04 08 1 8s739ms 8s739ms Nov 05 08 1 33s86ms 33s86ms Nov 06 08 1 53s961ms 53s961ms Nov 07 08 1 13s965ms 13s965ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m21s - 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-11-06 07:43:36 Duration: 53s961ms 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-11-05 07:44:46 Duration: 33s86ms 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-11-03 07:39:13 Duration: 31s925ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 16s337ms 39s423ms 27s396ms 5 2m16s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 08 1 16s337ms 16s337ms Nov 04 08 1 25s387ms 25s387ms Nov 05 08 1 24s818ms 24s818ms Nov 06 08 1 39s423ms 39s423ms Nov 07 08 1 31s17ms 31s17ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 5 ]
[ Application: psql - Total duration: 2m16s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-11-06 07:27:01 Duration: 39s423ms 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-11-07 07:28:06 Duration: 31s17ms 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-11-04 07:22:56 Duration: 25s387ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 8s113ms 36s491ms 26s33ms 5 2m10s 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 #6
Day Hour Count Duration Avg duration Nov 03 08 1 26s993ms 26s993ms Nov 04 08 1 8s113ms 8s113ms Nov 05 08 1 36s491ms 36s491ms Nov 06 08 1 34s30ms 34s30ms Nov 07 08 1 24s541ms 24s541ms [ User: a3dsupervisor - Total duration: 2m10s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m10s - 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-11-05 07:45:22 Duration: 36s491ms 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-11-06 07:44:10 Duration: 34s30ms 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-11-03 07:39:40 Duration: 26s993ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 9s761ms 41s142ms 23s355ms 5 1m56s 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 #7
Day Hour Count Duration Avg duration Nov 03 08 1 32s225ms 32s225ms Nov 04 08 1 9s761ms 9s761ms Nov 05 08 1 20s738ms 20s738ms Nov 06 08 1 41s142ms 41s142ms Nov 07 08 1 12s911ms 12s911ms [ User: a3dsupervisor - Total duration: 1m56s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-11-06 07:42:42 Duration: 41s142ms 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-11-03 07:38:41 Duration: 32s225ms 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-11-05 07:44:13 Duration: 20s738ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 12s882ms 34s422ms 20s885ms 4 1m23s copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 08 1 15s740ms 15s740ms Nov 05 08 1 12s882ms 12s882ms Nov 06 08 1 20s498ms 20s498ms Nov 07 08 1 34s422ms 34s422ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-07 07:43:10 Duration: 34s422ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-06 07:44:31 Duration: 20s498ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-11-03 07:39:56 Duration: 15s740ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 17s690ms 20s961ms 19s174ms 5 1m35s 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 #9
Day Hour Count Duration Avg duration Nov 03 08 1 18s214ms 18s214ms Nov 04 08 1 17s690ms 17s690ms Nov 05 08 1 20s961ms 20s961ms Nov 06 08 1 18s948ms 18s948ms Nov 07 08 1 20s58ms 20s58ms [ User: a3dsupervisor - Total duration: 1m35s - Times executed: 5 ]
[ Application: psql - Total duration: 1m35s - Times executed: 5 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-05 07:31:12 Duration: 20s961ms 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-11-07 07:29:41 Duration: 20s58ms 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-11-06 07:28:44 Duration: 18s948ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 15s388ms 23s241ms 18s434ms 5 1m32s 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 Nov 03 08 1 19s261ms 19s261ms Nov 04 08 1 15s955ms 15s955ms Nov 05 08 1 15s388ms 15s388ms Nov 06 08 1 23s241ms 23s241ms Nov 07 08 1 18s327ms 18s327ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 5 ]
[ Application: psql - Total duration: 1m32s - Times executed: 5 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-11-06 07:28:14 Duration: 23s241ms 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-11-03 07:25:28 Duration: 19s261ms 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-11-07 07:29:14 Duration: 18s327ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 15s536ms 20s404ms 17s649ms 5 1m28s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 08 1 15s536ms 15s536ms Nov 04 08 1 17s550ms 17s550ms Nov 05 08 1 18s560ms 18s560ms Nov 06 08 1 16s197ms 16s197ms Nov 07 08 1 20s404ms 20s404ms [ User: a3dsupervisor - Total duration: 1m28s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m28s - Times executed: 5 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2025-11-07 07:35:53 Duration: 20s404ms 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-11-05 07:37:48 Duration: 18s560ms 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-11-04 07:30:54 Duration: 17s550ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 12s829ms 18s517ms 15s740ms 5 1m18s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 08 1 15s745ms 15s745ms Nov 04 08 1 17s775ms 17s775ms Nov 05 08 1 13s834ms 13s834ms Nov 06 08 1 18s517ms 18s517ms Nov 07 08 1 12s829ms 12s829ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 5 ]
[ Application: psql - Total duration: 1m18s - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-11-06 07:27:19 Duration: 18s517ms 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-11-04 07:23:14 Duration: 17s775ms 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-11-03 07:24:39 Duration: 15s745ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 15s106ms 15s531ms 15s343ms 5 1m16s 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 #13
Day Hour Count Duration Avg duration Nov 03 22 1 15s379ms 15s379ms Nov 04 22 1 15s531ms 15s531ms Nov 05 22 1 15s410ms 15s410ms Nov 06 22 1 15s290ms 15s290ms Nov 07 22 1 15s106ms 15s106ms [ User: a3dsupervisor - Total duration: 1m16s - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m16s - 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-11-04 21:33:19 Duration: 15s531ms 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-11-05 21:33:22 Duration: 15s410ms 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-11-03 21:33:22 Duration: 15s379ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 7s946ms 24s119ms 14s561ms 3 43s685ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 05 08 1 11s620ms 11s620ms Nov 06 08 1 7s946ms 7s946ms Nov 07 08 1 24s119ms 24s119ms [ User: a3dsupervisor - Total duration: 43s685ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 43s685ms - Times executed: 3 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-07 07:43:34 Duration: 24s119ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-05 07:45:47 Duration: 11s620ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-11-06 07:44:39 Duration: 7s946ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 11s392ms 15s76ms 13s114ms 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 #15
Day Hour Count Duration Avg duration Nov 03 08 1 12s982ms 12s982ms Nov 04 08 1 11s392ms 11s392ms Nov 05 08 1 12s226ms 12s226ms Nov 06 08 1 15s76ms 15s76ms Nov 07 08 1 13s894ms 13s894ms [ 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-11-06 07:26:00 Duration: 15s76ms 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-11-07 07:27:20 Duration: 13s894ms 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-11-03 07:23:48 Duration: 12s982ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 9s880ms 13s104ms 11s582ms 5 57s914ms 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 #16
Day Hour Count Duration Avg duration Nov 03 08 1 11s908ms 11s908ms Nov 04 08 1 11s763ms 11s763ms Nov 05 08 1 13s104ms 13s104ms Nov 06 08 1 11s257ms 11s257ms Nov 07 08 1 9s880ms 9s880ms [ User: a3dsupervisor - Total duration: 57s914ms - Times executed: 5 ]
[ Application: psql - Total duration: 57s914ms - Times executed: 5 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-11-05 07:27:33 Duration: 13s104ms 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-11-03 07:22:30 Duration: 11s908ms 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-11-04 07:20:44 Duration: 11s763ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 7s614ms 15s98ms 9s858ms 5 49s291ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 08 1 7s643ms 7s643ms Nov 04 08 1 10s949ms 10s949ms Nov 05 08 1 7s985ms 7s985ms Nov 06 08 1 7s614ms 7s614ms Nov 07 08 1 15s98ms 15s98ms [ User: a3dsupervisor - Total duration: 49s291ms - Times executed: 5 ]
[ Application: psql - Total duration: 49s291ms - Times executed: 5 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-11-07 07:28:34 Duration: 15s98ms 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-11-04 07:23:25 Duration: 10s949ms 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-11-05 07:30:02 Duration: 7s985ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 7s279ms 13s887ms 9s382ms 5 46s911ms 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 Nov 03 08 1 8s705ms 8s705ms Nov 04 08 1 7s279ms 7s279ms Nov 05 08 1 13s887ms 13s887ms Nov 06 08 1 8s711ms 8s711ms Nov 07 08 1 8s328ms 8s328ms [ User: a3dsupervisor - Total duration: 46s911ms - Times executed: 5 ]
[ Application: psql - Total duration: 46s911ms - Times executed: 5 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-05 07:30:27 Duration: 13s887ms 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-11-06 07:27:47 Duration: 8s711ms 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-11-03 07:25:06 Duration: 8s705ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5s503ms 10s118ms 8s702ms 5 43s511ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 04 20 1 5s503ms 5s503ms Nov 05 21 1 8s544ms 8s544ms Nov 06 08 1 9s409ms 9s409ms Nov 07 08 1 9s935ms 9s935ms 21 1 10s118ms 10s118ms [ User: a3dsupervisor - Total duration: 43s511ms - Times executed: 5 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 43s511ms - Times executed: 5 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-07 20:50:13 Duration: 10s118ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-07 07:56:25 Duration: 9s935ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2025-11-06 07:56:16 Duration: 9s409ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s963ms 10s870ms 8s263ms 5 41s315ms 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 #20
Day Hour Count Duration Avg duration Nov 03 08 1 8s325ms 8s325ms Nov 04 08 1 8s462ms 8s462ms Nov 05 08 1 10s870ms 10s870ms Nov 06 08 1 7s693ms 7s693ms Nov 07 08 1 5s963ms 5s963ms [ User: a3dsupervisor - Total duration: 41s315ms - Times executed: 5 ]
[ Application: psql - Total duration: 41s315ms - 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-11-05 07:31:28 Duration: 10s870ms 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-11-04 07:24:39 Duration: 8s462ms 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-11-03 07:26:08 Duration: 8s325ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 45,174 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 19313 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 19,199 Max number of times the same event was reported
- 19,394 Total events found
Rank Times reported Error 1 19,199 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 03 08 93 09 235 10 89 11 692 12 134 13 998 14 235 15 90 16 116 17 523 18 100 19 239 20 142 21 48 22 69 23 131 00 328 Nov 04 01 85 02 15 03 1 04 3 05 2 08 100 09 393 10 48 11 752 12 95 13 338 14 388 15 242 16 48 17 195 18 97 19 257 20 84 21 46 22 173 23 24 00 24 Nov 05 01 1 02 3 05 1 08 137 09 195 10 390 11 569 12 392 13 700 14 197 15 148 16 145 17 122 18 197 19 273 20 141 21 88 22 3 23 42 00 482 Nov 06 01 35 02 76 03 1 04 1 05 1 08 90 09 237 10 275 11 199 12 290 13 459 14 254 15 197 16 234 17 14 18 194 19 223 20 377 21 149 22 51 23 47 00 203 Nov 07 01 137 02 65 03 3 04 1 05 1 08 112 09 234 10 229 11 147 12 371 13 442 14 524 15 397 16 173 17 139 18 56 19 140 20 95 21 45 22 47 23 116 00 100 Nov 08 01 120 2 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 03 08 16 Nov 04 08 16 Nov 05 08 16 Nov 06 08 16 Nov 07 08 16 3 44 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 03 19 6 Nov 04 11 3 16 4 19 4 Nov 05 19 4 Nov 06 19 3 Nov 07 15 3 17 11 19 3 Nov 08 19 3 4 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 07 16 8 5 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 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 Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 7 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 #7
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 8 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 #8
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 9 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 10 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 #10
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 11 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 12 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 #12
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 13 5 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 14 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 03 08 1 Nov 04 08 1 Nov 05 08 1 Nov 06 08 1 Nov 07 08 1 15 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 #15
Day Hour Count Nov 06 08 1 Nov 07 08 1 16 2 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 07 16 2 17 2 ERROR: relation "..." does not existDO $$ DECLARE rtId_list TEXT; BEGIN -- OI SELECT array_to_string(...), ', ' ) INTO rtId_list from (...) grt; EXECUTE format(...) WITH (...)', rtId_list ); END $$
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 07 16 2 18 1 ERROR: "..." is not partitionedDO $$ DECLARE rtId_list TEXT; BEGIN -- OI SELECT array_to_string(...), ', ' ) INTO rtId_list from (...) grt; EXECUTE format(...) WITH (...)', rtId_list ); END $$
Times Reported Most Frequent Error / Event #18
Day Hour Count Nov 07 16 1 19 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 #19
Day Hour Count Nov 06 08 1 20 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE gtp_log_ehcache ALTER COLUMN used_memory_average SET NOT NULL
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 06 08 1 21 1 ERROR: relation "..." already existsDO $$ DECLARE rtOiId_list int[]; rtId_tmpList int[]; BEGIN -- OI SELECT array_agg(...) INTO rtOiId_list from (...) grt; EXECUTE(...)||') WITH (...)' ); -- Tâche SELECT array_agg(...) INTO rtId_tmpList from (...) grt where grt.rel_template_num_id <> ALL (...) ; EXECUTE(...)||') WITH (...)' ); END $$
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 07 16 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON gtp_obj_composition (...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 05 08 1 23 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 06 07 1 24 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 06 07 1