Re: Determine current running query, but no query in pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Determine current running query, but no query in pg_stat_activity
Дата
Msg-id 21904.1112110023@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Determine current running query, but no query in pg_stat_activity  (Adam Witney <awitney@sghms.ac.uk>)
Список pgsql-admin
Adam Witney <awitney@sghms.ac.uk> writes:
> Shouldn't there be something in current_query?

Only if (a) you have stats_command_string turned on, *and* (b) you
are a superuser or the owner of the target process.

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


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

Предыдущее
От: "Thomas F.O'Connell"
Дата:
Сообщение: Re: Table Partitioning
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: locale and character set