Difference between revisions of "Vacuum reporting"
Jump to navigation
Jump to search
| 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://www.dbrnd.com/2017/12/postgresql-check-the-progress-of-running-vacuum/ | ||
https://wiki.postgresql.org/wiki/Lock_Monitoring | https://wiki.postgresql.org/wiki/Lock_Monitoring | ||
| + | |||
| + | ``` | ||
| + | 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 | ||
Revision as of 02:48, 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
SELECT * FROM pg_settings WHERE name LIKE 'autovacuum%'