pghero

PgHero is a web dashboard that gives you a visual look at the health and performance of a PostgreSQL database. PostgreSQL (often shortened to Postgres) is a popular open-source database that many web applications use to store their data. Over time, databases can slow down because of missing indexes, long-running queries, bloated tables, or other issues, and diagnosing those problems normally requires running SQL commands and knowing what to look for. PgHero puts that information in a browser interface so it is easier to spot.

The dashboard shows things like slow queries, duplicate indexes, unused indexes, and tables that need maintenance. It was used in production at Instacart, which gives some indication of how much load it has been tested against.

You can install PgHero in three different ways depending on your setup. There is a Docker image for those who prefer containers, a Linux package for direct server installation, and a Rails engine for teams already running a Ruby on Rails application who want to embed the dashboard inside it. Each method has its own installation guide linked from the main README.

The README itself is brief and points to separate guide files for setup details rather than listing them inline. It also lists a few related projects from the same author: Dexter for automatic index recommendations, pgsync for copying data between databases, and pgslice for table partitioning.

PgHero is an open-source project that accepts contributions for bug fixes, documentation, and new features. A live demo is available at the project's hosted URL for anyone who wants to see what the interface looks like before installing it.