Runbook: IncreasedDeadTupelCount Alert
Alert Details
- Alert Name: IncreasedDeadTupelCount
- Expression:
(pg_stat_user_tables_n_dead_tup{datname!~"template.*"}/ pg_stat_user_tables_n_live_tup{datname!~"template.*"}) > 1
Description
This alert triggers if the amount of unused tupels in the DB is higher than the amount of live tupels. Dead tupels are unused tupels which can be deleted but are not deleted yet.
Possible Causes
- VACUUM process is not configured
- VACUUM process isn’t running often enough