pgBadger-
Global information
- Generated on Mon Mar 9 09:31:27 2026
- Log file: ././A3D-RND-PIC/y=2026/m=03/d=07/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=03/d=07/h=23/m=00/PT1H.log
- Parsed 271,746 log entries in 1m12s
- Log start from 2026-03-02 07:21:07 to 2026-03-06 07:23:39
-
Overview
Global Stats
- 64 Number of unique normalized queries
- 784 Number of queries
- 1h29m7s Total query duration
- 2026-03-02 06:38:09 First query
- 2026-03-06 06:44:15 Last query
- 5 queries/s at 2026-03-05 09:11:49 Query peak
- 1h29m7s Total query duration
- 1m22s Prepare/parse total duration
- 44s105ms Bind total duration
- 1h27m Execute total duration
- 127,401 Number of events
- 22 Number of unique normalized events
- 127,250 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
- 585 Number temporary file
- 2.67 GiB Max size of temporary file
- 24.52 MiB Average size of temporary file
- 4,920 Total number of sessions
- 47 sessions at 2026-03-03 08:59:32 Session peak
- 14d11h23m27s Total duration of sessions
- 4m14s Average duration of sessions
- 0 Average queries per session
- 1s86ms Average queries duration per session
- 4m13s Average idle time per session
- 4,916 Total number of connections
- 9 connections/s at 2026-03-03 07:46:26 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-03-05 09:11:49 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2026-03-02 09:47:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-03-02 09:47:07 Date
Queries duration
Key values
- 1h29m7s 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) Mar 01 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 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 Mar 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 06 3 0ms 4s998ms 3s716ms 0ms 4s998ms 6s149ms 07 37 0ms 1m24s 13s293ms 1m6s 1m13s 1m24s 08 34 0ms 4s853ms 3s445ms 9s642ms 11s62ms 13s533ms 09 64 0ms 8s274ms 4s257ms 17s932ms 24s101ms 46s788ms 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 1 0ms 15s490ms 15s490ms 0ms 0ms 15s490ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Mar 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 10 0ms 4s552ms 3s536ms 3s653ms 4s552ms 23s907ms 07 37 0ms 1m54s 19s805ms 1m45s 1m48s 1m54s 08 56 0ms 44s396ms 6s686ms 28s998ms 32s432ms 1m37s 09 24 0ms 5s931ms 4s54ms 6s805ms 10s711ms 17s765ms 10 8 0ms 5s908ms 4s350ms 0ms 0ms 34s806ms 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 1 0ms 16s319ms 16s319ms 0ms 0ms 16s319ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Mar 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 20 0ms 5s988ms 3s814ms 9s446ms 19s977ms 25s635ms 07 36 0ms 1m40s 14s338ms 56s847ms 1m2s 1m40s 08 54 0ms 8s146ms 4s67ms 15s470ms 23s812ms 26s287ms 09 55 0ms 7s972ms 4s317ms 18s695ms 21s661ms 58s320ms 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 1 0ms 15s148ms 15s148ms 0ms 0ms 15s148ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Mar 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 18 0ms 4s572ms 3s880ms 13s658ms 17s858ms 18s570ms 07 37 0ms 1m34s 14s183ms 59s566ms 1m4s 1m34s 08 119 0ms 15s972ms 4s958ms 21s551ms 45s926ms 2m10s 09 159 0ms 10s449ms 4s487ms 31s319ms 42s617ms 49s792ms 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 1 0ms 16s477ms 16s477ms 0ms 0ms 16s477ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Mar 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 9 0ms 5s808ms 4s673ms 5s93ms 16s702ms 17s51ms 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 Mar 07 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 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) Mar 01 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Mar 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 6 12s234ms 0ms 0ms 1m13s 08 1 0 3s23ms 0ms 0ms 3s23ms 09 4 0 3s857ms 0ms 0ms 3s152ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 15s490ms 0ms 0ms 15s490ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Mar 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 1 0 3s835ms 0ms 0ms 3s835ms 07 0 4 1m 0ms 27s568ms 1m48s 08 3 9 11s604ms 0ms 3s367ms 1m37s 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 16s319ms 0ms 0ms 16s319ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Mar 04 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 3s324ms 0ms 0ms 3s458ms 07 0 6 11s291ms 0ms 0ms 1m2s 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 15s148ms 0ms 0ms 15s148ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Mar 05 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 6 12s73ms 0ms 0ms 57s167ms 08 3 0 5s735ms 0ms 0ms 0ms 09 5 0 4s555ms 0ms 0ms 9s742ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 16s477ms 0ms 0ms 16s477ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Mar 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 4s320ms 0ms 0ms 8s640ms 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 Mar 07 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 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) Mar 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 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 Mar 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 1 0 4s998ms 0ms 0ms 0ms 07 0 0 1 0 30s226ms 0ms 0ms 0ms 08 2 0 1 0 3s61ms 0ms 0ms 3s62ms 09 0 0 1 0 4s1ms 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 Mar 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 1 0 32s787ms 0ms 0ms 0ms 08 2 1 0 0 4s44ms 0ms 0ms 4s85ms 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 Mar 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 1 0 3s191ms 0ms 0ms 0ms 07 0 0 1 0 35s622ms 0ms 0ms 0ms 08 4 0 1 0 3s590ms 0ms 0ms 4s80ms 09 1 0 2 0 3s682ms 0ms 0ms 3s502ms 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 Mar 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 1 0 33s438ms 0ms 0ms 0ms 08 3 0 5 0 5s841ms 0ms 0ms 5s755ms 09 4 0 0 0 4s579ms 0ms 0ms 4s608ms 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 Mar 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 3 0 1 0 5s93ms 0ms 0ms 10s893ms 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 Mar 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 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 Mar 01 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 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% Mar 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 06 0 3 3.00 0.00% 07 0 1 1.00 0.00% 08 0 34 34.00 0.00% 09 0 64 64.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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Mar 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 10 10.00 0.00% 07 0 1 1.00 0.00% 08 3 47 15.67 5.36% 09 1 24 24.00 4.17% 10 0 8 8.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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Mar 04 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 20 20.00 0.00% 07 0 1 1.00 0.00% 08 0 54 54.00 0.00% 09 1 55 55.00 1.82% 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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Mar 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 18 18.00 0.00% 07 0 3 3.00 0.00% 08 9 119 13.22 7.56% 09 1 159 159.00 0.63% 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 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Mar 06 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 9 9.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% Mar 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 Mar 01 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Mar 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 06 45 0.01/s 07 348 0.10/s 08 35 0.01/s 09 33 0.01/s 10 27 0.01/s 11 20 0.01/s 12 26 0.01/s 13 47 0.01/s 14 42 0.01/s 15 40 0.01/s 16 40 0.01/s 17 40 0.01/s 18 35 0.01/s 19 43 0.01/s 20 53 0.01/s 21 53 0.01/s 22 42 0.01/s 23 42 0.01/s Mar 03 00 48 0.01/s 01 32 0.01/s 02 33 0.01/s 03 27 0.01/s 04 27 0.01/s 05 24 0.01/s 06 32 0.01/s 07 342 0.10/s 08 36 0.01/s 09 25 0.01/s 10 25 0.01/s 11 24 0.01/s 12 42 0.01/s 13 30 0.01/s 14 38 0.01/s 15 25 0.01/s 16 36 0.01/s 17 43 0.01/s 18 33 0.01/s 19 25 0.01/s 20 35 0.01/s 21 48 0.01/s 22 23 0.01/s 23 30 0.01/s Mar 04 00 22 0.01/s 01 44 0.01/s 02 28 0.01/s 03 35 0.01/s 04 41 0.01/s 05 37 0.01/s 06 26 0.01/s 07 352 0.10/s 08 48 0.01/s 09 28 0.01/s 10 36 0.01/s 11 49 0.01/s 12 44 0.01/s 13 61 0.02/s 14 46 0.01/s 15 41 0.01/s 16 48 0.01/s 17 51 0.01/s 18 15 0.00/s 19 48 0.01/s 20 45 0.01/s 21 54 0.01/s 22 46 0.01/s 23 34 0.01/s Mar 05 00 31 0.01/s 01 34 0.01/s 02 20 0.01/s 03 50 0.01/s 04 36 0.01/s 05 31 0.01/s 06 33 0.01/s 07 339 0.09/s 08 40 0.01/s 09 25 0.01/s 10 35 0.01/s 11 44 0.01/s 12 40 0.01/s 13 40 0.01/s 14 44 0.01/s 15 33 0.01/s 16 19 0.01/s 17 17 0.00/s 18 33 0.01/s 19 23 0.01/s 20 40 0.01/s 21 28 0.01/s 22 31 0.01/s 23 20 0.01/s Mar 06 00 30 0.01/s 01 14 0.00/s 02 36 0.01/s 03 45 0.01/s 04 64 0.02/s 05 42 0.01/s 06 23 0.01/s 07 51 0.01/s 08 5 0.00/s 09 2 0.00/s 10 4 0.00/s 11 6 0.00/s 12 2 0.00/s 13 6 0.00/s 14 4 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 1 0.00/s Mar 07 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Mar 01 00 2 62ms 62ms 01 2 53ms 53ms 02 2 52ms 52ms 03 2 54ms 54ms 04 2 52ms 52ms 05 2 54ms 54ms 06 2 52ms 52ms 07 2 51ms 51ms 08 2 51ms 51ms 09 2 52ms 52ms 10 2 57ms 57ms 11 2 52ms 52ms 12 2 50ms 50ms 13 2 51ms 51ms 14 2 54ms 54ms 15 2 65ms 65ms 16 2 69ms 69ms 17 2 55ms 55ms 18 2 58ms 58ms 19 2 56ms 56ms 20 2 59ms 59ms 21 2 52ms 52ms 22 2 51ms 51ms 23 2 53ms 53ms Mar 02 00 2 54ms 54ms 01 2 58ms 58ms 02 2 53ms 53ms 03 2 53ms 53ms 04 2 50ms 50ms 06 45 3m47s 3m47s 07 344 23s946ms 22s516ms 08 36 2m10s 2m6s 09 31 2m47s 2m39s 10 25 8m45s 8m45s 11 24 4m13s 4m13s 12 26 3m13s 3m13s 13 44 2m37s 2m37s 14 45 2m11s 2m11s 15 40 1m58s 1m58s 16 37 3m20s 3m20s 17 43 2m24s 2m24s 18 36 36m47s 36m47s 19 41 2m8s 2m8s 20 52 2m3s 2m3s 21 55 2m 2m 22 42 1m58s 1m58s 23 42 2m19s 2m19s Mar 03 00 49 2m52s 2m52s 01 31 2m56s 2m56s 02 33 1m43s 1m43s 03 28 4m45s 4m45s 04 27 3m11s 3m11s 05 24 2m19s 2m19s 06 35 46m8s 46m7s 07 333 12s281ms 10s80ms 08 41 4m11s 4m2s 09 24 3m28s 3m24s 10 23 8m39s 8m38s 11 28 3m11s 3m11s 12 42 2m13s 2m13s 13 26 1m35s 1m35s 14 42 3m32s 3m32s 15 25 2m54s 2m54s 16 34 3m4s 3m4s 17 44 2m21s 2m21s 18 34 37m55s 37m55s 19 25 3m14s 3m14s 20 33 2m42s 2m42s 21 50 1m47s 1m46s 22 23 2m57s 2m57s 23 30 2m41s 2m41s Mar 04 00 23 4m32s 4m32s 01 43 2m24s 2m24s 02 28 2m12s 2m12s 03 35 3m36s 3m36s 04 41 2m23s 2m23s 05 37 2m7s 2m7s 06 29 54m27s 54m24s 07 349 22s809ms 21s330ms 08 47 1m53s 1m49s 09 27 4m58s 4m49s 10 36 5m47s 5m47s 11 48 2m38s 2m38s 12 47 2m44s 2m44s 13 61 1m58s 1m58s 14 46 3m10s 3m10s 15 41 2m35s 2m35s 16 48 2m21s 2m21s 17 51 2m36s 2m36s 18 15 1h24m21s 1h24m21s 19 48 2m43s 2m43s 20 45 2m4s 2m4s 21 54 2m2s 2m1s 22 47 2m17s 2m17s 23 33 1m46s 1m46s Mar 05 00 31 3m55s 3m55s 01 34 2m55s 2m55s 02 20 1m27s 1m27s 03 50 3m14s 3m14s 04 37 2m42s 2m42s 05 30 1m39s 1m39s 06 39 41m34s 41m32s 07 333 13s930ms 12s354ms 08 40 3m44s 3m30s 09 28 4m16s 3m51s 10 35 5m51s 5m51s 11 44 2m37s 2m37s 12 39 2m31s 2m31s 13 41 2m13s 2m13s 14 44 2m26s 2m26s 15 33 2m24s 2m24s 16 19 4m1s 4m1s 17 17 1m13s 1m13s 18 30 45m47s 45m47s 19 26 1m27s 1m27s 20 41 3m30s 3m30s 21 26 2m49s 2m48s 22 32 2m14s 2m14s 23 20 4m45s 4m45s Mar 06 00 30 2m38s 2m38s 01 14 1m29s 1m29s 02 37 3m58s 3m58s 03 41 2m12s 2m12s 04 65 1m41s 1m41s 05 44 1m53s 1m53s 06 26 1h14s 1h13s 07 51 3s340ms 3s340ms 08 5 100ms 100ms 09 2 56ms 56ms 10 4 56s89ms 56s89ms 11 6 84ms 84ms 12 2 54ms 54ms 13 6 87ms 87ms 14 4 14s989ms 14s989ms 15 2 52ms 52ms 16 2 52ms 52ms 17 2 52ms 52ms 18 2 50ms 50ms 19 2 57ms 57ms 20 2 60ms 60ms 21 2 49ms 49ms 22 2 56ms 56ms 23 1 61ms 61ms Mar 07 00 2 51ms 51ms 01 2 69ms 69ms 02 2 53ms 53ms 03 2 51ms 51ms 04 2 48ms 48ms 05 2 50ms 50ms 06 2 55ms 55ms 07 2 53ms 53ms 08 2 51ms 51ms 09 2 49ms 49ms 10 2 51ms 51ms 11 2 160ms 160ms 12 2 56ms 56ms 13 2 59ms 59ms 14 2 54ms 54ms 15 2 54ms 54ms 16 2 51ms 51ms 17 2 52ms 52ms 18 2 52ms 52ms 19 2 51ms 51ms 20 2 53ms 53ms 21 2 50ms 50ms 22 2 51ms 51ms 23 2 53ms 53ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-03-03 07:46:26 Date
Connections per database
Key values
- reftk Main Database
- 4,916 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,916 connections Total
-
Sessions
Simultaneous sessions
Key values
- 47 sessions Session Peak
- 2026-03-03 08:59:32 Date
Histogram of session times
Key values
- 3,145 60000-600000ms duration
Sessions per database
Key values
- reftk Main Database
- 4,920 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,920 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,920 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,920 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 294.67 MiB Temp Files size Peak
- 2026-03-05 07:34:08 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-03-03 07:38:07 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Mar 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 06 1 4.34 MiB 4.34 MiB 07 142 3.46 GiB 24.92 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Mar 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 153 3.62 GiB 24.20 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Mar 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 144 3.46 GiB 24.64 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Mar 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 145 3.47 GiB 24.49 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Mar 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 Mar 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 Mar 01 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Mar 02 00 0 0 01 0 0 02 0 0 03 0 0 04 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 Mar 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Mar 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Mar 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Mar 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Mar 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessShareLock Main Lock Type
- 13 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
- 25 Total read queries
- 746 Total write queries
Queries by database
Key values
- reftk Main database
- 784 Requests
- 1h27m (reftk)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 784 Requests
User Request type Count Duration a3dsupervisor Total 784 1h27m copy to 31 9m41s ddl 107 16m32s delete 17 3m6s insert 19 1m29s others 13 11m22s select 25 2m34s tcl 571 42m10s update 1 4s85ms Duration by user
Key values
- 1h27m (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 784 1h27m copy to 31 9m41s ddl 107 16m32s delete 17 3m6s insert 19 1m29s others 13 11m22s select 25 2m34s tcl 571 42m10s update 1 4s85ms Queries by host
Key values
- 10.3.0.4 Main host
- 784 Requests
- 1h27m (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- PostgreSQL JDBC Driver Main application
- 634 Requests
- 49m27s (PostgreSQL JDBC Driver)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-05 19:24:00 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 714 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 1m54s VACUUM ANALYZE;[ Date: 2026-03-03 07:43:57 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 1m48s 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: 2026-03-03 07:57:06 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 1m40s VACUUM ANALYZE;[ Date: 2026-03-04 07:36:28 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 1m34s VACUUM ANALYZE;[ Date: 2026-03-05 07:38:16 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 1m24s VACUUM ANALYZE;[ Date: 2026-03-02 07:39:19 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 1m4s VACUUM ANALYSE;[ Date: 2026-03-05 07:39:30 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 1m2s VACUUM ANALYSE;[ Date: 2026-03-04 07:37:37 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 1m2s VACUUM ANALYSE;[ Date: 2026-03-03 07:45:09 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 1m 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: 2026-03-03 07:58:06 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 52s701ms VACUUM ANALYSE;[ Date: 2026-03-02 07:40:19 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
11 45s230ms 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: 2026-03-03 07:58:52 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 44s396ms COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;[ Date: 2026-03-03 08:00:04 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 42s120ms 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: 2026-03-03 08:00:46 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 40s824ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2026-03-02 07:35:05 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
15 40s669ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2026-03-04 07:31:46 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
16 39s923ms CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);[ Date: 2026-03-03 07:38:47 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
17 35s622ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-04 07:41:31 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
18 33s438ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-05 07:43:44 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
19 32s787ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-03 07:49:22 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
20 30s226ms delete from GTP_LOG_EHCACHE where LOG_DATE <;[ Date: 2026-03-02 07:44:40 - Database: reftk - User: a3dsupervisor - Remote: 10.3.0.4 - Application: PostgreSQL JDBC Driver - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 42m10s 571 3s1ms 19s233ms 4s430ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 07 2 6s149ms 3s74ms 09 30 1m44s 3s498ms 10 59 4m13s 4s288ms Mar 03 07 9 31s533ms 3s503ms 09 41 3m43s 5s441ms 10 24 1m37s 4s54ms 11 8 34s806ms 4s350ms Mar 04 07 17 1m6s 3s908ms 09 49 3m21s 4s116ms 10 52 3m46s 4s354ms Mar 05 07 18 1m9s 3s880ms 08 1 3s64ms 3s64ms 09 108 8m46s 4s871ms 10 150 11m12s 4s483ms Mar 06 07 3 13s44ms 4s348ms [ User: a3dsupervisor - Total duration: 42m10s - Times executed: 571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42m10s - Times executed: 571 ]
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 19s233ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 17s307ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 17s306ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6m33s 4 1m24s 1m54s 1m38s vacuum analyze;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 02 08 1 1m24s 1m24s Mar 03 08 1 1m54s 1m54s Mar 04 08 1 1m40s 1m40s Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 4 ]
[ Application: psql - Total duration: 6m33s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2026-03-03 07:43:57 Duration: 1m54s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4m1s 4 52s701ms 1m4s 1m vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 02 08 1 52s701ms 52s701ms Mar 03 08 1 1m2s 1m2s Mar 04 08 1 1m2s 1m2s Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 4m1s - Times executed: 4 ]
[ Application: psql - Total duration: 4m1s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-03 07:45:09 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 3m7s 4 25s503ms 1m48s 46s943ms 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 Mar 02 08 1 26s911ms 26s911ms Mar 03 08 1 1m48s 1m48s Mar 04 08 1 25s503ms 25s503ms Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - 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: 2026-03-03 07:57:06 Duration: 1m48s 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: 2026-03-05 07:50:18 Duration: 27s139ms 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: 2026-03-02 07:51:03 Duration: 26s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 2m27s 4 25s609ms 40s824ms 36s756ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 02 08 1 40s824ms 40s824ms Mar 03 08 1 39s923ms 39s923ms Mar 04 08 1 40s669ms 40s669ms Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: psql - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-02 07:35:05 Duration: 40s824ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-03 07:38:47 Duration: 39s923ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
6 2m12s 4 30s226ms 35s622ms 33s18ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 02 08 1 30s226ms 30s226ms Mar 03 08 1 32s787ms 32s787ms Mar 04 08 1 35s622ms 35s622ms Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m12s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-03 07:49:22 Duration: 32s787ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
7 1m32s 4 10s86ms 1m 23s224ms 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 Mar 02 08 1 11s506ms 11s506ms Mar 03 08 1 1m 1m Mar 04 08 1 10s86ms 10s86ms Mar 05 08 1 10s857ms 10s857ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m32s - 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: 2026-03-03 07:58:06 Duration: 1m 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: 2026-03-02 07:51:15 Duration: 11s506ms 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: 2026-03-05 07:50:29 Duration: 10s857ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1m32s 4 16s685ms 29s571ms 23s110ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 02 08 1 16s685ms 16s685ms Mar 03 08 1 25s455ms 25s455ms Mar 04 08 1 20s729ms 20s729ms Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: psql - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms 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: 2026-03-03 07:39:13 Duration: 25s455ms 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: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 1m14s 4 15s908ms 22s103ms 18s691ms 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 Mar 02 08 1 16s295ms 16s295ms Mar 03 08 1 20s457ms 20s457ms Mar 04 08 1 22s103ms 22s103ms Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 4 ]
[ Application: psql - Total duration: 1m14s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms 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: 2026-03-03 07:40:25 Duration: 20s457ms 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: 2026-03-02 07:36:23 Duration: 16s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
10 1m13s 4 9s284ms 45s230ms 18s491ms 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 #10
Day Hour Count Duration Avg duration Mar 02 08 1 9s795ms 9s795ms Mar 03 08 1 45s230ms 45s230ms Mar 04 08 1 9s284ms 9s284ms Mar 05 08 1 9s656ms 9s656ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - 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: 2026-03-03 07:58:52 Duration: 45s230ms 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: 2026-03-02 07:51:26 Duration: 9s795ms 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: 2026-03-05 07:50:40 Duration: 9s656ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 1m13s 4 8s892ms 44s396ms 18s282ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 02 08 1 10s209ms 10s209ms Mar 03 09 1 44s396ms 44s396ms Mar 04 08 1 8s892ms 8s892ms Mar 05 08 1 9s632ms 9s632ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-03 08:00:04 Duration: 44s396ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-02 07:51:46 Duration: 10s209ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-05 07:51:00 Duration: 9s632ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 1m11s 16 3s13ms 10s97ms 4s499ms 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 #12
Day Hour Count Duration Avg duration Mar 02 09 1 3s13ms 3s13ms Mar 03 09 2 8s47ms 4s23ms Mar 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m11s - Times executed: 16 ]
-
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: 2026-03-05 08:35:15 Duration: 10s97ms 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: 2026-03-05 09:11:49 Duration: 6s4ms 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: 2026-03-06 06:37:53 Duration: 5s447ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
13 1m3s 4 15s148ms 16s477ms 15s859ms select ceahp1_0.history_num_id, ceahp1_1.history_action, ceahp1_1.history_date, ceahp1_1.obj_num_id, ceahp1_1.obj_template_a3d_id, ceahp1_0.alert_src_num_id, ceahp1_0.alert_type_a3d_id from gtp_cw_eng_alert ceahp1_0 join gtp_cw_eng_history ceahp1_1 on ceahp1_0.history_num_id = ceahp1_1.history_num_id where ceahp1_1.history_action = and ceahp1_1.obj_template_a3d_id = and ceahp1_1.obj_num_id = and ceahp1_0.alert_type_a3d_id = and ceahp1_0.alert_src_num_id is null order by ceahp1_1.history_date desc fetch first rows only;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 22 1 15s490ms 15s490ms Mar 03 22 1 16s319ms 16s319ms Mar 04 22 1 15s148ms 15s148ms Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - 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: 2026-03-05 21:32:57 Duration: 16s477ms 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: 2026-03-03 21:33:23 Duration: 16s319ms 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: 2026-03-02 21:32:56 Duration: 15s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
14 1m 4 8s889ms 19s983ms 15s196ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 02 08 1 19s983ms 19s983ms Mar 03 08 1 15s950ms 15s950ms Mar 04 08 1 15s963ms 15s963ms Mar 05 08 1 8s889ms 8s889ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-02 07:36:04 Duration: 19s983ms 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: 2026-03-04 07:32:49 Duration: 15s963ms 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: 2026-03-03 07:39:59 Duration: 15s950ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 1m 4 8s959ms 21s105ms 15s113ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 02 08 1 8s959ms 8s959ms Mar 03 08 1 17s969ms 17s969ms Mar 04 08 1 12s419ms 12s419ms Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms 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: 2026-03-03 07:39:31 Duration: 17s969ms 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: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
16 59s12ms 4 12s487ms 16s919ms 14s753ms 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 #16
Day Hour Count Duration Avg duration Mar 02 08 1 15s48ms 15s48ms Mar 03 08 1 16s919ms 16s919ms Mar 04 08 1 14s556ms 14s556ms Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 59s12ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s12ms - 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: 2026-03-03 07:37:46 Duration: 16s919ms 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: 2026-03-02 07:34:03 Duration: 15s48ms 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: 2026-03-04 07:30:43 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 58s451ms 4 5s285ms 42s120ms 14s612ms 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 #17
Day Hour Count Duration Avg duration Mar 02 08 1 5s405ms 5s405ms Mar 03 09 1 42s120ms 42s120ms Mar 04 08 1 5s285ms 5s285ms Mar 05 08 1 5s639ms 5s639ms [ User: a3dsupervisor - Total duration: 58s451ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 58s451ms - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2026-03-03 08:00:46 Duration: 42s120ms 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: 2026-03-05 07:51:07 Duration: 5s639ms 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: 2026-03-02 07:51:52 Duration: 5s405ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 56s143ms 4 12s647ms 16s86ms 14s35ms 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 #18
Day Hour Count Duration Avg duration Mar 02 08 1 13s84ms 13s84ms Mar 03 08 1 14s324ms 14s324ms Mar 04 08 1 12s647ms 12s647ms Mar 05 08 1 16s86ms 16s86ms [ User: a3dsupervisor - Total duration: 56s143ms - Times executed: 4 ]
[ Application: psql - Total duration: 56s143ms - 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: 2026-03-05 07:35:37 Duration: 16s86ms 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: 2026-03-03 07:40:52 Duration: 14s324ms 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: 2026-03-02 07:36:51 Duration: 13s84ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 55s356ms 4 8s696ms 27s568ms 13s839ms 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 #19
Day Hour Count Duration Avg duration Mar 02 08 1 9s577ms 9s577ms Mar 03 08 1 27s568ms 27s568ms Mar 04 08 1 8s696ms 8s696ms Mar 05 08 1 9s513ms 9s513ms [ User: a3dsupervisor - Total duration: 55s356ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s356ms - 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: 2026-03-03 07:59:19 Duration: 27s568ms 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: 2026-03-02 07:51:36 Duration: 9s577ms 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: 2026-03-05 07:50:50 Duration: 9s513ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 53s747ms 4 6s475ms 29s383ms 13s436ms 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 #20
Day Hour Count Duration Avg duration Mar 02 08 1 8s57ms 8s57ms Mar 03 08 1 6s475ms 6s475ms Mar 04 08 1 9s830ms 9s830ms Mar 05 08 1 29s383ms 29s383ms [ User: a3dsupervisor - Total duration: 53s747ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s747ms - 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: 2026-03-05 07:31:28 Duration: 29s383ms 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: 2026-03-04 07:29:03 Duration: 9s830ms 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: 2026-03-02 07:32:25 Duration: 8s57ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 571 42m10s 3s1ms 19s233ms 4s430ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 07 2 6s149ms 3s74ms 09 30 1m44s 3s498ms 10 59 4m13s 4s288ms Mar 03 07 9 31s533ms 3s503ms 09 41 3m43s 5s441ms 10 24 1m37s 4s54ms 11 8 34s806ms 4s350ms Mar 04 07 17 1m6s 3s908ms 09 49 3m21s 4s116ms 10 52 3m46s 4s354ms Mar 05 07 18 1m9s 3s880ms 08 1 3s64ms 3s64ms 09 108 8m46s 4s871ms 10 150 11m12s 4s483ms Mar 06 07 3 13s44ms 4s348ms [ User: a3dsupervisor - Total duration: 42m10s - Times executed: 571 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 42m10s - Times executed: 571 ]
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 19s233ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 17s307ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2026-03-03 08:29:05 Duration: 17s306ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 16 1m11s 3s13ms 10s97ms 4s499ms 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 Mar 02 09 1 3s13ms 3s13ms Mar 03 09 2 8s47ms 4s23ms Mar 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m11s - Times executed: 16 ]
-
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: 2026-03-05 08:35:15 Duration: 10s97ms 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: 2026-03-05 09:11:49 Duration: 6s4ms 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: 2026-03-06 06:37:53 Duration: 5s447ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 11 45s535ms 3s58ms 5s755ms 4s139ms delete from gtp_background_task task where task.task_service_name = and task.task_status = ? and task.task_num_id in ( select task_num_id from gtp_background_task task except select task_num_id from ( select task.task_num_id from gtp_background_task task where task.task_service_name = and task.task_status = ? order by task_start_date desc limit ?));Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 02 07 1 4s998ms 4s998ms 09 1 3s109ms 3s109ms 10 1 4s1ms 4s1ms Mar 04 09 1 3s673ms 3s673ms 10 2 7s140ms 3s570ms Mar 05 09 4 17s518ms 4s379ms Mar 06 07 1 5s93ms 5s93ms [ User: a3dsupervisor - Total duration: 45s535ms - Times executed: 11 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 45s535ms - Times executed: 11 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:34:16 Duration: 5s755ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:39:15 Duration: 5s276ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-06 06:44:15 Duration: 5s93ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
4 10 40s676ms 3s32ms 5s226ms 4s67ms select lock_num_id from gtp_lock where lock_num_id = for update;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 02 10 2 7s696ms 3s848ms Mar 03 07 1 3s835ms 3s835ms 09 3 13s32ms 4s344ms Mar 04 07 1 3s458ms 3s458ms Mar 05 09 1 3s32ms 3s32ms 10 1 5s226ms 5s226ms Mar 06 07 1 4s394ms 4s394ms [ User: a3dsupervisor - Total duration: 40s676ms - Times executed: 10 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 40s676ms - Times executed: 10 ]
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-05 09:15:21 Duration: 5s226ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-03 08:32:16 Duration: 5s124ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
select LOCK_NUM_ID from gtp_lock where LOCK_NUM_ID = FOR UPDATE;
Date: 2026-03-02 09:47:01 Duration: 4s544ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
5 7 29s29ms 3s189ms 5s873ms 4s147ms 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 #5
Day Hour Count Duration Avg duration Mar 02 10 2 7s731ms 3s865ms Mar 04 07 1 3s189ms 3s189ms Mar 05 10 3 13s862ms 4s620ms Mar 06 07 1 4s246ms 4s246ms [ User: a3dsupervisor - Total duration: 29s29ms - Times executed: 7 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 29s29ms - Times executed: 7 ]
-
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: 2026-03-05 09:11:49 Duration: 5s873ms 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: 2026-03-05 09:15:21 Duration: 4s516ms 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: 2026-03-06 06:38:26 Duration: 4s246ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 5 30s80ms 4s554ms 7s462ms 6s16ms create index i_history_compo_obj on gtp_history_obj_compo (obj_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 02 08 1 7s462ms 7s462ms Mar 03 08 2 13s460ms 6s730ms Mar 04 08 1 4s554ms 4s554ms Mar 05 08 1 4s603ms 4s603ms [ User: a3dsupervisor - Total duration: 30s80ms - Times executed: 5 ]
[ Application: psql - Total duration: 30s80ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-02 07:34:18 Duration: 7s462ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-03 07:38:02 Duration: 6s730ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-05 07:33:04 Duration: 4s603ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
7 4 6m33s 1m24s 1m54s 1m38s vacuum analyze;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 02 08 1 1m24s 1m24s Mar 03 08 1 1m54s 1m54s Mar 04 08 1 1m40s 1m40s Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 4 ]
[ Application: psql - Total duration: 6m33s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2026-03-03 07:43:57 Duration: 1m54s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 4 4m1s 52s701ms 1m4s 1m vacuum analyse;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 02 08 1 52s701ms 52s701ms Mar 03 08 1 1m2s 1m2s Mar 04 08 1 1m2s 1m2s Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 4m1s - Times executed: 4 ]
[ Application: psql - Total duration: 4m1s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-03 07:45:09 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 4 3m7s 25s503ms 1m48s 46s943ms 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 #9
Day Hour Count Duration Avg duration Mar 02 08 1 26s911ms 26s911ms Mar 03 08 1 1m48s 1m48s Mar 04 08 1 25s503ms 25s503ms Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - 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: 2026-03-03 07:57:06 Duration: 1m48s 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: 2026-03-05 07:50:18 Duration: 27s139ms 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: 2026-03-02 07:51:03 Duration: 26s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 4 2m27s 25s609ms 40s824ms 36s756ms create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 02 08 1 40s824ms 40s824ms Mar 03 08 1 39s923ms 39s923ms Mar 04 08 1 40s669ms 40s669ms Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: psql - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-02 07:35:05 Duration: 40s824ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-03 07:38:47 Duration: 39s923ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
11 4 2m12s 30s226ms 35s622ms 33s18ms delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 02 08 1 30s226ms 30s226ms Mar 03 08 1 32s787ms 32s787ms Mar 04 08 1 35s622ms 35s622ms Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m12s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-03 07:49:22 Duration: 32s787ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 4 1m32s 10s86ms 1m 23s224ms 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 #12
Day Hour Count Duration Avg duration Mar 02 08 1 11s506ms 11s506ms Mar 03 08 1 1m 1m Mar 04 08 1 10s86ms 10s86ms Mar 05 08 1 10s857ms 10s857ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m32s - 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: 2026-03-03 07:58:06 Duration: 1m 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: 2026-03-02 07:51:15 Duration: 11s506ms 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: 2026-03-05 07:50:29 Duration: 10s857ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 4 1m32s 16s685ms 29s571ms 23s110ms create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 08 1 16s685ms 16s685ms Mar 03 08 1 25s455ms 25s455ms Mar 04 08 1 20s729ms 20s729ms Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: psql - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms 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: 2026-03-03 07:39:13 Duration: 25s455ms 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: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 4 1m14s 15s908ms 22s103ms 18s691ms alter table gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 02 08 1 16s295ms 16s295ms Mar 03 08 1 20s457ms 20s457ms Mar 04 08 1 22s103ms 22s103ms Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 4 ]
[ Application: psql - Total duration: 1m14s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms 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: 2026-03-03 07:40:25 Duration: 20s457ms 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: 2026-03-02 07:36:23 Duration: 16s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 4 1m13s 9s284ms 45s230ms 18s491ms 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 #15
Day Hour Count Duration Avg duration Mar 02 08 1 9s795ms 9s795ms Mar 03 08 1 45s230ms 45s230ms Mar 04 08 1 9s284ms 9s284ms Mar 05 08 1 9s656ms 9s656ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - 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: 2026-03-03 07:58:52 Duration: 45s230ms 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: 2026-03-02 07:51:26 Duration: 9s795ms 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: 2026-03-05 07:50:40 Duration: 9s656ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 4 1m13s 8s892ms 44s396ms 18s282ms copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 02 08 1 10s209ms 10s209ms Mar 03 09 1 44s396ms 44s396ms Mar 04 08 1 8s892ms 8s892ms Mar 05 08 1 9s632ms 9s632ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-03 08:00:04 Duration: 44s396ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-02 07:51:46 Duration: 10s209ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-05 07:51:00 Duration: 9s632ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 4 1m3s 15s148ms 16s477ms 15s859ms 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 #17
Day Hour Count Duration Avg duration Mar 02 22 1 15s490ms 15s490ms Mar 03 22 1 16s319ms 16s319ms Mar 04 22 1 15s148ms 15s148ms Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - 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: 2026-03-05 21:32:57 Duration: 16s477ms 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: 2026-03-03 21:33:23 Duration: 16s319ms 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: 2026-03-02 21:32:56 Duration: 15s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
18 4 1m 8s889ms 19s983ms 15s196ms alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 02 08 1 19s983ms 19s983ms Mar 03 08 1 15s950ms 15s950ms Mar 04 08 1 15s963ms 15s963ms Mar 05 08 1 8s889ms 8s889ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-02 07:36:04 Duration: 19s983ms 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: 2026-03-04 07:32:49 Duration: 15s963ms 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: 2026-03-03 07:39:59 Duration: 15s950ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 4 1m 8s959ms 21s105ms 15s113ms create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 02 08 1 8s959ms 8s959ms Mar 03 08 1 17s969ms 17s969ms Mar 04 08 1 12s419ms 12s419ms Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms 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: 2026-03-03 07:39:31 Duration: 17s969ms 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: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 4 59s12ms 12s487ms 16s919ms 14s753ms 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 #20
Day Hour Count Duration Avg duration Mar 02 08 1 15s48ms 15s48ms Mar 03 08 1 16s919ms 16s919ms Mar 04 08 1 14s556ms 14s556ms Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 59s12ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s12ms - 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: 2026-03-03 07:37:46 Duration: 16s919ms 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: 2026-03-02 07:34:03 Duration: 15s48ms 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: 2026-03-04 07:30:43 Duration: 14s556ms 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 1m24s 1m54s 1m38s 4 6m33s vacuum analyze;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 08 1 1m24s 1m24s Mar 03 08 1 1m54s 1m54s Mar 04 08 1 1m40s 1m40s Mar 05 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 6m33s - Times executed: 4 ]
[ Application: psql - Total duration: 6m33s - Times executed: 4 ]
-
VACUUM ANALYZE;
Date: 2026-03-03 07:43:57 Duration: 1m54s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-04 07:36:28 Duration: 1m40s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYZE;
Date: 2026-03-05 07:38:16 Duration: 1m34s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 52s701ms 1m4s 1m 4 4m1s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 02 08 1 52s701ms 52s701ms Mar 03 08 1 1m2s 1m2s Mar 04 08 1 1m2s 1m2s Mar 05 08 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 4m1s - Times executed: 4 ]
[ Application: psql - Total duration: 4m1s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2026-03-05 07:39:30 Duration: 1m4s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-04 07:37:37 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-03-03 07:45:09 Duration: 1m2s Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 25s503ms 1m48s 46s943ms 4 3m7s 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 Mar 02 08 1 26s911ms 26s911ms Mar 03 08 1 1m48s 1m48s Mar 04 08 1 25s503ms 25s503ms Mar 05 08 1 27s139ms 27s139ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m7s - 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: 2026-03-03 07:57:06 Duration: 1m48s 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: 2026-03-05 07:50:18 Duration: 27s139ms 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: 2026-03-02 07:51:03 Duration: 26s911ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 25s609ms 40s824ms 36s756ms 4 2m27s create index i_log_ehcache_date on gtp_log_ehcache (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 02 08 1 40s824ms 40s824ms Mar 03 08 1 39s923ms 39s923ms Mar 04 08 1 40s669ms 40s669ms Mar 05 08 1 25s609ms 25s609ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: psql - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-02 07:35:05 Duration: 40s824ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-04 07:31:46 Duration: 40s669ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (log_date);
Date: 2026-03-03 07:38:47 Duration: 39s923ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
5 30s226ms 35s622ms 33s18ms 4 2m12s delete from gtp_log_ehcache where log_date <;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 02 08 1 30s226ms 30s226ms Mar 03 08 1 32s787ms 32s787ms Mar 04 08 1 35s622ms 35s622ms Mar 05 08 1 33s438ms 33s438ms [ User: a3dsupervisor - Total duration: 2m12s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m12s - Times executed: 4 ]
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-04 07:41:31 Duration: 35s622ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-05 07:43:44 Duration: 33s438ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
delete from GTP_LOG_EHCACHE where LOG_DATE <;
Date: 2026-03-03 07:49:22 Duration: 32s787ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
6 10s86ms 1m 23s224ms 4 1m32s 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 Mar 02 08 1 11s506ms 11s506ms Mar 03 08 1 1m 1m Mar 04 08 1 10s86ms 10s86ms Mar 05 08 1 10s857ms 10s857ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m32s - 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: 2026-03-03 07:58:06 Duration: 1m 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: 2026-03-02 07:51:15 Duration: 11s506ms 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: 2026-03-05 07:50:29 Duration: 10s857ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 16s685ms 29s571ms 23s110ms 4 1m32s create index i_log_ehcache_region_name on gtp_log_ehcache (region_name);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 02 08 1 16s685ms 16s685ms Mar 03 08 1 25s455ms 25s455ms Mar 04 08 1 20s729ms 20s729ms Mar 05 08 1 29s571ms 29s571ms [ User: a3dsupervisor - Total duration: 1m32s - Times executed: 4 ]
[ Application: psql - Total duration: 1m32s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON gtp_log_ehcache (region_name);
Date: 2026-03-05 07:34:08 Duration: 29s571ms 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: 2026-03-03 07:39:13 Duration: 25s455ms 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: 2026-03-04 07:32:07 Duration: 20s729ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
8 15s908ms 22s103ms 18s691ms 4 1m14s 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 Mar 02 08 1 16s295ms 16s295ms Mar 03 08 1 20s457ms 20s457ms Mar 04 08 1 22s103ms 22s103ms Mar 05 08 1 15s908ms 15s908ms [ User: a3dsupervisor - Total duration: 1m14s - Times executed: 4 ]
[ Application: psql - Total duration: 1m14s - Times executed: 4 ]
-
ALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 07:33:15 Duration: 22s103ms 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: 2026-03-03 07:40:25 Duration: 20s457ms 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: 2026-03-02 07:36:23 Duration: 16s295ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
9 9s284ms 45s230ms 18s491ms 4 1m13s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 02 08 1 9s795ms 9s795ms Mar 03 08 1 45s230ms 45s230ms Mar 04 08 1 9s284ms 9s284ms Mar 05 08 1 9s656ms 9s656ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - 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: 2026-03-03 07:58:52 Duration: 45s230ms 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: 2026-03-02 07:51:26 Duration: 9s795ms 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: 2026-03-05 07:50:40 Duration: 9s656ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 8s892ms 44s396ms 18s282ms 4 1m13s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 02 08 1 10s209ms 10s209ms Mar 03 09 1 44s396ms 44s396ms Mar 04 08 1 8s892ms 8s892ms Mar 05 08 1 9s632ms 9s632ms [ User: a3dsupervisor - Total duration: 1m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m13s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-03 08:00:04 Duration: 44s396ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-02 07:51:46 Duration: 10s209ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) TO stdout;
Date: 2026-03-05 07:51:00 Duration: 9s632ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 15s148ms 16s477ms 15s859ms 4 1m3s 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 #11
Day Hour Count Duration Avg duration Mar 02 22 1 15s490ms 15s490ms Mar 03 22 1 16s319ms 16s319ms Mar 04 22 1 15s148ms 15s148ms Mar 05 22 1 16s477ms 16s477ms [ User: a3dsupervisor - Total duration: 1m3s - Times executed: 4 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m3s - 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: 2026-03-05 21:32:57 Duration: 16s477ms 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: 2026-03-03 21:33:23 Duration: 16s319ms 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: 2026-03-02 21:32:56 Duration: 15s490ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
12 8s889ms 19s983ms 15s196ms 4 1m alter table gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 02 08 1 19s983ms 19s983ms Mar 03 08 1 15s950ms 15s950ms Mar 04 08 1 15s963ms 15s963ms Mar 05 08 1 8s889ms 8s889ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
ALTER TABLE gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-02 07:36:04 Duration: 19s983ms 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: 2026-03-04 07:32:49 Duration: 15s963ms 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: 2026-03-03 07:39:59 Duration: 15s950ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
13 8s959ms 21s105ms 15s113ms 4 1m create index i_log_ehcache_server_id on gtp_log_ehcache (server_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 08 1 8s959ms 8s959ms Mar 03 08 1 17s969ms 17s969ms Mar 04 08 1 12s419ms 12s419ms Mar 05 08 1 21s105ms 21s105ms [ User: a3dsupervisor - Total duration: 1m - Times executed: 4 ]
[ Application: psql - Total duration: 1m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON gtp_log_ehcache (server_id);
Date: 2026-03-05 07:34:29 Duration: 21s105ms 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: 2026-03-03 07:39:31 Duration: 17s969ms 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: 2026-03-04 07:32:20 Duration: 12s419ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
14 12s487ms 16s919ms 14s753ms 4 59s12ms 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 Mar 02 08 1 15s48ms 15s48ms Mar 03 08 1 16s919ms 16s919ms Mar 04 08 1 14s556ms 14s556ms Mar 05 08 1 12s487ms 12s487ms [ User: a3dsupervisor - Total duration: 59s12ms - Times executed: 4 ]
[ Application: psql - Total duration: 59s12ms - 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: 2026-03-03 07:37:46 Duration: 16s919ms 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: 2026-03-02 07:34:03 Duration: 15s48ms 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: 2026-03-04 07:30:43 Duration: 14s556ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
15 5s285ms 42s120ms 14s612ms 4 58s451ms 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 #15
Day Hour Count Duration Avg duration Mar 02 08 1 5s405ms 5s405ms Mar 03 09 1 42s120ms 42s120ms Mar 04 08 1 5s285ms 5s285ms Mar 05 08 1 5s639ms 5s639ms [ User: a3dsupervisor - Total duration: 58s451ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 58s451ms - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2026-03-03 08:00:46 Duration: 42s120ms 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: 2026-03-05 07:51:07 Duration: 5s639ms 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: 2026-03-02 07:51:52 Duration: 5s405ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 12s647ms 16s86ms 14s35ms 4 56s143ms 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 #16
Day Hour Count Duration Avg duration Mar 02 08 1 13s84ms 13s84ms Mar 03 08 1 14s324ms 14s324ms Mar 04 08 1 12s647ms 12s647ms Mar 05 08 1 16s86ms 16s86ms [ User: a3dsupervisor - Total duration: 56s143ms - Times executed: 4 ]
[ Application: psql - Total duration: 56s143ms - 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: 2026-03-05 07:35:37 Duration: 16s86ms 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: 2026-03-03 07:40:52 Duration: 14s324ms 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: 2026-03-02 07:36:51 Duration: 13s84ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
17 8s696ms 27s568ms 13s839ms 4 55s356ms 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 #17
Day Hour Count Duration Avg duration Mar 02 08 1 9s577ms 9s577ms Mar 03 08 1 27s568ms 27s568ms Mar 04 08 1 8s696ms 8s696ms Mar 05 08 1 9s513ms 9s513ms [ User: a3dsupervisor - Total duration: 55s356ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s356ms - 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: 2026-03-03 07:59:19 Duration: 27s568ms 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: 2026-03-02 07:51:36 Duration: 9s577ms 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: 2026-03-05 07:50:50 Duration: 9s513ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 6s475ms 29s383ms 13s436ms 4 53s747ms 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 #18
Day Hour Count Duration Avg duration Mar 02 08 1 8s57ms 8s57ms Mar 03 08 1 6s475ms 6s475ms Mar 04 08 1 9s830ms 9s830ms Mar 05 08 1 29s383ms 29s383ms [ User: a3dsupervisor - Total duration: 53s747ms - Times executed: 4 ]
[ Application: psql - Total duration: 53s747ms - 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: 2026-03-05 07:31:28 Duration: 29s383ms 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: 2026-03-04 07:29:03 Duration: 9s830ms 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: 2026-03-02 07:32:25 Duration: 8s57ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
19 4s554ms 7s462ms 6s16ms 5 30s80ms create index i_history_compo_obj on gtp_history_obj_compo (obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 02 08 1 7s462ms 7s462ms Mar 03 08 2 13s460ms 6s730ms Mar 04 08 1 4s554ms 4s554ms Mar 05 08 1 4s603ms 4s603ms [ User: a3dsupervisor - Total duration: 30s80ms - Times executed: 5 ]
[ Application: psql - Total duration: 30s80ms - Times executed: 5 ]
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-02 07:34:18 Duration: 7s462ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-03 07:38:02 Duration: 6s730ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
CREATE INDEX i_history_compo_obj ON gtp_history_obj_compo (obj_num_id);
Date: 2026-03-05 07:33:04 Duration: 4s603ms Database: reftk User: a3dsupervisor Remote: 10.3.0.4 Application: psql
20 3s13ms 10s97ms 4s499ms 16 1m11s 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 #20
Day Hour Count Duration Avg duration Mar 02 09 1 3s13ms 3s13ms Mar 03 09 2 8s47ms 4s23ms Mar 04 09 4 14s281ms 3s570ms 10 1 3s907ms 3s907ms Mar 05 09 2 13s243ms 6s621ms 10 3 14s221ms 4s740ms Mar 06 07 3 15s282ms 5s94ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 16 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m11s - Times executed: 16 ]
-
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: 2026-03-05 08:35:15 Duration: 10s97ms 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: 2026-03-05 09:11:49 Duration: 6s4ms 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: 2026-03-06 06:37:53 Duration: 5s447ms 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 1 5s169ms 1 5s169ms 5s169ms 5s169ms select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Mar 06 10 1 5s169ms 5s169ms [ User: a3dsupervisor - Total duration: 3s687ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s687ms - Times executed: 1 ]
-
select gsbp1_0.SETTING_NUM_ID, gsbp1_1.SETTING_CODE, gsbp1_1.SETTING_CREATOR, gsbp1_1.SETTING_DCRE, gsbp1_1.SETTING_DMAJ, gsbp1_1.SETTING_MODIFIER, gsbp1_1.SETTING_TYPE, gsbp1_1.USER_NUM_ID, gsbp1_0.SETTING_VALUE from GTP_SETTING_BOOLEAN gsbp1_0 join GTP_SETTING gsbp1_1 on gsbp1_0.SETTING_NUM_ID = gsbp1_1.SETTING_NUM_ID where gsbp1_1.USER_NUM_ID is null and gsbp1_1.SETTING_CODE = $1 order by gsbp1_0.SETTING_NUM_ID desc;
Date: 2026-03-05 09:08:17 Duration: 5s169ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
2 5s98ms 1 5s98ms 5s98ms 5s98ms insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 08 1 5s98ms 5s98ms [ User: a3dsupervisor - Total duration: 3s814ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s814ms - Times executed: 1 ]
-
insert into GTP_LOG_EHCACHE (ELEMENT_COUNT_AVERAGE, ELEMENT_COUNT_MAX, ELEMENT_COUNT_MIN, HIT_COUNT, LOG_DATE, MAX_MEMORY, MISS_COUNT, REGION_NAME, SERVER_ID, USED_MEMORY_AVERAGE, USED_MEMORY_MAX, USED_MEMORY_MIN, LOG_EHCACHE_NUM_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13);
Date: 2026-03-05 08:30:08 Duration: 5s98ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 4s1ms 1 4s1ms 4s1ms 4s1ms select task_num_id from gtp_background_task where task_status in ($1, $2, $3) and current_timestamp > task_last_update + interval '180 second';Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 08 1 4s1ms 4s1ms [ User: a3dsupervisor - Total duration: 3s367ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s367ms - Times executed: 1 ]
-
select task_num_id from gtp_background_task where task_status in ($1, $2, $3) and current_timestamp > task_last_update + interval '180 second';
Date: 2026-03-03 08:29:03 Duration: 4s1ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 3s979ms 1 3s979ms 3s979ms 3s979ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 08 1 3s979ms 3s979ms [ User: a3dsupervisor - Total duration: 10s97ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s97ms - Times executed: 1 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2026-03-05 08:34:21 Duration: 3s979ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
5 3s879ms 1 3s879ms 3s879ms 3s879ms select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 08 1 3s879ms 3s879ms [ User: a3dsupervisor - Total duration: 3s782ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s782ms - Times executed: 1 ]
-
select gotcrp1_0.RULE_ID, gotcrp1_0.ATT_TEMPLATE_CATEGORY_NUM_ID, gotcrp1_0.ATT_TEMPLATE_NUM_ID, gotcrp1_0.ELSE_CONDITION, gotcrp1_0.FORMULA, gotcrp1_0.LABEL, gotcrp1_0.OBJ_TEMPLATE_NUM_ID, gotcrp1_0.PARENT_RULE_ID, gotcrp1_0.RULE_ORDER from GTP_OBJ_TEMPLATE_CALCULATION_RULE gotcrp1_0;
Date: 2026-03-05 08:16:41 Duration: 3s879ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
6 3s108ms 1 3s108ms 3s108ms 3s108ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 08 1 3s108ms 3s108ms [ User: a3dsupervisor - Total duration: 4s358ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 4s358ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;
Date: 2026-03-03 08:44:14 Duration: 3s108ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6s950ms 2 3s113ms 3s836ms 3s475ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Mar 06 09 1 3s836ms 3s836ms Mar 06 10 1 3s113ms 3s113ms [ User: a3dsupervisor - Total duration: 8s868ms - Times executed: 2 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 8s868ms - Times executed: 2 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-03 08:44:14 Duration: 3s836ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0;
Date: 2026-03-05 09:19:39 Duration: 3s113ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
2 5s605ms 1 5s605ms 5s605ms 5s605ms select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 09 1 5s605ms 5s605ms [ User: a3dsupervisor - Total duration: 3s147ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s147ms - Times executed: 1 ]
-
select bsrp1_0.BATCH_SCENARIO_RUN_ID, bsrp1_0.CREATION_DATE, bsrp1_0.CREATOR_NUM_ID, bsrp1_0.END_DATE, bsrp1_0.MODIFICATION_DATE, bsrp1_0.MODIFIER_NUM_ID, bsrp1_0.BATCH_SCENARIO_NUM_ID, bsrp1_0.START_DATE, bsrp1_0.STATE, bsrp1_0.STATUS from BATCH_SCENARIO_RUN bsrp1_0 where bsrp1_0.STATUS not in ($1, $2, $3);
Date: 2026-03-05 09:08:17 Duration: 5s605ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
3 4s390ms 1 4s390ms 4s390ms 4s390ms delete from GTP_BACKGROUND_TASK task where task.task_service_name = $1 AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = $2 AND task.task_status = 3 order by task_start_date desc LIMIT 10));Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 08 1 4s390ms 4s390ms [ User: a3dsupervisor - Total duration: 3s916ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s916ms - Times executed: 1 ]
-
delete from GTP_BACKGROUND_TASK task where task.task_service_name = $1 AND task.task_status = 3 AND task.task_num_id in ( SELECT task_num_id from gtp_background_task task EXCEPT SELECT task_num_id FROM ( SELECT task.task_num_id FROM gtp_background_task task where task.task_service_name = $2 AND task.task_status = 3 order by task_start_date desc LIMIT 10));
Date: 2026-03-05 08:49:15 Duration: 4s390ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
4 4s6ms 1 4s6ms 4s6ms 4s6ms select gbtp1_0.TASK_NUM_ID, gbtp1_0.BATCH_PROCESS_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 08 1 4s6ms 4s6ms [ User: a3dsupervisor - Total duration: 3s367ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s367ms - Times executed: 1 ]
-
select gbtp1_0.TASK_NUM_ID, gbtp1_0.BATCH_PROCESS_NUM_ID, gbtp1_0.CANCELING_USER_NUM_ID, gbtp1_0.EXPORT_FILE_NAME, gbtp1_0.SERVER_ID, gbtp1_0.SOURCE_FILE_NAME, gbtp1_0.SOURCE_OBJ_NUM_ID, gbtp1_0.TASK_ACTIVE_STATUS, gbtp1_0.TASK_CREATE_DATE, gbtp1_0.TASK_CURRENT_PROGRESS, gbtp1_0.TASK_CURRENT_STEP, gbtp1_0.TASK_END_DATE, gbtp1_0.TASK_ERROR_MESSAGE, gbtp1_0.TASK_LAST_UPDATE, gbtp1_0.TASK_LOG, gbtp1_0.TASK_MAX_PROGRESS, gbtp1_0.TASK_MAX_STEP, gbtp1_0.TASK_ORIGIN, gbtp1_0.TASK_PARAMETERS, gbtp1_0.TASK_REPORT, gbtp1_0.TASK_SERVICE_NAME, gbtp1_0.TASK_START_DATE, gbtp1_0.TASK_STATE, gbtp1_0.TASK_STATUS, gbtp1_0.TASK_SUB_TYPE, gbtp1_0.USER_NUM_ID from GTP_BACKGROUND_TASK gbtp1_0 where gbtp1_0.TASK_STATUS = $1 and gbtp1_0.CANCELING_USER_NUM_ID is not null order by gbtp1_0.TASK_NUM_ID desc;
Date: 2026-03-03 08:28:10 Duration: 4s6ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
5 3s936ms 1 3s936ms 3s936ms 3s936ms select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 08 1 3s936ms 3s936ms [ User: a3dsupervisor - Total duration: 10s97ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 10s97ms - Times executed: 1 ]
-
select ghodp1_0.ACTION_NUM_ID, ghodp1_0.OBJ_NUM_ID, ghodp1_0.OBJ_CREATOR, ghodp1_0.OBJ_NAME, ghodp1_0.OBJ_TEMPLATE_NUM_ID, ghodp1_0.WORKSPACE_NUM_ID from GTP_HISTORY_OBJ_DELETED ghodp1_0 where 1 = 0;
Date: 2026-03-05 08:34:25 Duration: 3s936ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
6 3s395ms 1 3s395ms 3s395ms 3s395ms SELECT DISTINCT (OBJ_TEMPLATE_NUM_ID) FROM GTP_NODE_TREE_TYPE WHERE OBJ_TEMPLATE_NUM_ID IS NOT NULL AND VIEW_TEMPLATE_NUM_ID = $1;Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 08 1 3s395ms 3s395ms [ User: a3dsupervisor - Total duration: 3s814ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s814ms - Times executed: 1 ]
-
SELECT DISTINCT (OBJ_TEMPLATE_NUM_ID) FROM GTP_NODE_TREE_TYPE WHERE OBJ_TEMPLATE_NUM_ID IS NOT NULL AND VIEW_TEMPLATE_NUM_ID = $1;
Date: 2026-03-05 08:26:32 Duration: 3s395ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
7 3s111ms 1 3s111ms 3s111ms 3s111ms select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 08 1 3s111ms 3s111ms [ User: a3dsupervisor - Total duration: 3s735ms - Times executed: 1 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3s735ms - Times executed: 1 ]
-
select alp1_0.LOCK_KEY, alp1_0.LOCK_CREATOR, alp1_0.LOCK_DATE, alp1_0.LOCK_DURATION, alp1_0.LOCK_EXTENSIONS_NUMBER, alp1_0.LOCK_HOST_NAME, alp1_0.LOCK_INFORMATIONS, alp1_0.LOCK_NAME, alp1_0.LOCK_SESSION_ID, alp1_0.LOCK_TIMEOUT_DATE, alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY = $1;
Date: 2026-03-03 08:44:14 Duration: 3s111ms Database: reftk User: reftk Remote: a3dsupervisor Application: 10.3.0.4 Queryid: PostgreSQL JDBC Driver
-
Events
Log levels
Key values
- 143,561 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 127321 ERROR entries
- 80 WARNING entries
Most Frequent Errors/Events
Key values
- 127,250 Max number of times the same event was reported
- 127,401 Total events found
Rank Times reported Error 1 127,250 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 02 09 329 10 3,362 11 995 12 587 13 2,346 14 63 15 775 16 1,354 17 982 18 455 19 2,601 20 213 21 460 22 920 23 1,371 00 1,409 Mar 03 01 3,320 02 2,338 03 2,288 04 2,737 05 1,518 06 2,061 07 293 09 355 10 3,212 11 602 12 2,365 13 870 14 2,274 15 98 16 907 17 469 18 1,899 19 122 20 2,595 21 212 22 440 23 1,034 00 1,352 Mar 04 01 3,320 02 2,391 03 2,271 04 2,754 05 1,380 06 1,143 07 1,791 08 49 09 956 10 2,834 11 1,344 12 1,475 13 906 14 2,353 15 13 16 910 17 464 18 2,144 19 1,568 20 326 21 264 22 940 23 1,861 00 1,799 Mar 05 01 3,126 02 2,107 03 3,599 04 1,842 05 1,681 06 2,699 07 339 08 49 09 1,177 10 2,267 11 2,245 12 999 13 942 14 1,890 15 7 16 906 17 1,370 18 985 19 443 20 2,291 21 530 22 936 23 1,770 00 2,036 Mar 06 01 641 02 3,532 03 2 2 80 WARNING: TIMESTAMP(...) precision reduced to maximum allowed, 6
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 02 08 16 Mar 03 08 16 Mar 04 08 16 Mar 05 08 16 Mar 06 08 16 3 13 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 02 19 3 Mar 03 19 3 Mar 04 19 4 Mar 05 19 3 4 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 5 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 #5
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 6 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 7 4 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_log_ehcache_date ON gtp_log_ehcache (...)
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 02 08 1 Mar 03 08 2 Mar 04 08 1 8 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 #8
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 9 4 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 02 10 1 Mar 03 09 1 Mar 06 07 2 10 4 ERROR: duplicate key value violates unique constraint "..." call PACK_GTP_TRIGGER.P_DELETE_GTP_OBJ_INVALID(...)
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 11 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 #11
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 12 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 #12
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 13 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 #13
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 14 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 #14
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 15 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 16 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 02 08 1 Mar 03 08 1 Mar 04 08 1 Mar 05 08 1 17 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON gtp_history_obj_compo (...)
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 02 08 1 18 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0
Times Reported Most Frequent Error / Event #18
Day Hour Count Mar 03 09 1 19 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (...)
Times Reported Most Frequent Error / Event #19
Day Hour Count Mar 04 08 1 20 1 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... msinsert into APPLICATIVE_LOCK (...) values (...)
Times Reported Most Frequent Error / Event #20
Day Hour Count Mar 04 09 1 21 1 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #21
Day Hour Count Mar 03 09 1 22 1 ERROR: schema "..." does not exist
Times Reported Most Frequent Error / Event #22
Day Hour Count Mar 06 08 1