heroku/heroku-pg-extras

Health v2 · maintenance only

Flags: archived

Adoption not part of the score

1354 stars · 103 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A Heroku CLI plugin providing shortcut commands for common Postgres introspection queries, such as cache hit ratios, index usage, locks, and query outliers. It helps analyze performance issues on Heroku Postgres instances. The repository is now archived, with the commands merged into the Heroku CLI itself.

Use cases

• diagnose slow queries on heroku postgres
• check postgres buffer cache hit ratio
• find unused indexes in postgres
• inspect table locks blocking queries
• identify expensive query outliers in postgres
• analyze postgres vacuum statistics

When to choose

• you are on an older Heroku CLI that lacks built-in pg:* introspection commands
• you need quick Postgres performance diagnostics from the terminal on Heroku

When to avoid

• you use a current Heroku CLI, since these commands are now built in and the plugin is archived
• you manage Postgres outside Heroku
• you need a GUI or continuous monitoring rather than ad-hoc CLI queries

Facets

plugin · maturity abandoned

database monitoring cli developer-tools databases developer-tools performance cloud-computing cli cloud postgres heroku database-introspection performance-diagnostics archived nodejs

Member repositories

For agents

markdown · JSON · MCP: product_card(name="heroku/heroku-pg-extras")