Estimated dead rows, initiated sequences and indexes scans on tables.

dead_rows_sequences_and_indexes.sql

select relname,(n_dead_tup+n_live_tup) as estimated_total_rows, n_dead_tup as estimated_dead_rows,
seq_scan,idx_scan 
from pg_catalog.pg_stat_all_tables
where n_dead_tup > 0  
-- and relname =  '<TABLE_NAME>' 
and schemaname='<SCHEMA_NAME>'
order by n_dead_tup desc;