pgsql: Add a guc_check_handler to the EXPLAIN extension mechanism.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add a guc_check_handler to the EXPLAIN extension mechanism.
Date: 2026-04-06 16:46:22
Message-ID: E1w9n5h-003GDi-0h@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add a guc_check_handler to the EXPLAIN extension mechanism.

It would be useful to be able to tell auto_explain to set a custom
EXPLAIN option, but it would be bad if it tried to do so and the
option name or value wasn't valid, because then every query would fail
with a complaint about the EXPLAIN option. So add a guc_check_handler
that auto_explain will be able to use to only try to set option
name/value/type combinations that have been determined to be legal,
and to emit useful messages about ones that aren't.

Reviewed-by: Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
Reviewed-by: Lukas Fittl <lukas(at)fittl(dot)com>
Discussion: http://postgr.es/m/CA+Tgmob-0W8306mvrJX5Urtqt1AAasu8pi4yLrZ1XfwZU-Uj1w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0442f1c9eff673849664d8ef71c202ad076e72e9

Modified Files
--------------
contrib/pg_overexplain/pg_overexplain.c | 6 +-
contrib/pg_plan_advice/pg_plan_advice.c | 3 +-
src/backend/commands/explain_state.c | 121 ++++++++++++++++++++++++++++++--
src/include/commands/explain_state.h | 13 +++-
4 files changed, 135 insertions(+), 8 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2026-04-06 17:15:11 pgsql: Fix null-bitmap combining in array_agg_array_combine().
Previous Message Nathan Bossart 2026-04-06 16:29:27 pgsql: Remove autoanalyze corner case.