gargron/pghero

PgHero is a performance dashboard for PostgreSQL databases. If your app runs on Postgres and things start feeling slow, this tool gives you a visual dashboard to see what's going on under the hood, which queries are taking too long, where the bottlenecks are, and how your database is handling the load overall. The tool works by running a series of pre-built diagnostic queries against your Postgres database and presenting the results in a clean web interface. Instead of writing complex SQL to figure out why your database is sluggish, you get a dashboard with the answers laid out in front of you. You can install it in a few different ways depending on your setup, as a plugin for Ruby on Rails apps, as a standalone Linux package, or as a Docker image that runs anywhere. The main audience is developers and teams who manage Postgres databases and want to keep them healthy without becoming database experts. For example, if you run an e-commerce site and checkout is slow during peak hours, this tool helps you pinpoint which queries are responsible. It's described as "battle-tested at Instacart," meaning it's been used at scale on a real, high-traffic production app. There's also a hosted version available if you don't want to set it up yourself, which adds features like real-time alerts and single sign-on. The README is fairly sparse beyond installation links, so it doesn't go into detail on every feature, but the core value proposition is straightforward: a simple way to keep tabs on your Postgres performance.