pgBadger-
Global information
- Generated on Fri Nov 14 09:08:48 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=13/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=13/h=23/m=00/PT1H.log
- Parsed 175,442 log entries in 1m10s
- Log start from 2025-11-13 00:00:02 to 2025-11-13 23:59:57
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 5 Number of queries
- 1m39s Total query duration
- 2025-11-13 07:32:48 First query
- 2025-11-13 19:43:50 Last query
- 1 queries/s at 2025-11-13 07:32:48 Query peak
- 1m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1m39s Execute total duration
- 22 Number of events
- 4 Number of unique normalized events
- 15 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
- 3 Number temporary file
- 2.36 MiB Max size of temporary file
- 2.33 MiB Average size of temporary file
- 8,584 Total number of sessions
- 135 sessions at 2025-11-13 19:57:24 Session peak
- 1d2h25m8s Total duration of sessions
- 11s79ms Average duration of sessions
- 0 Average queries per session
- 11ms Average queries duration per session
- 11s68ms Average idle time per session
- 8,584 Total number of connections
- 5 connections/s at 2025-11-13 09:12:38 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-13 07:32:48 Date
SELECT Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-13 19:43:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-13 07:32:48 Date
Queries duration
Key values
- 1m39s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 13 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 2 0ms 23s744ms 14s994ms 0ms 0ms 23s744ms 08 1 0ms 24s451ms 24s451ms 0ms 0ms 24s451ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 2 0ms 36s637ms 22s501ms 0ms 0ms 36s637ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 13 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 1 0 36s637ms 0ms 0ms 0ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Nov 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Nov 13 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 2 2.00 0.00% 08 0 1 1.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 2 2.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Nov 13 00 370 0.10/s 01 361 0.10/s 02 355 0.10/s 03 358 0.10/s 04 353 0.10/s 05 354 0.10/s 06 364 0.10/s 07 363 0.10/s 08 363 0.10/s 09 355 0.10/s 10 347 0.10/s 11 349 0.10/s 12 363 0.10/s 13 350 0.10/s 14 352 0.10/s 15 366 0.10/s 16 367 0.10/s 17 354 0.10/s 18 357 0.10/s 19 360 0.10/s 20 363 0.10/s 21 353 0.10/s 22 355 0.10/s 23 352 0.10/s Day Hour Count Average Duration Average idle time Nov 13 00 370 11s45ms 11s45ms 01 361 10s933ms 10s933ms 02 355 10s915ms 10s915ms 03 358 10s934ms 10s934ms 04 353 10s824ms 10s824ms 05 354 10s941ms 10s941ms 06 364 11s23ms 11s23ms 07 363 11s209ms 11s126ms 08 363 11s169ms 11s101ms 09 355 11s191ms 11s191ms 10 347 10s904ms 10s904ms 11 349 10s896ms 10s896ms 12 363 11s173ms 11s173ms 13 350 11s174ms 11s174ms 14 352 11s57ms 11s57ms 15 366 11s72ms 11s72ms 16 367 10s981ms 10s981ms 17 354 11s96ms 11s96ms 18 357 11s222ms 11s222ms 19 360 11s549ms 11s424ms 20 363 11s252ms 11s252ms 21 353 10s825ms 10s825ms 22 355 11s242ms 11s242ms 23 352 11s259ms 11s259ms -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2025-11-13 09:12:38 Date
Connections per database
Key values
- postgres Main Database
- 8,584 connections Total
Connections per user
Key values
- azuresu Main User
- 8,584 connections Total
-
Sessions
Simultaneous sessions
Key values
- 135 sessions Session Peak
- 2025-11-13 19:57:24 Date
Histogram of session times
Key values
- 4,362 1000-30000ms duration
Sessions per database
Key values
- postgres Main Database
- 8,584 sessions Total
Sessions per user
Key values
- azuresu Main User
- 8,584 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 8,584 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 196,977 buffers Checkpoint Peak
- 2025-11-13 09:05:31 Date
- 539.967 seconds Highest write time
- 14.510 seconds Sync time
Checkpoints Wal files
Key values
- 399 files Wal files usage Peak
- 2025-11-13 08:35:48 Date
Checkpoints distance
Key values
- 12,068.51 Mo Distance Peak
- 2025-11-13 08:35:48 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 13 00 7,215 720.492s 0.089s 720.811s 01 8,935 892.77s 0.115s 893.108s 02 6,785 677.883s 0.089s 678.202s 03 6,795 678.705s 0.089s 679.028s 04 6,777 677.192s 0.091s 677.524s 05 6,794 678.685s 0.089s 679.02s 06 6,386 637.79s 0.069s 638.086s 07 148,728 1,389.261s 3.731s 1,397.229s 08 368,745 2,269.085s 30.142s 2,381.251s 09 355,967 2,539.171s 2.452s 2,564.421s 10 111,677 1,811.764s 2.994s 1,817.064s 11 7,515 751.509s 0.111s 751.861s 12 6,814 680.586s 0.124s 680.982s 13 8,617 862.458s 0.124s 862.799s 14 143,654 1,675.814s 0.111s 1,677.598s 15 8,361 835.79s 0.112s 836.159s 16 6,742 673.393s 0.072s 673.796s 17 7,966 795.423s 0.092s 795.77s 18 5,504 550.452s 0.096s 550.806s 19 144,381 356.157s 1.531s 359.643s 20 162,600 1,573.073s 0.147s 1,575.77s 21 85,157 1,611.867s 0.092s 1,612.899s 22 5,010 500.229s 0.086s 500.559s 23 5,503 549.76s 0.048s 550.06s Day Hour Added Removed Recycled Synced files Longest sync Average sync Nov 13 00 0 12 0 1,349 0.008s 0.006s 01 0 12 0 1,477 0.008s 0.006s 02 0 12 0 1,328 0.008s 0.006s 03 0 12 0 1,318 0.009s 0.006s 04 0 12 0 1,319 0.010s 0.006s 05 0 12 0 1,325 0.008s 0.006s 06 0 12 0 1,245 0.009s 0.006s 07 0 79 699 7,012 0.506s 0.009s 08 0 0 1,469 6,129 6.551s 0.056s 09 0 6 614 3,292 0.202s 0.01s 10 0 102 191 2,671 2.142s 0.011s 11 0 12 0 1,417 0.010s 0.006s 12 0 12 0 1,400 0.010s 0.006s 13 0 10 0 1,188 0.011s 0.005s 14 0 122 172 2,465 0.009s 0.007s 15 0 12 0 1,510 0.020s 0.006s 16 0 12 0 1,365 0.009s 0.006s 17 0 12 0 1,523 0.013s 0.006s 18 0 12 0 1,143 0.011s 0.006s 19 0 8 228 3,350 0.852s 0.005s 20 0 1 585 4,087 0.011s 0.007s 21 0 8 156 2,323 0.008s 0.007s 22 0 12 0 1,002 0.008s 0.006s 23 0 12 0 1,042 0.008s 0.006s Day Hour Count Avg time (sec) Nov 13 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Nov 13 00 32,757.50 kB 486,419.33 kB 01 32,765.67 kB 273,874.83 kB 02 32,748.50 kB 160,874.50 kB 03 32,767.17 kB 100,845.67 kB 04 32,772.67 kB 68,948.83 kB 05 32,770.17 kB 52,000.33 kB 06 32,717.67 kB 42,979.17 kB 07 1,594,940.62 kB 2,923,318.12 kB 08 3,941,915.00 kB 5,149,599.83 kB 09 1,508,864.29 kB 4,561,261.43 kB 10 797,465.00 kB 3,376,960.00 kB 11 32,679.83 kB 1,957,841.83 kB 12 32,764.17 kB 1,055,800.50 kB 13 32,806.40 kB 603,009.60 kB 14 690,394.71 kB 2,295,089.00 kB 15 32,765.33 kB 1,180,282.50 kB 16 32,767.83 kB 642,601.00 kB 17 32,785.00 kB 356,863.17 kB 18 32,749.33 kB 204,978.00 kB 19 733,849.60 kB 814,314.60 kB 20 1,341,598.43 kB 3,121,317.00 kB 21 441,953.57 kB 3,597,548.71 kB 22 32,770.83 kB 1,821,484.50 kB 23 32,764.83 kB 983,364.33 kB -
Temporary Files
Size of temporary files
Key values
- 4.62 MiB Temp Files size Peak
- 2025-11-13 10:14:17 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2025-11-13 10:14:17 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Nov 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 2 4.62 MiB 2.31 MiB 11 0 0 0 12 0 0 0 13 1 2.36 MiB 2.36 MiB 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 Nov 13 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 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
- 1 Total read queries
- 4 Total write queries
Queries by database
Key values
- postgres Main database
- 5 Requests
- 1m39s (postgres)
- Main time consuming database
Queries by user
Key values
- azuresu Main user
- 5 Requests
User Request type Count Duration azuresu Total 5 1m39s ddl 4 1m2s select 1 36s637ms Duration by user
Key values
- 1m39s (azuresu) Main time consuming user
User Request type Count Duration azuresu Total 5 1m39s ddl 4 1m2s select 1 36s637ms Queries by host
Key values
- 169.254.128.1 Main host
- 5 Requests
- 1m39s (169.254.128.1)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5 Requests
- 1m39s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-13 15:27:32 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3 > 10000ms duration
Slowest individual queries
Rank Duration Query 1 36s637ms SELECT pg_catalog.pg_backup_start (, true);[ Date: 2025-11-13 19:43:50 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
2 24s451ms DROP DATABASE IF EXISTS "autotest_feat_batch";[ Date: 2025-11-13 08:16:33 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
3 23s744ms DROP DATABASE IF EXISTS "autotest";[ Date: 2025-11-13 07:32:48 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
4 8s365ms DROP DATABASE IF EXISTS "autotest_feat_batch";[ Date: 2025-11-13 19:36:16 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
5 6s245ms DROP DATABASE IF EXISTS "cnrs";[ Date: 2025-11-13 07:54:36 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 36s637ms 1 36s637ms 36s637ms 36s637ms select pg_catalog.pg_backup_start (, true);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 20 1 36s637ms 36s637ms [ User: azuresu - Total duration: 36s637ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 36s637ms - Times executed: 1 ]
-
SELECT pg_catalog.pg_backup_start (, true);
Date: 2025-11-13 19:43:50 Duration: 36s637ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 32s816ms 2 8s365ms 24s451ms 16s408ms drop database if exists "autotest_feat_batch";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 09 1 24s451ms 24s451ms 20 1 8s365ms 8s365ms [ User: azuresu - Total duration: 32s816ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 32s816ms - Times executed: 2 ]
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 08:16:33 Duration: 24s451ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 19:36:16 Duration: 8s365ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 23s744ms 1 23s744ms 23s744ms 23s744ms drop database if exists "autotest";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 08 1 23s744ms 23s744ms [ User: azuresu - Total duration: 23s744ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 23s744ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-13 07:32:48 Duration: 23s744ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 6s245ms 1 6s245ms 6s245ms 6s245ms drop database if exists "cnrs";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 08 1 6s245ms 6s245ms [ User: azuresu - Total duration: 6s245ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 6s245ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-13 07:54:36 Duration: 6s245ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2 32s816ms 8s365ms 24s451ms 16s408ms drop database if exists "autotest_feat_batch";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 09 1 24s451ms 24s451ms 20 1 8s365ms 8s365ms [ User: azuresu - Total duration: 32s816ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 32s816ms - Times executed: 2 ]
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 08:16:33 Duration: 24s451ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 19:36:16 Duration: 8s365ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 1 36s637ms 36s637ms 36s637ms 36s637ms select pg_catalog.pg_backup_start (, true);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 20 1 36s637ms 36s637ms [ User: azuresu - Total duration: 36s637ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 36s637ms - Times executed: 1 ]
-
SELECT pg_catalog.pg_backup_start (, true);
Date: 2025-11-13 19:43:50 Duration: 36s637ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 1 23s744ms 23s744ms 23s744ms 23s744ms drop database if exists "autotest";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 08 1 23s744ms 23s744ms [ User: azuresu - Total duration: 23s744ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 23s744ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-13 07:32:48 Duration: 23s744ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 1 6s245ms 6s245ms 6s245ms 6s245ms drop database if exists "cnrs";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 08 1 6s245ms 6s245ms [ User: azuresu - Total duration: 6s245ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 6s245ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-13 07:54:36 Duration: 6s245ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 36s637ms 36s637ms 36s637ms 1 36s637ms select pg_catalog.pg_backup_start (, true);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 13 20 1 36s637ms 36s637ms [ User: azuresu - Total duration: 36s637ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 36s637ms - Times executed: 1 ]
-
SELECT pg_catalog.pg_backup_start (, true);
Date: 2025-11-13 19:43:50 Duration: 36s637ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 23s744ms 23s744ms 23s744ms 1 23s744ms drop database if exists "autotest";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 13 08 1 23s744ms 23s744ms [ User: azuresu - Total duration: 23s744ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 23s744ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-13 07:32:48 Duration: 23s744ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 8s365ms 24s451ms 16s408ms 2 32s816ms drop database if exists "autotest_feat_batch";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 13 09 1 24s451ms 24s451ms 20 1 8s365ms 8s365ms [ User: azuresu - Total duration: 32s816ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 32s816ms - Times executed: 2 ]
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 08:16:33 Duration: 24s451ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
-
DROP DATABASE IF EXISTS "autotest_feat_batch";
Date: 2025-11-13 19:36:16 Duration: 8s365ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 6s245ms 6s245ms 6s245ms 1 6s245ms drop database if exists "cnrs";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 13 08 1 6s245ms 6s245ms [ User: azuresu - Total duration: 6s245ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 6s245ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-13 07:54:36 Duration: 6s245ms Database: postgres 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 NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 48,337 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 22 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 15 Max number of times the same event was reported
- 22 Total events found
Rank Times reported Error 1 15 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 13 08 1 09 6 20 4 21 4 2 5 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 13 09 3 10 1 20 1 3 1 LOG: still waiting for backend with to accept ProcSignalBarrierDROP DATABASE IF EXISTS"..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 13 20 1 4 1 ERROR: canceling statement due to user requestDROP DATABASE IF EXISTS"..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Nov 13 09 1