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';