Horton

Re: Monitoring a Query

Neil Conway <neilc@samurai.com>

View thread View on postgr.es
From: Neil Conway <neilc@samurai.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Aaron Held <aaron@MetroNY.com>, pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 2002-09-20T19:54:45Z
Lists: pgsql-hackers, pgsql-general, pgsql-sql 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Aaron Held wrote:
> > Is there any way to monitor a long running query?
> 
> Oh, sorry, you want to know how far the query has progressed.  Gee, I
> don't think there is any easy way to do that.

Would it be a good idea to add the time that the current query began
execution at to pg_stat_activity?

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC