We can compare the number of dead row versions, shown as n_dead_tup against the required threshold, av_threshold.
The preceding query doesn't take into account table-specific autovacuum thresholds. It could do so if you really need it, but the main purpose of the query is to give us information to understand what is happening, and then set the parameters accordingly-not the other way around.
Notice that the table query shows insertions, updates, and deletions, so you can understand your workload better. There is also something named the hot_update_ratio. This shows the fraction of updates that take advantage of the HOT feature, which allows a table to self-vacuum as the table changes. If that ratio is high, then you may avoid ...
