Postgres Pro
Downloads
Home   >   mailing lists

Distinguishing autovacuum activity in pg_stat_activity - Mailing list pgsql-hackers

From Tom Lane
Subject Distinguishing autovacuum activity in pg_stat_activity
Date
Msg-id 9452.1200261587@sss.pgh.pa.us
Whole thread Raw
Responses Re: Distinguishing autovacuum activity in pg_stat_activity  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: Distinguishing autovacuum activity in pg_stat_activity  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Tree view 
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?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Index trouble with 8.3b4
Next
From: "Guillaume Smet"
Date:
Subject: Re: Distinguishing autovacuum activity in pg_stat_activity