Re: How to observe plan_cache_mode transition from custom to generic plan?

Поиск
Список
Период
Сортировка
От Richard Michael
Тема Re: How to observe plan_cache_mode transition from custom to generic plan?
Дата
Msg-id CABR0jETyYzw89GnwGadJOdAuhqcDQr82o2M+dXWtesjSujdy_g@mail.gmail.com
обсуждение исходный текст
Ответ на How to observe plan_cache_mode transition from custom to generic plan?  (Richard Michael <rmichael@edgeofthenet.org>)
Список pgsql-general
Дерево обсуждения


On Fri, Sep 10, 2021 at 10:38 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2021-09-09 at 16:51 +0200, Richard Michael wrote:
> > > 2/ EXPLAIN EXECUTE of prepared statement doesn't show query text, as the
> > > documentation seems to imply.  Should it?
> >
> > Yes, and it does for me - see below.
>
> I do not see the query text in your EXPLAIN EXECUTE output.  Perhaps I am misusing terminology?

My sloppiness.  You are right, it does not show the query text.  But no EXPLAIN
shows the query text, right?

That seems to be correct, yes.

Somewhat related, I noted in my reply to Tom that `auto_explain` does log the query text,
and ExplainQueryText() was added to commands/explain.c for just that purpose.  auto_explain is
the only code which uses that function.

Regards,
richard


Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Michael
Дата:
Сообщение: Re: How to observe plan_cache_mode transition from custom to generic plan?
Следующее
От: Gus Spier
Дата:
Сообщение: Re: Is there any technical reason why "alter table .. set not null" can't use index?