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

Поиск
Список
Период
Сортировка
Искать
От
Julien Rouhaud
Тема
Re: Make EXPLAIN generate a generic plan for a parameterized query
Дата
Msg-id
20221025110341.2xh4b3xnv33jlx2w@jrouhaud
Ответ на
Список
Дерево обсуждения
Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Julien Rouhaud <rjuju123@gmail.com>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Julien Rouhaud <rjuju123@gmail.com>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Andres Freund <andres@anarazel.de>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Michel Pelletier <pelletier.michel@gmail.com>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Andres Freund <andres@anarazel.de>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Christoph Berg <myon@debian.org>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Christoph Berg <myon@debian.org>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Laurenz Albe <laurenz.albe@cybertec.at>
Re: Make EXPLAIN generate a generic plan for a parameterized query Christoph Berg <myon@debian.org>
Re: Make EXPLAIN generate a generic plan for a parameterized query Jim Jones <jim.jones@uni-muenster.de>
Re: Make EXPLAIN generate a generic plan for a parameterized query Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: thomas@habets.se
Дата:
От: Anton A. Melnikov
Дата:
FAQ