# heroku/heroku-pg-extras

A heroku plugin for awesome pg:* commands that are also great and fun and super.

Repository: https://github.com/heroku/heroku-pg-extras
Canonical: https://ross.abutalabs.com/products/heroku-pg-extras
Language: TypeScript
License: MIT
License Family: permissive
Topics: heroku, heroku-cli-plugin, heroku-data
Archived: true
Last push: 2026-07-07T18:16:25+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 91, release rhythm 75, longevity 100
- inputs: {"age_days": 5085, "days_push": 57, "days_rel": 85, "gap_med": 47, "n_releases_24m": 4}
- flags: archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1354, forks 103 (observed 2026-08-28T04:04:29.115103+00:00)

## What it is
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
- artifact type: plugin
- maturity: abandoned
- function: database, monitoring, cli, developer-tools
- domain: databases, developer-tools, performance, cloud-computing
- platform: cli, cloud
- tags: postgres, heroku, database-introspection, performance-diagnostics, archived, nodejs

## Member repositories
- heroku/heroku-pg-extras (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:29.115103+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:42:01.636334+00:00, confidence not recorded.
  - readme: https://github.com/heroku/heroku-pg-extras (fetched 2026-08-28T04:04:29.115103+00:00, sha da4021fdac1c)
  - registry_npm: https://registry.npmjs.org/heroku-pg-extras (fetched 2026-08-29T12:00:42.072464+00:00, sha 1eb74be8a49e)
- Data as of 2026-08-30T08:39:29.467469+00:00.