Константин Сергеевич ДереркНу, к примеру, по каким-то причинам он не работает, хотя в конфиге стоит on.

Подскажите как запросом контролировать правельность выполнения автовакуума?
в логе смотри.

Вот хорошая статья. Учись студент:

авторSo that’s how you tune autovacuum. If I had to sum it into a few basic rules, it’d be these five:
• Don’t disable autovacuum, unless your really know what you’re doing. Seriously.
• On busy databases (doing a lot of UPDATEs and DELETEs), particularly large ones, you should probably decrease the scale factor, so that cleanup happens more frequently.
• On reasonable hardware (good storage, multiple cores), you should probably increase the throttling parameters, so that the cleanup can keep up.
• Increasing autovacuum_max_workers alone will not really help in most cases. You’ll get more processes that go slower.
• You can set the parameters per table using ALTER TABLE, but think twice if you really need that. It makes the system more complex and more difficult to inspect.

Источник < https://blog.2ndquadrant.com/autovacuum-tuning-basics/>