Re: [GENERAL] Monitoring a Query

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: [GENERAL] Monitoring a Query
Дата
Msg-id 87znuc5tdm.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Monitoring a Query  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: CoL
Дата:
Сообщение: Re: Two Permance Questions
Следующее
От: "John Gilson"
Дата:
Сообщение: Re: HELP w/ SQL -- distinct select with non distinct fields?