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

From Jim Nasby
Subject Autovacuum vacuums not setting start time in pg_stat_activity
Date
Msg-id 72E9A8CC-0729-4EAE-BC49-D861314137B8@enterprisedb.com
Whole thread Raw
Responses Re: Autovacuum vacuums not setting start time in pg_stat_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
This is on a 8.2.3 database; vacuums started by autovacuum don't get
their query_start time set.

select * from pg_stat_activity where current_query like 'VACUUM%';
-[ RECORD 1 ]-+---------------------------------------------
datid         | 16384
datname       | emma2
procpid       | 8674
usesysid      | 10
usename       | postgres
current_query | VACUUM public.userdata_2409_messages_history
waiting       | f
query_start   |
backend_start | 2007-06-12 15:29:53.376641-05
client_addr   |
client_port   |

--
Jim Nasby                               jim.nasby@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-bugs by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: password auth woes on sparc64/FreeBSD
Next
From: Tom Lane
Date:
Subject: Re: Autovacuum vacuums not setting start time in pg_stat_activity