Re: Distinguishing autovacuum activity in pg_stat_activity

Guillaume Smet wrote:
> On Jan 13, 2008 11:27 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>> AUTOVACUUM ANALYZE foo.bar more clear.
> 
> Doesn't autovacuum also trigger ANALYZE only?
> 
> That's why I proposed an 'autovacuum:' prefix.

Oh so:

autovacuum: vacuum
autovacuum: analyze
autovacuum: vacuum analyze

Yeah that's cool.

Joshua D. Drake



> 
> --
> Guillaume
>