pgBadger-
Global information
- Generated on Mon Mar 9 09:31:33 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 2,567 log entries in 1m18s
- Log start from 2026-03-02 08:07:04 to 2026-03-05 09:43:05
-
Overview
Global Stats
- 138 Number of unique normalized queries
- 311 Number of queries
- 6h28m3s Total query duration
- 2026-03-02 07:58:58 First query
- 2026-03-05 09:43:46 Last query
- 2 queries/s at 2026-03-02 08:13:16 Query peak
- 6h28m3s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h28m3s Execute total duration
- 11 Number of events
- 9 Number of unique normalized events
- 2 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
- 705 Number temporary file
- 1.32 GiB Max size of temporary file
- 21.65 MiB Average size of temporary file
- 387 Total number of sessions
- 49 sessions at 2026-03-03 08:58:47 Session peak
- 12h2m58s Total duration of sessions
- 1m52s Average duration of sessions
- 0 Average queries per session
- 1m Average queries duration per session
- 51s925ms Average idle time per session
- 387 Total number of connections
- 3 connections/s at 2026-03-02 07:58:26 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-02 08:13:16 Date
SELECT Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-05 08:40:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-03-02 08:13:16 Date
Queries duration
Key values
- 6h28m3s 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 0 0ms 0ms 0ms 0ms 0ms 0ms 07 3 0ms 1m23s 46s994ms 1m58s 1m58s 1m58s 08 56 0ms 5m27s 29s626ms 4m18s 10m38s 10m38s 09 9 0ms 39m53s 7m59s 31m2s 39m53s 39m53s 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 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 83 0ms 3m54s 32s796ms 3m22s 5m38s 7m21s 09 1 0ms 28m58s 28m58s 28m58s 28m58s 28m58s 10 3 0ms 26m25s 8m51s 26m25s 26m25s 26m25s 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 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 8 0ms 1m58s 31s975ms 2m44s 2m44s 2m44s 08 52 0ms 5m20s 29s268ms 4m50s 5m30s 5m30s 09 9 0ms 38m24s 7m18s 26m50s 38m24s 38m24s 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 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 84 0ms 4m16s 21s859ms 2m43s 4m16s 8m15s 09 3 0ms 35m24s 19m45s 23m52s 35m24s 35m24s 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 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 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 0 0ms 0ms 0ms 0ms 08 1 0 3s244ms 0ms 0ms 3s244ms 09 0 7 9s985ms 0ms 14s283ms 55s616ms 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 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 9 0 3s994ms 0ms 3s290ms 16s879ms 09 0 0 0ms 0ms 0ms 0ms 10 0 2 3s684ms 0ms 7s369ms 7s369ms 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 04 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 5 0 3s610ms 0ms 6s153ms 8s585ms 09 1 6 4s577ms 3s71ms 11s134ms 17s838ms 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 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 0 0ms 0ms 0ms 0ms 08 28 0 5s160ms 8s136ms 11s787ms 40s490ms 09 0 1 4s524ms 0ms 0ms 4s524ms 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 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 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 0 0 0ms 0ms 0ms 0ms 07 0 0 0 3 46s994ms 22s66ms 1m58s 1m58s 08 0 0 0 8 9s723ms 0ms 8s358ms 28s8ms 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 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 0 0 0ms 0ms 0ms 0ms 08 0 0 0 10 40s116ms 0ms 26s257ms 1m13s 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 0 0 0ms 0ms 0ms 0ms 07 0 0 0 4 52s8ms 38s94ms 2m25s 2m25s 08 0 0 0 6 13s100ms 0ms 5s670ms 38s66ms 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 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 0 0 0ms 0ms 0ms 0ms 08 0 0 0 8 34s272ms 0ms 0ms 44s790ms 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 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 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 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 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 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 04 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% 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 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 06 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 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 2 0.00/s 07 7 0.00/s 08 4 0.00/s 09 5 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 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 5 0.00/s 08 7 0.00/s 09 8 0.00/s 10 3 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 04 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 7 0.00/s 08 4 0.00/s 09 5 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 05 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 9 0.00/s 09 7 0.00/s 10 6 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 06 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 5 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 60ms 60ms 01 2 52ms 52ms 02 2 54ms 54ms 03 2 58ms 58ms 04 2 55ms 55ms 05 2 52ms 52ms 06 2 53ms 53ms 07 2 52ms 52ms 08 2 52ms 52ms 09 2 52ms 52ms 10 2 57ms 57ms 11 2 53ms 53ms 12 2 53ms 53ms 13 2 51ms 51ms 14 2 51ms 51ms 15 2 55ms 55ms 16 2 57ms 57ms 17 2 56ms 56ms 18 2 69ms 69ms 19 2 62ms 62ms 20 2 55ms 55ms 21 2 55ms 55ms 22 2 54ms 54ms 23 2 58ms 58ms Mar 02 00 2 50ms 50ms 01 2 59ms 59ms 02 2 57ms 57ms 03 2 53ms 53ms 04 2 49ms 49ms 06 2 1s256ms 1s256ms 07 5 2s33ms 0ms 08 5 15m29s 9m57s 09 5 14m8s 0ms 10 3 13m1s 13m1s 11 2 69ms 69ms 12 2 63ms 63ms 13 2 58ms 58ms 14 2 55ms 55ms 15 2 57ms 57ms 16 2 58ms 58ms 17 2 62ms 62ms 18 2 68ms 68ms 19 2 158ms 158ms 20 2 58ms 58ms 21 2 52ms 52ms 22 2 53ms 53ms 23 2 59ms 59ms Mar 03 00 2 52ms 52ms 01 2 57ms 57ms 02 2 56ms 56ms 03 2 60ms 60ms 04 2 60ms 60ms 05 2 55ms 55ms 06 2 157ms 157ms 07 5 980ms 980ms 08 5 13s707ms 0ms 09 9 14m53s 11m40s 10 4 12m26s 5m47s 11 2 59ms 59ms 12 2 57ms 57ms 13 2 67ms 67ms 14 2 54ms 54ms 15 2 66ms 66ms 16 2 105ms 105ms 17 2 58ms 58ms 18 2 56ms 56ms 19 2 52ms 52ms 20 2 57ms 57ms 21 2 53ms 53ms 22 2 54ms 54ms 23 2 52ms 52ms Mar 04 00 2 58ms 58ms 01 2 58ms 58ms 02 2 51ms 51ms 03 2 56ms 56ms 04 2 53ms 53ms 05 2 55ms 55ms 06 2 98ms 98ms 07 5 2s35ms 0ms 08 5 14m49s 9m45s 09 5 13m3s 0ms 10 3 12m12s 12m12s 11 2 60ms 60ms 12 2 56ms 56ms 13 2 56ms 56ms 14 2 54ms 54ms 15 2 63ms 63ms 16 2 54ms 54ms 17 2 60ms 60ms 18 2 54ms 54ms 19 2 63ms 63ms 20 2 55ms 55ms 21 2 52ms 52ms 22 2 54ms 54ms 23 2 55ms 55ms Mar 05 00 2 57ms 57ms 01 2 52ms 52ms 02 2 60ms 60ms 03 2 56ms 56ms 04 2 53ms 53ms 05 2 58ms 58ms 06 2 100ms 100ms 07 2 138ms 138ms 08 8 10m24s 6m35s 09 7 8m28s 431ms 10 7 4m27s 4m27s 11 2 52ms 52ms 12 2 58ms 58ms 13 2 55ms 55ms 14 2 54ms 54ms 15 2 56ms 56ms 16 2 62ms 62ms 17 2 53ms 53ms 18 2 59ms 59ms 19 2 63ms 63ms 20 2 57ms 57ms 21 2 53ms 53ms 22 2 55ms 55ms 23 2 67ms 67ms Mar 06 00 2 50ms 50ms 01 2 56ms 56ms 02 2 57ms 57ms 03 2 55ms 55ms 04 2 54ms 54ms 05 2 65ms 65ms 06 2 138ms 138ms 07 2 728ms 728ms 08 2 137ms 137ms 09 2 58ms 58ms 10 2 53ms 53ms 11 2 107ms 107ms 12 2 55ms 55ms 13 2 52ms 52ms 14 5 157ms 157ms 15 2 56ms 56ms 16 2 59ms 59ms 17 2 57ms 57ms 18 2 51ms 51ms 19 2 54ms 54ms 20 2 59ms 59ms 21 2 55ms 55ms 22 2 57ms 57ms 23 1 56ms 56ms Mar 07 00 2 59ms 59ms 01 2 57ms 57ms 02 2 52ms 52ms 03 2 53ms 53ms 04 2 56ms 56ms 05 2 53ms 53ms 06 2 55ms 55ms 07 2 58ms 58ms 08 2 49ms 49ms 09 2 55ms 55ms 10 2 61ms 61ms 11 2 72ms 72ms 12 2 57ms 57ms 13 2 60ms 60ms 14 2 57ms 57ms 15 2 55ms 55ms 16 2 63ms 63ms 17 2 58ms 58ms 18 2 56ms 56ms 19 2 54ms 54ms 20 2 53ms 53ms 21 2 59ms 59ms 22 2 54ms 54ms 23 2 53ms 53ms -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-03-02 07:58:26 Date
Connections per database
Key values
- reftkbim Main Database
- 387 connections Total
Connections per user
Key values
- azuresu Main User
- 387 connections Total
-
Sessions
Simultaneous sessions
Key values
- 49 sessions Session Peak
- 2026-03-03 08:58:47 Date
Histogram of session times
Key values
- 332 0-500ms duration
Sessions per database
Key values
- reftkbim Main Database
- 387 sessions Total
Sessions per user
Key values
- azuresu Main User
- 387 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 387 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 294.66 MiB Temp Files size Peak
- 2026-03-05 08:08:50 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-03-05 09:39:45 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 0 0 0 07 0 0 0 08 53 1.61 GiB 31.01 MiB 09 96 1.32 GiB 14.09 MiB 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 0 0 0 08 115 2.68 GiB 23.88 MiB 09 78 1002.02 MiB 12.85 MiB 10 18 351.69 MiB 19.54 MiB 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 8 413.91 MiB 51.74 MiB 08 71 2.13 GiB 30.68 MiB 09 94 1.32 GiB 14.37 MiB 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 0 0 0 08 78 2.81 GiB 36.86 MiB 09 94 1.32 GiB 14.36 MiB 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 2.31 GiB 87.16 MiB 505.77 MiB 295.59 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-05 08:08:34 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 8 318.22 MiB 9.38 MiB 206.23 MiB 39.78 MiB add constraint pk_gtp_cw_eng_histo primary key (history_num_id);-
ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);
Date: 2026-03-05 08:15:47 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 6 796.67 MiB 88.73 MiB 199.16 MiB 132.78 MiB 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);-
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 08:15:59 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6 261.39 MiB 2.80 MiB 171.27 MiB 43.57 MiB add constraint pk_l_notification_user primary key (nous_user_num_id, nous_noti_id);-
ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);
Date: 2026-03-05 08:18:09 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6 124.94 MiB 3.84 MiB 59.64 MiB 20.82 MiB add constraint pk_gtp_relation_num_id primary key (relation_num_id);-
ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);
Date: 2026-03-04 08:07:22 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6 995.94 MiB 33.68 MiB 536.27 MiB 165.99 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-03-05 08:14:49 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6 236.44 MiB 32.18 MiB 46.63 MiB 39.41 MiB add constraint uk_pe_consumption_10min unique (counting_point_num_id, date_stamped, type, time_period);-
ADD CONSTRAINT uk_pe_consumption_10min UNIQUE (counting_point_num_id, date_stamped, type, time_period);
Date: 2026-03-05 08:15:30 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6 931.30 MiB 47.10 MiB 361.02 MiB 155.22 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-03-05 08:03:53 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6 61.99 MiB 4.30 MiB 17.21 MiB 10.33 MiB add constraint uk_pe_consumption_hourly unique (counting_point_num_id, date_stamped, type, consolidated, time_period);-
ADD CONSTRAINT uk_pe_consumption_hourly UNIQUE (counting_point_num_id, date_stamped, type, consolidated, time_period);
Date: 2026-03-04 08:10:34 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6 335.55 MiB 45.22 MiB 66.63 MiB 55.92 MiB add constraint uk_gtp_obj_composition unique (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);-
ADD CONSTRAINT uk_gtp_obj_composition UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-05 08:17:51 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 166.19 MiB 12.06 MiB 61.59 MiB 27.70 MiB add constraint uk_gtp_obj_rel_vt_path unique (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);-
ADD CONSTRAINT uk_gtp_obj_rel_vt_path UNIQUE (relation_num_id, obj_num_id, obj_num_id_p, node_tree_type_num_id, node_tree_type_num_id_p, view_template_num_id);
Date: 2026-03-04 08:10:27 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 941.10 MiB 25.98 MiB 320.44 MiB 156.85 MiB add constraint pk_gtp_obj_compo primary key (obj_compo_num_id);-
ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);
Date: 2026-03-05 08:16:41 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6 79.58 MiB 7.34 MiB 19.46 MiB 13.26 MiB add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);-
ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-03-04 08:10:39 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3 127.82 MiB 18.09 MiB 56.16 MiB 42.61 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2026-03-04 08:09:40 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3 189.34 MiB 8.34 MiB 153.23 MiB 63.11 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-03-04 08:10:04 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 93.14 MiB 9.77 MiB 83.38 MiB 46.57 MiB add constraint pk_history_obj_link_unlink primary key (history_link_unlink_id);-
ADD CONSTRAINT pk_history_obj_link_unlink PRIMARY KEY (history_link_unlink_id);
Date: 2026-03-03 08:35:59 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 20.63 MiB 4.34 MiB 16.29 MiB 10.32 MiB add constraint pk_pe_consumption_hourly primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_hourly PRIMARY KEY (consumption_num_id);
Date: 2026-03-04 08:10:32 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 823.73 MiB 411.24 MiB 412.49 MiB 411.87 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2026-03-03 08:17:23 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2 588.20 MiB 293.53 MiB 294.66 MiB 294.10 MiB add constraint fk_gtp_relation_rel_template foreign key (rel_template_num_id) references public.gtp_rel_template (rel_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_relation_rel_template FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:08:50 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 4.59 MiB 4.59 MiB 4.59 MiB 4.59 MiB add constraint pk_log_connection primary key (log_connection_num_id);-
ADD CONSTRAINT pk_log_connection PRIMARY KEY (log_connection_num_id);
Date: 2026-03-02 08:06:45 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 8.41 MiB 8.41 MiB 8.41 MiB 8.41 MiB add constraint fk_gtp_obj_rel_vt_rel foreign key (relation_num_id) references public.gtp_relation (relation_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (relation_num_id) REFERENCES public.gtp_relation (relation_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-03 08:39:49 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 35.84 MiB 35.84 MiB 35.84 MiB 35.84 MiB add constraint fk_gtp_cw_eng_alert foreign key (history_num_id) references public.gtp_cw_eng_history (history_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_cw_eng_alert FOREIGN KEY (history_num_id) REFERENCES public.gtp_cw_eng_history (history_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-05 08:15:50 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 24.45 MiB 24.45 MiB 24.45 MiB 24.45 MiB add constraint fk_gtp_obj_rel_vt_ntt foreign key (view_template_num_id, node_tree_type_num_id) references public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_ntt FOREIGN KEY (view_template_num_id, node_tree_type_num_id) REFERENCES public.gtp_node_tree_type (view_template_num_id, node_tree_type_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-02 08:06:54 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 2.54 MiB 2.54 MiB 2.54 MiB 2.54 MiB add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-03 08:36:36 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 120.75 MiB 120.75 MiB 120.75 MiB 120.75 MiB add constraint fk_view_template_modifier foreign key (view_template_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_view_template_modifier FOREIGN KEY (view_template_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-03-03 08:25:43 Duration: 0ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 536.27 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-05 08:14:49 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 505.77 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-05 08:08:34 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 505.12 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-04 08:01:13 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 502.20 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-03 08:20:19 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 500.61 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2026-03-02 08:05:11 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 412.49 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2026-03-03 08:17:23 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 411.24 MiB ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);[ Date: 2026-03-02 08:00:29 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 361.02 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-04 07:55:39 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 357.98 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-03-05 08:03:53 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 320.44 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-04 08:08:13 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 314.15 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-03 08:31:25 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 294.66 MiB ADD CONSTRAINT fk_gtp_relation_rel_template FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-05 08:08:50 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 293.53 MiB ADD CONSTRAINT fk_gtp_relation_rel_template FOREIGN KEY (rel_template_num_id) REFERENCES public.gtp_rel_template (rel_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-03-04 08:02:03 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 264.71 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-03-03 08:28:16 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 208.84 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-03-05 08:16:41 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 206.23 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-03-04 08:08:32 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 199.16 MiB 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 08:12:14 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 199.16 MiB 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 08:15:59 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 171.27 MiB ADD CONSTRAINT pk_l_notification_user PRIMARY KEY (nous_user_num_id, nous_noti_id);[ Date: 2026-03-05 08:18:09 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 153.23 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2026-03-02 08:11:29 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
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
- ShareRowExclusiveLock Main Lock Type
- 11 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 2 16s287ms 8s143ms relation 2 16s287ms 8s143ms ExclusiveLock 2 2s790ms 1s395ms extension 2 2s790ms 1s395ms ShareLock 2 21s635ms 10s817ms relation 2 21s635ms 10s817ms ShareRowExclusiveLock 3 3s25ms 1s8ms relation 3 3s25ms 1s8ms ShareUpdateExclusiveLock 2 2s39ms 1s19ms relation 2 2s39ms 1s19ms Total 11 45s778ms 4s161ms 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
- 44 Total read queries
- 259 Total write queries
Queries by database
Key values
- reftkbim Main database
- 311 Requests
- 6h28m3s (reftkbim)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 311 Requests
User Request type Count Duration a3dsupervisor Total 311 6h28m3s copy from 39 19m40s copy to 16 1m50s ddl 201 1h52m19s others 8 4h10m33s select 44 3m24s tcl 3 13s965ms Duration by user
Key values
- 6h28m3s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 311 6h28m3s copy from 39 19m40s copy to 16 1m50s ddl 201 1h52m19s others 8 4h10m33s select 44 3m24s tcl 3 13s965ms Queries by host
Key values
- 10.3.0.4 Main host
- 311 Requests
- 6h28m3s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 286 Requests
- 4h10m33s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-03-04 14:24:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 182 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 39m53s DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;[ Date: 2026-03-02 09:17:19 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 38m24s DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;[ Date: 2026-03-04 09:09:56 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 35m24s DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;[ Date: 2026-03-05 09:19:16 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 30m48s VACUUM FULL;[ Date: 2026-03-02 09:48:08 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 28m58s DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;[ Date: 2026-03-03 09:35:16 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 26m50s VACUUM FULL;[ Date: 2026-03-04 09:36:47 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
7 26m25s VACUUM FULL;[ Date: 2026-03-03 10:01:43 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 23m47s VACUUM FULL;[ Date: 2026-03-05 09:43:05 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
9 5m27s CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2026-03-02 08:05:57 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 5m20s CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2026-03-04 08:02:04 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 5m11s CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2026-03-02 08:05:11 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 4m50s CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2026-03-04 08:01:14 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 4m16s CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2026-03-05 08:12:51 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 4m10s CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2026-03-05 08:08:50 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 4m4s CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2026-03-05 08:08:34 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 3m54s CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);[ Date: 2026-03-03 08:20:20 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 3m27s CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2026-03-04 08:04:42 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 3m27s CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);[ Date: 2026-03-03 08:20:51 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 3m26s CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);[ Date: 2026-03-02 08:08:38 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 2m42s 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) FROM stdin;[ Date: 2026-03-03 08:16:25 - Database: reftkbim - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h22m41s 4 28m58s 39m53s 35m40s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 10 1 39m53s 39m53s Mar 03 10 1 28m58s 28m58s Mar 04 10 1 38m24s 38m24s Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 2h22m41s - Times executed: 4 ]
[ Application: psql - Total duration: 2h22m41s - Times executed: 4 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-02 09:17:19 Duration: 39m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-04 09:09:56 Duration: 38m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1h47m52s 4 23m47s 30m48s 26m58s vacuum full;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 02 10 1 30m48s 30m48s Mar 03 11 1 26m25s 26m25s Mar 04 10 1 26m50s 26m50s Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 1h47m52s - Times executed: 4 ]
[ Application: psql - Total duration: 1h47m52s - Times executed: 4 ]
-
VACUUM FULL;
Date: 2026-03-02 09:48:08 Duration: 30m48s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-04 09:36:47 Duration: 26m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-03 10:01:43 Duration: 26m25s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 18m25s 4 3m27s 5m27s 4m36s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 02 09 1 5m27s 5m27s Mar 03 09 1 3m27s 3m27s Mar 04 09 1 5m20s 5m20s Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 18m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m25s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-02 08:05:57 Duration: 5m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-04 08:02:04 Duration: 5m20s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 18m 4 3m54s 5m11s 4m30s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 02 09 1 5m11s 5m11s Mar 03 09 1 3m54s 3m54s Mar 04 09 1 4m50s 4m50s Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 18m - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-02 08:05:11 Duration: 5m11s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-04 08:01:14 Duration: 4m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 13m43s 4 2m31s 4m16s 3m25s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 02 09 1 3m26s 3m26s Mar 03 09 1 2m31s 2m31s Mar 04 09 1 3m27s 3m27s Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 13m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 13m43s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-04 08:04:42 Duration: 3m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-02 08:08:38 Duration: 3m26s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 8m4s 4 1m23s 2m42s 2m1s 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) from stdin;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 02 08 1 1m23s 1m23s Mar 03 09 1 2m42s 2m42s Mar 04 08 1 1m58s 1m58s Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 8m4s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m4s - 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) FROM stdin;
Date: 2026-03-03 08:16:25 Duration: 2m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:23 Duration: 1m58s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 7m48s 4 1m21s 2m31s 1m57s alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 02 09 1 2m13s 2m13s Mar 03 09 1 1m42s 1m42s Mar 04 09 1 2m31s 2m31s Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m48s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 08:07:14 Duration: 2m31s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-02 08:10:51 Duration: 2m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-03 08:24:34 Duration: 1m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5m12s 4 7s894ms 2m32s 1m18s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 02 09 1 1m1s 1m1s Mar 03 09 1 2m32s 2m32s Mar 04 09 1 1m30s 1m30s Mar 05 09 1 7s894ms 7s894ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-03 08:28:18 Duration: 2m32s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-04 08:06:34 Duration: 1m30s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-02 08:11:30 Duration: 1m1s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3m21s 43 3s5ms 10s590ms 4s691ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 02 09 1 3s244ms 3s244ms Mar 03 09 9 35s948ms 3s994ms Mar 04 09 5 18s51ms 3s610ms Mar 05 09 28 2m24s 5s160ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 43 ]
[ Application: pg_restore - Total duration: 3m21s - Times executed: 43 ]
-
SELECT pg_catalog.lo_create('2396933');
Date: 2026-03-05 08:35:18 Duration: 10s590ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2396802');
Date: 2026-03-05 08:34:24 Duration: 8s42ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2397007');
Date: 2026-03-05 08:35:51 Duration: 6s694ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3m12s 4 35s792ms 1m13s 48s86ms 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) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 02 08 1 35s792ms 35s792ms Mar 03 09 1 1m13s 1m13s Mar 04 08 1 38s94ms 38s94ms Mar 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m12s - 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) FROM stdin;
Date: 2026-03-03 08:15:26 Duration: 1m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:55:28 Duration: 38s94ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3m11s 4 10s879ms 1m57s 47s847ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 02 09 1 52s240ms 52s240ms Mar 03 09 1 1m57s 1m57s Mar 04 08 1 11s229ms 11s229ms Mar 05 09 1 10s879ms 10s879ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-03 08:17:23 Duration: 1m57s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-02 08:00:30 Duration: 52s240ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-04 07:55:40 Duration: 11s229ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3m7s 4 5s139ms 2m17s 46s943ms create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 02 09 1 39s643ms 39s643ms Mar 03 09 1 2m17s 2m17s Mar 04 09 1 5s139ms 5s139ms Mar 05 09 1 5s335ms 5s335ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-03 08:28:05 Duration: 2m17s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-02 08:11:30 Duration: 39s643ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-05 08:14:54 Duration: 5s335ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 2m27s 4 10s991ms 1m8s 36s803ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 09 1 1m8s 1m8s Mar 03 09 1 56s419ms 56s419ms Mar 04 08 1 10s991ms 10s991ms Mar 05 09 1 11s205ms 11s205ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-02 08:09:46 Duration: 1m8s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-03 08:24:19 Duration: 56s419ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-05 08:04:07 Duration: 11s205ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2m23s 1 2m23s 2m23s 2m23s alter table only public.gtp_history_obj_compo;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 03 09 1 2m23s 2m23s [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo;
Date: 2026-03-03 08:39:15 Duration: 2m23s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2m21s 4 5s236ms 1m53s 35s465ms create index i_fk_gtp_obj_compo_unit on public.gtp_obj_composition using btree (obj_compo_unit_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 02 09 1 5s236ms 5s236ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 9s452ms 9s452ms Mar 05 09 1 13s426ms 13s426ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-03 08:31:27 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-05 08:16:42 Duration: 13s426ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-04 08:08:30 Duration: 9s452ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2m19s 4 4s891ms 1m53s 34s893ms create index i_fk_gtp_obj_compo_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 02 09 1 4s891ms 4s891ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 7s434ms 7s434ms Mar 05 09 1 13s687ms 13s687ms [ User: a3dsupervisor - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m19s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-03 08:31:26 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-05 08:16:42 Duration: 13s687ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-04 08:08:21 Duration: 7s434ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2m13s 4 20s44ms 1m6s 33s442ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 02 09 1 20s44ms 20s44ms Mar 03 09 1 21s688ms 21s688ms Mar 04 09 1 1m6s 1m6s Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m13s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-04 08:08:32 Duration: 1m6s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-03 08:31:59 Duration: 21s688ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2m7s 4 8s744ms 50s294ms 31s956ms create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 02 09 1 48s21ms 48s21ms Mar 03 09 1 50s294ms 50s294ms Mar 04 09 1 8s744ms 8s744ms Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m7s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-03 08:23:22 Duration: 50s294ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-02 08:08:29 Duration: 48s21ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1m57s 4 15s53ms 43s944ms 29s309ms create index i_fk_gtp_obj_compo_ligne_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 02 09 1 43s944ms 43s944ms Mar 03 09 1 31s536ms 31s536ms Mar 04 09 1 26s704ms 26s704ms Mar 05 09 1 15s53ms 15s53ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m57s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-02 08:13:06 Duration: 43s944ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-03 08:25:43 Duration: 31s536ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-04 08:08:07 Duration: 26s704ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1m54s 4 25s440ms 34s28ms 28s613ms 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) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 02 09 1 28s8ms 28s8ms Mar 03 09 1 34s28ms 34s28ms Mar 04 08 1 26s977ms 26s977ms Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m54s - 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) FROM stdin;
Date: 2026-03-03 08:25:45 Duration: 34s28ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-02 08:10:29 Duration: 28s8ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:44 Duration: 26s977ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 43 3m21s 3s5ms 10s590ms 4s691ms select pg_catalog.lo_create(?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 09 1 3s244ms 3s244ms Mar 03 09 9 35s948ms 3s994ms Mar 04 09 5 18s51ms 3s610ms Mar 05 09 28 2m24s 5s160ms [ User: a3dsupervisor - Total duration: 3m21s - Times executed: 43 ]
[ Application: pg_restore - Total duration: 3m21s - Times executed: 43 ]
-
SELECT pg_catalog.lo_create('2396933');
Date: 2026-03-05 08:35:18 Duration: 10s590ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2396802');
Date: 2026-03-05 08:34:24 Duration: 8s42ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
SELECT pg_catalog.lo_create('2397007');
Date: 2026-03-05 08:35:51 Duration: 6s694ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 4 2h22m41s 28m58s 39m53s 35m40s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 02 10 1 39m53s 39m53s Mar 03 10 1 28m58s 28m58s Mar 04 10 1 38m24s 38m24s Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 2h22m41s - Times executed: 4 ]
[ Application: psql - Total duration: 2h22m41s - Times executed: 4 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-02 09:17:19 Duration: 39m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-04 09:09:56 Duration: 38m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 4 1h47m52s 23m47s 30m48s 26m58s vacuum full;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 02 10 1 30m48s 30m48s Mar 03 11 1 26m25s 26m25s Mar 04 10 1 26m50s 26m50s Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 1h47m52s - Times executed: 4 ]
[ Application: psql - Total duration: 1h47m52s - Times executed: 4 ]
-
VACUUM FULL;
Date: 2026-03-02 09:48:08 Duration: 30m48s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-04 09:36:47 Duration: 26m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-03 10:01:43 Duration: 26m25s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 4 18m25s 3m27s 5m27s 4m36s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 02 09 1 5m27s 5m27s Mar 03 09 1 3m27s 3m27s Mar 04 09 1 5m20s 5m20s Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 18m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m25s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-02 08:05:57 Duration: 5m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-04 08:02:04 Duration: 5m20s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 4 18m 3m54s 5m11s 4m30s create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 02 09 1 5m11s 5m11s Mar 03 09 1 3m54s 3m54s Mar 04 09 1 4m50s 4m50s Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 18m - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-02 08:05:11 Duration: 5m11s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-04 08:01:14 Duration: 4m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 4 13m43s 2m31s 4m16s 3m25s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 02 09 1 3m26s 3m26s Mar 03 09 1 2m31s 2m31s Mar 04 09 1 3m27s 3m27s Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 13m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 13m43s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-04 08:04:42 Duration: 3m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-02 08:08:38 Duration: 3m26s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 4 8m4s 1m23s 2m42s 2m1s 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) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 02 08 1 1m23s 1m23s Mar 03 09 1 2m42s 2m42s Mar 04 08 1 1m58s 1m58s Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 8m4s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m4s - 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) FROM stdin;
Date: 2026-03-03 08:16:25 Duration: 2m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:23 Duration: 1m58s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 4 7m48s 1m21s 2m31s 1m57s alter table only public.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 09 1 2m13s 2m13s Mar 03 09 1 1m42s 1m42s Mar 04 09 1 2m31s 2m31s Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m48s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 08:07:14 Duration: 2m31s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-02 08:10:51 Duration: 2m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-03 08:24:34 Duration: 1m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 4 5m12s 7s894ms 2m32s 1m18s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 02 09 1 1m1s 1m1s Mar 03 09 1 2m32s 2m32s Mar 04 09 1 1m30s 1m30s Mar 05 09 1 7s894ms 7s894ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-03 08:28:18 Duration: 2m32s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-04 08:06:34 Duration: 1m30s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-02 08:11:30 Duration: 1m1s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 4 3m12s 35s792ms 1m13s 48s86ms 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) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 02 08 1 35s792ms 35s792ms Mar 03 09 1 1m13s 1m13s Mar 04 08 1 38s94ms 38s94ms Mar 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m12s - 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) FROM stdin;
Date: 2026-03-03 08:15:26 Duration: 1m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:55:28 Duration: 38s94ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 4 3m11s 10s879ms 1m57s 47s847ms create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 02 09 1 52s240ms 52s240ms Mar 03 09 1 1m57s 1m57s Mar 04 08 1 11s229ms 11s229ms Mar 05 09 1 10s879ms 10s879ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-03 08:17:23 Duration: 1m57s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-02 08:00:30 Duration: 52s240ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-04 07:55:40 Duration: 11s229ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4 3m7s 5s139ms 2m17s 46s943ms create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 02 09 1 39s643ms 39s643ms Mar 03 09 1 2m17s 2m17s Mar 04 09 1 5s139ms 5s139ms Mar 05 09 1 5s335ms 5s335ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-03 08:28:05 Duration: 2m17s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-02 08:11:30 Duration: 39s643ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-05 08:14:54 Duration: 5s335ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 4 2m27s 10s991ms 1m8s 36s803ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 09 1 1m8s 1m8s Mar 03 09 1 56s419ms 56s419ms Mar 04 08 1 10s991ms 10s991ms Mar 05 09 1 11s205ms 11s205ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-02 08:09:46 Duration: 1m8s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-03 08:24:19 Duration: 56s419ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-05 08:04:07 Duration: 11s205ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 4 2m21s 5s236ms 1m53s 35s465ms create index i_fk_gtp_obj_compo_unit on public.gtp_obj_composition using btree (obj_compo_unit_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 02 09 1 5s236ms 5s236ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 9s452ms 9s452ms Mar 05 09 1 13s426ms 13s426ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-03 08:31:27 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-05 08:16:42 Duration: 13s426ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-04 08:08:30 Duration: 9s452ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 2m19s 4s891ms 1m53s 34s893ms create index i_fk_gtp_obj_compo_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 02 09 1 4s891ms 4s891ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 7s434ms 7s434ms Mar 05 09 1 13s687ms 13s687ms [ User: a3dsupervisor - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m19s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-03 08:31:26 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-05 08:16:42 Duration: 13s687ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-04 08:08:21 Duration: 7s434ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4 2m13s 20s44ms 1m6s 33s442ms create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (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 09 1 20s44ms 20s44ms Mar 03 09 1 21s688ms 21s688ms Mar 04 09 1 1m6s 1m6s Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m13s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-04 08:08:32 Duration: 1m6s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-03 08:31:59 Duration: 21s688ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 4 2m7s 8s744ms 50s294ms 31s956ms create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 02 09 1 48s21ms 48s21ms Mar 03 09 1 50s294ms 50s294ms Mar 04 09 1 8s744ms 8s744ms Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m7s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-03 08:23:22 Duration: 50s294ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-02 08:08:29 Duration: 48s21ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 4 1m57s 15s53ms 43s944ms 29s309ms create index i_fk_gtp_obj_compo_ligne_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 02 09 1 43s944ms 43s944ms Mar 03 09 1 31s536ms 31s536ms Mar 04 09 1 26s704ms 26s704ms Mar 05 09 1 15s53ms 15s53ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m57s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-02 08:13:06 Duration: 43s944ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-03 08:25:43 Duration: 31s536ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-04 08:08:07 Duration: 26s704ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 4 1m54s 25s440ms 34s28ms 28s613ms 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) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 02 09 1 28s8ms 28s8ms Mar 03 09 1 34s28ms 34s28ms Mar 04 08 1 26s977ms 26s977ms Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m54s - 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) FROM stdin;
Date: 2026-03-03 08:25:45 Duration: 34s28ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-02 08:10:29 Duration: 28s8ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:44 Duration: 26s977ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 4 1m51s 17s76ms 38s66ms 27s849ms 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) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 02 09 1 17s76ms 17s76ms Mar 03 09 1 24s584ms 24s584ms Mar 04 09 1 38s66ms 38s66ms Mar 05 09 1 31s670ms 31s670ms [ User: a3dsupervisor - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m51s - 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) FROM stdin;
Date: 2026-03-04 08:04:41 Duration: 38s66ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:09:22 Duration: 31s670ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-03 08:21:15 Duration: 24s584ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 28m58s 39m53s 35m40s 4 2h22m41s do $$ declare v_start time; v_stop time; l_anonymize_flags integer := current_setting(?); l_reduce_history integer := current_setting(?); l_truncate integer := current_setting(?); l_anonymize_list text[] := array[?, ?, ?, ?, ?, ?, ?, ?]; i int; begin raise notice ?; raise notice ?, l_anonymize_flags; raise notice ?, l_reduce_history; call pack_gtp_utils.p_trace_log (?, ?); v_start := clock_timestamp()::time; if (l_truncate > ?) then raise notice ?; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice ?; end if; for i in ?..array_length(l_anonymize_list, ?) loop if (l_anonymize_flags & (? << (i - ?))) = (? << (i - ?)) then raise notice ?, l_anonymize_list[i]; execute ? || l_anonymize_list[i] || ?; raise notice ?, l_anonymize_list[i]; end if; end loop; if (l_reduce_history > ?) then raise notice ?; delete from gtp_history_obj_action where action_date < current_date - ?; delete from gtp_monthly_history where histo_dcre < current_date - ?; raise notice ?; end if; v_stop := clock_timestamp()::time; raise notice ?, extract(millisecond from (v_stop - v_start)); raise notice ?; call pack_gtp_utils.p_trace_log (?, ?); exception when others then raise notice ?, sqlstate, sqlerrm; call pack_gtp_utils.p_trace_error (?, sqlerrm); end $$;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 02 10 1 39m53s 39m53s Mar 03 10 1 28m58s 28m58s Mar 04 10 1 38m24s 38m24s Mar 05 10 1 35m24s 35m24s [ User: a3dsupervisor - Total duration: 2h22m41s - Times executed: 4 ]
[ Application: psql - Total duration: 2h22m41s - Times executed: 4 ]
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-02 09:17:19 Duration: 39m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-04 09:09:56 Duration: 38m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
DO $$ DECLARE v_start time; v_stop time; -- l_anonymize_flags : La valeur correspond à la somme des puissances de 2 détails : -- - 0000000001 (2^0 = 1) : Anonymize DCS -- - 0000000010 (2^1 = 2) : Anonymize GED -- - 0000000100 (2^2 = 4) : Anonymize Notification -- - 0000001000 (2^3 = 8) : Anonymize Background task -- - 0000010000 (2^4 = 16) : Anonymize Bim -- - 0000100000 (2^5 = 32) : Anonymize Comment -- - 0001000000 (2^6 = 64) : Anonymize DCP -- - 0010000000 (2^7 = 128) : Anonymize coordonnées -- - 0100000000 (2^8 = 256) : Free -- - 1000000000 (2^9 = 512) : Free l_anonymize_flags integer := current_setting('args.anonymizeflags'); l_reduce_history integer := current_setting('args.reducehistory'); l_truncate integer := current_setting('args.truncate'); l_anonymize_list text[] := ARRAY['pack_gtp_dba.p_anonymization_dcs', -- (2^0 = 1) 'pack_gtp_dba.p_anonymization_ged', -- (2^1 = 2) 'pack_gtp_dba.p_anonymization_notif', -- (2^2 = 4) 'pack_gtp_dba.p_anonymization_backgroundtask', -- (2^3 = 8) 'pack_gtp_dba.p_anonymization_bim', -- (2^4 = 16) 'pack_gtp_dba.p_anonymization_comment', -- (2^5 = 32) 'pack_gtp_dba.p_anonymization_dcp', -- (2^6 = 64) 'pack_gtp_dba.p_anonymization_coordinates' -- (2^7 = 128) ]; i int; BEGIN raise notice '[START] reduceAndAnonymizeDatabase.sql'; raise notice '[args.anonymizeflags] : %', l_anonymize_flags; raise notice '[args.reducehistory] : %', l_reduce_history; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_REDUCE_DB', '[START] reduceAndAnonymizeDatabase.sql'); v_start := clock_timestamp()::time; IF (l_truncate > 0) THEN raise notice '[START] Truncate tables'; truncate table public.gtp_log_connection cascade; truncate table public.gtp_log_ehcache cascade; truncate table public.gtp_log_jvm cascade; truncate table public.gtp_log_session cascade; truncate table public.gtp_log_thread cascade; truncate table public.gtp_mail_adress cascade; truncate table public.gtp_mail cascade; truncate table public.log_session cascade; truncate table public.gtp_error cascade; truncate table public.batch_step_execution_context cascade; truncate table public.batch_step_execution cascade; truncate table public.batch_job_execution_context cascade; truncate table public.batch_job_execution cascade; truncate table public.batch_job_execution_params cascade; truncate table public.batch_job_instance cascade; raise notice '[END] Truncate tables'; END IF; FOR i IN 1..array_length(l_anonymize_list, 1) LOOP IF (l_anonymize_flags & (1 << (i - 1))) = (1 << (i - 1)) THEN RAISE NOTICE '[START] %()', l_anonymize_list[i]; EXECUTE 'CALL ' || l_anonymize_list[i] || '()'; RAISE NOTICE '[END] %()', l_anonymize_list[i]; END IF; END LOOP; IF (l_reduce_history > 0) THEN raise notice '[START] Delete gtp_history_obj_action et gtp_monthly_history'; delete from gtp_history_obj_action where action_date < current_date -180; delete from gtp_monthly_history where histo_dcre < current_date -90; raise notice '[END] Delete gtp_history_obj_action et gtp_monthly_history'; END IF; v_stop := clock_timestamp()::time; RAISE NOTICE '% ms', EXTRACT(MILLISECOND FROM (v_stop - v_start)); RAISE NOTICE '[END] reduceAndAnonymizeDatabase.sql'; CALL PACK_GTP_UTILS.P_TRACE_LOG ('A3D_CLEAN_PDB', '[END] reduceAndAnonymizeDatabase.sql'); EXCEPTION WHEN OTHERS THEN RAISE NOTICE '[ERROR] reduceAndAnonymizeDatabase.sql: SQLSTATE=% SQLERRM=%', SQLSTATE, SQLERRM; CALL PACK_GTP_UTILS.P_TRACE_ERROR ('[ERROR] reduceAndAnonymizeDatabase.sql', SQLERRM); END $$;
Date: 2026-03-05 09:19:16 Duration: 35m24s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 23m47s 30m48s 26m58s 4 1h47m52s vacuum full;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 02 10 1 30m48s 30m48s Mar 03 11 1 26m25s 26m25s Mar 04 10 1 26m50s 26m50s Mar 05 10 1 23m47s 23m47s [ User: a3dsupervisor - Total duration: 1h47m52s - Times executed: 4 ]
[ Application: psql - Total duration: 1h47m52s - Times executed: 4 ]
-
VACUUM FULL;
Date: 2026-03-02 09:48:08 Duration: 30m48s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-04 09:36:47 Duration: 26m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM FULL;
Date: 2026-03-03 10:01:43 Duration: 26m25s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 3m27s 5m27s 4m36s 4 18m25s create index i_log_ehcache_region_name on public.gtp_log_ehcache using btree (region_name);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 02 09 1 5m27s 5m27s Mar 03 09 1 3m27s 3m27s Mar 04 09 1 5m20s 5m20s Mar 05 09 1 4m10s 4m10s [ User: a3dsupervisor - Total duration: 18m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m25s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-02 08:05:57 Duration: 5m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-04 08:02:04 Duration: 5m20s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (region_name);
Date: 2026-03-05 08:08:50 Duration: 4m10s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 3m54s 5m11s 4m30s 4 18m create index i_log_ehcache_date on public.gtp_log_ehcache using btree (log_date);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 02 09 1 5m11s 5m11s Mar 03 09 1 3m54s 3m54s Mar 04 09 1 4m50s 4m50s Mar 05 09 1 4m4s 4m4s [ User: a3dsupervisor - Total duration: 18m - Times executed: 4 ]
[ Application: pg_restore - Total duration: 18m - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-02 08:05:11 Duration: 5m11s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-04 08:01:14 Duration: 4m50s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_date ON public.gtp_log_ehcache USING btree (log_date);
Date: 2026-03-05 08:08:34 Duration: 4m4s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 2m31s 4m16s 3m25s 4 13m43s create index i_log_ehcache_server_id on public.gtp_log_ehcache using btree (server_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 02 09 1 3m26s 3m26s Mar 03 09 1 2m31s 2m31s Mar 04 09 1 3m27s 3m27s Mar 05 09 1 4m16s 4m16s [ User: a3dsupervisor - Total duration: 13m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 13m43s - Times executed: 4 ]
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-05 08:12:51 Duration: 4m16s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-04 08:04:42 Duration: 3m27s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (server_id);
Date: 2026-03-02 08:08:38 Duration: 3m26s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 2m23s 2m23s 2m23s 1 2m23s alter table only public.gtp_history_obj_compo;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 03 09 1 2m23s 2m23s [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 2m23s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo;
Date: 2026-03-03 08:39:15 Duration: 2m23s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m23s 2m42s 2m1s 4 8m4s 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) from stdin;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 02 08 1 1m23s 1m23s Mar 03 09 1 2m42s 2m42s Mar 04 08 1 1m58s 1m58s Mar 05 09 1 2m 2m [ User: a3dsupervisor - Total duration: 8m4s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m4s - 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) FROM stdin;
Date: 2026-03-03 08:16:25 Duration: 2m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:04:29 Duration: 2m Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:23 Duration: 1m58s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m21s 2m31s 1m57s 4 7m48s alter table only public.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 09 1 2m13s 2m13s Mar 03 09 1 1m42s 1m42s Mar 04 09 1 2m31s 2m31s Mar 05 09 1 1m21s 1m21s [ User: a3dsupervisor - Total duration: 7m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m48s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-04 08:07:14 Duration: 2m31s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-02 08:10:51 Duration: 2m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-03-03 08:24:34 Duration: 1m42s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 7s894ms 2m32s 1m18s 4 5m12s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 02 09 1 1m1s 1m1s Mar 03 09 1 2m32s 2m32s Mar 04 09 1 1m30s 1m30s Mar 05 09 1 7s894ms 7s894ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-03 08:28:18 Duration: 2m32s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-04 08:06:34 Duration: 1m30s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-03-02 08:11:30 Duration: 1m1s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 35s792ms 1m13s 48s86ms 4 3m12s 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) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 02 08 1 35s792ms 35s792ms Mar 03 09 1 1m13s 1m13s Mar 04 08 1 38s94ms 38s94ms Mar 05 09 1 44s790ms 44s790ms [ User: a3dsupervisor - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m12s - 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) FROM stdin;
Date: 2026-03-03 08:15:26 Duration: 1m13s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:03:45 Duration: 44s790ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:55:28 Duration: 38s94ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 10s879ms 1m57s 47s847ms 4 3m11s create index i_fk_gtp_obj_compo_history_new_unit on public.gtp_history_obj_compo using btree (obj_compo_new_unit_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 02 09 1 52s240ms 52s240ms Mar 03 09 1 1m57s 1m57s Mar 04 08 1 11s229ms 11s229ms Mar 05 09 1 10s879ms 10s879ms [ User: a3dsupervisor - Total duration: 3m11s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m11s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-03 08:17:23 Duration: 1m57s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-02 08:00:30 Duration: 52s240ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (obj_compo_new_unit_num_id);
Date: 2026-03-04 07:55:40 Duration: 11s229ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5s139ms 2m17s 46s943ms 4 3m7s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 02 09 1 39s643ms 39s643ms Mar 03 09 1 2m17s 2m17s Mar 04 09 1 5s139ms 5s139ms Mar 05 09 1 5s335ms 5s335ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-03 08:28:05 Duration: 2m17s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-02 08:11:30 Duration: 39s643ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-03-05 08:14:54 Duration: 5s335ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 10s991ms 1m8s 36s803ms 4 2m27s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 02 09 1 1m8s 1m8s Mar 03 09 1 56s419ms 56s419ms Mar 04 08 1 10s991ms 10s991ms Mar 05 09 1 11s205ms 11s205ms [ User: a3dsupervisor - Total duration: 2m27s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m27s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-02 08:09:46 Duration: 1m8s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-03 08:24:19 Duration: 56s419ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2026-03-05 08:04:07 Duration: 11s205ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5s236ms 1m53s 35s465ms 4 2m21s create index i_fk_gtp_obj_compo_unit on public.gtp_obj_composition using btree (obj_compo_unit_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 02 09 1 5s236ms 5s236ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 9s452ms 9s452ms Mar 05 09 1 13s426ms 13s426ms [ User: a3dsupervisor - Total duration: 2m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-03 08:31:27 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-05 08:16:42 Duration: 13s426ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_unit ON public.gtp_obj_composition USING btree (obj_compo_unit_num_id);
Date: 2026-03-04 08:08:30 Duration: 9s452ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4s891ms 1m53s 34s893ms 4 2m19s create index i_fk_gtp_obj_compo_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 02 09 1 4s891ms 4s891ms Mar 03 09 1 1m53s 1m53s Mar 04 09 1 7s434ms 7s434ms Mar 05 09 1 13s687ms 13s687ms [ User: a3dsupervisor - Total duration: 2m19s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m19s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-03 08:31:26 Duration: 1m53s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-05 08:16:42 Duration: 13s687ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab);
Date: 2026-03-04 08:08:21 Duration: 7s434ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 20s44ms 1m6s 33s442ms 4 2m13s create index i_gtp_obj_compo_value_compo_id on public.gtp_obj_composition using btree (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 09 1 20s44ms 20s44ms Mar 03 09 1 21s688ms 21s688ms Mar 04 09 1 1m6s 1m6s Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m13s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-04 08:08:32 Duration: 1m6s Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-05 08:17:23 Duration: 25s440ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (obj_compo_value, att_template_num_id, att_template_category_num_id, obj_num_id);
Date: 2026-03-03 08:31:59 Duration: 21s688ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 8s744ms 50s294ms 31s956ms 4 2m7s create index i_gtp_obj_compo_value_case on public.gtp_obj_composition using btree (public.touppernoaccent ((obj_compo_value)::text));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 02 09 1 48s21ms 48s21ms Mar 03 09 1 50s294ms 50s294ms Mar 04 09 1 8s744ms 8s744ms Mar 05 09 1 20s765ms 20s765ms [ User: a3dsupervisor - Total duration: 2m7s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m7s - Times executed: 4 ]
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-03 08:23:22 Duration: 50s294ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-02 08:08:29 Duration: 48s21ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (public.touppernoaccent ((obj_compo_value)::text));
Date: 2026-03-05 08:17:14 Duration: 20s765ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 15s53ms 43s944ms 29s309ms 4 1m57s create index i_fk_gtp_obj_compo_ligne_tab on public.gtp_obj_composition using btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 02 09 1 43s944ms 43s944ms Mar 03 09 1 31s536ms 31s536ms Mar 04 09 1 26s704ms 26s704ms Mar 05 09 1 15s53ms 15s53ms [ User: a3dsupervisor - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m57s - Times executed: 4 ]
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-02 08:13:06 Duration: 43s944ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-03 08:25:43 Duration: 31s536ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (obj_compo_num_id_tab, obj_compo_ligne_tab_num_id);
Date: 2026-03-04 08:08:07 Duration: 26s704ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 25s440ms 34s28ms 28s613ms 4 1m54s 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) from stdin;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 02 09 1 28s8ms 28s8ms Mar 03 09 1 34s28ms 34s28ms Mar 04 08 1 26s977ms 26s977ms Mar 05 09 1 25s440ms 25s440ms [ User: a3dsupervisor - Total duration: 1m54s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m54s - 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) FROM stdin;
Date: 2026-03-03 08:25:45 Duration: 34s28ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-02 08:10:29 Duration: 28s8ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-04 07:56:44 Duration: 26s977ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 17s76ms 38s66ms 27s849ms 4 1m51s 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) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 02 09 1 17s76ms 17s76ms Mar 03 09 1 24s584ms 24s584ms Mar 04 09 1 38s66ms 38s66ms Mar 05 09 1 31s670ms 31s670ms [ User: a3dsupervisor - Total duration: 1m51s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m51s - 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) FROM stdin;
Date: 2026-03-04 08:04:41 Duration: 38s66ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-05 08:09:22 Duration: 31s670ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
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) FROM stdin;
Date: 2026-03-03 08:21:15 Duration: 24s584ms Database: reftkbim User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 2,245 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 11 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 2 Max number of times the same event was reported
- 11 Total events found
Rank Times reported Error 1 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msCREATE TRIGGER t_bef_ins_er_gtp_obj_compo BEFORE INSERT ON public.gtp_obj_composition FOR EACH ROW EXECUTE FUNCTION public.trigger_fct_t_bef_ins_er_gtp_obj_compo()
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 02 09 1 Mar 03 09 1 2 2 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 02 09 1 Mar 04 09 1 3 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_dep_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 05 09 1 4 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_cw_eng_obj_id ON public.gtp_cw_eng_history USING btree (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 04 09 1 5 1 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msCREATE STATISTICS public.stat_mcv_obj_compo_att (...) ON att_template_category_num_id, att_template_num_id FROM public.gtp_obj_composition
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 05 09 1 6 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_action
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 02 09 1 7 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (...)
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 04 09 1 8 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msVACUUM FULL
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 02 10 1 9 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msCREATE TRIGGER t_bef_upd_er_gtp_obj_compo BEFORE UPDATE ON public.gtp_obj_composition FOR EACH ROW EXECUTE FUNCTION public.trigger_fct_t_bef_upd_er_gtp_obj_compo()
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 04 09 1