Postgres Pro
Downloads
Home   >   mailing lists

bloat indicator using n_dead_tup column - Mailing list pgsql-admin

From Yambu
Subject bloat indicator using n_dead_tup column
Date
Msg-id CALhHtcAWd+rfCnXA1-1p9DrqJ0fHpR+P3_GHrhgaVDx5myG5Yg@mail.gmail.com
Whole thread Raw
Responses Re: bloat indicator using n_dead_tup column
List pgsql-admin
Tree view
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
FROM pg_stat_user_tables 


i want to use column n_dead_tup to get an estimate or indicator of impending bloat

regards

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating an index on a timestamp with time zone cast to a date-- possible?
Next
From: Guillaume Lelarge
Date:
Subject: Re: bloat indicator using n_dead_tup column