Distinguishing autovacuum activity in pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Distinguishing autovacuum activity in pg_stat_activity
Дата
Msg-id 9452.1200261587@sss.pgh.pa.us
обсуждение исходный текст
Ответы 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>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Hannes Dorbath
Дата:
Сообщение: Re: Index trouble with 8.3b4
Следующее
От: "Guillaume Smet"
Дата:
Сообщение: Re: Distinguishing autovacuum activity in pg_stat_activity