Repolode
Submit
ankane

ankane/pghero

A performance dashboard for Postgres that surfaces slow queries, index usage, and database health metrics.

View on GitHub
Stars
8,950
Forks
482
Open issues
5
Last commit
16 days ago

What is it?

PgHero is a performance dashboard for Postgres databases. It gives developers a web view of query performance, index usage, and overall database health, so they can spot slow or problematic queries without writing SQL against system statistics by hand.

PgHero is distributed as a Docker image that can be run against any Postgres instance, and as a Rails engine that mounts inside an existing Rails application. Installation guides for both methods are provided in the project's guides.

The project is related to other tools by the same author, including Dexter (an automatic indexer for Postgres), pgsync for syncing data between databases, and pgslice for partitioning tables.

Key features

  • 01Shows slow queries and their performance statistics in a web dashboard.
  • 02Reports index usage to help find unused or missing indexes.
  • 03Provides database health and space-related views.
  • 04Can run as a Docker image against any Postgres instance.
  • 05Can be mounted as a Rails engine inside an existing Rails app.

Use cases

  • Diagnosing slow queries in a production Postgres database.
  • Reviewing index usage to decide which indexes to add or remove.
  • Giving a team a shared, read-only view of database performance without giving them shell access.

Quick start

  1. 1

    Choose an installation method: Docker or Rails engine (see the guides in the README)

  2. 2

    Install the Rails engine by adding the gem to your Gemfile, then run bundle install

    bundle install

Things to know

  • Requires a running Postgres database and setup through Docker or a Rails app.
  • Some README sections are brief, so setup details live in separate guides.

In collections

Databases & SQL toolsDashboards & business intelligence tools

Topics

#postgres#database#performance#monitoring#dashboard#rails

FAQ

What is pghero?
A performance dashboard for Postgres that surfaces slow queries, index usage, and database health metrics. PgHero is a performance dashboard for Postgres databases. It gives developers a web view of query performance, index usage, and overall database health, so they can spot slow or problematic queries without writing SQL against system statistics by hand.
Is pghero free to use? What license does it have?
pghero is open source under the MIT license. Check the license terms before using it in commercial products.
Is pghero still maintained?
Actively maintained. The last commit to pghero was on Oct 22, 2026.
What can I use pghero for?
Diagnosing slow queries in a production Postgres database. Reviewing index usage to decide which indexes to add or remove. Giving a team a shared, read-only view of database performance without giving them shell access.
How do I install pghero?
Choose an installation method: Docker or Rails engine (see the guides in the README) Install the Rails engine by adding the gem to your Gemfile, then run bundle install: bundle install
Where can I get pghero?
The source code and installation instructions are on GitHub: https://github.com/ankane/pghero

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects