Postgres Pro
Downloads
Home   >   mailing lists

Monitoring a Query - Mailing list pgsql-sql

From Aaron Held
Subject Monitoring a Query
Date
Msg-id 3D8B4003.3090303@MetroNY.com
Whole thread Raw
In response to timestamp parse error  ("Tomas Lehuta" <lharp@aurius.sk>)
Responses Re: [GENERAL] Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [GENERAL] Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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>

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] timestamp parse error
Next
From: "Josh Berkus"
Date:
Subject: Re: help w/ constructing a SELECT