Autovacuum vacuums not setting start time in pg_stat_activity

From: "Jim Nasby" <jim(dot)nasby(at)enterprisedb(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Autovacuum vacuums not setting start time in pg_stat_activity
Date: 2007-06-12 20:48:04
Message-ID: 72E9A8CC-0729-4EAE-BC49-D861314137B8@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)nasby(at)enterprisedb(dot)com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-06-12 21:14:49 Re: Autovacuum vacuums not setting start time in pg_stat_activity
Previous Message Zdenek Kotala 2007-06-12 18:25:17 Re: password auth woes on sparc64/FreeBSD