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

From:	Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To:	Christoph Berg <myon(at)debian(dot)org>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:	Re: Make EXPLAIN generate a generic plan for a parameterized query
Date:	2023-03-23 18:31:26
Message-ID:	93a9c6dd0b44fffd6ecfda973497b537d232609b.camel@cybertec.at
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-10-11 12:37:25 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎  2022-10-11 13:49:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2022-10-11 16:03:48 from Julien Rouhaud <rjuju123(at)gmail(dot)com>    2022-10-25 09:08:27 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎     2022-10-25 11:03:41 from Julien Rouhaud <rjuju123(at)gmail(dot)com>      2022-10-29 08:35:26 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎       2022-12-06 18:17:08 from Andres Freund <andres(at)anarazel(dot)de>        2022-12-07 11:23:02 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎         2022-12-27 22:37:11 from Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>          2023-01-09 16:40:01 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎           2023-01-16 13:39:08 from Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>            2023-01-16 17:02:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2023-01-31 18:49:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎            2023-02-03 13:30:59 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>             2023-02-03 14:44:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2023-02-03 16:14:29 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎               2023-02-03 20:11:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2023-02-05 17:24:03 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎                 2023-02-14 00:33:06 from Andres Freund <andres(at)anarazel(dot)de>                  2023-02-14 12:44:44 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎                   2023-03-21 15:32:48 from Christoph Berg <myon(at)debian(dot)org>                    2023-03-22 13:15:23 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎                     2023-03-23 18:31:26 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 📎                      2023-03-24 10:58:09 from Christoph Berg <myon(at)debian(dot)org>                     2023-03-24 17:20:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2023-03-24 20:26:32 from Christoph Berg <myon(at)debian(dot)org>                       2023-03-24 20:41:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2023-03-28 06:35:57 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-Add-EXPLAIN-option-GENERIC_PLAN.v10.patch	text/x-patch	18.0 KB

In response to

• Re: Make EXPLAIN generate a generic plan for a parameterized query at 2023-03-22 13:15:23 from Laurenz Albe

Responses

• Re: Make EXPLAIN generate a generic plan for a parameterized query at 2023-03-24 10:58:09 from Christoph Berg

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Gregory Stark (as CFM)	2023-03-23 18:42:51	Re: Consider parallel for lateral subqueries with limit
Previous Message	Peter Geoghegan	2023-03-23 18:18:08	Re: Add n_tup_newpage_upd to pg_stat table views