bloat indicator using n_dead_tup column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux