PostgreSQL Performance Cheat Sheet/Show autovacuum setting

Check whether autovacuum is enabled.

Section: Vacuum, Analyze, and Maintenance

Show autovacuum setting

sql
sql
SHOW autovacuum;
Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Vacuum, Analyze, and Maintenance
Vacuum one table
Reclaim dead tuples and maintain visibility data.
OpenIn sheetsqlsame section
Vacuum analyze one table
Vacuum and refresh planner stats in one command.
OpenIn sheetsqlsame section
VACUUM FULL table
Rewrite a bloated table more aggressively.
OpenIn sheetsqlsame section
Reindex table
Rebuild all indexes on a table.
OpenIn sheetsqlsame section
Analyze verbose
Show extra detail while updating planner statistics.
OpenIn sheetsqlsame section
Show work_mem
Inspect a setting that affects sort and hash memory usage.
OpenIn sheetsql1 tag match