pgbadger ☆

« Back to VersTracker

Description:
Log analyzer for PostgreSQL

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql log-analysis database monitoring reporting

Install: brew install pgbadger

About:
Pgbadger is a fast log analyzer that generates detailed HTML reports from PostgreSQL log files. It helps database administrators visualize performance metrics, errors, and query statistics without complex setup. The tool provides actionable insights to optimize database configurations and troubleshoot issues efficiently.

Key Features:

Generates comprehensive HTML reports with charts and graphs
Supports multiple log formats including csvlog and syslog
Analyzes slow queries, errors, and session activity
Command-line interface for easy automation and scripting

Use Cases:

Identifying slow queries and performance bottlenecks in production databases
Auditing database activity and security events for compliance
Capacity planning through historical query performance analysis

Alternatives:

pg_stat_statements – Built-in PostgreSQL extension for query stats; requires database access vs pgbadger's log file analysis
pganalyze – Commercial monitoring platform with real-time insights vs pgbadger's free, log-based reporting

Version History

Detected	Version	Rev	Change	Commit