db-storage-bloat
Installation
SKILL.md
db-storage-bloat (M18)
Storage operability keeps a database fast and alive over time; it is a Performance & Scale (axis
performance) concern, feeding relational Almacenamiento w12 (shared with M22/M20/M21) and the
Tombstones category in the wide-column profile. The catastrophic case — TXID wraparound — can
force a Postgres shutdown, so it is a severity:5 cap when imminent.
What it checks
- VACUUM / autovacuum health — autovacuum disabled or mis-tuned on a high-churn table, dead tuples accumulating, bloated tables/indexes inflating size and slowing scans.
- TXID wraparound —
age(datfrozenxid)(or per-tablerelfrozenxid) approachingautovacuum_freeze_max_age/ the 2-billion ceiling. Imminent wraparound isseverity:5,fail(perf) — but only with live age evidence; statically it is at most aneeds_apinudge. - Tombstones (wide-column) — Cassandra/Scylla heavy deletes / TTL churn producing tombstones that
degrade reads (
tombstone_warn_thresholdterritory).