pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jul 15 23:00:05 2026
Log file: /var/log/postgresql/postgresql-10-main.log
Parsed 185,588 log entries in 4s
Log start from 2026-07-15 07:00:01 to 2026-07-15 21:59:58

Global Stats

1 Number of unique normalized queries
2 Number of queries
2s45ms Total query duration
2026-07-15 08:00:03 First query
2026-07-15 14:00:02 Last query
1 queries/s at 2026-07-15 08:00:03 Query peak

2,880 Number of events
1 Number of unique normalized events
2,880 Max number of times the same event was reported
0 Number of cancellation

48 Total number of automatic vacuums
60 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

7,575 Total number of sessions
4 sessions at 2026-07-15 19:00:01 Session peak
1m14s Total duration of sessions
9ms Average duration of sessions
0 Average queries per session
0ms Average queries duration per session

10,457 Total number of connections
11 connections/s at 2026-07-15 10:25:05 Connection peak
1 Total number of databases

SQL Traffic

Key values

1 queries/s Query Peak
2026-07-15 08:00:03 Date

SELECT Traffic

Key values

1 queries/s Query Peak
2026-07-15 08:00:03 Date

INSERT/UPDATE/DELETE Traffic

Key values

0 queries/s Query Peak
Date

Queries duration

Key values

2s45ms 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

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 15	07	0	0ms	0ms	0ms	0ms	0ms	0ms
	08	1	0ms	1s31ms	1s31ms	0ms	0ms	1s31ms
	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	1	0ms	1s14ms	1s14ms	0ms	0ms	1s14ms
	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	0	0ms	0ms	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms	0ms	0ms

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 15	07	0	0ms	0ms	0ms	0ms
	08	1	1s31ms	0ms	0ms	0ms
	09	0	0ms	0ms	0ms	0ms
	10	0	0ms	0ms	0ms	0ms
	11	0	0ms	0ms	0ms	0ms
	12	0	0ms	0ms	0ms	0ms
	13	0	0ms	0ms	0ms	0ms
	14	1	1s14ms	0ms	0ms	0ms
	15	0	0ms	0ms	0ms	0ms
	16	0	0ms	0ms	0ms	0ms
	17	0	0ms	0ms	0ms	0ms
	18	0	0ms	0ms	0ms	0ms
	19	0	0ms	0ms	0ms	0ms
	20	0	0ms	0ms	0ms	0ms
	21	0	0ms	0ms	0ms	0ms

Day	Hour	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jul 15	07	0ms	0ms	0ms	0ms
	08	0ms	0ms	0ms	0ms
	09	0ms	0ms	0ms	0ms
	10	0ms	0ms	0ms	0ms
	11	0ms	0ms	0ms	0ms
	12	0ms	0ms	0ms	0ms
	13	0ms	0ms	0ms	0ms
	14	0ms	0ms	0ms	0ms
	15	0ms	0ms	0ms	0ms
	16	0ms	0ms	0ms	0ms
	17	0ms	0ms	0ms	0ms
	18	0ms	0ms	0ms	0ms
	19	0ms	0ms	0ms	0ms
	20	0ms	0ms	0ms	0ms
	21	0ms	0ms	0ms	0ms

Day	Hour	Percentage of prepare
Jul 15	07	0.00%
	08	0.00%
	09	0.00%
	10	0.00%
	11	0.00%
	12	0.00%
	13	0.00%
	14	0.00%
	15	0.00%
	16	0.00%
	17	0.00%
	18	0.00%
	19	0.00%
	20	0.00%
	21	0.00%

Day	Hour	Count	Average / Second
Jul 15	07	698	0.19/s
	08	697	0.19/s
	09	697	0.19/s
	10	697	0.19/s
	11	697	0.19/s
	12	697	0.19/s
	13	698	0.19/s
	14	697	0.19/s
	15	697	0.19/s
	16	697	0.19/s
	17	697	0.19/s
	18	697	0.19/s
	19	697	0.19/s
	20	697	0.19/s
	21	697	0.19/s

