Re: Expose lock group leader pid in pg_stat_activity

Поиск
Список
Период
Сортировка
Искать
От
Sergei Kornilov
Тема
Re: Expose lock group leader pid in pg_stat_activity
Дата
Msg-id
5153051577359132@sas8-b090c2642e35.qloud-c.yandex.net
Ответ на
Список
Дерево обсуждения
Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge <guillaume@lelarge.info>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Sergei Kornilov <sk@zsrv.org>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Sergei Kornilov <sk@zsrv.org>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Justin Pryzby <pryzby@telsasoft.com>
Re: Expose lock group leader pid in pg_stat_activity Justin Pryzby <pryzby@telsasoft.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Michael Paquier <michael@paquier.xyz>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge <guillaume@lelarge.info>
Re: Expose lock group leader pid in pg_stat_activity Julien Rouhaud <rjuju123@gmail.com>
Re: Expose lock group leader pid in pg_stat_activity Guillaume Lelarge <guillaume@lelarge.info>
Hello

I doubt that "Process ID of the lock group leader" is enough for user documentation. I think we need note:
- this field is related to parallel query execution
- leader_pid = pid if process is parallel leader
- leader_pid would point to pid of the leader if process is parallel worker
- leader_pid will be NULL for non-parallel queries or idle sessions

Also patch has no tests. Possible this is normal, not sure how to write a reliable test for this feature.
Patch applies, compiles, pass tests

regards, Sergei


В списке pgsql-hackers по дате отправления
От: Amit Khandekar
Дата:
От: Ashutosh Sharma
Дата:
FAQ