pgBadger-
Global information
- Generated on Mon Mar 2 09:31:16 2026
- Log file: ././A3D-RND-PIC/y=2026/m=02/d=28/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2026/m=02/d=28/h=23/m=00/PT1H.log
- Parsed 200,350 log entries in 1m2s
- Log start from 2026-02-22 12:58:07 to 2026-02-28 18:00:46
-
Overview
Global Stats
- 121 Number of unique normalized queries
- 310 Number of queries
- 5h45m40s Total query duration
- 2026-02-23 07:58:31 First query
- 2026-02-28 01:00:53 Last query
- 2 queries/s at 2026-02-26 08:25:04 Query peak
- 5h45m40s Total query duration
- 3s952ms Prepare/parse total duration
- 4s902ms Bind total duration
- 5h45m31s Execute total duration
- 97,322 Number of events
- 51 Number of unique normalized events
- 97,153 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
- 512 Number temporary file
- 2.01 GiB Max size of temporary file
- 54.32 MiB Average size of temporary file
- 1,462 Total number of sessions
- 36 sessions at 2026-02-27 09:47:44 Session peak
- 8d16h43m50s Total duration of sessions
- 8m33s Average duration of sessions
- 0 Average queries per session
- 14s186ms Average queries duration per session
- 8m19s Average idle time per session
- 1,462 Total number of connections
- 9 connections/s at 2026-02-27 09:47:35 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 2 queries/s Query Peak
- 2026-02-26 08:25:04 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2026-02-24 08:33:21 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 2 queries/s Query Peak
- 2026-02-26 08:25:04 Date
Queries duration
Key values
- 5h45m40s 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) Feb 22 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 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 Feb 23 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 1m39s 1m39s 0ms 0ms 1m39s 08 59 0ms 10m12s 54s700ms 3m21s 4m53s 12m43s 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 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Feb 24 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 2 0ms 1m42s 1m42s 1m42s 1m42s 1m42s 08 54 0ms 9m12s 50s91ms 2m58s 4m12s 10m20s 09 1 0ms 3s506ms 3s506ms 3s506ms 3s506ms 3s506ms 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 Feb 25 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 3 0ms 1m46s 1m31s 1m43s 1m46s 1m46s 08 52 0ms 7m5s 53s9ms 3m31s 3m54s 8m7s 09 2 0ms 24m11s 12m14s 17s141ms 24m11s 24m11s 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 Feb 26 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 4 0ms 1m58s 1m26s 1m43s 1m58s 1m58s 08 58 0ms 7m3s 49s539ms 3m19s 4m3s 8m7s 09 2 0ms 24m40s 12m29s 18s124ms 24m40s 24m40s 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 Feb 27 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 4s288ms 4s288ms 4s288ms 4s288ms 4s288ms 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 59 0ms 8m43s 1m 4m19s 4m45s 9m26s 09 2 0ms 27m19s 13m49s 18s901ms 27m19s 27m19s 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 3 0ms 3s701ms 3s441ms 3s80ms 3s542ms 3s701ms 13 5 0ms 5s563ms 4s189ms 6s425ms 9s25ms 9s25ms 14 1 0ms 31s835ms 31s835ms 0ms 0ms 31s835ms 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 Feb 28 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 1 0ms 4s127ms 4s127ms 4s127ms 4s127ms 4s127ms 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) Feb 22 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 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 Feb 23 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 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 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Feb 24 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 1 0 4s750ms 0ms 0ms 4s750ms 09 1 0 3s506ms 0ms 3s506ms 3s506ms 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 Feb 25 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Feb 26 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 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 Feb 27 00 0 0 0ms 0ms 0ms 0ms 01 1 0 4s288ms 0ms 4s288ms 4s288ms 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 Feb 28 00 0 0 0ms 0ms 0ms 0ms 01 1 0 4s127ms 0ms 4s127ms 4s127ms 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) Feb 22 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 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 Feb 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 1 1m39s 0ms 0ms 1m39s 08 0 0 0 9 1m31s 0ms 0ms 40s853ms 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 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 Feb 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 1 1m42s 0ms 0ms 1m42s 08 0 0 0 9 1m21s 0ms 0ms 1m12s 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 Feb 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 1 1m43s 0ms 0ms 1m43s 08 0 0 0 7 1m28s 0ms 0ms 1m20s 09 0 0 1 0 17s141ms 0ms 0ms 17s141ms 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 Feb 26 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 1 1m43s 0ms 0ms 1m43s 08 0 0 0 9 1m10s 0ms 0ms 1m13s 09 0 0 1 0 18s124ms 0ms 0ms 18s124ms 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 Feb 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 10 1m23s 0ms 0ms 1m42s 09 0 0 1 0 18s901ms 0ms 0ms 18s901ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 1 0 0 0 3s701ms 0ms 0ms 3s701ms 13 1 1 1 0 4s16ms 0ms 0ms 5s563ms 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 Feb 28 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 Feb 22 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 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% Feb 23 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 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% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Feb 24 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 1 0 0.00 100.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% Feb 25 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.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% Feb 26 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 1 1.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% Feb 27 00 0 0 0.00 0.00% 01 0 1 1.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 1 1.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 3 3.00 0.00% 13 0 5 5.00 0.00% 14 0 1 1.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% Feb 28 00 0 0 0.00 0.00% 01 0 1 1.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 Feb 22 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 7 0.00/s 13 34 0.01/s 14 37 0.01/s 15 29 0.01/s 16 21 0.01/s 17 26 0.01/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 Feb 23 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 39 0.01/s 07 22 0.01/s 08 2 0.00/s 09 3 0.00/s 10 3 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 4 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Feb 24 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 9 0.00/s 08 3 0.00/s 09 3 0.00/s 10 7 0.00/s 11 2 0.00/s 12 3 0.00/s 13 2 0.00/s 14 6 0.00/s 15 3 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 Feb 25 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 14 0.00/s 08 4 0.00/s 09 47 0.01/s 10 19 0.01/s 11 9 0.00/s 12 22 0.01/s 13 18 0.01/s 14 15 0.00/s 15 17 0.00/s 16 6 0.00/s 17 12 0.00/s 18 7 0.00/s 19 6 0.00/s 20 10 0.00/s 21 9 0.00/s 22 6 0.00/s 23 6 0.00/s Feb 26 00 5 0.00/s 01 3 0.00/s 02 9 0.00/s 03 5 0.00/s 04 6 0.00/s 05 10 0.00/s 06 4 0.00/s 07 8 0.00/s 08 2 0.00/s 09 51 0.01/s 10 4 0.00/s 11 15 0.00/s 12 13 0.00/s 13 18 0.01/s 14 18 0.01/s 15 19 0.01/s 16 11 0.00/s 17 22 0.01/s 18 17 0.00/s 19 6 0.00/s 20 5 0.00/s 21 3 0.00/s 22 6 0.00/s 23 3 0.00/s Feb 27 00 2 0.00/s 01 5 0.00/s 02 5 0.00/s 03 2 0.00/s 04 5 0.00/s 05 6 0.00/s 06 5 0.00/s 07 7 0.00/s 08 2 0.00/s 09 35 0.01/s 10 7 0.00/s 11 14 0.00/s 12 23 0.01/s 13 21 0.01/s 14 35 0.01/s 15 24 0.01/s 16 15 0.00/s 17 13 0.00/s 18 14 0.00/s 19 16 0.00/s 20 21 0.01/s 21 15 0.00/s 22 13 0.00/s 23 20 0.01/s Feb 28 00 20 0.01/s 01 5 0.00/s 02 17 0.00/s 03 9 0.00/s 04 14 0.00/s 05 19 0.01/s 06 6 0.00/s 07 14 0.00/s 08 9 0.00/s 09 21 0.01/s 10 15 0.00/s 11 18 0.01/s 12 9 0.00/s 13 25 0.01/s 14 16 0.00/s 15 13 0.00/s 16 10 0.00/s 17 16 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 Feb 22 00 2 52ms 52ms 01 2 54ms 54ms 02 2 57ms 57ms 03 2 54ms 54ms 04 2 60ms 60ms 05 2 54ms 54ms 06 2 57ms 57ms 07 2 58ms 58ms 08 2 57ms 57ms 09 2 55ms 55ms 10 2 55ms 55ms 11 2 69ms 69ms 12 4 44s693ms 44s693ms 13 34 1m53s 1m53s 14 38 1m49s 1m49s 15 26 1m16s 1m16s 16 24 1m21s 1m21s 17 28 22m29s 22m29s 18 2 56ms 56ms 19 2 52ms 52ms 20 2 60ms 60ms 21 2 54ms 54ms 22 2 51ms 51ms 23 2 59ms 59ms Feb 23 00 2 54ms 54ms 01 2 56ms 56ms 02 2 62ms 62ms 03 2 55ms 55ms 04 2 51ms 51ms 05 2 59ms 59ms 06 34 1m41s 1m41s 07 25 7m2s 6m58s 08 2 168ms 0ms 09 5 32m21s 32m21s 10 3 82ms 82ms 11 2 90ms 90ms 12 2 58ms 58ms 13 2 58ms 58ms 14 4 339ms 339ms 15 2 70ms 70ms 16 2 56ms 56ms 17 2 58ms 58ms 18 2 61ms 61ms 19 2 59ms 59ms 21 2 58ms 58ms 22 2 56ms 56ms 23 2 55ms 55ms Feb 24 00 2 55ms 55ms 01 2 56ms 56ms 02 2 59ms 59ms 03 2 63ms 63ms 04 2 52ms 52ms 05 2 54ms 54ms 06 2 55ms 55ms 07 7 1s683ms 0ms 08 3 1s417ms 0ms 09 5 29m28s 29m27s 10 7 118ms 118ms 11 2 58ms 58ms 12 3 242ms 242ms 13 2 57ms 57ms 14 6 178ms 178ms 15 3 69ms 69ms 16 2 56ms 56ms 17 2 58ms 58ms 18 2 68ms 68ms 19 2 54ms 54ms 20 2 53ms 53ms 21 2 54ms 54ms 22 2 54ms 54ms 23 2 55ms 55ms Feb 25 00 2 57ms 57ms 01 2 67ms 67ms 02 2 55ms 55ms 03 2 58ms 58ms 04 2 54ms 54ms 05 2 58ms 58ms 06 2 55ms 55ms 07 12 9m3s 8m40s 08 4 6s712ms 0ms 09 47 4m14s 3m43s 10 19 38s563ms 38s563ms 11 9 1m6s 1m6s 12 22 1m17s 1m17s 13 15 25s495ms 25s495ms 14 15 1m4s 1m4s 15 20 19m7s 19m7s 16 6 57s423ms 57s423ms 17 12 1m 1m 18 7 2h24m30s 2h24m30s 19 6 59s285ms 59s285ms 20 10 1m14s 1m14s 21 9 1m4s 1m4s 22 6 54s653ms 54s653ms 23 6 56s282ms 56s282ms Feb 26 00 5 37s181ms 37s181ms 01 3 39s366ms 39s366ms 02 9 1m11s 1m11s 03 5 41s620ms 41s620ms 04 6 49s730ms 49s730ms 05 9 1m6s 1m6s 06 5 41s75ms 41s75ms 07 8 3h16m6s 3h15m23s 08 2 365ms 0ms 09 51 3m51s 3m21s 10 4 10m59s 10m59s 11 15 4m6s 4m6s 12 13 9m39s 9m39s 13 18 4m 4m 14 18 3m32s 3m32s 15 19 4m18s 4m18s 16 11 1m6s 1m6s 17 22 1m7s 1m7s 18 17 40m20s 40m20s 19 6 48s914ms 48s914ms 20 5 46s755ms 46s755ms 21 3 28s954ms 28s954ms 22 6 45s984ms 45s984ms 23 3 1h25m53s 1h25m53s Feb 27 00 2 59ms 59ms 01 5 23m1s 23m 02 5 42s202ms 42s202ms 03 2 53ms 53ms 04 5 50s778ms 50s778ms 05 6 46s861ms 46s861ms 06 5 53s521ms 53s521ms 07 7 2h45m11s 2h45m11s 08 2 1s793ms 0ms 09 35 5m49s 5m1s 10 7 34s733ms 34s733ms 11 13 12m36s 12m36s 12 24 1m19s 1m19s 13 21 54s62ms 53s64ms 14 32 41s123ms 40s128ms 15 27 8m55s 8m55s 16 13 43s663ms 43s663ms 17 15 1m8s 1m8s 18 14 59m36s 59m36s 19 16 1m2s 1m2s 20 21 1m11s 1m11s 21 15 1m10s 1m10s 22 13 1m4s 1m4s 23 20 1m5s 1m5s Feb 28 00 20 1m13s 1m13s 01 5 58s853ms 58s27ms 02 17 1m14s 1m14s 03 9 1m3s 1m3s 04 14 1m20s 1m20s 05 19 1m8s 1m8s 06 6 54s662ms 54s662ms 07 14 1m10s 1m10s 08 9 58s350ms 58s350ms 09 21 1m9s 1m9s 10 15 1m7s 1m7s 11 18 1m9s 1m9s 12 9 1m3s 1m3s 13 25 1m11s 1m11s 14 16 1m10s 1m10s 15 13 1m12s 1m12s 16 10 58s467ms 58s467ms 17 16 1m7s 1m7s 18 4 11h50m52s 11h50m52s 19 2 54ms 54ms 20 2 52ms 52ms 21 2 54ms 54ms 22 2 60ms 60ms 23 2 52ms 52ms -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-02-27 09:47:35 Date
Connections per database
Key values
- cnrs Main Database
- 1,462 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 1,462 connections Total
-
Sessions
Simultaneous sessions
Key values
- 36 sessions Session Peak
- 2026-02-27 09:47:44 Date
Histogram of session times
Key values
- 875 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 1,462 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 1,462 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 1,462 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 1,462 sessions Total
Application Count Total Duration Average Duration DBeaver 25.2.0 - Main 'cnrs' 3 2h38m43s 52m54s DBeaver 25.2.0 - Metadata 'cnrs' 2 2h37m16s 1h18m38s DBeaver 25.2.0 - Read PostgreSQL database list 3 941ms 313ms DBeaver 25.2.0 - SQLEditor 'Script-42.sql' 2 2h36m41s 1h18m20s DBeaver 25.3.5 - Main 'cnrs' 1 1h11m36s 1h11m36s DBeaver 25.3.5 - Metadata 'cnrs' 1 1h11m36s 1h11m36s DBeaver 25.3.5 - SQLEditor 'Script-13.sql' 1 1h11m16s 1h11m16s PostgreSQL JDBC Driver 985 7d15h2m46s 11m9s [unknown] 425 1m49s 257ms pg_restore 20 12h55m48s 38m47s psql 19 1h16m14s 4m -
Temporary Files
Size of temporary files
Key values
- 714.08 MiB Temp Files size Peak
- 2026-02-23 08:12:27 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2026-02-23 08:30:25 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Feb 22 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Feb 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 125 5.95 GiB 48.77 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Feb 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 2 274.66 MiB 137.33 MiB 08 97 4.51 GiB 47.56 MiB 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Feb 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 4 549.32 MiB 137.33 MiB 08 74 4.80 GiB 66.44 MiB 09 1 3.66 MiB 3.66 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 Feb 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 6 823.97 MiB 137.33 MiB 08 97 4.62 GiB 48.76 MiB 09 1 3.66 MiB 3.66 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 Feb 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 102 5.65 GiB 56.72 MiB 09 1 3.66 MiB 3.66 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 2 10.73 MiB 5.37 MiB 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 Feb 28 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 10 1.19 GiB 77.73 MiB 398.48 MiB 121.73 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-02-27 08:29:43 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 10 73.51 MiB 2.45 MiB 17.91 MiB 7.35 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-02-27 08:31:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 9 1.26 GiB 47.01 MiB 352.38 MiB 143.09 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-02-27 08:14:14 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 9 8.58 GiB 135.45 MiB 2.01 GiB 976.56 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-02-27 08:02:48 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 8 541.74 MiB 1.97 MiB 292.29 MiB 67.72 MiB add constraint pk_history_obj_old_qsp primary key (history_old_qsp_id);-
ADD CONSTRAINT pk_history_obj_old_qsp PRIMARY KEY (history_old_qsp_id);
Date: 2026-02-27 08:31:44 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 8 2.51 GiB 6.16 MiB 685.82 MiB 321.37 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-02-27 08:17:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 8 602.59 MiB 25.73 MiB 418.66 MiB 75.32 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-02-27 08:27:46 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 8 1.08 GiB 2.31 MiB 595.86 MiB 138.44 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-02-27 08:31:53 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 7 2.08 GiB 70.67 MiB 497.09 MiB 304.16 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-02-27 08:20:34 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 7 485.95 MiB 16.48 MiB 274.63 MiB 69.42 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-02-26 08:06:07 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 6 408.58 MiB 1.98 MiB 169.47 MiB 68.10 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-02-27 08:31:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 6 2.79 GiB 341.17 MiB 714.02 MiB 476.03 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-02-27 08:17:15 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6 516.56 MiB 24.21 MiB 182.18 MiB 86.09 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-02-25 08:07:43 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 120.45 MiB 3.16 MiB 82.48 MiB 24.09 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-02-27 08:32:59 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 49.18 MiB 3.21 MiB 26.00 MiB 12.29 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-02-26 08:06:03 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4 205.64 MiB 47.23 MiB 55.53 MiB 51.41 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-02-23 08:31:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 4.12 MiB 1.95 MiB 2.17 MiB 2.06 MiB add constraint fk_gtp_obj_rel_vt_objt foreign key (obj_template_num_id) references public.gtp_obj_template (obj_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_objt FOREIGN KEY (obj_template_num_id) REFERENCES public.gtp_obj_template (obj_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-26 08:05:48 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 20.75 MiB 2.21 MiB 18.54 MiB 10.38 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2026-02-26 08:05:42 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 561.39 MiB 561.39 MiB 561.39 MiB 561.39 MiB add constraint fk_gtp_obj_compo_creator foreign key (obj_compo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_creator FOREIGN KEY (obj_compo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:20:44 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 218.63 MiB 218.63 MiB 218.63 MiB 218.63 MiB add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:11:40 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 13.80 MiB 13.80 MiB 13.80 MiB 13.80 MiB add constraint fk_hist_obj_link_unlink_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_hist_obj_link_unlink_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-25 08:24:23 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 763.98 MiB 763.98 MiB 763.98 MiB 763.98 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-02-27 08:26:14 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 102.64 MiB 102.64 MiB 102.64 MiB 102.64 MiB add constraint fk_history_obj_concerned_act 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_concerned_act FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:31:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 8.87 MiB 8.87 MiB 8.87 MiB 8.87 MiB add constraint fk_gtp_obj_compo_category foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_category FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:15:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 11.55 MiB 11.55 MiB 11.55 MiB 11.55 MiB add constraint fk_gtp_obj_compo_template foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:12:23 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
26 1 333.60 MiB 333.60 MiB 333.60 MiB 333.60 MiB add constraint pk_eng_gtp_datalink_objdid primary key (obj_num_id, eng_data_id);-
ADD CONSTRAINT pk_eng_gtp_datalink_objdid PRIMARY KEY (obj_num_id, eng_data_id);
Date: 2026-02-23 08:11:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
27 1 5.37 MiB 5.37 MiB 5.37 MiB 5.37 MiB declare l_script_name constant text := ?; cursel cursor for select distinct ga.obj_compo_num_id, ga.obj_num_id, ga.obj_compo_value from gtp_obj_composition ga inner join gtp_att_template gat on (ga.att_template_num_id = gat.att_template_num_id) inner join ged_document ge on (ga.obj_compo_value = to_char(ge.document_num_id)) left join gtp_obj_composition tab on (tab.obj_compo_num_id = ga.obj_compo_num_id_tab) where gat.att_template_domain_code = ?; ccomponumid bigint; cobjid bigint; coldgedid varchar(?); cnewgedid bigint; begin insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); raise debug ?, l_script_name; open cursel; loop fetch next from "..." into ccomponumid, cobjid, coldgedid; exit when not found; select gd.document_num_id into cnewgedid from ged_document gd inner join ged_document gei on (gei.node_num_id = gd.node_num_id) where gd.document_num_id_version is null and gei.document_num_id = coldgedid; update gtp_obj_composition set obj_compo_value = to_char(cnewgedid) where obj_compo_num_id = ccomponumid and obj_num_id = cobjid; end loop; close "..." raise notice ?, l_script_name; update a3d_migration_tracking set validated = ? where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); exception when others then call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); call pack_gtp_utils.p_trace_error (? || l_script_name, sqlerrm, ?); raise; end $body$;-
DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE = TO_CHAR(ge.document_num_id)) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(100); cNewGedId bigint; BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0_OCL'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0_OCL'); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT gd.document_num_id INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = TO_CHAR(cNewGedId) WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0_OCL'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0_OCL'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0_OCL'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0_OCL'); RAISE; END $body$;
Date: 2026-02-27 14:24:15 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 25.3.5 - SQLEditor 'Script-13.sql'
28 1 5.37 MiB 5.37 MiB 5.37 MiB 5.37 MiB do $body$ declare l_script_name constant text := ?; cursel cursor for select distinct ga.obj_compo_num_id, ga.obj_num_id, ga.obj_compo_value from gtp_obj_composition ga inner join gtp_att_template gat on (ga.att_template_num_id = gat.att_template_num_id) inner join ged_document ge on (ga.obj_compo_value = to_char(ge.document_num_id)) left join gtp_obj_composition tab on (tab.obj_compo_num_id = ga.obj_compo_num_id_tab) where gat.att_template_domain_code = ?; ccomponumid bigint; cobjid bigint; coldgedid varchar(?); cnewgedid varchar(?); begin insert into a3d_migration_tracking (type, name, release) values (?, l_script_name, ?); call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); raise debug ?, l_script_name; open cursel; loop fetch next from "..." into ccomponumid, cobjid, coldgedid; exit when not found; select to_char(gd.document_num_id) into cnewgedid from ged_document gd inner join ged_document gei on (gei.node_num_id = gd.node_num_id) where gd.document_num_id_version is null and gei.document_num_id = coldgedid; update gtp_obj_composition set obj_compo_value = cnewgedid where obj_compo_num_id = ccomponumid and obj_num_id = cobjid; end loop; close "..." raise notice ?, l_script_name; update a3d_migration_tracking set validated = ? where type = ? and name = l_script_name and release = ?; call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); exception when others then call pack_gtp_utils.p_trace_log_post_install (l_script_name || ?, ?); call pack_gtp_utils.p_trace_error (? || l_script_name, sqlerrm, ?); raise; end $body$;-
DO $body$ DECLARE L_SCRIPT_NAME CONSTANT text := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID, ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (ga.att_template_num_id = gat.att_template_num_id) INNER JOIN GED_DOCUMENT ge ON (ga.OBJ_COMPO_VALUE = TO_CHAR(ge.document_num_id)) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (tab.OBJ_COMPO_NUM_ID = ga.obj_compo_num_id_tab) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId varchar(100); cNewGedId varchar(100); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (TYPE, NAME, RELEASE) VALUES ('postInstallation', L_SCRIPT_NAME, '7.23.0.0_OCL'); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [START]', '7.23.0.0_OCL'); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT TO_CHAR(gd.document_num_id) INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (gei.node_num_id = gd.node_num_id) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0_OCL'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [SUCCESS]', '7.23.0.0_OCL'); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL (L_SCRIPT_NAME || ' [ERROR]', '7.23.0.0_OCL'); CALL PACK_GTP_UTILS.P_TRACE_ERROR ('POST_INSTALL ' || L_SCRIPT_NAME, SQLERRM, '7.23.0.0_OCL'); RAISE; END $body$;
Date: 2026-02-27 14:35:14 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: DBeaver 25.3.5 - SQLEditor 'Script-13.sql'
29 1 317.20 MiB 317.20 MiB 317.20 MiB 317.20 MiB add constraint fk_relation_creator foreign key (relation_creator) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_relation_creator FOREIGN KEY (relation_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:15:27 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 2.01 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-23 08:00:10 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 2.01 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-27 08:02:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1.74 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-24 08:00:54 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.21 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-25 08:00:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 1.07 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-26 08:00:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 763.98 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;[ Date: 2026-02-27 08:26:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 714.02 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-02-25 08:11:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 714.02 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-02-27 08:17:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 685.82 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2026-02-25 08:10:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 595.86 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-02-24 08:17:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 561.39 MiB ADD CONSTRAINT fk_gtp_obj_compo_creator FOREIGN KEY (obj_compo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-02-24 08:20:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 531.80 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2026-02-27 08:17:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 497.09 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-02-23 08:22:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 496.86 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-02-27 08:20:34 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 495.91 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-02-26 08:14:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 464.73 MiB ADD CONSTRAINT pk_gtp_cw_eng_histo PRIMARY KEY (history_num_id);[ Date: 2026-02-23 08:18:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 444.02 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2026-02-26 08:12:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 425.79 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2026-02-25 08:16:54 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 418.66 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2026-02-23 08:18:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 398.48 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2026-02-25 08:20:46 - Database: cnrs - 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 Feb 22 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Feb 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 21 0 0 22 0 0 23 0 0 Feb 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Feb 25 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Feb 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Feb 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Feb 28 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
- ExclusiveLock Main Lock Type
- 50 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 4 31s239ms 7s809ms relation 4 31s239ms 7s809ms ExclusiveLock 38 1m17s 2s48ms extension 38 1m17s 2s48ms ShareLock 3 8s946ms 2s982ms relation 3 8s946ms 2s982ms ShareRowExclusiveLock 3 16s9ms 5s336ms relation 3 16s9ms 5s336ms ShareUpdateExclusiveLock 2 59s852ms 29s926ms relation 2 59s852ms 29s926ms Total 50 3m13s 3s877ms 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
- 4 Total read queries
- 302 Total write queries
Queries by database
Key values
- cnrs Main database
- 310 Requests
- 5h45m31s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 311 Requests
User Request type Count Duration a3dsupervisor Total 311 5h45m35s copy from 48 1h7m32s ddl 243 3h19m33s delete 4 57s629ms insert 2 6s725ms others 4 1h16m43s select 5 20s800ms tcl 4 15s522ms update 1 5s563ms Duration by user
Key values
- 5h45m35s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 311 5h45m35s copy from 48 1h7m32s ddl 243 3h19m33s delete 4 57s629ms insert 2 6s725ms others 4 1h16m43s select 5 20s800ms tcl 4 15s522ms update 1 5s563ms Queries by host
Key values
- 10.3.0.4 Main host
- 311 Requests
- 5h45m35s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 293 Requests
- 4h27m14s (pg_restore)
- Main time consuming application
Application Request type Count Duration DBeaver 25.3.5 - SQLEditor 'Script-13.sql' Total 1 31s835ms others 1 31s835ms PostgreSQL JDBC Driver Total 13 1m33s delete 4 57s629ms insert 2 6s725ms select 2 8s416ms tcl 4 15s522ms update 1 5s563ms pg_restore Total 293 4h27m14s copy from 48 1h7m32s ddl 243 3h19m33s select 2 8s257ms psql Total 3 1h16m11s others 3 1h16m11s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-02-22 14:16:07 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 242 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 27m19s VACUUM ANALYSE;[ Date: 2026-02-27 09:46:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 24m40s VACUUM ANALYSE;[ Date: 2026-02-26 09:34:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 24m11s VACUUM ANALYSE;[ Date: 2026-02-25 09:36:11 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 10m12s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;[ Date: 2026-02-23 08:07:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 9m12s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;[ Date: 2026-02-24 08:05:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 8m43s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;[ Date: 2026-02-27 08:08:02 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 7m5s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;[ Date: 2026-02-25 08:01:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 7m3s COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;[ Date: 2026-02-26 08:01:13 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 4m39s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2026-02-23 08:12:27 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 4m30s ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-27 08:34:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 3m40s CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);[ Date: 2026-02-26 08:05:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 3m31s CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);[ Date: 2026-02-27 08:11:27 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 3m19s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2026-02-26 08:11:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 3m18s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-24 08:10:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 3m13s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2026-02-27 08:17:16 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 3m2s CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);[ Date: 2026-02-25 08:05:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 2m56s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2026-02-25 08:11:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 2m53s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2026-02-23 08:15:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 2m46s CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);[ Date: 2026-02-23 08:11:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 2m45s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2026-02-25 08:08:04 - Database: cnrs - 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 1h16m11s 3 24m11s 27m19s 25m23s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 25 10 1 24m11s 24m11s Feb 26 10 1 24m40s 24m40s Feb 27 10 1 27m19s 27m19s [ User: a3dsupervisor - Total duration: 1h16m11s - Times executed: 3 ]
[ Application: psql - Total duration: 1h16m11s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2026-02-27 09:46:55 Duration: 27m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-02-26 09:34:58 Duration: 24m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-02-25 09:36:11 Duration: 24m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 42m18s 5 7m3s 10m12s 8m27s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 23 09 1 10m12s 10m12s Feb 24 09 1 9m12s 9m12s Feb 25 09 1 7m5s 7m5s Feb 26 09 1 7m3s 7m3s Feb 27 09 1 8m43s 8m43s [ User: a3dsupervisor - Total duration: 42m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 42m18s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-23 08:07:04 Duration: 10m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-24 08:05:45 Duration: 9m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-27 08:08:02 Duration: 8m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 14m9s 4 2m56s 4m39s 3m32s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 23 09 1 4m39s 4m39s Feb 25 09 1 2m56s 2m56s Feb 26 09 1 3m19s 3m19s Feb 27 09 1 3m13s 3m13s [ User: a3dsupervisor - Total duration: 14m9s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 14m9s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-23 08:12:27 Duration: 4m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-26 08:11:48 Duration: 3m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-27 08:17:16 Duration: 3m13s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 13m10s 5 1m3s 3m40s 2m38s create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 23 09 1 1m3s 1m3s Feb 24 09 1 1m52s 1m52s Feb 25 09 1 3m2s 3m2s Feb 26 09 1 3m40s 3m40s Feb 27 09 1 3m31s 3m31s [ User: a3dsupervisor - Total duration: 13m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 13m10s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-26 08:05:58 Duration: 3m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-27 08:11:27 Duration: 3m31s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-25 08:05:18 Duration: 3m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 12m51s 5 1m42s 3m18s 2m34s alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 23 09 1 1m42s 1m42s Feb 24 09 1 3m18s 3m18s Feb 25 09 1 2m45s 2m45s Feb 26 09 1 2m30s 2m30s Feb 27 09 1 2m34s 2m34s [ User: a3dsupervisor - Total duration: 12m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 12m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-24 08:10:15 Duration: 3m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-25 08:08:04 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-27 08:14:02 Duration: 2m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 10m28s 5 1m47s 2m29s 2m5s alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 23 09 1 2m1s 2m1s Feb 24 09 1 2m1s 2m1s Feb 25 09 1 2m7s 2m7s Feb 26 09 1 2m29s 2m29s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-26 08:12:28 Duration: 2m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-25 08:19:23 Duration: 2m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-23 08:18:20 Duration: 2m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 8m52s 5 1m38s 1m58s 1m46s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 23 09 1 1m38s 1m38s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m46s 1m46s Feb 26 08 1 1m58s 1m58s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 8m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m52s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-02-26 07:57:52 Duration: 1m58s Database: cnrs 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-02-27 08:02:48 Duration: 1m47s Database: cnrs 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-02-25 07:58:04 Duration: 1m46s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 8m31s 5 1m39s 1m43s 1m42s 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 #8
Day Hour Count Duration Avg duration Feb 23 08 1 1m39s 1m39s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m43s 1m43s Feb 26 08 1 1m43s 1m43s Feb 27 09 1 1m42s 1m42s [ User: a3dsupervisor - Total duration: 8m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m31s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2026-02-25 07:56:17 Duration: 1m43s Database: cnrs 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-02-26 07:55:53 Duration: 1m43s Database: cnrs 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-02-24 07:58:15 Duration: 1m42s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 7m41s 5 1m13s 1m56s 1m32s create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 23 09 1 1m56s 1m56s Feb 24 09 1 1m24s 1m24s Feb 25 09 1 1m40s 1m40s Feb 26 09 1 1m13s 1m13s Feb 27 09 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 7m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m41s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-23 08:15:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-25 08:16:38 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-27 08:17:04 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 7m28s 5 29s836ms 2m53s 1m29s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 23 09 1 2m53s 2m53s Feb 24 09 1 1m38s 1m38s Feb 25 09 1 29s836ms 29s836ms Feb 26 09 1 1m7s 1m7s Feb 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 7m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:15:22 Duration: 2m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:16:19 Duration: 1m38s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:21:42 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 7m13s 4 42s378ms 4m30s 1m48s alter table only public.gtp_history_obj_compo 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;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 24 09 1 1m 1m Feb 25 09 1 42s378ms 42s378ms Feb 26 09 1 59s727ms 59s727ms Feb 27 09 1 4m30s 4m30s [ User: a3dsupervisor - Total duration: 7m13s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m13s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-27 08:34:14 Duration: 4m30s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-24 08:25:37 Duration: 1m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-26 08:24:17 Duration: 59s727ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 7m1s 5 27s458ms 1m43s 1m24s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 23 09 1 1m39s 1m39s Feb 24 09 1 1m43s 1m43s Feb 25 09 1 27s458ms 27s458ms Feb 26 09 1 1m34s 1m34s Feb 27 09 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 7m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m1s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:14:41 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:18:38 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:20:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 6m38s 4 59s494ms 2m46s 1m39s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 23 09 1 2m46s 2m46s Feb 25 09 1 1m24s 1m24s Feb 26 09 1 1m28s 1m28s Feb 27 09 1 59s494ms 59s494ms [ User: a3dsupervisor - Total duration: 6m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m38s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-23 08:11:18 Duration: 2m46s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-26 08:21:19 Duration: 1m28s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-25 08:20:47 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 6m29s 5 58s250ms 1m51s 1m17s create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 23 09 1 58s250ms 58s250ms Feb 24 09 1 1m7s 1m7s Feb 25 09 1 1m51s 1m51s Feb 26 09 1 1m26s 1m26s Feb 27 09 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 6m29s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m29s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-25 08:03:30 Duration: 1m51s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-26 08:02:40 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-24 08:05:04 Duration: 1m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5m56s 5 1m1s 1m22s 1m11s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m4s 1m4s Feb 25 09 1 1m8s 1m8s Feb 26 09 1 1m1s 1m1s Feb 27 09 1 1m22s 1m22s [ User: a3dsupervisor - Total duration: 5m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m56s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-27 08:29:43 Duration: 1m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-23 08:27:35 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-25 08:23:21 Duration: 1m8s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5m48s 5 30s134ms 1m28s 1m9s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m28s 1m28s Feb 25 09 1 30s134ms 30s134ms Feb 26 09 1 1m11s 1m11s Feb 27 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 5m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m48s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:17:48 Duration: 1m28s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:19:58 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:23:01 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5m12s 5 54s945ms 1m17s 1m2s create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 23 09 1 54s945ms 54s945ms Feb 24 09 1 57s4ms 57s4ms Feb 25 09 1 1m4s 1m4s Feb 26 09 1 1m17s 1m17s Feb 27 09 1 58s445ms 58s445ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-26 08:02:18 Duration: 1m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-25 08:02:16 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-27 08:06:50 Duration: 58s445ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5m8s 5 56s679ms 1m4s 1m1s 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 #18
Day Hour Count Duration Avg duration Feb 23 09 1 1m 1m Feb 24 09 1 56s679ms 56s679ms Feb 25 08 1 1m3s 1m3s Feb 26 08 1 1m2s 1m2s Feb 27 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-02-27 08:03:53 Duration: 1m4s Database: cnrs 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-02-25 07:59:08 Duration: 1m3s Database: cnrs 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-02-26 07:58:54 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5m7s 5 59s29ms 1m2s 1m1s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 23 09 1 59s29ms 59s29ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m1s 1m1s Feb 26 08 1 1m1s 1m1s Feb 27 09 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m7s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-27 08:04:55 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-24 08:01:57 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-25 08:00:09 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5m3s 5 56s543ms 1m3s 1m create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 23 09 1 58s49ms 58s49ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m2s 1m2s Feb 26 09 1 1m3s 1m3s Feb 27 09 1 56s543ms 56s543ms [ User: a3dsupervisor - Total duration: 5m3s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m3s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-26 08:01:00 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-24 08:02:59 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-25 08:01:11 Duration: 1m2s Database: cnrs 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 5 42m18s 7m3s 10m12s 8m27s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) from stdin;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 23 09 1 10m12s 10m12s Feb 24 09 1 9m12s 9m12s Feb 25 09 1 7m5s 7m5s Feb 26 09 1 7m3s 7m3s Feb 27 09 1 8m43s 8m43s [ User: a3dsupervisor - Total duration: 42m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 42m18s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-23 08:07:04 Duration: 10m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-24 08:05:45 Duration: 9m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-27 08:08:02 Duration: 8m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 5 13m10s 1m3s 3m40s 2m38s create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 23 09 1 1m3s 1m3s Feb 24 09 1 1m52s 1m52s Feb 25 09 1 3m2s 3m2s Feb 26 09 1 3m40s 3m40s Feb 27 09 1 3m31s 3m31s [ User: a3dsupervisor - Total duration: 13m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 13m10s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-26 08:05:58 Duration: 3m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-27 08:11:27 Duration: 3m31s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-25 08:05:18 Duration: 3m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 5 12m51s 1m42s 3m18s 2m34s alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 23 09 1 1m42s 1m42s Feb 24 09 1 3m18s 3m18s Feb 25 09 1 2m45s 2m45s Feb 26 09 1 2m30s 2m30s Feb 27 09 1 2m34s 2m34s [ User: a3dsupervisor - Total duration: 12m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 12m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-24 08:10:15 Duration: 3m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-25 08:08:04 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-27 08:14:02 Duration: 2m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 5 10m28s 1m47s 2m29s 2m5s alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 23 09 1 2m1s 2m1s Feb 24 09 1 2m1s 2m1s Feb 25 09 1 2m7s 2m7s Feb 26 09 1 2m29s 2m29s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-26 08:12:28 Duration: 2m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-25 08:19:23 Duration: 2m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-23 08:18:20 Duration: 2m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 5 8m52s 1m38s 1m58s 1m46s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 23 09 1 1m38s 1m38s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m46s 1m46s Feb 26 08 1 1m58s 1m58s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 8m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m52s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-02-26 07:57:52 Duration: 1m58s Database: cnrs 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-02-27 08:02:48 Duration: 1m47s Database: cnrs 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-02-25 07:58:04 Duration: 1m46s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5 8m31s 1m39s 1m43s 1m42s 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 #6
Day Hour Count Duration Avg duration Feb 23 08 1 1m39s 1m39s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m43s 1m43s Feb 26 08 1 1m43s 1m43s Feb 27 09 1 1m42s 1m42s [ User: a3dsupervisor - Total duration: 8m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m31s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2026-02-25 07:56:17 Duration: 1m43s Database: cnrs 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-02-26 07:55:53 Duration: 1m43s Database: cnrs 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-02-24 07:58:15 Duration: 1m42s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5 7m41s 1m13s 1m56s 1m32s create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 23 09 1 1m56s 1m56s Feb 24 09 1 1m24s 1m24s Feb 25 09 1 1m40s 1m40s Feb 26 09 1 1m13s 1m13s Feb 27 09 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 7m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m41s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-23 08:15:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-25 08:16:38 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-27 08:17:04 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 7m28s 29s836ms 2m53s 1m29s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Feb 23 09 1 2m53s 2m53s Feb 24 09 1 1m38s 1m38s Feb 25 09 1 29s836ms 29s836ms Feb 26 09 1 1m7s 1m7s Feb 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 7m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:15:22 Duration: 2m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:16:19 Duration: 1m38s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:21:42 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 7m1s 27s458ms 1m43s 1m24s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Feb 23 09 1 1m39s 1m39s Feb 24 09 1 1m43s 1m43s Feb 25 09 1 27s458ms 27s458ms Feb 26 09 1 1m34s 1m34s Feb 27 09 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 7m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m1s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:14:41 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:18:38 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:20:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 6m29s 58s250ms 1m51s 1m17s create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 23 09 1 58s250ms 58s250ms Feb 24 09 1 1m7s 1m7s Feb 25 09 1 1m51s 1m51s Feb 26 09 1 1m26s 1m26s Feb 27 09 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 6m29s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m29s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-25 08:03:30 Duration: 1m51s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-26 08:02:40 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-24 08:05:04 Duration: 1m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 5m56s 1m1s 1m22s 1m11s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m4s 1m4s Feb 25 09 1 1m8s 1m8s Feb 26 09 1 1m1s 1m1s Feb 27 09 1 1m22s 1m22s [ User: a3dsupervisor - Total duration: 5m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m56s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-27 08:29:43 Duration: 1m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-23 08:27:35 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-25 08:23:21 Duration: 1m8s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 5m48s 30s134ms 1m28s 1m9s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m28s 1m28s Feb 25 09 1 30s134ms 30s134ms Feb 26 09 1 1m11s 1m11s Feb 27 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 5m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m48s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:17:48 Duration: 1m28s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:19:58 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:23:01 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 5m12s 54s945ms 1m17s 1m2s create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 23 09 1 54s945ms 54s945ms Feb 24 09 1 57s4ms 57s4ms Feb 25 09 1 1m4s 1m4s Feb 26 09 1 1m17s 1m17s Feb 27 09 1 58s445ms 58s445ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-26 08:02:18 Duration: 1m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-25 08:02:16 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-27 08:06:50 Duration: 58s445ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 5m8s 56s679ms 1m4s 1m1s 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 #14
Day Hour Count Duration Avg duration Feb 23 09 1 1m 1m Feb 24 09 1 56s679ms 56s679ms Feb 25 08 1 1m3s 1m3s Feb 26 08 1 1m2s 1m2s Feb 27 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-02-27 08:03:53 Duration: 1m4s Database: cnrs 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-02-25 07:59:08 Duration: 1m3s Database: cnrs 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-02-26 07:58:54 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 5m7s 59s29ms 1m2s 1m1s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 23 09 1 59s29ms 59s29ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m1s 1m1s Feb 26 08 1 1m1s 1m1s Feb 27 09 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m7s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-27 08:04:55 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-24 08:01:57 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-25 08:00:09 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 5m3s 56s543ms 1m3s 1m create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 23 09 1 58s49ms 58s49ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m2s 1m2s Feb 26 09 1 1m3s 1m3s Feb 27 09 1 56s543ms 56s543ms [ User: a3dsupervisor - Total duration: 5m3s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m3s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-26 08:01:00 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-24 08:02:59 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-25 08:01:11 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 4m57s 27s809ms 1m45s 59s550ms 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 #17
Day Hour Count Duration Avg duration Feb 23 09 1 27s809ms 27s809ms Feb 24 09 1 56s953ms 56s953ms Feb 25 09 1 1m45s 1m45s Feb 26 09 1 54s190ms 54s190ms Feb 27 09 1 52s946ms 52s946ms [ User: a3dsupervisor - Total duration: 4m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m57s - Times executed: 5 ]
-
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-02-25 08:16:55 Duration: 1m45s Database: cnrs 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-02-24 08:17:00 Duration: 56s953ms Database: cnrs 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-02-26 08:14:26 Duration: 54s190ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 4m28s 43s25ms 1m13s 53s638ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Feb 23 09 1 48s221ms 48s221ms Feb 24 09 1 46s784ms 46s784ms Feb 25 09 1 56s975ms 56s975ms Feb 26 09 1 1m13s 1m13s Feb 27 09 1 43s25ms 43s25ms [ User: a3dsupervisor - Total duration: 4m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m28s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2026-02-26 08:03:53 Duration: 1m13s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2026-02-25 08:04:27 Duration: 56s975ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2026-02-23 08:07:53 Duration: 48s221ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 3m56s 19s507ms 1m21s 47s251ms alter table only public.gtp_log_ehcache add constraint pk_log_ehcache primary key (log_ehcache_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 23 09 1 1m21s 1m21s Feb 24 09 1 23s741ms 23s741ms Feb 25 09 1 19s507ms 19s507ms Feb 26 09 1 39s900ms 39s900ms Feb 27 09 1 1m11s 1m11s [ User: a3dsupervisor - Total duration: 3m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m56s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2026-02-23 08:29:24 Duration: 1m21s Database: cnrs 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-02-27 08:13:48 Duration: 1m11s Database: cnrs 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-02-26 08:06:55 Duration: 39s900ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 3m40s 36s809ms 1m2s 44s84ms alter table only public.gtp_history_obj_compo add constraint pk_history_obj_compo primary key (history_compo_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 23 09 1 36s809ms 36s809ms Feb 24 09 1 43s368ms 43s368ms Feb 25 09 1 1m2s 1m2s Feb 26 09 1 39s336ms 39s336ms Feb 27 09 1 38s258ms 38s258ms [ User: a3dsupervisor - Total duration: 3m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m40s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-02-25 08:18:41 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-02-24 08:20:44 Duration: 43s368ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2026-02-26 08:16:20 Duration: 39s336ms Database: cnrs 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 24m11s 27m19s 25m23s 3 1h16m11s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Feb 25 10 1 24m11s 24m11s Feb 26 10 1 24m40s 24m40s Feb 27 10 1 27m19s 27m19s [ User: a3dsupervisor - Total duration: 1h16m11s - Times executed: 3 ]
[ Application: psql - Total duration: 1h16m11s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2026-02-27 09:46:55 Duration: 27m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-02-26 09:34:58 Duration: 24m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2026-02-25 09:36:11 Duration: 24m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 7m3s 10m12s 8m27s 5 42m18s copy public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Feb 23 09 1 10m12s 10m12s Feb 24 09 1 9m12s 9m12s Feb 25 09 1 7m5s 7m5s Feb 26 09 1 7m3s 7m3s Feb 27 09 1 8m43s 8m43s [ User: a3dsupervisor - Total duration: 42m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 42m18s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-23 08:07:04 Duration: 10m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-24 08:05:45 Duration: 9m12s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type, batch_process_num_id) FROM stdin;
Date: 2026-02-27 08:08:02 Duration: 8m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 2m56s 4m39s 3m32s 4 14m9s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Feb 23 09 1 4m39s 4m39s Feb 25 09 1 2m56s 2m56s Feb 26 09 1 3m19s 3m19s Feb 27 09 1 3m13s 3m13s [ User: a3dsupervisor - Total duration: 14m9s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 14m9s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-23 08:12:27 Duration: 4m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-26 08:11:48 Duration: 3m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2026-02-27 08:17:16 Duration: 3m13s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m3s 3m40s 2m38s 5 13m10s create index i_fk_monthly_history_unit on public.gtp_monthly_history using btree (att_unit_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Feb 23 09 1 1m3s 1m3s Feb 24 09 1 1m52s 1m52s Feb 25 09 1 3m2s 3m2s Feb 26 09 1 3m40s 3m40s Feb 27 09 1 3m31s 3m31s [ User: a3dsupervisor - Total duration: 13m10s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 13m10s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-26 08:05:58 Duration: 3m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-27 08:11:27 Duration: 3m31s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_unit ON public.gtp_monthly_history USING btree (att_unit_num_id);
Date: 2026-02-25 08:05:18 Duration: 3m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m42s 3m18s 2m34s 5 12m51s alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Feb 23 09 1 1m42s 1m42s Feb 24 09 1 3m18s 3m18s Feb 25 09 1 2m45s 2m45s Feb 26 09 1 2m30s 2m30s Feb 27 09 1 2m34s 2m34s [ User: a3dsupervisor - Total duration: 12m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 12m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-24 08:10:15 Duration: 3m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-25 08:08:04 Duration: 2m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2026-02-27 08:14:02 Duration: 2m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m47s 2m29s 2m5s 5 10m28s alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Feb 23 09 1 2m1s 2m1s Feb 24 09 1 2m1s 2m1s Feb 25 09 1 2m7s 2m7s Feb 26 09 1 2m29s 2m29s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 10m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-26 08:12:28 Duration: 2m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-25 08:19:23 Duration: 2m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2026-02-23 08:18:20 Duration: 2m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 42s378ms 4m30s 1m48s 4 7m13s alter table only public.gtp_history_obj_compo 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;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Feb 24 09 1 1m 1m Feb 25 09 1 42s378ms 42s378ms Feb 26 09 1 59s727ms 59s727ms Feb 27 09 1 4m30s 4m30s [ User: a3dsupervisor - Total duration: 7m13s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m13s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-27 08:34:14 Duration: 4m30s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-24 08:25:37 Duration: 1m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_compo 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-02-26 08:24:17 Duration: 59s727ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m38s 1m58s 1m46s 5 8m52s 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 Feb 23 09 1 1m38s 1m38s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m46s 1m46s Feb 26 08 1 1m58s 1m58s Feb 27 09 1 1m47s 1m47s [ User: a3dsupervisor - Total duration: 8m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m52s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2026-02-26 07:57:52 Duration: 1m58s Database: cnrs 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-02-27 08:02:48 Duration: 1m47s Database: cnrs 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-02-25 07:58:04 Duration: 1m46s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m39s 1m43s 1m42s 5 8m31s 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 #9
Day Hour Count Duration Avg duration Feb 23 08 1 1m39s 1m39s Feb 24 08 1 1m42s 1m42s Feb 25 08 1 1m43s 1m43s Feb 26 08 1 1m43s 1m43s Feb 27 09 1 1m42s 1m42s [ User: a3dsupervisor - Total duration: 8m31s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m31s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2026-02-25 07:56:17 Duration: 1m43s Database: cnrs 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-02-26 07:55:53 Duration: 1m43s Database: cnrs 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-02-24 07:58:15 Duration: 1m42s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 59s494ms 2m46s 1m39s 4 6m38s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Feb 23 09 1 2m46s 2m46s Feb 25 09 1 1m24s 1m24s Feb 26 09 1 1m28s 1m28s Feb 27 09 1 59s494ms 59s494ms [ User: a3dsupervisor - Total duration: 6m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m38s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-23 08:11:18 Duration: 2m46s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-26 08:21:19 Duration: 1m28s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2026-02-25 08:20:47 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 1m13s 1m56s 1m32s 5 7m41s create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Feb 23 09 1 1m56s 1m56s Feb 24 09 1 1m24s 1m24s Feb 25 09 1 1m40s 1m40s Feb 26 09 1 1m13s 1m13s Feb 27 09 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 7m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m41s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-23 08:15:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-25 08:16:38 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2026-02-27 08:17:04 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 29s836ms 2m53s 1m29s 5 7m28s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Feb 23 09 1 2m53s 2m53s Feb 24 09 1 1m38s 1m38s Feb 25 09 1 29s836ms 29s836ms Feb 26 09 1 1m7s 1m7s Feb 27 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 7m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m28s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:15:22 Duration: 2m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:16:19 Duration: 1m38s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:21:42 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 27s458ms 1m43s 1m24s 5 7m1s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Feb 23 09 1 1m39s 1m39s Feb 24 09 1 1m43s 1m43s Feb 25 09 1 27s458ms 27s458ms Feb 26 09 1 1m34s 1m34s Feb 27 09 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 7m1s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m1s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:14:41 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:18:38 Duration: 1m39s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:20:22 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 58s250ms 1m51s 1m17s 5 6m29s create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Feb 23 09 1 58s250ms 58s250ms Feb 24 09 1 1m7s 1m7s Feb 25 09 1 1m51s 1m51s Feb 26 09 1 1m26s 1m26s Feb 27 09 1 1m5s 1m5s [ User: a3dsupervisor - Total duration: 6m29s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m29s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-25 08:03:30 Duration: 1m51s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-26 08:02:40 Duration: 1m26s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2026-02-24 08:05:04 Duration: 1m7s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 1m1s 1m22s 1m11s 5 5m56s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m4s 1m4s Feb 25 09 1 1m8s 1m8s Feb 26 09 1 1m1s 1m1s Feb 27 09 1 1m22s 1m22s [ User: a3dsupervisor - Total duration: 5m56s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m56s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-27 08:29:43 Duration: 1m22s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-23 08:27:35 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2026-02-25 08:23:21 Duration: 1m8s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 30s134ms 1m28s 1m9s 5 5m48s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Feb 23 09 1 1m19s 1m19s Feb 24 09 1 1m28s 1m28s Feb 25 09 1 30s134ms 30s134ms Feb 26 09 1 1m11s 1m11s Feb 27 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 5m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m48s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-24 08:17:48 Duration: 1m28s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-23 08:19:58 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2026-02-27 08:23:01 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 54s945ms 1m17s 1m2s 5 5m12s create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Feb 23 09 1 54s945ms 54s945ms Feb 24 09 1 57s4ms 57s4ms Feb 25 09 1 1m4s 1m4s Feb 26 09 1 1m17s 1m17s Feb 27 09 1 58s445ms 58s445ms [ User: a3dsupervisor - Total duration: 5m12s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m12s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-26 08:02:18 Duration: 1m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-25 08:02:16 Duration: 1m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2026-02-27 08:06:50 Duration: 58s445ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 56s679ms 1m4s 1m1s 5 5m8s 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 #18
Day Hour Count Duration Avg duration Feb 23 09 1 1m 1m Feb 24 09 1 56s679ms 56s679ms Feb 25 08 1 1m3s 1m3s Feb 26 08 1 1m2s 1m2s Feb 27 09 1 1m4s 1m4s [ User: a3dsupervisor - Total duration: 5m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2026-02-27 08:03:53 Duration: 1m4s Database: cnrs 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-02-25 07:59:08 Duration: 1m3s Database: cnrs 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-02-26 07:58:54 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 59s29ms 1m2s 1m1s 5 5m7s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Feb 23 09 1 59s29ms 59s29ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m1s 1m1s Feb 26 08 1 1m1s 1m1s Feb 27 09 1 1m2s 1m2s [ User: a3dsupervisor - Total duration: 5m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m7s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-27 08:04:55 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-24 08:01:57 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2026-02-25 08:00:09 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 56s543ms 1m3s 1m 5 5m3s create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Feb 23 09 1 58s49ms 58s49ms Feb 24 09 1 1m2s 1m2s Feb 25 09 1 1m2s 1m2s Feb 26 09 1 1m3s 1m3s Feb 27 09 1 56s543ms 56s543ms [ User: a3dsupervisor - Total duration: 5m3s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m3s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-26 08:01:00 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-24 08:02:59 Duration: 1m2s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2026-02-25 08:01:11 Duration: 1m2s Database: cnrs 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
- 102,718 Log entries
Events distribution
Key values
- 0 PANIC entries
- 18 FATAL entries
- 97302 ERROR entries
- 2 WARNING entries
Most Frequent Errors/Events
Key values
- 97,153 Max number of times the same event was reported
- 97,322 Total events found
Rank Times reported Error 1 97,153 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Feb 22 13 66 14 25,228 15 27,565 16 3,600 17 3,600 18 3,304 Feb 23 07 24,403 08 9,387 2 38 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Feb 23 09 5 10 3 Feb 24 09 10 10 1 Feb 25 09 3 10 1 Feb 26 09 8 Feb 27 09 3 10 4 3 21 ERROR: operator does not exist: integer = character varying
Times Reported Most Frequent Error / Event #3
Day Hour Count Feb 27 15 21 4 14 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Feb 22 18 2 Feb 25 16 3 19 2 Feb 26 19 2 Feb 27 19 3 Feb 28 19 2 5 11 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Feb 27 12 11 6 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Feb 25 08 3 Feb 27 15 2 16 1 7 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Feb 25 08 3 Feb 27 12 2 8 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_log_ehcache ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (...)
Times Reported Most Frequent Error / Event #8
Day Hour Count Feb 26 09 1 Feb 27 09 2 9 3 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 10 3 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 11 3 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 12 3 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #12
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 13 3 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 14 3 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #14
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 15 3 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #15
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 16 3 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #16
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 17 3 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #17
Day Hour Count Feb 25 10 1 Feb 26 10 1 Feb 27 10 1 18 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockSELECT pc.oid,pc.relname,pc.relnamespace,pc.relkind FROM pg_catalog.pg_class pc WHERE pc.relkind in(...) AND pc.relname ILIKE ORDER BY pc.relname LIMIT 1
Times Reported Most Frequent Error / Event #18
Day Hour Count Feb 27 15 2 19 2 WARNING: there is no transaction in progress
Times Reported Most Frequent Error / Event #19
Day Hour Count Feb 25 08 2 20 2 ERROR: type "..." does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Feb 27 15 2 21 2 ERROR: operator does not exist: integer == unknown
Times Reported Most Frequent Error / Event #21
Day Hour Count Feb 25 08 2 22 2 ERROR: operator does not exist: character varying > integer
Times Reported Most Frequent Error / Event #22
Day Hour Count Feb 25 08 2 23 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(...); cNewGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); --CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT gd.document_num_id::varchar INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0.99'; --COMMIT; --CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #23
Day Hour Count Feb 27 15 2 24 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(...); cNewGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT gd.document_num_id::varchar INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.99'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #24
Day Hour Count Feb 27 15 2 25 2 ERROR: current transaction is aborted, commands ignored until end of transaction blockSELECT pc.oid,pc.relname,pc.relnamespace,pc.relkind FROM pg_catalog.pg_class pc WHERE pc.relkind in(...) AND pc.relname ILIKE AND pc.relnamespace IN (...) ORDER BY pc.relname LIMIT 10
Times Reported Most Frequent Error / Event #25
Day Hour Count Feb 27 15 2 26 2 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #26
Day Hour Count Feb 25 10 1 Feb 26 10 1 27 2 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #27
Day Hour Count Feb 25 08 2 28 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT VARCHAR2(...) := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...)) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId INTEGER; cObjId INTEGER; cOldGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = (...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId ) WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0_ocl'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #28
Day Hour Count Feb 27 15 1 29 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt ADD CONSTRAINT fk_gtp_obj_rel_vt_relt FOREIGN KEY (...) REFERENCES public.gtp_rel_template(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #29
Day Hour Count Feb 27 09 1 30 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_log_ehcache_region_name ON public.gtp_log_ehcache USING btree (...)
Times Reported Most Frequent Error / Event #30
Day Hour Count Feb 24 09 1 31 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_compo_value_compo_id ON public.gtp_obj_composition USING btree (...)
Times Reported Most Frequent Error / Event #31
Day Hour Count Feb 26 09 1 32 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...)) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(...); cNewGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT TO_CHAR(...) INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #32
Day Hour Count Feb 27 15 1 33 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #33
Day Hour Count Feb 25 09 1 34 1 ERROR: out of memoryALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (...)
Times Reported Most Frequent Error / Event #34
Day Hour Count Feb 24 09 1 35 1 ERROR: out of memoryCREATE INDEX i_gtp_obj_compo_modifier ON public.gtp_obj_composition USING btree (...)
Times Reported Most Frequent Error / Event #35
Day Hour Count Feb 24 09 1 36 1 ERROR: out of memoryCREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (...)
Times Reported Most Frequent Error / Event #36
Day Hour Count Feb 24 09 1 37 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_template FOREIGN KEY (...) REFERENCES public.gtp_att_template(...) DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #37
Day Hour Count Feb 24 09 1 38 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.ged_right_user
Times Reported Most Frequent Error / Event #38
Day Hour Count Feb 23 09 1 39 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockSELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'
Times Reported Most Frequent Error / Event #39
Day Hour Count Feb 27 15 1 40 1 ERROR: out of memoryCREATE INDEX i_log_ehcache_server_id ON public.gtp_log_ehcache USING btree (...)
Times Reported Most Frequent Error / Event #40
Day Hour Count Feb 23 09 1 41 1 ERROR: parallel worker failed to initializeCREATE INDEX i_history_old_qsp_obj ON public.gtp_history_obj_old_qsp USING btree (...)
Times Reported Most Frequent Error / Event #41
Day Hour Count Feb 23 09 1 42 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(...); cNewGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; SELECT TO_CHAR(...) INTO cNewGedId FROM GED_DOCUMENT gd INNER JOIN GED_DOCUMENT gei ON (...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = cNewGedId WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.99'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #42
Day Hour Count Feb 27 15 1 43 1 ERROR: column "..." is of type boolean but expression is of type integer
Times Reported Most Frequent Error / Event #43
Day Hour Count Feb 27 16 1 44 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (...)
Times Reported Most Frequent Error / Event #44
Day Hour Count Feb 24 09 1 45 1 ERROR: operator does not exist: character varying <> integer
Times Reported Most Frequent Error / Event #45
Day Hour Count Feb 25 08 1 46 1 ERROR: out of memoryALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #46
Day Hour Count Feb 23 09 1 47 1 ERROR: operator does not exist: character varying == integer
Times Reported Most Frequent Error / Event #47
Day Hour Count Feb 25 08 1 48 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockSELECT * FROM GTP_LOG ORDER BY GTP_LOG.LOG_DATE DESC
Times Reported Most Frequent Error / Event #48
Day Hour Count Feb 27 15 1 49 1 ERROR: operator does not exist: integer == integer
Times Reported Most Frequent Error / Event #49
Day Hour Count Feb 25 08 1 50 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (...)
Times Reported Most Frequent Error / Event #50
Day Hour Count Feb 23 09 1 51 1 ERROR: current transaction is aborted, commands ignored until end of transaction blockDO $body$ DECLARE L_SCRIPT_NAME CONSTANT TEXT := '01_ACTIVE3D_RQM-19599'; curSel CURSOR FOR SELECT DISTINCT ga.OBJ_COMPO_NUM_ID, ga.OBJ_NUM_ID , ga.OBJ_COMPO_VALUE FROM GTP_OBJ_COMPOSITION ga INNER JOIN gtp_att_template gat ON (...) INNER JOIN GED_DOCUMENT ge ON (...)) LEFT JOIN GTP_OBJ_COMPOSITION tab ON (...) WHERE gat.att_template_domain_code = 'FIL'; cCompoNumId bigint; cObjId bigint; cOldGedId VARCHAR(...); BEGIN -- Ne pas supprimer cette ligne : Initialisation de la validation du passage du script de post-installation INSERT INTO A3D_MIGRATION_TRACKING (...) VALUES (...); CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); raise debug 'START %', L_SCRIPT_NAME; -- -------------------------------------------------------------------------------- OPEN curSel; LOOP FETCH NEXT FROM curSel INTO cCompoNumId, cObjId, cOldGedId; -- exit if not found EXIT WHEN NOT FOUND; -- On utilise la dernière version du fichier correspondant à DOCUMENT_NUM_ID_VERSION null UPDATE GTP_OBJ_COMPOSITION SET OBJ_COMPO_VALUE = TO_CHAR(...) WHERE gd.DOCUMENT_NUM_ID_VERSION IS NULL AND gei.document_num_id = cOldGedId ) WHERE OBJ_COMPO_NUM_ID = cCompoNumId AND OBJ_NUM_ID = cObjId; END LOOP; CLOSE curSel; -- -------------------------------------------------------------------------------- raise notice 'END %', L_SCRIPT_NAME; -- Ne pas supprimer cette ligne : Validation du passage du script de post-installation UPDATE A3D_MIGRATION_TRACKING SET VALIDATED = 1 WHERE TYPE = 'postInstallation' AND NAME = L_SCRIPT_NAME AND RELEASE = '7.23.0.0_OCL'; --COMMIT; CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); EXCEPTION WHEN OTHERS THEN CALL PACK_GTP_UTILS.P_TRACE_LOG_POST_INSTALL(...); CALL PACK_GTP_UTILS.P_TRACE_ERROR(...); RAISE; END $body$
Times Reported Most Frequent Error / Event #51
Day Hour Count Feb 27 15 1