pgBadger-
Global information
- Generated on Wed Nov 12 09:05:42 2025
- Log file: ././A3D-RND-PIC/y=2025/m=11/d=11/h=00/m=00/PT1H.log, ..., ././A3D-RND-PIC/y=2025/m=11/d=11/h=23/m=00/PT1H.log
- Parsed 174,201 log entries in 56s
- Log start from 2025-11-11 00:00:00 to 2025-11-11 23:59:59
-
Overview
Global Stats
- 4 Number of unique normalized queries
- 4 Number of queries
- 43s378ms Total query duration
- 2025-11-11 07:16:03 First query
- 2025-11-11 20:25:25 Last query
- 1 queries/s at 2025-11-11 07:16:03 Query peak
- 43s378ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 43s378ms Execute total duration
- 10 Number of events
- 3 Number of unique normalized events
- 5 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
- 8,629 Total number of sessions
- 126 sessions at 2025-11-11 18:58:46 Session peak
- 1d2h40m12s Total duration of sessions
- 11s126ms Average duration of sessions
- 0 Average queries per session
- 5ms Average queries duration per session
- 11s121ms Average idle time per session
- 8,631 Total number of connections
- 4 connections/s at 2025-11-11 09:57:04 Connection peak
- 1 Total number of databases
SQL Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-11 07:16:03 Date
SELECT Traffic
Key values
- 0 queries/s Query Peak
- Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2025-11-11 07:16:03 Date
Queries duration
Key values
- 43s378ms 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 11 00 0 0ms 0ms 0ms 0ms 0ms 0ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 0 0ms 0ms 0ms 0ms 0ms 0ms 04 0 0ms 0ms 0ms 0ms 0ms 0ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 3 0ms 14s899ms 12s96ms 0ms 10s5ms 14s899ms 08 0 0ms 0ms 0ms 0ms 0ms 0ms 09 0 0ms 0ms 0ms 0ms 0ms 0ms 10 0 0ms 0ms 0ms 0ms 0ms 0ms 11 0 0ms 0ms 0ms 0ms 0ms 0ms 12 0 0ms 0ms 0ms 0ms 0ms 0ms 13 0 0ms 0ms 0ms 0ms 0ms 0ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 0 0ms 0ms 0ms 0ms 0ms 0ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 0 0ms 0ms 0ms 0ms 0ms 0ms 18 0 0ms 0ms 0ms 0ms 0ms 0ms 19 0 0ms 0ms 0ms 0ms 0ms 0ms 20 1 0ms 7s89ms 7s89ms 0ms 0ms 7s89ms 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 11 00 0 0 0ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 0 0 0ms 0ms 0ms 0ms 09 0 0 0ms 0ms 0ms 0ms 10 0 0 0ms 0ms 0ms 0ms 11 0 0 0ms 0ms 0ms 0ms 12 0 0 0ms 0ms 0ms 0ms 13 0 0 0ms 0ms 0ms 0ms 14 0 0 0ms 0ms 0ms 0ms 15 0 0 0ms 0ms 0ms 0ms 16 0 0 0ms 0ms 0ms 0ms 17 0 0 0ms 0ms 0ms 0ms 18 0 0 0ms 0ms 0ms 0ms 19 0 0 0ms 0ms 0ms 0ms 20 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 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 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 11 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 3 3.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.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 11 00 384 0.11/s 01 357 0.10/s 02 347 0.10/s 03 353 0.10/s 04 363 0.10/s 05 361 0.10/s 06 358 0.10/s 07 356 0.10/s 08 359 0.10/s 09 361 0.10/s 10 363 0.10/s 11 367 0.10/s 12 354 0.10/s 13 356 0.10/s 14 363 0.10/s 15 360 0.10/s 16 356 0.10/s 17 363 0.10/s 18 354 0.10/s 19 375 0.10/s 20 357 0.10/s 21 354 0.10/s 22 359 0.10/s 23 351 0.10/s Day Hour Count Average Duration Average idle time Nov 11 00 384 11s437ms 11s437ms 01 357 11s350ms 11s350ms 02 347 10s926ms 10s926ms 03 353 11s78ms 11s78ms 04 363 11s109ms 11s109ms 05 361 11s275ms 11s275ms 06 358 11s108ms 11s108ms 07 355 11s24ms 10s922ms 08 359 11s158ms 11s158ms 09 361 10s985ms 10s985ms 10 363 11s150ms 11s150ms 11 367 11s273ms 11s273ms 12 354 11s175ms 11s175ms 13 356 11s78ms 11s78ms 14 362 11s101ms 11s101ms 15 361 11s105ms 11s105ms 16 356 10s887ms 10s887ms 17 363 11s268ms 11s268ms 18 353 10s996ms 10s996ms 19 376 11s440ms 11s440ms 20 356 11s88ms 11s68ms 21 354 11s129ms 11s129ms 22 358 10s985ms 10s985ms 23 352 10s846ms 10s846ms -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2025-11-11 09:57:04 Date
Connections per database
Key values
- postgres Main Database
- 8,631 connections Total
Connections per user
Key values
- azuresu Main User
- 8,631 connections Total
-
Sessions
Simultaneous sessions
Key values
- 126 sessions Session Peak
- 2025-11-11 18:58:46 Date
Histogram of session times
Key values
- 4,379 1000-30000ms duration
Sessions per database
Key values
- postgres Main Database
- 8,629 sessions Total
Sessions per user
Key values
- azuresu Main User
- 8,629 sessions Total
Sessions per host
Key values
- 169.254.128.1 Main Host
- 8,629 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 177,048 buffers Checkpoint Peak
- 2025-11-11 08:52:16 Date
- 540.518 seconds Highest write time
- 19.998 seconds Sync time
Checkpoints Wal files
Key values
- 319 files Wal files usage Peak
- 2025-11-11 07:53:01 Date
Checkpoints distance
Key values
- 9,407.26 Mo Distance Peak
- 2025-11-11 07:53:01 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Nov 11 00 7,451 744.518s 0.064s 744.822s 01 8,717 871.236s 0.175s 871.65s 02 6,888 687.72s 0.063s 688.055s 03 6,757 674.96s 0.063s 675.256s 04 6,690 667.868s 0.078s 668.164s 05 6,666 665.607s 0.08s 665.918s 06 9,659 965.462s 0.066s 965.749s 07 125,643 1,135.465s 1.588s 1,143.257s 08 271,150 2,696.15s 32.133s 2,763.986s 09 157,122 1,655.982s 0.207s 1,657.967s 10 7,776 777.641s 0.071s 777.949s 11 8,667 866.587s 0.061s 866.875s 12 6,846 684.032s 0.119s 684.401s 13 7,034 702.427s 0.08s 702.74s 14 7,044 703.66s 0.086s 703.983s 15 7,505 750.043s 0.125s 750.401s 16 7,141 714.368s 0.171s 714.773s 17 7,396 739.2s 0.172s 739.599s 18 4,931 492.519s 0.09s 492.851s 19 9,951 950.35s 0.167s 950.776s 20 51,430 1,400.098s 0.784s 1,409.143s 21 54,608 1,363.499s 0.087s 1,363.819s 22 6,752 674.474s 0.093s 674.811s 23 7,122 711.741s 0.074s 712.135s Day Hour Added Removed Recycled Synced files Longest sync Average sync Nov 11 00 0 12 0 1,376 0.009s 0.006s 01 0 12 0 1,500 0.012s 0.006s 02 0 12 0 1,284 0.007s 0.006s 03 0 12 0 1,298 0.008s 0.006s 04 0 12 0 1,304 0.007s 0.006s 05 0 12 0 1,261 0.010s 0.006s 06 0 12 0 1,272 0.010s 0.006s 07 0 93 669 5,836 0.242s 0.009s 08 0 0 1,226 5,071 6.349s 0.063s 09 0 8 329 2,233 0.069s 0.007s 10 0 12 0 1,287 0.016s 0.006s 11 0 12 0 1,289 0.013s 0.006s 12 0 12 0 1,294 0.014s 0.006s 13 0 12 0 1,285 0.010s 0.006s 14 0 12 0 1,334 0.008s 0.006s 15 0 12 0 1,311 0.009s 0.006s 16 0 12 0 1,295 0.009s 0.006s 17 0 12 0 1,307 0.010s 0.006s 18 0 12 0 951 0.007s 0.007s 19 0 13 0 1,227 0.048s 0.006s 20 0 7 461 3,802 0.147s 0.006s 21 0 10 3 2,045 0.011s 0.007s 22 0 12 0 1,300 0.013s 0.006s 23 0 12 0 1,312 0.008s 0.006s Day Hour Count Avg time (sec) Nov 11 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 11 00 32,738.50 kB 506,678.00 kB 01 32,764.17 kB 284,630.67 kB 02 32,768.83 kB 166,597.67 kB 03 32,775.83 kB 103,897.50 kB 04 32,759.50 kB 70,562.00 kB 05 32,769.00 kB 52,854.33 kB 06 32,878.33 kB 43,572.67 kB 07 1,560,563.75 kB 2,453,512.75 kB 08 3,935,303.40 kB 4,295,151.60 kB 09 847,273.57 kB 3,283,887.14 kB 10 32,773.00 kB 1,684,052.67 kB 11 32,765.17 kB 910,329.50 kB 12 32,764.00 kB 499,138.17 kB 13 32,781.67 kB 280,616.67 kB 14 32,751.00 kB 164,482.33 kB 15 32,766.83 kB 102,766.00 kB 16 32,766.17 kB 69,967.33 kB 17 32,767.33 kB 52,536.67 kB 18 32,770.50 kB 43,265.33 kB 19 32,946.67 kB 39,311.00 kB 20 1,233,423.00 kB 1,530,515.67 kB 21 70,799.29 kB 2,995,127.57 kB 22 32,760.33 kB 1,517,406.67 kB 23 32,773.33 kB 821,767.00 kB -
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 Nov 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 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 Nov 11 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 0 0 - 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
- 0 Total read queries
- 4 Total write queries
Queries by database
Key values
- postgres Main database
- 4 Requests
- 43s378ms (postgres)
- Main time consuming database
Queries by user
Key values
- azuresu Main user
- 4 Requests
User Request type Count Duration azuresu Total 4 43s378ms ddl 4 43s378ms Duration by user
Key values
- 43s378ms (azuresu) Main time consuming user
User Request type Count Duration azuresu Total 4 43s378ms ddl 4 43s378ms Queries by host
Key values
- 169.254.128.1 Main host
- 4 Requests
- 43s378ms (169.254.128.1)
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4 Requests
- 43s378ms ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-11-11 18:17:31 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 14s899ms DROP DATABASE IF EXISTS "autotest";[ Date: 2025-11-11 07:38:45 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
2 11s382ms DROP DATABASE IF EXISTS "cnrs";[ Date: 2025-11-11 07:53:11 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
3 10s5ms DROP DATABASE IF EXISTS "reftk";[ Date: 2025-11-11 07:16:03 - Database: postgres - User: azuresu - Remote: 169.254.128.1 - Application: [unknown] - Bind query: yes ]
4 7s89ms DROP DATABASE IF EXISTS "autotest_api_batch";[ Date: 2025-11-11 20:25:25 - 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 14s899ms 1 14s899ms 14s899ms 14s899ms drop database if exists "autotest";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 08 1 14s899ms 14s899ms [ User: azuresu - Total duration: 14s899ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 14s899ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-11 07:38:45 Duration: 14s899ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 11s382ms 1 11s382ms 11s382ms 11s382ms drop database if exists "cnrs";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 08 1 11s382ms 11s382ms [ User: azuresu - Total duration: 11s382ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 11s382ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-11 07:53:11 Duration: 11s382ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 10s5ms 1 10s5ms 10s5ms 10s5ms drop database if exists "reftk";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 08 1 10s5ms 10s5ms [ User: azuresu - Total duration: 10s5ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 10s5ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "reftk";
Date: 2025-11-11 07:16:03 Duration: 10s5ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 7s89ms 1 7s89ms 7s89ms 7s89ms drop database if exists "autotest_api_batch";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 11 21 1 7s89ms 7s89ms [ User: azuresu - Total duration: 7s89ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 7s89ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest_api_batch";
Date: 2025-11-11 20:25:25 Duration: 7s89ms 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 1 14s899ms 14s899ms 14s899ms 14s899ms drop database if exists "autotest";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 08 1 14s899ms 14s899ms [ User: azuresu - Total duration: 14s899ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 14s899ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-11 07:38:45 Duration: 14s899ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 1 11s382ms 11s382ms 11s382ms 11s382ms drop database if exists "cnrs";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 08 1 11s382ms 11s382ms [ User: azuresu - Total duration: 11s382ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 11s382ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-11 07:53:11 Duration: 11s382ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 1 10s5ms 10s5ms 10s5ms 10s5ms drop database if exists "reftk";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 08 1 10s5ms 10s5ms [ User: azuresu - Total duration: 10s5ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 10s5ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "reftk";
Date: 2025-11-11 07:16:03 Duration: 10s5ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 1 7s89ms 7s89ms 7s89ms 7s89ms drop database if exists "autotest_api_batch";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 11 21 1 7s89ms 7s89ms [ User: azuresu - Total duration: 7s89ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 7s89ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest_api_batch";
Date: 2025-11-11 20:25:25 Duration: 7s89ms 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 14s899ms 14s899ms 14s899ms 1 14s899ms drop database if exists "autotest";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Nov 11 08 1 14s899ms 14s899ms [ User: azuresu - Total duration: 14s899ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 14s899ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest";
Date: 2025-11-11 07:38:45 Duration: 14s899ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
2 11s382ms 11s382ms 11s382ms 1 11s382ms drop database if exists "cnrs";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Nov 11 08 1 11s382ms 11s382ms [ User: azuresu - Total duration: 11s382ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 11s382ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "cnrs";
Date: 2025-11-11 07:53:11 Duration: 11s382ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
3 10s5ms 10s5ms 10s5ms 1 10s5ms drop database if exists "reftk";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Nov 11 08 1 10s5ms 10s5ms [ User: azuresu - Total duration: 10s5ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 10s5ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "reftk";
Date: 2025-11-11 07:16:03 Duration: 10s5ms Database: postgres User: azuresu Remote: 169.254.128.1 Application: [unknown] Bind query: yes
4 7s89ms 7s89ms 7s89ms 1 7s89ms drop database if exists "autotest_api_batch";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Nov 11 21 1 7s89ms 7s89ms [ User: azuresu - Total duration: 7s89ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 7s89ms - Times executed: 1 ]
-
DROP DATABASE IF EXISTS "autotest_api_batch";
Date: 2025-11-11 20:25:25 Duration: 7s89ms 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,418 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 10 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 5 Max number of times the same event was reported
- 10 Total events found
Rank Times reported Error 1 5 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #1
Day Hour Count Nov 11 08 1 09 4 2 3 LOG: still waiting for backend with to accept ProcSignalBarrierDROP DATABASE IF EXISTS"..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Nov 11 08 2 21 1 3 2 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #3
Day Hour Count Nov 11 09 2