Query for metric the distribution of the deleted tuples across blocks
This issue intends to find queries to gather a distribution of dead tuples across blocks in tables. That is, trying to measure how many blocks a vacuum needs to clean statistically.
Maybe, combining pg_buffercache
and pg_stat_tuple
.
Objective: find the correlation between the table size, write distribution and vacuum cost.