psql -d appdb -c "SELECT name, setting FROM pg_settings WHERE name LIKE 'autovacuum%';"

Category: Databases & SQL

psql -d appdb -c "SELECT name, setting FROM pg_settings WHERE name LIKE 'autovacuum%';"

Inspect autovacuum settings

pg_settings holds every run-time parameter; filtering on autovacuum% reveals the tunables (threshold, scale factor, workers) and their current values. Autovacuum is the background process that reclaims dead rows automatically. Override per table with ALTER TABLE SET (autovacuum_vacuum_threshold = ...).
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.