Day	Hour	Count	Average Duration
Jul 15	07	505	10ms
	08	505	10ms
	09	505	9ms
	10	505	9ms
	11	505	9ms
	12	505	9ms
	13	505	9ms
	14	505	10ms
	15	505	9ms
	16	505	9ms
	17	505	9ms
	18	505	9ms
	19	505	9ms
	20	505	9ms
	21	505	9ms

↑ Back to the top of the General Activity table

Established Connections

Key values

11 connections Connection Peak
2026-07-15 10:25:05 Date

Connections per database

Key values

etendo Main Database
10,457 connections Total

Chart
Table

Database	User	Count
etendo		3,242
	postgres	60
	tad	3,182
openbravo		2,880
	postgres	2,880
postgres		2,175
	postgres	2,175
template1		2,160
	postgres	2,160

Connections per user

Key values

postgres Main User
10,457 connections Total

Chart
Table

User	Count
postgres	7,275
tad	3,182

Connections per host

Key values

[local] Main host with 7275 connections
10,457 Total connections

Chart
Table

Host	Count
127.0.0.1	2
::1	3,180
[local]	7,275

Simultaneous sessions

Key values

4 sessions Session Peak
2026-07-15 19:00:01 Date

Histogram of session times

Key values

7,545 0-500ms duration

Chart
Table

Range	Count	Percentage
0ms-500ms	7,545	99.60%
500ms-1s	28	0.37%
1s-30s	2	0.03%
30s-1m	0	0.00%
1m-10m	0	0.00%
10m-30m	0	0.00%
30m-1h	0	0.00%
1h-8h	0	0.00%
> 8h	0	0.00%

Sessions per database

Key values

etendo Main Database
7,575 sessions Total

Chart
Table

Database	User	Count	Total Duration
etendo	3,240	52s647ms	16ms
postgres	2,175	12s243ms	5ms
template1	2,160	9s929ms	4ms

Sessions per user

Key values

postgres Main User
7,575 sessions Total

Chart
Table

User	Count	Total Duration	Average Duration
postgres	4,395	53s80ms
tad	3,180	21s739ms

Sessions per host

Key values

[local] Main Host
7,575 sessions Total

Chart
Table

Host	Count	Total Duration	Average Duration
::1	3,180	21s739ms	6ms
[local]	4,395	53s80ms	12ms

Sessions per application

Key values

[unknown] Main Host
7,575 sessions Total

Chart
Table

Application	Count	Total Duration	Average Duration
[unknown]	4,350	28s796ms	6ms
pg_profile	15	9s637ms	642ms
psql	3,210	36s386ms	11ms

Checkpoints Buffers

Key values

0 buffers Checkpoint Peak
Date
seconds Highest write time
seconds Sync time

Checkpoint write buffers (5 minutes period)

NO DATASET

Checkpoints Wal files

Key values

0 files Wal files usage Peak
Date

Checkpoint Wal files usage (5 minutes period)

NO DATASET

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

NO DATASET

Checkpoints Activity

Day	Hour	Write time	Sync time	Total time
Jul 15	07	0s	0s	0s
	08	0s	0s	0s
	09	0s	0s	0s
	10	0s	0s	0s
	11	0s	0s	0s
	12	0s	0s	0s
	13	0s	0s	0s
	14	0s	0s	0s
	15	0s	0s	0s
	16	0s	0s	0s
	17	0s	0s	0s
	18	0s	0s	0s
	19	0s	0s	0s
	20	0s	0s	0s
	21	0s	0s	0s

Day	Hour	Longest sync	Average sync
Jul 15	07	0s	0s
	08	0s	0s
	09	0s	0s
	10	0s	0s
	11	0s	0s
	12	0s	0s
	13	0s	0s
	14	0s	0s
	15	0s	0s
	16	0s	0s
	17	0s	0s
	18	0s	0s
	19	0s	0s
	20	0s	0s
	21	0s	0s

