Re: a verbose option for autovacuum

I agree to have autovacuum log more information, especially index

vacuums. Currently, the log related to index vacuum is only the number

of index scans. I think it would be helpful if the log has more

details about each index vacuum.

But I'm not sure that neither always logging that nor having set the

parameter per-table basis is a good idea. In the former case, it could

be log spam for example in the case of anti-wraparound vacuums that

vacuums on all tables (and their indexes) in the database. If we set

it per-table basis, it’s useful when the user already knows which

tables are likely to take a long time for autovacuum but won’t work

when the users want to check the autovacuum details for tables that

autovacuum could take a long time for.

Given that we already have log_autovacuum_min_duration, I think this

verbose logging should work together with that. I’d prefer to enable

the verbose logging by default for the same reason Stephen mentioned.

Or maybe we can have a parameter to control verbosity, say

log_autovaucum_verbosity.