Horton

Monitoring a Query

Aaron Held <aaron@metrony.com>

View thread View on postgr.es
From: Aaron Held <aaron@MetroNY.com>
To: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Date: 2002-09-20T15:34:27Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql 
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>