Log autovacuum actions that run at least this long.
At a glance
| Property | Value |
|---|---|
| Parameter | log_autovacuum_min_duration |
| Category | Logging |
| Default | 10min |
| Value type | time (ms/s/min) |
| Change scope | Reload (no restart) |
What it does
Logs autovacuum operations meeting this duration, with detailed page/tuple statistics. Default 10min since PG15. 0 logs all.
How to apply a change
Takes effect on configuration reload (sighup context). Run SELECT pg_reload_conf(); or send SIGHUP — no restart needed.
Inspect the current value and source with SHOW log_autovacuum_min_duration; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'log_autovacuum_min_duration';.
Tuning guidance
Lower to 0 temporarily when diagnosing bloat or slow vacuums to see exactly what autovacuum is doing per table.