Horton

Re: Make EXPLAIN generate a generic plan for a parameterized query

Christoph Berg <myon@debian.org>

View thread View on postgr.es
From: Christoph Berg <myon@debian.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Andres Freund <andres@anarazel.de>, Michel Pelletier <pelletier.michel@gmail.com>, Julien Rouhaud <rjuju123@gmail.com>, pgsql-hackers@postgresql.org
Date: 2023-03-24T20:26:32Z
Lists: pgsql-hackers 
Re: Tom Lane
> I don't actually see why a postgres_fdw test case is needed at all?
> The tests in explain.sql seem sufficient.

When I asked Laurenz about that he told me that local tables wouldn't
exercise the code specific for EXEC_FLAG_EXPLAIN_GENERIC.

(Admittedly my knowledge of the planner wasn't deep enough to verify
that. Laurenz is currently traveling, so I don't know if he could
answer this himself now.)

Christoph

Commits

  1. Invent GENERIC_PLAN option for EXPLAIN.