Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum vacuums not setting start time in pg_stat_activity - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Autovacuum vacuums not setting start time in pg_stat_activity
Date
Msg-id 26968.1181682889@sss.pgh.pa.us
Whole thread Raw
In response to Autovacuum vacuums not setting start time in pg_stat_activity  ("Jim Nasby" <jim.nasby@enterprisedb.com>)
Responses Re: Autovacuum vacuums not setting start time in pg_stat_activity  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: "Jim Nasby"
Date:
Subject: Autovacuum vacuums not setting start time in pg_stat_activity
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum vacuums not setting start time in pg_stat_activity