Find live vs. dead tuples of a table
select relname as "table", n_live_tup as "live tuples", n_dead_tup as "dead tuples" from pg_stat_user_tables where relname = 'my_table';
select relname as "table", n_live_tup as "live tuples", n_dead_tup as "dead tuples" from pg_stat_user_tables where relname = 'my_table';