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(dot)nasby(at)enterprisedb(dot)com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)