pgBadger-
Global information
- Generated on Mon Oct 6 09:34:49 2025
- Log file: ././A3D-RND-REF/y=2025/m=10/d=04/h=00/m=00/PT1H.log, ..., ././A3D-RND-REF/y=2025/m=10/d=04/h=23/m=00/PT1H.log
- Parsed 3,118,239 log entries in 3m49s
- Log start from 2025-09-28 00:17:02 to 2025-10-04 23:57:03
-
Overview
Global Stats
- 750 Number of unique normalized queries
- 6,629 Number of queries
- 14m9s Total query duration
- 2025-09-28 00:17:02 First query
- 2025-10-04 23:57:03 Last query
- 212 queries/s at 2025-10-01 06:19:31 Query peak
- 14m9s Total query duration
- 1s95ms Prepare/parse total duration
- 1s378ms Bind total duration
- 14m6s 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
- 378 Total number of sessions
- 3 sessions at 2025-10-01 06:44:33 Session peak
- 8h6m36s Total duration of sessions
- 1m17s Average duration of sessions
- 17 Average queries per session
- 2s246ms Average queries duration per session
- 1m14s Average idle time per session
- 378 Total number of connections
- 2 connections/s at 2025-10-02 06:19:29 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 212 queries/s Query Peak
- 2025-10-01 06:19:31 Date
SELECT Traffic
Key values
- 197 queries/s Query Peak
- 2025-10-03 06:19:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 50 queries/s Query Peak
- 2025-09-30 06:49:39 Date
Queries duration
Key values
- 14m9s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 10ms 2ms 10ms 10ms 10ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 5ms 1ms 5ms 5ms 5ms 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 5ms 5ms 5ms 08 6 0ms 4ms 1ms 4ms 4ms 4ms 09 6 0ms 4ms 1ms 4ms 4ms 4ms 10 6 0ms 6ms 1ms 6ms 6ms 6ms 11 6 0ms 5ms 1ms 5ms 5ms 5ms 12 6 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 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 4ms 4ms 4ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Sep 29 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 5ms 1ms 5ms 5ms 5ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 4ms 1ms 4ms 4ms 4ms 06 1,109 0ms 38s394ms 152ms 1s210ms 1m5s 1m31s 07 6 0ms 6ms 1ms 6ms 6ms 6ms 08 9 0ms 4ms 1ms 4ms 4ms 4ms 09 15 0ms 77ms 14ms 210ms 210ms 210ms 10 6 0ms 4ms 1ms 5ms 5ms 5ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 7 0ms 5ms 1ms 5ms 5ms 5ms 13 7 0ms 4ms 1ms 4ms 4ms 4ms 14 6 0ms 5ms 1ms 5ms 5ms 5ms 15 6 0ms 4ms 1ms 4ms 4ms 4ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 5ms 5ms 5ms 18 6 0ms 7ms 2ms 7ms 7ms 7ms 19 6 0ms 5ms 1ms 5ms 5ms 5ms 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 30 00 6 0ms 5ms 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 4ms 4ms 4ms 06 1,109 0ms 41s996ms 170ms 597ms 39s523ms 1m55s 07 6 0ms 4ms 1ms 4ms 4ms 4ms 08 6 0ms 4ms 1ms 4ms 4ms 4ms 09 14 0ms 74ms 13ms 185ms 185ms 185ms 10 6 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 6 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 5ms 5ms 5ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 1ms 7ms 7ms 7ms 19 6 0ms 5ms 1ms 5ms 5ms 5ms 20 6 0ms 4ms 1ms 5ms 5ms 5ms 21 6 0ms 5ms 1ms 5ms 5ms 5ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Oct 01 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 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 35s921ms 121ms 601ms 54s997ms 1m8s 07 14 0ms 73ms 13ms 182ms 182ms 182ms 08 6 0ms 6ms 1ms 6ms 6ms 6ms 09 14 0ms 52ms 10ms 129ms 129ms 129ms 10 16 0ms 53ms 10ms 129ms 129ms 129ms 11 6 0ms 4ms 1ms 4ms 4ms 4ms 12 8 0ms 4ms 1ms 4ms 4ms 4ms 13 7 0ms 5ms 1ms 5ms 5ms 5ms 14 6 0ms 4ms 1ms 4ms 4ms 4ms 15 14 0ms 53ms 9ms 129ms 129ms 129ms 16 6 0ms 4ms 1ms 4ms 4ms 4ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 2ms 7ms 7ms 7ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 5ms 5ms 5ms 21 6 0ms 8ms 2ms 8ms 8ms 8ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Oct 02 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 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 38s641ms 160ms 582ms 44s410ms 1m46s 07 14 0ms 78ms 13ms 179ms 179ms 179ms 08 14 0ms 52ms 9ms 127ms 127ms 127ms 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 8 0ms 4ms 1ms 4ms 4ms 4ms 13 6 0ms 4ms 1ms 4ms 4ms 4ms 14 30 0ms 53ms 13ms 389ms 389ms 389ms 15 6 0ms 4ms 1ms 5ms 5ms 5ms 16 6 0ms 5ms 1ms 5ms 5ms 5ms 17 6 0ms 4ms 1ms 4ms 4ms 4ms 18 6 0ms 6ms 2ms 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 5ms 5ms 5ms 23 6 0ms 6ms 1ms 6ms 6ms 6ms Oct 03 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 03 6 0ms 4ms 1ms 4ms 4ms 4ms 04 6 0ms 4ms 1ms 4ms 4ms 4ms 05 6 0ms 5ms 1ms 5ms 5ms 5ms 06 1,109 0ms 42s441ms 155ms 608ms 43s221ms 1m58s 07 6 0ms 4ms 1ms 4ms 4ms 4ms 08 6 0ms 4ms 1ms 4ms 4ms 4ms 09 7 0ms 4ms 1ms 4ms 4ms 4ms 10 6 0ms 4ms 1ms 4ms 4ms 4ms 11 6 0ms 4ms 1ms 5ms 5ms 5ms 12 6 0ms 4ms 1ms 5ms 5ms 5ms 13 7 0ms 5ms 1ms 5ms 5ms 5ms 14 9 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 6ms 6ms 6ms 19 6 0ms 4ms 1ms 4ms 4ms 4ms 20 6 0ms 4ms 1ms 4ms 4ms 4ms 21 6 0ms 5ms 1ms 6ms 6ms 6ms 22 6 0ms 4ms 1ms 4ms 4ms 4ms 23 6 0ms 4ms 1ms 4ms 4ms 4ms Oct 04 00 6 0ms 4ms 1ms 4ms 4ms 4ms 01 6 0ms 4ms 1ms 4ms 4ms 4ms 02 6 0ms 4ms 1ms 4ms 4ms 4ms 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 6 0ms 4ms 1ms 4ms 4ms 4ms 07 6 0ms 6ms 1ms 6ms 6ms 6ms 08 6 0ms 5ms 1ms 5ms 5ms 5ms 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 6 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 5ms 5ms 5ms 17 6 0ms 5ms 1ms 5ms 5ms 5ms 18 6 0ms 4ms 1ms 4ms 4ms 4ms 19 6 0ms 5ms 1ms 5ms 5ms 5ms 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 5ms 1ms 5ms 5ms 5ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 3 0 3ms 4ms 4ms 4ms 01 3 0 5ms 10ms 10ms 10ms 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 5ms 5ms 5ms 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 6ms 6ms 6ms 11 3 0 3ms 5ms 5ms 5ms 12 3 0 3ms 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 5ms 5ms 5ms 18 3 0 2ms 4ms 4ms 4ms 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 29 00 3 0 3ms 4ms 4ms 4ms 01 3 0 3ms 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 248ms 0ms 1s147ms 1m31s 07 3 0 3ms 6ms 6ms 6ms 08 6 0 1ms 4ms 4ms 4ms 09 12 0 18ms 210ms 210ms 210ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 4 0 2ms 5ms 5ms 5ms 13 4 0 2ms 4ms 4ms 4ms 14 3 0 3ms 5ms 5ms 5ms 15 3 0 3ms 4ms 4ms 4ms 16 3 0 2ms 4ms 4ms 4ms 17 3 0 3ms 5ms 5ms 5ms 18 3 0 4ms 7ms 7ms 7ms 19 3 0 3ms 5ms 5ms 5ms 20 3 0 2ms 4ms 4ms 4ms 21 3 0 3ms 4ms 4ms 4ms 22 3 0 2ms 4ms 4ms 4ms 23 3 0 3ms 4ms 4ms 4ms Sep 30 00 3 0 3ms 5ms 5ms 5ms 01 3 0 3ms 5ms 5ms 5ms 02 3 0 3ms 5ms 5ms 5ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 2ms 4ms 4ms 4ms 06 436 245 278ms 0ms 548ms 1m55s 07 3 0 3ms 4ms 4ms 4ms 08 3 0 3ms 4ms 4ms 4ms 09 11 0 17ms 185ms 185ms 185ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 3 0 3ms 4ms 4ms 4ms 13 3 0 3ms 4ms 4ms 4ms 14 3 0 3ms 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 6ms 6ms 6ms 19 3 0 3ms 5ms 5ms 5ms 20 3 0 3ms 4ms 4ms 4ms 21 3 0 3ms 5ms 5ms 5ms 22 3 0 2ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Oct 01 00 3 0 3ms 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 3ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 436 245 197ms 0ms 554ms 1m8s 07 11 0 17ms 182ms 182ms 182ms 08 3 0 3ms 6ms 6ms 6ms 09 11 0 12ms 129ms 129ms 129ms 10 12 0 14ms 129ms 129ms 129ms 11 3 0 3ms 4ms 4ms 4ms 12 5 0 1ms 4ms 4ms 4ms 13 4 0 2ms 5ms 5ms 5ms 14 3 0 3ms 4ms 4ms 4ms 15 11 0 12ms 129ms 129ms 129ms 16 3 0 3ms 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 4ms 8ms 8ms 8ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Oct 02 00 3 0 3ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 2ms 4ms 4ms 4ms 04 3 0 2ms 4ms 4ms 4ms 05 3 0 3ms 4ms 4ms 4ms 06 436 245 260ms 0ms 535ms 1m46s 07 11 0 17ms 179ms 179ms 179ms 08 11 0 12ms 127ms 127ms 127ms 09 3 0 3ms 4ms 4ms 4ms 10 3 0 2ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 5 0 1ms 4ms 4ms 4ms 13 3 0 3ms 4ms 4ms 4ms 14 27 0 14ms 389ms 389ms 389ms 15 3 0 3ms 4ms 4ms 4ms 16 3 0 3ms 5ms 5ms 5ms 17 3 0 3ms 4ms 4ms 4ms 18 3 0 4ms 7ms 7ms 7ms 19 3 0 3ms 4ms 4ms 4ms 20 3 0 2ms 4ms 4ms 4ms 21 3 0 2ms 4ms 4ms 4ms 22 3 0 3ms 4ms 4ms 4ms 23 3 0 3ms 6ms 6ms 6ms Oct 03 00 3 0 3ms 4ms 4ms 4ms 01 3 0 3ms 4ms 4ms 4ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 3ms 4ms 4ms 4ms 05 3 0 3ms 5ms 5ms 5ms 06 436 245 253ms 0ms 559ms 1m58s 07 3 0 2ms 4ms 4ms 4ms 08 3 0 3ms 4ms 4ms 4ms 09 4 0 2ms 4ms 4ms 4ms 10 3 0 3ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 3 0 3ms 4ms 4ms 4ms 13 4 0 2ms 5ms 5ms 5ms 14 6 0 1ms 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 6ms 6ms 6ms 19 3 0 2ms 4ms 4ms 4ms 20 3 0 2ms 4ms 4ms 4ms 21 3 0 3ms 5ms 5ms 5ms 22 3 0 2ms 4ms 4ms 4ms 23 3 0 2ms 4ms 4ms 4ms Oct 04 00 3 0 3ms 4ms 4ms 4ms 01 3 0 2ms 4ms 4ms 4ms 02 3 0 3ms 4ms 4ms 4ms 03 3 0 3ms 4ms 4ms 4ms 04 3 0 2ms 4ms 4ms 4ms 05 3 0 2ms 4ms 4ms 4ms 06 3 0 3ms 4ms 4ms 4ms 07 3 0 3ms 6ms 6ms 6ms 08 3 0 3ms 5ms 5ms 5ms 09 3 0 3ms 4ms 4ms 4ms 10 3 0 2ms 4ms 4ms 4ms 11 3 0 3ms 4ms 4ms 4ms 12 3 0 2ms 4ms 4ms 4ms 13 3 0 2ms 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 5ms 5ms 5ms 18 3 0 3ms 4ms 4ms 4ms 19 3 0 3ms 5ms 5ms 5ms 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 5ms 5ms 5ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 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 30 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Oct 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Oct 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 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 Oct 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 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 Oct 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 28 00 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% Sep 29 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 9 9 1.00 150.00% 09 15 15 1.00 125.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 7 7 1.00 175.00% 13 7 7 1.00 175.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 30 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 14 14 1.00 127.27% 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% Oct 01 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 14 14 1.00 127.27% 08 6 6 1.00 200.00% 09 14 14 1.00 127.27% 10 16 16 1.00 133.33% 11 6 6 1.00 200.00% 12 8 8 1.00 160.00% 13 7 7 1.00 175.00% 14 6 6 1.00 200.00% 15 14 14 1.00 127.27% 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% Oct 02 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 14 14 1.00 127.27% 08 14 14 1.00 127.27% 09 6 6 1.00 200.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 8 8 1.00 160.00% 13 6 6 1.00 200.00% 14 30 30 1.00 111.11% 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% Oct 03 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 7 7 1.00 175.00% 10 6 6 1.00 200.00% 11 6 6 1.00 200.00% 12 6 6 1.00 200.00% 13 7 7 1.00 175.00% 14 9 9 1.00 150.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% Oct 04 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 28 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 Sep 29 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 2 0.00/s 08 5 0.00/s 09 4 0.00/s 10 2 0.00/s 11 2 0.00/s 12 3 0.00/s 13 3 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 30 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 3 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 Oct 01 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 2 0.00/s 09 3 0.00/s 10 3 0.00/s 11 2 0.00/s 12 4 0.00/s 13 3 0.00/s 14 2 0.00/s 15 3 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 Oct 02 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 3 0.00/s 08 3 0.00/s 09 2 0.00/s 10 2 0.00/s 11 2 0.00/s 12 4 0.00/s 13 2 0.00/s 14 5 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 Oct 03 00 2 0.00/s 01 2 0.00/s 02 2 0.00/s 03 2 0.00/s 04 2 0.00/s 05 2 0.00/s 06 5 0.00/s 07 2 0.00/s 08 2 0.00/s 09 3 0.00/s 10 2 0.00/s 11 2 0.00/s 12 2 0.00/s 13 3 0.00/s 14 5 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 Oct 04 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 28 00 2 73ms 68ms 01 2 77ms 69ms 02 2 72ms 67ms 03 2 76ms 71ms 04 2 76ms 71ms 05 2 78ms 72ms 06 2 72ms 67ms 07 2 74ms 69ms 08 2 73ms 68ms 09 2 69ms 64ms 10 2 81ms 75ms 11 2 73ms 68ms 12 2 71ms 66ms 13 2 72ms 67ms 14 2 80ms 75ms 15 2 73ms 68ms 16 2 73ms 68ms 17 2 81ms 75ms 18 2 73ms 68ms 19 2 71ms 66ms 20 2 76ms 71ms 21 2 73ms 68ms 22 2 71ms 66ms 23 2 70ms 65ms Sep 29 00 2 70ms 65ms 01 2 73ms 68ms 02 2 69ms 64ms 03 2 80ms 74ms 04 2 71ms 66ms 05 2 74ms 69ms 06 5 20m4s 19m30s 07 2 97ms 91ms 08 5 64ms 62ms 09 4 199ms 144ms 10 2 77ms 72ms 11 2 84ms 79ms 12 3 72ms 68ms 13 3 73ms 70ms 14 2 74ms 68ms 15 2 71ms 66ms 16 2 73ms 68ms 17 2 80ms 75ms 18 2 103ms 96ms 19 2 79ms 74ms 20 2 74ms 69ms 21 2 71ms 66ms 22 2 68ms 64ms 23 2 71ms 66ms Sep 30 00 2 74ms 69ms 01 2 73ms 68ms 02 2 76ms 70ms 03 2 70ms 65ms 04 2 75ms 70ms 05 2 69ms 64ms 06 5 18m24s 17m46s 07 2 70ms 65ms 08 2 72ms 67ms 09 3 219ms 154ms 10 2 73ms 68ms 11 2 68ms 63ms 12 2 71ms 66ms 13 2 73ms 68ms 14 2 76ms 71ms 15 2 70ms 65ms 16 2 70ms 64ms 17 2 79ms 74ms 18 2 108ms 102ms 19 2 73ms 68ms 20 2 85ms 80ms 21 2 78ms 72ms 22 2 72ms 67ms 23 2 72ms 67ms Oct 01 00 2 75ms 70ms 01 2 75ms 70ms 02 2 72ms 67ms 03 2 71ms 66ms 04 2 71ms 66ms 05 2 71ms 66ms 06 5 18m9s 17m42s 07 3 209ms 145ms 08 2 73ms 67ms 09 3 193ms 146ms 10 3 201ms 143ms 11 2 75ms 70ms 12 4 65ms 63ms 13 3 69ms 66ms 14 2 72ms 67ms 15 3 182ms 135ms 16 2 70ms 65ms 17 2 74ms 69ms 18 2 101ms 94ms 19 2 82ms 77ms 20 2 72ms 66ms 21 2 76ms 69ms 22 2 74ms 69ms 23 2 72ms 67ms Oct 02 00 2 72ms 67ms 01 2 75ms 70ms 02 2 72ms 67ms 03 2 71ms 66ms 04 2 70ms 65ms 05 2 73ms 68ms 06 5 21m3s 20m27s 07 3 175ms 112ms 08 3 199ms 153ms 09 2 75ms 70ms 10 2 73ms 68ms 11 2 75ms 70ms 12 4 71ms 69ms 13 2 73ms 68ms 14 5 285ms 205ms 15 2 81ms 76ms 16 2 75ms 70ms 17 2 79ms 74ms 18 2 119ms 112ms 19 2 72ms 67ms 20 2 72ms 68ms 21 2 75ms 70ms 22 2 76ms 71ms 23 2 76ms 70ms Oct 03 00 2 71ms 66ms 01 2 71ms 66ms 02 2 76ms 71ms 03 2 76ms 71ms 04 2 74ms 69ms 05 2 73ms 68ms 06 5 19m30s 18m56s 07 2 72ms 67ms 08 2 71ms 66ms 09 3 82ms 79ms 10 2 74ms 69ms 11 2 71ms 66ms 12 2 73ms 68ms 13 3 73ms 70ms 14 5 66ms 64ms 15 2 89ms 84ms 16 2 85ms 80ms 17 2 75ms 70ms 18 2 104ms 98ms 19 2 74ms 69ms 20 2 73ms 69ms 21 2 76ms 71ms 22 2 73ms 68ms 23 2 72ms 67ms Oct 04 00 2 74ms 69ms 01 2 71ms 67ms 02 2 74ms 69ms 03 2 71ms 66ms 04 2 72ms 67ms 05 2 73ms 68ms 06 2 73ms 68ms 07 2 93ms 87ms 08 2 76ms 71ms 09 2 83ms 78ms 10 2 82ms 77ms 11 2 73ms 68ms 12 2 72ms 68ms 13 2 84ms 80ms 14 2 76ms 71ms 15 2 73ms 68ms 16 2 79ms 73ms 17 2 91ms 86ms 18 2 74ms 69ms 19 2 78ms 73ms 20 2 80ms 75ms 21 2 76ms 71ms 22 2 76ms 71ms 23 2 75ms 70ms -
Connections
Established Connections
Key values
- 2 connections Connection Peak
- 2025-10-02 06:19:29 Date
Connections per database
Key values
- cnrs Main Database
- 378 connections Total
Connections per user
Key values
- azuresu Main User
- 378 connections Total
-
Sessions
Simultaneous sessions
Key values
- 3 sessions Session Peak
- 2025-10-01 06:44:33 Date
Histogram of session times
Key values
- 361 0-500ms duration
Sessions per database
Key values
- cnrs Main Database
- 378 sessions Total
Sessions per user
Key values
- azuresu Main User
- 378 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 378 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 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Sep 29 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Oct 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Oct 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 Oct 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 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 Oct 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 29 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Sep 30 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 01 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 02 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 03 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 Oct 04 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- 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,774 Total read queries
- 1,245 Total write queries
Queries by database
Key values
- cnrs Main database
- 6,629 Requests
- 14m6s (cnrs)
- Main time consuming database
Queries by user
Key values
- a3dsupervisor Main user
- 5,619 Requests
User Request type Count Duration a3dsupervisor Total 5,619 14m5s copy to 1,225 13m59s cte 5 40ms others 2,105 495ms select 2,269 5s13ms tcl 15 0ms azuresu Total 1,154 1s905ms others 577 32ms select 577 1s873ms Duration by user
Key values
- 14m5s (a3dsupervisor) Main time consuming user
User Request type Count Duration a3dsupervisor Total 5,619 14m5s copy to 1,225 13m59s cte 5 40ms others 2,105 495ms select 2,269 5s13ms tcl 15 0ms azuresu Total 1,154 1s905ms others 577 32ms select 577 1s873ms Queries by host
Key values
- 10.3.0.4 Main host
- 5,611 Requests
- 14m4s (10.3.0.4)
- Main time consuming host
Queries by application
Key values
- pg_dump Main application
- 5,515 Requests
- 14m3s (pg_dump)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-09-30 06:37:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,995 0-1ms duration
Slowest individual queries
Rank Duration Query 1 42s441ms 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-10-03 06:51:57 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
2 41s996ms 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-30 06:49:06 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
3 39s516ms 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-30 06:50:07 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
4 38s641ms 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-10-02 06:53:34 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
5 38s394ms 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-29 06:52:56 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
6 38s52ms 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-10-02 06:54:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
7 35s921ms 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-10-01 06:49:47 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
8 31s535ms 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-29 06:51:39 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
9 29s338ms 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-29 06:52:20 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
10 28s265ms 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-30 06:49:35 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
11 27s930ms 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-10-03 06:51:14 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
12 27s15ms 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-10-03 06:50:43 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
13 26s774ms 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-10-02 06:53:59 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
14 25s845ms 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-10-01 06:48:28 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
15 24s859ms 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-10-03 06:51:10 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
16 22s147ms COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;[ Date: 2025-09-30 06:48:46 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
17 20s32ms 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-10-02 06:53:33 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
18 19s753ms 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-30 06:49:08 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
19 16s838ms 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-10-01 06:49:00 - Database: cnrs - User: a3dsupervisor - Remote: 10.3.0.4 - Application: pg_dump ]
20 16s507ms 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-29 06:51:58 - 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 3m14s 5 35s921ms 42s441ms 38s865ms 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 29 08 1 38s394ms 38s394ms Sep 30 08 1 39s516ms 39s516ms Oct 01 08 1 35s921ms 35s921ms Oct 02 08 1 38s52ms 38s52ms Oct 03 08 1 42s441ms 42s441ms [ User: a3dsupervisor - Total duration: 3m14s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-03 06:51:57 Duration: 42s441ms 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-30 06:50:07 Duration: 39s516ms 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-29 06:52:56 Duration: 38s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 2m45s 5 25s845ms 41s996ms 33s6ms 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 29 08 1 31s535ms 31s535ms Sep 30 08 1 41s996ms 41s996ms Oct 01 08 1 25s845ms 25s845ms Oct 02 08 1 38s641ms 38s641ms Oct 03 08 1 27s15ms 27s15ms [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m45s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-09-30 06:49:06 Duration: 41s996ms 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-10-02 06:53:34 Duration: 38s641ms 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-29 06:51:39 Duration: 31s535ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 2m9s 5 16s838ms 29s338ms 25s829ms 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 29 08 1 29s338ms 29s338ms Sep 30 08 1 28s265ms 28s265ms Oct 01 08 1 16s838ms 16s838ms Oct 02 08 1 26s774ms 26s774ms Oct 03 08 1 27s930ms 27s930ms [ User: a3dsupervisor - Total duration: 2m9s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-29 06:52:20 Duration: 29s338ms 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-30 06:49:35 Duration: 28s265ms 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-10-03 06:51:14 Duration: 27s930ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 1m34s 5 13s145ms 24s859ms 18s859ms 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 29 08 1 16s507ms 16s507ms Sep 30 08 1 19s753ms 19s753ms Oct 01 08 1 13s145ms 13s145ms Oct 02 08 1 20s32ms 20s32ms Oct 03 08 1 24s859ms 24s859ms [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 5 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-03 06:51:10 Duration: 24s859ms 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-10-02 06:53:33 Duration: 20s32ms 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-30 06:49:08 Duration: 19s753ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 1m23s 5 15s270ms 22s147ms 16s717ms 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 29 08 1 15s475ms 15s475ms Sep 30 08 1 22s147ms 22s147ms Oct 01 08 1 15s318ms 15s318ms Oct 02 08 1 15s376ms 15s376ms Oct 03 08 1 15s270ms 15s270ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-30 06:48:46 Duration: 22s147ms 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-29 06:51:08 Duration: 15s475ms 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-10-02 06:52:55 Duration: 15s376ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 1m11s 5 8s256ms 16s424ms 14s205ms 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 29 08 1 15s542ms 15s542ms Sep 30 08 1 16s333ms 16s333ms Oct 01 08 1 8s256ms 8s256ms Oct 02 08 1 16s424ms 16s424ms Oct 03 08 1 14s471ms 14s471ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-02 06:53:54 Duration: 16s424ms 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-30 06:49:27 Duration: 16s333ms 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-29 06:52:17 Duration: 15s542ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 45s279ms 5 8s547ms 9s732ms 9s55ms 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 29 08 1 9s14ms 9s14ms Sep 30 08 1 8s547ms 8s547ms Oct 01 08 1 8s605ms 8s605ms Oct 02 08 1 9s732ms 9s732ms Oct 03 08 1 9s379ms 9s379ms [ User: a3dsupervisor - Total duration: 45s279ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 45s279ms - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-02 06:52:38 Duration: 9s732ms 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-10-03 06:49:58 Duration: 9s379ms 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-29 06:50:49 Duration: 9s14ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 11s890ms 5 2s313ms 2s446ms 2s378ms 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 29 08 1 2s446ms 2s446ms Sep 30 08 1 2s313ms 2s313ms Oct 01 08 1 2s400ms 2s400ms Oct 02 08 1 2s391ms 2s391ms Oct 03 08 1 2s336ms 2s336ms [ User: a3dsupervisor - Total duration: 11s890ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 11s890ms - Times executed: 5 ]
-
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-29 06:52:23 Duration: 2s446ms 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-10-01 06:49:21 Duration: 2s400ms 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-10-02 06:54:03 Duration: 2s391ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 8s23ms 5 1s585ms 1s625ms 1s604ms 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 29 08 1 1s590ms 1s590ms Sep 30 08 1 1s620ms 1s620ms Oct 01 08 1 1s625ms 1s625ms Oct 02 08 1 1s602ms 1s602ms Oct 03 08 1 1s585ms 1s585ms [ User: a3dsupervisor - Total duration: 8s23ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 8s23ms - Times executed: 5 ]
-
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-10-01 06:49:25 Duration: 1s625ms 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-30 06:49:41 Duration: 1s620ms 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-10-02 06:54:06 Duration: 1s602ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 4s855ms 5 423ms 1s180ms 971ms 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 29 08 1 1s180ms 1s180ms Sep 30 08 1 1s96ms 1s96ms Oct 01 08 1 423ms 423ms Oct 02 08 1 1s83ms 1s83ms Oct 03 08 1 1s71ms 1s71ms [ User: a3dsupervisor - Total duration: 4s855ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4s855ms - Times executed: 5 ]
-
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-29 06:52:01 Duration: 1s180ms 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-30 06:49:10 Duration: 1s96ms 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-10-02 06:53:37 Duration: 1s83ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 3s408ms 5 664ms 700ms 681ms 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 29 08 1 700ms 700ms Sep 30 08 1 691ms 691ms Oct 01 08 1 675ms 675ms Oct 02 08 1 675ms 675ms Oct 03 08 1 664ms 664ms [ User: a3dsupervisor - Total duration: 3s408ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s408ms - Times executed: 5 ]
-
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-29 06:52:21 Duration: 700ms 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-30 06:49:36 Duration: 691ms 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-10-01 06:49:19 Duration: 675ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 2s882ms 5 378ms 810ms 576ms 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 #12
Day Hour Count Duration Avg duration Sep 29 08 1 506ms 506ms Sep 30 08 1 794ms 794ms Oct 01 08 1 392ms 392ms Oct 02 08 1 810ms 810ms Oct 03 08 1 378ms 378ms [ User: a3dsupervisor - Total duration: 2s882ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s882ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-02 06:53:11 Duration: 810ms 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-30 06:48:47 Duration: 794ms 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-29 06:51:41 Duration: 506ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 2s627ms 5 151ms 652ms 525ms 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 #13
Day Hour Count Duration Avg duration Sep 29 08 1 652ms 652ms Sep 30 08 1 630ms 630ms Oct 01 08 1 151ms 151ms Oct 02 08 1 567ms 567ms Oct 03 08 1 625ms 625ms [ User: a3dsupervisor - Total duration: 2s627ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s627ms - Times executed: 5 ]
-
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-29 06:51:59 Duration: 652ms 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-30 06:49:09 Duration: 630ms 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-10-03 06:51:11 Duration: 625ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 1s962ms 5 372ms 432ms 392ms 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 29 08 1 432ms 432ms Sep 30 08 1 372ms 372ms Oct 01 08 1 380ms 380ms Oct 02 08 1 391ms 391ms Oct 03 08 1 385ms 385ms [ User: a3dsupervisor - Total duration: 1s962ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s962ms - Times executed: 5 ]
-
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-29 06:52:24 Duration: 432ms 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-10-02 06:54:03 Duration: 391ms 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-10-03 06:51:31 Duration: 385ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 1s599ms 336 4ms 10ms 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 #15
Day Hour Count Duration Avg duration Sep 28 02 2 9ms 4ms 03 2 15ms 7ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 9ms 4ms 09 2 9ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 10ms 5ms 13 2 10ms 5ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 8ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms Sep 29 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 10ms 5ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 10ms 5ms 17 2 9ms 4ms 18 2 8ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 8ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Sep 30 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 8ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 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 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 01 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 10 2 10ms 5ms 11 2 11ms 5ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 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 12ms 6ms 00 2 9ms 4ms 01 2 8ms 4ms Oct 02 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 8ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 10ms 5ms 09 2 9ms 4ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 9ms 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 8ms 4ms 23 2 8ms 4ms 00 2 9ms 4ms 01 2 11ms 5ms Oct 03 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 12ms 6ms 09 2 8ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 8ms 4ms 22 2 8ms 4ms 23 2 10ms 5ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 04 02 2 9ms 4ms 03 2 8ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 8ms 4ms 08 2 9ms 4ms 09 2 10ms 5ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 9ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 9ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 1s599ms - Times executed: 336 ]
[ Application: [unknown] - Total duration: 1s599ms - Times executed: 336 ]
-
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-28 01:47:07 Duration: 10ms 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-10-03 06:54:37 Duration: 8ms 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-10-01 21:22:35 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
16 1s495ms 5 190ms 408ms 299ms 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 #16
Day Hour Count Duration Avg duration Sep 29 08 1 408ms 408ms Sep 30 08 1 355ms 355ms Oct 01 08 1 325ms 325ms Oct 02 08 1 215ms 215ms Oct 03 08 1 190ms 190ms [ User: a3dsupervisor - Total duration: 1s495ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s495ms - Times executed: 5 ]
-
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-29 06:50:50 Duration: 408ms 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-30 06:48:23 Duration: 355ms 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-10-01 06:47:45 Duration: 325ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 1s467ms 5 88ms 733ms 293ms copy public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 1 236ms 236ms Sep 30 08 1 298ms 298ms Oct 01 08 1 88ms 88ms Oct 02 08 1 733ms 733ms Oct 03 08 1 110ms 110ms [ User: a3dsupervisor - Total duration: 1s467ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s467ms - Times executed: 5 ]
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-10-02 06:53:12 Duration: 733ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-09-30 06:48:48 Duration: 298ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-09-29 06:51:41 Duration: 236ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 1s382ms 5 260ms 288ms 276ms 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 #18
Day Hour Count Duration Avg duration Sep 29 08 1 275ms 275ms Sep 30 08 1 287ms 287ms Oct 01 08 1 288ms 288ms Oct 02 08 1 260ms 260ms Oct 03 08 1 270ms 270ms [ User: a3dsupervisor - Total duration: 1s382ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s382ms - Times executed: 5 ]
-
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-10-01 06:49:25 Duration: 288ms 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-30 06:49:42 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-29 06:52:27 Duration: 275ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 1s317ms 5 120ms 456ms 263ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 299ms 299ms Sep 30 08 1 456ms 456ms Oct 01 08 1 124ms 124ms Oct 02 08 1 317ms 317ms Oct 03 08 1 120ms 120ms [ User: a3dsupervisor - Total duration: 1s317ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s317ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-30 06:48:47 Duration: 456ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-02 06:53:10 Duration: 317ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-29 06:51:40 Duration: 299ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 1s93ms 5 50ms 280ms 218ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 1 257ms 257ms Sep 30 08 1 280ms 280ms Oct 01 08 1 50ms 50ms Oct 02 08 1 277ms 277ms Oct 03 08 1 227ms 227ms [ User: a3dsupervisor - Total duration: 1s93ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s93ms - Times executed: 5 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-30 06:49:11 Duration: 280ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-10-02 06:53:38 Duration: 277ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-29 06:52:01 Duration: 257ms 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 820 139ms 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 29 08 164 33ms 0ms Sep 30 08 164 26ms 0ms Oct 01 08 164 26ms 0ms Oct 02 08 164 26ms 0ms Oct 03 08 164 25ms 0ms [ User: a3dsupervisor - Total duration: 139ms - Times executed: 820 ]
[ Application: pg_dump - Total duration: 139ms - Times executed: 820 ]
-
SELECT format_type(seqtypid, NULL), seqstart, seqincrement, seqmax, seqmin, seqcache, seqcycle FROM pg_catalog.pg_sequence WHERE seqrelid = '2648852'::oid;
Date: 2025-09-29 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-30 06:19:26 Duration: 2ms 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-10-03 06:19:25 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 630 118ms 0ms 3ms 0ms execute dumpfunc (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 29 08 126 29ms 0ms Sep 30 08 126 22ms 0ms Oct 01 08 126 21ms 0ms Oct 02 08 126 22ms 0ms Oct 03 08 126 22ms 0ms [ User: a3dsupervisor - Total duration: 118ms - Times executed: 630 ]
[ Application: pg_dump - Total duration: 118ms - Times executed: 630 ]
-
EXECUTE dumpFunc ('16579');
Date: 2025-09-29 06:19:27 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16564');
Date: 2025-09-29 06:19:27 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpFunc ('16538');
Date: 2025-09-30 06:19:25 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 505 28ms 0ms 0ms 0ms set session statement_timeout to ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 28 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 29 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 30 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 Oct 01 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 Oct 02 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 Oct 03 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 Oct 04 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: 28ms - Times executed: 505 ]
[ Application: [unknown] - Total duration: 28ms - Times executed: 505 ]
-
set session statement_timeout to 120000;
Date: 2025-09-29 10:49:05 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-30 20:21:04 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
set session statement_timeout to 60000;
Date: 2025-10-01 04:21:33 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 336 1s599ms 4ms 10ms 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 28 02 2 9ms 4ms 03 2 15ms 7ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 9ms 4ms 09 2 9ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 10ms 5ms 13 2 10ms 5ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 8ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms Sep 29 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 10ms 5ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 10ms 5ms 17 2 9ms 4ms 18 2 8ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 8ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Sep 30 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 8ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 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 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 01 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 10 2 10ms 5ms 11 2 11ms 5ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 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 12ms 6ms 00 2 9ms 4ms 01 2 8ms 4ms Oct 02 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 8ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 10ms 5ms 09 2 9ms 4ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 9ms 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 8ms 4ms 23 2 8ms 4ms 00 2 9ms 4ms 01 2 11ms 5ms Oct 03 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 12ms 6ms 09 2 8ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 8ms 4ms 22 2 8ms 4ms 23 2 10ms 5ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 04 02 2 9ms 4ms 03 2 8ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 8ms 4ms 08 2 9ms 4ms 09 2 10ms 5ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 9ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 9ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 1s599ms - Times executed: 336 ]
[ Application: [unknown] - Total duration: 1s599ms - Times executed: 336 ]
-
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-28 01:47:07 Duration: 10ms 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-10-03 06:54:37 Duration: 8ms 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-10-01 21:22:35 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
5 168 18ms 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 28 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 29 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 30 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 Oct 01 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 Oct 02 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 Oct 03 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 Oct 04 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: 18ms - Times executed: 168 ]
[ Application: [unknown] - Total duration: 18ms - Times executed: 168 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-10-01 06:51:42 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-29 18:49:34 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-29 07:48:55 Duration: 0ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
6 110 11ms 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 29 08 22 2ms 0ms Sep 30 08 22 2ms 0ms Oct 01 08 22 2ms 0ms Oct 02 08 22 2ms 0ms Oct 03 08 22 2ms 0ms [ User: a3dsupervisor - Total duration: 11ms - Times executed: 110 ]
[ Application: pg_dump - Total duration: 11ms - Times executed: 110 ]
-
SELECT pg_catalog.format_type('23'::pg_catalog.oid, NULL);
Date: 2025-09-29 06:19:26 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('1015'::pg_catalog.oid, NULL);
Date: 2025-09-30 06:19:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.format_type('2465437'::pg_catalog.oid, NULL);
Date: 2025-09-30 06:19:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 70 9ms 0ms 1ms 0ms select pg_catalog.pg_get_statisticsobjdef (?::pg_catalog.oid);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 29 08 14 1ms 0ms Sep 30 08 14 1ms 0ms Oct 01 08 14 2ms 0ms Oct 02 08 14 1ms 0ms Oct 03 08 14 1ms 0ms [ User: a3dsupervisor - Total duration: 9ms - Times executed: 70 ]
[ Application: pg_dump - Total duration: 9ms - Times executed: 70 ]
-
SELECT pg_catalog.pg_get_statisticsobjdef ('17221'::pg_catalog.oid);
Date: 2025-10-01 06:19:32 Duration: 1ms 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-29 06:19:29 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-30 06:19:28 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 30 21ms 0ms 3ms 0ms execute dumpcompositetype (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 29 08 6 5ms 0ms Sep 30 08 6 3ms 0ms Oct 01 08 6 3ms 0ms Oct 02 08 6 3ms 0ms Oct 03 08 6 4ms 0ms [ User: a3dsupervisor - Total duration: 21ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 21ms - Times executed: 30 ]
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-09-29 06:19:26 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-10-03 06:19:25 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE dumpCompositeType ('2465423');
Date: 2025-10-01 06:19:30 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 30 18ms 0ms 2ms 0ms select pg_catalog.set_config(?, ?, false);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 29 08 6 3ms 0ms Sep 30 08 6 4ms 0ms Oct 01 08 6 3ms 0ms Oct 02 08 6 3ms 0ms Oct 03 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 18ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 18ms - Times executed: 30 ]
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-09-30 06:19:24 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-29 06:19:25 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.set_config('search_path', '', false);
Date: 2025-10-02 06:19:25 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 30 15ms 0ms 1ms 0ms execute getcolumnacls (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 29 08 6 3ms 0ms Sep 30 08 6 2ms 0ms Oct 01 08 6 2ms 0ms Oct 02 08 6 3ms 0ms Oct 03 08 6 3ms 0ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 30 ]
[ Application: pg_dump - Total duration: 15ms - Times executed: 30 ]
-
EXECUTE getColumnACLs ('12339');
Date: 2025-10-03 06:19:25 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12339');
Date: 2025-10-02 06:19:27 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
EXECUTE getColumnACLs ('12339');
Date: 2025-09-30 06:19:26 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 16 4ms 0ms 1ms 0ms select version from gtp_a3d_version order by date_version desc fetch next ? rows only;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 29 10 3 1ms 0ms 11 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms Oct 01 14 2 0ms 0ms 15 1 0ms 0ms Oct 02 14 2 0ms 0ms Oct 03 11 1 0ms 0ms 15 1 0ms 0ms 16 3 0ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 16 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-29 08:07:04 Duration: 1ms 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-10-03 09:14: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-10-01 12:33:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: [unknown] Bind query: yes
12 15 60ms 1ms 10ms 4ms select set_config(name, ?, false) from pg_settings where name = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 29 08 3 10ms 3ms Sep 30 08 3 11ms 3ms Oct 01 08 3 12ms 4ms Oct 02 08 3 11ms 3ms Oct 03 08 3 15ms 5ms [ User: a3dsupervisor - Total duration: 60ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 60ms - Times executed: 15 ]
-
SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind';
Date: 2025-10-03 06:19:24 Duration: 10ms 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-10-01 06:19:29 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-10-02 06:19:25 Duration: 7ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 15 15ms 0ms 3ms 1ms select pg_catalog.pg_is_in_recovery();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 29 08 3 2ms 0ms Sep 30 08 3 4ms 1ms Oct 01 08 3 2ms 0ms Oct 02 08 3 2ms 0ms Oct 03 08 3 4ms 1ms [ User: a3dsupervisor - Total duration: 15ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 15ms - Times executed: 15 ]
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-03 06:19:24 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-09-30 06:19:24 Duration: 3ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SELECT pg_catalog.pg_is_in_recovery();
Date: 2025-10-02 06:19:25 Duration: 2ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 15 8ms 0ms 1ms 0ms set datestyle = iso;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 29 08 3 1ms 0ms Sep 30 08 3 1ms 0ms Oct 01 08 3 1ms 0ms Oct 02 08 3 1ms 0ms Oct 03 08 3 1ms 0ms [ User: a3dsupervisor - Total duration: 8ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 8ms - Times executed: 15 ]
-
SET DATESTYLE = ISO;
Date: 2025-10-03 06:19:24 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-09-30 06:19:24 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET DATESTYLE = ISO;
Date: 2025-10-02 06:19:25 Duration: 1ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 15 1ms 0ms 0ms 0ms set idle_in_transaction_session_timeout = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 1ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 1ms - Times executed: 15 ]
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-09-29 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-09-30 06:19:28 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET idle_in_transaction_session_timeout = 0;
Date: 2025-10-02 06:19:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 15 0ms 0ms 0ms 0ms set extra_float_digits to ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET extra_float_digits TO 3;
Date: 2025-09-29 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-09-29 06:19:30 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET extra_float_digits TO 3;
Date: 2025-10-02 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 15 0ms 0ms 0ms 0ms set statement_timeout = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET statement_timeout = 0;
Date: 2025-10-02 06:19:29 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-01 06:19:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET statement_timeout = 0;
Date: 2025-10-01 06:19:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 15 0ms 0ms 0ms 0ms set lock_timeout = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET lock_timeout = 0;
Date: 2025-10-03 06:19:27 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET lock_timeout = 0;
Date: 2025-10-01 06:19:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET lock_timeout = 0;
Date: 2025-09-29 06:19:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 15 0ms 0ms 0ms 0ms set row_security = off;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET row_security = off;
Date: 2025-09-30 06:19:28 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-09-29 06:19:25 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET row_security = off;
Date: 2025-10-03 06:19:24 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 15 0ms 0ms 0ms 0ms set synchronize_seqscans to off;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 29 08 3 0ms 0ms Sep 30 08 3 0ms 0ms Oct 01 08 3 0ms 0ms Oct 02 08 3 0ms 0ms Oct 03 08 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 15 ]
[ Application: pg_dump - Total duration: 0ms - Times executed: 15 ]
-
SET synchronize_seqscans TO off;
Date: 2025-10-03 06:19:27 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-10-01 06:19:33 Duration: 0ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
SET synchronize_seqscans TO off;
Date: 2025-09-29 06:19:30 Duration: 0ms 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 35s921ms 42s441ms 38s865ms 5 3m14s 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 29 08 1 38s394ms 38s394ms Sep 30 08 1 39s516ms 39s516ms Oct 01 08 1 35s921ms 35s921ms Oct 02 08 1 38s52ms 38s52ms Oct 03 08 1 42s441ms 42s441ms [ User: a3dsupervisor - Total duration: 3m14s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 5 ]
-
COPY public.gtp_monthly_history (histo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, year, month, value, histo_dcre, histo_creator, histo_dmaj, histo_modifier, histo_num_id_tab, tab_line, att_unit_num_id, type) TO stdout;
Date: 2025-10-03 06:51:57 Duration: 42s441ms 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-30 06:50:07 Duration: 39s516ms 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-29 06:52:56 Duration: 38s394ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
2 25s845ms 41s996ms 33s6ms 5 2m45s 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 29 08 1 31s535ms 31s535ms Sep 30 08 1 41s996ms 41s996ms Oct 01 08 1 25s845ms 25s845ms Oct 02 08 1 38s641ms 38s641ms Oct 03 08 1 27s15ms 27s15ms [ User: a3dsupervisor - Total duration: 2m45s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m45s - Times executed: 5 ]
-
COPY public.gtp_background_task (task_num_id, user_num_id, task_service_name, task_start_date, task_end_date, task_current_step, task_max_step, task_current_progress, task_max_progress, task_log, task_status, task_error_message, task_active_status, task_last_update, task_parameters, task_create_date, canceling_user_num_id, task_report, export_file, export_file_name, source_file, source_file_name, source_obj_num_id, server_id, task_state, task_origin, task_sub_type) TO stdout;
Date: 2025-09-30 06:49:06 Duration: 41s996ms 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-10-02 06:53:34 Duration: 38s641ms 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-29 06:51:39 Duration: 31s535ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
3 16s838ms 29s338ms 25s829ms 5 2m9s 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 29 08 1 29s338ms 29s338ms Sep 30 08 1 28s265ms 28s265ms Oct 01 08 1 16s838ms 16s838ms Oct 02 08 1 26s774ms 26s774ms Oct 03 08 1 27s930ms 27s930ms [ User: a3dsupervisor - Total duration: 2m9s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 5 ]
-
COPY public.gtp_history_obj_compo (history_compo_id, action_num_id, obj_num_id, att_template_num_id, att_template_category_num_id, cell_column, cell_line, att_new_value, displayable_value, action_type, obj_compo_new_unit_num_id) TO stdout;
Date: 2025-09-29 06:52:20 Duration: 29s338ms 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-30 06:49:35 Duration: 28s265ms 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-10-03 06:51:14 Duration: 27s930ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
4 13s145ms 24s859ms 18s859ms 5 1m34s 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 29 08 1 16s507ms 16s507ms Sep 30 08 1 19s753ms 19s753ms Oct 01 08 1 13s145ms 13s145ms Oct 02 08 1 20s32ms 20s32ms Oct 03 08 1 24s859ms 24s859ms [ User: a3dsupervisor - Total duration: 1m34s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m34s - Times executed: 5 ]
-
COPY public.gtp_history_obj_action (action_num_id, action_type, user_num_id, action_date, action_task_id, action_application, action_transaction_type, action_process_type, action_comment) TO stdout;
Date: 2025-10-03 06:51:10 Duration: 24s859ms 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-10-02 06:53:33 Duration: 20s32ms 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-30 06:49:08 Duration: 19s753ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
5 15s270ms 22s147ms 16s717ms 5 1m23s 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 29 08 1 15s475ms 15s475ms Sep 30 08 1 22s147ms 22s147ms Oct 01 08 1 15s318ms 15s318ms Oct 02 08 1 15s376ms 15s376ms Oct 03 08 1 15s270ms 15s270ms [ User: a3dsupervisor - Total duration: 1m23s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m23s - Times executed: 5 ]
-
COPY public.ged_right_user (user_num_id, project_num_id, node_num_id, right_code) TO stdout;
Date: 2025-09-30 06:48:46 Duration: 22s147ms 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-29 06:51:08 Duration: 15s475ms 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-10-02 06:52:55 Duration: 15s376ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
6 8s256ms 16s424ms 14s205ms 5 1m11s 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 29 08 1 15s542ms 15s542ms Sep 30 08 1 16s333ms 16s333ms Oct 01 08 1 8s256ms 8s256ms Oct 02 08 1 16s424ms 16s424ms Oct 03 08 1 14s471ms 14s471ms [ User: a3dsupervisor - Total duration: 1m11s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 5 ]
-
COPY public.gtp_log_ehcache (log_ehcache_num_id, server_id, log_date, region_name, max_memory, used_memory_min, used_memory_average, used_memory_max, element_count_min, element_count_average, element_count_max, hit_count, miss_count) TO stdout;
Date: 2025-10-02 06:53:54 Duration: 16s424ms 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-30 06:49:27 Duration: 16s333ms 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-29 06:52:17 Duration: 15s542ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
7 8s547ms 9s732ms 9s55ms 5 45s279ms 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 29 08 1 9s14ms 9s14ms Sep 30 08 1 8s547ms 8s547ms Oct 01 08 1 8s605ms 8s605ms Oct 02 08 1 9s732ms 9s732ms Oct 03 08 1 9s379ms 9s379ms [ User: a3dsupervisor - Total duration: 45s279ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 45s279ms - Times executed: 5 ]
-
COPY public.gtp_obj_composition (obj_compo_num_id, obj_num_id, att_template_category_num_id, att_template_num_id, obj_compo_num_id_tab, obj_compo_ligne_tab_num_id, obj_compo_value, obj_compo_dcre, obj_compo_creator, obj_compo_dmaj, obj_compo_modifier, obj_compo_unit_num_id) TO stdout;
Date: 2025-10-02 06:52:38 Duration: 9s732ms 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-10-03 06:49:58 Duration: 9s379ms 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-29 06:50:49 Duration: 9s14ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
8 2s313ms 2s446ms 2s378ms 5 11s890ms 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 29 08 1 2s446ms 2s446ms Sep 30 08 1 2s313ms 2s313ms Oct 01 08 1 2s400ms 2s400ms Oct 02 08 1 2s391ms 2s391ms Oct 03 08 1 2s336ms 2s336ms [ User: a3dsupervisor - Total duration: 11s890ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 11s890ms - Times executed: 5 ]
-
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-29 06:52:23 Duration: 2s446ms 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-10-01 06:49:21 Duration: 2s400ms 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-10-02 06:54:03 Duration: 2s391ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
9 1s585ms 1s625ms 1s604ms 5 8s23ms 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 29 08 1 1s590ms 1s590ms Sep 30 08 1 1s620ms 1s620ms Oct 01 08 1 1s625ms 1s625ms Oct 02 08 1 1s602ms 1s602ms Oct 03 08 1 1s585ms 1s585ms [ User: a3dsupervisor - Total duration: 8s23ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 8s23ms - Times executed: 5 ]
-
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-10-01 06:49:25 Duration: 1s625ms 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-30 06:49:41 Duration: 1s620ms 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-10-02 06:54:06 Duration: 1s602ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
10 423ms 1s180ms 971ms 5 4s855ms 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 29 08 1 1s180ms 1s180ms Sep 30 08 1 1s96ms 1s96ms Oct 01 08 1 423ms 423ms Oct 02 08 1 1s83ms 1s83ms Oct 03 08 1 1s71ms 1s71ms [ User: a3dsupervisor - Total duration: 4s855ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 4s855ms - Times executed: 5 ]
-
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-29 06:52:01 Duration: 1s180ms 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-30 06:49:10 Duration: 1s96ms 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-10-02 06:53:37 Duration: 1s83ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
11 664ms 700ms 681ms 5 3s408ms 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 29 08 1 700ms 700ms Sep 30 08 1 691ms 691ms Oct 01 08 1 675ms 675ms Oct 02 08 1 675ms 675ms Oct 03 08 1 664ms 664ms [ User: a3dsupervisor - Total duration: 3s408ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 3s408ms - Times executed: 5 ]
-
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-29 06:52:21 Duration: 700ms 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-30 06:49:36 Duration: 691ms 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-10-01 06:49:19 Duration: 675ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
12 378ms 810ms 576ms 5 2s882ms 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 #12
Day Hour Count Duration Avg duration Sep 29 08 1 506ms 506ms Sep 30 08 1 794ms 794ms Oct 01 08 1 392ms 392ms Oct 02 08 1 810ms 810ms Oct 03 08 1 378ms 378ms [ User: a3dsupervisor - Total duration: 2s882ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s882ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_history (history_num_id, history_date, history_action, obj_num_id, obj_template_a3d_id) TO stdout;
Date: 2025-10-02 06:53:11 Duration: 810ms 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-30 06:48:47 Duration: 794ms 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-29 06:51:41 Duration: 506ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
13 151ms 652ms 525ms 5 2s627ms 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 #13
Day Hour Count Duration Avg duration Sep 29 08 1 652ms 652ms Sep 30 08 1 630ms 630ms Oct 01 08 1 151ms 151ms Oct 02 08 1 567ms 567ms Oct 03 08 1 625ms 625ms [ User: a3dsupervisor - Total duration: 2s627ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2s627ms - Times executed: 5 ]
-
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-29 06:51:59 Duration: 652ms 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-30 06:49:09 Duration: 630ms 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-10-03 06:51:11 Duration: 625ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
14 372ms 432ms 392ms 5 1s962ms 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 29 08 1 432ms 432ms Sep 30 08 1 372ms 372ms Oct 01 08 1 380ms 380ms Oct 02 08 1 391ms 391ms Oct 03 08 1 385ms 385ms [ User: a3dsupervisor - Total duration: 1s962ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s962ms - Times executed: 5 ]
-
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-29 06:52:24 Duration: 432ms 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-10-02 06:54:03 Duration: 391ms 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-10-03 06:51:31 Duration: 385ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
15 190ms 408ms 299ms 5 1s495ms 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 29 08 1 408ms 408ms Sep 30 08 1 355ms 355ms Oct 01 08 1 325ms 325ms Oct 02 08 1 215ms 215ms Oct 03 08 1 190ms 190ms [ User: a3dsupervisor - Total duration: 1s495ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s495ms - Times executed: 5 ]
-
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-29 06:50:50 Duration: 408ms 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-30 06:48:23 Duration: 355ms 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-10-01 06:47:45 Duration: 325ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
16 88ms 733ms 293ms 5 1s467ms copy public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 29 08 1 236ms 236ms Sep 30 08 1 298ms 298ms Oct 01 08 1 88ms 88ms Oct 02 08 1 733ms 733ms Oct 03 08 1 110ms 110ms [ User: a3dsupervisor - Total duration: 1s467ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s467ms - Times executed: 5 ]
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-10-02 06:53:12 Duration: 733ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-09-30 06:48:48 Duration: 298ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_file (file_num_id, file_blob, file_name, file_type, file_size, file_upload_date, uploader_num_id, file_a3d_num_id, file_context) TO stdout;
Date: 2025-09-29 06:51:41 Duration: 236ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
17 260ms 288ms 276ms 5 1s382ms 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 #17
Day Hour Count Duration Avg duration Sep 29 08 1 275ms 275ms Sep 30 08 1 287ms 287ms Oct 01 08 1 288ms 288ms Oct 02 08 1 260ms 260ms Oct 03 08 1 270ms 270ms [ User: a3dsupervisor - Total duration: 1s382ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s382ms - Times executed: 5 ]
-
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-10-01 06:49:25 Duration: 288ms 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-30 06:49:42 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-29 06:52:27 Duration: 275ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
18 120ms 456ms 263ms 5 1s317ms copy public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 29 08 1 299ms 299ms Sep 30 08 1 456ms 456ms Oct 01 08 1 124ms 124ms Oct 02 08 1 317ms 317ms Oct 03 08 1 120ms 120ms [ User: a3dsupervisor - Total duration: 1s317ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s317ms - Times executed: 5 ]
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-30 06:48:47 Duration: 456ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-10-02 06:53:10 Duration: 317ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_cw_eng_alert (history_num_id, alert_type_a3d_id, alert_src_num_id) TO stdout;
Date: 2025-09-29 06:51:40 Duration: 299ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
19 50ms 280ms 218ms 5 1s93ms copy public.gtp_log (log_date, log_type, log_info, log_release, log_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 29 08 1 257ms 257ms Sep 30 08 1 280ms 280ms Oct 01 08 1 50ms 50ms Oct 02 08 1 277ms 277ms Oct 03 08 1 227ms 227ms [ User: a3dsupervisor - Total duration: 1s93ms - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1s93ms - Times executed: 5 ]
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-30 06:49:11 Duration: 280ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-10-02 06:53:38 Duration: 277ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
-
COPY public.gtp_log (log_date, log_type, log_info, log_release, log_id) TO stdout;
Date: 2025-09-29 06:52:01 Duration: 257ms Database: cnrs User: a3dsupervisor Remote: 10.3.0.4 Application: pg_dump
20 4ms 10ms 4ms 336 1s599ms 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 #20
Day Hour Count Duration Avg duration Sep 28 02 2 9ms 4ms 03 2 15ms 7ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 9ms 4ms 09 2 9ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 10ms 5ms 13 2 10ms 5ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 8ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms Sep 29 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 10ms 5ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 10ms 5ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 10ms 5ms 17 2 9ms 4ms 18 2 8ms 4ms 19 2 9ms 4ms 20 2 11ms 5ms 21 2 9ms 4ms 22 2 8ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Sep 30 02 2 9ms 4ms 03 2 9ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 8ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 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 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 01 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 9ms 4ms 06 2 9ms 4ms 07 2 9ms 4ms 08 2 12ms 6ms 09 2 9ms 4ms 10 2 10ms 5ms 11 2 11ms 5ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 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 12ms 6ms 00 2 9ms 4ms 01 2 8ms 4ms Oct 02 02 2 9ms 4ms 03 2 9ms 4ms 04 2 8ms 4ms 05 2 8ms 4ms 06 2 8ms 4ms 07 2 9ms 4ms 08 2 10ms 5ms 09 2 9ms 4ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 8ms 4ms 14 2 9ms 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 8ms 4ms 23 2 8ms 4ms 00 2 9ms 4ms 01 2 11ms 5ms Oct 03 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 12ms 6ms 09 2 8ms 4ms 10 2 8ms 4ms 11 2 9ms 4ms 12 2 9ms 4ms 13 2 9ms 4ms 14 2 9ms 4ms 15 2 9ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 10ms 5ms 21 2 8ms 4ms 22 2 8ms 4ms 23 2 10ms 5ms 00 2 8ms 4ms 01 2 8ms 4ms Oct 04 02 2 9ms 4ms 03 2 8ms 4ms 04 2 9ms 4ms 05 2 9ms 4ms 06 2 8ms 4ms 07 2 8ms 4ms 08 2 9ms 4ms 09 2 10ms 5ms 10 2 9ms 4ms 11 2 9ms 4ms 12 2 8ms 4ms 13 2 9ms 4ms 14 2 8ms 4ms 15 2 8ms 4ms 16 2 9ms 4ms 17 2 9ms 4ms 18 2 9ms 4ms 19 2 9ms 4ms 20 2 9ms 4ms 21 2 9ms 4ms 22 2 9ms 4ms 23 2 9ms 4ms 00 2 8ms 4ms 01 2 9ms 4ms [ User: azuresu - Total duration: 1s599ms - Times executed: 336 ]
[ Application: [unknown] - Total duration: 1s599ms - Times executed: 336 ]
-
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-28 01:47:07 Duration: 10ms 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-10-03 06:54:37 Duration: 8ms 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-10-01 21:22:35 Duration: 8ms Database: cnrs User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 823ms 384 1ms 34ms 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 Oct 04 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 3ms 1ms 09 2 2ms 1ms 10 2 3ms 1ms 11 2 2ms 1ms 12 2 2ms 1ms 13 2 3ms 1ms 14 2 2ms 1ms 15 2 3ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 2ms 1ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Oct 04 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 3ms 1ms 08 2 25ms 12ms 09 2 19ms 9ms 10 2 3ms 1ms 11 2 3ms 1ms 12 2 3ms 1ms 13 2 3ms 1ms 14 2 3ms 1ms 15 2 3ms 1ms 16 2 3ms 1ms 17 2 2ms 1ms 18 2 3ms 1ms 19 2 3ms 1ms 20 2 27ms 13ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 3ms 1ms Oct 04 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 2ms 1ms 06 2 3ms 1ms 07 2 2ms 1ms 08 2 28ms 14ms 09 2 2ms 1ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 3ms 1ms 13 2 2ms 1ms 14 2 3ms 1ms 15 2 2ms 1ms 16 2 2ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 2ms 1ms 20 2 23ms 11ms 21 2 2ms 1ms 22 2 3ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Oct 04 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 25ms 12ms 09 2 2ms 1ms 10 2 3ms 1ms 11 2 3ms 1ms 12 2 3ms 1ms 13 2 3ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 3ms 1ms 17 2 2ms 1ms 18 2 3ms 1ms 19 2 2ms 1ms 20 2 24ms 12ms 21 2 2ms 1ms 22 2 2ms 1ms 23 2 3ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Oct 04 02 2 2ms 1ms 03 2 2ms 1ms 04 2 2ms 1ms 05 2 3ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 26ms 13ms 09 2 3ms 1ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 3ms 1ms 13 2 2ms 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 36ms 18ms 21 2 3ms 1ms 22 2 2ms 1ms 23 2 3ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Oct 04 02 2 2ms 1ms 03 2 2ms 1ms 04 2 3ms 1ms 05 2 2ms 1ms 06 2 2ms 1ms 07 2 2ms 1ms 08 2 21ms 10ms 09 2 2ms 1ms 10 2 2ms 1ms 11 2 2ms 1ms 12 2 2ms 1ms 13 2 2ms 1ms 14 2 2ms 1ms 15 2 2ms 1ms 16 2 3ms 1ms 17 2 2ms 1ms 18 2 2ms 1ms 19 2 3ms 1ms 20 2 31ms 15ms 21 2 2ms 1ms 22 2 3ms 1ms 23 2 2ms 1ms 00 2 2ms 1ms 01 2 2ms 1ms Oct 04 02 4 5ms 1ms 03 4 5ms 1ms 04 4 6ms 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 5ms 1ms 13 4 6ms 1ms 14 4 5ms 1ms 15 4 5ms 1ms 16 4 5ms 1ms 17 4 6ms 1ms 18 4 6ms 1ms 19 4 5ms 1ms 20 4 5ms 1ms 21 4 5ms 1ms 22 4 5ms 1ms 23 4 5ms 1ms 00 4 5ms 1ms 01 4 6ms 1ms [ User: azuresu - Total duration: 1s821ms - Times executed: 384 ]
[ Application: [unknown] - Total duration: 1s821ms - Times executed: 384 ]
-
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-10-02 18:53:53 Duration: 34ms 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-10-03 18:25:17 Duration: 30ms 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-29 18:49:34 Duration: 25ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 119ms 192 0ms 7ms 0ms SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;Times Reported Time consuming prepare #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 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 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 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 4ms 4ms 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 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 3ms 3ms 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 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 4ms 4ms 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 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 3ms 3ms 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 1ms 1ms 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 1ms 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: 18ms - Times executed: 192 ]
[ Application: [unknown] - Total duration: 18ms - Times executed: 192 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-29 18:49:34 Duration: 7ms 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-30 18:50:59 Duration: 7ms 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-10-01 18:52:25 Duration: 7ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
3 49ms 11 1ms 11ms 4ms 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 #3
Day Hour Count Duration Avg duration 09 1 8ms 8ms 09 1 9ms 9ms 07 1 7ms 7ms 09 1 1ms 1ms 10 1 1ms 1ms 15 1 1ms 1ms 07 1 11ms 11ms 08 1 1ms 1ms 14 3 6ms 2ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 11 ]
-
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-10-02 07:59:09 Duration: 11ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 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-30 09:57:13 Duration: 9ms 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-29 09:05:58 Duration: 8ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
4 42ms 11 0ms 16ms 3ms 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 09 1 7ms 7ms 09 1 5ms 5ms 07 1 5ms 5ms 09 1 1ms 1ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 16ms 16ms 08 1 0ms 0ms 14 3 3ms 1ms [ User: a3dsupervisor - Total duration: 511ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 511ms - Times executed: 11 ]
-
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-10-02 07:59:09 Duration: 16ms 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-29 09:05:58 Duration: 7ms 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-30 09:57:14 Duration: 5ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 30ms 385 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming prepare #5
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 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 2 0ms 0ms 01 2 0ms 0ms 02 2 0ms 0ms 03 2 0ms 0ms 04 2 1ms 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: 16ms - Times executed: 385 ]
[ Application: [unknown] - Total duration: 16ms - Times executed: 385 ]
-
set session statement_timeout to 60000;
Date: 2025-10-01 04:51:35 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-10-04 16:56:38 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-28 18:48:08 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
6 23ms 192 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming prepare #6
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 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: 15ms - Times executed: 192 ]
[ Application: [unknown] - Total duration: 15ms - Times executed: 192 ]
-
set session statement_timeout to 120000;
Date: 2025-09-29 12:49:12 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-10-03 17:55:16 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-10-01 20:52:33 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
7 19ms 11 0ms 3ms 1ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming prepare #7
Day Hour Count Duration Avg duration 09 1 3ms 3ms 09 1 2ms 2ms 07 1 3ms 3ms 09 1 1ms 1ms 10 1 1ms 1ms 15 1 1ms 1ms 07 1 3ms 3ms 08 1 1ms 1ms 14 3 2ms 0ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 66ms - Times executed: 11 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-02 07:59:09 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-09-29 09:05:58 Duration: 3ms 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-10-01 07:43:19 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 18ms 11 0ms 5ms 1ms 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 09 1 5ms 5ms 09 1 3ms 3ms 07 1 2ms 2ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 4ms 4ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 471ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 471ms - Times executed: 11 ]
-
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-29 09:05:59 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-10-02 07:59:09 Duration: 4ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 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-30 09:57:14 Duration: 3ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
9 18ms 16 0ms 2ms 1ms SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;Times Reported Time consuming prepare #9
Day Hour Count Duration Avg duration 08 3 4ms 1ms 09 1 1ms 1ms 12 1 0ms 0ms 13 1 0ms 0ms 12 2 2ms 1ms 13 1 0ms 0ms 12 2 1ms 0ms 09 1 1ms 1ms 13 1 1ms 1ms 14 3 3ms 1ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 16 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-29 08:07:04 Duration: 2ms 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-10-03 09:14:37 Duration: 1ms 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-10-03 14:22:54 Duration: 1ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
10 17ms 11 0ms 4ms 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 #10
Day Hour Count Duration Avg duration 09 1 4ms 4ms 09 1 2ms 2ms 07 1 2ms 2ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 2ms 2ms 08 1 0ms 0ms 14 3 2ms 0ms [ User: a3dsupervisor - Total duration: 13ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 13ms - Times executed: 11 ]
-
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-29 09:05:59 Duration: 4ms 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-30 09:57:14 Duration: 2ms 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-10-01 07:43:19 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 8ms 11 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 #11
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 2ms 2ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 1ms 1ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 11 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-30 09:57:14 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-10-02 07:59:09 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-10-01 07:43:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 4ms 1 4ms 4ms 4ms 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 #12
Day Hour Count Duration Avg duration 10 1 4ms 4ms [ User: azuresu - Total duration: 32ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 32ms - 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-10-01 10:51:56 Duration: 4ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
13 3ms 11 0ms 0ms 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 #13
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 589ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 589ms - Times executed: 11 ]
-
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-10-02 08:36:53 Duration: 0ms 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-29 09:05:59 Duration: 0ms 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-30 09:57:14 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
14 1ms 11 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 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 11 ]
-
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-30 09:57:14 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-10-01 07:43:19 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-29 09:05:58 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 1s94ms 384 1ms 30ms 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 bind #1
Day Hour Count Duration Avg duration Oct 04 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 4ms 2ms 09 2 4ms 2ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 4ms 2ms 13 2 4ms 2ms 14 2 3ms 1ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 4ms 2ms 18 2 4ms 2ms 19 2 4ms 2ms 20 2 4ms 2ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 5ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms Oct 04 02 2 4ms 2ms 03 2 4ms 2ms 04 2 4ms 2ms 05 2 6ms 3ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 25ms 12ms 09 2 32ms 16ms 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 27ms 13ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 3ms 1ms 01 2 4ms 2ms Oct 04 02 2 4ms 2ms 03 2 7ms 3ms 04 2 5ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 3ms 1ms 08 2 21ms 10ms 09 2 4ms 2ms 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 24ms 12ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 3ms 1ms Oct 04 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 4ms 2ms 10 2 4ms 2ms 11 2 5ms 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 7ms 3ms 20 2 21ms 10ms 21 2 4ms 2ms 22 2 4ms 2ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 3ms 1ms Oct 04 02 2 4ms 2ms 03 2 5ms 2ms 04 2 4ms 2ms 05 2 4ms 2ms 06 2 4ms 2ms 07 2 4ms 2ms 08 2 22ms 11ms 09 2 4ms 2ms 10 2 4ms 2ms 11 2 4ms 2ms 12 2 3ms 1ms 13 2 4ms 2ms 14 2 4ms 2ms 15 2 4ms 2ms 16 2 4ms 2ms 17 2 5ms 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 7ms 3ms 01 2 4ms 2ms Oct 04 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 21ms 10ms 09 2 3ms 1ms 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 7ms 3ms 19 2 4ms 2ms 20 2 22ms 11ms 21 2 4ms 2ms 22 2 3ms 1ms 23 2 4ms 2ms 00 2 4ms 2ms 01 2 4ms 2ms Oct 04 02 4 9ms 2ms 03 4 8ms 2ms 04 4 8ms 2ms 05 4 8ms 2ms 06 4 8ms 2ms 07 4 8ms 2ms 08 4 8ms 2ms 09 4 8ms 2ms 10 4 10ms 2ms 11 4 8ms 2ms 12 4 8ms 2ms 13 4 8ms 2ms 14 4 8ms 2ms 15 4 9ms 2ms 16 4 8ms 2ms 17 4 13ms 3ms 18 4 8ms 2ms 19 4 8ms 2ms 20 4 7ms 1ms 21 4 8ms 2ms 22 4 8ms 2ms 23 4 8ms 2ms 00 4 23ms 5ms 01 4 9ms 2ms [ User: azuresu - Total duration: 1s821ms - Times executed: 384 ]
[ Application: [unknown] - Total duration: 1s821ms - Times executed: 384 ]
-
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-29 07:18:53 Duration: 30ms 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-10-01 06:51:42 Duration: 25ms 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-29 18:49:34 Duration: 24ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
2 210ms 192 0ms 11ms 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 1ms 1ms 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 1ms 1ms 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 9ms 9ms 07 1 1ms 1ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 11 1 0ms 0ms 12 1 1ms 1ms 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 5ms 5ms 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 1ms 1ms 17 1 0ms 0ms 18 1 11ms 11ms 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 0ms 0ms 08 1 0ms 0ms 09 1 0ms 0ms 10 1 1ms 1ms 11 1 2ms 2ms 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 1ms 1ms 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 5ms 5ms 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 8ms 8ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 2ms 2ms 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 5ms 5ms 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 4ms 4ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms 23 1 0ms 0ms 00 2 1ms 0ms 01 2 1ms 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 1ms 0ms 22 2 1ms 0ms 23 2 1ms 0ms [ User: azuresu - Total duration: 18ms - Times executed: 192 ]
[ Application: [unknown] - Total duration: 18ms - Times executed: 192 ]
-
SELECT extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition FROM pg_catalog.pg_extension;
Date: 2025-09-30 18:50:59 Duration: 11ms 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-29 06:48:51 Duration: 9ms 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-10-02 18:53:53 Duration: 8ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
3 63ms 11 0ms 33ms 5ms 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 #3
Day Hour Count Duration Avg duration 09 1 33ms 33ms 09 1 9ms 9ms 07 1 7ms 7ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 8ms 8ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 13ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 13ms - Times executed: 11 ]
-
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-29 09:05:59 Duration: 33ms 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-30 09:57:14 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-10-02 07:59:09 Duration: 8ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
4 59ms 11 0ms 32ms 5ms 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 #4
Day Hour Count Duration Avg duration 09 1 32ms 32ms 09 1 6ms 6ms 07 1 6ms 6ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 7ms 7ms 08 1 0ms 0ms 14 3 2ms 0ms [ User: a3dsupervisor - Total duration: 511ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 511ms - Times executed: 11 ]
-
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-29 09:05:59 Duration: 32ms 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-10-02 07:59:09 Duration: 7ms 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-30 09:57:14 Duration: 6ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
5 24ms 11 0ms 12ms 2ms 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 09 1 12ms 12ms 09 1 2ms 2ms 07 1 2ms 2ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 2ms 2ms 08 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 589ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 589ms - Times executed: 11 ]
-
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-29 09:05:59 Duration: 12ms 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-10-01 07:43:19 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-30 09:57:14 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
6 17ms 11 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 09 1 2ms 2ms 09 1 2ms 2ms 07 1 2ms 2ms 09 1 1ms 1ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 2ms 2ms 08 1 1ms 1ms 14 3 3ms 1ms [ User: a3dsupervisor - Total duration: 6ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 6ms - Times executed: 11 ]
-
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-30 09:57:14 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-29 09:05:58 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-10-02 07:59:09 Duration: 2ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.1.6 Queryid: [unknown]
7 9ms 16 0ms 1ms 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 08 3 2ms 0ms 09 1 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 12 2 1ms 0ms 13 1 0ms 0ms 12 2 0ms 0ms 09 1 0ms 0ms 13 1 0ms 0ms 14 3 1ms 0ms [ User: a3dsupervisor - Total duration: 4ms - Times executed: 16 ]
[ Application: [unknown] - Total duration: 4ms - Times executed: 16 ]
-
SELECT VERSION FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-09-29 08:07:04 Duration: 1ms 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-29 08:36:58 Duration: 0ms 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-29 13:31:32 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
8 7ms 385 0ms 0ms 0ms set session statement_timeout to 60000;Times Reported Time consuming bind #8
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 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 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: 16ms - Times executed: 385 ]
[ Application: [unknown] - Total duration: 16ms - Times executed: 385 ]
-
set session statement_timeout to 60000;
Date: 2025-09-28 10:17:37 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-10-04 03:55:51 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 60000;
Date: 2025-09-29 02:18:35 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
9 6ms 1 6ms 6ms 6ms 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 6ms 6ms [ User: azuresu - Total duration: 32ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 32ms - 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-10-01 10:51:56 Duration: 6ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
10 5ms 11 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 #10
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 1ms 1ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 471ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 471ms - Times executed: 11 ]
-
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-30 09:57:14 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-29 09:05:59 Duration: 0ms 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-10-01 07:43:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
11 4ms 11 0ms 1ms 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 #11
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 1ms 1ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 3ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 3ms - Times executed: 11 ]
-
SELECT VERSION AS application_release FROM GTP_A3D_VERSION ORDER BY DATE_VERSION DESC FETCH NEXT 1 ROWS ONLY;
Date: 2025-10-02 07:59:09 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-30 09:57:14 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-10-01 07:43:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
12 4ms 192 0ms 0ms 0ms set session statement_timeout to 120000;Times Reported Time consuming bind #12
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 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: 15ms - Times executed: 192 ]
[ Application: [unknown] - Total duration: 15ms - Times executed: 192 ]
-
set session statement_timeout to 120000;
Date: 2025-09-30 13:50:41 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
-
set session statement_timeout to 120000;
Date: 2025-09-30 03:50: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-28 07:47:29 Duration: 0ms Database: cnrs User: cnrs Remote: azuresu Application: 169.254.128.1 Queryid: [unknown]
13 1ms 11 0ms 0ms 0ms SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;Times Reported Time consuming bind #13
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 66ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 66ms - Times executed: 11 ]
-
SELECT PG_SIZE_PRETTY(PG_DATABASE_SIZE($1)) AS database_size;
Date: 2025-10-02 14:01:01 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-29 09:05:58 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-10-01 07:43:19 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 Queryid: [unknown]
14 1ms 11 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 #14
Day Hour Count Duration Avg duration 09 1 0ms 0ms 09 1 0ms 0ms 07 1 0ms 0ms 09 1 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 07 1 0ms 0ms 08 1 0ms 0ms 14 3 0ms 0ms [ User: a3dsupervisor - Total duration: 0ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 0ms - Times executed: 11 ]
-
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-10-01 09:48:06 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-30 09:57:14 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-10-02 14:01:01 Duration: 0ms Database: cnrs User: cnrs Remote: a3dsupervisor Application: 10.3.0.4 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