Re: autovacuum not running

Ben <bench(at)silentmedia(dot)com> writes:
> Hm, I assumed it wasn't running because pg_stat_all_tables shows the last
> vacuum from several weeks ago, and this is an active db. Also, I see no
> vacuum activity in the logs. But "show autovacuum" does show it being
> on....

Just to double-check, make sure stats_start_collector and
stats_row_level are on, and confirm that you see the stats collector
process in "ps". Also, do you have any of the autovac threshold
parameters at nondefault values?

The autovac process doesn't run continuously, so not seeing it in ps
is not proof that there's a problem. But if pg_stat_all_tables isn't
showing any evidence of vacuums happening, that's probably bad.

> So if it is running after all, how can I track down why things aren't
> getting vacuumed? What log level are the autovacuum logs at?

I think you've gotta crank it up to DEBUG2 or so, which is gonna be
noisy :-(

regards, tom lane