A free and handy PostgreSQL log analyzer that autodetects log file formats and enables users to view fully detailed reports regarding entries and errors
Furthermore, pgBadger can autodetect your log file format (syslog, stderr or csvlog). It is designed to parse huge log files as well as gzip compressed file.
- Analyze statistics
- View entries
- View errors
In a hurry? Add it to your Download Basket!
What's New in This Release:
- This is a maintenance release to fix a regression in SQL traffic graphs and fix some other minor issues. The release also adds a new option -D or --dns-resolv to map client ip addresses to FQDN without having log_hostname enabled on the postgresql's configuration
- Do not display queries in Slowest individual, Time consuming and Normalized slowest queries reports when there is no duration in log file. Display NO DATASET instead.
- Fix min/max queries in SQL traffic that was based on duration instead of query count. Fix wrong unit to Synced files in Checkpoints files report. Thanks to Levente Birta for the report.
- Enable allow_loose_quotes in Text::CSV_XS call to fix CSV parsing error when fields have quote inside an unquoted field. Thanks to Josh Berkus for the report.