Difference between revisions of "Vacuum reporting"
Jump to navigation
Jump to search
(Created page with "select * from pg_stat_progress_vacuum") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | ``` | ||
select * from pg_stat_progress_vacuum | 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%' | ||
| + | ``` | ||
| + | |||
| + | 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);