Re: Display individual query in pg_stat_activity

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Display individual query in pg_stat_activity
Дата
Msg-id CA+OCxozrKrt=39d_kcnpNmOs=wG+4NFTfTa3jqHNuv=DJj9E+g@mail.gmail.com
обсуждение исходный текст
Ответ на Display individual query in pg_stat_activity  ("Drouvot, Bertrand" <bdrouvot@amazon.com>)
Ответы Re: Display individual query in pg_stat_activity  (Jeremy Schneider <schnjere@amazon.com>)
Re: Display individual query in pg_stat_activity  (Jim Nasby <nasbyj@amazon.com>)
Re: Display individual query in pg_stat_activity  ("Drouvot, Bertrand" <bdrouvot@amazon.com>)
Список pgsql-hackers
Дерево обсуждения
Hi

On Mon, Jul 27, 2020 at 3:40 PM Drouvot, Bertrand <bdrouvot@amazon.com> wrote:
Hi hackers,

I've attached a patch to display individual query in the pg_stat_activity query field when multiple SQL statements are currently displayed.

Motivation:

When multiple statements are displayed then we don’t know which one is currently running.

I'm not sure I'd want that to happen, as it could make it much harder to track the activity back to a query in the application layer or server logs. 

Perhaps a separate field could be added for the current statement, or a value to indicate what the current statement number in the query is?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: display offset along with block number in vacuum errors
Следующее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: [BUG] Error in BRIN summarization