Re: [GENERAL] Monitoring a Query - Mailing list pgsql-sql

From Neil Conway
Subject Re: [GENERAL] Monitoring a Query
Date
Msg-id 87znuc5tdm.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: [GENERAL] Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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

pgsql-sql by date:

Previous
From: CoL
Date:
Subject: Re: Two Permance Questions
Next
From: "John Gilson"
Date:
Subject: Re: HELP w/ SQL -- distinct select with non distinct fields?