Re: Distinguishing autovacuum activity in pg_stat_activity

Guillaume Smet escribió:
> On Jan 13, 2008 10:59 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > I think this would be a helpful change, but some might find it
> > confusing.  Thoughts?
> 
> If possible, something like:
> autovacuum: VACUUM ANALYZE foo.bar
> could be less confusing.
> It's weird to just add AUTO in front of the query.

Whether the string is "AUTO " or "autovacuum: " seems rather the same
thing to me :-)  I agree with the general idea.  I think "autovacuum: "
makes it clearer that it's not part of the actual command syntax, so
maybe I'll put half a vote for that option.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.