# NikolayS/postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers

Repository: https://github.com/NikolayS/postgres_dba
Canonical: https://ross.abutalabs.com/products/postgres_dba
Language: PLpgSQL
License: BSD-3-Clause
License Family: permissive
Topics: postgres-dba, postgresql, dba, postgres, psql, postgres-server
Last push: 2026-08-18T15:56:45+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 98, release rhythm 37, longevity 100
- inputs: {"age_days": 3402, "days_push": 15, "days_rel": 204, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1284, forks 145 (observed 2026-08-28T04:04:14.537892+00:00)

## What it is
A set of 34 SQL-based diagnostic reports for PostgreSQL that run directly inside psql with no agents or external dependencies. It covers bloat estimation, index health, lock trees, vacuum monitoring, query analysis, and corruption checks.

## Use cases
- diagnose postgres table and index bloat
- find unused or redundant indexes in postgresql
- monitor autovacuum progress and queue
- analyze slow queries with pg_stat_statements
- check postgres indexes for corruption
- inspect lock trees and blocking queries
- estimate database and table sizes

## When to choose
- you administer PostgreSQL and want quick diagnostics inside psql without installing agents or daemons
- you need production-safe health checks like bloat estimation and index analysis
- you want lightweight SQL-only tooling with no external dependencies

## When to avoid
- you need continuous monitoring with dashboards, alerting, and history (use pgwatch, Prometheus, or pganalyze)
- you require support for databases other than PostgreSQL
- you want a GUI-based database administration tool

## Facets
- artifact type: cli-tool
- maturity: active
- function: database, monitoring, developer-tools, cli
- domain: databases, developer-tools, performance
- platform: cli, windows
- tags: postgresql, psql, dba, diagnostics, sql-reports, database-administration, linux, macos

## Member repositories
- NikolayS/postgres_dba (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:14.537892+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:56:42.575526+00:00, confidence not recorded.
  - readme: https://github.com/NikolayS/postgres_dba (fetched 2026-08-28T04:04:14.537892+00:00, sha af68d6cda192)
- Data as of 2026-08-30T08:39:29.467469+00:00.