Hello
I would like to know if the below query can be used as a bloat indicator.
select
n_dead_tup
/ (n_live_tup * current_setting('autovacuum_vacuum_scale_factor')::float8
+ current_setting('autovacuum_vacuum_threshold')::float8) > 1 then true else false end as bloated_indicator
/ (n_live_tup * current_setting('autovacuum_vacuum_scale_factor')::float8
+ current_setting('autovacuum_vacuum_threshold')::float8) > 1 then true else false end as bloated_indicator
FROM pg_stat_user_tables
i want to use column n_dead_tup to get an estimate or indicator of impending bloat
regards