Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Fri, Sep 10, 2021 at 10:38 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux