Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 513E5476DD3; Fri, 20 Sep 2002 11:35:43 -0400 (EDT)
Received: from metrony.com (webware.metrony.com [207.159.131.106])
	by postgresql.org (Postfix) with ESMTP
	id 6D473476D9E; Fri, 20 Sep 2002 11:35:42 -0400 (EDT)
Received: from MetroNY.com ([66.9.109.130])
	by metrony.com (8.11.0/8.11.0) with ESMTP id g8KFYcT50204;
	Fri, 20 Sep 2002 15:34:38 GMT (envelope-from aaron@MetroNY.com)
Message-ID: <3D8B4003.3090303@MetroNY.com>
Date: Fri, 20 Sep 2002 11:34:27 -0400
From: Aaron Held <aaron@MetroNY.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Monitoring a Query
References: <amf4ce$2kle$1@news.hub.org> <16439.1032535170@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/938
X-Sequence-Number: 30519

Is there any way to monitor a long running query?

I have stats turned on and I can see my queries, but is there any better 
measure of the progress?

Thanks,
-Aaron Held

select current_query from pg_stat_activity;
current_query

<IDLE>
<IDLE>
<IDLE>
<IDLE>
<IDLE> in transaction
FETCH ALL FROM PgSQL_470AEE94
<IDLE> in transaction
select * from "Calls" WHERE "DurationOfCall" = 2.5 AND "DateOfCall" = 
'7/01/02' AND ("GroupCode" = 'MIAMI' OR "GroupCode" = 'Salt Lake');
<IDLE>
<IDLE>
<IDLE>