PgHero
A self-hosted performance dashboard for PostgreSQL that highlights slow queries, index issues and space usage.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
About PgHero
PgHero is a web dashboard for PostgreSQL. It shows which queries are slow, points out missing or unused indexes and reports how much space tables and indexes take up, so you can find performance problems without writing diagnostic SQL yourself.
It installs either as a Docker image or as an engine inside a Rails application. It was built and used at Instacart, and version 4.0 was recently released.
Strengths
- Surfaces slow queries and index problems at a glance
- Runs as a Docker image or a Rails engine
- Proven in production at Instacart
- Actively maintained with a recent major release
Limitations
- PostgreSQL only
- You host and secure the dashboard yourself
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- Andrew Kane
- Platforms
- Web, Self-hosted
- How it runs
- Self-hosted
- Best suited for
- Developers and DBAs tuning PostgreSQL performance
- Categories
- System monitoring, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Similar software
Related functionality, not necessarily a direct replacement.
pgAdmin
The standard open-source administration tool for PostgreSQL.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
DataGrip
Multi-database IDE with an intelligent SQL console and schema navigation.
Metabase
An open-source analytics tool for querying databases and building dashboards, with or without writing SQL.
pgBackRest
Parallel backup and restore for PostgreSQL with delta restore.
TimescaleDB
PostgreSQL extension that turns Postgres into a scalable time-series database.
