-
Global information
- Generated on Sat Apr 2 03:00:04 2022
- Log file: /var/log/postgresql/postgresql-12-main.log
- Parsed 13 log entries in 2s
- Log start from 2022-04-01 10:02:03 to 2022-04-01 10:02:03
-
Global Stats
- 0 Number of unique normalized queries
- 0 Number of queries
- 0ms Total query duration
- - First query
- - Last query
- 0 queries/s at Query peak
- 0ms Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 0ms 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
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 0 Average queries per session
- 0ms Average queries duration per session
- 0 Total number of connections
- 0 Total number of databases
INSERT/UPDATE/DELETE Traffic
General Activity
| Day |
Hour |
Count |
Min duration |
Max duration |
Avg duration |
Latency Percentile(90) |
Latency Percentile(95) |
Latency Percentile(99) |
| Apr 01 |
10 |
0 |
0ms |
0ms |
0ms |
0ms |
0ms |
0ms |
| Day |
Hour |
SELECT |
COPY TO |
Average Duration |
Latency Percentile(90) |
Latency Percentile(95) |
Latency Percentile(99) |
| Apr 01 |
10 |
0 |
0 |
0ms |
0ms |
0ms |
0ms |
| Day |
Hour |
INSERT |
UPDATE |
DELETE |
COPY FROM |
Average Duration |
Latency Percentile(90) |
Latency Percentile(95) |
Latency Percentile(99) |
| Apr 01 |
10 |
0 |
0 |
0 |
0 |
0ms | 0ms |
0ms |
0ms |
| Day |
Hour |
Prepare |
Bind |
Bind/Prepare |
Percentage of prepare |
| Apr 01 |
10 |
0 |
0 |
0.00 |
0.00% |
| Day |
Hour |
Count |
Average / Second |
| Apr 01 |
10 |
0 |
0.00/s |
| Day |
Hour |
Count |
Average Duration |
| Apr 01 |
10 |
0 |
0ms |
↑ Back to the top of the General Activity table
-
-
Histogram of session times
Sessions per database
| Database |
User |
Count |
Total Duration |
Average Duration |
|
Sessions per user
| User |
Count |
Total Duration |
Average Duration |
|
Sessions per host
| Host |
Count |
Total Duration |
Average Duration |
|
Sessions per application
| Application |
Count |
Total Duration |
Average Duration |
|
-
Checkpoints Buffers
Checkpoint write buffers (5 minutes period)
Checkpoints Wal files
Checkpoint Wal files usage (5 minutes period)
Checkpoints Activity
| Day |
Hour |
Written buffers |
Write time |
Sync time |
Total time |
| Apr 01 | 10 | 0 | 0s | 0s | 0s |
| Day |
Hour |
Added |
Removed |
Recycled |
Synced files |
Longest sync |
Average sync |
| Apr 01 | 10 | 0 | 0 | 0 | 0 | 0s | 0s |
| Day |
Hour |
Count |
Avg time (sec) |
| Apr 01 | 10 | 0 | 0s |
| Day |
Hour |
Mean distance |
Mean estimate |
| Apr 01 | 10 | 0.00 kB | 0.00 kB |
↑ Back to the top of the Checkpoint Activity table
-
Size of temporary files
Size of temporary files (5 minutes period)
Number of temporary files
Number of temporary files (5 minutes period)
-
Vacuums / Analyzes Distribution
Autovacuum actions (5 minutes period)
Vacuums per table
| Table |
Number of vacuums |
Index scans |
|
Tuples removed per table
Tuples removed per tables
| Table |
Number of vacuums |
Index scans |
Tuples removed |
Pages removed |
|
Pages removed per table
| Table |
Number of vacuums |
Index scans |
Tuples removed |
Pages removed |
|
-
Locks by types
| Type |
Object |
Count |
Total Duration |
Average Duration (s) |
|
Most frequent waiting queries (N)
| Rank |
Count |
Total time |
Min time |
Max time |
Avg duration |
Query |
|
Queries that waited the most
-
Queries by database
| Database |
Request type |
Count |
Duration |
|
Queries by user
| User |
Request type |
Count |
Duration |
|
Duration by user
| User |
Request type |
Count |
Duration |
|
Queries by host
| Host |
Request type |
Count |
Duration |
|
Queries by application
| Application |
Request type |
Count |
Duration |
|
Number of cancelled queries
Number of cancelled queries (5 minutes period)
-
Slowest individual queries
Time consuming queries
| Rank |
Total duration |
Times executed |
Min duration |
Max duration |
Avg duration |
Query |
|
Most frequent queries (N)
| Rank |
Times executed |
Total duration |
Min duration |
Max duration |
Avg duration |
Query |
|
Normalized slowest queries (N)
| Rank |
Min duration |
Max duration |
Avg duration |
Times executed |
Total duration |
Query |
|
Time consuming prepare
| Rank |
Total duration |
Times executed |
Min duration |
Max duration |
Avg duration |
Query |
|
Time consuming bind
| Rank |
Total duration |
Times executed |
Min duration |
Max duration |
Avg duration |
Query |
|
-
Log levels
| Type |
Count |
Percentage |
| HINT | 1 | 16.67% |
| LOG | 5 | 83.33% |
Most Frequent Errors/Events
| Rank |
Times reported |
Error |
|
pgBadger