PgHero
A performance dashboard for Postgres
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.