Some useful PostgreSQL queries to check autovacuum state and progress:
; Check if autovacuum enabled
SHOW autovacuum;
; Show autovacuum processes
SELECT pid, query, state, age(clock_timestamp(), query_start) AS duration
FROM pg_stat_activity
WHERE query LIKE 'autovacuum: %' AND state != 'idle';
; Show autovacuum phase and progress
SELECT pid, relid::regclass AS table_name, phase, heap_blks_total, heap_blks_scanned, heap_blks_vacuumed
FROM pg_stat_progress_vacuum;