Table Health

A table has autovacuum explicitly disabled, meaning it will not be automatically vacuumed by PostgreSQL.

A table's frozen transaction ID age is approaching the autovacuum_freeze_max_age threshold, which will trigger aggressive anti-wraparound vacuum.

A table has a high ratio of sequential scans to index scans, indicating that queries may be missing useful indexes.

A table has a high ratio of dead tuples to live tuples, indicating significant bloat. This wastes disk space and slows down sequential scans.

A table has accumulated dead tuples or hasn't been vacuumed recently, indicating maintenance is needed.

A table is created as UNLOGGED, meaning data is not written to WAL and will be lost on crash or unclean shutdown.