PgHero
A performance dashboard for Postgres: query stats, slow queries, missing indexes, and vacuuming.
Why consider PgHero?
PgHero is an open-source performance monitoring dashboard for PostgreSQL written in Ruby and Rails by Andrew Kane. PgHero analyzes `pg_stat_statements`, identifying slow queries, suggesting missing table indexes, alerting on table bloat, and tracking database connection limits in real time.
Learn PgHero by building
Practical setup notes, real use cases, and copy-ready examples in one focused guide.
In this guide2 sections
Overview of PgHero
PgHero optimizes PostgreSQL database performance by exposing slow queries and indexing suggestions.
Docker Quickstart
docker run -d -e DATABASE_URL=postgres://user:password@host:5432/dbname -p 8080:8080 ankane/pgheroPgHero is licensed under the permissive MIT License.
Related tools
More options with a similar category or technology profile.
diskus
Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.
peco
Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.
Dapr CLI
Command-line tool for managing Dapr distributed application runtime environments and sidecars.
Freeze
Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.