pgBadger-
Global information
- Generated on Mon Nov 10 09:36:06 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=08/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=08/h=23/m=00/PT1H.log
- Parsed 645,384 log entries in 1m12s
- Log start from 2025-11-03 07:59:06 to 2025-11-07 09:10:04
-
Overview
Global Stats
- 90 Number of unique normalized queries
- 247 Number of queries
- 3h8m42s Total query duration
- 2025-11-03 07:54:28 First query
- 2025-11-07 08:54:11 Last query
- 4 queries/s at 2025-11-06 19:38:24 Query peak
- 3h8m42s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h8m42s Execute total duration
- 315,746 Number of events
- 28 Number of unique normalized events
- 315,647 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
- 745 Number temporary file
- 1.17 GiB Max size of temporary file
- 40.53 MiB Average size of temporary file
- 4,205 Total number of sessions
- 150 sessions at 2025-11-02 17:49:05 Session peak
- 12d4h19m32s Total duration of sessions
- 4m10s Average duration of sessions
- 0 Average queries per session
- 2s692ms Average queries duration per session
- 4m7s Average idle time per session
- 4,206 Total number of connections
- 11 connections/s at 2025-11-06 08:51:01 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-06 19:38:24 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-05 20:41:58 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2025-11-06 19:38:24 Date
Queries duration
Key values
- 3h8m42s 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) Nov 02 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 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 Nov 03 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 18 0ms 1m56s 43s348ms 4m9s 4m9s 4m9s 08 21 0ms 5m21s 44s220ms 1m45s 2m23s 5m21s 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 12 0ms 9s398ms 6s452ms 0ms 17s643ms 28s333ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 04 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 11 0ms 1m27s 46s192ms 54s250ms 2m53s 4m34s 08 30 0ms 5m41s 46s897ms 3m12s 5m41s 5m41s 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 6 0ms 9s704ms 7s57ms 0ms 0ms 36s674ms 20 5 0ms 6s539ms 5s922ms 0ms 0ms 29s613ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 05 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 9 0ms 2m28s 1m18s 2m26s 2m28s 4m51s 08 30 0ms 14m4s 1m2s 2m53s 3m2s 14m4s 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 10 0ms 10s228ms 8s132ms 0ms 9s387ms 50s110ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 06 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 19 0ms 1m57s 46s933ms 2m38s 3m30s 3m41s 08 25 0ms 13m41s 56s895ms 2m 3m1s 13m41s 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 4 0ms 9s506ms 9s344ms 0ms 0ms 37s379ms 20 7 0ms 7s42ms 5s740ms 0ms 5s586ms 22s579ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Nov 07 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 15 0ms 2m10s 53s787ms 2m38s 3m6s 3m27s 08 25 0ms 12m18s 1m7s 4m24s 12m18s 12m18s 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 Nov 08 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 02 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 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 Nov 03 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 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 Nov 04 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 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 1 0 8s114ms 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 Nov 05 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 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 1 0 8s448ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 06 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 07 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Nov 08 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 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 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 Nov 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 4 1m3s 0ms 38s178ms 3m2s 08 0 0 0 3 44s675ms 0ms 0ms 1m31s 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 4 0 7s83ms 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 Nov 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 1 2 59s833ms 0ms 0ms 5s915ms 08 0 0 0 5 50s319ms 0ms 0ms 2m 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 1 0 0 0 5s466ms 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 Nov 05 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 2 2m14s 0ms 0ms 2m 08 0 0 0 5 42s961ms 0ms 29s189ms 54s929ms 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 1 0 1 0 8s961ms 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 Nov 06 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 4 1m13s 0ms 0ms 43s233ms 08 0 0 0 3 47s273ms 0ms 0ms 1m36s 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 4 0 5s644ms 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 Nov 07 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 6 50s743ms 0ms 0ms 1m22s 08 0 0 0 2 33s456ms 0ms 0ms 37s162ms 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 Nov 08 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 Nov 02 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 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% Nov 03 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 12 12.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 04 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 1 1.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 6 6.00 0.00% 20 0 5 5.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 10 10.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 06 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 4 4.00 0.00% 20 0 7 7.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 07 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Nov 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Nov 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 7 0.00/s 08 49 0.01/s 09 47 0.01/s 10 42 0.01/s 11 48 0.01/s 12 56 0.02/s 13 49 0.01/s 14 59 0.02/s 15 68 0.02/s 16 49 0.01/s 17 51 0.01/s 18 38 0.01/s 19 52 0.01/s 20 50 0.01/s 21 32 0.01/s 22 34 0.01/s 23 49 0.01/s Nov 04 00 61 0.02/s 01 48 0.01/s 02 36 0.01/s 03 45 0.01/s 04 49 0.01/s 05 42 0.01/s 06 46 0.01/s 07 24 0.01/s 08 43 0.01/s 09 39 0.01/s 10 37 0.01/s 11 35 0.01/s 12 41 0.01/s 13 44 0.01/s 14 43 0.01/s 15 35 0.01/s 16 38 0.01/s 17 40 0.01/s 18 30 0.01/s 19 38 0.01/s 20 49 0.01/s 21 34 0.01/s 22 35 0.01/s 23 40 0.01/s Nov 05 00 43 0.01/s 01 39 0.01/s 02 35 0.01/s 03 30 0.01/s 04 38 0.01/s 05 28 0.01/s 06 32 0.01/s 07 22 0.01/s 08 43 0.01/s 09 37 0.01/s 10 44 0.01/s 11 47 0.01/s 12 43 0.01/s 13 52 0.01/s 14 44 0.01/s 15 51 0.01/s 16 49 0.01/s 17 48 0.01/s 18 37 0.01/s 19 48 0.01/s 20 50 0.01/s 21 43 0.01/s 22 45 0.01/s 23 44 0.01/s Nov 06 00 50 0.01/s 01 43 0.01/s 02 40 0.01/s 03 37 0.01/s 04 48 0.01/s 05 49 0.01/s 06 41 0.01/s 07 26 0.01/s 08 47 0.01/s 09 40 0.01/s 10 53 0.01/s 11 39 0.01/s 12 38 0.01/s 13 45 0.01/s 14 46 0.01/s 15 44 0.01/s 16 39 0.01/s 17 35 0.01/s 18 34 0.01/s 19 47 0.01/s 20 43 0.01/s 21 39 0.01/s 22 34 0.01/s 23 41 0.01/s Nov 07 00 38 0.01/s 01 27 0.01/s 02 35 0.01/s 03 32 0.01/s 04 36 0.01/s 05 40 0.01/s 06 28 0.01/s 07 19 0.01/s 08 8 0.00/s 09 5 0.00/s 10 7 0.00/s 11 3 0.00/s 12 4 0.00/s 13 7 0.00/s 14 11 0.00/s 15 5 0.00/s 16 4 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Nov 08 00 3 0.00/s 01 3 0.00/s 02 3 0.00/s 03 3 0.00/s 04 3 0.00/s 05 3 0.00/s 06 3 0.00/s 07 3 0.00/s 08 3 0.00/s 09 3 0.00/s 10 3 0.00/s 11 3 0.00/s 12 3 0.00/s 13 3 0.00/s 14 3 0.00/s 15 3 0.00/s 16 3 0.00/s 17 3 0.00/s 18 3 0.00/s 19 3 0.00/s 20 3 0.00/s 21 3 0.00/s 22 3 0.00/s 23 3 0.00/s Day Hour Count Average Duration Average idle time Nov 02 00 2 79ms 79ms 01 2 79ms 79ms 02 2 77ms 77ms 03 2 72ms 72ms 04 2 78ms 78ms 05 2 75ms 75ms 06 2 76ms 76ms 07 2 71ms 71ms 08 2 77ms 77ms 09 2 74ms 74ms 10 2 72ms 72ms 11 2 73ms 73ms 12 2 79ms 79ms 13 2 215ms 215ms 14 2 84ms 84ms 15 2 83ms 83ms 16 2 83ms 83ms 17 2 79ms 79ms 18 2 79ms 79ms 19 2 76ms 76ms 20 2 77ms 77ms 21 2 72ms 72ms 22 2 74ms 74ms 23 2 76ms 76ms Nov 03 00 2 73ms 73ms 01 2 76ms 76ms 02 2 79ms 79ms 03 2 73ms 73ms 04 2 76ms 76ms 05 2 75ms 75ms 06 2 77ms 77ms 07 5 2s292ms 0ms 08 46 2m30s 2m10s 09 48 5m 5m 10 42 1m15s 1m15s 11 48 1m17s 1m17s 12 55 7m26s 7m26s 13 50 1m9s 1m9s 14 61 1m21s 1m21s 15 68 1m22s 1m22s 16 49 1m35s 1m35s 17 47 1m19s 1m19s 18 41 28m28s 28m28s 19 53 1m21s 1m21s 20 50 1m36s 1m34s 21 31 2m 2m 22 35 1m52s 1m52s 23 49 1m19s 1m19s Nov 04 00 61 1m18s 1m18s 01 48 1m23s 1m23s 02 36 1m25s 1m25s 03 45 1m19s 1m19s 04 49 1m17s 1m17s 05 42 1m21s 1m21s 06 44 1m17s 1m17s 07 26 1h1m18s 1h58s 08 43 2m44s 2m11s 09 39 1m53s 1m53s 10 36 1m22s 1m22s 11 36 1m24s 1m24s 12 41 1m23s 1m23s 13 44 1m9s 1m9s 14 43 1m7s 1m7s 15 35 24m 24m 16 38 1m21s 1m21s 17 37 1m23s 1m23s 18 33 9m52s 9m52s 19 38 1m40s 1m39s 20 48 1m29s 1m29s 21 35 1m22s 1m22s 22 35 1m20s 1m20s 23 40 1m21s 1m21s Nov 05 00 43 1m19s 1m19s 01 38 1m17s 1m17s 02 36 1m22s 1m22s 03 30 1m23s 1m23s 04 38 1m15s 1m15s 05 28 1m22s 1m22s 06 32 1m17s 1m17s 07 21 1h15m30s 1h14m57s 08 40 3m4s 2m17s 09 40 1m24s 1m24s 10 43 1m15s 1m15s 11 48 1m24s 1m24s 12 43 1m18s 1m18s 13 52 1m15s 1m15s 14 44 1m20s 1m20s 15 51 1m9s 1m9s 16 49 1m19s 1m19s 17 48 1m22s 1m22s 18 34 33m3s 33m3s 19 48 1m36s 1m36s 20 53 6m23s 6m21s 21 43 1m16s 1m16s 22 44 1m16s 1m16s 23 45 1m20s 1m20s Nov 06 00 49 1m19s 1m19s 01 44 1m22s 1m22s 02 40 1m20s 1m20s 03 37 1m16s 1m16s 04 48 1m13s 1m13s 05 48 1m14s 1m14s 06 42 1m22s 1m22s 07 25 1h3m26s 1h2m51s 08 44 2m46s 2m14s 09 40 1m50s 1m50s 10 54 2m51s 2m51s 11 41 9m23s 9m23s 12 38 1m11s 1m11s 13 45 1m6s 1m6s 14 46 59s689ms 59s689ms 15 41 1m14s 1m14s 16 42 1m20s 1m20s 17 34 1m14s 1m14s 18 35 31m55s 31m55s 19 47 1m34s 1m33s 20 43 1m36s 1m35s 21 39 1m19s 1m19s 22 34 1m21s 1m21s 23 40 1m17s 1m17s Nov 07 00 38 1m20s 1m20s 01 28 1m25s 1m25s 02 35 1m16s 1m16s 03 32 1m16s 1m16s 04 36 1m16s 1m16s 05 37 1m18s 1m18s 06 30 1m30s 1m30s 07 21 1h15m7s 1h14m29s 08 9 10m52s 7m45s 09 6 4m42s 4m42s 10 7 206ms 206ms 11 3 72ms 72ms 12 4 66ms 66ms 13 7 104ms 104ms 14 11 215ms 215ms 15 5 62ms 62ms 16 4 68ms 68ms 17 3 72ms 72ms 18 3 84ms 84ms 19 3 75ms 75ms 20 3 127ms 127ms 21 3 101ms 101ms 22 3 71ms 71ms 23 3 68ms 68ms Nov 08 00 3 71ms 71ms 01 3 70ms 70ms 02 3 71ms 71ms 03 3 68ms 68ms 04 3 84ms 84ms 05 3 81ms 81ms 06 3 74ms 74ms 07 3 68ms 68ms 08 3 73ms 73ms 09 3 68ms 68ms 10 3 74ms 74ms 11 3 70ms 70ms 12 3 76ms 76ms 13 3 88ms 88ms 14 3 72ms 72ms 15 3 70ms 70ms 16 3 71ms 71ms 17 3 69ms 69ms 18 3 72ms 72ms 19 3 83ms 83ms 20 3 141ms 141ms 21 3 72ms 72ms 22 3 67ms 67ms 23 3 71ms 71ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-11-06 08:51:01 Date
Connections per database
Key values
- cnrs Main Database
- 4,206 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,206 connections Total
-
Sessions
Simultaneous sessions
Key values
- 150 sessions Session Peak
- 2025-11-02 17:49:05 Date
Histogram of session times
Key values
- 3,467 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 4,205 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,205 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,205 sessions Total
Sessions per application
Key values
- PostgreSQL JDBC Driver Main Application
- 4,205 sessions Total
Application Count Total Duration Average Duration DBeaver 25.1.0 - Main 'cnrs' 4 5h14m21s 1h18m35s DBeaver 25.1.0 - Metadata 'cnrs' 5 8h5m3s 1h37m DBeaver 25.1.0 - SQLEditor 'Script-1.sql' 5 6h51m53s 1h22m22s IntelliJ IDEA 2024.3.5 1 431ms 431ms PostgreSQL JDBC Driver 3,619 10d23h14m2s 4m21s [unknown] 526 1m3s 121ms pg_restore 20 7h46m4s 23m18s psql 25 1h7m3s 2m40s -
Temporary Files
Size of temporary files
Key values
- 717.73 MiB Temp Files size Peak
- 2025-11-07 07:59:31 Date
Number of temporary files
Key values
- 6 per second Temp Files Peak
- 2025-11-07 08:06:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 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 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 Nov 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 51 2.97 GiB 59.66 MiB 08 103 3.03 GiB 30.13 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 Nov 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 18 2.15 GiB 122.06 MiB 08 100 3.43 GiB 35.10 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 Nov 05 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 15 1.88 GiB 128.17 MiB 08 138 3.91 GiB 29.04 MiB 09 1 3.66 MiB 3.66 MiB 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Nov 06 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 53 3.24 GiB 62.68 MiB 08 107 2.77 GiB 26.52 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 Nov 07 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 38 2.90 GiB 78.15 MiB 08 121 3.20 GiB 27.07 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 Nov 08 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 18 929.49 MiB 47.68 MiB 55.55 MiB 51.64 MiB add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-07 08:06:04 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 15 5.44 GiB 127.97 MiB 971.16 MiB 371.04 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-11-07 08:01:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 5.63 GiB 70.74 MiB 1.17 GiB 384.51 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-11-07 07:55:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 1.86 GiB 35.33 MiB 341.81 MiB 127.00 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-11-07 08:07:24 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 15 1.93 GiB 14.52 MiB 632.38 MiB 131.82 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-11-07 08:02:47 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 12 911.53 MiB 13.23 MiB 218.72 MiB 75.96 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-11-07 08:08:09 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 12 3.49 GiB 222.63 MiB 714.01 MiB 297.53 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-11-07 07:59:31 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 12 420.05 MiB 8.88 MiB 115.12 MiB 35.00 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-11-07 08:06:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 11 1.24 GiB 50.43 MiB 518.25 MiB 115.11 MiB add constraint pk_history_obj_action primary key (action_num_id);-
ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-07 08:05:01 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 10 661.27 MiB 27.88 MiB 317.20 MiB 66.13 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-11-07 08:03:56 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 9 930.66 MiB 2.19 MiB 854.38 MiB 103.41 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-11-07 07:55:38 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 8 30.73 MiB 1.96 MiB 7.02 MiB 3.84 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-11-07 08:06:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 7 103.80 MiB 2.19 MiB 31.53 MiB 14.83 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-11-07 08:06:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 7 69.06 MiB 2.05 MiB 24.61 MiB 9.87 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-11-06 07:59:05 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4 31.51 MiB 1.98 MiB 17.17 MiB 7.88 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-11-06 08:04:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3 200.99 MiB 2.57 MiB 100.30 MiB 67.00 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-11-07 08:06:50 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 62.25 MiB 30.64 MiB 31.61 MiB 31.12 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-11-05 08:10:50 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 1 199.66 MiB 199.66 MiB 199.66 MiB 199.66 MiB add constraint fk_gtp_cw_eng_alert foreign key (history_num_id) references public.gtp_cw_eng_history (history_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_cw_eng_alert FOREIGN KEY (history_num_id) REFERENCES public.gtp_cw_eng_history (history_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-04 08:07:06 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 2.71 MiB 2.71 MiB 2.71 MiB 2.71 MiB add constraint fk_gtp_obj_compo_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-03 07:59:08 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 437.77 MiB 437.77 MiB 437.77 MiB 437.77 MiB add constraint fk_gtp_month_histo_att foreign key (att_template_num_id) references public.gtp_att_template (att_template_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-04 08:05:21 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 8.83 MiB 8.83 MiB 8.83 MiB 8.83 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-03 07:59:06 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 6.83 MiB 6.83 MiB 6.83 MiB 6.83 MiB add constraint fk_history_obj_concerned_act foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_history_obj_concerned_act FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-04 08:09:07 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 823.94 MiB 823.94 MiB 823.94 MiB 823.94 MiB add constraint fk_uml_relation_ua_id foreign key (ur_ua_id) references public.uml_attribute (ua_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-03 07:56:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 839.77 MiB 839.77 MiB 839.77 MiB 839.77 MiB add constraint pk_a3d_user primary key (user_num_id);-
ADD CONSTRAINT pk_a3d_user PRIMARY KEY (user_num_id);
Date: 2025-11-06 07:55:53 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 7.09 MiB 7.09 MiB 7.09 MiB 7.09 MiB add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-04 08:03:38 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
Queries generating the largest temporary files
Rank Size Query 1 1.17 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-07 07:55:31 - 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-11-03 07:56:26 - 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-11-04 07:57:59 - 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-11-06 07:55:37 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 971.16 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-03 08:00:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 933.78 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-04 08:02:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 908.15 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-05 08:04:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 854.38 MiB ADD CONSTRAINT pk_gtp_relation_num_id PRIMARY KEY (relation_num_id);[ Date: 2025-11-07 07:55:38 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 839.77 MiB ADD CONSTRAINT pk_a3d_user PRIMARY KEY (user_num_id);[ Date: 2025-11-06 07:55:53 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 823.94 MiB ADD CONSTRAINT fk_uml_relation_ua_id FOREIGN KEY (ur_ua_id) REFERENCES public.uml_attribute (ua_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-03 07:56:51 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 791.73 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-07 08:01:22 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 714.01 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-05 08:02:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 632.38 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-06 08:00:27 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 560.17 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-07 08:02:47 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 518.25 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-05 08:07:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 477.48 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-03 08:00:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 474.62 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-06 08:02:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 437.77 MiB ADD CONSTRAINT fk_gtp_month_histo_att FOREIGN KEY (att_template_num_id) REFERENCES public.gtp_att_template (att_template_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-04 08:05:21 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 366.86 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-06 07:59:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 347.20 MiB ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);[ Date: 2025-11-06 07:59:09 - 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 Nov 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 Nov 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 Nov 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 Nov 05 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 06 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 07 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Nov 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareRowExclusiveLock Main Lock Type
- 35 locks Total
Type Object Count Total Duration Average Duration (s) AccessShareLock 3 4s749ms 1s583ms relation 3 4s749ms 1s583ms ExclusiveLock 10 14s795ms 1s479ms extension 10 14s795ms 1s479ms RowExclusiveLock 3 7s551ms 2s517ms relation 3 7s551ms 2s517ms ShareLock 4 4s6ms 1s1ms relation 4 4s6ms 1s1ms ShareRowExclusiveLock 11 11s323ms 1s29ms relation 11 11s323ms 1s29ms ShareUpdateExclusiveLock 4 4s115ms 1s28ms relation 4 4s115ms 1s28ms Total 35 46s540ms 1s329ms 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
- 2 Total read queries
- 240 Total write queries
Queries by database
Key values
- cnrs Main database
- 247 Requests
- 3h8m42s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 247 Requests
User Request type Count Duration a3dsupervisor Total 247 3h8m42s copy from 36 35m4s ddl 161 1h37m17s delete 10 1m6s insert 2 14s3ms others 5 51m6s select 2 16s563ms tcl 31 3m37s Duration by user
Key values
- 3h8m42s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 247 3h8m42s copy from 36 35m4s ddl 161 1h37m17s delete 10 1m6s insert 2 14s3ms others 5 51m6s select 2 16s563ms tcl 31 3m37s Queries by host
Key values
- 10.3.0.4 Main host
- 247 Requests
- 3h8m42s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 197 Requests
- 2h12m21s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-06 01:07:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 161 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 14m4s VACUUM ANALYSE;[ Date: 2025-11-05 08:57:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 13m41s VACUUM ANALYSE;[ Date: 2025-11-06 08:50:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 12m18s VACUUM ANALYSE;[ Date: 2025-11-07 08:54:11 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 5m41s VACUUM ANALYSE;[ Date: 2025-11-04 08:47:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
5 5m21s VACUUM ANALYSE;[ Date: 2025-11-03 08:41:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
6 3m24s 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-11-07 08:02:56 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 2m28s 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-11-05 07:56:26 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 2m17s 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-11-07 08:05:13 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 2m10s 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-11-07 07:59:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 2m5s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-05 07:58:03 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 2m 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-11-05 07:55:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 1m57s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-06 07:55:38 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 1m56s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-03 07:56:27 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 1m55s CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);[ Date: 2025-11-04 08:02:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 1m55s 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-11-05 08:11:54 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 1m51s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-05 07:58:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 1m51s 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-11-06 07:53:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m44s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-07 07:55:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m43s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-06 07:55:56 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m43s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-03 07:56:51 - 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 51m6s 5 5m21s 14m4s 10m13s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 09 1 5m21s 5m21s Nov 04 09 1 5m41s 5m41s Nov 05 09 1 14m4s 14m4s Nov 06 09 1 13m41s 13m41s Nov 07 09 1 12m18s 12m18s [ User: a3dsupervisor - Total duration: 51m6s - Times executed: 5 ]
[ Application: psql - Total duration: 51m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 08:57:44 Duration: 14m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 08:50:15 Duration: 13m41s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 08:54:11 Duration: 12m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 9m8s 5 1m25s 2m5s 1m49s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 08 1 1m56s 1m56s Nov 04 08 1 1m25s 1m25s Nov 05 08 1 2m5s 2m5s Nov 06 08 1 1m57s 1m57s Nov 07 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-05 07:58:03 Duration: 2m5s 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-11-06 07:55:38 Duration: 1m57s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-03 07:56:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 8m41s 5 1m27s 2m28s 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;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 08 1 1m30s 1m30s Nov 04 08 1 1m27s 1m27s Nov 05 08 1 2m28s 2m28s Nov 06 08 1 1m39s 1m39s Nov 07 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m41s - 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-11-05 07:56:26 Duration: 2m28s 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-11-06 07:53:27 Duration: 1m39s 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-11-07 07:53:54 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 8m28s 5 1m26s 1m51s 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 #4
Day Hour Count Duration Avg duration Nov 03 08 1 1m43s 1m43s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 1m51s 1m51s Nov 06 08 1 1m43s 1m43s Nov 07 08 1 1m43s 1m43s [ 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-11-05 07:58:18 Duration: 1m51s 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-11-06 07:55:56 Duration: 1m43s 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-11-03 07:56:51 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 8m20s 5 1m26s 2m 1m40s 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 Nov 03 08 1 1m32s 1m32s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 2m 2m Nov 06 08 1 1m51s 1m51s Nov 07 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - 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-11-05 07:55:58 Duration: 2m 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-11-06 07:53:39 Duration: 1m51s 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-11-03 07:54:30 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 7m25s 5 1m9s 2m10s 1m29s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 08 1 1m9s 1m9s Nov 04 09 1 1m12s 1m12s Nov 05 09 1 1m31s 1m31s Nov 06 08 1 1m21s 1m21s Nov 07 08 1 2m10s 2m10s [ User: a3dsupervisor - Total duration: 7m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m25s - 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-11-07 07:59:31 Duration: 2m10s 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-11-05 08:02:08 Duration: 1m31s 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-11-06 07:59:10 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 7m15s 5 1m5s 1m55s 1m27s 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 Nov 03 09 1 1m5s 1m5s Nov 04 09 1 1m55s 1m55s Nov 05 09 1 1m41s 1m41s Nov 06 09 1 1m21s 1m21s Nov 07 09 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 7m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m15s - 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-11-04 08:02:58 Duration: 1m55s 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-11-05 08:04:58 Duration: 1m41s 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-11-06 08:02:35 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 6m6s 5 42s137ms 1m55s 1m13s 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 #8
Day Hour Count Duration Avg duration Nov 03 09 1 1m22s 1m22s Nov 04 09 1 42s137ms 42s137ms Nov 05 09 1 1m55s 1m55s Nov 06 09 1 51s285ms 51s285ms Nov 07 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m6s - 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-11-05 08:11:54 Duration: 1m55s 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-11-03 08:06:34 Duration: 1m22s 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-11-07 08:06:16 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 4m48s 5 42s76ms 1m28s 57s640ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 09 1 42s76ms 42s76ms Nov 04 09 1 1m28s 1m28s Nov 05 09 1 48s347ms 48s347ms Nov 06 09 1 45s441ms 45s441ms Nov 07 08 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 4m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m48s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-04 08:00:21 Duration: 1m28s 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-11-07 07:57:36 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-05 08:00:30 Duration: 48s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 4m40s 5 51s434ms 1m5s 56s80ms 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 Nov 03 09 1 1m5s 1m5s Nov 04 09 1 51s434ms 51s434ms Nov 05 09 1 55s301ms 55s301ms Nov 06 09 1 54s978ms 54s978ms Nov 07 09 1 53s343ms 53s343ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - 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-11-03 08:03:49 Duration: 1m5s 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-11-05 08:07:37 Duration: 55s301ms 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-11-06 08:03:30 Duration: 54s978ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 4m38s 5 25s955ms 1m16s 55s633ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 09 1 1m7s 1m7s Nov 04 09 1 58s347ms 58s347ms Nov 05 09 1 49s938ms 49s938ms Nov 06 09 1 1m16s 1m16s Nov 07 09 1 25s955ms 25s955ms [ User: a3dsupervisor - Total duration: 4m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m38s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-11-06 08:02:34 Duration: 1m16s 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-11-03 08:02:43 Duration: 1m7s 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-11-04 08:04:14 Duration: 58s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 4m8s 5 29s751ms 59s451ms 49s783ms 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 #12
Day Hour Count Duration Avg duration Nov 03 09 1 54s371ms 54s371ms Nov 04 09 1 53s580ms 53s580ms Nov 05 09 1 51s760ms 51s760ms Nov 06 09 1 59s451ms 59s451ms Nov 07 09 1 29s751ms 29s751ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m8s - 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-11-06 08:04:30 Duration: 59s451ms 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-11-03 08:04:31 Duration: 54s371ms 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-11-04 08:07:19 Duration: 53s580ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 4m8s 3 10s278ms 3m24s 1m22s 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 #13
Day Hour Count Duration Avg duration Nov 05 09 1 10s278ms 10s278ms Nov 06 08 1 33s588ms 33s588ms Nov 07 09 1 3m24s 3m24s [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 4m8s - Times executed: 3 ]
-
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-11-07 08:02:56 Duration: 3m24s 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-11-06 07:59:43 Duration: 33s588ms 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-11-05 08:02:56 Duration: 10s278ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 3m37s 31 5s64ms 10s228ms 7s13ms commit;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 03 21 8 49s101ms 6s137ms Nov 04 20 4 28s760ms 7s190ms 21 5 29s613ms 5s922ms Nov 05 21 7 54s953ms 7s850ms Nov 06 20 4 37s379ms 9s344ms 21 3 17s602ms 5s867ms [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 31 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m37s - Times executed: 31 ]
-
COMMIT;
Date: 2025-11-05 20:41:58 Duration: 10s228ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 19:40:17 Duration: 9s704ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-06 19:38:24 Duration: 9s506ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
15 3m35s 5 37s162ms 54s929ms 43s65ms 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 Nov 03 08 1 38s178ms 38s178ms Nov 04 09 1 41s825ms 41s825ms Nov 05 09 1 54s929ms 54s929ms Nov 06 08 1 43s233ms 43s233ms Nov 07 09 1 37s162ms 37s162ms [ User: a3dsupervisor - Total duration: 3m35s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m35s - 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-11-05 08:04:08 Duration: 54s929ms 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-11-06 07:54:12 Duration: 43s233ms 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-11-04 08:01:41 Duration: 41s825ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 3m30s 5 32s479ms 1m 42s164ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 09 1 39s897ms 39s897ms Nov 04 09 1 1m 1m Nov 05 09 1 32s479ms 32s479ms Nov 06 09 1 45s246ms 45s246ms Nov 07 09 1 32s910ms 32s910ms [ User: a3dsupervisor - Total duration: 3m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-04 08:08:20 Duration: 1m 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-11-06 08:05:15 Duration: 45s246ms 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-11-03 08:05:11 Duration: 39s897ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 3m16s 4 8s260ms 2m17s 49s152ms 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 #17
Day Hour Count Duration Avg duration Nov 03 08 1 13s561ms 13s561ms Nov 05 09 1 37s283ms 37s283ms Nov 06 08 1 8s260ms 8s260ms Nov 07 09 1 2m17s 2m17s [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m16s - Times executed: 4 ]
-
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-11-07 08:05:13 Duration: 2m17s 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-11-05 08:02:46 Duration: 37s283ms 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-11-03 07:59:49 Duration: 13s561ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 3m2s 5 24s830ms 54s530ms 36s419ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 08 1 29s553ms 29s553ms Nov 04 08 1 24s830ms 24s830ms Nov 05 08 1 54s530ms 54s530ms Nov 06 08 1 42s787ms 42s787ms Nov 07 08 1 30s394ms 30s394ms [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-11-05 07:58:58 Duration: 54s530ms 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-11-06 07:56:21 Duration: 42s787ms 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-11-07 07:56:01 Duration: 30s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 2m57s 5 24s308ms 1m2s 35s539ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 03 09 1 27s361ms 27s361ms Nov 04 09 1 1m2s 1m2s Nov 05 09 1 31s751ms 31s751ms Nov 06 08 1 24s308ms 24s308ms Nov 07 09 1 31s544ms 31s544ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-04 08:03:16 Duration: 1m2s 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-11-05 08:05:30 Duration: 31s751ms 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-11-07 08:07:35 Duration: 31s544ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 2m52s 5 30s604ms 37s687ms 34s406ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 08 1 35s100ms 35s100ms Nov 04 08 1 30s604ms 30s604ms Nov 05 09 1 37s687ms 37s687ms Nov 06 08 1 37s97ms 37s97ms Nov 07 08 1 31s539ms 31s539ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-05 08:00:37 Duration: 37s687ms 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-11-06 07:57:48 Duration: 37s97ms 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-11-03 07:58:26 Duration: 35s100ms 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 31 3m37s 5s64ms 10s228ms 7s13ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 21 8 49s101ms 6s137ms Nov 04 20 4 28s760ms 7s190ms 21 5 29s613ms 5s922ms Nov 05 21 7 54s953ms 7s850ms Nov 06 20 4 37s379ms 9s344ms 21 3 17s602ms 5s867ms [ User: a3dsupervisor - Total duration: 3m37s - Times executed: 31 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m37s - Times executed: 31 ]
-
COMMIT;
Date: 2025-11-05 20:41:58 Duration: 10s228ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-04 19:40:17 Duration: 9s704ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-06 19:38:24 Duration: 9s506ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 6 34s473ms 5s132ms 6s661ms 5s745ms delete from gtp_background_task task where task.task_num_id in ( select task.task_num_id from gtp_background_task task where task.task_service_name = and (task.task_start_date + interval ? * ?) < current_timestamp and task.task_status = ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 21 3 18s935ms 6s311ms Nov 06 21 3 15s537ms 5s179ms [ User: a3dsupervisor - Total duration: 34s473ms - Times executed: 6 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 34s473ms - Times executed: 6 ]
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-11-03 20:40:17 Duration: 6s661ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-11-03 20:40:17 Duration: 6s637ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
DELETE FROM GTP_BACKGROUND_TASK task WHERE task.TASK_NUM_ID IN ( SELECT task.TASK_NUM_ID FROM GTP_BACKGROUND_TASK task WHERE task.TASK_SERVICE_NAME = AND (task.TASK_START_DATE + interval '1 day' * 7) < current_timestamp AND task.TASK_STATUS = 4);
Date: 2025-11-03 20:40:17 Duration: 5s636ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
3 5 51m6s 5m21s 14m4s 10m13s vacuum analyse;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 03 09 1 5m21s 5m21s Nov 04 09 1 5m41s 5m41s Nov 05 09 1 14m4s 14m4s Nov 06 09 1 13m41s 13m41s Nov 07 09 1 12m18s 12m18s [ User: a3dsupervisor - Total duration: 51m6s - Times executed: 5 ]
[ Application: psql - Total duration: 51m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 08:57:44 Duration: 14m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 08:50:15 Duration: 13m41s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 08:54:11 Duration: 12m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
4 5 9m8s 1m25s 2m5s 1m49s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 03 08 1 1m56s 1m56s Nov 04 08 1 1m25s 1m25s Nov 05 08 1 2m5s 2m5s Nov 06 08 1 1m57s 1m57s Nov 07 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-05 07:58:03 Duration: 2m5s 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-11-06 07:55:38 Duration: 1m57s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-03 07:56:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 5 8m41s 1m27s 2m28s 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;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Nov 03 08 1 1m30s 1m30s Nov 04 08 1 1m27s 1m27s Nov 05 08 1 2m28s 2m28s Nov 06 08 1 1m39s 1m39s Nov 07 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m41s - 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-11-05 07:56:26 Duration: 2m28s 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-11-06 07:53:27 Duration: 1m39s 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-11-07 07:53:54 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5 8m28s 1m26s 1m51s 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 Nov 03 08 1 1m43s 1m43s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 1m51s 1m51s Nov 06 08 1 1m43s 1m43s Nov 07 08 1 1m43s 1m43s [ 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-11-05 07:58:18 Duration: 1m51s 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-11-06 07:55:56 Duration: 1m43s 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-11-03 07:56:51 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5 8m20s 1m26s 2m 1m40s 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 #7
Day Hour Count Duration Avg duration Nov 03 08 1 1m32s 1m32s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 2m 2m Nov 06 08 1 1m51s 1m51s Nov 07 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - 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-11-05 07:55:58 Duration: 2m 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-11-06 07:53:39 Duration: 1m51s 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-11-03 07:54:30 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 7m25s 1m9s 2m10s 1m29s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 03 08 1 1m9s 1m9s Nov 04 09 1 1m12s 1m12s Nov 05 09 1 1m31s 1m31s Nov 06 08 1 1m21s 1m21s Nov 07 08 1 2m10s 2m10s [ User: a3dsupervisor - Total duration: 7m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m25s - 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-11-07 07:59:31 Duration: 2m10s 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-11-05 08:02:08 Duration: 1m31s 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-11-06 07:59:10 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 7m15s 1m5s 1m55s 1m27s create index i_fk_ged_right_user_ged_node on public.ged_right_user using btree (project_num_id, node_num_id);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Nov 03 09 1 1m5s 1m5s Nov 04 09 1 1m55s 1m55s Nov 05 09 1 1m41s 1m41s Nov 06 09 1 1m21s 1m21s Nov 07 09 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 7m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m15s - 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-11-04 08:02:58 Duration: 1m55s 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-11-05 08:04:58 Duration: 1m41s 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-11-06 08:02:35 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 6m6s 42s137ms 1m55s 1m13s alter table only public.gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 09 1 1m22s 1m22s Nov 04 09 1 42s137ms 42s137ms Nov 05 09 1 1m55s 1m55s Nov 06 09 1 51s285ms 51s285ms Nov 07 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m6s - 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-11-05 08:11:54 Duration: 1m55s 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-11-03 08:06:34 Duration: 1m22s 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-11-07 08:06:16 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 4m48s 42s76ms 1m28s 57s640ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 09 1 42s76ms 42s76ms Nov 04 09 1 1m28s 1m28s Nov 05 09 1 48s347ms 48s347ms Nov 06 09 1 45s441ms 45s441ms Nov 07 08 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 4m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m48s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-04 08:00:21 Duration: 1m28s 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-11-07 07:57:36 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-05 08:00:30 Duration: 48s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 4m40s 51s434ms 1m5s 56s80ms 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 #12
Day Hour Count Duration Avg duration Nov 03 09 1 1m5s 1m5s Nov 04 09 1 51s434ms 51s434ms Nov 05 09 1 55s301ms 55s301ms Nov 06 09 1 54s978ms 54s978ms Nov 07 09 1 53s343ms 53s343ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - 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-11-03 08:03:49 Duration: 1m5s 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-11-05 08:07:37 Duration: 55s301ms 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-11-06 08:03:30 Duration: 54s978ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 4m38s 25s955ms 1m16s 55s633ms create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 03 09 1 1m7s 1m7s Nov 04 09 1 58s347ms 58s347ms Nov 05 09 1 49s938ms 49s938ms Nov 06 09 1 1m16s 1m16s Nov 07 09 1 25s955ms 25s955ms [ User: a3dsupervisor - Total duration: 4m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m38s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-11-06 08:02:34 Duration: 1m16s 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-11-03 08:02:43 Duration: 1m7s 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-11-04 08:04:14 Duration: 58s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 4m8s 29s751ms 59s451ms 49s783ms 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 #14
Day Hour Count Duration Avg duration Nov 03 09 1 54s371ms 54s371ms Nov 04 09 1 53s580ms 53s580ms Nov 05 09 1 51s760ms 51s760ms Nov 06 09 1 59s451ms 59s451ms Nov 07 09 1 29s751ms 29s751ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m8s - 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-11-06 08:04:30 Duration: 59s451ms 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-11-03 08:04:31 Duration: 54s371ms 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-11-04 08:07:19 Duration: 53s580ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 3m35s 37s162ms 54s929ms 43s65ms 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 Nov 03 08 1 38s178ms 38s178ms Nov 04 09 1 41s825ms 41s825ms Nov 05 09 1 54s929ms 54s929ms Nov 06 08 1 43s233ms 43s233ms Nov 07 09 1 37s162ms 37s162ms [ User: a3dsupervisor - Total duration: 3m35s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m35s - 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-11-05 08:04:08 Duration: 54s929ms 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-11-06 07:54:12 Duration: 43s233ms 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-11-04 08:01:41 Duration: 41s825ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 3m30s 32s479ms 1m 42s164ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 09 1 39s897ms 39s897ms Nov 04 09 1 1m 1m Nov 05 09 1 32s479ms 32s479ms Nov 06 09 1 45s246ms 45s246ms Nov 07 09 1 32s910ms 32s910ms [ User: a3dsupervisor - Total duration: 3m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-04 08:08:20 Duration: 1m 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-11-06 08:05:15 Duration: 45s246ms 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-11-03 08:05:11 Duration: 39s897ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 3m2s 24s830ms 54s530ms 36s419ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 08 1 29s553ms 29s553ms Nov 04 08 1 24s830ms 24s830ms Nov 05 08 1 54s530ms 54s530ms Nov 06 08 1 42s787ms 42s787ms Nov 07 08 1 30s394ms 30s394ms [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-11-05 07:58:58 Duration: 54s530ms 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-11-06 07:56:21 Duration: 42s787ms 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-11-07 07:56:01 Duration: 30s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 2m57s 24s308ms 1m2s 35s539ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 09 1 27s361ms 27s361ms Nov 04 09 1 1m2s 1m2s Nov 05 09 1 31s751ms 31s751ms Nov 06 08 1 24s308ms 24s308ms Nov 07 09 1 31s544ms 31s544ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-04 08:03:16 Duration: 1m2s 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-11-05 08:05:30 Duration: 31s751ms 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-11-07 08:07:35 Duration: 31s544ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 2m52s 30s604ms 37s687ms 34s406ms 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 Nov 03 08 1 35s100ms 35s100ms Nov 04 08 1 30s604ms 30s604ms Nov 05 09 1 37s687ms 37s687ms Nov 06 08 1 37s97ms 37s97ms Nov 07 08 1 31s539ms 31s539ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-05 08:00:37 Duration: 37s687ms 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-11-06 07:57:48 Duration: 37s97ms 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-11-03 07:58:26 Duration: 35s100ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 2m47s 27s802ms 37s578ms 33s481ms copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 09 1 37s578ms 37s578ms Nov 04 09 1 35s909ms 35s909ms Nov 05 09 1 29s189ms 29s189ms Nov 06 09 1 36s928ms 36s928ms Nov 07 08 1 27s802ms 27s802ms [ User: a3dsupervisor - Total duration: 2m47s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m47s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-03 08:04:26 Duration: 37s578ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-06 08:04:07 Duration: 36s928ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-04 08:07:03 Duration: 35s909ms 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 5m21s 14m4s 10m13s 5 51m6s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 03 09 1 5m21s 5m21s Nov 04 09 1 5m41s 5m41s Nov 05 09 1 14m4s 14m4s Nov 06 09 1 13m41s 13m41s Nov 07 09 1 12m18s 12m18s [ User: a3dsupervisor - Total duration: 51m6s - Times executed: 5 ]
[ Application: psql - Total duration: 51m6s - Times executed: 5 ]
-
VACUUM ANALYSE;
Date: 2025-11-05 08:57:44 Duration: 14m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-06 08:50:15 Duration: 13m41s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-07 08:54:11 Duration: 12m18s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 1m25s 2m5s 1m49s 5 9m8s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 03 08 1 1m56s 1m56s Nov 04 08 1 1m25s 1m25s Nov 05 08 1 2m5s 2m5s Nov 06 08 1 1m57s 1m57s Nov 07 08 1 1m44s 1m44s [ User: a3dsupervisor - Total duration: 9m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-05 07:58:03 Duration: 2m5s 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-11-06 07:55:38 Duration: 1m57s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-03 07:56:27 Duration: 1m56s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 1m27s 2m28s 1m44s 5 8m41s 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 Nov 03 08 1 1m30s 1m30s Nov 04 08 1 1m27s 1m27s Nov 05 08 1 2m28s 2m28s Nov 06 08 1 1m39s 1m39s Nov 07 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m41s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m41s - 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-11-05 07:56:26 Duration: 2m28s 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-11-06 07:53:27 Duration: 1m39s 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-11-07 07:53:54 Duration: 1m36s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m26s 1m51s 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 #4
Day Hour Count Duration Avg duration Nov 03 08 1 1m43s 1m43s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 1m51s 1m51s Nov 06 08 1 1m43s 1m43s Nov 07 08 1 1m43s 1m43s [ 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-11-05 07:58:18 Duration: 1m51s 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-11-06 07:55:56 Duration: 1m43s 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-11-03 07:56:51 Duration: 1m43s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 1m26s 2m 1m40s 5 8m20s 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 Nov 03 08 1 1m32s 1m32s Nov 04 08 1 1m26s 1m26s Nov 05 08 1 2m 2m Nov 06 08 1 1m51s 1m51s Nov 07 08 1 1m29s 1m29s [ User: a3dsupervisor - Total duration: 8m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m20s - 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-11-05 07:55:58 Duration: 2m 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-11-06 07:53:39 Duration: 1m51s 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-11-03 07:54:30 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m9s 2m10s 1m29s 5 7m25s alter table only public.gtp_monthly_history add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 03 08 1 1m9s 1m9s Nov 04 09 1 1m12s 1m12s Nov 05 09 1 1m31s 1m31s Nov 06 08 1 1m21s 1m21s Nov 07 08 1 2m10s 2m10s [ User: a3dsupervisor - Total duration: 7m25s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m25s - 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-11-07 07:59:31 Duration: 2m10s 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-11-05 08:02:08 Duration: 1m31s 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-11-06 07:59:10 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m5s 1m55s 1m27s 5 7m15s 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 Nov 03 09 1 1m5s 1m5s Nov 04 09 1 1m55s 1m55s Nov 05 09 1 1m41s 1m41s Nov 06 09 1 1m21s 1m21s Nov 07 09 1 1m10s 1m10s [ User: a3dsupervisor - Total duration: 7m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 7m15s - 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-11-04 08:02:58 Duration: 1m55s 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-11-05 08:04:58 Duration: 1m41s 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-11-06 08:02:35 Duration: 1m21s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 10s278ms 3m24s 1m22s 3 4m8s 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 Nov 05 09 1 10s278ms 10s278ms Nov 06 08 1 33s588ms 33s588ms Nov 07 09 1 3m24s 3m24s [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 4m8s - Times executed: 3 ]
-
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-11-07 08:02:56 Duration: 3m24s 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-11-06 07:59:43 Duration: 33s588ms 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-11-05 08:02:56 Duration: 10s278ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 42s137ms 1m55s 1m13s 5 6m6s 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 Nov 03 09 1 1m22s 1m22s Nov 04 09 1 42s137ms 42s137ms Nov 05 09 1 1m55s 1m55s Nov 06 09 1 51s285ms 51s285ms Nov 07 09 1 1m14s 1m14s [ User: a3dsupervisor - Total duration: 6m6s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m6s - 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-11-05 08:11:54 Duration: 1m55s 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-11-03 08:06:34 Duration: 1m22s 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-11-07 08:06:16 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 42s76ms 1m28s 57s640ms 5 4m48s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 03 09 1 42s76ms 42s76ms Nov 04 09 1 1m28s 1m28s Nov 05 09 1 48s347ms 48s347ms Nov 06 09 1 45s441ms 45s441ms Nov 07 08 1 1m3s 1m3s [ User: a3dsupervisor - Total duration: 4m48s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m48s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-04 08:00:21 Duration: 1m28s 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-11-07 07:57:36 Duration: 1m3s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-05 08:00:30 Duration: 48s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 51s434ms 1m5s 56s80ms 5 4m40s alter table only public.ged_right_user add constraint pk_ged_right_user primary key (user_num_id, project_num_id, node_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 03 09 1 1m5s 1m5s Nov 04 09 1 51s434ms 51s434ms Nov 05 09 1 55s301ms 55s301ms Nov 06 09 1 54s978ms 54s978ms Nov 07 09 1 53s343ms 53s343ms [ User: a3dsupervisor - Total duration: 4m40s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m40s - 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-11-03 08:03:49 Duration: 1m5s 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-11-05 08:07:37 Duration: 55s301ms 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-11-06 08:03:30 Duration: 54s978ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 25s955ms 1m16s 55s633ms 5 4m38s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 03 09 1 1m7s 1m7s Nov 04 09 1 58s347ms 58s347ms Nov 05 09 1 49s938ms 49s938ms Nov 06 09 1 1m16s 1m16s Nov 07 09 1 25s955ms 25s955ms [ User: a3dsupervisor - Total duration: 4m38s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m38s - Times executed: 5 ]
-
CREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (user_num_id);
Date: 2025-11-06 08:02:34 Duration: 1m16s 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-11-03 08:02:43 Duration: 1m7s 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-11-04 08:04:14 Duration: 58s347ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 29s751ms 59s451ms 49s783ms 5 4m8s 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 #13
Day Hour Count Duration Avg duration Nov 03 09 1 54s371ms 54s371ms Nov 04 09 1 53s580ms 53s580ms Nov 05 09 1 51s760ms 51s760ms Nov 06 09 1 59s451ms 59s451ms Nov 07 09 1 29s751ms 29s751ms [ User: a3dsupervisor - Total duration: 4m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m8s - 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-11-06 08:04:30 Duration: 59s451ms 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-11-03 08:04:31 Duration: 54s371ms 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-11-04 08:07:19 Duration: 53s580ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 8s260ms 2m17s 49s152ms 4 3m16s 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 #14
Day Hour Count Duration Avg duration Nov 03 08 1 13s561ms 13s561ms Nov 05 09 1 37s283ms 37s283ms Nov 06 08 1 8s260ms 8s260ms Nov 07 09 1 2m17s 2m17s [ User: a3dsupervisor - Total duration: 3m16s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 3m16s - Times executed: 4 ]
-
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-11-07 08:05:13 Duration: 2m17s 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-11-05 08:02:46 Duration: 37s283ms 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-11-03 07:59:49 Duration: 13s561ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 37s162ms 54s929ms 43s65ms 5 3m35s 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 Nov 03 08 1 38s178ms 38s178ms Nov 04 09 1 41s825ms 41s825ms Nov 05 09 1 54s929ms 54s929ms Nov 06 08 1 43s233ms 43s233ms Nov 07 09 1 37s162ms 37s162ms [ User: a3dsupervisor - Total duration: 3m35s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m35s - 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-11-05 08:04:08 Duration: 54s929ms 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-11-06 07:54:12 Duration: 43s233ms 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-11-04 08:01:41 Duration: 41s825ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 32s479ms 1m 42s164ms 5 3m30s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 03 09 1 39s897ms 39s897ms Nov 04 09 1 1m 1m Nov 05 09 1 32s479ms 32s479ms Nov 06 09 1 45s246ms 45s246ms Nov 07 09 1 32s910ms 32s910ms [ User: a3dsupervisor - Total duration: 3m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m30s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_history_obj_action ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);
Date: 2025-11-04 08:08:20 Duration: 1m 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-11-06 08:05:15 Duration: 45s246ms 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-11-03 08:05:11 Duration: 39s897ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 24s830ms 54s530ms 36s419ms 5 3m2s create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 03 08 1 29s553ms 29s553ms Nov 04 08 1 24s830ms 24s830ms Nov 05 08 1 54s530ms 54s530ms Nov 06 08 1 42s787ms 42s787ms Nov 07 08 1 30s394ms 30s394ms [ User: a3dsupervisor - Total duration: 3m2s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m2s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-11-05 07:58:58 Duration: 54s530ms 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-11-06 07:56:21 Duration: 42s787ms 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-11-07 07:56:01 Duration: 30s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 24s308ms 1m2s 35s539ms 5 2m57s create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 03 09 1 27s361ms 27s361ms Nov 04 09 1 1m2s 1m2s Nov 05 09 1 31s751ms 31s751ms Nov 06 08 1 24s308ms 24s308ms Nov 07 09 1 31s544ms 31s544ms [ User: a3dsupervisor - Total duration: 2m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m57s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-04 08:03:16 Duration: 1m2s 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-11-05 08:05:30 Duration: 31s751ms 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-11-07 08:07:35 Duration: 31s544ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 30s604ms 37s687ms 34s406ms 5 2m52s 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 Nov 03 08 1 35s100ms 35s100ms Nov 04 08 1 30s604ms 30s604ms Nov 05 09 1 37s687ms 37s687ms Nov 06 08 1 37s97ms 37s97ms Nov 07 08 1 31s539ms 31s539ms [ User: a3dsupervisor - Total duration: 2m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m52s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-05 08:00:37 Duration: 37s687ms 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-11-06 07:57:48 Duration: 37s97ms 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-11-03 07:58:26 Duration: 35s100ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 27s802ms 37s578ms 33s481ms 5 2m47s copy public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) from stdin;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 03 09 1 37s578ms 37s578ms Nov 04 09 1 35s909ms 35s909ms Nov 05 09 1 29s189ms 29s189ms Nov 06 09 1 36s928ms 36s928ms Nov 07 08 1 27s802ms 27s802ms [ User: a3dsupervisor - Total duration: 2m47s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m47s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-03 08:04:26 Duration: 37s578ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-06 08:04:07 Duration: 36s928ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) FROM stdin;
Date: 2025-11-04 08:07:03 Duration: 35s909ms 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
- 329,391 Log entries
Events distribution
Key values
- 0 PANIC entries
- 1 FATAL entries
- 315745 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 315,647 Max number of times the same event was reported
- 315,746 Total events found
Rank Times reported Error 1 315,647 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 03 10 2,700 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,341 20 3,600 21 3,600 22 3,600 23 3,600 00 3,600 Nov 04 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,148 10 2,700 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,596 17 3,600 18 3,600 19 3,334 20 3,600 21 3,587 22 3,600 23 3,610 00 3,600 Nov 05 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,136 10 1,800 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,610 18 3,600 19 3,283 20 3,600 21 3,581 22 3,600 23 3,600 00 3,600 Nov 06 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,144 10 2,700 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,233 20 3,610 21 3,594 22 3,600 23 3,600 00 3,600 Nov 07 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,140 2 27 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 03 10 5 13 2 19 2 Nov 04 16 3 19 2 Nov 05 19 5 21 2 Nov 06 12 2 19 3 Nov 07 10 1 3 10 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 03 09 2 Nov 04 09 1 Nov 05 09 4 Nov 06 09 3 4 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_PARAMS (...) NOT NULL , PARAMETER_TYPE VARCHAR(...) NOT NULL , PARAMETER_VALUE VARCHAR(...) , IDENTIFYING CHAR(...) NOT NULL , constraint JOB_EXEC_PARAMS_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 5 4 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #5
Day Hour Count Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 Nov 07 09 1 6 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION (...) NOT NULL, JOB_EXECUTION_ID BIGINT NOT NULL, CREATE_TIME TIMESTAMP NOT NULL, START_TIME TIMESTAMP DEFAULT NULL , END_TIME TIMESTAMP DEFAULT NULL , STATUS VARCHAR(...) , COMMIT_COUNT BIGINT , READ_COUNT BIGINT , FILTER_COUNT BIGINT , WRITE_COUNT BIGINT , READ_SKIP_COUNT BIGINT , WRITE_SKIP_COUNT BIGINT , PROCESS_SKIP_COUNT BIGINT , ROLLBACK_COUNT BIGINT , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_EXEC_STEP_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 7 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #7
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 8 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #8
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 9 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION (...) , EXIT_CODE VARCHAR(...) , EXIT_MESSAGE VARCHAR(...) , LAST_UPDATED TIMESTAMP, constraint JOB_INST_EXEC_FK foreign key (...) references BATCH_JOB_INSTANCE(...) )
Times Reported Most Frequent Error / Event #9
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 10 4 ERROR: relation "..." already existsCREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint STEP_EXEC_CTX_FK foreign key (...) references BATCH_STEP_EXECUTION(...) )
Times Reported Most Frequent Error / Event #10
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 11 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 12 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_INSTANCE (...) NOT NULL, JOB_KEY VARCHAR(...) NOT NULL, constraint JOB_INST_UN unique (...) )
Times Reported Most Frequent Error / Event #12
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 13 4 ERROR: relation "..." already existsCREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (...) NOT NULL, SERIALIZED_CONTEXT TEXT , constraint JOB_EXEC_CTX_FK foreign key (...) references BATCH_JOB_EXECUTION(...) )
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 03 09 1 Nov 04 09 1 Nov 05 09 1 Nov 06 09 1 14 3 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... msinsert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #14
Day Hour Count Nov 04 21 1 Nov 05 20 1 21 1 15 3 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 04 09 2 Nov 05 09 1 16 3 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 #16
Day Hour Count Nov 04 20 1 21 1 Nov 06 21 1 17 2 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 #17
Day Hour Count Nov 05 09 1 Nov 07 09 1 18 1 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 Nov 04 09 1 19 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 03 08 1 20 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition ADD CONSTRAINT fk_gtp_obj_compo_obj FOREIGN KEY (...) REFERENCES public.gtp_obj(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #20
Day Hour Count Nov 06 08 1 21 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (...) REFERENCES public.gtp_att_unit(...)
Times Reported Most Frequent Error / Event #21
Day Hour Count Nov 04 09 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_gtp_obj_compo_value_case ON public.gtp_obj_composition USING btree (...)::text))
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 06 08 1 23 1 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 #23
Day Hour Count Nov 07 09 1 24 1 FATAL: cannot connect to invalid database "..."
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 05 08 1 25 1 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 #25
Day Hour Count Nov 05 09 1 26 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (...) REFERENCES public.gtp_obj(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #26
Day Hour Count Nov 07 09 1 27 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_concerned
Times Reported Most Frequent Error / Event #27
Day Hour Count Nov 04 09 1 28 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_doc_deleted ADD CONSTRAINT fk_history_doc_deleted_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #28
Day Hour Count Nov 07 09 1