Day	Hour	Avg time (sec)
Jul 15	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s

Day	Hour	Mean distance	Mean estimate
Jul 15	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

↑ Back to the top of the Checkpoint Activity table

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

Temp Files

Day	Hour	Count	Total size	Average size
Jul 15	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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Analyzes per table

Key values

profile.last_stat_tables (15) Main table analyzed (database etendo)
60 analyzes Total

Chart
Table

Table	Number of analyzes
etendo.profile.last_stat_tables	15
etendo.profile.last_stat_indexes	15
etendo.profile.last_stat_user_functions	15
etendo.profile.last_stat_database	2
etendo.profile.sample_stat_indexes	2
etendo.profile.sample_statements	2
etendo.profile.sample_stat_user_functions	2
etendo.profile.sample_stat_tables	2
etendo.profile.sample_stat_database	1
etendo.profile.sample_stat_indexes_total	1
etendo.profile.sample_statements_total	1
etendo.public.ad_session	1
etendo.profile.sample_stat_tables_total	1
Total	60

Vacuums per table

Key values

profile.last_stat_user_functions (15) Main table vacuumed on database etendo
48 vacuums Total

Chart
Table

Table	Number of vacuums	Index scans
etendo.profile.last_stat_user_functions	15	0
etendo.profile.last_stat_indexes	15	15
etendo.profile.last_stat_tables	15	15
etendo.pg_toast.pg_toast_2619	1	1
etendo.pg_catalog.pg_statistic	1	1
etendo.profile.last_stat_database	1	1
Total	48	33

Tuples removed per table

Key values

profile.last_stat_indexes (36406) Main table with removed tuples on database etendo
64498 tuples Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.profile.last_stat_indexes	15	15	36406	0
etendo.profile.last_stat_tables	15	15	23104	36
etendo.profile.last_stat_user_functions	15	0	4058	8
etendo.pg_catalog.pg_statistic	1	1	721	0
etendo.pg_toast.pg_toast_2619	1	1	197	0
etendo.profile.last_stat_database	1	1	12	0
Total	48	33	64,498	44

Pages removed per table

Key values

profile.last_stat_tables (36) Main table with removed pages on database etendo
44 pages Total removed

Chart
Table

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
etendo.profile.last_stat_tables	15	15	23104	36
etendo.profile.last_stat_user_functions	15	0	4058	8
etendo.pg_toast.pg_toast_2619	1	1	197	0
etendo.pg_catalog.pg_statistic	1	1	721	0
etendo.profile.last_stat_indexes	15	15	36406	0
etendo.profile.last_stat_database	1	1	12	0
Total	48	33	64,498	44

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jul 15	07	3	3
	08	3	3
	09	3	4
	10	3	3
	11	3	4
	12	3	7
	13	4	3
	14	3	4
	15	4	3
	16	3	4
	17	4	3
	18	3	5
	19	3	4
	20	3	4
	21	3	6

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

NO DATASET

Type	Object	Count	Total Duration	Average Duration (s)
NO DATASET

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 by type

Key values

2 Total read queries
0 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	2	100.00%
INSERT	0	0.00%
UPDATE	0	0.00%
DELETE	0	0.00%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	0	0.00%
DDL	0	0.00%
TCL	0	0.00%

Queries by database

Key values

etendo Main database
2 Requests
2s45ms (etendo)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
etendo	Total	2	2s45ms
	SELECT	2	2s45ms

Queries by user

Key values

postgres Main user
2 Requests

Queries Chart
Table

User	Request type	Count	Duration
postgres	Total	2	2s45ms
	SELECT	2	2s45ms

Duration by user

Key values

2s45ms (postgres) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
postgres	Total	2	2s45ms
	SELECT	2	2s45ms

Queries by host

Key values

[local] Main host
2 Requests
2s45ms ([local])
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
[local]	Total	2	2s45ms
	SELECT	2	2s45ms

