nbari / pg_exporter / 18800822326

90%

main: 90%

Build Type

push

github

Committed by nbari

Commit Message

feat: add bloat metrics to stat_user_tables collector

Add two derived metrics to help identify bloated tables:
- pg_stat_user_tables_bloat_ratio: ratio of dead to total tuples (0.0-1.0)
- pg_stat_user_tables_dead_tuple_size_bytes: estimated reclaimable space

These metrics are computed from existing pg_stat_user_tables data
(n_live_tup, n_dead_tup, table_size_bytes) without additional queries,
making it easier to identify tables needing vacuum and prioritize by
impact.

Example alerts:
- High bloat ratio: pg_stat_user_tables_bloat_ratio > 0.2
- Large waste: pg_stat_user_tables_dead_tuple_size_bytes > 1073741824

Coverage Stats

38 of 64 new or added lines in 2 files covered. (59.38%)

1 existing line in 1 file now uncovered.

3979 of 4591 relevant lines covered (86.67%)

33.11 hits per line