Re: expose parallel leader in CSV and log_line_prefix
Julien Rouhaud <rjuju123@gmail.com>
From: Julien Rouhaud <rjuju123@gmail.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-hackers@postgresql.org
Date: 2020-03-15T11:49:33Z
Lists: pgsql-hackers
On Sun, Mar 15, 2020 at 06:18:31AM -0500, Justin Pryzby wrote: > See also: > https://commitfest.postgresql.org/27/2390/ > https://www.postgresql.org/message-id/flat/CAOBaU_Yy5bt0vTPZ2_LUM6cUcGeqmYNoJ8-Rgto+c2+w3defYA@mail.gmail.com > b025f32e0b Add leader_pid to pg_stat_activity FTR this is a followup of https://www.postgresql.org/message-id/20200315095728.GA26184%40telsasoft.com +1 for the feature. Regarding the patch: + case 'k': + if (MyBackendType != B_BG_WORKER) + ; /* Do nothing */ Isn't the test inverted? Also a bgworker could run parallel queries through SPI I think, should we really ignore bgworkers? + else if (!MyProc->lockGroupLeader) + ; /* Do nothing */ There should be a test that MyProc isn't NULL. + else if (padding != 0) + appendStringInfo(buf, "%*d", padding, MyProc->lockGroupLeader->pid); + else + appendStringInfo(buf, "%d", MyProc->lockGroupLeader->pid); + break; I think that if padding was asked we should append spaces rather than doing nothing.
Commits
-
Add %P to log_line_prefix for parallel group leader
- b8fdee7d0ca8 14.0 landed
-
Tweak behavior of pg_stat_activity.leader_pid
- 21b0055359f0 13.0 landed
- 11a68e4b53ff 14.0 landed
-
Add leader_pid to pg_stat_activity
- b025f32e0b5d 13.0 cited