pgexperts/pgx_scripts
A collection of useful little scripts for database analysis and administration, created by our team at PostgreSQL Experts. observed · 2026-08-28
Health v2 · maintenance only
32/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases no_license
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 4346
- days_rel: n/a
- days_push: 1119
- n_releases_24m: 0
Adoption not part of the score
1468 stars · 241 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
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
cli-tool · maturity maintenance
database monitoring developer-tools databases developer-tools performance cli postgresql sql-scripts database-administration bloat-analysis index-tuning lock-analysis linux macos
1 source
- readme: https://github.com/pgexperts/pgx_scripts · fetched 2026-08-28 · 8ac8d8881d29
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| pgexperts/pgx_scripts | main | 32 |
For agents
markdown · JSON · MCP: product_card(name="pgexperts/pgx_scripts")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem