pgconfigurator
pgconfigurator

log_autovacuum_min_duration

No restart — takes effect on reloadtuned by pgconfiguratortime (ms); -1 off, 0 logs all

Logs autovacuum/autoanalyze actions that take longer than this.

What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded

What it does

Records each autovacuum or autoanalyze run that exceeds the threshold, with what it cleaned and how long it took. Essential for confirming autovacuum is keeping up (or isn't) on big tables.

How to tune it

A few seconds (or 0 to log all) gives good visibility into autovacuum behavior. PostgreSQL 15+ defaults this to 10 minutes; lowering it helps when you're tuning autovacuum on a bloating table.

Related parameters