Gregory Stark wrote: > > I'm having trouble following what's going on with autovacuum and I'm finding > the existing logging insufficient. In particular that it's only logging vacuum > runs *after* the vacuum finishes makes it hard to see what vacuums are running > at any given time. Also, I want to see what is making autovacuum decide to > forgo vacuuming a table and the log with that information is at DEBUG2.
So did this idea go anywhere?
Assuming the thread stopped here, I'd like to rekindle the proposal.
log_min_messages acts as a single gate for everything headed for the server logs; controls for per-background process logging do not exist. If one wants to see DEBUG/INFO messages for just the Autovacuum (or checkpointer, bgwriter, etc.), they have to set log_min_messages to that level, but the result would be a lot of clutter from other processes to grovel through, to see the messages of interest.
The facilities don't yet exist, but it'd be nice if such parameters when unset (ie NULL) pick up the value of log_min_messages. So by default, the users will get the same behaviour as today, but can choose to tweak per background-process logging when needed.
Absent such a feature, one hack is to set the desired log_min_messages value in conf file and send SIGHUP to just the process of interest and revert the conf file back; but it's a hack.