Monitoring a Query
| От | Aaron Held |
|---|---|
| Тема | Monitoring a Query |
| Дата | |
| Msg-id | 3D8B4003.3090303@MetroNY.com обсуждение |
| Ответ на | timestamp parse error ("Tomas Lehuta" <lharp@aurius.sk>) |
| Ответы |
Re: [GENERAL] Monitoring a Query
Re: [GENERAL] Monitoring a Query |
| Список | 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>
В списке pgsql-sql по дате отправления: