pgBadger-
Global information
- Generated on Mon Nov 17 09:35:29 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=15/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=15/h=23/m=00/PT1H.log
- Parsed 639,918 log entries in 1m10s
- Log start from 2025-11-10 08:07:45 to 2025-11-14 08:06:20
-
Overview
Global Stats
- 93 Number of unique normalized queries
- 235 Number of queries
- 3h29m20s Total query duration
- 2025-11-10 07:55:48 First query
- 2025-11-14 08:06:20 Last query
- 3 queries/s at 2025-11-12 20:40:35 Query peak
- 3h29m20s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 3h29m20s Execute total duration
- 312,588 Number of events
- 25 Number of unique normalized events
- 312,500 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
- 656 Number temporary file
- 1.16 GiB Max size of temporary file
- 42.98 MiB Average size of temporary file
- 4,524 Total number of sessions
- 147 sessions at 2025-11-09 19:47:23 Session peak
- 11d10h24m23s Total duration of sessions
- 3m38s Average duration of sessions
- 0 Average queries per session
- 2s776ms Average queries duration per session
- 3m35s Average idle time per session
- 4,524 Total number of connections
- 11 connections/s at 2025-11-13 09:18:57 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-12 20:40:35 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-11 20:42:33 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2025-11-12 20:40:35 Date
Queries duration
Key values
- 3h29m20s 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 09 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 10 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 12 0ms 2m6s 56s330ms 4m43s 4m43s 4m43s 08 36 0ms 7m4s 1m5s 3m58s 6m28s 7m4s 09 1 0ms 13m45s 13m45s 0ms 0ms 13m45s 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 6 0ms 8s88ms 6s863ms 0ms 5s920ms 24s192ms 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 11 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 3m2s 1m21s 2m15s 3m56s 3m56s 08 31 0ms 14m54s 1m5s 2m29s 3m48s 14m54s 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 8s932ms 6s564ms 0ms 10s156ms 28s120ms 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 12 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 42 0ms 3m23s 41s581ms 2m56s 3m10s 3m23s 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 6 0ms 6s674ms 5s844ms 0ms 6s508ms 17s545ms 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 13 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 10 0ms 1m55s 57s212ms 1m50s 2m59s 4m2s 08 28 0ms 1m19s 26s847ms 1m50s 1m55s 2m32s 09 1 0ms 22m27s 22m27s 0ms 0ms 22m27s 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 3 0ms 8s534ms 7s787ms 0ms 0ms 23s361ms 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 1 0ms 6s21ms 6s21ms 0ms 0ms 6s21ms 20 10 0ms 8s452ms 6s199ms 0ms 17s102ms 19s29ms 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 14 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 1m36s 51s314ms 1m45s 2m54s 3m4s 08 18 0ms 1m46s 39s418ms 2m52s 3m31s 3m31s 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 15 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 09 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 10 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 11 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 6s944ms 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 12 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 13 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 14 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 15 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 09 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 10 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 1m7s 0ms 42s347ms 3m14s 08 0 0 0 4 51s477ms 0ms 0ms 1m28s 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 11 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 3 1m59s 0ms 0ms 2m3s 08 0 0 0 5 48s972ms 0ms 0ms 2m12s 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 0 0 6s968ms 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 12 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 7 55s672ms 0ms 0ms 1m55s 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 13 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 3 1m12s 0ms 0ms 39s605ms 08 0 0 0 4 38s314ms 0ms 0ms 54s789ms 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 3 0 7s787ms 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 1 0 8s452ms 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 14 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 3 1m16s 0ms 0ms 44s844ms 08 0 0 0 5 28s252ms 0ms 35s992ms 40s857ms 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 15 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 09 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 10 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 6 6.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 11 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 12 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 6 6.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 13 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 3 3.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 1 1.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 14 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 15 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 09 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 Nov 10 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 8 0.00/s 08 7 0.00/s 09 81 0.02/s 10 54 0.01/s 11 47 0.01/s 12 47 0.01/s 13 48 0.01/s 14 52 0.01/s 15 49 0.01/s 16 57 0.02/s 17 53 0.01/s 18 49 0.01/s 19 44 0.01/s 20 39 0.01/s 21 43 0.01/s 22 54 0.01/s 23 41 0.01/s Nov 11 00 50 0.01/s 01 41 0.01/s 02 48 0.01/s 03 37 0.01/s 04 46 0.01/s 05 51 0.01/s 06 49 0.01/s 07 21 0.01/s 08 19 0.01/s 09 60 0.02/s 10 46 0.01/s 11 47 0.01/s 12 43 0.01/s 13 41 0.01/s 14 42 0.01/s 15 42 0.01/s 16 42 0.01/s 17 43 0.01/s 18 40 0.01/s 19 43 0.01/s 20 44 0.01/s 21 51 0.01/s 22 53 0.01/s 23 43 0.01/s Nov 12 00 47 0.01/s 01 49 0.01/s 02 48 0.01/s 03 45 0.01/s 04 44 0.01/s 05 46 0.01/s 06 43 0.01/s 07 19 0.01/s 08 49 0.01/s 09 56 0.02/s 10 45 0.01/s 11 43 0.01/s 12 47 0.01/s 13 47 0.01/s 14 49 0.01/s 15 54 0.01/s 16 47 0.01/s 17 40 0.01/s 18 29 0.01/s 19 42 0.01/s 20 38 0.01/s 21 41 0.01/s 22 47 0.01/s 23 42 0.01/s Nov 13 00 49 0.01/s 01 41 0.01/s 02 47 0.01/s 03 42 0.01/s 04 44 0.01/s 05 44 0.01/s 06 38 0.01/s 07 24 0.01/s 08 10 0.00/s 09 61 0.02/s 10 54 0.01/s 11 52 0.01/s 12 39 0.01/s 13 51 0.01/s 14 50 0.01/s 15 43 0.01/s 16 51 0.01/s 17 48 0.01/s 18 46 0.01/s 19 48 0.01/s 20 40 0.01/s 21 49 0.01/s 22 45 0.01/s 23 55 0.02/s Nov 14 00 51 0.01/s 01 39 0.01/s 02 36 0.01/s 03 40 0.01/s 04 45 0.01/s 05 44 0.01/s 06 41 0.01/s 07 21 0.01/s 08 6 0.00/s 09 15 0.00/s 10 22 0.01/s 11 4 0.00/s 12 4 0.00/s 13 9 0.00/s 14 6 0.00/s 15 10 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 Nov 15 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 2 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 09 00 3 70ms 70ms 01 3 75ms 75ms 02 3 88ms 88ms 03 3 73ms 73ms 04 3 69ms 69ms 05 3 69ms 69ms 06 3 72ms 72ms 07 3 68ms 68ms 08 3 73ms 73ms 09 3 74ms 74ms 10 3 77ms 77ms 11 3 73ms 73ms 12 3 70ms 70ms 13 3 71ms 71ms 14 3 74ms 74ms 15 3 72ms 72ms 16 3 73ms 73ms 17 3 74ms 74ms 18 3 72ms 72ms 19 3 73ms 73ms 20 3 69ms 69ms 21 3 72ms 72ms 22 3 75ms 75ms 23 3 69ms 69ms Nov 10 00 3 70ms 70ms 01 3 73ms 73ms 02 3 80ms 80ms 03 3 72ms 72ms 04 3 68ms 68ms 05 3 66ms 66ms 06 3 73ms 73ms 07 6 2s475ms 0ms 08 8 15m15s 10m19s 09 79 59s299ms 48s851ms 10 53 1m20s 1m20s 11 46 1m17s 1m17s 12 47 1m20s 1m20s 13 51 1m21s 1m21s 14 49 1m13s 1m13s 15 51 1m18s 1m18s 16 57 1m14s 1m14s 17 54 1m20s 1m20s 18 46 24m13s 24m13s 19 47 1m15s 1m15s 20 39 1m35s 1m33s 21 43 1m15s 1m15s 22 54 1m14s 1m14s 23 41 1m19s 1m19s Nov 11 00 50 1m18s 1m18s 01 40 1m18s 1m18s 02 49 1m17s 1m17s 03 37 1m23s 1m23s 04 46 1m17s 1m17s 05 51 1m15s 1m15s 06 48 1m14s 1m14s 07 22 1h12m5s 1h11m31s 08 9 12m46s 9m1s 09 70 1m8s 1m8s 10 46 1m19s 1m19s 11 46 1m16s 1m16s 12 44 1m20s 1m20s 13 41 1m19s 1m19s 14 42 1m20s 1m20s 15 41 1m22s 1m22s 16 43 1m18s 1m18s 17 43 1m22s 1m22s 18 40 28m11s 28m11s 19 43 1m16s 1m16s 20 44 1m32s 1m30s 21 51 1m17s 1m17s 22 53 1m11s 1m11s 23 43 1m27s 1m27s Nov 12 00 46 1m17s 1m17s 01 49 1m16s 1m16s 02 49 1m23s 1m23s 03 44 1m18s 1m18s 04 45 1m18s 1m18s 05 46 1m20s 1m20s 06 43 1m15s 1m15s 07 20 1h18m45s 1h18m45s 08 48 2m33s 1m57s 09 54 1m18s 1m18s 10 47 1m13s 1m13s 11 43 1m26s 1m26s 12 47 1m23s 1m23s 13 47 1m17s 1m17s 14 49 1m17s 1m17s 15 53 1m17s 1m17s 16 48 1m24s 1m24s 17 39 1m16s 1m16s 18 30 37m52s 37m52s 19 42 1m18s 1m18s 20 37 1m44s 1m43s 21 42 1m24s 1m24s 22 47 1m16s 1m16s 23 42 1m24s 1m24s Nov 13 00 49 1m22s 1m22s 01 41 1m18s 1m18s 02 47 1m19s 1m19s 03 42 1m23s 1m23s 04 44 1m16s 1m16s 05 44 1m18s 1m18s 06 38 1m24s 1m24s 07 24 1h5m25s 1h5m2s 08 11 10m54s 9m46s 09 60 1m12s 50s57ms 10 54 1m15s 1m15s 11 52 1m19s 1m19s 12 39 1m17s 1m17s 13 51 1m19s 1m19s 14 50 1m16s 1m15s 15 43 1m22s 1m22s 16 51 1m16s 1m16s 17 48 1m22s 1m22s 18 46 23m48s 23m48s 19 48 1m42s 1m42s 20 40 1m42s 1m40s 21 49 1m16s 1m16s 22 45 1m17s 1m17s 23 55 1m18s 1m18s Nov 14 00 50 1m14s 1m14s 01 40 1m23s 1m23s 02 36 1m15s 1m15s 03 40 1m17s 1m17s 04 45 1m18s 1m18s 05 44 1m13s 1m13s 06 41 1m19s 1m19s 07 21 1h15m11s 1h14m44s 08 8 2m50s 1m21s 09 15 106ms 106ms 10 22 168ms 168ms 11 4 132ms 132ms 12 4 122ms 122ms 13 9 210ms 210ms 14 6 99ms 99ms 15 10 237ms 237ms 16 3 81ms 81ms 17 3 79ms 79ms 18 3 71ms 71ms 19 3 68ms 68ms 20 3 69ms 69ms 21 3 72ms 72ms 22 3 82ms 82ms 23 3 75ms 75ms Nov 15 00 3 75ms 75ms 01 3 67ms 67ms 02 3 71ms 71ms 03 3 68ms 68ms 04 3 67ms 67ms 05 3 69ms 69ms 06 3 73ms 73ms 07 3 71ms 71ms 08 3 77ms 77ms 09 3 75ms 75ms 10 3 71ms 71ms 11 3 66ms 66ms 12 3 67ms 67ms 13 3 74ms 74ms 14 3 69ms 69ms 15 3 67ms 67ms 16 3 68ms 68ms 17 3 75ms 75ms 18 2 68ms 68ms 19 3 108ms 108ms 20 3 69ms 69ms 21 3 67ms 67ms 22 3 73ms 73ms 23 3 74ms 74ms -
Connections
Established Connections
Key values
- 11 connections Connection Peak
- 2025-11-13 09:18:57 Date
Connections per database
Key values
- cnrs Main Database
- 4,524 connections Total
Connections per user
Key values
- a3dsupervisor Main User
- 4,524 connections Total
-
Sessions
Simultaneous sessions
Key values
- 147 sessions Session Peak
- 2025-11-09 19:47:23 Date
Histogram of session times
Key values
- 3,782 60000-600000ms duration
Sessions per database
Key values
- cnrs Main Database
- 4,524 sessions Total
Sessions per user
Key values
- a3dsupervisor Main User
- 4,524 sessions Total
Sessions per host
Key values
- 10.3.0.4 Main Host
- 4,524 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 714.09 MiB Temp Files size Peak
- 2025-11-13 08:01:36 Date
Number of temporary files
Key values
- 8 per second Temp Files Peak
- 2025-11-13 08:06:54 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 09 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 10 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 20 2.15 GiB 109.86 MiB 08 144 3.66 GiB 26.05 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 11 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 12 1.61 GiB 137.32 MiB 08 114 3.93 GiB 35.28 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 12 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 153 5.76 GiB 38.53 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 13 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 125 4.08 GiB 33.42 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 14 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 52 2.31 GiB 45.57 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 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 15 4.83 GiB 85.00 MiB 1.16 GiB 329.58 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-14 07:57:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
2 15 2.88 GiB 40.56 MiB 1.13 GiB 196.88 MiB add constraint pk_history_obj_compo primary key (history_compo_id);-
ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);
Date: 2025-11-14 08:03:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 15 3.49 GiB 197.10 MiB 271.28 MiB 238.03 MiB add constraint u_hist_obj_cat_att_year_month_line_type unique (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);-
ADD CONSTRAINT u_hist_obj_cat_att_year_month_line_type UNIQUE (obj_num_id, att_template_category_num_id, att_template_num_id, year, month, histo_num_id_tab, tab_line, type);
Date: 2025-11-14 08:01:21 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 15 538.42 MiB 23.88 MiB 78.34 MiB 35.89 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-14 08:01:41 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 13 2.45 GiB 13.10 MiB 841.02 MiB 192.63 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-14 08:01:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 13 1.07 GiB 47.30 MiB 459.16 MiB 84.24 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-14 08:04:18 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 12 945.13 MiB 13.55 MiB 217.53 MiB 78.76 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-13 08:06:09 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 12 4.30 GiB 140.84 MiB 945.79 MiB 367.29 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-13 08:04:24 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 11 49.20 MiB 2.12 MiB 11.86 MiB 4.47 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-13 08:06:43 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 9 387.91 MiB 10.88 MiB 139.62 MiB 43.10 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-13 08:01:50 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 8 54.04 MiB 2.05 MiB 20.46 MiB 6.75 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-13 08:01:46 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 7 89.60 MiB 2.13 MiB 34.77 MiB 12.80 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-14 08:00:20 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 7 165.05 MiB 1.99 MiB 57.91 MiB 23.58 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-14 08:01:22 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 6 309.80 MiB 47.67 MiB 55.55 MiB 51.63 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-13 08:08:12 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 37.90 MiB 2.20 MiB 10.78 MiB 7.58 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-13 08:06:51 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4 70.05 MiB 2.96 MiB 53.55 MiB 17.51 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-13 08:05:59 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 2 71.65 MiB 7.09 MiB 64.55 MiB 35.82 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-12 08:08:23 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 2 25.80 MiB 9.14 MiB 16.66 MiB 12.90 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-13 08:01:07 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 1 8.42 MiB 8.42 MiB 8.42 MiB 8.42 MiB add constraint fk_gtp_month_histo_att_cat foreign key (att_template_category_num_id) references public.gtp_att_template_category (att_template_category_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_month_histo_att_cat FOREIGN KEY (att_template_category_num_id) REFERENCES public.gtp_att_template_category (att_template_category_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-11 08:09:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 1 18.95 MiB 18.95 MiB 18.95 MiB 18.95 MiB add constraint fk_gtp_monthly_history_unit foreign key (att_unit_num_id) references public.gtp_att_unit (att_unit_num_id);-
ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-11-11 08:08:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
21 1 15.73 MiB 15.73 MiB 15.73 MiB 15.73 MiB add constraint pk_gtp_obj primary key (obj_num_id);-
ADD CONSTRAINT pk_gtp_obj PRIMARY KEY (obj_num_id);
Date: 2025-11-12 08:11:13 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
22 1 4.70 MiB 4.70 MiB 4.70 MiB 4.70 MiB add constraint fk_gtp_obj_compo_tab foreign key (obj_compo_num_id_tab) references public.gtp_obj_composition (obj_compo_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_gtp_obj_compo_tab FOREIGN KEY (obj_compo_num_id_tab) REFERENCES public.gtp_obj_composition (obj_compo_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:16:39 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
23 1 143.93 MiB 143.93 MiB 143.93 MiB 143.93 MiB add constraint pk_a3d_log primary key (log_num_id);-
ADD CONSTRAINT pk_a3d_log PRIMARY KEY (log_num_id);
Date: 2025-11-13 08:02:23 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
24 1 9.05 MiB 9.05 MiB 9.05 MiB 9.05 MiB add constraint fk_hist_obj_link_unlink_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;-
ADD CONSTRAINT fk_hist_obj_link_unlink_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-12 08:14:53 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
25 1 2.37 MiB 2.37 MiB 2.37 MiB 2.37 MiB add constraint pk_eng_gtp_datalink_objdid primary key (obj_num_id, eng_data_id);-
ADD CONSTRAINT pk_eng_gtp_datalink_objdid PRIMARY KEY (obj_num_id, eng_data_id);
Date: 2025-11-10 08:01:12 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.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-10 07:58:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
2 1.16 GiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-12 08:02:58 - 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-14 07:57:51 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
4 1.13 GiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-12 08:02:58 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 945.79 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-12 08:07:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 896.27 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-11 08:03:12 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 895.16 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-10 08:10:36 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
8 841.02 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-13 08:02:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 541.46 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-10 08:04:44 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 485.46 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-12 08:09:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 482.38 MiB ADD CONSTRAINT pk_gtp_obj_compo PRIMARY KEY (obj_compo_num_id);[ Date: 2025-11-11 08:02:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 459.16 MiB ADD CONSTRAINT pk_history_obj_action PRIMARY KEY (action_num_id);[ Date: 2025-11-14 08:04:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 440.71 MiB ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);[ Date: 2025-11-13 08:04:24 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 363.42 MiB ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);[ Date: 2025-11-11 08:00:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 341.00 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-11 08:02:34 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 336.81 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-14 08:03:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 332.80 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-13 08:02:17 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 330.48 MiB ADD CONSTRAINT pk_history_obj_compo PRIMARY KEY (history_compo_id);[ Date: 2025-11-10 08:02:27 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 271.28 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-11 08:01:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 245.91 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-12 08:05:49 - 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 09 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 10 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 11 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 12 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 13 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 14 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 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ExclusiveLock Main Lock Type
- 37 locks Total
Type Object Count Total Duration Average Duration (s) AccessExclusiveLock 1 1s233ms 1s233ms relation 1 1s233ms 1s233ms AccessShareLock 1 1s114ms 1s114ms relation 1 1s114ms 1s114ms ExclusiveLock 17 24s930ms 1s466ms extension 17 24s930ms 1s466ms RowExclusiveLock 2 5s680ms 2s840ms relation 2 5s680ms 2s840ms ShareLock 5 8s240ms 1s648ms relation 5 8s240ms 1s648ms ShareRowExclusiveLock 8 8s81ms 1s10ms relation 8 8s81ms 1s10ms ShareUpdateExclusiveLock 3 6s192ms 2s64ms relation 3 6s192ms 2s64ms Total 37 55s474ms 1s499ms 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
- 1 Total read queries
- 230 Total write queries
Queries by database
Key values
- cnrs Main database
- 235 Requests
- 3h29m20s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 235 Requests
User Request type Count Duration a3dsupervisor Total 235 3h29m20s copy from 38 36m54s ddl 157 1h54m1s delete 4 31s814ms insert 1 6s968ms others 4 54m30s select 1 6s944ms tcl 30 3m7s Duration by user
Key values
- 3h29m20s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 235 3h29m20s copy from 38 36m54s ddl 157 1h54m1s delete 4 31s814ms insert 1 6s968ms others 4 54m30s select 1 6s944ms tcl 30 3m7s Queries by host
Key values
- 10.3.0.4 Main host
- 235 Requests
- 3h29m20s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_restore Main application
- 195 Requests
- 2h30m56s (pg_restore)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-10 23:15:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 158 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 22m27s VACUUM ANALYSE;[ Date: 2025-11-13 09:17:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
2 14m54s VACUUM ANALYSE;[ Date: 2025-11-11 08:58:51 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
3 13m45s VACUUM ANALYSE;[ Date: 2025-11-10 09:09:12 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
4 7m4s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-10 08:09:45 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
5 6m17s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-10 08:16:03 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
6 3m52s 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-10 08:22:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
7 3m23s VACUUM ANALYSE;[ Date: 2025-11-12 08:50:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: psql ]
8 3m17s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-10 08:19:23 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
9 3m2s 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-11 07:56:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
10 2m6s ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_gtp_obj_compo_history_new_unit FOREIGN KEY (obj_compo_new_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id) DEFERRABLE INITIALLY DEFERRED;[ Date: 2025-11-10 08:10:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
11 2m6s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-10 07:58:04 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
12 2m3s 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-11 07:55:49 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
13 1m58s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-11 07:58:50 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
14 1m57s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-11 07:58:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
15 1m55s CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);[ Date: 2025-11-13 07:58:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
16 1m54s ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);[ Date: 2025-11-12 08:12:29 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
17 1m53s CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);[ Date: 2025-11-10 08:12:30 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
18 1m51s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-10 07:58:23 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
19 1m46s 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-14 08:04:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_restore ]
20 1m45s CREATE INDEX i_fk_month_histo_att_cat ON public.gtp_monthly_history USING btree (att_template_category_num_id);[ Date: 2025-11-13 07:58:57 - 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 54m30s 4 3m23s 22m27s 13m37s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 10 1 13m45s 13m45s Nov 11 09 1 14m54s 14m54s Nov 12 09 1 3m23s 3m23s Nov 13 10 1 22m27s 22m27s [ User: a3dsupervisor - Total duration: 54m30s - Times executed: 4 ]
[ Application: psql - Total duration: 54m30s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:17:40 Duration: 22m27s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-11 08:58:51 Duration: 14m54s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-10 09:09:12 Duration: 13m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 9m15s 5 1m27s 3m2s 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 08 1 1m42s 1m42s Nov 11 08 1 3m2s 3m2s Nov 12 09 1 1m30s 1m30s Nov 13 08 1 1m32s 1m32s Nov 14 08 1 1m27s 1m27s [ User: a3dsupervisor - Total duration: 9m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m15s - 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-11 07:56:48 Duration: 3m2s 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-10 07:55:58 Duration: 1m42s 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-13 07:56:36 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 8m57s 5 1m26s 2m6s 1m47s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 10 08 1 2m6s 2m6s Nov 11 08 1 1m57s 1m57s Nov 12 09 1 1m26s 1m26s Nov 13 08 1 1m55s 1m55s Nov 14 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 8m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m57s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-10 07:58:04 Duration: 2m6s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-11 07:58:46 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-13 07:58:31 Duration: 1m55s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 8m21s 5 1m23s 1m58s 1m40s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 10 08 1 1m51s 1m51s Nov 11 08 1 1m58s 1m58s Nov 12 09 1 1m23s 1m23s Nov 13 08 1 1m45s 1m45s Nov 14 08 1 1m23s 1m23s [ User: a3dsupervisor - Total duration: 8m21s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m21s - 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-11 07:58:50 Duration: 1m58s 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-10 07:58:23 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-13 07:58:57 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 8m11s 5 1m26s 2m3s 1m38s 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 10 08 1 1m32s 1m32s Nov 11 08 1 2m3s 2m3s Nov 12 09 1 1m32s 1m32s Nov 13 08 1 1m26s 1m26s Nov 14 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m11s - 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-11 07:55:49 Duration: 2m3s 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-14 07:56:31 Duration: 1m36s 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-12 08:01:35 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 8m7s 5 1m5s 1m53s 1m37s 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 #6
Day Hour Count Duration Avg duration Nov 10 09 1 1m53s 1m53s Nov 11 09 1 1m38s 1m38s Nov 12 09 1 1m44s 1m44s Nov 13 09 1 1m5s 1m5s Nov 14 09 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 8m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m7s - 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-10 08:12:30 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-14 08:04:18 Duration: 1m46s 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-12 08:07:46 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 7m12s 4 22s89ms 3m52s 1m48s alter table only public.gtp_history_obj_compo add constraint fk_history_obj_compo_action foreign key (action_num_id) references public.gtp_history_obj_action (action_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 10 09 1 3m52s 3m52s Nov 11 09 1 1m37s 1m37s Nov 12 09 1 22s89ms 22s89ms Nov 13 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 7m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m12s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:22:08 Duration: 3m52s 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-11 08:10:12 Duration: 1m37s 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-13 08:08:14 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 7m4s 1 7m4s 7m4s 7m4s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 10 09 1 7m4s 7m4s [ User: a3dsupervisor - Total duration: 7m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 7m4s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:09:45 Duration: 7m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 6m20s 5 56s859ms 1m41s 1m16s 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 #9
Day Hour Count Duration Avg duration Nov 10 09 1 1m19s 1m19s Nov 11 09 1 56s859ms 56s859ms Nov 12 09 1 1m14s 1m14s Nov 13 09 1 1m8s 1m8s Nov 14 09 1 1m41s 1m41s [ User: a3dsupervisor - Total duration: 6m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m20s - 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-14 08:01:22 Duration: 1m41s 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-10 08:01:17 Duration: 1m19s 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-12 08:05:49 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 6m17s 1 6m17s 6m17s 6m17s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 10 09 1 6m17s 6m17s [ User: a3dsupervisor - Total duration: 6m17s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 6m17s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:16:03 Duration: 6m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5m30s 5 50s902ms 1m31s 1m6s 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 10 09 1 50s902ms 50s902ms Nov 11 09 1 1m31s 1m31s Nov 12 09 1 1m1s 1m1s Nov 13 09 1 58s906ms 58s906ms Nov 14 09 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 5m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m30s - 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-11 08:05:20 Duration: 1m31s 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-14 08:06:20 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-12 08:09:10 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5m5s 5 35s146ms 1m33s 1m1s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 10 09 1 1m15s 1m15s Nov 11 09 1 57s412ms 57s412ms Nov 12 09 1 1m33s 1m33s Nov 13 09 1 35s146ms 35s146ms Nov 14 08 1 44s844ms 44s844ms [ User: a3dsupervisor - Total duration: 5m5s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m5s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-12 08:05:25 Duration: 1m33s 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-10 08:04:11 Duration: 1m15s 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-11 08:03:41 Duration: 57s412ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5m1s 4 56s224ms 1m22s 1m15s 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 #13
Day Hour Count Duration Avg duration Nov 10 09 1 1m22s 1m22s Nov 11 09 1 1m19s 1m19s Nov 12 09 1 1m22s 1m22s Nov 13 09 1 56s224ms 56s224ms [ User: a3dsupervisor - Total duration: 5m1s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 5m1s - Times executed: 4 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-10 08:14:43 Duration: 1m22s 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-12 08:10:33 Duration: 1m22s 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-11 08:06:40 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 4m52s 5 30s828ms 1m28s 58s448ms 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 10 09 1 1m28s 1m28s Nov 11 09 1 1m22s 1m22s Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 54s789ms 54s789ms Nov 14 09 1 35s992ms 35s992ms [ User: a3dsupervisor - Total duration: 4m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m52s - 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-10 08:07:21 Duration: 1m28s 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-11 08:07:47 Duration: 1m22s 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-13 08:06:14 Duration: 54s789ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 4m37s 5 30s828ms 1m20s 55s531ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 10 09 1 1m20s 1m20s Nov 11 09 1 46s832ms 46s832ms Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 40s734ms 40s734ms Nov 14 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 4m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m37s - 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-10 08:18:15 Duration: 1m20s 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-14 08:06:07 Duration: 1m18s 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-11 08:08:34 Duration: 46s832ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 4m20s 5 23s969ms 1m15s 52s57ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 10 09 1 46s200ms 46s200ms Nov 11 09 1 44s201ms 44s201ms Nov 12 09 1 1m10s 1m10s Nov 13 09 1 23s969ms 23s969ms Nov 14 09 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 4m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m20s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-14 08:04:49 Duration: 1m15s 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-12 08:08:08 Duration: 1m10s 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-10 08:02:27 Duration: 46s200ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 3m34s 5 39s605ms 53s567ms 42s976ms 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 #17
Day Hour Count Duration Avg duration Nov 10 08 1 42s347ms 42s347ms Nov 11 08 1 53s567ms 53s567ms Nov 12 09 1 39s718ms 39s718ms Nov 13 08 1 39s605ms 39s605ms Nov 14 09 1 39s645ms 39s645ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m34s - 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-11 07:56:51 Duration: 53s567ms 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-10 07:56:32 Duration: 42s347ms 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-12 08:06:31 Duration: 39s718ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 3m29s 3 5s333ms 3m17s 1m9s alter table only public.gtp_monthly_history add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 10 09 1 3m17s 3m17s Nov 12 09 1 5s333ms 5s333ms Nov 13 09 1 6s692ms 6s692ms [ User: a3dsupervisor - Total duration: 3m29s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 3m29s - Times executed: 3 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:19:23 Duration: 3m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-13 08:02:08 Duration: 6s692ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-12 08:13:26 Duration: 5s333ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 3m7s 30 5s31ms 8s932ms 6s251ms commit;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 10 21 6 41s183ms 6s863ms Nov 11 21 8 51s733ms 6s466ms Nov 12 21 6 35s68ms 5s844ms Nov 13 20 1 6s21ms 6s21ms 21 9 53s544ms 5s949ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 30 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m7s - Times executed: 30 ]
-
COMMIT;
Date: 2025-11-11 20:42:33 Duration: 8s932ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 20:47:31 Duration: 8s88ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 20:47:31 Duration: 8s52ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
20 3m3s 2 1m8s 1m54s 1m31s alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_unit foreign key (att_unit_num_id) references public.gtp_att_unit (att_unit_num_id);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 11 09 1 1m8s 1m8s Nov 12 09 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 3m3s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m3s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-11-12 08:12:29 Duration: 1m54s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-11-11 08:09:52 Duration: 1m8s 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 30 3m7s 5s31ms 8s932ms 6s251ms commit;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 21 6 41s183ms 6s863ms Nov 11 21 8 51s733ms 6s466ms Nov 12 21 6 35s68ms 5s844ms Nov 13 20 1 6s21ms 6s21ms 21 9 53s544ms 5s949ms [ User: a3dsupervisor - Total duration: 3m7s - Times executed: 30 ]
[ Application: PostgreSQL JDBC Driver - Total duration: 3m7s - Times executed: 30 ]
-
COMMIT;
Date: 2025-11-11 20:42:33 Duration: 8s932ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 20:47:31 Duration: 8s88ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
-
COMMIT;
Date: 2025-11-10 20:47:31 Duration: 8s52ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: PostgreSQL JDBC Driver Bind query: yes
2 5 9m15s 1m27s 3m2s 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;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 08 1 1m42s 1m42s Nov 11 08 1 3m2s 3m2s Nov 12 09 1 1m30s 1m30s Nov 13 08 1 1m32s 1m32s Nov 14 08 1 1m27s 1m27s [ User: a3dsupervisor - Total duration: 9m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m15s - 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-11 07:56:48 Duration: 3m2s 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-10 07:55:58 Duration: 1m42s 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-13 07:56:36 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 5 8m57s 1m26s 2m6s 1m47s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 10 08 1 2m6s 2m6s Nov 11 08 1 1m57s 1m57s Nov 12 09 1 1m26s 1m26s Nov 13 08 1 1m55s 1m55s Nov 14 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 8m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m57s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-10 07:58:04 Duration: 2m6s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-11 07:58:46 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-13 07:58:31 Duration: 1m55s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 5 8m21s 1m23s 1m58s 1m40s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 10 08 1 1m51s 1m51s Nov 11 08 1 1m58s 1m58s Nov 12 09 1 1m23s 1m23s Nov 13 08 1 1m45s 1m45s Nov 14 08 1 1m23s 1m23s [ User: a3dsupervisor - Total duration: 8m21s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m21s - 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-11 07:58:50 Duration: 1m58s 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-10 07:58:23 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-13 07:58:57 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 5 8m11s 1m26s 2m3s 1m38s 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 10 08 1 1m32s 1m32s Nov 11 08 1 2m3s 2m3s Nov 12 09 1 1m32s 1m32s Nov 13 08 1 1m26s 1m26s Nov 14 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m11s - 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-11 07:55:49 Duration: 2m3s 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-14 07:56:31 Duration: 1m36s 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-12 08:01:35 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 5 8m7s 1m5s 1m53s 1m37s 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 #6
Day Hour Count Duration Avg duration Nov 10 09 1 1m53s 1m53s Nov 11 09 1 1m38s 1m38s Nov 12 09 1 1m44s 1m44s Nov 13 09 1 1m5s 1m5s Nov 14 09 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 8m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m7s - 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-10 08:12:30 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-14 08:04:18 Duration: 1m46s 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-12 08:07:46 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 5 6m20s 56s859ms 1m41s 1m16s 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 #7
Day Hour Count Duration Avg duration Nov 10 09 1 1m19s 1m19s Nov 11 09 1 56s859ms 56s859ms Nov 12 09 1 1m14s 1m14s Nov 13 09 1 1m8s 1m8s Nov 14 09 1 1m41s 1m41s [ User: a3dsupervisor - Total duration: 6m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m20s - 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-14 08:01:22 Duration: 1m41s 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-10 08:01:17 Duration: 1m19s 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-12 08:05:49 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 5 5m30s 50s902ms 1m31s 1m6s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Nov 10 09 1 50s902ms 50s902ms Nov 11 09 1 1m31s 1m31s Nov 12 09 1 1m1s 1m1s Nov 13 09 1 58s906ms 58s906ms Nov 14 09 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 5m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m30s - 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-11 08:05:20 Duration: 1m31s 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-14 08:06:20 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-12 08:09:10 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 5 5m5s 35s146ms 1m33s 1m1s 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 10 09 1 1m15s 1m15s Nov 11 09 1 57s412ms 57s412ms Nov 12 09 1 1m33s 1m33s Nov 13 09 1 35s146ms 35s146ms Nov 14 08 1 44s844ms 44s844ms [ User: a3dsupervisor - Total duration: 5m5s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m5s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-12 08:05:25 Duration: 1m33s 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-10 08:04:11 Duration: 1m15s 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-11 08:03:41 Duration: 57s412ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 5 4m52s 30s828ms 1m28s 58s448ms 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 #10
Day Hour Count Duration Avg duration Nov 10 09 1 1m28s 1m28s Nov 11 09 1 1m22s 1m22s Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 54s789ms 54s789ms Nov 14 09 1 35s992ms 35s992ms [ User: a3dsupervisor - Total duration: 4m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m52s - 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-10 08:07:21 Duration: 1m28s 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-11 08:07:47 Duration: 1m22s 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-13 08:06:14 Duration: 54s789ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 5 4m37s 30s828ms 1m20s 55s531ms alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Nov 10 09 1 1m20s 1m20s Nov 11 09 1 46s832ms 46s832ms Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 40s734ms 40s734ms Nov 14 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 4m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m37s - 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-10 08:18:15 Duration: 1m20s 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-14 08:06:07 Duration: 1m18s 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-11 08:08:34 Duration: 46s832ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 5 4m20s 23s969ms 1m15s 52s57ms create index i_history_compo_action on public.gtp_history_obj_compo using btree (action_num_id);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Nov 10 09 1 46s200ms 46s200ms Nov 11 09 1 44s201ms 44s201ms Nov 12 09 1 1m10s 1m10s Nov 13 09 1 23s969ms 23s969ms Nov 14 09 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 4m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m20s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-14 08:04:49 Duration: 1m15s 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-12 08:08:08 Duration: 1m10s 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-10 08:02:27 Duration: 46s200ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5 3m34s 39s605ms 53s567ms 42s976ms 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 #13
Day Hour Count Duration Avg duration Nov 10 08 1 42s347ms 42s347ms Nov 11 08 1 53s567ms 53s567ms Nov 12 09 1 39s718ms 39s718ms Nov 13 08 1 39s605ms 39s605ms Nov 14 09 1 39s645ms 39s645ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m34s - 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-11 07:56:51 Duration: 53s567ms 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-10 07:56:32 Duration: 42s347ms 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-12 08:06:31 Duration: 39s718ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 5 2m50s 27s933ms 36s349ms 34s49ms alter table only public.gtp_monthly_history add constraint pk_gtp_monthly_history primary key (histo_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 10 08 1 35s433ms 35s433ms Nov 11 09 1 34s827ms 34s827ms Nov 12 09 1 27s933ms 27s933ms Nov 13 09 1 35s706ms 35s706ms Nov 14 08 1 36s349ms 36s349ms [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m50s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-14 07:59:40 Duration: 36s349ms 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-13 08:00:28 Duration: 35s706ms 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-10 07:59:58 Duration: 35s433ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 5 2m46s 19s893ms 50s124ms 33s311ms 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 #15
Day Hour Count Duration Avg duration Nov 10 09 1 35s439ms 35s439ms Nov 11 09 1 50s124ms 50s124ms Nov 12 09 1 19s893ms 19s893ms Nov 13 09 1 36s335ms 36s335ms Nov 14 09 1 24s767ms 24s767ms [ User: a3dsupervisor - Total duration: 2m46s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m46s - 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-11 08:07:30 Duration: 50s124ms 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-13 08:05:57 Duration: 36s335ms 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-10 08:15:23 Duration: 35s439ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 5 2m46s 22s645ms 48s258ms 33s276ms copy public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) from stdin;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Nov 10 08 1 35s194ms 35s194ms Nov 11 09 1 48s258ms 48s258ms Nov 12 09 1 22s645ms 22s645ms Nov 13 09 1 26s986ms 26s986ms Nov 14 09 1 33s299ms 33s299ms [ User: a3dsupervisor - Total duration: 2m46s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m46s - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-11 08:00:46 Duration: 48s258ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-10 07:59:51 Duration: 35s194ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) FROM stdin;
Date: 2025-11-14 08:00:06 Duration: 33s299ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 5 2m24s 25s245ms 31s385ms 28s876ms create index i_fk_monthly_history_histo_num_id_tab on public.gtp_monthly_history using btree (histo_num_id_tab);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 10 08 1 31s385ms 31s385ms Nov 11 08 1 30s742ms 30s742ms Nov 12 09 1 25s245ms 25s245ms Nov 13 08 1 28s651ms 28s651ms Nov 14 08 1 28s357ms 28s357ms [ User: a3dsupervisor - Total duration: 2m24s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m24s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2025-11-10 07:59:16 Duration: 31s385ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2025-11-11 07:59:58 Duration: 30s742ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_history_histo_num_id_tab ON public.gtp_monthly_history USING btree (histo_num_id_tab);
Date: 2025-11-13 07:59:49 Duration: 28s651ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 5 2m18s 21s293ms 37s288ms 27s796ms create index i_fk_month_histo_modifier on public.gtp_monthly_history using btree (histo_modifier);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Nov 10 08 1 21s293ms 21s293ms Nov 11 08 1 37s288ms 37s288ms Nov 12 09 1 27s526ms 27s526ms Nov 13 08 1 26s988ms 26s988ms Nov 14 08 1 25s882ms 25s882ms [ User: a3dsupervisor - Total duration: 2m18s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m18s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-11-11 07:59:27 Duration: 37s288ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-11-12 08:03:26 Duration: 27s526ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_modifier ON public.gtp_monthly_history USING btree (histo_modifier);
Date: 2025-11-13 07:59:20 Duration: 26s988ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 5 2m14s 24s444ms 31s939ms 26s982ms create index i_fk_monthly_histo_obj on public.gtp_monthly_history using btree (obj_num_id);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Nov 10 08 1 31s939ms 31s939ms Nov 11 08 1 27s351ms 27s351ms Nov 12 09 1 26s615ms 26s615ms Nov 13 08 1 24s561ms 24s561ms Nov 14 08 1 24s444ms 24s444ms [ User: a3dsupervisor - Total duration: 2m14s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m14s - Times executed: 5 ]
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-11-10 07:59:00 Duration: 31s939ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-11-11 07:59:53 Duration: 27s351ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_monthly_histo_obj ON public.gtp_monthly_history USING btree (obj_num_id);
Date: 2025-11-12 08:03:47 Duration: 26s615ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 5 2m8s 20s540ms 39s696ms 25s723ms create index i_fk_month_histo_creator on public.gtp_monthly_history using btree (histo_creator);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Nov 10 08 1 24s403ms 24s403ms Nov 11 08 1 39s696ms 39s696ms Nov 12 09 1 22s34ms 22s34ms Nov 13 08 1 21s944ms 21s944ms Nov 14 08 1 20s540ms 20s540ms [ User: a3dsupervisor - Total duration: 2m8s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m8s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_creator ON public.gtp_monthly_history USING btree (histo_creator);
Date: 2025-11-11 07:59:26 Duration: 39s696ms 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-10 07:58:29 Duration: 24s403ms 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-12 08:03:21 Duration: 22s34ms 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 3m23s 22m27s 13m37s 4 54m30s vacuum analyse;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 10 10 1 13m45s 13m45s Nov 11 09 1 14m54s 14m54s Nov 12 09 1 3m23s 3m23s Nov 13 10 1 22m27s 22m27s [ User: a3dsupervisor - Total duration: 54m30s - Times executed: 4 ]
[ Application: psql - Total duration: 54m30s - Times executed: 4 ]
-
VACUUM ANALYSE;
Date: 2025-11-13 09:17:40 Duration: 22m27s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-11 08:58:51 Duration: 14m54s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
-
VACUUM ANALYSE;
Date: 2025-11-10 09:09:12 Duration: 13m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: psql
2 7m4s 7m4s 7m4s 1 7m4s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_creator foreign key (histo_creator) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 10 09 1 7m4s 7m4s [ User: a3dsupervisor - Total duration: 7m4s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 7m4s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_creator FOREIGN KEY (histo_creator) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:09:45 Duration: 7m4s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
3 6m17s 6m17s 6m17s 1 6m17s alter table only public.gtp_monthly_history add constraint fk_gtp_month_histo_modifier foreign key (histo_modifier) references public.a3d_user (user_num_id) deferrable initially deferred;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 10 09 1 6m17s 6m17s [ User: a3dsupervisor - Total duration: 6m17s - Times executed: 1 ]
[ Application: pg_restore - Total duration: 6m17s - Times executed: 1 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_histo_modifier FOREIGN KEY (histo_modifier) REFERENCES public.a3d_user (user_num_id) DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:16:03 Duration: 6m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
4 1m27s 3m2s 1m51s 5 9m15s copy public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) from stdin;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 10 08 1 1m42s 1m42s Nov 11 08 1 3m2s 3m2s Nov 12 09 1 1m30s 1m30s Nov 13 08 1 1m32s 1m32s Nov 14 08 1 1m27s 1m27s [ User: a3dsupervisor - Total duration: 9m15s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 9m15s - 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-11 07:56:48 Duration: 3m2s 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-10 07:55:58 Duration: 1m42s 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-13 07:56:36 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
5 22s89ms 3m52s 1m48s 4 7m12s 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 #5
Day Hour Count Duration Avg duration Nov 10 09 1 3m52s 3m52s Nov 11 09 1 1m37s 1m37s Nov 12 09 1 22s89ms 22s89ms Nov 13 09 1 1m19s 1m19s [ User: a3dsupervisor - Total duration: 7m12s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 7m12s - Times executed: 4 ]
-
ALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (action_num_id) REFERENCES public.gtp_history_obj_action (action_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:22:08 Duration: 3m52s 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-11 08:10:12 Duration: 1m37s 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-13 08:08:14 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
6 1m26s 2m6s 1m47s 5 8m57s create index i_fk_month_histo_att on public.gtp_monthly_history using btree (att_template_num_id);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Nov 10 08 1 2m6s 2m6s Nov 11 08 1 1m57s 1m57s Nov 12 09 1 1m26s 1m26s Nov 13 08 1 1m55s 1m55s Nov 14 08 1 1m31s 1m31s [ User: a3dsupervisor - Total duration: 8m57s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m57s - Times executed: 5 ]
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-10 07:58:04 Duration: 2m6s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_month_histo_att ON public.gtp_monthly_history USING btree (att_template_num_id);
Date: 2025-11-11 07:58:46 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-13 07:58:31 Duration: 1m55s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
7 1m23s 1m58s 1m40s 5 8m21s create index i_fk_month_histo_att_cat on public.gtp_monthly_history using btree (att_template_category_num_id);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Nov 10 08 1 1m51s 1m51s Nov 11 08 1 1m58s 1m58s Nov 12 09 1 1m23s 1m23s Nov 13 08 1 1m45s 1m45s Nov 14 08 1 1m23s 1m23s [ User: a3dsupervisor - Total duration: 8m21s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m21s - 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-11 07:58:50 Duration: 1m58s 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-10 07:58:23 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-13 07:58:57 Duration: 1m45s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
8 1m26s 2m3s 1m38s 5 8m11s 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 #8
Day Hour Count Duration Avg duration Nov 10 08 1 1m32s 1m32s Nov 11 08 1 2m3s 2m3s Nov 12 09 1 1m32s 1m32s Nov 13 08 1 1m26s 1m26s Nov 14 08 1 1m36s 1m36s [ User: a3dsupervisor - Total duration: 8m11s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m11s - 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-11 07:55:49 Duration: 2m3s 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-14 07:56:31 Duration: 1m36s 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-12 08:01:35 Duration: 1m32s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
9 1m5s 1m53s 1m37s 5 8m7s 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 10 09 1 1m53s 1m53s Nov 11 09 1 1m38s 1m38s Nov 12 09 1 1m44s 1m44s Nov 13 09 1 1m5s 1m5s Nov 14 09 1 1m46s 1m46s [ User: a3dsupervisor - Total duration: 8m7s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 8m7s - 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-10 08:12:30 Duration: 1m53s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
CREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (project_num_id, node_num_id);
Date: 2025-11-14 08:04:18 Duration: 1m46s 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-12 08:07:46 Duration: 1m44s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
10 1m8s 1m54s 1m31s 2 3m3s alter table only public.gtp_monthly_history add constraint fk_gtp_monthly_history_unit foreign key (att_unit_num_id) references public.gtp_att_unit (att_unit_num_id);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Nov 11 09 1 1m8s 1m8s Nov 12 09 1 1m54s 1m54s [ User: a3dsupervisor - Total duration: 3m3s - Times executed: 2 ]
[ Application: pg_restore - Total duration: 3m3s - Times executed: 2 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-11-12 08:12:29 Duration: 1m54s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_monthly_history_unit FOREIGN KEY (att_unit_num_id) REFERENCES public.gtp_att_unit (att_unit_num_id);
Date: 2025-11-11 08:09:52 Duration: 1m8s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
11 56s859ms 1m41s 1m16s 5 6m20s 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 #11
Day Hour Count Duration Avg duration Nov 10 09 1 1m19s 1m19s Nov 11 09 1 56s859ms 56s859ms Nov 12 09 1 1m14s 1m14s Nov 13 09 1 1m8s 1m8s Nov 14 09 1 1m41s 1m41s [ User: a3dsupervisor - Total duration: 6m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 6m20s - 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-14 08:01:22 Duration: 1m41s 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-10 08:01:17 Duration: 1m19s 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-12 08:05:49 Duration: 1m14s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
12 56s224ms 1m22s 1m15s 4 5m1s 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 10 09 1 1m22s 1m22s Nov 11 09 1 1m19s 1m19s Nov 12 09 1 1m22s 1m22s Nov 13 09 1 56s224ms 56s224ms [ User: a3dsupervisor - Total duration: 5m1s - Times executed: 4 ]
[ Application: pg_restore - Total duration: 5m1s - Times executed: 4 ]
-
ALTER TABLE ONLY public.ged_right_user ADD CONSTRAINT pk_ged_right_user PRIMARY KEY (user_num_id, project_num_id, node_num_id);
Date: 2025-11-10 08:14:43 Duration: 1m22s 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-12 08:10:33 Duration: 1m22s 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-11 08:06:40 Duration: 1m19s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
13 5s333ms 3m17s 1m9s 3 3m29s alter table only public.gtp_monthly_history add constraint fk_gtp_month_history_obj foreign key (obj_num_id) references public.gtp_obj (obj_num_id) on delete cascade deferrable initially deferred;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Nov 10 09 1 3m17s 3m17s Nov 12 09 1 5s333ms 5s333ms Nov 13 09 1 6s692ms 6s692ms [ User: a3dsupervisor - Total duration: 3m29s - Times executed: 3 ]
[ Application: pg_restore - Total duration: 3m29s - Times executed: 3 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-10 08:19:23 Duration: 3m17s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-13 08:02:08 Duration: 6s692ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT fk_gtp_month_history_obj FOREIGN KEY (obj_num_id) REFERENCES public.gtp_obj (obj_num_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
Date: 2025-11-12 08:13:26 Duration: 5s333ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
14 50s902ms 1m31s 1m6s 5 5m30s create index i_fk_ged_right_user_ged_user on public.ged_right_user using btree (user_num_id);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Nov 10 09 1 50s902ms 50s902ms Nov 11 09 1 1m31s 1m31s Nov 12 09 1 1m1s 1m1s Nov 13 09 1 58s906ms 58s906ms Nov 14 09 1 1m7s 1m7s [ User: a3dsupervisor - Total duration: 5m30s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m30s - 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-11 08:05:20 Duration: 1m31s 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-14 08:06:20 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-12 08:09:10 Duration: 1m1s Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
15 35s146ms 1m33s 1m1s 5 5m5s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) from stdin;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Nov 10 09 1 1m15s 1m15s Nov 11 09 1 57s412ms 57s412ms Nov 12 09 1 1m33s 1m33s Nov 13 09 1 35s146ms 35s146ms Nov 14 08 1 44s844ms 44s844ms [ User: a3dsupervisor - Total duration: 5m5s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 5m5s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) FROM stdin;
Date: 2025-11-12 08:05:25 Duration: 1m33s 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-10 08:04:11 Duration: 1m15s 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-11 08:03:41 Duration: 57s412ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
16 30s828ms 1m28s 58s448ms 5 4m52s 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 #16
Day Hour Count Duration Avg duration Nov 10 09 1 1m28s 1m28s Nov 11 09 1 1m22s 1m22s Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 54s789ms 54s789ms Nov 14 09 1 35s992ms 35s992ms [ User: a3dsupervisor - Total duration: 4m52s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m52s - 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-10 08:07:21 Duration: 1m28s 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-11 08:07:47 Duration: 1m22s 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-13 08:06:14 Duration: 54s789ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
17 30s828ms 1m20s 55s531ms 5 4m37s alter table only public.gtp_history_obj_action add constraint pk_history_obj_action primary key (action_num_id);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Nov 10 09 1 1m20s 1m20s Nov 11 09 1 46s832ms 46s832ms Nov 12 09 1 30s828ms 30s828ms Nov 13 09 1 40s734ms 40s734ms Nov 14 09 1 1m18s 1m18s [ User: a3dsupervisor - Total duration: 4m37s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m37s - 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-10 08:18:15 Duration: 1m20s 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-14 08:06:07 Duration: 1m18s 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-11 08:08:34 Duration: 46s832ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
18 23s969ms 1m15s 52s57ms 5 4m20s 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 10 09 1 46s200ms 46s200ms Nov 11 09 1 44s201ms 44s201ms Nov 12 09 1 1m10s 1m10s Nov 13 09 1 23s969ms 23s969ms Nov 14 09 1 1m15s 1m15s [ User: a3dsupervisor - Total duration: 4m20s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 4m20s - Times executed: 5 ]
-
CREATE INDEX i_history_compo_action ON public.gtp_history_obj_compo USING btree (action_num_id);
Date: 2025-11-14 08:04:49 Duration: 1m15s 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-12 08:08:08 Duration: 1m10s 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-10 08:02:27 Duration: 46s200ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
19 39s605ms 53s567ms 42s976ms 5 3m34s 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 #19
Day Hour Count Duration Avg duration Nov 10 08 1 42s347ms 42s347ms Nov 11 08 1 53s567ms 53s567ms Nov 12 09 1 39s718ms 39s718ms Nov 13 08 1 39s605ms 39s605ms Nov 14 09 1 39s645ms 39s645ms [ User: a3dsupervisor - Total duration: 3m34s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 3m34s - 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-11 07:56:51 Duration: 53s567ms 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-10 07:56:32 Duration: 42s347ms 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-12 08:06:31 Duration: 39s718ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_restore
20 27s933ms 36s349ms 34s49ms 5 2m50s 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 10 08 1 35s433ms 35s433ms Nov 11 09 1 34s827ms 34s827ms Nov 12 09 1 27s933ms 27s933ms Nov 13 09 1 35s706ms 35s706ms Nov 14 08 1 36s349ms 36s349ms [ User: a3dsupervisor - Total duration: 2m50s - Times executed: 5 ]
[ Application: pg_restore - Total duration: 2m50s - Times executed: 5 ]
-
ALTER TABLE ONLY public.gtp_monthly_history ADD CONSTRAINT pk_gtp_monthly_history PRIMARY KEY (histo_num_id);
Date: 2025-11-14 07:59:40 Duration: 36s349ms 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-13 08:00:28 Duration: 35s706ms 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-10 07:59:58 Duration: 35s433ms 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
- 327,095 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 312588 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 312,500 Max number of times the same event was reported
- 312,588 Total events found
Rank Times reported Error 1 312,500 ERROR: duplicate key value violates unique constraint "..."insert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 10 10 1,799 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,290 20 3,600 21 3,563 22 3,600 23 3,600 00 3,600 Nov 11 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,151 10 1,800 11 3,600 12 3,600 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,168 20 3,600 21 3,576 22 3,600 23 3,600 00 3,600 Nov 12 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,120 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,113 20 3,600 21 3,586 22 3,600 23 3,600 00 3,600 Nov 13 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,142 10 900 11 3,600 12 3,590 13 3,600 14 3,600 15 3,600 16 3,600 17 3,600 18 3,600 19 3,274 20 3,600 21 3,584 22 3,600 23 3,600 00 3,600 Nov 14 01 3,600 02 3,600 03 3,600 04 3,600 05 3,600 06 3,600 07 3,600 08 1,144 2 17 LOG: process ... still waiting for ExclusiveLock on extension of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 10 09 2 Nov 11 09 3 Nov 12 09 4 Nov 13 09 8 3 15 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 10 19 2 Nov 11 19 2 Nov 12 19 3 Nov 13 19 6 Nov 14 09 2 4 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_STEP_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 5 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 #5
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 6 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_EXECUTION_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #6
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 7 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 #7
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 8 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 #8
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 9 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 #9
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 10 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 #10
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 11 4 ERROR: relation "..." already existsCREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE
Times Reported Most Frequent Error / Event #11
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 12 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 #12
Day Hour Count Nov 10 10 1 Nov 11 09 1 Nov 12 09 1 Nov 13 10 1 13 3 LOG: process ... still waiting for ShareUpdateExclusiveLock on relation ... of database ... after ... msVACUUM ANALYSE
Times Reported Most Frequent Error / Event #13
Day Hour Count Nov 11 09 1 Nov 12 09 1 Nov 13 09 1 14 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 #14
Day Hour Count Nov 10 09 1 Nov 11 09 1 Nov 12 09 1 15 2 LOG: process ... still waiting for RowExclusiveLock on relation ... of database ... after ... msinsert into GTP_LOG_METRIC (...) values (...)
Times Reported Most Frequent Error / Event #15
Day Hour Count Nov 13 08 1 21 1 16 2 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_obj_composition
Times Reported Most Frequent Error / Event #16
Day Hour Count Nov 10 09 1 Nov 13 09 1 17 2 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_ged_right_user_ged_user ON public.ged_right_user USING btree (...)
Times Reported Most Frequent Error / Event #17
Day Hour Count Nov 12 09 1 Nov 14 09 1 18 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 #18
Day Hour Count Nov 12 09 1 19 1 LOG: process ... still waiting for ShareRowExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_compo ADD CONSTRAINT fk_history_obj_compo_action FOREIGN KEY (...) REFERENCES public.gtp_history_obj_action(...) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Times Reported Most Frequent Error / Event #19
Day Hour Count Nov 12 09 1 20 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 #20
Day Hour Count Nov 14 09 1 21 1 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 #21
Day Hour Count Nov 13 20 1 22 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_ligne_tab ON public.gtp_obj_composition USING btree (...)
Times Reported Most Frequent Error / Event #22
Day Hour Count Nov 11 09 1 23 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_ged_right_user_ged_node ON public.ged_right_user USING btree (...)
Times Reported Most Frequent Error / Event #23
Day Hour Count Nov 14 09 1 24 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... msALTER TABLE ONLY public.gtp_history_obj_action
Times Reported Most Frequent Error / Event #24
Day Hour Count Nov 14 09 1 25 1 LOG: process ... still waiting for ShareLock on relation ... of database ... after ... msCREATE INDEX i_fk_gtp_obj_compo_history_new_unit ON public.gtp_history_obj_compo USING btree (...)
Times Reported Most Frequent Error / Event #25
Day Hour Count Nov 11 09 1