Queries by application

Key values

psql Main application
2 Requests
2s45ms (psql)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
psql	Total	2	2s45ms
	SELECT	2	2s45ms

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2026-07-15 16:40:55 Date

Number of cancelled queries (5 minutes period)

NO DATASET

Top Queries

Histogram of query times

Key values

2 1000-10000ms duration

Chart
Table

Range	Count	Percentage
0-1ms	0	0.00%
1-5ms	0	0.00%
5-10ms	0	0.00%
10-25ms	0	0.00%
25-50ms	0	0.00%
50-100ms	0	0.00%
100-500ms	0	0.00%
500-1000ms	0	0.00%
1000-10000ms	2	100.00%
> 10000ms	0	0.00%

Slowest individual queries

Rank	Duration	Query
1	1s31ms	SELECT profile.take_sample (); [ Date: 2026-07-15 08:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]
2	1s14ms	SELECT profile.take_sample (); [ Date: 2026-07-15 14:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Rank

Duration

Query

1

1s31ms

SELECT profile.take_sample ();

[ Date: 2026-07-15 08:00:03 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

2

1s14ms

SELECT profile.take_sample ();

[ Date: 2026-07-15 14:00:02 - Database: etendo - User: postgres - Remote: [local] - Application: psql ]

Time consuming queries

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2s45ms

2

Details

1s14ms

1s31ms

1s22ms

SELECT profile.take_sample ();

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 15	08	1	1s31ms	1s31ms
	14	1	1s14ms	1s14ms

[ User: postgres - Total duration: 2s45ms - Times executed: 2 ]

[ Application: psql - Total duration: 2s45ms - Times executed: 2 ]

SELECT profile.take_sample ();
SELECT profile.take_sample ();

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2

Details

2s45ms

1s14ms

1s31ms

1s22ms

SELECT profile.take_sample ();

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 15	08	1	1s31ms	1s31ms
	14	1	1s14ms	1s14ms

[ User: postgres - Total duration: 2s45ms - Times executed: 2 ]

[ Application: psql - Total duration: 2s45ms - Times executed: 2 ]

SELECT profile.take_sample ();
SELECT profile.take_sample ();

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

1s14ms

1s31ms

1s22ms

2

Details

2s45ms

SELECT profile.take_sample ();

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jul 15	08	1	1s31ms	1s31ms
	14	1	1s14ms	1s14ms

[ User: postgres - Total duration: 2s45ms - Times executed: 2 ]

[ Application: psql - Total duration: 2s45ms - Times executed: 2 ]

SELECT profile.take_sample ();
SELECT profile.take_sample ();

Log levels

Key values

31,817 Log entries

Chart
Table

Type	Count	Percentage
FATAL	2,880	9.05%
LOG	28,937	90.95%

Events distribution

Key values

0 PANIC entries
2880 FATAL entries
0 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

2,880 Max number of times the same event was reported
2,880 Total events found

Rank

Times reported

Error

1

2,880

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jul 15	07	192
	08	192
	09	192
	10	192
	11	192
	12	192
	13	192
	14	192
	15	192
	16	192
	17	192
	18	192
	19	192
	20	192
	21	192

FATAL: database "openbravo" does not exist

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per user

Key values

Connections per host

Key values

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per user

Key values

Sessions per host

Key values

Sessions per application

Key values

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoint write buffers (5 minutes period)

Checkpoints Wal files

Key values

Checkpoint Wal files usage (5 minutes period)

Checkpoints distance

Key values

Checkpoint mean distance and estimate (5 minutes period)

Checkpoints Activity

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Analyzes per table

Key values

Vacuums per table

Key values

Tuples removed per table

Key values

Pages removed per table

Key values

Autovacuum Activity

Locks

Locks by types

Key values

Type of locks

Most frequent waiting queries (N)

Queries that waited the most

Queries

Queries by type

Key values

Queries by database

Key values

Queries by user

Key values