pgstattuple

Postgres charges full price to scan the dead 20% of an append-only table

Timescale's bloat guide shows an append-only Postgres table sitting at 22% dead tuples. Nothing on a normal dashboard reports that, so the cost arrives as slow query drift that reads like growth.