EXPLAIN (GENERIC_PLAN)
: New in PostgreSQL 16
A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. The method suggested in that article works, but is still somewhat complicated. So I wrote a patch to support an
EXPLAIN
optionGENERIC_PLAN
, which provides native support for that. My patch got committed by Tom Lane in 3c05284d83, which means the new option will be available from v16 on. This article describes how the new feature works and how it can be useful.
Source: PostgreSQL 16: EXPLAIN (GENERIC_PLAN), an article by Laurenz Albe.