Re: Display individual query in pg_stat_activity

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Display individual query in pg_stat_activity
Дата
Msg-id b886a78f-a6b2-f1fd-f5be-a6e3b5a89fe7@amazon.com
обсуждение исходный текст
Ответ на Re: Display individual query in pg_stat_activity  (Dave Page <dpage@pgadmin.org>)
Список pgsql-hackers
Дерево обсуждения
On 7/27/20 9:57 AM, Dave Page wrote:
On Mon, Jul 27, 2020 at 3:40 PM Drouvot, Bertrand <bdrouvot@amazon.com> wrote:
<snip>
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?
Perhaps turn query into text[]. That would make it easy to concatenate back together if desired.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

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

Предыдущее
От: Asif Rehman
Дата:
Сообщение: Re: proposal: unescape_text function
Следующее
От: Robert Haas
Дата:
Сообщение: Re: new heapcheck contrib module