https://www.tutorialdba.com/2017/12/daily-monitoring-postgresql-master-and.html SELECT schemaname, relname, n_dead_tup, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze FROM pg_stat_all_tables WHERE n_dead_tup <> 0 ORDER BY n_dead_tup DESC; -- 5000 üzerinde dead tuple olan sorgu SELECT COUNT(*) FROM pg_stat_all_tables WHERE n_dead_tup > 5000;
