pgBadger app Innovation Release
This documentation covers the current Innovation Release of
EDB Postgres AI. See also:
- Hybrid Manager dual release strategy
- Documentation for the current Long-term support release
Important
Regular upstream releases deliver security updates. Keep your pgBadger instance up to date to receive the latest patches.
pgBadger analyzes PostgreSQL logs from your HM clusters and generates HTML reports with statistics on database activity, performance, and errors.
Key features
- Parallel log parsing.
- HTML reports with interactive charts.
- Slow query identification.
- Connection and session statistics.
- Lock and checkpoint analysis.
- Temporary file and autovacuum monitoring.
- Support for stderr, csvlog, and syslog log formats.
Requirements
Technical requirements
- Kubernetes or OpenShift cluster.
- Persistence: Default 1Gi volume to store reports and uploaded logs.
Configuration requirements
- Retention:
reportRetentionDays(default 30) controls how long reports are kept. - Upload limits:
maxUploadSize(default 50MB) limits the size of log files you can analyze.
Supported data sources
- PostgreSQL log files (text format).
Deploying pgBadger
- Navigate to Asset Library, then select Apps in the HM console.
- Select pgBadger and adjust resource limits based on expected log volume (default 512Mi memory).
- Select Deploy.
Note
Once you have deployed pgBadger in HM, you can access it in the HM console under Apps or Asset Library.
Post-deployment configuration
Once pgBadger is deployed, complete these steps to finish your setup:
- Navigate to your Project and select the Apps tab, or navigate to Estate > Apps to check the deployment status. When the status shows Ready, launch the app to continue.
- Open the pgBadger Reports interface in the HM console.
- Upload your PostgreSQL log files to generate a new visual report.
Support resources
As pgBadger OSS is community-supported, use these resources for technical guidance and updates:
- pgBadger support — get support for any queries related to pgBadger.
- pgBadger documentation — self-service deployment and feature guides, as well as additional information on pgBadger installation and configuration.
- pgBadger GitHub repository — source code, issue tracker, and release notes.