pgBadger-
Global information
- Generated on Mon Sep 29 09:34:02 2025
- Log file: ././A3D-RND-REF/y=2025/m=09/d=27/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=09/d=27/h=23/m=00/PT1H.log
- Parsed 2,495,495 log entries in 3m6s
- Log start from 2025-09-23 00:09:47 to 2025-09-27 23:47:00
-
Overview
Global Stats
- 750 Number of unique normalized queries
- 5,453 Number of queries
- 11m28s Total query duration
- 2025-09-23 00:09:47 First query
- 2025-09-27 23:47:00 Last query
- 203 queries/s at 2025-09-23 06:19:27 Query peak
- 11m28s Total query duration
- 1s253ms Prepare/parse total duration
- 1s392ms Bind total duration
- 11m25s Execute total duration
- 0 Number of events
- 0 Number of unique normalized events
- 0 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
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 326 Total number of sessions
- 2 sessions at 2025-09-23 06:40:25 Session peak
- 6h53m11s Total duration of sessions
- 1m16s Average duration of sessions
- 16 Average queries per session
- 2s111ms Average queries duration per session
- 1m13s Average idle time per session
- 325 Total number of connections
- 3 connections/s at 2025-09-26 13:16:44 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 203 queries/s Query Peak
- 2025-09-23 06:19:27 Date
SELECT Traffic
Key values
- 182 queries/s Query Peak
- 2025-09-25 06:19:17 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 53 queries/s Query Peak
- 2025-09-25 06:56:44 Date
Queries duration
Key values
- 11m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 6 0ms 6ms 1ms 6ms 6ms 6ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 8ms 2ms 8ms 8ms 8ms 03 6 0ms 4ms 1ms 4ms 4ms 4ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 4ms 1ms 4ms 4ms 4ms 06 1,117 0ms 38s401ms 161ms 1s165ms 38s401ms 1m52s 07 48 0ms 87ms 15ms 274ms 274ms 274ms 08 31 0ms 53ms 12ms 260ms 260ms 260ms 09 54 0ms 57ms 14ms 257ms 257ms 257ms 10 7 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 6ms 1ms 6ms 6ms 6ms 12 6 0ms 4ms 1ms 4ms 4ms 4ms 13 12 0ms 4ms 0ms 4ms 4ms 4ms 14 10 0ms 4ms 1ms 4ms 4ms 4ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 6ms 1ms 6ms 6ms 6ms 18 6 0ms 4ms 1ms 4ms 4ms 4ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 9ms 2ms 10ms 10ms 10ms 21 6 0ms 6ms 1ms 6ms 6ms 6ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 5ms 5ms 5ms Sep 24 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 5ms 5ms 5ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 4ms 1ms 5ms 5ms 5ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 6ms 1ms 6ms 6ms 6ms 06 1,109 0ms 45s639ms 169ms 600ms 41s752ms 2m13s 07 54 0ms 76ms 15ms 260ms 260ms 260ms 08 30 0ms 54ms 13ms 258ms 258ms 258ms 09 15 0ms 54ms 9ms 131ms 131ms 131ms 10 19 0ms 103ms 14ms 231ms 231ms 231ms 11 6 0ms 5ms 1ms 5ms 5ms 5ms 12 7 0ms 4ms 1ms 4ms 4ms 4ms 13 6 0ms 4ms 1ms 4ms 4ms 4ms 14 6 0ms 4ms 1ms 4ms 4ms 4ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 1ms 7ms 7ms 7ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 4ms 1ms 4ms 4ms 4ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Sep 25 00 6 0ms 8ms 2ms 8ms 8ms 8ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 5ms 1ms 6ms 6ms 6ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 4ms 1ms 5ms 5ms 5ms 06 1,109 0ms 39s116ms 140ms 1s227ms 51s340ms 1m16s 07 6 0ms 6ms 1ms 6ms 6ms 6ms 08 6 0ms 4ms 1ms 4ms 4ms 4ms 09 15 0ms 84ms 13ms 192ms 192ms 192ms 10 6 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 9 0ms 4ms 1ms 4ms 4ms 4ms 13 10 0ms 4ms 1ms 4ms 4ms 4ms 14 8 0ms 4ms 1ms 4ms 4ms 4ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 1ms 7ms 7ms 7ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 4ms 1ms 4ms 4ms 4ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Sep 26 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 5ms 5ms 5ms 03 6 0ms 4ms 1ms 4ms 4ms 4ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 4ms 1ms 4ms 4ms 4ms 06 1,109 0ms 39s572ms 140ms 112ms 1m3s 1m30s 07 7 0ms 8ms 2ms 8ms 8ms 8ms 08 30 0ms 68ms 14ms 262ms 262ms 262ms 09 6 0ms 4ms 1ms 4ms 4ms 4ms 10 6 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 14 0ms 52ms 10ms 139ms 139ms 139ms 13 14 0ms 4ms 0ms 4ms 4ms 4ms 14 39 0ms 55ms 13ms 264ms 264ms 264ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 1ms 6ms 6ms 6ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 4ms 1ms 4ms 4ms 4ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Sep 27 00 6 0ms 4ms 1ms 5ms 5ms 5ms 01 6 0ms 5ms 1ms 5ms 5ms 5ms 02 6 0ms 4ms 1ms 5ms 5ms 5ms 03 6 0ms 4ms 1ms 4ms 4ms 4ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 4ms 1ms 5ms 5ms 5ms 06 6 0ms 4ms 1ms 4ms 4ms 4ms 07 6 0ms 4ms 1ms 4ms 4ms 4ms 08 6 0ms 4ms 1ms 4ms 4ms 4ms 09 6 0ms 4ms 1ms 5ms 5ms 5ms 10 6 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 6 0ms 8ms 2ms 8ms 8ms 8ms 13 6 0ms 4ms 1ms 5ms 5ms 5ms 14 6 0ms 4ms 1ms 4ms 4ms 4ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 5ms 1ms 5ms 5ms 5ms 18 6 0ms 4ms 1ms 5ms 5ms 5ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 4ms 1ms 5ms 5ms 5ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 5ms 5ms 5ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 3 0 3ms 6ms 6ms 6ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 4ms 8ms 8ms 8ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 444 245 261ms 0ms 1s111ms 1m52s 07 45 0 16ms 204ms 274ms 274ms 08 28 0 14ms 260ms 260ms 260ms 09 51 0 15ms 132ms 257ms 257ms 10 4 0 2ms 4ms 4ms 4ms 11 3 0 3ms 6ms 6ms 6ms 12 3 0 3ms 4ms 4ms 4ms 13 9 0 1ms 4ms 4ms 4ms 14 7 0 1ms 4ms 4ms 4ms 15 3 0 2ms 4ms 4ms 4ms 16 3 0 3ms 4ms 4ms 4ms 17 3 0 3ms 6ms 6ms 6ms 18 3 0 3ms 4ms 4ms 4ms 19 3 0 2ms 4ms 4ms 4ms 20 3 0 4ms 10ms 10ms 10ms 21 3 0 3ms 6ms 6ms 6ms 22 3 0 2ms 4ms 4ms 4ms 23 3 0 3ms 4ms 4ms 4ms Sep 24 00 3 0 2ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 2ms 4ms 4ms 4ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 2ms 4ms 4ms 4ms 05 3 0 3ms 6ms 6ms 6ms 06 436 245 275ms 0ms 551ms 2m13s 07 51 0 16ms 186ms 260ms 260ms 08 27 0 14ms 258ms 258ms 258ms 09 12 0 11ms 131ms 131ms 131ms 10 15 0 18ms 231ms 231ms 231ms 11 3 0 3ms 5ms 5ms 5ms 12 4 0 2ms 4ms 4ms 4ms 13 3 0 3ms 4ms 4ms 4ms 14 3 0 3ms 4ms 4ms 4ms 15 3 0 3ms 4ms 4ms 4ms 16 3 0 3ms 4ms 4ms 4ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 3ms 7ms 7ms 7ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Sep 25 00 3 0 4ms 8ms 8ms 8ms 01 3 0 2ms 4ms 4ms 4ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 3ms 5ms 5ms 5ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 436 245 229ms 0ms 1s168ms 1m16s 07 3 0 3ms 6ms 6ms 6ms 08 3 0 3ms 4ms 4ms 4ms 09 12 0 16ms 192ms 192ms 192ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 6 0 1ms 4ms 4ms 4ms 13 7 0 1ms 4ms 4ms 4ms 14 5 0 1ms 4ms 4ms 4ms 15 3 0 2ms 4ms 4ms 4ms 16 3 0 3ms 4ms 4ms 4ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 3ms 7ms 7ms 7ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 3ms 4ms 4ms 4ms Sep 26 00 3 0 3ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 3ms 5ms 5ms 5ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 2ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 436 245 227ms 0ms 107ms 1m30s 07 4 0 3ms 8ms 8ms 8ms 08 27 0 16ms 262ms 262ms 262ms 09 3 0 3ms 4ms 4ms 4ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 11 0 13ms 139ms 139ms 139ms 13 11 0 1ms 4ms 4ms 4ms 14 36 0 14ms 264ms 264ms 264ms 15 3 0 2ms 4ms 4ms 4ms 16 3 0 2ms 4ms 4ms 4ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 3ms 6ms 6ms 6ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 2ms 4ms 4ms 4ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Sep 27 00 3 0 3ms 5ms 5ms 5ms 01 3 0 3ms 5ms 5ms 5ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 2ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 3 0 3ms 4ms 4ms 4ms 07 3 0 3ms 4ms 4ms 4ms 08 3 0 3ms 4ms 4ms 4ms 09 3 0 3ms 4ms 4ms 4ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 3 0 4ms 8ms 8ms 8ms 13 3 0 3ms 4ms 4ms 4ms 14 3 0 2ms 4ms 4ms 4ms 15 3 0 2ms 4ms 4ms 4ms 16 3 0 3ms 4ms 4ms 4ms 17 3 0 3ms 5ms 5ms 5ms 18 3 0 3ms 4ms 4ms 4ms 19 3 0 2ms 4ms 4ms 4ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 2ms 4ms 4ms 4ms 23 3 0 3ms 4ms 4ms 4ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 23 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Sep 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Sep 25 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 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 Sep 26 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Sep 27 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 23 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 17 152 8.94 2.45% 07 48 48 1.00 106.67% 08 31 31 1.00 110.71% 09 54 54 1.00 105.88% 10 7 7 1.00 175.00% 11 6 6 1.00 200.00% 12 6 6 1.00 200.00% 13 12 12 1.00 133.33% 14 10 10 1.00 142.86% 15 6 6 1.00 200.00% 16 6 6 1.00 200.00% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Sep 24 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 9 144 16.00 1.31% 07 54 54 1.00 105.88% 08 30 30 1.00 111.11% 09 15 15 1.00 125.00% 10 19 19 1.00 126.67% 11 6 6 1.00 200.00% 12 7 7 1.00 175.00% 13 6 6 1.00 200.00% 14 6 6 1.00 200.00% 15 6 6 1.00 200.00% 16 6 6 1.00 200.00% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Sep 25 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 9 144 16.00 1.31% 07 6 6 1.00 200.00% 08 6 6 1.00 200.00% 09 15 15 1.00 125.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 9 9 1.00 150.00% 13 10 10 1.00 142.86% 14 8 8 1.00 160.00% 15 6 6 1.00 200.00% 16 6 6 1.00 200.00% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Sep 26 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 9 144 16.00 1.31% 07 7 7 1.00 175.00% 08 30 30 1.00 111.11% 09 6 6 1.00 200.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 14 14 1.00 127.27% 13 14 14 1.00 127.27% 14 39 39 1.00 108.33% 15 6 6 1.00 200.00% 16 6 6 1.00 200.00% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Sep 27 00 6 6 1.00 200.00% 01 6 6 1.00 200.00% 02 6 6 1.00 200.00% 03 6 6 1.00 200.00% 04 6 6 1.00 200.00% 05 6 6 1.00 200.00% 06 6 6 1.00 200.00% 07 6 6 1.00 200.00% 08 6 6 1.00 200.00% 09 6 6 1.00 200.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 6 6 1.00 200.00% 13 6 6 1.00 200.00% 14 6 6 1.00 200.00% 15 6 6 1.00 200.00% 16 6 6 1.00 200.00% 17 6 6 1.00 200.00% 18 6 6 1.00 200.00% 19 6 6 1.00 200.00% 20 6 6 1.00 200.00% 21 6 6 1.00 200.00% 22 6 6 1.00 200.00% 23 6 6 1.00 200.00% Day Hour Count Average / Second Sep 23 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 6 0.00/s 07 9 0.00/s 08 6 0.00/s 09 8 0.00/s 10 3 0.00/s 11 2 0.00/s 12 2 0.00/s 13 8 0.00/s 14 6 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Sep 24 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 8 0.00/s 08 5 0.00/s 09 3 0.00/s 10 6 0.00/s 11 2 0.00/s 12 3 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Sep 25 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 2 0.00/s 08 2 0.00/s 09 4 0.00/s 10 2 0.00/s 11 2 0.00/s 12 5 0.00/s 13 6 0.00/s 14 4 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Sep 26 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 3 0.00/s 08 5 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 3 0.00/s 13 10 0.00/s 14 7 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Sep 27 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 2 0.00/s 07 2 0.00/s 08 2 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 2 0.00/s 14 2 0.00/s 15 2 0.00/s 16 2 0.00/s 17 2 0.00/s 18 2 0.00/s 19 2 0.00/s 20 2 0.00/s 21 2 0.00/s 22 2 0.00/s 23 2 0.00/s Day Hour Count Average Duration Average idle time Sep 23 00 2 75ms 69ms 01 2 72ms 67ms 02 2 76ms 69ms 03 2 81ms 76ms 04 2 71ms 66ms 05 2 76ms 71ms 06 6 16m55s 16m25s 07 9 312ms 228ms 08 6 240ms 173ms 09 8 331ms 233ms 10 3 77ms 74ms 11 2 81ms 75ms 12 2 73ms 68ms 13 8 65ms 64ms 14 6 66ms 64ms 15 2 74ms 69ms 16 2 76ms 71ms 17 2 102ms 96ms 18 2 79ms 74ms 19 2 74ms 70ms 20 2 76ms 68ms 21 2 74ms 68ms 22 2 69ms 64ms 23 2 70ms 65ms Sep 24 00 2 68ms 63ms 01 2 73ms 68ms 02 2 73ms 68ms 03 2 72ms 67ms 04 2 69ms 64ms 05 2 80ms 74ms 06 5 19m18s 18m40s 07 8 297ms 190ms 08 5 268ms 188ms 09 4 370ms 334ms 10 6 178ms 131ms 11 2 77ms 72ms 12 3 69ms 66ms 13 2 69ms 64ms 14 2 73ms 68ms 15 2 71ms 66ms 16 2 77ms 72ms 17 2 117ms 112ms 18 2 107ms 101ms 19 2 75ms 70ms 20 2 72ms 67ms 21 2 71ms 66ms 22 2 70ms 65ms 23 2 69ms 64ms Sep 25 00 2 74ms 67ms 01 2 70ms 65ms 02 2 75ms 70ms 03 2 73ms 68ms 04 2 75ms 70ms 05 2 71ms 66ms 06 5 22m54s 22m23s 07 2 102ms 96ms 08 2 73ms 68ms 09 4 155ms 104ms 10 2 70ms 65ms 11 2 75ms 70ms 12 5 77ms 75ms 13 6 91ms 89ms 14 4 85ms 82ms 15 2 71ms 66ms 16 2 75ms 70ms 17 2 74ms 69ms 18 2 107ms 101ms 19 2 76ms 71ms 20 2 71ms 66ms 21 2 74ms 69ms 22 2 72ms 67ms 23 2 73ms 68ms Sep 26 00 2 69ms 64ms 01 2 70ms 65ms 02 2 70ms 65ms 03 2 74ms 69ms 04 2 71ms 67ms 05 2 74ms 69ms 06 5 19m59s 19m28s 07 3 88ms 83ms 08 5 298ms 209ms 09 2 69ms 64ms 10 2 68ms 63ms 11 2 72ms 67ms 12 3 184ms 134ms 13 10 62ms 61ms 14 7 272ms 195ms 15 2 73ms 68ms 16 2 68ms 63ms 17 2 67ms 62ms 18 2 101ms 95ms 19 2 65ms 60ms 20 2 73ms 68ms 21 2 71ms 66ms 22 2 67ms 62ms 23 2 64ms 59ms Sep 27 00 2 76ms 71ms 01 2 72ms 67ms 02 2 72ms 67ms 03 2 73ms 68ms 04 2 69ms 65ms 05 2 73ms 68ms 06 2 70ms 65ms 07 2 71ms 66ms 08 2 71ms 66ms 09 2 69ms 64ms 10 2 70ms 65ms 11 2 72ms 67ms 12 2 77ms 70ms 13 2 77ms 72ms 14 2 73ms 68ms 15 2 70ms 65ms 16 2 71ms 66ms 17 2 72ms 67ms 18 2 95ms 89ms 19 2 70ms 65ms 20 2 68ms 63ms 21 2 74ms 69ms 22 2 71ms 66ms 23 2 67ms 62ms -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2025-09-26 13:16:44 Date
Connections per database
Key values
- cnrs Main Database
- 325 connections Total
Connections per user
Key values
- azuresu Main User
- 325 connections Total
-
Sessions
Simultaneous sessions
Key values
- 2 sessions Session Peak
- 2025-09-23 06:40:25 Date
Histogram of session times
Key values
- 307 0-500ms duration
Sessions per database
Key values
- cnrs Main Database
- 326 sessions Total
Sessions per user
Key values
- azuresu Main User
- 326 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 326 sessions Total
-
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 23 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Sep 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Sep 25 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 Sep 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Sep 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 23 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 24 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 25 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 2,412 Total read queries
- 996 Total write queries
Queries by database
Key values
- cnrs Main database
- 5,453 Requests
- 11m25s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 4,731 Requests
User Request type Count Duration a3dsupervisor Total 4,731 11m24s copy to 980 11m15s cte 4 37ms others 1,684 401ms select 2,051 8s408ms tcl 12 0ms azuresu Total 866 1s470ms others 433 25ms select 433 1s444ms Duration by user
Key values
- 11m24s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 4,731 11m24s copy to 980 11m15s cte 4 37ms others 1,684 401ms select 2,051 8s408ms tcl 12 0ms azuresu Total 866 1s470ms others 433 25ms select 433 1s444ms Queries by host
Key values
- 10.3.0.4 Main host
- 4,699 Requests
- 11m23s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 4,412 Requests
- 11m19s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-25 06:49:45 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,825 0-1ms duration
Slowest individual queries
Rank Duration Query 1 45s639ms 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) TO stdout;[ Date: 2025-09-24 06:50:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 39s572ms 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) TO stdout;[ Date: 2025-09-26 06:52:55 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 39s116ms 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) TO stdout;[ Date: 2025-09-25 06:56:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 38s401ms 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) TO stdout;[ Date: 2025-09-23 06:53:18 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 37s17ms 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) TO stdout;[ Date: 2025-09-25 06:55:09 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 35s915ms 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) TO stdout;[ Date: 2025-09-23 06:52:10 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 35s490ms 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) TO stdout;[ Date: 2025-09-24 06:51:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 29s559ms 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) TO stdout;[ Date: 2025-09-23 06:52:40 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 27s888ms 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) TO stdout;[ Date: 2025-09-26 06:52:24 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 25s864ms 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) TO stdout;[ Date: 2025-09-24 06:50:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 24s594ms 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) TO stdout;[ Date: 2025-09-26 06:51:41 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 23s739ms 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) TO stdout;[ Date: 2025-09-25 06:55:48 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 21s788ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-09-24 06:50:11 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 21s349ms 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) TO stdout;[ Date: 2025-09-23 06:52:25 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 20s115ms 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) TO stdout;[ Date: 2025-09-24 06:50:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 16s378ms 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) TO stdout;[ Date: 2025-09-26 06:52:15 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 15s866ms 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) TO stdout;[ Date: 2025-09-24 06:50:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 15s393ms 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) TO stdout;[ Date: 2025-09-23 06:52:43 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 15s115ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-09-23 06:51:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 15s104ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-09-25 06:54:31 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2m32s 4 35s490ms 39s572ms 38s145ms 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) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 1 38s401ms 38s401ms Sep 24 08 1 35s490ms 35s490ms Sep 25 08 1 39s116ms 39s116ms Sep 26 08 1 39s572ms 39s572ms [ User: a3dsupervisor - Total duration: 2m32s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m32s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-26 06:52:55 Duration: 39s572ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:56:40 Duration: 39s116ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:53:18 Duration: 38s401ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 2m23s 4 24s594ms 45s639ms 35s791ms 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) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 35s915ms 35s915ms Sep 24 08 1 45s639ms 45s639ms Sep 25 08 1 37s17ms 37s17ms Sep 26 08 1 24s594ms 24s594ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m23s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-09-24 06:50:40 Duration: 45s639ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:55:09 Duration: 37s17ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:52:10 Duration: 35s915ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 1m47s 4 23s739ms 29s559ms 26s762ms 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) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 08 1 29s559ms 29s559ms Sep 24 08 1 25s864ms 25s864ms Sep 25 08 1 23s739ms 23s739ms Sep 26 08 1 27s888ms 27s888ms [ User: a3dsupervisor - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-23 06:52:40 Duration: 29s559ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-26 06:52:24 Duration: 27s888ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:59 Duration: 25s864ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 1m6s 4 12s445ms 21s349ms 16s704ms 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 08 1 21s349ms 21s349ms Sep 24 08 1 20s115ms 20s115ms Sep 25 08 1 12s907ms 12s907ms Sep 26 08 1 12s445ms 12s445ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 4 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-09-23 06:52:25 Duration: 21s349ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:33 Duration: 20s115ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:55:25 Duration: 12s907ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 1m6s 4 14s422ms 21s788ms 16s607ms copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 08 1 15s115ms 15s115ms Sep 24 08 1 21s788ms 21s788ms Sep 25 08 1 15s104ms 15s104ms Sep 26 08 1 14s422ms 14s422ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-24 06:50:11 Duration: 21s788ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-23 06:51:33 Duration: 15s115ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-25 06:54:31 Duration: 15s104ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 55s849ms 4 8s210ms 16s378ms 13s962ms 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 08 1 15s393ms 15s393ms Sep 24 08 1 15s866ms 15s866ms Sep 25 08 1 8s210ms 8s210ms Sep 26 08 1 16s378ms 16s378ms [ User: a3dsupervisor - Total duration: 55s849ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s849ms - Times executed: 4 ]
-
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) TO stdout;
Date: 2025-09-26 06:52:15 Duration: 16s378ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:59 Duration: 15s866ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:52:43 Duration: 15s393ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 40s323ms 4 8s434ms 10s839ms 10s80ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 08 1 10s839ms 10s839ms Sep 24 08 1 10s355ms 10s355ms Sep 25 08 1 10s692ms 10s692ms Sep 26 08 1 8s434ms 8s434ms [ User: a3dsupervisor - Total duration: 40s323ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s323ms - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-23 06:51:16 Duration: 10s839ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:54:12 Duration: 10s692ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:49:54 Duration: 10s355ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 8s545ms 4 1s331ms 2s507ms 2s136ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 08 1 2s507ms 2s507ms Sep 24 08 1 2s308ms 2s308ms Sep 25 08 1 1s331ms 1s331ms Sep 26 08 1 2s398ms 2s398ms [ User: a3dsupervisor - Total duration: 8s545ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 8s545ms - Times executed: 4 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-23 06:52:47 Duration: 2s507ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-26 06:52:27 Duration: 2s398ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 06:51:02 Duration: 2s308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 5s675ms 4 888ms 1s603ms 1s418ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 1s597ms 1s597ms Sep 24 08 1 1s586ms 1s586ms Sep 25 08 1 888ms 888ms Sep 26 08 1 1s603ms 1s603ms [ User: a3dsupervisor - Total duration: 5s675ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 5s675ms - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-26 06:52:30 Duration: 1s603ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-23 06:52:50 Duration: 1s597ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-24 06:51:06 Duration: 1s586ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 3s935ms 4 599ms 1s174ms 983ms copy public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 08 1 1s174ms 1s174ms Sep 24 08 1 1s87ms 1s87ms Sep 25 08 1 599ms 599ms Sep 26 08 1 1s74ms 1s74ms [ User: a3dsupervisor - Total duration: 3s935ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s935ms - Times executed: 4 ]
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-23 06:52:27 Duration: 1s174ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-24 06:50:42 Duration: 1s87ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-26 06:51:58 Duration: 1s74ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 2s440ms 4 401ms 735ms 610ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 735ms 735ms Sep 24 08 1 663ms 663ms Sep 25 08 1 401ms 401ms Sep 26 08 1 640ms 640ms [ User: a3dsupervisor - Total duration: 2s440ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s440ms - Times executed: 4 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-23 06:52:44 Duration: 735ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-24 06:51:00 Duration: 663ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-26 06:52:24 Duration: 640ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 2s307ms 4 323ms 679ms 576ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 672ms 672ms Sep 24 08 1 679ms 679ms Sep 25 08 1 323ms 323ms Sep 26 08 1 632ms 632ms [ User: a3dsupervisor - Total duration: 2s307ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s307ms - Times executed: 4 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-24 06:50:41 Duration: 679ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-23 06:52:26 Duration: 672ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-26 06:51:57 Duration: 632ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 2s101ms 4 401ms 634ms 525ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 555ms 555ms Sep 24 08 1 634ms 634ms Sep 25 08 1 510ms 510ms Sep 26 08 1 401ms 401ms [ User: a3dsupervisor - Total duration: 2s101ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s101ms - Times executed: 4 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-24 06:50:12 Duration: 634ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-23 06:52:02 Duration: 555ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-25 06:55:11 Duration: 510ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 1s928ms 35 52ms 65ms 55ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 1 64ms 64ms 09 5 288ms 57ms 10 3 160ms 53ms 11 6 324ms 54ms Sep 24 09 6 323ms 53ms 10 3 161ms 53ms 11 1 54ms 54ms 12 1 65ms 65ms Sep 25 11 1 57ms 57ms Sep 26 10 3 161ms 53ms 14 1 52ms 52ms 16 4 214ms 53ms [ User: a3dsupervisor - Total duration: 1s928ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s928ms - Times executed: 35 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:41 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 06:41:13 Duration: 64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:09:11 Duration: 62ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
15 1s539ms 4 227ms 461ms 384ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 461ms 461ms Sep 24 08 1 412ms 412ms Sep 25 08 1 227ms 227ms Sep 26 08 1 437ms 437ms [ User: a3dsupervisor - Total duration: 1s539ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s539ms - Times executed: 4 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-23 06:52:47 Duration: 461ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-26 06:52:27 Duration: 437ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-24 06:51:03 Duration: 412ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 1s406ms 35 38ms 49ms 40ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 49ms 49ms 09 5 200ms 40ms 10 3 119ms 39ms 11 6 237ms 39ms Sep 24 09 6 236ms 39ms 10 3 118ms 39ms 11 1 39ms 39ms 12 1 39ms 39ms Sep 25 11 1 39ms 39ms Sep 26 10 3 118ms 39ms 14 1 48ms 48ms 16 4 159ms 39ms [ User: a3dsupervisor - Total duration: 1s406ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s406ms - Times executed: 35 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 06:41:13 Duration: 49ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-26 12:25:50 Duration: 48ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 07:06:41 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
17 1s365ms 35 28ms 103ms 39ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 1 72ms 72ms 09 5 207ms 41ms 10 3 88ms 29ms 11 6 175ms 29ms Sep 24 09 6 228ms 38ms 10 3 88ms 29ms 11 1 29ms 29ms 12 1 103ms 103ms Sep 25 11 1 84ms 84ms Sep 26 10 3 131ms 43ms 14 1 31ms 31ms 16 4 124ms 31ms [ User: a3dsupervisor - Total duration: 1s365ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s365ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-24 10:11:41 Duration: 103ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-23 07:06:41 Duration: 87ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-25 09:12:47 Duration: 84ms Database: cnrs User: a3dsupervisor Remote: 10.3.1.6 Application: [unknown] Bind query: yes
18 1s260ms 4 201ms 421ms 315ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 1 421ms 421ms Sep 24 08 1 219ms 219ms Sep 25 08 1 418ms 418ms Sep 26 08 1 201ms 201ms [ User: a3dsupervisor - Total duration: 1s260ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s260ms - Times executed: 4 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-23 06:51:16 Duration: 421ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-25 06:54:14 Duration: 418ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-24 06:49:47 Duration: 219ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 1s160ms 240 4ms 9ms 4ms select schemaname, sum(n_live_tup) as n_live_tup, sum(n_dead_tup) as n_dead_tup, sum(seq_scan) as seq_scan, sum(seq_tup_read) as seq_tup_read, sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch, sum(n_tup_ins) as n_tup_ins, sum(n_tup_upd) as n_tup_upd, sum(n_tup_del) as n_tup_del, sum(n_tup_hot_upd) as n_tup_hot_upd, sum(n_mod_since_analyze) as n_mod_since_analyze, sum(vacuum_count) as vacuum_count, sum(autovacuum_count) as autovacuum_count, sum(analyze_count) as analyze_count, sum(autoanalyze_count) as autoanalyze_count, count(relid) as tables_counter, sum( case when last_vacuum is not null then ? else ? end)::bigint as tables_vacuumed, sum( case when last_autovacuum is not null then ? else ? end)::bigint as tables_autovacuumed, sum( case when last_analyze is not null then ? else ? end)::bigint as tables_analyzed, sum( case when last_autoanalyze is not null then ? else ? end)::bigint as tables_autoanalyzed from pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 02 2 10ms 5ms 03 2 9ms 4ms 04 2 12ms 6ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 13ms 6ms 09 2 11ms 5ms 10 2 10ms 5ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 11ms 5ms 14 2 8ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 11ms 5ms 20 2 9ms 4ms 21 2 8ms 4ms 22 2 13ms 6ms 23 2 11ms 5ms 00 2 8ms 4ms 01 2 9ms 4ms Sep 24 02 2 8ms 4ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 11ms 5ms 08 2 11ms 5ms 09 2 11ms 5ms 10 2 8ms 4ms 11 2 11ms 5ms 12 2 13ms 6ms 13 2 10ms 5ms 14 2 8ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 9ms 4ms 01 2 8ms 4ms Sep 25 02 2 12ms 6ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 10ms 5ms 09 2 10ms 5ms 10 2 9ms 4ms 11 2 10ms 5ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 9ms 4ms 01 2 9ms 4ms Sep 26 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 11ms 5ms 09 2 12ms 6ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 8ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 8ms 4ms 23 2 8ms 4ms 00 2 9ms 4ms 01 2 8ms 4ms Sep 27 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 9ms 4ms 09 2 9ms 4ms 10 2 9ms 4ms 11 2 8ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 12ms 6ms 15 2 9ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 10ms 5ms 20 2 9ms 4ms 21 2 8ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 1s160ms - Times executed: 240 ]
[ Application: [unknown] - Total duration: 1s160ms - Times executed: 240 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 20:41:00 Duration: 9ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 06:40:09 Duration: 9ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 02:39:55 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
20 1s26ms 4 160ms 294ms 256ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 294ms 294ms Sep 24 08 1 287ms 287ms Sep 25 08 1 160ms 160ms Sep 26 08 1 284ms 284ms [ User: a3dsupervisor - Total duration: 1s26ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s26ms - Times executed: 4 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-23 06:52:51 Duration: 294ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-24 06:51:06 Duration: 287ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-26 06:52:31 Duration: 284ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 656 113ms 0ms 4ms 0ms select format_type(seqtypid, null), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle from pg_catalog.pg_sequence where seqrelid = ?::oid;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 164 31ms 0ms Sep 24 08 164 28ms 0ms Sep 25 08 164 27ms 0ms Sep 26 08 164 25ms 0ms [ User: a3dsupervisor - Total duration: 113ms - Times executed: 656 ]
[ Application: pg_dump - Total duration: 113ms - Times executed: 656 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;
Date: 2025-09-23 06:19:27 Duration: 4ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;
Date: 2025-09-25 06:19:17 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2466651'::oid;
Date: 2025-09-23 06:19:27 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 504 98ms 0ms 3ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 126 26ms 0ms Sep 24 08 126 22ms 0ms Sep 25 08 126 26ms 0ms Sep 26 08 126 22ms 0ms [ User: a3dsupervisor - Total duration: 98ms - Times executed: 504 ]
[ Application: pg_dump - Total duration: 98ms - Times executed: 504 ]
-
EXECUTE dumpFunc ('16564');
Date: 2025-09-25 06:19:16 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16579');
Date: 2025-09-25 06:19:16 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16579');
Date: 2025-09-23 06:19:26 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 361 19ms 0ms 0ms 0ms set session statement_timeout to ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms Sep 24 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 4 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms Sep 25 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms Sep 26 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms Sep 27 02 3 0ms 0ms 03 3 0ms 0ms 04 3 0ms 0ms 05 3 0ms 0ms 06 3 0ms 0ms 07 3 0ms 0ms 08 3 0ms 0ms 09 3 0ms 0ms 10 3 0ms 0ms 11 3 0ms 0ms 12 3 0ms 0ms 13 3 0ms 0ms 14 3 0ms 0ms 15 3 0ms 0ms 16 3 0ms 0ms 17 3 0ms 0ms 18 3 0ms 0ms 19 3 0ms 0ms 20 3 0ms 0ms 21 3 0ms 0ms 22 3 0ms 0ms 23 3 0ms 0ms 00 3 0ms 0ms 01 3 0ms 0ms [ User: azuresu - Total duration: 19ms - Times executed: 361 ]
[ Application: [unknown] - Total duration: 19ms - Times executed: 361 ]
-
set session statement_timeout to 60000;
Date: 2025-09-27 00:15:35 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 60000;
Date: 2025-09-27 02:45:44 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 60000;
Date: 2025-09-23 23:11:09 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 240 1s160ms 4ms 9ms 4ms select schemaname, sum(n_live_tup) as n_live_tup, sum(n_dead_tup) as n_dead_tup, sum(seq_scan) as seq_scan, sum(seq_tup_read) as seq_tup_read, sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch, sum(n_tup_ins) as n_tup_ins, sum(n_tup_upd) as n_tup_upd, sum(n_tup_del) as n_tup_del, sum(n_tup_hot_upd) as n_tup_hot_upd, sum(n_mod_since_analyze) as n_mod_since_analyze, sum(vacuum_count) as vacuum_count, sum(autovacuum_count) as autovacuum_count, sum(analyze_count) as analyze_count, sum(autoanalyze_count) as autoanalyze_count, count(relid) as tables_counter, sum( case when last_vacuum is not null then ? else ? end)::bigint as tables_vacuumed, sum( case when last_autovacuum is not null then ? else ? end)::bigint as tables_autovacuumed, sum( case when last_analyze is not null then ? else ? end)::bigint as tables_analyzed, sum( case when last_autoanalyze is not null then ? else ? end)::bigint as tables_autoanalyzed from pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 02 2 10ms 5ms 03 2 9ms 4ms 04 2 12ms 6ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 13ms 6ms 09 2 11ms 5ms 10 2 10ms 5ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 11ms 5ms 14 2 8ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 11ms 5ms 20 2 9ms 4ms 21 2 8ms 4ms 22 2 13ms 6ms 23 2 11ms 5ms 00 2 8ms 4ms 01 2 9ms 4ms Sep 24 02 2 8ms 4ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 11ms 5ms 08 2 11ms 5ms 09 2 11ms 5ms 10 2 8ms 4ms 11 2 11ms 5ms 12 2 13ms 6ms 13 2 10ms 5ms 14 2 8ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 9ms 4ms 01 2 8ms 4ms Sep 25 02 2 12ms 6ms 03 2 8ms 4ms 04 2 8ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 10ms 5ms 09 2 10ms 5ms 10 2 9ms 4ms 11 2 10ms 5ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 9ms 4ms 01 2 9ms 4ms Sep 26 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 11ms 5ms 09 2 12ms 6ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 8ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 8ms 4ms 18 2 8ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 8ms 4ms 23 2 8ms 4ms 00 2 9ms 4ms 01 2 8ms 4ms Sep 27 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 9ms 4ms 09 2 9ms 4ms 10 2 9ms 4ms 11 2 8ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 12ms 6ms 15 2 9ms 4ms 16 2 8ms 4ms 17 2 8ms 4ms 18 2 9ms 4ms 19 2 10ms 5ms 20 2 9ms 4ms 21 2 8ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 1s160ms - Times executed: 240 ]
[ Application: [unknown] - Total duration: 1s160ms - Times executed: 240 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 20:41:00 Duration: 9ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 06:40:09 Duration: 9ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 02:39:55 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
5 120 16ms 0ms 0ms 0ms select extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition from pg_catalog.pg_extension;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms Sep 24 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms Sep 25 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms Sep 26 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms Sep 27 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms [ User: azuresu - Total duration: 16ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 16ms - Times executed: 120 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-26 06:44:33 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 10:41:51 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-23 20:41:00 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
6 88 8ms 0ms 0ms 0ms select pg_catalog.format_type(?::pg_catalog.oid, null);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 08 22 2ms 0ms Sep 24 08 22 2ms 0ms Sep 25 08 22 2ms 0ms Sep 26 08 22 2ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 88 ]
[ Application: pg_dump - Total duration: 8ms - Times executed: 88 ]
-
SELECT pg_catalog.format_type('26'::pg_catalog.oid, NULL);
Date: 2025-09-26 06:19:35 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1114'::pg_catalog.oid, NULL);
Date: 2025-09-25 06:19:16 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1700'::pg_catalog.oid, NULL);
Date: 2025-09-24 06:19:24 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 56 6ms 0ms 0ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 08 14 1ms 0ms Sep 24 08 14 1ms 0ms Sep 25 08 14 1ms 0ms Sep 26 08 14 1ms 0ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 56 ]
[ Application: pg_dump - Total duration: 6ms - Times executed: 56 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17218'::pg_catalog.oid);
Date: 2025-09-26 06:19:37 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17218'::pg_catalog.oid);
Date: 2025-09-23 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17221'::pg_catalog.oid);
Date: 2025-09-26 06:19:37 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 39 10ms 0ms 0ms 0ms select version from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 09 2 0ms 0ms 10 1 0ms 0ms 12 1 0ms 0ms 15 6 1ms 0ms 16 4 1ms 0ms Sep 24 11 1 0ms 0ms 12 3 0ms 0ms 14 1 0ms 0ms Sep 25 11 1 0ms 0ms 14 3 0ms 0ms 15 4 0ms 0ms 16 2 0ms 0ms Sep 26 09 1 0ms 0ms 15 8 2ms 0ms 16 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 39 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 12:08:37 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 07:49:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:08:37 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
9 35 1s928ms 52ms 65ms 55ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 64ms 64ms 09 5 288ms 57ms 10 3 160ms 53ms 11 6 324ms 54ms Sep 24 09 6 323ms 53ms 10 3 161ms 53ms 11 1 54ms 54ms 12 1 65ms 65ms Sep 25 11 1 57ms 57ms Sep 26 10 3 161ms 53ms 14 1 52ms 52ms 16 4 214ms 53ms [ User: a3dsupervisor - Total duration: 1s928ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s928ms - Times executed: 35 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:41 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 06:41:13 Duration: 64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:09:11 Duration: 62ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
10 35 1s406ms 38ms 49ms 40ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 08 1 49ms 49ms 09 5 200ms 40ms 10 3 119ms 39ms 11 6 237ms 39ms Sep 24 09 6 236ms 39ms 10 3 118ms 39ms 11 1 39ms 39ms 12 1 39ms 39ms Sep 25 11 1 39ms 39ms Sep 26 10 3 118ms 39ms 14 1 48ms 48ms 16 4 159ms 39ms [ User: a3dsupervisor - Total duration: 1s406ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s406ms - Times executed: 35 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 06:41:13 Duration: 49ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-26 12:25:50 Duration: 48ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 07:06:41 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
11 35 1s365ms 28ms 103ms 39ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 72ms 72ms 09 5 207ms 41ms 10 3 88ms 29ms 11 6 175ms 29ms Sep 24 09 6 228ms 38ms 10 3 88ms 29ms 11 1 29ms 29ms 12 1 103ms 103ms Sep 25 11 1 84ms 84ms Sep 26 10 3 131ms 43ms 14 1 31ms 31ms 16 4 124ms 31ms [ User: a3dsupervisor - Total duration: 1s365ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s365ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-24 10:11:41 Duration: 103ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-23 07:06:41 Duration: 87ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-25 09:12:47 Duration: 84ms Database: cnrs User: a3dsupervisor Remote: 10.3.1.6 Application: [unknown] Bind query: yes
12 35 243ms 5ms 13ms 6ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 12ms 12ms 09 5 39ms 7ms 10 3 18ms 6ms 11 6 34ms 5ms Sep 24 09 6 47ms 7ms 10 3 18ms 6ms 11 1 5ms 5ms 12 1 12ms 12ms Sep 25 11 1 5ms 5ms Sep 26 10 3 18ms 6ms 14 1 5ms 5ms 16 4 23ms 5ms [ User: a3dsupervisor - Total duration: 243ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 243ms - Times executed: 35 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-23 07:06:41 Duration: 13ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-23 06:41:13 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-24 07:20:12 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
13 35 28ms 0ms 2ms 0ms select count(*) as application_nb_user_not_anonymise from a3d_user where upper(user_login) not like ? and user_login not in (...) and user_login not like ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 2ms 2ms 09 5 4ms 0ms 10 3 1ms 0ms 11 6 2ms 0ms Sep 24 09 6 4ms 0ms 10 3 1ms 0ms 11 1 0ms 0ms 12 1 2ms 2ms Sep 25 11 1 2ms 2ms Sep 26 10 3 3ms 1ms 14 1 0ms 0ms 16 4 2ms 0ms [ User: a3dsupervisor - Total duration: 28ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 28ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-24 10:11:41 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-23 07:06:41 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-23 06:41:13 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
14 35 17ms 0ms 0ms 0ms select count(*) as database_nb_active_session from pg_stat_activity where upper(state) is not null and datname = and pid <> pg_backend_pid();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 1 0ms 0ms 09 5 2ms 0ms 10 3 1ms 0ms 11 6 3ms 0ms Sep 24 09 6 2ms 0ms 10 3 1ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms Sep 25 11 1 0ms 0ms Sep 26 10 3 1ms 0ms 14 1 0ms 0ms 16 4 1ms 0ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 35 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-09-23 09:02:46 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-09-23 09:36:21 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = AND pid <> pg_backend_pid();
Date: 2025-09-24 09:32:53 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
15 35 7ms 0ms 1ms 0ms select version as application_release from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 0ms 0ms 09 5 0ms 0ms 10 3 0ms 0ms 11 6 0ms 0ms Sep 24 09 6 1ms 0ms 10 3 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms Sep 25 11 1 1ms 1ms Sep 26 10 3 0ms 0ms 14 1 0ms 0ms 16 4 0ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 35 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-25 09:12:46 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.1.6 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 07:13:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 06:41:13 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
16 35 2ms 0ms 0ms 0ms select commentaire_version as application_last_comment from ( select commentaire_version from gtp_a3d_version where commentaire_version is not null order by date_version desc) fetch next ? rows only;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 0ms 0ms 09 5 0ms 0ms 10 3 0ms 0ms 11 6 0ms 0ms Sep 24 09 6 0ms 0ms 10 3 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms Sep 25 11 1 0ms 0ms Sep 26 10 3 0ms 0ms 14 1 0ms 0ms 16 4 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 35 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 07:13:55 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-26 08:51:45 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 07:53:52 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.1.6 Application: [unknown] Bind query: yes
17 24 18ms 0ms 2ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 6 5ms 0ms Sep 24 08 6 3ms 0ms Sep 25 08 6 5ms 0ms Sep 26 08 6 4ms 0ms [ User: a3dsupervisor - Total duration: 18ms - Times executed: 24 ]
[ Application: pg_dump - Total duration: 18ms - Times executed: 24 ]
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-09-25 06:19:16 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-09-23 06:19:26 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-09-26 06:19:34 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 24 14ms 0ms 2ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 6 3ms 0ms Sep 24 08 6 4ms 0ms Sep 25 08 6 3ms 0ms Sep 26 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 14ms - Times executed: 24 ]
[ Application: pg_dump - Total duration: 14ms - Times executed: 24 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-24 06:19:22 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-25 06:19:15 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-26 06:19:33 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 24 11ms 0ms 1ms 0ms execute getcolumnacls (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 6 2ms 0ms Sep 24 08 6 2ms 0ms Sep 25 08 6 3ms 0ms Sep 26 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 24 ]
[ Application: pg_dump - Total duration: 11ms - Times executed: 24 ]
-
EXECUTE getColumnACLs ('12339');
Date: 2025-09-26 06:19:35 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12339');
Date: 2025-09-25 06:19:16 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12339');
Date: 2025-09-23 06:19:27 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 12 43ms 1ms 7ms 3ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 3 8ms 2ms Sep 24 08 3 12ms 4ms Sep 25 08 3 11ms 3ms Sep 26 08 3 10ms 3ms [ User: a3dsupervisor - Total duration: 43ms - Times executed: 12 ]
[ Application: pg_dump - Total duration: 43ms - Times executed: 12 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-09-24 06:19:22 Duration: 7ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-09-25 06:19:15 Duration: 7ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-09-26 06:19:34 Duration: 6ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 35s490ms 39s572ms 38s145ms 4 2m32s 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) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 23 08 1 38s401ms 38s401ms Sep 24 08 1 35s490ms 35s490ms Sep 25 08 1 39s116ms 39s116ms Sep 26 08 1 39s572ms 39s572ms [ User: a3dsupervisor - Total duration: 2m32s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m32s - Times executed: 4 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-09-26 06:52:55 Duration: 39s572ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:56:40 Duration: 39s116ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:53:18 Duration: 38s401ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 24s594ms 45s639ms 35s791ms 4 2m23s 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) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 23 08 1 35s915ms 35s915ms Sep 24 08 1 45s639ms 45s639ms Sep 25 08 1 37s17ms 37s17ms Sep 26 08 1 24s594ms 24s594ms [ User: a3dsupervisor - Total duration: 2m23s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m23s - Times executed: 4 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-09-24 06:50:40 Duration: 45s639ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:55:09 Duration: 37s17ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:52:10 Duration: 35s915ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 23s739ms 29s559ms 26s762ms 4 1m47s 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) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 23 08 1 29s559ms 29s559ms Sep 24 08 1 25s864ms 25s864ms Sep 25 08 1 23s739ms 23s739ms Sep 26 08 1 27s888ms 27s888ms [ User: a3dsupervisor - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-23 06:52:40 Duration: 29s559ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-26 06:52:24 Duration: 27s888ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:59 Duration: 25s864ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 12s445ms 21s349ms 16s704ms 4 1m6s 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) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 23 08 1 21s349ms 21s349ms Sep 24 08 1 20s115ms 20s115ms Sep 25 08 1 12s907ms 12s907ms Sep 26 08 1 12s445ms 12s445ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 4 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-09-23 06:52:25 Duration: 21s349ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:33 Duration: 20s115ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:55:25 Duration: 12s907ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 14s422ms 21s788ms 16s607ms 4 1m6s copy public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 23 08 1 15s115ms 15s115ms Sep 24 08 1 21s788ms 21s788ms Sep 25 08 1 15s104ms 15s104ms Sep 26 08 1 14s422ms 14s422ms [ User: a3dsupervisor - Total duration: 1m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m6s - Times executed: 4 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-24 06:50:11 Duration: 21s788ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-23 06:51:33 Duration: 15s115ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-25 06:54:31 Duration: 15s104ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 8s210ms 16s378ms 13s962ms 4 55s849ms 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 23 08 1 15s393ms 15s393ms Sep 24 08 1 15s866ms 15s866ms Sep 25 08 1 8s210ms 8s210ms Sep 26 08 1 16s378ms 16s378ms [ User: a3dsupervisor - Total duration: 55s849ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 55s849ms - Times executed: 4 ]
-
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) TO stdout;
Date: 2025-09-26 06:52:15 Duration: 16s378ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:50:59 Duration: 15s866ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-23 06:52:43 Duration: 15s393ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 8s434ms 10s839ms 10s80ms 4 40s323ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 23 08 1 10s839ms 10s839ms Sep 24 08 1 10s355ms 10s355ms Sep 25 08 1 10s692ms 10s692ms Sep 26 08 1 8s434ms 8s434ms [ User: a3dsupervisor - Total duration: 40s323ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 40s323ms - Times executed: 4 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-09-23 06:51:16 Duration: 10s839ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-25 06:54:12 Duration: 10s692ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
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) TO stdout;
Date: 2025-09-24 06:49:54 Duration: 10s355ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 1s331ms 2s507ms 2s136ms 4 8s545ms copy public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 23 08 1 2s507ms 2s507ms Sep 24 08 1 2s308ms 2s308ms Sep 25 08 1 1s331ms 1s331ms Sep 26 08 1 2s398ms 2s398ms [ User: a3dsupervisor - Total duration: 8s545ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 8s545ms - Times executed: 4 ]
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-23 06:52:47 Duration: 2s507ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-26 06:52:27 Duration: 2s398ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_rel_vt (view_template_num_id, obj_template_num_id, obj_num_id, node_tree_type_num_id, rel_template_num_id, relation_num_id, obj_num_id_p, node_tree_type_num_id_p) TO stdout;
Date: 2025-09-24 06:51:02 Duration: 2s308ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 888ms 1s603ms 1s418ms 4 5s675ms copy public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 23 08 1 1s597ms 1s597ms Sep 24 08 1 1s586ms 1s586ms Sep 25 08 1 888ms 888ms Sep 26 08 1 1s603ms 1s603ms [ User: a3dsupervisor - Total duration: 5s675ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 5s675ms - Times executed: 4 ]
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-26 06:52:30 Duration: 1s603ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-23 06:52:50 Duration: 1s597ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_10min (consumption_num_id, counting_point_num_id, type, origin, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-24 06:51:06 Duration: 1s586ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 599ms 1s174ms 983ms 4 3s935ms copy public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 23 08 1 1s174ms 1s174ms Sep 24 08 1 1s87ms 1s87ms Sep 25 08 1 599ms 599ms Sep 26 08 1 1s74ms 1s74ms [ User: a3dsupervisor - Total duration: 3s935ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3s935ms - Times executed: 4 ]
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-23 06:52:27 Duration: 1s174ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-24 06:50:42 Duration: 1s87ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_old_qsp (history_old_qsp_id, action_num_id, obj_num_id, view_template_num_id, quick_search_path) TO stdout;
Date: 2025-09-26 06:51:58 Duration: 1s74ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 401ms 735ms 610ms 4 2s440ms copy public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 23 08 1 735ms 735ms Sep 24 08 1 663ms 663ms Sep 25 08 1 401ms 401ms Sep 26 08 1 640ms 640ms [ User: a3dsupervisor - Total duration: 2s440ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s440ms - Times executed: 4 ]
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-23 06:52:44 Duration: 735ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-24 06:51:00 Duration: 663ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj (obj_num_id, obj_template_num_id, obj_name_fr, obj_dcre, obj_creator, obj_dmaj, obj_modifier, obj_b_valid, obj_status, obj_state, obj_version) TO stdout;
Date: 2025-09-26 06:52:24 Duration: 640ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 323ms 679ms 576ms 4 2s307ms copy public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 23 08 1 672ms 672ms Sep 24 08 1 679ms 679ms Sep 25 08 1 323ms 323ms Sep 26 08 1 632ms 632ms [ User: a3dsupervisor - Total duration: 2s307ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s307ms - Times executed: 4 ]
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-24 06:50:41 Duration: 679ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-23 06:52:26 Duration: 672ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_history_obj_link_unlink (history_link_unlink_id, action_num_id, obj_num_id_p, rel_template_num_id, obj_num_id) TO stdout;
Date: 2025-09-26 06:51:57 Duration: 632ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 401ms 634ms 525ms 4 2s101ms copy public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 23 08 1 555ms 555ms Sep 24 08 1 634ms 634ms Sep 25 08 1 510ms 510ms Sep 26 08 1 401ms 401ms [ User: a3dsupervisor - Total duration: 2s101ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2s101ms - Times executed: 4 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-24 06:50:12 Duration: 634ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-23 06:52:02 Duration: 555ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-09-25 06:55:11 Duration: 510ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 227ms 461ms 384ms 4 1s539ms copy public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 23 08 1 461ms 461ms Sep 24 08 1 412ms 412ms Sep 25 08 1 227ms 227ms Sep 26 08 1 437ms 437ms [ User: a3dsupervisor - Total duration: 1s539ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s539ms - Times executed: 4 ]
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-23 06:52:47 Duration: 461ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-26 06:52:27 Duration: 437ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_obj_template_calcul_rule_cascade_error (obj_num_id, att_template_category_num_id, att_template_num_id, error_text, error_date) TO stdout;
Date: 2025-09-24 06:51:03 Duration: 412ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 201ms 421ms 315ms 4 1s260ms copy public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 23 08 1 421ms 421ms Sep 24 08 1 219ms 219ms Sep 25 08 1 418ms 418ms Sep 26 08 1 201ms 201ms [ User: a3dsupervisor - Total duration: 1s260ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s260ms - Times executed: 4 ]
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-23 06:51:16 Duration: 421ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-25 06:54:14 Duration: 418ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_relation (relation_num_id, container_num_id, rel_template_num_id, content_num_id, content_template_num_id, relation_a3d_num_id, relation_creator, relation_dcre) TO stdout;
Date: 2025-09-24 06:49:47 Duration: 219ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 160ms 294ms 256ms 4 1s26ms copy public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 23 08 1 294ms 294ms Sep 24 08 1 287ms 287ms Sep 25 08 1 160ms 160ms Sep 26 08 1 284ms 284ms [ User: a3dsupervisor - Total duration: 1s26ms - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1s26ms - Times executed: 4 ]
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-23 06:52:51 Duration: 294ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-24 06:51:06 Duration: 287ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.pe_consumption_hourly (consumption_num_id, counting_point_num_id, type, origin, consolidated, date_storage, date_stamped, time_period, value, value_kwh, value_co2, user_comment, consumption_dcre, consumption_creator, consumption_dmaj, consumption_modifier) TO stdout;
Date: 2025-09-26 06:52:31 Duration: 284ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 52ms 65ms 55ms 35 1s928ms select case when upper(log_info) like ? then log_info when upper(log_info) like ? then ? else ? end application_last_anonymise_log, str_log_date as application_last_anonymise_date from ( select log_info, to_char(log_date, ?) as str_log_date from gtp_log where upper(log_info) like ? or upper(log_info) like ? or upper(log_info) like ? order by log_date desc) fetch next ? rows only;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 23 08 1 64ms 64ms 09 5 288ms 57ms 10 3 160ms 53ms 11 6 324ms 54ms Sep 24 09 6 323ms 53ms 10 3 161ms 53ms 11 1 54ms 54ms 12 1 65ms 65ms Sep 25 11 1 57ms 57ms Sep 26 10 3 161ms 53ms 14 1 52ms 52ms 16 4 214ms 53ms [ User: a3dsupervisor - Total duration: 1s928ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s928ms - Times executed: 35 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:11:41 Duration: 65ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 06:41:13 Duration: 64ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date FROM ( SELECT LOG_INFO, TO_CHAR(LOG_DATE, 'DD/MM/YYYY HH24:MI:SS') AS STR_LOG_DATE FROM GTP_LOG WHERE UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' OR UPPER(LOG_INFO) LIKE 'FIN SCRIPT%RGPD.SQL%' OR UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' ORDER BY LOG_DATE DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:09:11 Duration: 62ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
18 38ms 49ms 40ms 35 1s406ms select to_char(max(log_date), ?) as application_last_connection from a3d_log where upper(log_return) = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 23 08 1 49ms 49ms 09 5 200ms 40ms 10 3 119ms 39ms 11 6 237ms 39ms Sep 24 09 6 236ms 39ms 10 3 118ms 39ms 11 1 39ms 39ms 12 1 39ms 39ms Sep 25 11 1 39ms 39ms Sep 26 10 3 118ms 39ms 14 1 48ms 48ms 16 4 159ms 39ms [ User: a3dsupervisor - Total duration: 1s406ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s406ms - Times executed: 35 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 06:41:13 Duration: 49ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-26 12:25:50 Duration: 48ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 07:06:41 Duration: 42ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
19 28ms 103ms 39ms 35 1s365ms select count(*) as application_nb_active_session from a3d_log a where log_session_id is not null and upper(log_return) = ? and log_date > now() - interval ? and not exists ( select ? from a3d_log b where a.log_session_id = b.log_session_id and upper(b.log_return) = ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 23 08 1 72ms 72ms 09 5 207ms 41ms 10 3 88ms 29ms 11 6 175ms 29ms Sep 24 09 6 228ms 38ms 10 3 88ms 29ms 11 1 29ms 29ms 12 1 103ms 103ms Sep 25 11 1 84ms 84ms Sep 26 10 3 131ms 43ms 14 1 31ms 31ms 16 4 124ms 31ms [ User: a3dsupervisor - Total duration: 1s365ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s365ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-24 10:11:41 Duration: 103ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-23 07:06:41 Duration: 87ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours' AND NOT EXISTS ( SELECT 1 FROM A3D_LOG B WHERE A.LOG_SESSION_ID = B.LOG_SESSION_ID AND UPPER(B.LOG_RETURN) = 'DECONNEXION');
Date: 2025-09-25 09:12:47 Duration: 84ms Database: cnrs User: a3dsupervisor Remote: 10.3.1.6 Application: [unknown] Bind query: yes
20 5ms 13ms 6ms 35 243ms select pg_size_pretty(pg_database_size()) as database_size;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 23 08 1 12ms 12ms 09 5 39ms 7ms 10 3 18ms 6ms 11 6 34ms 5ms Sep 24 09 6 47ms 7ms 10 3 18ms 6ms 11 1 5ms 5ms 12 1 12ms 12ms Sep 25 11 1 5ms 5ms Sep 26 10 3 18ms 6ms 14 1 5ms 5ms 16 4 23ms 5ms [ User: a3dsupervisor - Total duration: 243ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 243ms - Times executed: 35 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-23 07:06:41 Duration: 13ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-23 06:41:13 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE()) AS database_size;
Date: 2025-09-24 07:20:12 Duration: 12ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 737ms 288 1ms 31ms 2ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 27 02 2 2ms 1ms 03 2 2ms 1ms 04 2 6ms 3ms 05 2 3ms 1ms 06 2 3ms 1ms 07 2 3ms 1ms 08 2 23ms 11ms 09 2 6ms 3ms 10 2 2ms 1ms 11 2 3ms 1ms 12 2 2ms 1ms 13 2 2ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 3ms 1ms 18 2 2ms 1ms 19 2 33ms 16ms 20 2 2ms 1ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 3ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Sep 27 02 2 3ms 1ms 03 2 3ms 1ms 04 2 2ms 1ms 05 2 2ms 1ms 06 2 2ms 1ms 07 2 3ms 1ms 08 2 28ms 14ms 09 2 30ms 15ms 10 2 2ms 1ms 11 2 6ms 3ms 12 2 29ms 14ms 13 2 3ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 3ms 1ms 19 2 2ms 1ms 20 2 23ms 11ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Sep 27 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 2ms 1ms 06 2 2ms 1ms 07 2 3ms 1ms 08 2 28ms 14ms 09 2 31ms 15ms 10 2 3ms 1ms 11 2 3ms 1ms 12 2 2ms 1ms 13 2 2ms 1ms 14 2 3ms 1ms 15 2 3ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 29ms 14ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Sep 27 02 2 3ms 1ms 03 2 2ms 1ms 04 2 3ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 28ms 14ms 09 2 25ms 12ms 10 2 2ms 1ms 11 2 3ms 1ms 12 2 2ms 1ms 13 2 2ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 24ms 12ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Sep 27 02 4 5ms 1ms 03 4 5ms 1ms 04 4 5ms 1ms 05 4 5ms 1ms 06 4 5ms 1ms 07 4 5ms 1ms 08 4 5ms 1ms 09 4 5ms 1ms 10 4 5ms 1ms 11 4 5ms 1ms 12 4 6ms 1ms 13 4 5ms 1ms 14 4 5ms 1ms 15 4 5ms 1ms 16 4 5ms 1ms 17 4 5ms 1ms 18 4 5ms 1ms 19 4 7ms 1ms 20 4 5ms 1ms 21 4 5ms 1ms 22 4 5ms 1ms 23 4 5ms 1ms 00 4 5ms 1ms 01 4 5ms 1ms [ User: azuresu - Total duration: 1s384ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 1s384ms - Times executed: 288 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 17:10:47 Duration: 31ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-25 07:13:09 Duration: 29ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-24 07:11:38 Duration: 29ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 125ms 35 1ms 23ms 3ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming prepare #2
Day Hour Count Duration Avg duration 06 1 9ms 9ms 07 5 24ms 4ms 08 3 5ms 1ms 09 6 11ms 1ms 07 6 16ms 2ms 08 3 4ms 1ms 09 1 1ms 1ms 10 1 23ms 23ms 09 1 8ms 8ms 08 3 11ms 3ms 12 1 1ms 1ms 14 4 6ms 1ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 35 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-24 10:11:40 Duration: 23ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-23 07:06:41 Duration: 17ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-23 06:41:13 Duration: 9ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
3 113ms 144 0ms 8ms 0ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming prepare #3
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 6ms 6ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 8ms 8ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 1ms 1ms 10 1 8ms 8ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 5ms 5ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 7ms 7ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 6ms 6ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 6ms 6ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 6ms 6ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 2ms 1ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 17ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 144 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 06:41:35 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 10:41:51 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-25 06:43:06 Duration: 7ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
4 77ms 35 0ms 13ms 2ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming prepare #4
Day Hour Count Duration Avg duration 06 1 11ms 11ms 07 5 9ms 1ms 08 3 2ms 0ms 09 6 6ms 1ms 07 6 9ms 1ms 08 3 2ms 0ms 09 1 1ms 1ms 10 1 13ms 13ms 09 1 7ms 7ms 08 3 7ms 2ms 12 1 0ms 0ms 14 4 3ms 0ms [ User: a3dsupervisor - Total duration: 1s365ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s365ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-24 10:11:40 Duration: 13ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-23 06:41:13 Duration: 11ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-25 09:12:46 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
5 64ms 39 0ms 15ms 1ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #5
Day Hour Count Duration Avg duration 07 2 14ms 7ms 08 1 0ms 0ms 10 1 0ms 0ms 13 6 5ms 0ms 14 4 3ms 0ms 09 1 0ms 0ms 10 3 17ms 5ms 12 1 2ms 2ms 09 1 0ms 0ms 12 3 2ms 0ms 13 4 3ms 0ms 14 2 1ms 0ms 07 1 1ms 1ms 13 8 7ms 0ms 14 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 39 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:08:37 Duration: 15ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:06:37 Duration: 13ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 12:08:37 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 49ms 35 0ms 7ms 1ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #6
Day Hour Count Duration Avg duration 06 1 2ms 2ms 07 5 10ms 2ms 08 3 3ms 1ms 09 6 4ms 0ms 07 6 7ms 1ms 08 3 3ms 1ms 09 1 0ms 0ms 10 1 7ms 7ms 09 1 2ms 2ms 08 3 4ms 1ms 12 1 1ms 1ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 243ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 243ms - Times executed: 35 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-24 10:11:40 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-23 07:06:41 Duration: 6ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-23 06:41:13 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 44ms 35 0ms 7ms 1ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 06 1 7ms 7ms 07 5 4ms 0ms 08 3 1ms 0ms 09 6 4ms 0ms 07 6 5ms 0ms 08 3 1ms 0ms 09 1 0ms 0ms 10 1 7ms 7ms 09 1 3ms 3ms 08 3 3ms 1ms 12 1 0ms 0ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 28ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 28ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-23 06:41:13 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-24 10:11:41 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-25 09:12:47 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
8 34ms 35 0ms 7ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming prepare #8
Day Hour Count Duration Avg duration 06 1 3ms 3ms 07 5 8ms 1ms 08 3 0ms 0ms 09 6 1ms 0ms 07 6 5ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 5ms 5ms 09 1 3ms 3ms 08 3 3ms 1ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 1s406ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s406ms - Times executed: 35 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 07:06:41 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-24 10:11:41 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-24 07:13:55 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 23ms 289 0ms 2ms 0ms set session statement_timeout to 60000;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 2ms 1ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 3 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 4 0ms 0ms 01 4 0ms 0ms 02 4 0ms 0ms 03 4 0ms 0ms 04 4 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 4 0ms 0ms 08 4 0ms 0ms 09 4 0ms 0ms 10 4 0ms 0ms 11 4 0ms 0ms 12 4 0ms 0ms 13 4 0ms 0ms 14 4 0ms 0ms 15 4 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 19 4 0ms 0ms 20 4 0ms 0ms 21 4 0ms 0ms 22 4 0ms 0ms 23 4 0ms 0ms [ User: azuresu - Total duration: 14ms - Times executed: 289 ]
[ Application: [unknown] - Total duration: 14ms - Times executed: 289 ]
-
set session statement_timeout to 60000;
Date: 2025-09-23 11:10:26 Duration: 2ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-26 18:15:14 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-25 21:44:00 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
10 18ms 144 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming prepare #10
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 11ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 11ms - Times executed: 144 ]
-
set session statement_timeout to 120000;
Date: 2025-09-23 00:39:48 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-25 06:43:06 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-24 01:41:17 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
11 17ms 35 0ms 3ms 0ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming prepare #11
Day Hour Count Duration Avg duration 06 1 3ms 3ms 07 5 2ms 0ms 08 3 0ms 0ms 09 6 1ms 0ms 07 6 1ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 2ms 2ms 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 1s928ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s928ms - Times executed: 35 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-23 06:41:13 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-24 10:11:41 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-23 07:08:14 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 16ms 35 0ms 2ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #12
Day Hour Count Duration Avg duration 06 1 2ms 2ms 07 5 2ms 0ms 08 3 1ms 0ms 09 6 2ms 0ms 07 6 2ms 0ms 08 3 1ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 1ms 1ms 08 3 1ms 0ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 35 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 06:41:13 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-25 09:12:46 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 07:13:55 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
13 12ms 1 12ms 12ms 12ms SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;Times Reported Time consuming prepare #13
Day Hour Count Duration Avg duration 10 1 12ms 12ms [ User: azuresu - Total duration: 42ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 42ms - Times executed: 1 ]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-09-24 10:41:52 Duration: 12ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
14 3ms 35 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #14
Day Hour Count Duration Avg duration 06 1 0ms 0ms 07 5 0ms 0ms 08 3 0ms 0ms 09 6 0ms 0ms 07 6 0ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 35 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:13:08 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:06:41 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:09:55 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 953ms 288 1ms 46ms 3ms SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 27 02 2 4ms 2ms 03 2 4ms 2ms 04 2 6ms 3ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 29ms 14ms 09 2 14ms 7ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 6ms 3ms 19 2 28ms 14ms 20 2 4ms 2ms 21 2 3ms 1ms 22 2 5ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 5ms 2ms Sep 27 02 2 3ms 1ms 03 2 3ms 1ms 04 2 4ms 2ms 05 2 3ms 1ms 06 2 4ms 2ms 07 2 5ms 2ms 08 2 27ms 13ms 09 2 26ms 13ms 10 2 4ms 2ms 11 2 48ms 24ms 12 2 38ms 19ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 22ms 11ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms Sep 27 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 29ms 14ms 09 2 24ms 12ms 10 2 5ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 24ms 12ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms Sep 27 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 3ms 1ms 07 2 4ms 2ms 08 2 22ms 11ms 09 2 26ms 13ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 23ms 11ms 21 2 4ms 2ms 22 2 3ms 1ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms Sep 27 02 4 9ms 2ms 03 4 7ms 1ms 04 4 8ms 2ms 05 4 9ms 2ms 06 4 7ms 1ms 07 4 8ms 2ms 08 4 8ms 2ms 09 4 7ms 1ms 10 4 8ms 2ms 11 4 8ms 2ms 12 4 9ms 2ms 13 4 8ms 2ms 14 4 9ms 2ms 15 4 9ms 2ms 16 4 8ms 2ms 17 4 8ms 2ms 18 4 8ms 2ms 19 4 8ms 2ms 20 4 9ms 2ms 21 4 8ms 2ms 22 4 8ms 2ms 23 4 8ms 2ms 00 4 8ms 2ms 01 4 9ms 2ms [ User: azuresu - Total duration: 1s384ms - Times executed: 288 ]
[ Application: [unknown] - Total duration: 1s384ms - Times executed: 288 ]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-24 09:41:47 Duration: 46ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-25 06:43:06 Duration: 27ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT schemaname, sum(n_live_tup) AS n_live_tup, sum(n_dead_tup) AS n_dead_tup, sum(seq_scan) AS seq_scan, sum(seq_tup_read) AS seq_tup_read, sum(idx_scan) AS idx_scan, sum(idx_tup_fetch) AS idx_tup_fetch, sum(n_tup_ins) AS n_tup_ins, sum(n_tup_upd) AS n_tup_upd, sum(n_tup_del) AS n_tup_del, sum(n_tup_hot_upd) AS n_tup_hot_upd, sum(n_mod_since_analyze) AS n_mod_since_analyze, sum(vacuum_count) AS vacuum_count, sum(autovacuum_count) AS autovacuum_count, sum(analyze_count) AS analyze_count, sum(autoanalyze_count) AS autoanalyze_count, count(relid) AS tables_counter, sum( case when last_vacuum IS NOT NULL then 1 else 0 end)::bigint as tables_vacuumed, sum( case when last_autovacuum IS NOT NULL then 1 else 0 end)::bigint as tables_autovacuumed, sum( case when last_analyze IS NOT NULL then 1 else 0 end)::bigint as tables_analyzed, sum( case when last_autoanalyze IS NOT NULL then 1 else 0 end)::bigint as tables_autoanalyzed FROM pg_catalog.pg_stat_all_tables group by schemaname;
Date: 2025-09-23 06:40:09 Duration: 27ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 197ms 144 0ms 20ms 1ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming bind #2
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 7ms 7ms 07 1 2ms 2ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 1ms 1ms 17 1 3ms 3ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 2ms 2ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 1ms 1ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 1ms 1ms 06 1 9ms 9ms 07 1 3ms 3ms 08 1 0ms 0ms 09 1 20ms 20ms 10 1 10ms 10ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 7ms 7ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 8ms 8ms 07 1 2ms 2ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 8ms 8ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 8ms 8ms 07 1 3ms 3ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 7ms 7ms 19 1 1ms 1ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 2 1ms 0ms 01 2 0ms 0ms 02 2 1ms 0ms 03 2 1ms 0ms 04 2 1ms 0ms 05 2 1ms 0ms 06 2 1ms 0ms 07 2 1ms 0ms 08 2 1ms 0ms 09 2 1ms 0ms 10 2 1ms 0ms 11 2 1ms 0ms 12 2 1ms 0ms 13 2 1ms 0ms 14 2 1ms 0ms 15 2 1ms 0ms 16 2 1ms 0ms 17 2 1ms 0ms 18 2 1ms 0ms 19 2 1ms 0ms 20 2 1ms 0ms 21 2 0ms 0ms 22 2 1ms 0ms 23 2 1ms 0ms [ User: azuresu - Total duration: 17ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 144 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 09:41:47 Duration: 20ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 10:41:51 Duration: 10ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-24 06:41:35 Duration: 9ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
3 100ms 35 0ms 30ms 2ms SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';Times Reported Time consuming bind #3
Day Hour Count Duration Avg duration 06 1 8ms 8ms 07 5 11ms 2ms 08 3 3ms 1ms 09 6 5ms 0ms 07 6 10ms 1ms 08 3 2ms 0ms 09 1 0ms 0ms 10 1 13ms 13ms 09 1 30ms 30ms 08 3 11ms 3ms 12 1 0ms 0ms 14 4 3ms 0ms [ User: a3dsupervisor - Total duration: 1s365ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s365ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-25 09:12:47 Duration: 30ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-24 10:11:40 Duration: 13ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_active_session FROM A3D_LOG A WHERE LOG_SESSION_ID IS NOT NULL AND UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE' AND LOG_DATE > NOW() - INTERVAL '12 hours';
Date: 2025-09-26 08:51:45 Duration: 9ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 85ms 35 0ms 30ms 2ms SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';Times Reported Time consuming bind #4
Day Hour Count Duration Avg duration 06 1 5ms 5ms 07 5 10ms 2ms 08 3 1ms 0ms 09 6 3ms 0ms 07 6 9ms 1ms 08 3 1ms 0ms 09 1 0ms 0ms 10 1 9ms 9ms 09 1 30ms 30ms 08 3 9ms 3ms 12 1 0ms 0ms 14 4 2ms 0ms [ User: a3dsupervisor - Total duration: 28ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 28ms - Times executed: 35 ]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-25 09:12:47 Duration: 30ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-24 10:11:41 Duration: 9ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS application_nb_user_not_anonymise FROM A3D_USER WHERE UPPER(USER_LOGIN) NOT LIKE 'USER%' AND USER_LOGIN NOT IN ('admin', 'batch') AND USER_LOGIN NOT LIKE '{%#%}';
Date: 2025-09-26 08:51:45 Duration: 8ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 48ms 35 0ms 17ms 1ms SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;Times Reported Time consuming bind #5
Day Hour Count Duration Avg duration 06 1 3ms 3ms 07 5 7ms 1ms 08 3 1ms 0ms 09 6 2ms 0ms 07 6 4ms 0ms 08 3 1ms 0ms 09 1 0ms 0ms 10 1 5ms 5ms 09 1 17ms 17ms 08 3 2ms 0ms 12 1 0ms 0ms 14 4 1ms 0ms [ User: a3dsupervisor - Total duration: 1s928ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s928ms - Times executed: 35 ]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-25 09:12:47 Duration: 17ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-23 07:06:41 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT CASE WHEN UPPER(LOG_INFO) LIKE 'FIN PROC%DURE P_ANONYMIZATION%' THEN LOG_INFO WHEN UPPER(LOG_INFO) LIKE 'FIN%MAJPERSONALDATA%' THEN 'OLD' ELSE '0' END application_last_anonymise_log, STR_LOG_DATE AS application_last_anonymise_date;
Date: 2025-09-24 10:11:41 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 46ms 35 0ms 2ms 1ms SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();Times Reported Time consuming bind #6
Day Hour Count Duration Avg duration 06 1 2ms 2ms 07 5 6ms 1ms 08 3 3ms 1ms 09 6 7ms 1ms 07 6 7ms 1ms 08 3 2ms 0ms 09 1 1ms 1ms 10 1 2ms 2ms 09 1 2ms 2ms 08 3 4ms 1ms 12 1 1ms 1ms 14 4 4ms 1ms [ User: a3dsupervisor - Total duration: 17ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 17ms - Times executed: 35 ]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-23 09:36:13 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-23 06:41:13 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COUNT(*) AS database_nb_active_session FROM PG_STAT_ACTIVITY WHERE UPPER(STATE) IS NOT NULL AND datname = $1 AND pid <> pg_backend_pid();
Date: 2025-09-24 10:11:40 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
7 32ms 39 0ms 7ms 0ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #7
Day Hour Count Duration Avg duration 07 2 4ms 2ms 08 1 0ms 0ms 10 1 0ms 0ms 13 6 2ms 0ms 14 4 2ms 0ms 09 1 1ms 1ms 10 3 8ms 2ms 12 1 0ms 0ms 09 1 0ms 0ms 12 3 1ms 0ms 13 4 2ms 0ms 14 2 1ms 0ms 07 1 0ms 0ms 13 8 4ms 0ms 14 1 0ms 0ms [ User: a3dsupervisor - Total duration: 10ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 10ms - Times executed: 39 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 10:08:37 Duration: 7ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:06:37 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 09:41:55 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 12ms 35 0ms 1ms 0ms SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';Times Reported Time consuming bind #8
Day Hour Count Duration Avg duration 06 1 1ms 1ms 07 5 1ms 0ms 08 3 0ms 0ms 09 6 1ms 0ms 07 6 2ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 0ms 0ms 08 3 1ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 1s406ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1s406ms - Times executed: 35 ]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-24 07:13:55 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-23 06:41:13 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT TO_CHAR(MAX(LOG_DATE), 'DD/MM/YYYY HH24:MI:SS') AS application_last_connection FROM A3D_LOG WHERE UPPER(LOG_RETURN) = 'CONNEXION ACCEPTEE';
Date: 2025-09-24 10:11:41 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 10ms 1 10ms 10ms 10ms SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;Times Reported Time consuming bind #9
Day Hour Count Duration Avg duration 10 1 10ms 10ms [ User: azuresu - Total duration: 42ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 42ms - Times executed: 1 ]
-
SELECT pg_am.amname AS index_type, COUNT(idstat.indexrelid) AS index_count, COALESCE(SUM(idstat.idx_scan)::bigint, 0) AS total_idx_scan, pg_size_pretty(SUM(pg_relation_size(idstat.indexrelid))) AS total_indices_size FROM pg_stat_user_indexes AS idstat JOIN pg_class AS pgc ON pgc.oid = idstat.indexrelid JOIN pg_am ON pg_am.oid = pgc.relam GROUP BY pg_am.amname ORDER BY pg_am.amname;
Date: 2025-09-24 10:41:52 Duration: 10ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
10 7ms 35 0ms 0ms 0ms SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #10
Day Hour Count Duration Avg duration 06 1 0ms 0ms 07 5 1ms 0ms 08 3 0ms 0ms 09 6 1ms 0ms 07 6 1ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 7ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7ms - Times executed: 35 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 08:29:40 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-24 07:20:12 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 09:02:46 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 6ms 35 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #11
Day Hour Count Duration Avg duration 06 1 0ms 0ms 07 5 1ms 0ms 08 3 0ms 0ms 09 6 1ms 0ms 07 6 0ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 243ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 243ms - Times executed: 35 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-23 07:09:11 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 08:51:45 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-26 14:41:24 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 4ms 35 0ms 0ms 0ms SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming bind #12
Day Hour Count Duration Avg duration 06 1 0ms 0ms 07 5 0ms 0ms 08 3 0ms 0ms 09 6 0ms 0ms 07 6 0ms 0ms 08 3 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 09 1 0ms 0ms 08 3 0ms 0ms 12 1 0ms 0ms 14 4 0ms 0ms [ User: a3dsupervisor - Total duration: 2ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 2ms - Times executed: 35 ]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:06:41 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 09:17:36 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
-
SELECT COMMENTAIRE_VERSION AS application_last_comment FROM ( SELECT COMMENTAIRE_VERSION FROM GTP_A3D_VERSION WHERE COMMENTAIRE_VERSION IS NOT NULL ORDER BY DATE_VERSION DESC) FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-23 07:09:11 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
13 4ms 289 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 3 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms 00 4 0ms 0ms 01 4 0ms 0ms 02 4 0ms 0ms 03 4 0ms 0ms 04 4 0ms 0ms 05 4 0ms 0ms 06 4 0ms 0ms 07 4 0ms 0ms 08 4 0ms 0ms 09 4 0ms 0ms 10 4 0ms 0ms 11 4 0ms 0ms 12 4 0ms 0ms 13 4 0ms 0ms 14 4 0ms 0ms 15 4 0ms 0ms 16 4 0ms 0ms 17 4 0ms 0ms 18 4 0ms 0ms 19 4 0ms 0ms 20 4 0ms 0ms 21 4 0ms 0ms 22 4 0ms 0ms 23 4 0ms 0ms [ User: azuresu - Total duration: 14ms - Times executed: 289 ]
[ Application: [unknown] - Total duration: 14ms - Times executed: 289 ]
-
set session statement_timeout to 60000;
Date: 2025-09-26 07:14:34 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-23 19:10:54 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-24 11:11:54 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
14 2ms 144 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming bind #14
Day Hour Count Duration Avg duration 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 1 0ms 0ms 01 1 0ms 0ms 02 1 0ms 0ms 03 1 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 0ms 0ms 05 2 0ms 0ms 06 2 0ms 0ms 07 2 0ms 0ms 08 2 0ms 0ms 09 2 0ms 0ms 10 2 0ms 0ms 11 2 0ms 0ms 12 2 0ms 0ms 13 2 0ms 0ms 14 2 0ms 0ms 15 2 0ms 0ms 16 2 0ms 0ms 17 2 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms 23 2 0ms 0ms [ User: azuresu - Total duration: 11ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 11ms - Times executed: 144 ]
-
set session statement_timeout to 120000;
Date: 2025-09-26 00:44:11 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-25 03:42:55 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-26 18:45:15 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
Events
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 0 ERROR entries
- 0 WARNING entries
Errors per 5 minutes
NO DATASET
Most Frequent Errors/Events
Key values
- 0 Max number of times the same event was reported
- 0 Total events found
Rank Times reported Error NO DATASET