pgBadger-
Global information
- Generated on Mon Oct 6 09:36:36 2025
- Log file: ././A3D-RND-PIC/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 901,599 log entries in 1m17s
- Log start from 2025-09-29 05:35:36 to 2025-10-04 17:00:56
-
Overview
Global Stats
- 81 Number of unique normalized queries
- 245 Number of queries
- 3h21m51s Total query duration
- 2025-09-29 06:11:33 First query
- 2025-10-04 00:01:35 Last query
- 3 queries/s at 2025-10-03 19:38:08 Query peak
- 3h21m51s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h21m51s Execute total duration
- 441,540 Number of events
- 26 Number of unique normalized events
- 441,409 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 779 Number temporary file
- 1.43 GiB Max size of temporary file
- 39.37 MiB Average size of temporary file
- 5,716 Total number of sessions
- 36 sessions at 2025-09-30 19:44:05 Session peak
- 16d34m10s Total duration of sessions
- 4m2s Average duration of sessions
- 0 Average queries per session
- 2s118ms Average queries duration per session
- 4m Average idle time per session
- 5,716 Total number of connections
- 11 connections/s at 2025-09-30 07:44:53 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-03 19:38:08 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-10-04 00:01:35 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-10-03 19:38:08 Date
Queries duration
Key values
- 3h21m51s 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 28 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Sep 29 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 20 0ms 1m44s 33s444ms 2m5s 2m42s 3m28s 07 31 0ms 1m53s 33s897ms 2m58s 3m29s 3m29s 08 1 0ms 20m48s 20m48s 0ms 0ms 20m48s 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 2 0ms 6s785ms 5s976ms 0ms 0ms 11s952ms 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 30 00 1 0ms 7s181ms 7s181ms 0ms 0ms 7s181ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 20 0ms 1m43s 46s79ms 2m 3m26s 4m27s 07 20 0ms 5m26s 45s702ms 1m36s 3m46s 5m26s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 6s264ms 6s264ms 0ms 0ms 6s264ms 19 2 0ms 5s269ms 5s222ms 0ms 0ms 10s444ms 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 Oct 01 00 1 0ms 7s115ms 7s115ms 0ms 0ms 7s115ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 23 0ms 2m24s 45s357ms 1m54s 3m12s 3m33s 07 17 0ms 6m47s 52s33ms 1m49s 1m51s 6m47s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 7s589ms 7s589ms 0ms 0ms 7s589ms 19 4 0ms 6s846ms 6s292ms 0ms 0ms 12s634ms 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 Oct 02 00 1 0ms 6s781ms 6s781ms 0ms 0ms 6s781ms 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 4 0ms 2m46s 1m24s 0ms 12s464ms 5m25s 07 39 0ms 2m46s 44s595ms 2m59s 3m11s 4m36s 08 1 0ms 15m4s 15m4s 0ms 0ms 15m4s 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 2 0ms 5s102ms 5s56ms 0ms 0ms 5s102ms 19 2 0ms 5s834ms 5s588ms 0ms 0ms 11s177ms 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 Oct 03 00 1 0ms 7s160ms 7s160ms 0ms 0ms 7s160ms 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 47s280ms 2m6s 3m1s 3m15s 07 26 0ms 9m16s 56s791ms 3m15s 3m30s 9m16s 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 1 0ms 5s174ms 5s174ms 0ms 0ms 5s174ms 19 7 0ms 9s288ms 6s64ms 0ms 0ms 37s342ms 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 Oct 04 00 1 0ms 7s210ms 7s210ms 0ms 0ms 7s210ms 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 28 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 29 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Sep 30 00 1 0 7s181ms 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 Oct 01 00 1 0 7s115ms 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 Oct 02 00 1 0 6s781ms 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 6s270ms 0ms 0ms 6s270ms 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 Oct 03 00 1 0 7s160ms 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 Oct 04 00 1 0 7s210ms 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 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 5 50s166ms 0ms 0ms 56s886ms 07 0 0 0 3 40s164ms 0ms 0ms 1m37s 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 30 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 6 1m1s 0ms 0ms 1m38s 07 0 0 0 1 41s140ms 0ms 0ms 41s140ms 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 Oct 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 6 55s568ms 0ms 0ms 1m28s 07 0 0 0 1 33s97ms 0ms 0ms 33s97ms 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 1 0 7s589ms 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 Oct 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 1 0 0 2 1m50s 0ms 0ms 5m25s 07 0 0 0 6 33s924ms 0ms 0ms 48s172ms 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 1 0 5s10ms 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 Oct 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 6 51s65ms 0ms 0ms 54s861ms 07 0 0 0 2 33s255ms 0ms 0ms 39s391ms 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 6s223ms 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 Oct 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 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 28 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 23 0 0 0.00 0.00% Sep 29 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 7 7.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 2 2.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 30 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 1 1.00 0.00% 19 0 2 2.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% Oct 01 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 1 1.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% Oct 02 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 2 2.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 2 2.00 0.00% 19 0 2 2.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% Oct 03 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 1 1.00 0.00% 19 0 7 7.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% Oct 04 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 28 00 1 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 23 2 0.00/s Sep 29 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 14 0.00/s 06 16 0.00/s 07 6 0.00/s 08 73 0.02/s 09 44 0.01/s 10 39 0.01/s 11 42 0.01/s 12 50 0.01/s 13 56 0.02/s 14 39 0.01/s 15 52 0.01/s 16 52 0.01/s 17 40 0.01/s 18 48 0.01/s 19 41 0.01/s 20 45 0.01/s 21 38 0.01/s 22 45 0.01/s 23 35 0.01/s Sep 30 00 46 0.01/s 01 46 0.01/s 02 44 0.01/s 03 42 0.01/s 04 41 0.01/s 05 43 0.01/s 06 17 0.00/s 07 47 0.01/s 08 44 0.01/s 09 48 0.01/s 10 40 0.01/s 11 41 0.01/s 12 36 0.01/s 13 64 0.02/s 14 45 0.01/s 15 51 0.01/s 16 35 0.01/s 17 41 0.01/s 18 36 0.01/s 19 52 0.01/s 20 48 0.01/s 21 47 0.01/s 22 35 0.01/s 23 50 0.01/s Oct 01 00 45 0.01/s 01 36 0.01/s 02 43 0.01/s 03 48 0.01/s 04 43 0.01/s 05 44 0.01/s 06 20 0.01/s 07 48 0.01/s 08 40 0.01/s 09 39 0.01/s 10 38 0.01/s 11 36 0.01/s 12 45 0.01/s 13 42 0.01/s 14 43 0.01/s 15 31 0.01/s 16 37 0.01/s 17 39 0.01/s 18 44 0.01/s 19 43 0.01/s 20 47 0.01/s 21 32 0.01/s 22 32 0.01/s 23 57 0.02/s Oct 02 00 43 0.01/s 01 33 0.01/s 02 44 0.01/s 03 33 0.01/s 04 36 0.01/s 05 33 0.01/s 06 26 0.01/s 07 7 0.00/s 08 80 0.02/s 09 43 0.01/s 10 58 0.02/s 11 51 0.01/s 12 49 0.01/s 13 58 0.02/s 14 52 0.01/s 15 50 0.01/s 16 55 0.02/s 17 32 0.01/s 18 48 0.01/s 19 46 0.01/s 20 48 0.01/s 21 48 0.01/s 22 47 0.01/s 23 52 0.01/s Oct 03 00 45 0.01/s 01 39 0.01/s 02 45 0.01/s 03 40 0.01/s 04 44 0.01/s 05 47 0.01/s 06 18 0.01/s 07 47 0.01/s 08 39 0.01/s 09 48 0.01/s 10 50 0.01/s 11 50 0.01/s 12 47 0.01/s 13 44 0.01/s 14 45 0.01/s 15 45 0.01/s 16 42 0.01/s 17 28 0.01/s 18 45 0.01/s 19 43 0.01/s 20 47 0.01/s 21 50 0.01/s 22 48 0.01/s 23 50 0.01/s Oct 04 00 41 0.01/s 01 43 0.01/s 02 45 0.01/s 03 43 0.01/s 04 46 0.01/s 05 44 0.01/s 06 41 0.01/s 07 53 0.01/s 08 47 0.01/s 09 41 0.01/s 10 40 0.01/s 11 44 0.01/s 12 48 0.01/s 13 43 0.01/s 14 31 0.01/s 15 48 0.01/s 16 45 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 28 00 1 68ms 68ms 01 2 76ms 76ms 02 2 73ms 73ms 03 2 70ms 70ms 04 2 73ms 73ms 05 2 71ms 71ms 06 2 74ms 74ms 07 2 72ms 72ms 08 2 74ms 74ms 09 2 80ms 80ms 10 2 74ms 74ms 11 2 75ms 75ms 12 2 73ms 73ms 13 2 70ms 70ms 14 2 72ms 72ms 15 2 69ms 69ms 16 2 78ms 78ms 17 2 80ms 80ms 18 2 73ms 73ms 19 2 71ms 71ms 20 2 73ms 73ms 21 2 76ms 76ms 23 2 73ms 73ms Sep 29 00 2 71ms 71ms 01 2 75ms 75ms 02 2 70ms 70ms 03 2 72ms 72ms 04 2 73ms 73ms 05 11 1m1s 1m1s 06 17 8m22s 7m43s 07 7 13m42s 11m12s 08 72 1m19s 1m1s 09 43 1m25s 1m25s 10 39 1m21s 1m21s 11 42 1m22s 1m22s 12 51 1m18s 1m18s 13 56 1m20s 1m20s 14 39 1m23s 1m23s 15 52 1m22s 1m22s 16 52 1m18s 1m18s 17 40 27m48s 27m48s 18 48 1m35s 1m35s 19 41 1m40s 1m40s 20 45 1m19s 1m19s 21 38 1m20s 1m20s 22 43 1m19s 1m19s 23 37 1m18s 1m18s Sep 30 00 43 1m27s 1m27s 01 49 1m15s 1m15s 02 44 1m16s 1m16s 03 40 1m21s 1m21s 04 43 1m21s 1m21s 05 42 1m14s 1m14s 06 18 1h28m4s 1h27m13s 07 47 2m37s 2m17s 08 44 1m17s 1m17s 09 48 1m21s 1m21s 10 40 1m16s 1m16s 11 41 1m19s 1m19s 12 36 1m26s 1m26s 13 64 1m16s 1m16s 14 45 1m23s 1m23s 15 49 1m20s 1m20s 16 37 1m21s 1m21s 17 41 28m14s 28m14s 18 36 1m56s 1m56s 19 52 1m32s 1m31s 20 48 1m17s 1m17s 21 47 1m17s 1m17s 22 35 1m26s 1m26s 23 50 1m18s 1m18s Oct 01 00 45 1m22s 1m22s 01 35 1m19s 1m19s 02 44 1m20s 1m20s 03 48 1m21s 1m21s 04 43 1m17s 1m17s 05 43 1m19s 1m19s 06 21 1h15m12s 1h14m22s 07 48 2m35s 2m16s 08 40 1m20s 1m20s 09 39 1m20s 1m20s 10 34 1m25s 1m25s 11 40 1m29s 1m29s 12 45 1m16s 1m16s 13 42 1m14s 1m14s 14 40 1m23s 1m23s 15 34 1m20s 1m20s 16 37 1m18s 1m18s 17 38 30m30s 30m30s 18 45 1m39s 1m38s 19 43 1m32s 1m32s 20 47 1m20s 1m20s 21 32 1m25s 1m25s 22 32 1m28s 1m28s 23 57 1m19s 1m19s Oct 02 00 42 1m24s 1m24s 01 34 1m25s 1m25s 02 44 1m19s 1m19s 03 33 1m26s 1m26s 04 35 1m18s 1m18s 05 34 1m25s 1m25s 06 26 1h1m15s 1h1m2s 07 8 13m17s 9m39s 08 75 1m40s 1m28s 09 45 2m22s 2m22s 10 59 1m57s 1m57s 11 51 2m12s 2m12s 12 49 2m9s 2m9s 13 58 1m57s 1m57s 14 52 2m12s 2m12s 15 50 2m9s 2m9s 16 55 2m8s 2m8s 17 33 32m58s 32m58s 18 48 1m38s 1m37s 19 46 1m34s 1m34s 20 48 1m20s 1m20s 21 48 1m18s 1m18s 22 47 1m21s 1m21s 23 52 1m16s 1m16s Oct 03 00 45 1m25s 1m25s 01 39 1m19s 1m19s 02 45 1m17s 1m17s 03 40 1m26s 1m26s 04 44 1m20s 1m20s 05 47 1m21s 1m21s 06 18 1h27m43s 1h27m 07 47 2m52s 2m21s 08 39 1m28s 1m28s 09 48 1m25s 1m25s 10 49 1m29s 1m29s 11 51 1m21s 1m21s 12 47 1m30s 1m30s 13 44 1m30s 1m30s 14 45 1m28s 1m28s 15 45 20m35s 20m35s 16 42 1m16s 1m16s 17 28 9m4s 9m4s 18 42 1m45s 1m45s 19 46 1m42s 1m41s 20 47 1m20s 1m20s 21 50 1m19s 1m19s 22 46 1m21s 1m21s 23 52 1m19s 1m19s Oct 04 00 41 1m31s 1m30s 01 41 1m24s 1m24s 02 47 1m23s 1m23s 03 43 1m20s 1m20s 04 46 1m20s 1m20s 05 44 1m23s 1m23s 06 41 1m17s 1m17s 07 53 1m20s 1m20s 08 46 1m14s 1m14s 09 42 1m21s 1m21s 10 40 1m21s 1m21s 11 44 1m21s 1m21s 12 48 1m17s 1m17s 13 43 1m16s 1m16s 14 31 1m23s 1m23s 15 48 1m18s 1m18s 16 45 1m18s 1m18s 17 4 11h50m15s 11h50m15s 18 2 83ms 83ms 19 2 78ms 78ms 20 2 76ms 76ms 21 2 78ms 78ms 22 2 74ms 74ms 23 2 74ms 74ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-09-30 07:44:53 Date
Connections per database
Key values
- cnrs Main Database
- 5,716 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 5,716 connections Total
-
Sessions
Simultaneous sessions
Key values
- 36 sessions Session Peak
- 2025-09-30 19:44:05 Date
Histogram of session times
Key values
- 5,119 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 5,716 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 5,716 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 5,716 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 766.62 MiB Temp Files size Peak
- 2025-10-02 07:06:38 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-10-02 07:15:28 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 23 0 0 0 Sep 29 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 29 2.18 GiB 76.88 MiB 07 123 3.76 GiB 31.33 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 30 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 54 3.22 GiB 61.04 MiB 07 98 2.83 GiB 29.56 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 Oct 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 69 3.69 GiB 54.69 MiB 07 91 2.41 GiB 27.10 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 Oct 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 145 6.04 GiB 42.67 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 Oct 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 53 2.99 GiB 57.74 MiB 07 115 2.83 GiB 25.21 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 Oct 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 15 6.97 GiB 86.14 MiB 1.43 GiB 476.07 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-10-03 06:55:54 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 15 696.03 MiB 27.70 MiB 88.31 MiB 46.40 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-10-03 07:00:01 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 4.48 GiB 129.30 MiB 933.66 MiB 305.51 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-10-03 07:03:15 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 733.99 MiB 15.03 MiB 486.47 MiB 48.93 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-10-03 07:00:07 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 607.73 MiB 8.70 MiB 113.85 MiB 40.52 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-10-03 07:08:43 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 15 3.49 GiB 197.14 MiB 271.32 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-10-03 06:59:24 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 15 2.36 GiB 35.31 MiB 471.59 MiB 160.88 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-10-03 07:01:28 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 13 778.70 MiB 47.72 MiB 158.98 MiB 59.90 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-10-02 07:16:49 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 13 1.46 GiB 11.71 MiB 451.54 MiB 114.70 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-10-03 07:08:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 11 2.45 GiB 47.88 MiB 630.29 MiB 228.10 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-10-03 07:04:57 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 8 74.41 MiB 2.24 MiB 25.95 MiB 9.30 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-10-03 06:59:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 7 35.53 MiB 2.62 MiB 8.45 MiB 5.08 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-10-03 07:00:15 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 2.28 GiB 6.00 MiB 863.65 MiB 466.07 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-10-03 06:55:58 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 185.38 MiB 11.03 MiB 61.27 MiB 37.08 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-10-03 06:59:36 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 13.61 MiB 1.98 MiB 7.16 MiB 3.40 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-10-03 07:00:16 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 2 30.69 MiB 9.39 MiB 21.30 MiB 15.34 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-10-02 07:15:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 46.60 MiB 11.82 MiB 34.78 MiB 23.30 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-10-02 07:15:56 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 5.67 MiB 5.67 MiB 5.67 MiB 5.67 MiB add constraint fk_gtp_obj_rel_vt_rel foreign key (relation_num_id) references public.gtp_relation (relation_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_rel_vt_rel FOREIGN KEY (relation_num_id) REFERENCES public.gtp_relation (relation_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-02 07:05:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 19.49 MiB 19.49 MiB 19.49 MiB 19.49 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-09-30 07:06:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 826.27 MiB 826.27 MiB 826.27 MiB 826.27 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-10-02 07:01:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 60.25 MiB 60.25 MiB 60.25 MiB 60.25 MiB add constraint fk_history_doc_deleted_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_doc_deleted_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-09-29 07:08:20 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.43 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-01 06:53:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.17 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-02 07:01:04 - 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-30 06:54:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-10-03 06:55:54 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 1.15 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-09-29 06:56:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 933.66 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-09-30 07:00:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 863.65 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-03 06:55:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 860.74 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-09-30 06:54:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 826.27 MiB ADD CONSTRAINT pk_eng_gtp_datalink_objdid PRIMARY KEY (obj_num_id, eng_data_id);[ Date: 2025-10-02 07:01:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 786.53 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-03 07:03:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 630.29 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-01 07:02:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 570.00 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-10-01 06:53:52 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 525.07 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-03 07:04:57 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 522.26 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-10-02 07:12:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 486.47 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-09-30 07:02:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 471.59 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-01 06:59:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 470.88 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-02 07:08:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 466.75 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-10-03 07:01:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 459.16 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-09-29 07:03:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 457.02 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-10-01 07:01:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 23 0 0 Sep 29 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 30 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 Oct 01 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 02 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 Oct 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 60 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 1 1s 1s relation 1 1s 1s AccessShareLock 4 7s18ms 1s754ms relation 4 7s18ms 1s754ms ExclusiveLock 21 27s222ms 1s296ms extension 21 27s222ms 1s296ms RowExclusiveLock 6 12s552ms 2s92ms relation 6 12s552ms 2s92ms ShareLock 8 13s689ms 1s711ms relation 8 13s689ms 1s711ms ShareRowExclusiveLock 15 24s519ms 1s634ms relation 15 24s519ms 1s634ms ShareUpdateExclusiveLock 5 5s222ms 1s44ms relation 5 5s222ms 1s44ms Total 60 1m31s 1s520ms 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
- 6 Total read queries
- 234 Total write queries
Queries by database
Key values
- cnrs Main database
- 245 Requests
- 3h21m51s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 246 Requests
User Request type Count Duration a3dsupervisor Total 246 3h21m59s copy from 38 34m53s ddl 166 1h45m49s delete 8 49s941ms insert 2 11s808ms others 5 57m23s select 7 48s929ms tcl 20 2m1s Duration by user
Key values
- 3h21m59s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 246 3h21m59s copy from 38 34m53s ddl 166 1h45m49s delete 8 49s941ms insert 2 11s808ms others 5 57m23s select 7 48s929ms tcl 20 2m1s Queries by host
Key values
- 10.3.0.4 Main host
- 246 Requests
- 3h21m59s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 204 Requests
- 2h20m42s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-10-02 12:49:27 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 162 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 20m48s VACUUM ANALYSE;[ Date: 2025-09-29 08:02:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 15m4s VACUUM ANALYSE;[ Date: 2025-10-02 08:04:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 9m16s VACUUM ANALYSE;[ Date: 2025-10-03 07:50:21 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 6m47s VACUUM ANALYSE;[ Date: 2025-10-01 07:42:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 5m26s VACUUM ANALYSE;[ Date: 2025-09-30 07:43:32 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 2m46s 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-10-02 06:58:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 2m46s 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-10-02 07:06:38 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 2m45s 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-10-02 07:09:24 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 2m39s 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-10-02 06:58:43 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 2m24s 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-10-01 06:57:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 2m21s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-10-02 07:01:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 2m14s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-10-02 07:01:05 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 2m10s 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-10-01 06:59:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 2m5s 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-10-03 07:01:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 2m3s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-03 07:06:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 1m53s ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-09-29 07:05:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 1m53s 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-30 07:00:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m48s ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-10-02 07:16:57 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 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-29 06:55:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m44s 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-29 07:00:17 - 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 57m23s 5 5m26s 20m48s 11m28s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 10 1 20m48s 20m48s Sep 30 09 1 5m26s 5m26s Oct 01 09 1 6m47s 6m47s Oct 02 10 1 15m4s 15m4s Oct 03 09 1 9m16s 9m16s [ User: a3dsupervisor - Total duration: 57m23s - Times executed: 5 ]
[ Application: psql - Total duration: 57m23s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-29 08:02:37 Duration: 20m48s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 08:04:29 Duration: 15m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 07:50:21 Duration: 9m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 10m4s 5 1m34s 2m46s 2m 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 #2
Day Hour Count Duration Avg duration Sep 29 09 1 1m44s 1m44s Sep 30 08 1 1m34s 1m34s Oct 01 08 1 2m24s 2m24s Oct 02 09 1 2m46s 2m46s Oct 03 08 1 1m35s 1m35s [ User: a3dsupervisor - Total duration: 10m4s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m4s - Times executed: 5 ]
-
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-10-02 07:06:38 Duration: 2m46s 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-10-01 06:57:44 Duration: 2m24s 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-29 07:00:17 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 9m37s 5 1m39s 2m46s 1m55s 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 #3
Day Hour Count Duration Avg duration Sep 29 08 1 1m44s 1m44s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m39s 1m39s Oct 02 08 1 2m46s 2m46s Oct 03 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m37s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-10-02 06:58:50 Duration: 2m46s 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-29 06:55:25 Duration: 1m44s 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-10-03 06:54:32 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 9m6s 5 1m28s 2m39s 1m49s 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 #4
Day Hour Count Duration Avg duration Sep 29 08 1 1m43s 1m43s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m28s 1m28s Oct 02 08 1 2m39s 2m39s Oct 03 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 9m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m6s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-02 06:58:43 Duration: 2m39s 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-29 06:55:24 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-30 06:52:28 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 8m28s 5 1m23s 2m14s 1m41s 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 29 08 1 1m23s 1m23s Sep 30 08 1 1m40s 1m40s Oct 01 08 1 1m44s 1m44s Oct 02 09 1 2m14s 2m14s Oct 03 08 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 8m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m28s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m14s 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-10-01 06:53:52 Duration: 1m44s 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-30 06:54:09 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 8m20s 5 1m19s 2m21s 1m40s 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 29 08 1 1m19s 1m19s Sep 30 08 1 1m37s 1m37s Oct 01 08 1 1m27s 1m27s Oct 02 09 1 2m21s 2m21s Oct 03 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m21s 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-30 06:54:05 Duration: 1m37s 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-10-03 06:55:54 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 6m44s 5 55s95ms 1m53s 1m20s 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 29 09 1 1m43s 1m43s Sep 30 09 1 1m53s 1m53s Oct 01 09 1 55s95ms 55s95ms Oct 02 09 1 1m11s 1m11s Oct 03 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 6m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m44s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-30 07:00:25 Duration: 1m53s 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-29 07:03:20 Duration: 1m43s 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-10-02 07:10:12 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6m 4 5s575ms 2m45s 1m30s 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 29 09 1 5s575ms 5s575ms Oct 01 08 1 2m10s 2m10s Oct 02 09 1 2m45s 2m45s Oct 03 09 1 58s141ms 58s141ms [ User: a3dsupervisor - Total duration: 6m - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m - Times executed: 4 ]
-
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-10-02 07:09:24 Duration: 2m45s 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-10-01 06:59:55 Duration: 2m10s 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-10-03 07:02:28 Duration: 58s141ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5m52s 5 45s404ms 1m48s 1m10s 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 #9
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 45s404ms 45s404ms Oct 01 09 1 1m9s 1m9s Oct 02 09 1 1m48s 1m48s Oct 03 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 5m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m52s - Times executed: 5 ]
-
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-10-02 07:16:57 Duration: 1m48s 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-10-01 07:05:45 Duration: 1m9s 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-29 07:06:45 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5m16s 5 47s583ms 1m32s 1m3s 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 #10
Day Hour Count Duration Avg duration Sep 29 09 1 1m32s 1m32s Sep 30 09 1 53s646ms 53s646ms Oct 01 09 1 1m1s 1m1s Oct 02 09 1 1m1s 1m1s Oct 03 09 1 47s583ms 47s583ms [ User: a3dsupervisor - Total duration: 5m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-09-29 07:06:39 Duration: 1m32s 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-10-02 07:12:32 Duration: 1m1s 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-10-01 07:02:39 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 4m51s 5 14s220ms 2m5s 58s234ms 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 #11
Day Hour Count Duration Avg duration Sep 29 09 1 14s220ms 14s220ms Sep 30 08 1 34s593ms 34s593ms Oct 01 09 1 54s624ms 54s624ms Oct 02 09 1 1m2s 1m2s Oct 03 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 4m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-03 07:01:30 Duration: 2m5s 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-10-02 07:10:27 Duration: 1m2s 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-10-01 07:00:49 Duration: 54s624ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4m40s 5 54s662ms 57s699ms 56s81ms 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 29 08 1 56s886ms 56s886ms Sep 30 08 1 57s699ms 57s699ms Oct 01 08 1 54s662ms 54s662ms Oct 02 09 1 56s296ms 56s296ms Oct 03 08 1 54s861ms 54s861ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-30 06:56:07 Duration: 57s699ms 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-29 06:58:40 Duration: 56s886ms 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-10-02 07:04:07 Duration: 56s296ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 3m58s 5 25s554ms 1m53s 47s728ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 09 1 1m53s 1m53s Sep 30 09 1 35s78ms 35s78ms Oct 01 09 1 27s998ms 27s998ms Oct 02 09 1 36s787ms 36s787ms Oct 03 09 1 25s554ms 25s554ms [ User: a3dsupervisor - Total duration: 3m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m58s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-29 07:05:39 Duration: 1m53s 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-10-02 07:15:09 Duration: 36s787ms 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-30 07:05:19 Duration: 35s78ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3m36s 5 33s889ms 58s102ms 43s309ms 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 29 09 1 58s102ms 58s102ms Sep 30 09 1 33s889ms 33s889ms Oct 01 09 1 34s303ms 34s303ms Oct 02 09 1 45s948ms 45s948ms Oct 03 09 1 44s302ms 44s302ms [ User: a3dsupervisor - Total duration: 3m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m36s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-29 07:05:06 Duration: 58s102ms 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-10-02 07:11:30 Duration: 45s948ms 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-10-03 07:04:06 Duration: 44s302ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 3m23s 5 36s953ms 49s519ms 40s753ms 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 #15
Day Hour Count Duration Avg duration Sep 29 09 1 49s519ms 49s519ms Sep 30 08 1 36s959ms 36s959ms Oct 01 08 1 36s953ms 36s953ms Oct 02 09 1 40s944ms 40s944ms Oct 03 09 1 39s391ms 39s391ms [ User: a3dsupervisor - Total duration: 3m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m23s - Times executed: 5 ]
-
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-29 07:01:59 Duration: 49s519ms 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-10-02 07:07:53 Duration: 40s944ms 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-10-03 07:01:04 Duration: 39s391ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3m19s 5 9s543ms 1m27s 39s940ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 09 1 1m20s 1m20s Sep 30 09 1 1m27s 1m27s Oct 01 08 1 9s543ms 9s543ms Oct 02 09 1 11s192ms 11s192ms Oct 03 09 1 11s394ms 11s394ms [ User: a3dsupervisor - Total duration: 3m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m19s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-30 07:00:54 Duration: 1m27s 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-29 07:03:46 Duration: 1m20s 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-10-03 07:01:40 Duration: 11s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 3m17s 5 27s118ms 48s172ms 39s403ms 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 29 09 1 47s486ms 47s486ms Sep 30 09 1 41s140ms 41s140ms Oct 01 09 1 33s97ms 33s97ms Oct 02 09 1 48s172ms 48s172ms Oct 03 09 1 27s118ms 27s118ms [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m17s - Times executed: 5 ]
-
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-10-02 07:14:32 Duration: 48s172ms 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-29 07:01:37 Duration: 47s486ms 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-30 07:04:43 Duration: 41s140ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 3m16s 5 5s96ms 1m5s 39s219ms alter table only public.gtp_monthly_history 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 5s96ms 5s96ms Oct 01 09 1 44s194ms 44s194ms Oct 02 09 1 1m 1m Oct 03 09 1 20s213ms 20s213ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history 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-29 07:09:34 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-02 07:17:05 Duration: 1m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-01 07:06:03 Duration: 44s194ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 3m7s 5 36s295ms 39s133ms 37s574ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 38s101ms 38s101ms Sep 30 08 1 37s401ms 37s401ms Oct 01 08 1 36s295ms 36s295ms Oct 02 09 1 39s133ms 39s133ms Oct 03 08 1 36s941ms 36s941ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-02 07:03:52 Duration: 39s133ms 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-29 06:58:33 Duration: 38s101ms 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-30 06:55:59 Duration: 37s401ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2m58s 5 21s450ms 1m8s 35s718ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 26s822ms 26s822ms Sep 30 08 1 34s402ms 34s402ms Oct 01 08 1 21s450ms 21s450ms Oct 02 09 1 1m8s 1m8s Oct 03 08 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-10-02 07:02:14 Duration: 1m8s 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-30 06:54:40 Duration: 34s402ms 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-10-03 06:56:22 Duration: 27s772ms 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 20 2m1s 5s102ms 8s20ms 6s95ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 08 6 41s507ms 6s917ms 20 2 11s952ms 5s976ms Sep 30 20 1 6s264ms 6s264ms 21 2 10s444ms 5s222ms Oct 01 21 4 25s171ms 6s292ms Oct 02 20 1 5s102ms 5s102ms 21 2 11s177ms 5s588ms Oct 03 20 1 5s174ms 5s174ms 21 1 5s106ms 5s106ms [ User: a3dsupervisor - Total duration: 2m1s - Times executed: 20 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 2m1s - Times executed: 20 ]
-
COMMIT;
Date: 2025-09-29 06:12:50 Duration: 8s20ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 06:11:34 Duration: 7s292ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-09-29 06:12:11 Duration: 7s136ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 57m23s 5m26s 20m48s 11m28s vacuum analyse;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 10 1 20m48s 20m48s Sep 30 09 1 5m26s 5m26s Oct 01 09 1 6m47s 6m47s Oct 02 10 1 15m4s 15m4s Oct 03 09 1 9m16s 9m16s [ User: a3dsupervisor - Total duration: 57m23s - Times executed: 5 ]
[ Application: psql - Total duration: 57m23s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-29 08:02:37 Duration: 20m48s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 08:04:29 Duration: 15m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 07:50:21 Duration: 9m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
3 5 10m4s 1m34s 2m46s 2m alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 29 09 1 1m44s 1m44s Sep 30 08 1 1m34s 1m34s Oct 01 08 1 2m24s 2m24s Oct 02 09 1 2m46s 2m46s Oct 03 08 1 1m35s 1m35s [ User: a3dsupervisor - Total duration: 10m4s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m4s - Times executed: 5 ]
-
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-10-02 07:06:38 Duration: 2m46s 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-10-01 06:57:44 Duration: 2m24s 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-29 07:00:17 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 5 9m37s 1m39s 2m46s 1m55s 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 #4
Day Hour Count Duration Avg duration Sep 29 08 1 1m44s 1m44s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m39s 1m39s Oct 02 08 1 2m46s 2m46s Oct 03 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m37s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-10-02 06:58:50 Duration: 2m46s 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-29 06:55:25 Duration: 1m44s 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-10-03 06:54:32 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 5 9m6s 1m28s 2m39s 1m49s 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 29 08 1 1m43s 1m43s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m28s 1m28s Oct 02 08 1 2m39s 2m39s Oct 03 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 9m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m6s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-02 06:58:43 Duration: 2m39s 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-29 06:55:24 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-30 06:52:28 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5 8m28s 1m23s 2m14s 1m41s 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 #6
Day Hour Count Duration Avg duration Sep 29 08 1 1m23s 1m23s Sep 30 08 1 1m40s 1m40s Oct 01 08 1 1m44s 1m44s Oct 02 09 1 2m14s 2m14s Oct 03 08 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 8m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m28s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m14s 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-10-01 06:53:52 Duration: 1m44s 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-30 06:54:09 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5 8m20s 1m19s 2m21s 1m40s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 08 1 1m19s 1m19s Sep 30 08 1 1m37s 1m37s Oct 01 08 1 1m27s 1m27s Oct 02 09 1 2m21s 2m21s Oct 03 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m21s 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-30 06:54:05 Duration: 1m37s 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-10-03 06:55:54 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 6m44s 55s95ms 1m53s 1m20s 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 #8
Day Hour Count Duration Avg duration Sep 29 09 1 1m43s 1m43s Sep 30 09 1 1m53s 1m53s Oct 01 09 1 55s95ms 55s95ms Oct 02 09 1 1m11s 1m11s Oct 03 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 6m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m44s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-30 07:00:25 Duration: 1m53s 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-29 07:03:20 Duration: 1m43s 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-10-02 07:10:12 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 5m52s 45s404ms 1m48s 1m10s 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 #9
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 45s404ms 45s404ms Oct 01 09 1 1m9s 1m9s Oct 02 09 1 1m48s 1m48s Oct 03 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 5m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m52s - Times executed: 5 ]
-
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-10-02 07:16:57 Duration: 1m48s 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-10-01 07:05:45 Duration: 1m9s 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-29 07:06:45 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 5m16s 47s583ms 1m32s 1m3s 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 #10
Day Hour Count Duration Avg duration Sep 29 09 1 1m32s 1m32s Sep 30 09 1 53s646ms 53s646ms Oct 01 09 1 1m1s 1m1s Oct 02 09 1 1m1s 1m1s Oct 03 09 1 47s583ms 47s583ms [ User: a3dsupervisor - Total duration: 5m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-09-29 07:06:39 Duration: 1m32s 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-10-02 07:12:32 Duration: 1m1s 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-10-01 07:02:39 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 4m51s 14s220ms 2m5s 58s234ms 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 #11
Day Hour Count Duration Avg duration Sep 29 09 1 14s220ms 14s220ms Sep 30 08 1 34s593ms 34s593ms Oct 01 09 1 54s624ms 54s624ms Oct 02 09 1 1m2s 1m2s Oct 03 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 4m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-03 07:01:30 Duration: 2m5s 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-10-02 07:10:27 Duration: 1m2s 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-10-01 07:00:49 Duration: 54s624ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 4m40s 54s662ms 57s699ms 56s81ms 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 29 08 1 56s886ms 56s886ms Sep 30 08 1 57s699ms 57s699ms Oct 01 08 1 54s662ms 54s662ms Oct 02 09 1 56s296ms 56s296ms Oct 03 08 1 54s861ms 54s861ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-30 06:56:07 Duration: 57s699ms 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-29 06:58:40 Duration: 56s886ms 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-10-02 07:04:07 Duration: 56s296ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 3m58s 25s554ms 1m53s 47s728ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 09 1 1m53s 1m53s Sep 30 09 1 35s78ms 35s78ms Oct 01 09 1 27s998ms 27s998ms Oct 02 09 1 36s787ms 36s787ms Oct 03 09 1 25s554ms 25s554ms [ User: a3dsupervisor - Total duration: 3m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m58s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-29 07:05:39 Duration: 1m53s 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-10-02 07:15:09 Duration: 36s787ms 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-30 07:05:19 Duration: 35s78ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 3m36s 33s889ms 58s102ms 43s309ms 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 29 09 1 58s102ms 58s102ms Sep 30 09 1 33s889ms 33s889ms Oct 01 09 1 34s303ms 34s303ms Oct 02 09 1 45s948ms 45s948ms Oct 03 09 1 44s302ms 44s302ms [ User: a3dsupervisor - Total duration: 3m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m36s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-29 07:05:06 Duration: 58s102ms 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-10-02 07:11:30 Duration: 45s948ms 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-10-03 07:04:06 Duration: 44s302ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 3m23s 36s953ms 49s519ms 40s753ms 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 #15
Day Hour Count Duration Avg duration Sep 29 09 1 49s519ms 49s519ms Sep 30 08 1 36s959ms 36s959ms Oct 01 08 1 36s953ms 36s953ms Oct 02 09 1 40s944ms 40s944ms Oct 03 09 1 39s391ms 39s391ms [ User: a3dsupervisor - Total duration: 3m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m23s - Times executed: 5 ]
-
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-29 07:01:59 Duration: 49s519ms 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-10-02 07:07:53 Duration: 40s944ms 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-10-03 07:01:04 Duration: 39s391ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 3m19s 9s543ms 1m27s 39s940ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 09 1 1m20s 1m20s Sep 30 09 1 1m27s 1m27s Oct 01 08 1 9s543ms 9s543ms Oct 02 09 1 11s192ms 11s192ms Oct 03 09 1 11s394ms 11s394ms [ User: a3dsupervisor - Total duration: 3m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m19s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-30 07:00:54 Duration: 1m27s 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-29 07:03:46 Duration: 1m20s 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-10-03 07:01:40 Duration: 11s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 3m17s 27s118ms 48s172ms 39s403ms 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 29 09 1 47s486ms 47s486ms Sep 30 09 1 41s140ms 41s140ms Oct 01 09 1 33s97ms 33s97ms Oct 02 09 1 48s172ms 48s172ms Oct 03 09 1 27s118ms 27s118ms [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m17s - Times executed: 5 ]
-
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-10-02 07:14:32 Duration: 48s172ms 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-29 07:01:37 Duration: 47s486ms 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-30 07:04:43 Duration: 41s140ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 3m16s 5s96ms 1m5s 39s219ms alter table only public.gtp_monthly_history 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 5s96ms 5s96ms Oct 01 09 1 44s194ms 44s194ms Oct 02 09 1 1m 1m Oct 03 09 1 20s213ms 20s213ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history 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-29 07:09:34 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-02 07:17:05 Duration: 1m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-01 07:06:03 Duration: 44s194ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 3m7s 36s295ms 39s133ms 37s574ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 38s101ms 38s101ms Sep 30 08 1 37s401ms 37s401ms Oct 01 08 1 36s295ms 36s295ms Oct 02 09 1 39s133ms 39s133ms Oct 03 08 1 36s941ms 36s941ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-02 07:03:52 Duration: 39s133ms 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-29 06:58:33 Duration: 38s101ms 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-30 06:55:59 Duration: 37s401ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 2m58s 21s450ms 1m8s 35s718ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 26s822ms 26s822ms Sep 30 08 1 34s402ms 34s402ms Oct 01 08 1 21s450ms 21s450ms Oct 02 09 1 1m8s 1m8s Oct 03 08 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-10-02 07:02:14 Duration: 1m8s 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-30 06:54:40 Duration: 34s402ms 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-10-03 06:56:22 Duration: 27s772ms 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 5m26s 20m48s 11m28s 5 57m23s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 29 10 1 20m48s 20m48s Sep 30 09 1 5m26s 5m26s Oct 01 09 1 6m47s 6m47s Oct 02 10 1 15m4s 15m4s Oct 03 09 1 9m16s 9m16s [ User: a3dsupervisor - Total duration: 57m23s - Times executed: 5 ]
[ Application: psql - Total duration: 57m23s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-09-29 08:02:37 Duration: 20m48s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-02 08:04:29 Duration: 15m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-10-03 07:50:21 Duration: 9m16s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m34s 2m46s 2m 5 10m4s 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 #2
Day Hour Count Duration Avg duration Sep 29 09 1 1m44s 1m44s Sep 30 08 1 1m34s 1m34s Oct 01 08 1 2m24s 2m24s Oct 02 09 1 2m46s 2m46s Oct 03 08 1 1m35s 1m35s [ User: a3dsupervisor - Total duration: 10m4s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 10m4s - Times executed: 5 ]
-
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-10-02 07:06:38 Duration: 2m46s 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-10-01 06:57:44 Duration: 2m24s 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-29 07:00:17 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m39s 2m46s 1m55s 5 9m37s 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 #3
Day Hour Count Duration Avg duration Sep 29 08 1 1m44s 1m44s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m39s 1m39s Oct 02 08 1 2m46s 2m46s Oct 03 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m37s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) FROM stdin;
Date: 2025-10-02 06:58:50 Duration: 2m46s 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-29 06:55:25 Duration: 1m44s 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-10-03 06:54:32 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m28s 2m39s 1m49s 5 9m6s 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 #4
Day Hour Count Duration Avg duration Sep 29 08 1 1m43s 1m43s Sep 30 08 1 1m43s 1m43s Oct 01 08 1 1m28s 1m28s Oct 02 08 1 2m39s 2m39s Oct 03 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 9m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m6s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-10-02 06:58:43 Duration: 2m39s 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-29 06:55:24 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) FROM stdin;
Date: 2025-09-30 06:52:28 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m23s 2m14s 1m41s 5 8m28s 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 29 08 1 1m23s 1m23s Sep 30 08 1 1m40s 1m40s Oct 01 08 1 1m44s 1m44s Oct 02 09 1 2m14s 2m14s Oct 03 08 1 1m26s 1m26s [ User: a3dsupervisor - Total duration: 8m28s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m28s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m14s 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-10-01 06:53:52 Duration: 1m44s 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-30 06:54:09 Duration: 1m40s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m19s 2m21s 1m40s 5 8m20s 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 29 08 1 1m19s 1m19s Sep 30 08 1 1m37s 1m37s Oct 01 08 1 1m27s 1m27s Oct 02 09 1 2m21s 2m21s Oct 03 08 1 1m34s 1m34s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-10-02 07:01:05 Duration: 2m21s 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-30 06:54:05 Duration: 1m37s 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-10-03 06:55:54 Duration: 1m34s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5s575ms 2m45s 1m30s 4 6m 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 #7
Day Hour Count Duration Avg duration Sep 29 09 1 5s575ms 5s575ms Oct 01 08 1 2m10s 2m10s Oct 02 09 1 2m45s 2m45s Oct 03 09 1 58s141ms 58s141ms [ User: a3dsupervisor - Total duration: 6m - Times executed: 4 ]
[ Application: pg_restore - Total duration: 6m - Times executed: 4 ]
-
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-10-02 07:09:24 Duration: 2m45s 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-10-01 06:59:55 Duration: 2m10s 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-10-03 07:02:28 Duration: 58s141ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 55s95ms 1m53s 1m20s 5 6m44s 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 #8
Day Hour Count Duration Avg duration Sep 29 09 1 1m43s 1m43s Sep 30 09 1 1m53s 1m53s Oct 01 09 1 55s95ms 55s95ms Oct 02 09 1 1m11s 1m11s Oct 03 09 1 1m1s 1m1s [ User: a3dsupervisor - Total duration: 6m44s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m44s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-09-30 07:00:25 Duration: 1m53s 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-29 07:03:20 Duration: 1m43s 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-10-02 07:10:12 Duration: 1m11s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 45s404ms 1m48s 1m10s 5 5m52s 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 #9
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 45s404ms 45s404ms Oct 01 09 1 1m9s 1m9s Oct 02 09 1 1m48s 1m48s Oct 03 09 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 5m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m52s - Times executed: 5 ]
-
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-10-02 07:16:57 Duration: 1m48s 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-10-01 07:05:45 Duration: 1m9s 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-29 07:06:45 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 47s583ms 1m32s 1m3s 5 5m16s 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 #10
Day Hour Count Duration Avg duration Sep 29 09 1 1m32s 1m32s Sep 30 09 1 53s646ms 53s646ms Oct 01 09 1 1m1s 1m1s Oct 02 09 1 1m1s 1m1s Oct 03 09 1 47s583ms 47s583ms [ User: a3dsupervisor - Total duration: 5m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-09-29 07:06:39 Duration: 1m32s 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-10-02 07:12:32 Duration: 1m1s 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-10-01 07:02:39 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 14s220ms 2m5s 58s234ms 5 4m51s 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 #11
Day Hour Count Duration Avg duration Sep 29 09 1 14s220ms 14s220ms Sep 30 08 1 34s593ms 34s593ms Oct 01 09 1 54s624ms 54s624ms Oct 02 09 1 1m2s 1m2s Oct 03 09 1 2m5s 2m5s [ User: a3dsupervisor - Total duration: 4m51s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m51s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-10-03 07:01:30 Duration: 2m5s 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-10-02 07:10:27 Duration: 1m2s 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-10-01 07:00:49 Duration: 54s624ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 54s662ms 57s699ms 56s81ms 5 4m40s 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 29 08 1 56s886ms 56s886ms Sep 30 08 1 57s699ms 57s699ms Oct 01 08 1 54s662ms 54s662ms Oct 02 09 1 56s296ms 56s296ms Oct 03 08 1 54s861ms 54s861ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-09-30 06:56:07 Duration: 57s699ms 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-29 06:58:40 Duration: 56s886ms 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-10-02 07:04:07 Duration: 56s296ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 25s554ms 1m53s 47s728ms 5 3m58s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 09 1 1m53s 1m53s Sep 30 09 1 35s78ms 35s78ms Oct 01 09 1 27s998ms 27s998ms Oct 02 09 1 36s787ms 36s787ms Oct 03 09 1 25s554ms 25s554ms [ User: a3dsupervisor - Total duration: 3m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m58s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-09-29 07:05:39 Duration: 1m53s 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-10-02 07:15:09 Duration: 36s787ms 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-30 07:05:19 Duration: 35s78ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 33s889ms 58s102ms 43s309ms 5 3m36s 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 29 09 1 58s102ms 58s102ms Sep 30 09 1 33s889ms 33s889ms Oct 01 09 1 34s303ms 34s303ms Oct 02 09 1 45s948ms 45s948ms Oct 03 09 1 44s302ms 44s302ms [ User: a3dsupervisor - Total duration: 3m36s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m36s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-09-29 07:05:06 Duration: 58s102ms 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-10-02 07:11:30 Duration: 45s948ms 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-10-03 07:04:06 Duration: 44s302ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 36s953ms 49s519ms 40s753ms 5 3m23s 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 #15
Day Hour Count Duration Avg duration Sep 29 09 1 49s519ms 49s519ms Sep 30 08 1 36s959ms 36s959ms Oct 01 08 1 36s953ms 36s953ms Oct 02 09 1 40s944ms 40s944ms Oct 03 09 1 39s391ms 39s391ms [ User: a3dsupervisor - Total duration: 3m23s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m23s - Times executed: 5 ]
-
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-29 07:01:59 Duration: 49s519ms 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-10-02 07:07:53 Duration: 40s944ms 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-10-03 07:01:04 Duration: 39s391ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 9s543ms 1m27s 39s940ms 5 3m19s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 09 1 1m20s 1m20s Sep 30 09 1 1m27s 1m27s Oct 01 08 1 9s543ms 9s543ms Oct 02 09 1 11s192ms 11s192ms Oct 03 09 1 11s394ms 11s394ms [ User: a3dsupervisor - Total duration: 3m19s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m19s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-09-30 07:00:54 Duration: 1m27s 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-29 07:03:46 Duration: 1m20s 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-10-03 07:01:40 Duration: 11s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 27s118ms 48s172ms 39s403ms 5 3m17s 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 29 09 1 47s486ms 47s486ms Sep 30 09 1 41s140ms 41s140ms Oct 01 09 1 33s97ms 33s97ms Oct 02 09 1 48s172ms 48s172ms Oct 03 09 1 27s118ms 27s118ms [ User: a3dsupervisor - Total duration: 3m17s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m17s - Times executed: 5 ]
-
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-10-02 07:14:32 Duration: 48s172ms 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-29 07:01:37 Duration: 47s486ms 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-30 07:04:43 Duration: 41s140ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5s96ms 1m5s 39s219ms 5 3m16s alter table only public.gtp_monthly_history 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;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 09 1 1m5s 1m5s Sep 30 09 1 5s96ms 5s96ms Oct 01 09 1 44s194ms 44s194ms Oct 02 09 1 1m 1m Oct 03 09 1 20s213ms 20s213ms [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m16s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history 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-29 07:09:34 Duration: 1m5s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-02 07:17:05 Duration: 1m Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history 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-10-01 07:06:03 Duration: 44s194ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 36s295ms 39s133ms 37s574ms 5 3m7s alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 38s101ms 38s101ms Sep 30 08 1 37s401ms 37s401ms Oct 01 08 1 36s295ms 36s295ms Oct 02 09 1 39s133ms 39s133ms Oct 03 08 1 36s941ms 36s941ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m7s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-10-02 07:03:52 Duration: 39s133ms 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-29 06:58:33 Duration: 38s101ms 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-30 06:55:59 Duration: 37s401ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 21s450ms 1m8s 35s718ms 5 2m58s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 26s822ms 26s822ms Sep 30 08 1 34s402ms 34s402ms Oct 01 08 1 21s450ms 21s450ms Oct 02 09 1 1m8s 1m8s Oct 03 08 1 27s772ms 27s772ms [ User: a3dsupervisor - Total duration: 2m58s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m58s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-10-02 07:02:14 Duration: 1m8s 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-30 06:54:40 Duration: 34s402ms 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-10-03 06:56:22 Duration: 27s772ms 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
- 459,814 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 441540 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 441,409 Max number of times the same event was reported
- 441,540 Total events found
Rank Times reported Error 1 441,409 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 29 07 3,425 08 6,154 10 1,800 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,298 20 3,600 21 3,580 22 3,600 23 3,600 00 3,600 01 3,600 Sep 30 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,135 10 2,699 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,188 20 3,600 21 3,570 22 3,600 23 3,600 00 3,600 01 3,600 Oct 01 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,133 10 2,699 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,243 20 3,600 21 3,485 22 3,600 23 3,600 00 3,600 01 3,600 Oct 02 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,131 10 1,799 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,208 20 3,600 21 3,591 22 3,600 23 3,600 00 3,600 01 3,600 Oct 03 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,128 10 2,699 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,588 18 3,600 19 3,213 20 3,600 21 3,576 22 3,600 23 3,600 00 3,600 01 3,600 Oct 04 02 3,610 03 3,600 04 3,600 05 3,600 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 57 2 26 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 29 19 2 Sep 30 19 5 Oct 01 19 5 Oct 02 19 3 Oct 03 17 7 19 2 Oct 04 19 2 3 21 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 29 09 5 Sep 30 09 3 Oct 01 09 3 Oct 02 09 7 Oct 03 09 3 4 6 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... msinsert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 29 21 1 Sep 30 21 1 Oct 01 21 2 Oct 02 20 2 5 5 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 #5
Day Hour Count Sep 29 09 1 Sep 30 08 1 Oct 01 08 1 Oct 02 09 1 Oct 03 08 1 6 5 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 #6
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 7 5 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 #7
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 8 5 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 #8
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 9 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 10 5 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 #10
Day Hour Count Sep 29 09 1 Sep 30 08 1 Oct 01 08 1 Oct 02 09 1 Oct 03 09 1 11 5 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 #11
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 12 5 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 #12
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 13 5 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 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 14 5 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 29 09 1 Sep 30 09 1 Oct 01 09 1 Oct 02 09 1 Oct 03 09 1 15 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 16 5 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 29 10 1 Sep 30 09 1 Oct 01 09 1 Oct 02 10 1 Oct 03 09 1 17 4 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 #17
Day Hour Count Sep 29 20 2 21 1 Sep 30 21 1 18 3 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 #18
Day Hour Count Sep 29 09 1 Sep 30 09 1 Oct 02 09 1 19 2 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 #19
Day Hour Count Sep 29 09 1 Oct 03 09 1 20 2 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 #20
Day Hour Count Sep 29 09 1 Oct 03 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 Oct 01 09 1 Oct 02 09 1 22 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 #22
Day Hour Count Sep 30 09 1 23 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_doc_deleted
Times Reported Most Frequent Error / Event #23
Day Hour Count Sep 29 09 1 24 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_compo
Times Reported Most Frequent Error / Event #24
Day Hour Count Sep 29 09 1 25 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_rel_vt
Times Reported Most Frequent Error / Event #25
Day Hour Count Oct 02 09 1 26 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_action
Times Reported Most Frequent Error / Event #26
Day Hour Count Sep 29 09 1