From: | patrick hoogendijk <patrick(at)safepoint(dot)nl> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Is there a way to check execution progress of a query? |
Date: | 2005-11-09 12:56:01 |
Message-ID: | 1131540961.10015.34.camel@sol.office.safepoint.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
Some of the queries I run on my Postgresql database take some time to
complete (1 hour+).
I know you can get the active queries by 'select * from
pg_stat_activity', but I was wondering if there is a way to see some
information on the progress of the query execution while running (for
example the number of updated records , read records).
TIA,
Patrick
--
------------------------------------------------------------
Patrick Hoogendijk
Safepoint Internet Services
curacaolaan 144
3131 XG Vlaardingen
http://www.safepoint.nl
tel: +31 (0)10 4340044
fax: +31 (0)10 4340032
------------------------------------------------------------
"Walking on water and meeting requirements are both equally easy to do
when both are frozen."
From | Date | Subject | |
---|---|---|---|
Next Message | Stef | 2005-11-09 13:01:16 | Re: resetting superuser password |
Previous Message | Martin Fandel | 2005-11-09 12:47:54 | Re: Fwd: resetting superuser password |