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