Horton
Menu

Re: Missing query plan for auto_explain.

Julien Rouhaud <rjuju123@gmail.com>

View thread
From: Julien Rouhaud <rjuju123@gmail.com>
To: Matheus Martin <matheus.martin@voidbridge.com>
Cc: Maxim Boguk <maxim.boguk@gmail.com>, pgsql-general@postgresql.org
Date: 2022-09-12T16:46:16Z
Lists: pgsql-general 
On Mon, Sep 12, 2022 at 05:34:37PM +0100, Matheus Martin wrote:
> Understood. I have run a prepared statement with the query in question
> through `psql` and JIT was not used (see plan below), however please note
> that the long response times were never reproducible from `psql`, they only
> happen from our JDBC application.

Do you have pg_stat_statements enabled?  If yes you could check what are the
maximum execution and planning time for that query, which may give an answer.