Re: Autovacuum vacuums not setting start time in pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum vacuums not setting start time in pg_stat_activity
Дата
Msg-id 26968.1181682889@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Autovacuum vacuums not setting start time in pg_stat_activity  ("Jim Nasby" <jim.nasby@enterprisedb.com>)
Ответы Re: Autovacuum vacuums not setting start time in pg_stat_activity  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Дерево обсуждения 
"Jim Nasby" <jim.nasby@enterprisedb.com> writes:
> This is on a 8.2.3 database; vacuums started by autovacuum don't get
> their query_start time set.

Hmm.  Query_start is actually defined as "time of last client command
receipt", so it's null just like client_addr/port are.  Not sure if
there's anything we should put there that's more meaningful than the
backend start time.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Jim Nasby"
Дата:
Сообщение: Autovacuum vacuums not setting start time in pg_stat_activity
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum vacuums not setting start time in pg_stat_activity