Re: Way to tell what SQL is currently running?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Way to tell what SQL is currently running?
Дата
Msg-id 20030825104721.I93434-100000@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: Way to tell what SQL is currently running?  ("Patrick Hatcher" <PHatcher@macys.com>)
Ответы Using RECORD returning functions with JDBC  (Juan Francisco Diaz <j-diaz@publicar.com>)
Список pgsql-novice
Дерево обсуждения 
On Mon, 25 Aug 2003, Patrick Hatcher wrote:

> Pg_stat_activity only shows the User, PID, etc, but the Query string field
> just shows empty text

You need to turn on an option IIRC to get the query string field to be
populated (because it's extra overhead) so I don't think that'll help for
a currently running situation.  Do you have any of the query logging
options turned on?

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Patrick Hatcher"
Дата:
Сообщение: Re: Way to tell what SQL is currently running?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Returning SETOF RECORD