Re: Make EXPLAIN generate a generic plan for a parameterized query - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Make EXPLAIN generate a generic plan for a parameterized query
Date
Msg-id 20221025110341.2xh4b3xnv33jlx2w@jrouhaud
Whole thread Raw
In response to Re: Make EXPLAIN generate a generic plan for a parameterized query  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Make EXPLAIN generate a generic plan for a parameterized query  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Hi,

On Tue, Oct 25, 2022 at 11:08:27AM +0200, Laurenz Albe wrote:
>
> Here is a patch that
> implements it with an EXPLAIN option named GENERIC_PLAN.

I only have a quick look at the patch for now.  Any reason why you don't rely
on the existing explain_filter() function for emitting stable output (without
having to remove the costs)?  It would also take care of checking that it works
in plpgsql.



pgsql-hackers by date:

Previous
From: thomas@habets.se
Date:
Subject: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Next
From: "Anton A. Melnikov"
Date:
Subject: Re: Question about "compound" queries.