usertuples.sql

-- Cribbed from https://www.dbrnd.com/2016/10/postgresql-script-to-find-total-live-tuples-and-dead-tuples-row-of-a-table-execute-vacuum-remove-fragmentation-improve-performance/
SELECT
    schemaname || '.' || relname AS TableName
    ,n_live_tup AS LiveTuples
    ,n_dead_tup AS DeadTuples
FROM pg_stat_user_tables
WHERE n_live_tup > 0
ORDER by n_dead_tup DESC;