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.
Pricing and hosting
- Pricing
- Free
- Open source
- Yes (MIT)
- Self-hosted
- Yes
- Launched
- 2014
- Status
- Active
- Website
- github.com
Plans and prices change; check the tool's own site before you decide.
What it does
Database monitoring checklist
6 of 10 confirmed in PgHero's own documentation. The same checklist is used for every tool in Databases.
- PostgreSQL Yes
- MySQL or MariaDB No
- SQL Server No
- MongoDB No
- Query statistics Yes
- Explain plans Yes
- Index advice Yes
- Replication Yes
- Locks and waits Yes
- Alerting Not confirmed
PostgreSQL-only dashboard; replication, blocked queries and explain confirmed from source; no built-in alerting found
Checked against: github.com, github.com (2), github.com (3), github.com (4), github.com (5)
Alternatives to PgHero
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. -
pgBadger PostgreSQL log analyzer that turns server logs into HTML reports on slow queries, errors, locks, checkpoints and connections. -
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. - Foglight Quest's monitoring suite, best known for database performance monitoring across SQL Server, Oracle, PostgreSQL and other engines, with workload analysis and alerting.
- mysqld_exporter Official Prometheus exporter for MySQL and MariaDB that exposes server status, InnoDB and replication metrics.