pgBadger

Pricing and hosting

Pricing

Free

Open source

Yes (PostgreSQL)

Self-hosted

Yes

Launched

2012

Status

Active

Website

pgbadger.darold.net

Plans and prices change; check the tool's own site before you decide.

What it does

Database monitoring checklist

4 of 10 confirmed in pgBadger's own documentation. The same checklist is used for every tool in Databases.

• + PostgreSQL Yes
• x MySQL or MariaDB No
• x SQL Server No
• x MongoDB No
• + Query statistics Yes
• + Explain plans Yes
• ? Index advice Not confirmed
• ? Replication Not confirmed
• + Locks and waits Yes
• x Alerting No

Offline PostgreSQL log report generator; plans come from auto_explain lines in the logs

Checked against: github.com, pgbadger.darold.net

Alternatives to pgBadger

Other database monitoring tools. See all 19.

• ClusterControl Severalnines platform to deploy, monitor and manage open source database clusters such as MySQL, PostgreSQL, MongoDB and Redis on your own servers or cloud.
• Percona Monitoring and Management Open source monitoring for MySQL, PostgreSQL, MongoDB and Valkey: a server and client agents collect metrics and query analytics, with Grafana-based dashboards and alerting.
• pganalyze Hosted Postgres performance monitoring that collects query statistics, plans and logs, and suggests indexes and VACUUM settings. The Enterprise plan can run on your own infrastructure.
• pgDash PostgreSQL monitoring service from RapidLoop that tracks queries, replication, locks and table stats over time, with alerts. A self-hosted edition is sold on annual licences.
• pgwatch PostgreSQL monitoring from Cybertec that gathers metrics with SQL queries and stores them in Postgres or Prometheus for the bundled Grafana dashboards.
• Redgate Monitor Database estate monitoring for SQL Server, PostgreSQL, Oracle and MySQL (formerly SQL Monitor), with query performance history, alerting and estate-wide health views.
• Releem Hosted agent-based service for MySQL, MariaDB and PostgreSQL that monitors performance, analyses slow queries and recommends configuration and index changes.
• SolarWinds Suite of network, server, database and application monitoring products, sold as self-hosted software and as the SaaS SolarWinds Observability.
• SolarWinds Database Performance Analyzer Wait-time based performance analysis for SQL Server, Oracle, MySQL, PostgreSQL and other engines, showing which queries and waits slow each database down.
• F Foglight Quest's monitoring suite, best known for database performance monitoring across SQL Server, Oracle, PostgreSQL and other engines, with workload analysis and alerting.
• M mysqld_exporter Official Prometheus exporter for MySQL and MariaDB that exposes server status, InnoDB and replication metrics.
• P PgHero Small web dashboard for Postgres that shows slow queries, index usage, table bloat and connection counts. Runs as a Rails engine or a Docker container.