pgBadger-
Global information
- Generated on Mon Sep 29 09:35:40 2025
- Log file: ././A3D-RND-PIC/y=2025/m=09/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=09/d=27/h=23/m=00/PT1H.log
- Parsed 604,157 log entries in 1m15s
- Log start from 2025-09-23 00:05:02 to 2025-09-27 17:01:56
-
Overview
Global Stats
- 81 Number of unique normalized queries
- 188 Number of queries
- 2h56m12s Total query duration
- 2025-09-23 00:00:44 First query
- 2025-09-27 00:00:49 Last query
- 3 queries/s at 2025-09-26 06:18:39 Query peak
- 2h56m12s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h56m12s Execute total duration
- 295,516 Number of events
- 26 Number of unique normalized events
- 194,101 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 1 Total number of automatic analyzes
- 615 Number temporary file
- 1.17 GiB Max size of temporary file
- 39.05 MiB Average size of temporary file
- 4,018 Total number of sessions
- 44 sessions at 2025-09-27 00:57:41 Session peak
- 11d5h51m49s Total duration of sessions
- 4m1s Average duration of sessions
- 0 Average queries per session
- 2s631ms Average queries duration per session
- 3m59s Average idle time per session
- 4,017 Total number of connections
- 11 connections/s at 2025-09-23 08:24:56 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-09-26 06:18:39 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-09-26 06:18:39 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-09-23 19:27:18 Date
Queries duration
Key values
- 2h56m12s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 1 0ms 7s81ms 7s81ms 0ms 0ms 7s81ms 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 15 0ms 1m39s 41s982ms 1m55s 2m32s 2m57s 07 26 0ms 1m36s 22s248ms 1m36s 2m2s 2m11s 08 1 0ms 27m1s 27m1s 0ms 0ms 27m1s 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 6 0ms 11s509ms 7s634ms 0ms 0ms 45s808ms 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 Sep 24 00 1 0ms 7s373ms 7s373ms 0ms 0ms 7s373ms 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 11 0ms 2m26s 1m11s 2m28s 4m7s 4m44s 07 28 0ms 2m32s 39s26ms 2m19s 2m43s 3m31s 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 Sep 25 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 41 0ms 2m24s 46s528ms 2m39s 2m53s 4m28s 08 1 0ms 29m29s 29m29s 0ms 29m29s 29m29s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 5 0ms 6s536ms 5s909ms 0ms 5s792ms 17s596ms 19 4 0ms 7s724ms 6s281ms 0ms 5s65ms 14s952ms 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 Sep 26 00 1 0ms 6s993ms 6s993ms 0ms 0ms 6s993ms 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 16 0ms 1m44s 41s20ms 1m53s 2m54s 3m28s 07 27 0ms 9m38s 51s486ms 2m26s 3m14s 9m38s 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 3 0ms 6s267ms 5s662ms 0ms 5s350ms 6s267ms 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 Sep 27 00 1 0ms 6s461ms 6s461ms 0ms 0ms 6s461ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 1 0 7s81ms 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 Sep 24 00 1 0 7s373ms 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 Sep 25 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 2 0 8s391ms 0ms 0ms 8s396ms 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 Sep 26 00 1 0 6s993ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 1 0 6s246ms 0ms 0ms 6s246ms 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 Sep 27 00 1 0 6s461ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 4 1m 0ms 0ms 1m2s 07 0 0 0 4 22s458ms 0ms 0ms 23s17ms 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 6 0 7s634ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 3 1m55s 0ms 0ms 1m3s 07 0 0 0 5 32s448ms 0ms 0ms 46s861ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 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 7 1m6s 0ms 29s181ms 59s131ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 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 4 1m13s 0ms 0ms 51s786ms 07 0 0 0 3 29s737ms 0ms 0ms 37s981ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 23 00 0 1 1.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 6 6.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% Sep 24 00 0 1 1.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% Sep 25 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 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 5 5.00 0.00% 19 0 4 4.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% Sep 26 00 0 1 1.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 3 3.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 3 3.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% Sep 27 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Sep 23 00 39 0.01/s 01 54 0.01/s 02 47 0.01/s 03 52 0.01/s 04 53 0.01/s 05 34 0.01/s 06 16 0.00/s 07 13 0.00/s 08 63 0.02/s 09 47 0.01/s 10 49 0.01/s 11 50 0.01/s 12 47 0.01/s 13 54 0.01/s 14 64 0.02/s 15 59 0.02/s 16 50 0.01/s 17 44 0.01/s 18 43 0.01/s 19 51 0.01/s 20 51 0.01/s 21 41 0.01/s 22 43 0.01/s 23 49 0.01/s Sep 24 00 46 0.01/s 01 44 0.01/s 02 51 0.01/s 03 42 0.01/s 04 47 0.01/s 05 39 0.01/s 06 23 0.01/s 07 8 0.00/s 08 5 0.00/s 09 4 0.00/s 10 6 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Sep 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 7 0.00/s 07 2 0.00/s 08 48 0.01/s 09 46 0.01/s 10 42 0.01/s 11 40 0.01/s 12 43 0.01/s 13 58 0.02/s 14 41 0.01/s 15 41 0.01/s 16 49 0.01/s 17 35 0.01/s 18 55 0.02/s 19 48 0.01/s 20 37 0.01/s 21 39 0.01/s 22 49 0.01/s 23 57 0.02/s Sep 26 00 37 0.01/s 01 45 0.01/s 02 45 0.01/s 03 40 0.01/s 04 47 0.01/s 05 45 0.01/s 06 24 0.01/s 07 48 0.01/s 08 37 0.01/s 09 42 0.01/s 10 43 0.01/s 11 41 0.01/s 12 41 0.01/s 13 52 0.01/s 14 50 0.01/s 15 43 0.01/s 16 42 0.01/s 17 37 0.01/s 18 46 0.01/s 19 47 0.01/s 20 47 0.01/s 21 34 0.01/s 22 46 0.01/s 23 52 0.01/s Sep 27 00 50 0.01/s 01 47 0.01/s 02 32 0.01/s 03 51 0.01/s 04 51 0.01/s 05 44 0.01/s 06 42 0.01/s 07 46 0.01/s 08 37 0.01/s 09 53 0.01/s 10 50 0.01/s 11 51 0.01/s 12 41 0.01/s 13 36 0.01/s 14 45 0.01/s 15 45 0.01/s 16 48 0.01/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 23 00 42 1m27s 1m26s 01 54 1m17s 1m17s 02 43 1m17s 1m17s 03 56 1m17s 1m17s 04 52 1m16s 1m16s 05 34 1m21s 1m21s 06 17 1h30m3s 1h29m26s 07 14 7m3s 6m21s 08 62 1m14s 48s334ms 09 47 1m13s 1m13s 10 49 1m12s 1m12s 11 50 1m18s 1m18s 12 46 1m16s 1m16s 13 54 1m12s 1m12s 14 65 1m17s 1m17s 15 58 1m16s 1m16s 16 50 1m19s 1m19s 17 41 26m35s 26m35s 18 47 1m19s 1m19s 19 51 1m27s 1m26s 20 51 1m17s 1m17s 21 41 1m22s 1m22s 22 39 1m21s 1m21s 23 53 1m18s 1m18s Sep 24 00 45 1m21s 1m21s 01 44 1m19s 1m19s 02 51 1m16s 1m16s 03 43 1m19s 1m19s 04 47 1m17s 1m17s 05 39 1m21s 1m21s 06 23 1h9m56s 1h9m22s 07 10 12m32s 10m43s 08 5 233ms 233ms 09 4 140ms 140ms 10 6 112ms 112ms 11 2 72ms 72ms 12 2 73ms 73ms 13 2 169ms 169ms 14 2 113ms 113ms 15 2 82ms 82ms 16 2 75ms 75ms 17 2 252ms 252ms 18 2 125ms 125ms 19 2 130ms 130ms 20 2 78ms 78ms 21 2 72ms 72ms 22 2 70ms 70ms 23 2 70ms 70ms Sep 25 00 2 74ms 74ms 01 2 70ms 70ms 02 2 78ms 78ms 03 2 72ms 72ms 04 2 70ms 70ms 05 2 73ms 73ms 06 5 3s555ms 3s555ms 07 2 2s100ms 0ms 08 47 4m1s 3m24s 09 44 1m17s 1m17s 10 40 1m22s 1m22s 11 44 1m19s 1m19s 12 41 1m15s 1m15s 13 58 1m12s 1m12s 14 40 1m17s 1m17s 15 44 1m32s 1m32s 16 47 1m18s 1m18s 17 35 29m59s 29m59s 18 55 1m31s 1m30s 19 48 1m39s 1m38s 20 37 1m24s 1m24s 21 39 1m27s 1m27s 22 49 1m20s 1m20s 23 57 1m20s 1m20s Sep 26 00 38 1m27s 1m27s 01 42 1m24s 1m24s 02 47 1m19s 1m19s 03 40 1m19s 1m19s 04 47 1m20s 1m20s 05 45 1m20s 1m20s 06 25 32m16s 31m50s 07 48 2m36s 2m7s 08 37 1m11s 1m11s 09 41 1m16s 1m16s 10 43 1m17s 1m17s 11 41 1m23s 1m23s 12 42 1m14s 1m14s 13 52 1m13s 1m13s 14 49 1m18s 1m18s 15 41 23m11s 23m11s 16 44 1m55s 1m55s 17 37 8m 8m 18 46 1m57s 1m57s 19 48 2m2s 2m2s 20 46 2m 2m 21 34 2m41s 2m41s 22 46 1m57s 1m57s 23 52 1m56s 1m56s Sep 27 00 49 2m2s 2m1s 01 48 1m49s 1m49s 02 33 2m29s 2m29s 03 49 1m50s 1m50s 04 51 1m46s 1m46s 05 41 2m 2m 06 44 1m56s 1m56s 07 46 1m44s 1m44s 08 38 2m5s 2m5s 09 51 1m44s 1m44s 10 52 1m49s 1m49s 11 49 1m49s 1m49s 12 42 1m53s 1m53s 13 36 2m9s 2m9s 14 45 1m53s 1m53s 15 46 1m56s 1m56s 16 44 1m59s 1m59s 17 8 5h57m1s 5h57m1s 18 2 73ms 73ms 19 2 70ms 70ms 20 2 75ms 75ms 21 2 80ms 80ms 22 2 76ms 76ms 23 2 81ms 81ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-23 08:24:56 Date
Connections per database
Key values
- cnrs Main Database
- 4,017 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,017 connections Total
-
Sessions
Simultaneous sessions
Key values
- 44 sessions Session Peak
- 2025-09-27 00:57:41 Date
Histogram of session times
Key values
- 3,564 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 4,018 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,018 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,018 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 730.27 MiB Temp Files size Peak
- 2025-09-26 07:00:52 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-09-24 07:08:48 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 37 2.90 GiB 80.39 MiB 07 102 2.63 GiB 26.43 MiB 08 1 3.66 MiB 3.66 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 Sep 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 16 2.15 GiB 137.32 MiB 07 139 3.86 GiB 28.41 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 160 6.10 GiB 39.07 MiB 08 1 3.66 MiB 3.66 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 Sep 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 19 2.15 GiB 115.75 MiB 07 140 3.65 GiB 26.73 MiB 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 12 2.14 GiB 36.12 MiB 516.30 MiB 182.26 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-09-26 07:01:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 12 1.35 GiB 12.00 MiB 603.74 MiB 115.24 MiB add constraint pk_log_ehcache primary key (log_ehcache_num_id);-
ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);
Date: 2025-09-26 07:09:16 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 12 5.36 GiB 86.18 MiB 1.17 GiB 457.75 MiB add constraint pk_gtp_monthly_history primary key (histo_num_id);-
ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-26 06:56:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 12 619.62 MiB 47.69 MiB 55.55 MiB 51.64 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: 2025-09-25 07:16:08 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 12 2.79 GiB 201.59 MiB 266.81 MiB 238.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: 2025-09-26 07:00:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 12 1.68 GiB 14.89 MiB 739.69 MiB 143.08 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: 2025-09-26 07:06:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 12 559.37 MiB 9.30 MiB 122.91 MiB 46.61 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: 2025-09-26 07:09:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 12 3.28 GiB 130.25 MiB 791.71 MiB 280.18 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: 2025-09-26 07:05:07 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 12 441.23 MiB 26.41 MiB 81.90 MiB 36.77 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: 2025-09-26 07:07:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 10 44.23 MiB 2.46 MiB 8.31 MiB 4.42 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: 2025-09-26 07:09:48 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 10 635.98 MiB 46.95 MiB 158.98 MiB 63.60 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-26 07:08:43 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4 24.76 MiB 2.43 MiB 9.62 MiB 6.19 MiB add constraint pk_pe_consumption_10min primary key (consumption_num_id);-
ADD CONSTRAINT pk_pe_consumption_10min PRIMARY KEY (consumption_num_id);
Date: 2025-09-26 07:09:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 4 925.59 MiB 3.01 MiB 860.47 MiB 231.40 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: 2025-09-26 07:00:00 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2 91.93 MiB 2.35 MiB 89.58 MiB 45.96 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: 2025-09-25 07:16:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2 26.00 MiB 3.09 MiB 22.91 MiB 13.00 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: 2025-09-25 07:07:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 84.38 MiB 28.70 MiB 55.69 MiB 42.19 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: 2025-09-26 07:00:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 1 823.88 MiB 823.88 MiB 823.88 MiB 823.88 MiB add constraint pk_eng_file_src_md5 primary key (file_src_md5);-
ADD CONSTRAINT pk_eng_file_src_md5 PRIMARY KEY (file_src_md5);
Date: 2025-09-23 06:56:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 16.18 MiB 16.18 MiB 16.18 MiB 16.18 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: 2025-09-24 07:07:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 44.00 MiB 44.00 MiB 44.00 MiB 44.00 MiB add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-25 07:15:10 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 57.36 MiB 57.36 MiB 57.36 MiB 57.36 MiB add constraint fk_history_obj_consult_action_num_id foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade;-
ADD CONSTRAINT fk_history_obj_consult_action_num_id FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE;
Date: 2025-09-26 07:09:56 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 826.04 MiB 826.04 MiB 826.04 MiB 826.04 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: 2025-09-26 06:56:59 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 330.86 MiB 330.86 MiB 330.86 MiB 330.86 MiB add constraint fk_gtp_monthly_history_unit foreign key (att_unit_num_id) references public.gtp_att_unit (att_unit_num_id);-
ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-09-24 07:03:45 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 108.02 MiB 108.02 MiB 108.02 MiB 108.02 MiB 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;-
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: 2025-09-24 07:05:01 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.17 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-26 06:56:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-25 07:02:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
3 1.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-23 06:56:43 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.15 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-24 06:57:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 860.47 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-09-25 07:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 826.04 MiB ADD CONSTRAINT pk_eng_gtp_datalink_objdid PRIMARY KEY (obj_num_id, eng_data_id);[ Date: 2025-09-26 06:56:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 823.88 MiB ADD CONSTRAINT pk_eng_file_src_md5 PRIMARY KEY (file_src_md5);[ Date: 2025-09-23 06:56:47 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 791.71 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-09-25 07:11:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 739.69 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-23 07:01:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 603.74 MiB ADD CONSTRAINT pk_log_ehcache PRIMARY KEY (log_ehcache_num_id);[ Date: 2025-09-25 07:12:49 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 516.30 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-26 07:01:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 485.34 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-26 07:06:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 478.80 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-24 07:00:38 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 474.62 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-09-23 07:03:11 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 474.45 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-25 07:10:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 464.16 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-09-26 07:05:07 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 451.24 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-09-24 07:04:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 348.30 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-09-23 07:00:49 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 330.86 MiB ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);[ Date: 2025-09-24 07:03:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 330.34 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-24 07:04:55 - 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
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Analyzes per table
Key values
- pg_catalog.pg_largeobject (1) Main table analyzed (database cnrs)
- 1 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 25 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 1 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 61 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 6 18s777ms 3s129ms relation 6 18s777ms 3s129ms ExclusiveLock 35 54s174ms 1s547ms extension 35 54s174ms 1s547ms RowExclusiveLock 1 3s167ms 3s167ms relation 1 3s167ms 3s167ms ShareLock 5 5s245ms 1s49ms relation 5 5s245ms 1s49ms ShareRowExclusiveLock 11 11s378ms 1s34ms relation 11 11s378ms 1s34ms ShareUpdateExclusiveLock 3 4s911ms 1s637ms relation 3 4s911ms 1s637ms Total 61 1m37s 1s600ms 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
- 7 Total read queries
- 178 Total write queries
Queries by database
Key values
- cnrs Main database
- 188 Requests
- 2h56m12s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 189 Requests
User Request type Count Duration a3dsupervisor Total 189 2h56m18s copy from 30 28m10s ddl 127 1h18m44s delete 6 45s808ms others 3 1h6m9s select 8 57s400ms tcl 15 1m31s Duration by user
Key values
- 2h56m18s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 189 2h56m18s copy from 30 28m10s ddl 127 1h18m44s delete 6 45s808ms others 3 1h6m9s select 8 57s400ms tcl 15 1m31s Queries by host
Key values
- 10.3.0.4 Main host
- 189 Requests
- 2h56m18s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 160 Requests
- 1h47m18s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-25 10:09:17 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 126 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 29m29s VACUUM ANALYSE;[ Date: 2025-09-25 08:35:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 27m1s VACUUM ANALYSE;[ Date: 2025-09-23 08:10:36 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 9m38s VACUUM ANALYSE;[ Date: 2025-09-26 07:47:23 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 2m32s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);[ Date: 2025-09-24 07:03:21 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 2m26s 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) FROM stdin;[ Date: 2025-09-24 06:55:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 2m24s 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) FROM stdin;[ Date: 2025-09-25 07:01:23 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 2m21s ALTER TABLE ONLY public.gtp_monthly_history 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: 2025-09-26 07:03:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 2m19s ALTER TABLE ONLY public.gtp_monthly_history;[ Date: 2025-09-24 07:07:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 2m17s 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: 2025-09-24 06:55:19 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 2m10s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-09-25 07:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 2m6s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-09-24 06:57:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 2m5s 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: 2025-09-26 07:00:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 2m3s 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: 2025-09-25 07:01:02 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 2m CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-09-24 06:57:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 1m57s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-09-25 07:02:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 1m51s 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: 2025-09-25 07:07:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 1m50s 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: 2025-09-25 07:09:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m44s 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) FROM stdin;[ Date: 2025-09-26 06:55:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m44s 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: 2025-09-26 06:55:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m39s 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) FROM stdin;[ Date: 2025-09-23 06:55:40 - 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 1h6m9s 3 9m38s 29m29s 22m3s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 10 1 27m1s 27m1s Sep 25 10 1 29m29s 29m29s Sep 26 09 1 9m38s 9m38s [ User: a3dsupervisor - Total duration: 1h6m9s - Times executed: 3 ]
[ Application: psql - Total duration: 1h6m9s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2025-09-25 08:35:50 Duration: 29m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-23 08:10:36 Duration: 27m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-26 07:47:23 Duration: 9m38s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 8m16s 4 1m39s 2m26s 2m4s 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) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 1m39s 1m39s Sep 24 08 1 2m26s 2m26s Sep 25 09 1 2m24s 2m24s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 8m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m16s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-09-24 06:55:29 Duration: 2m26s 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) FROM stdin;
Date: 2025-09-25 07:01:23 Duration: 2m24s 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) FROM stdin;
Date: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 7m23s 4 1m18s 2m17s 1m50s 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 #3
Day Hour Count Duration Avg duration Sep 23 08 1 1m18s 1m18s Sep 24 08 1 2m17s 2m17s Sep 25 09 1 2m3s 2m3s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m23s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 06:55:19 Duration: 2m17s 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: 2025-09-25 07:01:02 Duration: 2m3s 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: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 6m58s 4 1m25s 2m6s 1m44s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 08 1 1m25s 1m25s Sep 24 08 1 2m6s 2m6s Sep 25 09 1 1m57s 1m57s Sep 26 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 6m58s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m58s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-09-24 06:57:26 Duration: 2m6s 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: 2025-09-25 07:02:59 Duration: 1m57s 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: 2025-09-26 06:56:59 Duration: 1m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 6m43s 4 1m7s 2m10s 1m40s 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 #5
Day Hour Count Duration Avg duration Sep 23 08 1 1m7s 1m7s Sep 24 08 1 2m 2m Sep 25 09 1 2m10s 2m10s Sep 26 08 1 1m25s 1m25s [ User: a3dsupervisor - Total duration: 6m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m43s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-09-25 07:03:33 Duration: 2m10s 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: 2025-09-24 06:57:30 Duration: 2m 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: 2025-09-26 06:56:55 Duration: 1m25s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 6m25s 4 1m10s 2m5s 1m36s 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 #6
Day Hour Count Duration Avg duration Sep 23 08 1 1m10s 1m10s Sep 24 09 1 1m18s 1m18s Sep 25 09 1 1m51s 1m51s Sep 26 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 6m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m25s - 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: 2025-09-26 07:00:53 Duration: 2m5s 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: 2025-09-25 07:07:37 Duration: 1m51s 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: 2025-09-24 07:00:49 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 4m21s 4 53s213ms 1m36s 1m5s 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 Sep 23 09 1 1m36s 1m36s Sep 24 09 1 58s781ms 58s781ms Sep 25 09 1 53s214ms 53s214ms Sep 26 09 1 53s213ms 53s213ms [ User: a3dsupervisor - Total duration: 4m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-23 07:01:48 Duration: 1m36s 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: 2025-09-24 07:03:47 Duration: 58s781ms 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: 2025-09-25 07:11:29 Duration: 53s214ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 3m57s 2 1m35s 2m21s 1m58s alter table only public.gtp_monthly_history 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;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 25 09 1 1m35s 1m35s Sep 26 09 1 2m21s 2m21s [ User: a3dsupervisor - Total duration: 3m57s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m57s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history 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: 2025-09-26 07:03:14 Duration: 2m21s 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 FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-25 07:11:04 Duration: 1m35s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 3m48s 4 42s249ms 1m13s 57s200ms 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 #9
Day Hour Count Duration Avg duration Sep 23 09 1 1m13s 1m13s Sep 24 09 1 42s249ms 42s249ms Sep 25 09 1 49s280ms 49s280ms Sep 26 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 3m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m48s - Times executed: 4 ]
-
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: 2025-09-23 07:04:24 Duration: 1m13s 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: 2025-09-26 07:06:12 Duration: 1m3s 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: 2025-09-25 07:12:47 Duration: 49s280ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 3m44s 2 1m24s 2m19s 1m52s alter table only public.gtp_monthly_history;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 09 2 3m44s 1m52s [ User: a3dsupervisor - Total duration: 3m44s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m44s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-09-24 07:07:46 Duration: 2m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-09-24 07:09:17 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 3m44s 4 49s578ms 1m3s 56s10ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 49s578ms 49s578ms Sep 24 08 1 1m3s 1m3s Sep 25 09 1 59s131ms 59s131ms Sep 26 08 1 51s786ms 51s786ms [ User: a3dsupervisor - Total duration: 3m44s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m44s - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-24 06:59:35 Duration: 1m3s 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: 2025-09-25 07:05:59 Duration: 59s131ms 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: 2025-09-26 06:58:41 Duration: 51s786ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 3m15s 4 9s468ms 1m32s 48s907ms 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 #12
Day Hour Count Duration Avg duration Sep 23 09 1 9s468ms 9s468ms Sep 24 09 1 1m21s 1m21s Sep 25 09 1 1m32s 1m32s Sep 26 09 1 12s261ms 12s261ms [ User: a3dsupervisor - Total duration: 3m15s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m15s - 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: 2025-09-25 07:16:12 Duration: 1m32s 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: 2025-09-24 07:08:07 Duration: 1m21s 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: 2025-09-26 07:08:55 Duration: 12s261ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3m2s 3 5s943ms 1m50s 1m 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 Sep 23 08 1 5s943ms 5s943ms Sep 25 09 1 1m50s 1m50s Sep 26 09 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 3m2s - Times executed: 3 ]
-
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: 2025-09-25 07:09:28 Duration: 1m50s 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: 2025-09-26 07:04:20 Duration: 1m6s 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: 2025-09-23 06:59:50 Duration: 5s943ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 2m45s 3 5s840ms 2m32s 55s60ms alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_tab_id foreign key (histo_num_id_tab) references public.gtp_monthly_history (histo_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 09 1 5s840ms 5s840ms Sep 24 09 1 2m32s 2m32s Sep 25 09 1 6s734ms 6s734ms [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 2m45s - Times executed: 3 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-24 07:03:21 Duration: 2m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-25 07:13:20 Duration: 6s734ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-23 07:00:06 Duration: 5s840ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 2m38s 4 36s694ms 42s387ms 39s670ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 38s645ms 38s645ms Sep 24 08 1 36s694ms 36s694ms Sep 25 09 1 42s387ms 42s387ms Sep 26 08 1 40s952ms 40s952ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-25 07:05:45 Duration: 42s387ms 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: 2025-09-26 06:58:48 Duration: 40s952ms 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: 2025-09-23 06:58:33 Duration: 38s645ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2m37s 4 36s346ms 46s861ms 39s441ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 09 1 36s575ms 36s575ms Sep 24 09 1 46s861ms 46s861ms Sep 25 09 1 36s346ms 36s346ms Sep 26 09 1 37s981ms 37s981ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m37s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 07:01:39 Duration: 46s861ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-26 07:01:46 Duration: 37s981ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-23 07:00:28 Duration: 36s575ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2m30s 4 20s406ms 1m2s 37s683ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 1 20s406ms 20s406ms Sep 24 08 1 40s481ms 40s481ms Sep 25 09 1 1m2s 1m2s Sep 26 08 1 27s345ms 27s345ms [ User: a3dsupervisor - Total duration: 2m30s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m30s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-09-25 07:04:01 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: 2025-09-24 06:58:07 Duration: 40s481ms 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: 2025-09-26 06:57:22 Duration: 27s345ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2m29s 4 25s107ms 47s295ms 37s387ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 09 1 47s295ms 47s295ms Sep 24 09 1 46s653ms 46s653ms Sep 25 09 1 25s107ms 25s107ms Sep 26 09 1 30s492ms 30s492ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-23 07:03:11 Duration: 47s295ms 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: 2025-09-24 07:04:08 Duration: 46s653ms 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: 2025-09-26 07:05:08 Duration: 30s492ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2m29s 4 20s584ms 59s402ms 37s281ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 1 20s584ms 20s584ms Sep 24 08 1 36s607ms 36s607ms Sep 25 09 1 59s402ms 59s402ms Sep 26 08 1 32s532ms 32s532ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-09-25 07:04:33 Duration: 59s402ms 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: 2025-09-24 06:58:07 Duration: 36s607ms 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: 2025-09-26 06:57:31 Duration: 32s532ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2m16s 4 13s368ms 48s123ms 34s71ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 13s368ms 13s368ms Sep 24 09 1 48s123ms 48s123ms Sep 25 09 1 42s411ms 42s411ms Sep 26 08 1 32s380ms 32s380ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-24 07:00:25 Duration: 48s123ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-25 07:06:42 Duration: 42s411ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-26 06:59:14 Duration: 32s380ms 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 15 1m31s 5s65ms 7s724ms 6s86ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 25 20 5 29s549ms 5s909ms 21 4 25s127ms 6s281ms Sep 26 08 3 19s625ms 6s541ms 20 3 16s987ms 5s662ms [ User: a3dsupervisor - Total duration: 1m31s - Times executed: 15 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 1m24s - Times executed: 14 ]
[ Application: pg_restore - Total duration: 6s567ms - Times executed: 1 ]
-
COMMIT;
Date: 2025-09-25 19:52:27 Duration: 7s724ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-25 19:52:54 Duration: 7s227ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-26 06:59:42 Duration: 6s567ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 4 8m16s 1m39s 2m26s 2m4s 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) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 1m39s 1m39s Sep 24 08 1 2m26s 2m26s Sep 25 09 1 2m24s 2m24s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 8m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m16s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-09-24 06:55:29 Duration: 2m26s 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) FROM stdin;
Date: 2025-09-25 07:01:23 Duration: 2m24s 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) FROM stdin;
Date: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 4 7m23s 1m18s 2m17s 1m50s 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 #3
Day Hour Count Duration Avg duration Sep 23 08 1 1m18s 1m18s Sep 24 08 1 2m17s 2m17s Sep 25 09 1 2m3s 2m3s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m23s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 06:55:19 Duration: 2m17s 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: 2025-09-25 07:01:02 Duration: 2m3s 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: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 4 6m58s 1m25s 2m6s 1m44s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 08 1 1m25s 1m25s Sep 24 08 1 2m6s 2m6s Sep 25 09 1 1m57s 1m57s Sep 26 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 6m58s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m58s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-09-24 06:57:26 Duration: 2m6s 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: 2025-09-25 07:02:59 Duration: 1m57s 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: 2025-09-26 06:56:59 Duration: 1m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 4 6m43s 1m7s 2m10s 1m40s 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 #5
Day Hour Count Duration Avg duration Sep 23 08 1 1m7s 1m7s Sep 24 08 1 2m 2m Sep 25 09 1 2m10s 2m10s Sep 26 08 1 1m25s 1m25s [ User: a3dsupervisor - Total duration: 6m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m43s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-09-25 07:03:33 Duration: 2m10s 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: 2025-09-24 06:57:30 Duration: 2m 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: 2025-09-26 06:56:55 Duration: 1m25s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 4 6m25s 1m10s 2m5s 1m36s 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 #6
Day Hour Count Duration Avg duration Sep 23 08 1 1m10s 1m10s Sep 24 09 1 1m18s 1m18s Sep 25 09 1 1m51s 1m51s Sep 26 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 6m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m25s - 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: 2025-09-26 07:00:53 Duration: 2m5s 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: 2025-09-25 07:07:37 Duration: 1m51s 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: 2025-09-24 07:00:49 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 4 4m21s 53s213ms 1m36s 1m5s 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 Sep 23 09 1 1m36s 1m36s Sep 24 09 1 58s781ms 58s781ms Sep 25 09 1 53s214ms 53s214ms Sep 26 09 1 53s213ms 53s213ms [ User: a3dsupervisor - Total duration: 4m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-23 07:01:48 Duration: 1m36s 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: 2025-09-24 07:03:47 Duration: 58s781ms 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: 2025-09-25 07:11:29 Duration: 53s214ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 4 3m48s 42s249ms 1m13s 57s200ms 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 #8
Day Hour Count Duration Avg duration Sep 23 09 1 1m13s 1m13s Sep 24 09 1 42s249ms 42s249ms Sep 25 09 1 49s280ms 49s280ms Sep 26 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 3m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m48s - Times executed: 4 ]
-
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: 2025-09-23 07:04:24 Duration: 1m13s 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: 2025-09-26 07:06:12 Duration: 1m3s 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: 2025-09-25 07:12:47 Duration: 49s280ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 4 3m44s 49s578ms 1m3s 56s10ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 49s578ms 49s578ms Sep 24 08 1 1m3s 1m3s Sep 25 09 1 59s131ms 59s131ms Sep 26 08 1 51s786ms 51s786ms [ User: a3dsupervisor - Total duration: 3m44s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m44s - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-24 06:59:35 Duration: 1m3s 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: 2025-09-25 07:05:59 Duration: 59s131ms 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: 2025-09-26 06:58:41 Duration: 51s786ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 4 3m15s 9s468ms 1m32s 48s907ms 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 #10
Day Hour Count Duration Avg duration Sep 23 09 1 9s468ms 9s468ms Sep 24 09 1 1m21s 1m21s Sep 25 09 1 1m32s 1m32s Sep 26 09 1 12s261ms 12s261ms [ User: a3dsupervisor - Total duration: 3m15s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m15s - 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: 2025-09-25 07:16:12 Duration: 1m32s 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: 2025-09-24 07:08:07 Duration: 1m21s 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: 2025-09-26 07:08:55 Duration: 12s261ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 4 2m38s 36s694ms 42s387ms 39s670ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 38s645ms 38s645ms Sep 24 08 1 36s694ms 36s694ms Sep 25 09 1 42s387ms 42s387ms Sep 26 08 1 40s952ms 40s952ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-25 07:05:45 Duration: 42s387ms 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: 2025-09-26 06:58:48 Duration: 40s952ms 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: 2025-09-23 06:58:33 Duration: 38s645ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4 2m37s 36s346ms 46s861ms 39s441ms copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 09 1 36s575ms 36s575ms Sep 24 09 1 46s861ms 46s861ms Sep 25 09 1 36s346ms 36s346ms Sep 26 09 1 37s981ms 37s981ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m37s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 07:01:39 Duration: 46s861ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-26 07:01:46 Duration: 37s981ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-23 07:00:28 Duration: 36s575ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 4 2m30s 20s406ms 1m2s 37s683ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 20s406ms 20s406ms Sep 24 08 1 40s481ms 40s481ms Sep 25 09 1 1m2s 1m2s Sep 26 08 1 27s345ms 27s345ms [ User: a3dsupervisor - Total duration: 2m30s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m30s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-09-25 07:04:01 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: 2025-09-24 06:58:07 Duration: 40s481ms 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: 2025-09-26 06:57:22 Duration: 27s345ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 4 2m29s 25s107ms 47s295ms 37s387ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 09 1 47s295ms 47s295ms Sep 24 09 1 46s653ms 46s653ms Sep 25 09 1 25s107ms 25s107ms Sep 26 09 1 30s492ms 30s492ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-23 07:03:11 Duration: 47s295ms 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: 2025-09-24 07:04:08 Duration: 46s653ms 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: 2025-09-26 07:05:08 Duration: 30s492ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 2m29s 20s584ms 59s402ms 37s281ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 20s584ms 20s584ms Sep 24 08 1 36s607ms 36s607ms Sep 25 09 1 59s402ms 59s402ms Sep 26 08 1 32s532ms 32s532ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-09-25 07:04:33 Duration: 59s402ms 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: 2025-09-24 06:58:07 Duration: 36s607ms 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: 2025-09-26 06:57:31 Duration: 32s532ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4 2m16s 13s368ms 48s123ms 34s71ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 13s368ms 13s368ms Sep 24 09 1 48s123ms 48s123ms Sep 25 09 1 42s411ms 42s411ms Sep 26 08 1 32s380ms 32s380ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-24 07:00:25 Duration: 48s123ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-25 07:06:42 Duration: 42s411ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-26 06:59:14 Duration: 32s380ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 4 2m1s 22s753ms 35s941ms 30s263ms copy public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) from stdin;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 09 1 22s753ms 22s753ms Sep 24 09 1 35s941ms 35s941ms Sep 25 09 1 32s114ms 32s114ms Sep 26 09 1 30s243ms 30s243ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m1s - Times executed: 4 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-09-24 07:06:19 Duration: 35s941ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-09-25 07:14:09 Duration: 32s114ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) FROM stdin;
Date: 2025-09-26 07:08:12 Duration: 30s243ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 4 1m49s 9s887ms 1m17s 27s254ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 09 1 1m17s 1m17s Sep 24 09 1 11s547ms 11s547ms Sep 25 09 1 10s535ms 10s535ms Sep 26 09 1 9s887ms 9s887ms [ User: a3dsupervisor - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m49s - Times executed: 4 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-23 07:02:06 Duration: 1m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-24 07:02:16 Duration: 11s547ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-25 07:10:11 Duration: 10s535ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 4 1m46s 21s538ms 30s288ms 26s722ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 09 1 21s538ms 21s538ms Sep 24 09 1 25s265ms 25s265ms Sep 25 09 1 29s796ms 29s796ms Sep 26 09 1 30s288ms 30s288ms [ User: a3dsupervisor - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m46s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-26 07:08:43 Duration: 30s288ms 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: 2025-09-25 07:14:39 Duration: 29s796ms 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: 2025-09-24 07:06:45 Duration: 25s265ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 4 1m44s 23s190ms 30s495ms 26s202ms create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 26s481ms 26s481ms Sep 24 08 1 24s644ms 24s644ms Sep 25 09 1 30s495ms 30s495ms Sep 26 08 1 23s190ms 23s190ms [ User: a3dsupervisor - Total duration: 1m44s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 1m44s - Times executed: 4 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-09-25 07:04:32 Duration: 30s495ms 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: 2025-09-23 06:57:31 Duration: 26s481ms 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: 2025-09-24 06:58:31 Duration: 24s644ms 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 9m38s 29m29s 22m3s 3 1h6m9s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 10 1 27m1s 27m1s Sep 25 10 1 29m29s 29m29s Sep 26 09 1 9m38s 9m38s [ User: a3dsupervisor - Total duration: 1h6m9s - Times executed: 3 ]
[ Application: psql - Total duration: 1h6m9s - Times executed: 3 ]
-
VACUUM ANALYSE;
Date: 2025-09-25 08:35:50 Duration: 29m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-23 08:10:36 Duration: 27m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-09-26 07:47:23 Duration: 9m38s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m39s 2m26s 2m4s 4 8m16s 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) from stdin;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 1m39s 1m39s Sep 24 08 1 2m26s 2m26s Sep 25 09 1 2m24s 2m24s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 8m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 8m16s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-09-24 06:55:29 Duration: 2m26s 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) FROM stdin;
Date: 2025-09-25 07:01:23 Duration: 2m24s 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) FROM stdin;
Date: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m35s 2m21s 1m58s 2 3m57s alter table only public.gtp_monthly_history 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;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 25 09 1 1m35s 1m35s Sep 26 09 1 2m21s 2m21s [ User: a3dsupervisor - Total duration: 3m57s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m57s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history 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: 2025-09-26 07:03:14 Duration: 2m21s 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 FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-25 07:11:04 Duration: 1m35s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m24s 2m19s 1m52s 2 3m44s alter table only public.gtp_monthly_history;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 09 2 3m44s 1m52s [ User: a3dsupervisor - Total duration: 3m44s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m44s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-09-24 07:07:46 Duration: 2m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history;
Date: 2025-09-24 07:09:17 Duration: 1m24s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m18s 2m17s 1m50s 4 7m23s 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 #5
Day Hour Count Duration Avg duration Sep 23 08 1 1m18s 1m18s Sep 24 08 1 2m17s 2m17s Sep 25 09 1 2m3s 2m3s Sep 26 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 7m23s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m23s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-24 06:55:19 Duration: 2m17s 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: 2025-09-25 07:01:02 Duration: 2m3s 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: 2025-09-26 06:55:30 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m25s 2m6s 1m44s 4 6m58s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 08 1 1m25s 1m25s Sep 24 08 1 2m6s 2m6s Sep 25 09 1 1m57s 1m57s Sep 26 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 6m58s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m58s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-09-24 06:57:26 Duration: 2m6s 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: 2025-09-25 07:02:59 Duration: 1m57s 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: 2025-09-26 06:56:59 Duration: 1m29s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m7s 2m10s 1m40s 4 6m43s 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 #7
Day Hour Count Duration Avg duration Sep 23 08 1 1m7s 1m7s Sep 24 08 1 2m 2m Sep 25 09 1 2m10s 2m10s Sep 26 08 1 1m25s 1m25s [ User: a3dsupervisor - Total duration: 6m43s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m43s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-09-25 07:03:33 Duration: 2m10s 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: 2025-09-24 06:57:30 Duration: 2m 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: 2025-09-26 06:56:55 Duration: 1m25s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m10s 2m5s 1m36s 4 6m25s 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 #8
Day Hour Count Duration Avg duration Sep 23 08 1 1m10s 1m10s Sep 24 09 1 1m18s 1m18s Sep 25 09 1 1m51s 1m51s Sep 26 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 6m25s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m25s - 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: 2025-09-26 07:00:53 Duration: 2m5s 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: 2025-09-25 07:07:37 Duration: 1m51s 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: 2025-09-24 07:00:49 Duration: 1m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 53s213ms 1m36s 1m5s 4 4m21s 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 Sep 23 09 1 1m36s 1m36s Sep 24 09 1 58s781ms 58s781ms Sep 25 09 1 53s214ms 53s214ms Sep 26 09 1 53s213ms 53s213ms [ User: a3dsupervisor - Total duration: 4m21s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 4m21s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-23 07:01:48 Duration: 1m36s 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: 2025-09-24 07:03:47 Duration: 58s781ms 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: 2025-09-25 07:11:29 Duration: 53s214ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5s943ms 1m50s 1m 3 3m2s 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 #10
Day Hour Count Duration Avg duration Sep 23 08 1 5s943ms 5s943ms Sep 25 09 1 1m50s 1m50s Sep 26 09 1 1m6s 1m6s [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 3m2s - Times executed: 3 ]
-
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: 2025-09-25 07:09:28 Duration: 1m50s 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: 2025-09-26 07:04:20 Duration: 1m6s 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: 2025-09-23 06:59:50 Duration: 5s943ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 42s249ms 1m13s 57s200ms 4 3m48s 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 #11
Day Hour Count Duration Avg duration Sep 23 09 1 1m13s 1m13s Sep 24 09 1 42s249ms 42s249ms Sep 25 09 1 49s280ms 49s280ms Sep 26 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 3m48s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m48s - Times executed: 4 ]
-
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: 2025-09-23 07:04:24 Duration: 1m13s 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: 2025-09-26 07:06:12 Duration: 1m3s 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: 2025-09-25 07:12:47 Duration: 49s280ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 49s578ms 1m3s 56s10ms 4 3m44s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 49s578ms 49s578ms Sep 24 08 1 1m3s 1m3s Sep 25 09 1 59s131ms 59s131ms Sep 26 08 1 51s786ms 51s786ms [ User: a3dsupervisor - Total duration: 3m44s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m44s - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-24 06:59:35 Duration: 1m3s 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: 2025-09-25 07:05:59 Duration: 59s131ms 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: 2025-09-26 06:58:41 Duration: 51s786ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5s840ms 2m32s 55s60ms 3 2m45s alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_tab_id foreign key (histo_num_id_tab) references public.gtp_monthly_history (histo_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 09 1 5s840ms 5s840ms Sep 24 09 1 2m32s 2m32s Sep 25 09 1 6s734ms 6s734ms [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 2m45s - Times executed: 3 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-24 07:03:21 Duration: 2m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-25 07:13:20 Duration: 6s734ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_tab_id FOREIGN KEY (histo_num_id_tab) REFERENCES public.gtp_monthly_history (histo_num_id);
Date: 2025-09-23 07:00:06 Duration: 5s840ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 9s468ms 1m32s 48s907ms 4 3m15s 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 #14
Day Hour Count Duration Avg duration Sep 23 09 1 9s468ms 9s468ms Sep 24 09 1 1m21s 1m21s Sep 25 09 1 1m32s 1m32s Sep 26 09 1 12s261ms 12s261ms [ User: a3dsupervisor - Total duration: 3m15s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m15s - 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: 2025-09-25 07:16:12 Duration: 1m32s 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: 2025-09-24 07:08:07 Duration: 1m21s 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: 2025-09-26 07:08:55 Duration: 12s261ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 36s694ms 42s387ms 39s670ms 4 2m38s alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 38s645ms 38s645ms Sep 24 08 1 36s694ms 36s694ms Sep 25 09 1 42s387ms 42s387ms Sep 26 08 1 40s952ms 40s952ms [ User: a3dsupervisor - Total duration: 2m38s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m38s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-09-25 07:05:45 Duration: 42s387ms 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: 2025-09-26 06:58:48 Duration: 40s952ms 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: 2025-09-23 06:58:33 Duration: 38s645ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 36s346ms 46s861ms 39s441ms 4 2m37s copy public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 09 1 36s575ms 36s575ms Sep 24 09 1 46s861ms 46s861ms Sep 25 09 1 36s346ms 36s346ms Sep 26 09 1 37s981ms 37s981ms [ User: a3dsupervisor - Total duration: 2m37s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m37s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-24 07:01:39 Duration: 46s861ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-26 07:01:46 Duration: 37s981ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) FROM stdin;
Date: 2025-09-23 07:00:28 Duration: 36s575ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 20s406ms 1m2s 37s683ms 4 2m30s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 1 20s406ms 20s406ms Sep 24 08 1 40s481ms 40s481ms Sep 25 09 1 1m2s 1m2s Sep 26 08 1 27s345ms 27s345ms [ User: a3dsupervisor - Total duration: 2m30s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m30s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-09-25 07:04:01 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: 2025-09-24 06:58:07 Duration: 40s481ms 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: 2025-09-26 06:57:22 Duration: 27s345ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 25s107ms 47s295ms 37s387ms 4 2m29s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 09 1 47s295ms 47s295ms Sep 24 09 1 46s653ms 46s653ms Sep 25 09 1 25s107ms 25s107ms Sep 26 09 1 30s492ms 30s492ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-23 07:03:11 Duration: 47s295ms 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: 2025-09-24 07:04:08 Duration: 46s653ms 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: 2025-09-26 07:05:08 Duration: 30s492ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 20s584ms 59s402ms 37s281ms 4 2m29s create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 1 20s584ms 20s584ms Sep 24 08 1 36s607ms 36s607ms Sep 25 09 1 59s402ms 59s402ms Sep 26 08 1 32s532ms 32s532ms [ User: a3dsupervisor - Total duration: 2m29s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m29s - Times executed: 4 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-09-25 07:04:33 Duration: 59s402ms 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: 2025-09-24 06:58:07 Duration: 36s607ms 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: 2025-09-26 06:57:31 Duration: 32s532ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 13s368ms 48s123ms 34s71ms 4 2m16s copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 13s368ms 13s368ms Sep 24 09 1 48s123ms 48s123ms Sep 25 09 1 42s411ms 42s411ms Sep 26 08 1 32s380ms 32s380ms [ User: a3dsupervisor - Total duration: 2m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 2m16s - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-24 07:00:25 Duration: 48s123ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-25 07:06:42 Duration: 42s411ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-09-26 06:59:14 Duration: 32s380ms 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
- 308,453 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 295516 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 194,101 Max number of times the same event was reported
- 295,516 Total events found
Rank Times reported Error 1 194,101 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 25 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,245 20 3,600 21 3,576 22 3,600 23 3,600 00 3,600 01 3,600 Sep 26 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,142 10 2,700 11 3,600 12 3,600 13 3,600 14 3,600 15 3,610 16 3,600 17 3,589 18 3,600 19 3,305 20 3,600 21 3,588 22 3,600 23 3,600 00 3,600 01 3,600 Sep 27 02 3,620 03 3,600 04 3,600 05 3,610 06 3,600 07 3,600 08 3,600 09 3,600 10 3,600 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 116 2 101,314 ERROR: operator does not exist: smallint = character varying
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 23 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,126 10 1,920 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,529 20 3,600 21 3,588 22 3,600 23 3,600 00 3,610 01 3,600 Sep 24 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,141 3 35 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 23 09 13 Sep 24 09 14 Sep 25 09 6 Sep 26 09 2 4 13 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 23 19 3 Sep 24 09 2 Sep 25 19 2 Sep 26 17 2 19 2 Sep 27 19 2 5 4 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect alp1_0.LOCK_KEY,alp1_0.LOCK_CREATOR,alp1_0.LOCK_DATE,alp1_0.LOCK_DURATION,alp1_0.LOCK_EXTENSIONS_NUMBER,alp1_0.LOCK_HOST_NAME,alp1_0.LOCK_INFORMATIONS,alp1_0.LOCK_NAME,alp1_0.LOCK_SESSION_ID,alp1_0.LOCK_TIMEOUT_DATE,alp1_0.LOCK_TYPE from APPLICATIVE_LOCK alp1_0 where alp1_0.LOCK_KEY=
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 24 08 2 Sep 25 21 2 6 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 #6
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 7 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 #7
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 8 3 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 #8
Day Hour Count Sep 23 09 1 Sep 24 09 1 Sep 26 09 1 9 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 #9
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 10 3 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 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 Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 12 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 #12
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 13 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 #13
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 14 3 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 23 09 1 Sep 25 10 1 Sep 26 09 1 15 3 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 16 3 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_old_qsp ADD CONSTRAINT fk_history_obj_old_qsp_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 23 09 1 Sep 24 09 1 Sep 26 09 1 17 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 #17
Day Hour Count Sep 23 10 1 Sep 25 10 1 Sep 26 09 1 18 2 LOG: process ... still waiting for AccessShareLock on relation ... of database ... after ... msselect glmp1_0.LOG_METRIC_NUM_ID,glmp1_0.LOG_DATE,glmp1_0.METRIC_AVERAGE_VALUE,glmp1_0.METRIC_MAX_VALUE,glmp1_0.METRIC_MIN_VALUE,glmp1_0.METRIC_NAME,glmp1_0.SERVER_ID from GTP_LOG_METRIC glmp1_0 where glmp1_0.LOG_DATE between and and (...)
Times Reported Most Frequent Error / Event #18
Day Hour Count Sep 25 20 1 Sep 26 20 1 19 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (...)
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 23 09 1 Sep 26 09 1 20 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msCREATE TRIGGER t_bef_ins_er_gtp_obj_compo BEFORE INSERT ON public.gtp_obj_composition FOR EACH ROW EXECUTE FUNCTION public.trigger_fct_t_bef_ins_er_gtp_obj_compo()
Times Reported Most Frequent Error / Event #20
Day Hour Count Sep 25 09 1 Sep 26 09 1 21 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history
Times Reported Most Frequent Error / Event #21
Day Hour Count Sep 24 09 1 Sep 25 09 1 22 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_consult ADD CONSTRAINT fk_history_obj_consult_action_num_id FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE
Times Reported Most Frequent Error / Event #22
Day Hour Count Sep 24 09 1 23 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (...) REFERENCES public.gtp_obj(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 26 09 1 24 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 #24
Day Hour Count Sep 26 09 1 25 1 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... msinsert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Sep 26 20 1 26 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_consult
Times Reported Most Frequent Error / Event #26
Day Hour Count Sep 26 09 1