Difference between revisions of "Vacuum reporting"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
https://wiki.postgresql.org/wiki/Lock_Monitoring | https://wiki.postgresql.org/wiki/Lock_Monitoring | ||
| + | read only | ||
``` | ``` | ||
SELECT * | SELECT * | ||
| Line 14: | Line 15: | ||
https://www.techonthenet.com/postgresql/autovacuum.php#:~:text=When%20the%20system%20settings%20for,table_name%20SET%20(autovacuum_enabled%20%3D%20false)%3B | https://www.techonthenet.com/postgresql/autovacuum.php#:~:text=When%20the%20system%20settings%20for,table_name%20SET%20(autovacuum_enabled%20%3D%20false)%3B | ||
| + | |||
| + | |||
| + | Disable | ||
| + | ``` | ||
| + | ALTER TABLE table_name SET (autovacuum_enabled = false); | ||
| + | ``` | ||
Latest revision as of 02:49, 23 September 2022
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);