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

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Make EXPLAIN generate a generic plan for a parameterized query
Date: 2022-10-25 11:03:41
Message-ID: 20221025110341.2xh4b3xnv33jlx2w@jrouhaud
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Anton A. Melnikov 2022-10-25 11:45:28 Re: Question about "compound" queries.
Previous Message thomas 2022-10-25 11:01:57 Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert