# pgexperts/pgx_scripts

A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts.

Repository: https://github.com/pgexperts/pgx_scripts
Canonical: https://ross.abutalabs.com/products/pgx_scripts
Language: Shell
License: NOASSERTION
License Family: other
Last push: 2023-08-10T22:34:00+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 4346, "days_push": 1119, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1468, forks 241 (observed 2026-08-28T04:04:48.886839+00:00)

## What it is
A collection of SQL and shell scripts for PostgreSQL database analysis and administration, maintained by PostgreSQL Experts. It includes queries for detecting table and index bloat, finding missing or duplicate indexes, and analyzing lock contention.

## Use cases
- estimate table and index bloat in postgres
- find foreign keys missing indexes
- detect duplicate or unused indexes
- analyze lock blocking and waiting transactions
- kill idle transactions automatically via cron
- identify tables that need new indexes from sequential scan stats

## When to avoid
- you need a continuous monitoring dashboard with alerting
- you use a database other than PostgreSQL
- you require supported, tested tooling with a clear license

## Facets
- artifact type: cli-tool
- maturity: maintenance
- function: database, monitoring, developer-tools
- domain: databases, developer-tools, performance
- platform: cli
- tags: postgresql, sql-scripts, database-administration, bloat-analysis, index-tuning, lock-analysis, linux, macos

## Member repositories
- pgexperts/pgx_scripts (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:48.886839+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:34:57.350368+00:00, confidence not recorded.
  - readme: https://github.com/pgexperts/pgx_scripts (fetched 2026-08-28T04:04:48.886839+00:00, sha 8ac8d8881d29)
- Data as of 2026-08-30T08:39:29.467469+00:00.