Page History

SELECT schemaname || '.' || relname as tblnam,
    n    n_dead_tup,
        (n_dead_tup::float / n_live_tup::float) * 100 as pfrag
FROM pg_stat_user_tables
WHERE schemaname = 'xml' and n_dead_tup > 0 and n_live_tup > 0 order by pfrag desc;