Aiolum Browse stories
All tools
Measuring · 1 of 252 stories

PgHero

An open-source performance dashboard for PostgreSQL databases that shows the slowest queries, space use and suggested indexes in a web page.

What PgHero is

Written from its maker's own pages, read on 28 October 2026.

PgHero is an open-source performance dashboard for Postgres (PostgreSQL), a relational database. It is maintained on GitHub by the developer ankane, and its README says it was tested in production at Instacart.

PgHero connects to a database and shows its state in a web page. Query statistics come from pg_stat_statements, a Postgres extension that records how often each query runs and how much time it takes, and the dashboard flags slow queries (by default those that average over 20 ms and run at least 100 times) and long-running queries. With the optional pg_query library it suggests indexes to add. It can store query and space statistics over time in tables, which adds a time-range slider to the Queries tab, and for Amazon RDS and Google Cloud SQL it also shows CPU use and IOPS (disk input and output operations per second). One installation can watch several databases.

PgHero is free and open source under the MIT license. It runs as a Docker image, started with the database address in DATABASE_URL, or as a Rails engine mounted inside a Ruby on Rails application.

Made by
ankane (open source)
Price
Free and open source (read 28 October 2026)
Free plan
free

Who uses it, and for what

One row per story. The grade is for the claim that the business uses this tool, not for its revenue.

StoryWhat it does thereWhenCost statedGradeSource
ChatbasePostgres performance dashboard used to find the slowest queries.BSupabase customer story, 2026: The consolidation play that took a single founder from zero to 10 million in ARR

Grade A: the tool's maker or a payment processor confirms the use. Grade B: an independent report, or the tool is visible in public code. Grade C: the founder or the company says so.

Other tools for the same job

Measuring, with the number of stories that use each.

Back to all tools