Re: Distinguishing autovacuum activity in pg_stat_activity

Tom Lane wrote:
> I was just noticing that $SUBJECT is hard --- the entry in current_query
> looks exactly like a manual vacuum command, and there's not anything in
> the other fields that looks different either.
> 
> Since autovacuum.c is making up its pgstat_report_activity string
> anyway, it would be easy to make the string look like, say,
>     AUTO VACUUM ANALYZE foo.bar
> 
> I think this would be a helpful change, but some might find it
> confusing.  Thoughts?

I find

AUTOVACUUM ANALYZE foo.bar more clear.

Joshua D. Drake

> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
>