Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Christoph Berg <myon@debian.org>, Andres Freund <andres@anarazel.de>, Michel Pelletier <pelletier.michel@gmail.com>, Julien Rouhaud <rjuju123@gmail.com>, pgsql-hackers@postgresql.org
Date: 2023-03-24T17:20:06Z
Lists: pgsql-hackers 
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Tue, 2023-03-21 at 16:32 +0100, Christoph Berg wrote:
>> The test involving postgres_fdw is still necessary to exercise the new
>> EXEC_FLAG_EXPLAIN_GENERIC code path, but needs to be moved elsewhere,
>> probably src/test/modules/.

> Tests for postgres_fdw are in contrib/postgres_fdw/sql/postgres_fdw.sql,
> so I added the test there.

I don't actually see why a postgres_fdw test case is needed at all?
The tests in explain.sql seem sufficient.

			regards, tom lane

Commits

  1. Invent GENERIC_PLAN option for EXPLAIN.