Vacuum reporting
Jump to navigation
Jump to search
select * from pg_stat_progress_vacuum
https://www.dbrnd.com/2017/12/postgresql-check-the-progress-of-running-vacuum/
https://wiki.postgresql.org/wiki/Lock_Monitoring
read only
SELECT * FROM pg_settings WHERE name LIKE 'autovacuum%'
Disable
ALTER TABLE table_name SET (autovacuum_enabled = false);