pgBadger-
Global information
- Generated on Mon Sep 29 09:35:59 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=27/h=23/m=00/PT1H.log
- Parsed 238,016 log entries in 1m34s
- Log start from 2025-09-23 00:00:03 to 2025-09-27 17:01:56
-
Overview
Global Stats
- 42 Number of unique normalized queries
- 212 Number of queries
- 40m40s Total query duration
- 2025-09-23 06:23:27 First query
- 2025-09-26 20:33:59 Last query
- 4 queries/s at 2025-09-23 07:48:37 Query peak
- 40m40s Total query duration
- 1m2s Prepare/parse total duration
- 12s773ms Bind total duration
- 39m25s Execute total duration
- 107,074 Number of events
- 16 Number of unique normalized events
- 103,884 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
- 791 Number temporary file
- 2.30 GiB Max size of temporary file
- 16.48 MiB Average size of temporary file
- 7,549 Total number of sessions
- 43 sessions at 2025-09-27 00:57:48 Session peak
- 21d13h15m15s Total duration of sessions
- 4m6s Average duration of sessions
- 0 Average queries per session
- 323ms Average queries duration per session
- 4m6s Average idle time per session
- 7,547 Total number of connections
- 11 connections/s at 2025-09-24 06:29:48 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-09-23 07:48:37 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2025-09-23 07:48:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-09-23 07:46:10 Date
Queries duration
Key values
- 40m40s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 33 0ms 1m23s 14s843ms 49s200ms 1m15s 1m23s 07 38 0ms 13s725ms 7s500ms 24s430ms 31s769ms 58s516ms 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 1 0ms 28s957ms 28s957ms 0ms 0ms 28s957ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 24 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 23 0ms 52s503ms 12s197ms 32s884ms 52s156ms 1m25s 07 10 0ms 7s514ms 6s241ms 0ms 6s95ms 31s861ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 3 0ms 13s808ms 8s744ms 0ms 0ms 26s232ms 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 5 0ms 5s408ms 5s181ms 0ms 5s10ms 15s854ms 19 5 0ms 7s466ms 6s247ms 0ms 6s871ms 24s363ms 20 1 0ms 30s564ms 30s564ms 0ms 0ms 30s564ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 25 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 24 0ms 45s292ms 12s755ms 34s300ms 45s292ms 49s399ms 07 12 0ms 7s906ms 5s760ms 5s223ms 6s806ms 26s409ms 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 5 0ms 6s263ms 5s736ms 0ms 5s845ms 16s575ms 19 7 0ms 8s755ms 6s171ms 0ms 10s354ms 22s263ms 20 1 0ms 30s5ms 30s5ms 0ms 0ms 30s5ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 26 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 35 0ms 1m30s 15s806ms 52s669ms 1m20s 1m30s 07 6 0ms 6s262ms 5s802ms 0ms 6s52ms 23s183ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 6s368ms 6s368ms 0ms 0ms 6s368ms 19 1 0ms 5s504ms 5s504ms 0ms 0ms 5s504ms 20 1 0ms 27s922ms 27s922ms 0ms 0ms 27s922ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 27 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 7 24s117ms 0ms 0ms 1m23s 07 4 0 8s846ms 0ms 0ms 7s209ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 1 0 28s957ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 24 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 1 4 10s406ms 0ms 0ms 46s697ms 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 1 0 5s290ms 0ms 0ms 5s290ms 20 1 0 30s564ms 0ms 0ms 30s564ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 25 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 5 11s292ms 0ms 0ms 39s188ms 07 1 0 6s806ms 0ms 0ms 6s806ms 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 5s183ms 0ms 0ms 5s183ms 20 1 0 30s5ms 0ms 0ms 30s5ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 26 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 9 27s893ms 0ms 26s261ms 1m30s 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 1 0 27s922ms 0ms 0ms 27s922ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 27 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 3 2 1 0 8s674ms 0ms 0ms 9s 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 0 5s492ms 0ms 0ms 0ms 07 1 0 0 0 6s95ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 1 0 0 13s808ms 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 1 0 0 0 5s334ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 1 0 1 0 6s963ms 0ms 0ms 5s171ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 26 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 1 0 0 0 5s504ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 23 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 10 10.00 0.00% 07 2 38 19.00 5.26% 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 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 24 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 4 4.00 0.00% 07 2 10 5.00 20.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 3 3.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 5 5.00 0.00% 19 0 5 5.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 25 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 1 12 12.00 8.33% 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 5 5.00 0.00% 19 0 7 7.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 2 8 4.00 6.06% 07 0 6 6.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 27 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 23 00 62 0.02/s 01 67 0.02/s 02 69 0.02/s 03 60 0.02/s 04 74 0.02/s 05 42 0.01/s 06 358 0.10/s 07 58 0.02/s 08 49 0.01/s 09 34 0.01/s 10 39 0.01/s 11 41 0.01/s 12 44 0.01/s 13 35 0.01/s 14 30 0.01/s 15 26 0.01/s 16 41 0.01/s 17 52 0.01/s 18 63 0.02/s 19 50 0.01/s 20 41 0.01/s 21 58 0.02/s 22 50 0.01/s 23 53 0.01/s Sep 24 00 52 0.01/s 01 40 0.01/s 02 64 0.02/s 03 65 0.02/s 04 56 0.02/s 05 37 0.01/s 06 356 0.10/s 07 46 0.01/s 08 70 0.02/s 09 59 0.02/s 10 66 0.02/s 11 56 0.02/s 12 62 0.02/s 13 51 0.01/s 14 73 0.02/s 15 59 0.02/s 16 41 0.01/s 17 37 0.01/s 18 60 0.02/s 19 47 0.01/s 20 69 0.02/s 21 73 0.02/s 22 56 0.02/s 23 49 0.01/s Sep 25 00 52 0.01/s 01 66 0.02/s 02 66 0.02/s 03 67 0.02/s 04 63 0.02/s 05 55 0.02/s 06 362 0.10/s 07 50 0.01/s 08 47 0.01/s 09 72 0.02/s 10 55 0.02/s 11 69 0.02/s 12 58 0.02/s 13 52 0.01/s 14 73 0.02/s 15 51 0.01/s 16 69 0.02/s 17 47 0.01/s 18 72 0.02/s 19 62 0.02/s 20 63 0.02/s 21 62 0.02/s 22 59 0.02/s 23 73 0.02/s Sep 26 00 72 0.02/s 01 67 0.02/s 02 62 0.02/s 03 60 0.02/s 04 73 0.02/s 05 57 0.02/s 06 354 0.10/s 07 37 0.01/s 08 65 0.02/s 09 43 0.01/s 10 53 0.01/s 11 56 0.02/s 12 75 0.02/s 13 52 0.01/s 14 64 0.02/s 15 61 0.02/s 16 47 0.01/s 17 38 0.01/s 18 68 0.02/s 19 55 0.02/s 20 59 0.02/s 21 58 0.02/s 22 52 0.01/s 23 58 0.02/s Sep 27 00 57 0.02/s 01 60 0.02/s 02 60 0.02/s 03 56 0.02/s 04 49 0.01/s 05 62 0.02/s 06 60 0.02/s 07 53 0.01/s 08 55 0.02/s 09 50 0.01/s 10 53 0.01/s 11 47 0.01/s 12 63 0.02/s 13 63 0.02/s 14 58 0.02/s 15 50 0.01/s 16 43 0.01/s 17 5 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 23 00 63 1m43s 1m43s 01 67 1m34s 1m34s 02 68 1m27s 1m27s 03 61 1m34s 1m34s 04 73 1m26s 1m26s 05 46 48m31s 48m31s 06 352 29s811ms 28s419ms 07 58 2m2s 1m57s 08 49 3m32s 3m32s 09 34 1m30s 1m30s 10 37 3m25s 3m25s 11 43 2m17s 2m17s 12 44 2m23s 2m23s 13 35 2m13s 2m13s 14 29 3m23s 3m23s 15 27 3m3s 3m3s 16 40 2m14s 2m14s 17 54 36m32s 36m32s 18 57 1m22s 1m22s 19 56 1m40s 1m40s 20 39 1m48s 1m47s 21 60 1m15s 1m15s 22 47 1m43s 1m43s 23 52 1m31s 1m31s Sep 24 00 54 1m30s 1m30s 01 42 1m32s 1m32s 02 64 1m26s 1m26s 03 62 1m23s 1m23s 04 59 1m19s 1m19s 05 40 58m11s 58m11s 06 350 24s694ms 23s892ms 07 49 2m14s 2m13s 08 69 1m57s 1m57s 09 59 1m48s 1m48s 10 66 1m54s 1m53s 11 57 1m24s 1m24s 12 62 1m24s 1m24s 13 51 1m30s 1m30s 14 73 1m19s 1m19s 15 55 1m25s 1m25s 16 45 1m33s 1m33s 17 37 52m30s 52m30s 18 59 1m22s 1m21s 19 48 2m2s 2m2s 20 69 1m28s 1m27s 21 70 1m25s 1m25s 22 59 1m23s 1m23s 23 49 1m27s 1m27s Sep 25 00 52 1m27s 1m27s 01 66 1m17s 1m17s 02 63 1m18s 1m18s 03 70 1m15s 1m15s 04 63 1m16s 1m16s 05 58 39m51s 39m51s 06 355 26s569ms 25s707ms 07 50 2m13s 2m11s 08 50 4m36s 4m36s 09 68 1m26s 1m26s 10 55 1m25s 1m25s 11 71 1m20s 1m20s 12 57 1m23s 1m23s 13 48 1m23s 1m23s 14 79 1m21s 1m21s 15 52 5m36s 5m36s 16 70 1m21s 1m21s 17 46 42m31s 42m31s 18 68 1m21s 1m21s 19 66 1m33s 1m33s 20 59 1m20s 1m19s 21 67 1m22s 1m22s 22 59 1m30s 1m30s 23 71 1m24s 1m24s Sep 26 00 71 1m22s 1m22s 01 70 1m20s 1m20s 02 58 1m24s 1m24s 03 63 1m16s 1m16s 04 74 1m17s 1m17s 05 60 38m31s 38m31s 06 349 27s443ms 25s858ms 07 39 2m13s 2m12s 08 65 1m16s 1m16s 09 43 1m29s 1m29s 10 53 1m30s 1m30s 11 56 1m59s 1m59s 12 74 1m15s 1m15s 13 53 1m26s 1m26s 14 64 1m13s 1m13s 15 61 26m30s 26m30s 16 47 1m20s 1m20s 17 38 10m12s 10m12s 18 68 1m24s 1m24s 19 55 1m25s 1m25s 20 59 1m20s 1m19s 21 58 1m33s 1m33s 22 52 1m24s 1m24s 23 58 1m16s 1m16s Sep 27 00 53 1m22s 1m22s 01 64 1m15s 1m15s 02 57 1m22s 1m22s 03 59 1m18s 1m18s 04 45 1m19s 1m19s 05 65 1m15s 1m15s 06 61 1m20s 1m20s 07 53 1m20s 1m20s 08 55 1m16s 1m16s 09 50 1m19s 1m19s 10 53 1m26s 1m26s 11 43 1m17s 1m17s 12 66 1m19s 1m19s 13 64 1m19s 1m19s 14 58 1m16s 1m16s 15 50 1m22s 1m22s 16 43 1m20s 1m20s 17 8 8h54m53s 8h54m53s 18 2 76ms 76ms 19 2 74ms 74ms 20 2 79ms 79ms 21 2 79ms 79ms 22 2 75ms 75ms 23 2 83ms 83ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-24 06:29:48 Date
Connections per database
Key values
- reftk Main Database
- 7,547 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 7,547 connections Total
-
Sessions
Simultaneous sessions
Key values
- 43 sessions Session Peak
- 2025-09-27 00:57:48 Date
Histogram of session times
Key values
- 5,987 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 7,549 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 7,549 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 7,549 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 7,549 sessions Total
Application Count Total Duration Average Duration DBeaver 25.0.5 - Main 'reftk' 4 3h26m37s 51m39s DBeaver 25.0.5 - Metadata 'reftk' 5 3h55m13s 47m2s DBeaver 25.0.5 - Read PostgreSQL database list 4 3s212ms 803ms DBeaver 25.0.5 - SQLEditor 'Script-10.sql' 1 1m 1m IntelliJ IDEA 2024.3.5 2 2s674ms 1s337ms PostgreSQL JDBC Driver 6,070 21d1h38m22s 4m59s [unknown] 295 38s730ms 131ms pg_dump 12 3h16m33s 16m22s psql 1,156 56m43s 2s944ms -
Temporary Files
Size of temporary files
Key values
- 209.91 MiB Temp Files size Peak
- 2025-09-26 06:26:39 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2025-09-23 06:24:53 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 196 3.17 GiB 16.57 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 198 3.18 GiB 16.46 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 196 3.18 GiB 16.63 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 201 3.19 GiB 16.27 MiB 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 25 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessShareLock Main Lock Type
- 1 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
- 12 Total read queries
- 192 Total write queries
Queries by database
Key values
- reftk Main database
- 212 Requests
- 39m25s (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 212 Requests
User Request type Count Duration a3dsupervisor Total 212 39m25s copy to 25 8m43s ddl 58 9m50s delete 2 17s756ms insert 8 57s513ms others 8 6m8s select 12 2m55s tcl 96 10m6s update 3 26s939ms Duration by user
Key values
- 39m25s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 212 39m25s copy to 25 8m43s ddl 58 9m50s delete 2 17s756ms insert 8 57s513ms others 8 6m8s select 12 2m55s tcl 96 10m6s update 3 26s939ms Queries by host
Key values
- 10.3.0.4 Main host
- 212 Requests
- 39m25s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 120 Requests
- 15m58s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-23 04:06:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 153 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m30s 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-09-26 06:43:36 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 1m23s 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-09-23 06:43:37 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 1m15s VACUUM ANALYZE;[ Date: 2025-09-23 06:29:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m7s VACUUM ANALYZE;[ Date: 2025-09-26 06:29:58 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 52s503ms VACUUM ANALYZE;[ Date: 2025-09-24 06:28:03 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 45s292ms VACUUM ANALYZE;[ Date: 2025-09-25 06:24:24 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 43s395ms 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-09-26 06:42:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 34s300ms VACUUM ANALYSE;[ Date: 2025-09-25 06:25:08 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 33s474ms 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-09-26 06:44:10 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 33s106ms VACUUM ANALYSE;[ Date: 2025-09-24 06:28:45 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 30s564ms 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-09-24 20:33:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
12 30s255ms VACUUM ANALYSE;[ Date: 2025-09-26 06:30:36 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
13 30s5ms 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-09-25 20:34:02 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
14 29s838ms VACUUM ANALYSE;[ Date: 2025-09-23 06:31:15 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 28s957ms 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-09-23 20:33:02 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
16 27s922ms 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-09-26 20:33:59 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
17 27s744ms 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-09-23 06:44:29 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 26s261ms 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-09-26 06:41:22 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 24s223ms 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-09-23 06:44:01 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 22s926ms ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-09-26 06:27:58 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 10m6s 96 5s10ms 13s725ms 6s317ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 10 1m4s 6s460ms 09 28 3m17s 7s56ms Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms Sep 25 08 2 10s134ms 5s67ms 09 11 1m2s 5s664ms 20 5 28s684ms 5s736ms 21 4 24s93ms 6s23ms Sep 26 08 8 48s965ms 6s120ms 09 6 34s812ms 5s802ms 20 1 6s368ms 6s368ms [ User: a3dsupervisor - Total duration: 10m6s - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10m6s - Times executed: 96 ]
-
COMMIT;
Date: 2025-09-23 07:48:37 Duration: 13s725ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s431ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s430ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 4m 4 45s292ms 1m15s 1m vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 1m15s 1m15s Sep 24 08 1 52s503ms 52s503ms Sep 25 08 1 45s292ms 45s292ms Sep 26 08 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 4m - Times executed: 4 ]
[ Application: psql - Total duration: 4m - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-09-23 06:29:05 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-26 06:29:58 Duration: 1m7s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 2m27s 4 17s517ms 1m23s 36s805ms 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 Sep 23 08 1 1m23s 1m23s Sep 24 08 1 20s277ms 20s277ms Sep 25 08 1 17s517ms 17s517ms Sep 26 08 1 26s261ms 26s261ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m27s - Times executed: 4 ]
-
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-09-23 06:43:37 Duration: 1m23s 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-09-26 06:41:22 Duration: 26s261ms 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-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 2m16s 4 9s160ms 1m30s 34s203ms 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 Sep 23 08 1 27s744ms 27s744ms Sep 24 08 1 9s160ms 9s160ms Sep 25 08 1 9s286ms 9s286ms Sep 26 08 1 1m30s 1m30s [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
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-09-26 06:43:36 Duration: 1m30s 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-09-23 06:44:29 Duration: 27s744ms 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-09-25 06:35:56 Duration: 9s286ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 2m7s 4 29s838ms 34s300ms 31s875ms vacuum analyse;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 08 1 29s838ms 29s838ms Sep 24 08 1 33s106ms 33s106ms Sep 25 08 1 34s300ms 34s300ms Sep 26 08 1 30s255ms 30s255ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: psql - Total duration: 2m7s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-09-25 06:25:08 Duration: 34s300ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-26 06:30:36 Duration: 30s255ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 1m57s 4 27s922ms 30s564ms 29s362ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 22 1 28s957ms 28s957ms Sep 24 22 1 30s564ms 30s564ms Sep 25 22 1 30s5ms 30s5ms Sep 26 22 1 27s922ms 27s922ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 4 ]
-
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-09-24 20:33:44 Duration: 30s564ms 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-09-25 20:34:02 Duration: 30s5ms 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-09-23 20:33:02 Duration: 28s957ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1m29s 4 9s644ms 43s395ms 22s411ms 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 Sep 23 08 1 24s223ms 24s223ms Sep 24 08 1 9s644ms 9s644ms Sep 25 08 1 12s383ms 12s383ms Sep 26 08 1 43s395ms 43s395ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m29s - Times executed: 4 ]
-
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-09-26 06:42:05 Duration: 43s395ms 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-09-23 06:44:01 Duration: 24s223ms 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-09-25 06:35:46 Duration: 12s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1m18s 4 15s505ms 22s926ms 19s662ms alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 08 1 15s505ms 15s505ms Sep 24 08 1 17s645ms 17s645ms Sep 25 08 1 22s571ms 22s571ms Sep 26 08 1 22s926ms 22s926ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 4 ]
[ Application: psql - Total duration: 1m18s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-26 06:27:58 Duration: 22s926ms 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-09-25 06:22:45 Duration: 22s571ms 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-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1m7s 4 11s817ms 22s661ms 16s813ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 22s661ms 22s661ms Sep 24 08 1 18s701ms 18s701ms Sep 25 08 1 11s817ms 11s817ms Sep 26 08 1 14s72ms 14s72ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-23 06:26:29 Duration: 22s661ms 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-09-24 06:25:51 Duration: 18s701ms 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-09-26 06:27:24 Duration: 14s72ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m4s 4 7s615ms 33s474ms 16s81ms 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 #10
Day Hour Count Duration Avg duration Sep 23 08 1 12s703ms 12s703ms Sep 24 08 1 7s615ms 7s615ms Sep 25 08 1 10s532ms 10s532ms Sep 26 08 1 33s474ms 33s474ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
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-09-26 06:44:10 Duration: 33s474ms 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-09-23 06:44:42 Duration: 12s703ms 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-09-25 06:36:07 Duration: 10s532ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 59s715ms 4 9s469ms 18s270ms 14s928ms 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 #11
Day Hour Count Duration Avg duration Sep 23 08 1 17s865ms 17s865ms Sep 24 08 1 9s469ms 9s469ms Sep 25 08 1 18s270ms 18s270ms Sep 26 08 1 14s111ms 14s111ms [ User: a3dsupervisor - Total duration: 59s715ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s715ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-25 06:19:01 Duration: 18s270ms 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-09-23 06:23:27 Duration: 17s865ms 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-09-26 06:24:21 Duration: 14s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 57s447ms 4 9s521ms 21s534ms 14s361ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 11s317ms 11s317ms Sep 24 08 1 9s521ms 9s521ms Sep 25 08 1 21s534ms 21s534ms Sep 26 08 1 15s74ms 15s74ms [ User: a3dsupervisor - Total duration: 57s447ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s447ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-25 06:21:17 Duration: 21s534ms 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-09-26 06:26:27 Duration: 15s74ms 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-09-23 06:25:23 Duration: 11s317ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 51s999ms 4 11s 15s951ms 12s999ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 11s186ms 11s186ms Sep 24 08 1 11s 11s Sep 25 08 1 15s951ms 15s951ms Sep 26 08 1 13s860ms 13s860ms [ User: a3dsupervisor - Total duration: 51s999ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s999ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-25 06:20:40 Duration: 15s951ms 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-09-26 06:25:55 Duration: 13s860ms 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-09-23 06:24:51 Duration: 11s186ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 45s913ms 6 5s171ms 11s644ms 7s652ms 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 #14
Day Hour Count Duration Avg duration Sep 23 09 3 29s915ms 9s971ms Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms Sep 25 21 1 5s171ms 5s171ms [ User: a3dsupervisor - Total duration: 45s913ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 45s913ms - 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-09-23 07:48:37 Duration: 11s644ms 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-09-23 07:46:10 Duration: 11s430ms 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-09-23 07:45:59 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 45s596ms 4 9s719ms 13s103ms 11s399ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 13s103ms 13s103ms Sep 24 08 1 10s301ms 10s301ms Sep 25 08 1 9s719ms 9s719ms Sep 26 08 1 12s471ms 12s471ms [ User: a3dsupervisor - Total duration: 45s596ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s596ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-23 06:25:37 Duration: 13s103ms 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-09-26 06:26:39 Duration: 12s471ms 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-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 34s874ms 3 6s743ms 19s6ms 11s624ms 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 #16
Day Hour Count Duration Avg duration Sep 23 08 1 9s124ms 9s124ms Sep 25 08 1 6s743ms 6s743ms Sep 26 08 1 19s6ms 19s6ms [ User: a3dsupervisor - Total duration: 34s874ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 34s874ms - Times executed: 3 ]
-
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-09-26 06:44:29 Duration: 19s6ms 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-09-23 06:44:52 Duration: 9s124ms 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-09-25 06:36:15 Duration: 6s743ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 34s672ms 4 7s135ms 10s403ms 8s668ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 1 7s135ms 7s135ms Sep 24 08 1 7s220ms 7s220ms Sep 25 08 1 9s913ms 9s913ms Sep 26 08 1 10s403ms 10s403ms [ User: a3dsupervisor - Total duration: 34s672ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s672ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-26 06:27:07 Duration: 10s403ms 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-09-25 06:21:56 Duration: 9s913ms 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-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 34s248ms 4 5s931ms 10s235ms 8s562ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 1 10s235ms 10s235ms Sep 24 08 1 9s848ms 9s848ms Sep 25 08 1 8s232ms 8s232ms Sep 26 08 1 5s931ms 5s931ms [ User: a3dsupervisor - Total duration: 34s248ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s248ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-23 06:25:47 Duration: 10s235ms 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-09-24 06:25:13 Duration: 9s848ms 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-09-25 06:21:35 Duration: 8s232ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 28s67ms 4 6s479ms 8s149ms 7s16ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 1 6s840ms 6s840ms Sep 24 08 1 6s598ms 6s598ms Sep 25 08 1 8s149ms 8s149ms Sep 26 08 1 6s479ms 6s479ms [ User: a3dsupervisor - Total duration: 28s67ms - Times executed: 4 ]
[ Application: psql - Total duration: 28s67ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-25 06:20:24 Duration: 8s149ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-23 06:24:40 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 27s955ms 4 5s290ms 11s463ms 6s988ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 09 2 17s331ms 8s665ms Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 27s955ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s955ms - Times executed: 4 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:48:37 Duration: 11s463ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:45:59 Duration: 5s868ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-24 06:51:09 Duration: 5s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 96 10m6s 5s10ms 13s725ms 6s317ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 10 1m4s 6s460ms 09 28 3m17s 7s56ms Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms Sep 25 08 2 10s134ms 5s67ms 09 11 1m2s 5s664ms 20 5 28s684ms 5s736ms 21 4 24s93ms 6s23ms Sep 26 08 8 48s965ms 6s120ms 09 6 34s812ms 5s802ms 20 1 6s368ms 6s368ms [ User: a3dsupervisor - Total duration: 10m6s - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10m6s - Times executed: 96 ]
-
COMMIT;
Date: 2025-09-23 07:48:37 Duration: 13s725ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s431ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s430ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6 45s913ms 5s171ms 11s644ms 7s652ms 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 Sep 23 09 3 29s915ms 9s971ms Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms Sep 25 21 1 5s171ms 5s171ms [ User: a3dsupervisor - Total duration: 45s913ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 45s913ms - 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-09-23 07:48:37 Duration: 11s644ms 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-09-23 07:46:10 Duration: 11s430ms 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-09-23 07:45:59 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 4 4m 45s292ms 1m15s 1m vacuum analyze;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 08 1 1m15s 1m15s Sep 24 08 1 52s503ms 52s503ms Sep 25 08 1 45s292ms 45s292ms Sep 26 08 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 4m - Times executed: 4 ]
[ Application: psql - Total duration: 4m - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-09-23 06:29:05 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-26 06:29:58 Duration: 1m7s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 4 2m27s 17s517ms 1m23s 36s805ms 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 Sep 23 08 1 1m23s 1m23s Sep 24 08 1 20s277ms 20s277ms Sep 25 08 1 17s517ms 17s517ms Sep 26 08 1 26s261ms 26s261ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m27s - Times executed: 4 ]
-
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-09-23 06:43:37 Duration: 1m23s 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-09-26 06:41:22 Duration: 26s261ms 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-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 4 2m16s 9s160ms 1m30s 34s203ms 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 Sep 23 08 1 27s744ms 27s744ms Sep 24 08 1 9s160ms 9s160ms Sep 25 08 1 9s286ms 9s286ms Sep 26 08 1 1m30s 1m30s [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
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-09-26 06:43:36 Duration: 1m30s 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-09-23 06:44:29 Duration: 27s744ms 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-09-25 06:35:56 Duration: 9s286ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 4 2m7s 29s838ms 34s300ms 31s875ms vacuum analyse;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 08 1 29s838ms 29s838ms Sep 24 08 1 33s106ms 33s106ms Sep 25 08 1 34s300ms 34s300ms Sep 26 08 1 30s255ms 30s255ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: psql - Total duration: 2m7s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-09-25 06:25:08 Duration: 34s300ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-26 06:30:36 Duration: 30s255ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 4 1m57s 27s922ms 30s564ms 29s362ms 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 #7
Day Hour Count Duration Avg duration Sep 23 22 1 28s957ms 28s957ms Sep 24 22 1 30s564ms 30s564ms Sep 25 22 1 30s5ms 30s5ms Sep 26 22 1 27s922ms 27s922ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 4 ]
-
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-09-24 20:33:44 Duration: 30s564ms 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-09-25 20:34:02 Duration: 30s5ms 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-09-23 20:33:02 Duration: 28s957ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
8 4 1m29s 9s644ms 43s395ms 22s411ms 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 Sep 23 08 1 24s223ms 24s223ms Sep 24 08 1 9s644ms 9s644ms Sep 25 08 1 12s383ms 12s383ms Sep 26 08 1 43s395ms 43s395ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m29s - Times executed: 4 ]
-
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-09-26 06:42:05 Duration: 43s395ms 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-09-23 06:44:01 Duration: 24s223ms 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-09-25 06:35:46 Duration: 12s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 4 1m18s 15s505ms 22s926ms 19s662ms 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 Sep 23 08 1 15s505ms 15s505ms Sep 24 08 1 17s645ms 17s645ms Sep 25 08 1 22s571ms 22s571ms Sep 26 08 1 22s926ms 22s926ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 4 ]
[ Application: psql - Total duration: 1m18s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-26 06:27:58 Duration: 22s926ms 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-09-25 06:22:45 Duration: 22s571ms 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-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 4 1m7s 11s817ms 22s661ms 16s813ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 08 1 22s661ms 22s661ms Sep 24 08 1 18s701ms 18s701ms Sep 25 08 1 11s817ms 11s817ms Sep 26 08 1 14s72ms 14s72ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-23 06:26:29 Duration: 22s661ms 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-09-24 06:25:51 Duration: 18s701ms 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-09-26 06:27:24 Duration: 14s72ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 4 1m4s 7s615ms 33s474ms 16s81ms 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 #11
Day Hour Count Duration Avg duration Sep 23 08 1 12s703ms 12s703ms Sep 24 08 1 7s615ms 7s615ms Sep 25 08 1 10s532ms 10s532ms Sep 26 08 1 33s474ms 33s474ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
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-09-26 06:44:10 Duration: 33s474ms 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-09-23 06:44:42 Duration: 12s703ms 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-09-25 06:36:07 Duration: 10s532ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 4 59s715ms 9s469ms 18s270ms 14s928ms 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 #12
Day Hour Count Duration Avg duration Sep 23 08 1 17s865ms 17s865ms Sep 24 08 1 9s469ms 9s469ms Sep 25 08 1 18s270ms 18s270ms Sep 26 08 1 14s111ms 14s111ms [ User: a3dsupervisor - Total duration: 59s715ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s715ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-25 06:19:01 Duration: 18s270ms 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-09-23 06:23:27 Duration: 17s865ms 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-09-26 06:24:21 Duration: 14s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 4 57s447ms 9s521ms 21s534ms 14s361ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 11s317ms 11s317ms Sep 24 08 1 9s521ms 9s521ms Sep 25 08 1 21s534ms 21s534ms Sep 26 08 1 15s74ms 15s74ms [ User: a3dsupervisor - Total duration: 57s447ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s447ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-25 06:21:17 Duration: 21s534ms 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-09-26 06:26:27 Duration: 15s74ms 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-09-23 06:25:23 Duration: 11s317ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 4 51s999ms 11s 15s951ms 12s999ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 1 11s186ms 11s186ms Sep 24 08 1 11s 11s Sep 25 08 1 15s951ms 15s951ms Sep 26 08 1 13s860ms 13s860ms [ User: a3dsupervisor - Total duration: 51s999ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s999ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-25 06:20:40 Duration: 15s951ms 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-09-26 06:25:55 Duration: 13s860ms 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-09-23 06:24:51 Duration: 11s186ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 4 45s596ms 9s719ms 13s103ms 11s399ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 13s103ms 13s103ms Sep 24 08 1 10s301ms 10s301ms Sep 25 08 1 9s719ms 9s719ms Sep 26 08 1 12s471ms 12s471ms [ User: a3dsupervisor - Total duration: 45s596ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s596ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-23 06:25:37 Duration: 13s103ms 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-09-26 06:26:39 Duration: 12s471ms 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-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 4 34s672ms 7s135ms 10s403ms 8s668ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 7s135ms 7s135ms Sep 24 08 1 7s220ms 7s220ms Sep 25 08 1 9s913ms 9s913ms Sep 26 08 1 10s403ms 10s403ms [ User: a3dsupervisor - Total duration: 34s672ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s672ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-26 06:27:07 Duration: 10s403ms 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-09-25 06:21:56 Duration: 9s913ms 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-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 4 34s248ms 5s931ms 10s235ms 8s562ms 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 Sep 23 08 1 10s235ms 10s235ms Sep 24 08 1 9s848ms 9s848ms Sep 25 08 1 8s232ms 8s232ms Sep 26 08 1 5s931ms 5s931ms [ User: a3dsupervisor - Total duration: 34s248ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s248ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-23 06:25:47 Duration: 10s235ms 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-09-24 06:25:13 Duration: 9s848ms 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-09-25 06:21:35 Duration: 8s232ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
18 4 28s67ms 6s479ms 8s149ms 7s16ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 1 6s840ms 6s840ms Sep 24 08 1 6s598ms 6s598ms Sep 25 08 1 8s149ms 8s149ms Sep 26 08 1 6s479ms 6s479ms [ User: a3dsupervisor - Total duration: 28s67ms - Times executed: 4 ]
[ Application: psql - Total duration: 28s67ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-25 06:20:24 Duration: 8s149ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-23 06:24:40 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 4 27s955ms 5s290ms 11s463ms 6s988ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 09 2 17s331ms 8s665ms Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 27s955ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s955ms - Times executed: 4 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:48:37 Duration: 11s463ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:45:59 Duration: 5s868ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-24 06:51:09 Duration: 5s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 4 23s139ms 5s267ms 6s313ms 5s784ms alter table gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 6s313ms 6s313ms Sep 24 08 1 6s83ms 6s83ms Sep 25 08 1 5s475ms 5s475ms Sep 26 08 1 5s267ms 5s267ms [ User: a3dsupervisor - Total duration: 23s139ms - Times executed: 4 ]
[ Application: psql - Total duration: 23s139ms - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-23 06:26:37 Duration: 6s313ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-24 06:25:58 Duration: 6s83ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-25 06:22:22 Duration: 5s475ms 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 45s292ms 1m15s 1m 4 4m vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 1 1m15s 1m15s Sep 24 08 1 52s503ms 52s503ms Sep 25 08 1 45s292ms 45s292ms Sep 26 08 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 4m - Times executed: 4 ]
[ Application: psql - Total duration: 4m - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2025-09-23 06:29:05 Duration: 1m15s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-26 06:29:58 Duration: 1m7s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2025-09-24 06:28:03 Duration: 52s503ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 17s517ms 1m23s 36s805ms 4 2m27s 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 Sep 23 08 1 1m23s 1m23s Sep 24 08 1 20s277ms 20s277ms Sep 25 08 1 17s517ms 17s517ms Sep 26 08 1 26s261ms 26s261ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m27s - Times executed: 4 ]
-
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-09-23 06:43:37 Duration: 1m23s 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-09-26 06:41:22 Duration: 26s261ms 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-09-24 06:38:25 Duration: 20s277ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 9s160ms 1m30s 34s203ms 4 2m16s 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 #3
Day Hour Count Duration Avg duration Sep 23 08 1 27s744ms 27s744ms Sep 24 08 1 9s160ms 9s160ms Sep 25 08 1 9s286ms 9s286ms Sep 26 08 1 1m30s 1m30s [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m16s - Times executed: 4 ]
-
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-09-26 06:43:36 Duration: 1m30s 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-09-23 06:44:29 Duration: 27s744ms 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-09-25 06:35:56 Duration: 9s286ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 29s838ms 34s300ms 31s875ms 4 2m7s vacuum analyse;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 08 1 29s838ms 29s838ms Sep 24 08 1 33s106ms 33s106ms Sep 25 08 1 34s300ms 34s300ms Sep 26 08 1 30s255ms 30s255ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: psql - Total duration: 2m7s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-09-25 06:25:08 Duration: 34s300ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-24 06:28:45 Duration: 33s106ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-26 06:30:36 Duration: 30s255ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 27s922ms 30s564ms 29s362ms 4 1m57s select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 22 1 28s957ms 28s957ms Sep 24 22 1 30s564ms 30s564ms Sep 25 22 1 30s5ms 30s5ms Sep 26 22 1 27s922ms 27s922ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m57s - Times executed: 4 ]
-
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-09-24 20:33:44 Duration: 30s564ms 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-09-25 20:34:02 Duration: 30s5ms 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-09-23 20:33:02 Duration: 28s957ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 9s644ms 43s395ms 22s411ms 4 1m29s 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 #6
Day Hour Count Duration Avg duration Sep 23 08 1 24s223ms 24s223ms Sep 24 08 1 9s644ms 9s644ms Sep 25 08 1 12s383ms 12s383ms Sep 26 08 1 43s395ms 43s395ms [ User: a3dsupervisor - Total duration: 1m29s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m29s - Times executed: 4 ]
-
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-09-26 06:42:05 Duration: 43s395ms 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-09-23 06:44:01 Duration: 24s223ms 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-09-25 06:35:46 Duration: 12s383ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 15s505ms 22s926ms 19s662ms 4 1m18s alter table gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 08 1 15s505ms 15s505ms Sep 24 08 1 17s645ms 17s645ms Sep 25 08 1 22s571ms 22s571ms Sep 26 08 1 22s926ms 22s926ms [ User: a3dsupervisor - Total duration: 1m18s - Times executed: 4 ]
[ Application: psql - Total duration: 1m18s - Times executed: 4 ]
-
ALTER TABLE gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-09-26 06:27:58 Duration: 22s926ms 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-09-25 06:22:45 Duration: 22s571ms 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-09-24 06:26:16 Duration: 17s645ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 11s817ms 22s661ms 16s813ms 4 1m7s alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 08 1 22s661ms 22s661ms Sep 24 08 1 18s701ms 18s701ms Sep 25 08 1 11s817ms 11s817ms Sep 26 08 1 14s72ms 14s72ms [ User: a3dsupervisor - Total duration: 1m7s - Times executed: 4 ]
[ Application: psql - Total duration: 1m7s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-23 06:26:29 Duration: 22s661ms 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-09-24 06:25:51 Duration: 18s701ms 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-09-26 06:27:24 Duration: 14s72ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 7s615ms 33s474ms 16s81ms 4 1m4s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 12s703ms 12s703ms Sep 24 08 1 7s615ms 7s615ms Sep 25 08 1 10s532ms 10s532ms Sep 26 08 1 33s474ms 33s474ms [ User: a3dsupervisor - Total duration: 1m4s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 4 ]
-
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-09-26 06:44:10 Duration: 33s474ms 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-09-23 06:44:42 Duration: 12s703ms 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-09-25 06:36:07 Duration: 10s532ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 9s469ms 18s270ms 14s928ms 4 59s715ms 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 #10
Day Hour Count Duration Avg duration Sep 23 08 1 17s865ms 17s865ms Sep 24 08 1 9s469ms 9s469ms Sep 25 08 1 18s270ms 18s270ms Sep 26 08 1 14s111ms 14s111ms [ User: a3dsupervisor - Total duration: 59s715ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s715ms - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (obj_compo_new_unit_num_id);
Date: 2025-09-25 06:19:01 Duration: 18s270ms 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-09-23 06:23:27 Duration: 17s865ms 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-09-26 06:24:21 Duration: 14s111ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 9s521ms 21s534ms 14s361ms 4 57s447ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 11s317ms 11s317ms Sep 24 08 1 9s521ms 9s521ms Sep 25 08 1 21s534ms 21s534ms Sep 26 08 1 15s74ms 15s74ms [ User: a3dsupervisor - Total duration: 57s447ms - Times executed: 4 ]
[ Application: psql - Total duration: 57s447ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2025-09-25 06:21:17 Duration: 21s534ms 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-09-26 06:26:27 Duration: 15s74ms 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-09-23 06:25:23 Duration: 11s317ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
12 11s 15s951ms 12s999ms 4 51s999ms create index i_gtp_obj_compo_value_compo_id on gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 11s186ms 11s186ms Sep 24 08 1 11s 11s Sep 25 08 1 15s951ms 15s951ms Sep 26 08 1 13s860ms 13s860ms [ User: a3dsupervisor - Total duration: 51s999ms - Times executed: 4 ]
[ Application: psql - Total duration: 51s999ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON gtp_obj_composition (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2025-09-25 06:20:40 Duration: 15s951ms 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-09-26 06:25:55 Duration: 13s860ms 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-09-23 06:24:51 Duration: 11s186ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 6s743ms 19s6ms 11s624ms 3 34s874ms 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 #13
Day Hour Count Duration Avg duration Sep 23 08 1 9s124ms 9s124ms Sep 25 08 1 6s743ms 6s743ms Sep 26 08 1 19s6ms 19s6ms [ User: a3dsupervisor - Total duration: 34s874ms - Times executed: 3 ]
[ Application: pg_dump - Total duration: 34s874ms - Times executed: 3 ]
-
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-09-26 06:44:29 Duration: 19s6ms 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-09-23 06:44:52 Duration: 9s124ms 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-09-25 06:36:15 Duration: 6s743ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 9s719ms 13s103ms 11s399ms 4 45s596ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 1 13s103ms 13s103ms Sep 24 08 1 10s301ms 10s301ms Sep 25 08 1 9s719ms 9s719ms Sep 26 08 1 12s471ms 12s471ms [ User: a3dsupervisor - Total duration: 45s596ms - Times executed: 4 ]
[ Application: psql - Total duration: 45s596ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2025-09-23 06:25:37 Duration: 13s103ms 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-09-26 06:26:39 Duration: 12s471ms 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-09-24 06:25:03 Duration: 10s301ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 7s135ms 10s403ms 8s668ms 4 34s672ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 7s135ms 7s135ms Sep 24 08 1 7s220ms 7s220ms Sep 25 08 1 9s913ms 9s913ms Sep 26 08 1 10s403ms 10s403ms [ User: a3dsupervisor - Total duration: 34s672ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s672ms - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-26 06:27:07 Duration: 10s403ms 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-09-25 06:21:56 Duration: 9s913ms 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-09-24 06:25:30 Duration: 7s220ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 5s931ms 10s235ms 8s562ms 4 34s248ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 10s235ms 10s235ms Sep 24 08 1 9s848ms 9s848ms Sep 25 08 1 8s232ms 8s232ms Sep 26 08 1 5s931ms 5s931ms [ User: a3dsupervisor - Total duration: 34s248ms - Times executed: 4 ]
[ Application: psql - Total duration: 34s248ms - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2025-09-23 06:25:47 Duration: 10s235ms 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-09-24 06:25:13 Duration: 9s848ms 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-09-25 06:21:35 Duration: 8s232ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 5s171ms 11s644ms 7s652ms 6 45s913ms 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 #17
Day Hour Count Duration Avg duration Sep 23 09 3 29s915ms 9s971ms Sep 24 08 1 5s492ms 5s492ms 21 1 5s334ms 5s334ms Sep 25 21 1 5s171ms 5s171ms [ User: a3dsupervisor - Total duration: 45s913ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 45s913ms - 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-09-23 07:48:37 Duration: 11s644ms 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-09-23 07:46:10 Duration: 11s430ms 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-09-23 07:45:59 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 6s479ms 8s149ms 7s16ms 4 28s67ms create index i_gtp_obj_compo_value_case on gtp_obj_composition (touppernoaccent (obj_compo_value));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 1 6s840ms 6s840ms Sep 24 08 1 6s598ms 6s598ms Sep 25 08 1 8s149ms 8s149ms Sep 26 08 1 6s479ms 6s479ms [ User: a3dsupervisor - Total duration: 28s67ms - Times executed: 4 ]
[ Application: psql - Total duration: 28s67ms - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-25 06:20:24 Duration: 8s149ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-23 06:24:40 Duration: 6s840ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_gtp_obj_compo_value_case ON gtp_obj_composition (touppernoaccent (obj_compo_value));
Date: 2025-09-24 06:24:14 Duration: 6s598ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 5s290ms 11s463ms 6s988ms 4 27s955ms select alp1_0.lock_key, alp1_0.lock_creator, alp1_0.lock_date, alp1_0.lock_duration, alp1_0.lock_extensions_number, alp1_0.lock_host_name, alp1_0.lock_informations, alp1_0.lock_name, alp1_0.lock_session_id, alp1_0.lock_timeout_date, alp1_0.lock_type from applicative_lock alp1_0 where alp1_0.lock_key =;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 09 2 17s331ms 8s665ms Sep 24 08 1 5s332ms 5s332ms 21 1 5s290ms 5s290ms [ User: a3dsupervisor - Total duration: 27s955ms - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 27s955ms - Times executed: 4 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:48:37 Duration: 11s463ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-23 07:45:59 Duration: 5s868ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY =;
Date: 2025-09-24 06:51:09 Duration: 5s332ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 5s10ms 13s725ms 6s317ms 96 10m6s commit;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 10 1m4s 6s460ms 09 28 3m17s 7s56ms Sep 24 08 2 13s682ms 6s841ms 09 9 56s314ms 6s257ms 12 2 12s423ms 6s211ms 20 5 25s905ms 5s181ms 21 3 20s609ms 6s869ms Sep 25 08 2 10s134ms 5s67ms 09 11 1m2s 5s664ms 20 5 28s684ms 5s736ms 21 4 24s93ms 6s23ms Sep 26 08 8 48s965ms 6s120ms 09 6 34s812ms 5s802ms 20 1 6s368ms 6s368ms [ User: a3dsupervisor - Total duration: 10m6s - Times executed: 96 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10m6s - Times executed: 96 ]
-
COMMIT;
Date: 2025-09-23 07:48:37 Duration: 13s725ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s431ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-23 07:46:10 Duration: 11s430ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 130,730 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 107010 ERROR entries
- 64 WARNING entries
Most Frequent Errors/Events
Key values
- 103,884 Max number of times the same event was reported
- 107,074 Total events found
Rank Times reported Error 1 103,884 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 23 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 2,707 08 1,370 09 3,575 10 3,600 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,529 20 3,600 21 3,587 22 3,600 23 3,600 00 3,610 01 3,600 Sep 24 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 2,706 2 3,051 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 08 100 09 228 10 754 11 135 12 26 Sep 25 08 177 09 207 10 228 11 193 12 170 13 2 Sep 26 08 97 09 243 10 90 11 277 12 122 14 2 3 64 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 23 08 16 Sep 24 08 16 Sep 25 08 16 Sep 26 08 16 4 28 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 23 19 4 Sep 24 10 3 11 1 19 3 Sep 25 10 2 17 2 19 3 Sep 26 17 3 19 3 Sep 27 19 4 5 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 23 08 1 Sep 24 08 1 10 1 Sep 25 08 1 Sep 26 08 1 6 5 ERROR: could not obtain lock on row in relation "..." select * from gtp_mail_adress where mail_num_id = AND MAIL_ADRESS = and DEST_TYPE = AND INVALID = 0 AND SEND_DATE is null for update nowait
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 23 15 1 Sep 24 08 2 15 1 Sep 25 11 1 7 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 8 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 9 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 10 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 11 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 12 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 13 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 14 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 15 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 23 08 1 Sep 24 08 1 Sep 25 08 1 Sep 26 08 1 16 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 25 09 1