PGHero (ankane/pghero) is an open-source tool for monitoring and analyzing PostgreSQL database performance, built to provide insights into query behavior, index usage, replication lag, and resource bottlenecks. It runs alongside your application (often as a Rails engine, but usable standalone) and collects metrics from PostgreSQL system views, logging slow queries, long-running transactions, and missing indexes. The web interface presents dashboards with charts and tables that help you understand trends, spot inefficient queries, and identify opportunities for optimization. PGHero supports customizable thresholds and notifications, so you can be alerted when slowness or index problems emerge. It also includes views of replication and connection statistics, helping teams monitor operational health without deploying external monitoring tools.
Features
- Overview dashboard showing slowest queries, query count, database load
- Ability to inspect query details over time (total time, average time, number of calls)
- Space statistics: table/index growth, unused indexes, tracking storage usage over time
- Suggested indexes to improve performance, and alerts/checks for things like transaction ID wraparound or integer overflow
- Supports multiple installation modes: run as Docker, Linux package, or integrated within a Rails app
- Basic security/access control via simple authentication (password or credentials) for the dashboard
Project Samples
