live and dead tuples #postgres #psql

tuples.sql

SELECT 
	schemaname
    ,relname AS TableName
	,n_live_tup AS LiveTuples
	,n_dead_tup AS DeadTuples
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC
;



SELECT
    relname AS ObjectName
    ,pg_stat_get_live_tuples(c.oid) AS LiveTuples
    ,pg_stat_get_dead_tuples(c.oid) AS DeadTuples
FROM pg_class c;