Re: is there a way log last query in pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: is there a way log last query in pg_stat_activity
Дата
Msg-id 5565.1408033433@sss.pgh.pa.us
обсуждение исходный текст
Ответ на is there a way log last query in pg_stat_activity  (Si Chen <sichen@opensourcestrategies.com>)
Список pgsql-general
Дерево обсуждения 
Si Chen <sichen@opensourcestrategies.com> writes:
> I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be
> showing <IDLE> when no query is being run.

> Is there a way for it to show the last query, even if it was run a while
> ago?

More recent versions act that way.  There is no way to make 9.0.x do it
short of patching the source code.

            regards, tom lane

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

Предыдущее
От: Andy Lau
Дата:
Сообщение: Best practices for cloning DB servers
Следующее
От: Rajmohan C
Дата:
Сообщение: How to modify parser in PostgreSQL to handle new keyword and parse it