PostgreSQL Vacuum Statistics

PostgreSQL_vacuum_statistics.sql

-- Display vacuum information for PostgreSQL Tables
SELECT     n.nspname AS schema_name
	,    c.relname AS table_name
	,    c.reltuples AS row_count
	,    c.relpages AS page_count
	,    s.n_dead_tup AS dead_row_count
	,    s.last_vacuum
	,    s.last_autovacuum
	,    s.last_analyze
	,    s.last_autoanalyze
FROM pg_class c
JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_stat_user_tables s ON s.relid = c.oid
WHERE c.relkind = 'r'
	AND n.nspname = 'public';