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
Re: Display individual query in pg_stat_activity Re: Display individual query in pg_stat_activity |
| Список | 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?
В списке pgsql-hackers по дате отправления: