Allow plugins to set a 64-bit plan identifier in PlannedStmt This field can be optionally set in a PlannedStmt through the planner hook, giving extensions the possibility to assign an identifier related to a computed plan. The backend is changed to report it in the backend entry of a process running (including the extended query protocol), with semantics and APIs to set or get it similar to what is used for the existing query ID (introduced in the backend via 4f0b0966c8). The plan ID is reset at the same timing as the query ID. Currently, this information is not added to the system view pg_stat_activity; extensions can access it through PgBackendStatus.
Some patches have been proposed to provide some features in the planning area, where a plan identifier is used as a key to know the plan involved (for statistics, plan storage and manipulations, etc.), and the point of this commit is to provide an anchor in the backend that extensions can rely on for future work. The reset of the plan identifier is controlled by core and follows the same pattern as the query identifier added in 4f0b0966c8. The contents of this commit are extracted from a larger set proposed originally by Lukas Fittl, that Sami Imseih has proposed as an independent change, with a few tweaks sprinkled by me. Author: Lukas Fittl <lu...@fittl.com> Author: Sami Imseih <samims...@gmail.com> Reviewed-by: Bertrand Drouvot <bertranddrouvot...@gmail.com> Reviewed-by: Michael Paquier <mich...@paquier.xyz> Discussion: https://postgr.es/m/cap53pkyow59ajfmhgpmb1bk9whdypawtuss_5doyuefsa_h...@mail.gmail.com Discussion: https://postgr.es/m/caa5rz0vywd4r35uubumhngv8xqeijukjddkklf5lcowxv-t...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/2a0cd38da5ccf70461c51a489ee7d25fcd3f26be Modified Files -------------- src/backend/executor/execParallel.c | 1 + src/backend/optimizer/plan/planner.c | 4 ++ src/backend/tcop/postgres.c | 24 ++++++++++++ src/backend/utils/activity/backend_status.c | 58 +++++++++++++++++++++++++++++ src/include/nodes/plannodes.h | 3 ++ src/include/utils/backend_status.h | 5 +++ 6 files changed, 95 insertions(+)
