darold/pgbadger
Pgbadger
pgBadger is a PostgreSQL log analyzer and database performance profiler that parses database logs to generate detailed reports on slow queries and system errors. It functions as a statistics visualizer, transforming raw logs into interactive charts and graphs to monitor system trends.
The tool utilizes a multi-core log processor to distribute parsing across CPU cores, accelerating the analysis of large volumes of database activity logs. It provides a mechanism for remote log analysis by retrieving and parsing files from distant servers via secure shell connections.
The system covers database resource monitoring, connection pooler log analysis, and performance trend visualization. It supports the generation of incremental reports to create cumulative summaries and exports analyzed metrics in JSON format for integration with external monitoring tools.
The analyzed data is transformed into static HTML reports and images for offline viewing.
Features
- PostgreSQL Performance Monitoring - Analyzes PostgreSQL database log files to identify slow queries and system errors to improve database speed.
- Parallel Log Parsing - Utilizes a multi-core log processor to distribute parsing across CPU cores, significantly accelerating the analysis of large log volumes.
- Database Performance Profiling - Identifies bottlenecks, temporary file usage, and error distributions within database log files.
- Database Performance Monitoring - Tracks query duration, request throughput, and active session counts to monitor database resource utilization.
- Log Statistics Visualizers - Transforms raw database logs into interactive charts and graphs to monitor system trends.
- Log File Parsing - Parses database log files in multiple formats to generate detailed performance reports.
- Log Management Systems - Processes large volumes of PostgreSQL database logs into readable reports and summaries.
- Performance Trend Analysis - Transforms raw database logs into interactive charts and graphs to visualize system activity and performance trends.
- Portable HTML Reports - Transforms analyzed metrics into self-contained, interlinked static HTML pages and images for offline viewing.
- Incremental Log Processing - Processes logs in successive runs to create cumulative daily and weekly summaries of system performance.
- Parallel Log Parsing - Utilizes multi-core parallel processing to accelerate the analysis of large database log files.
- Remote Database Log Retrieval - Fetches logs from distant servers over secure shell tunnels for centralized analysis without local file copies.
- Parallel Log Processing - Uses parallel processing across multiple CPU cores to analyze large volumes of database activity logs.
- Connection Pooler Statistics - Processes connection pooler logs to report on request throughput, query duration, and active session counts.
- Remote Log Parsing - Retrieves and analyzes log files from remote servers via secure shell connections to identify system issues.
- Cumulative Summaries - Generates cumulative daily and weekly performance summaries by processing logs in successive runs.
- Remote Logging Utilities - Retrieves and parses log files from remote servers via secure shell to diagnose issues without manual transfers.
- Performance and Optimization - Fast log analyzer for PostgreSQL.
