SHOW autovacuum;
SELECT relname, n_live_tup, n_dead_tup, n_dead_tup / (n_live_tup::float) as ratio FROM pg_stat_user_tables WHERE n_live_tup > 0 AND n_dead_tup > 1000 ORDER BY ratio DESC;
각 테이블 별로 Autovacuum 이 마지막에 실행된 시각
SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze FROM pg_stat_user_tables ORDER BY relname asc;
tune table
ALTER TABLE spatial_ref_sys SET (autovacuum_vacuum_scale_factor = 0.0); ALTER TABLE spatial_ref_sys SET (autovacuum_vacuum_threshold = 100000); ALTER TABLE spatial_ref_sys SET (autovacuum_vacuum_cost_limit = 1000);