Re: question on auto_explain - Mailing list pgsql-general

From Frédéric Yhuel
Subject Re: question on auto_explain
Date
Msg-id b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com
Whole thread Raw
In response to Re: question on auto_explain  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general

On 8/4/23 07:33, Julien Rouhaud wrote:
> Now, there also seems to be some common misconception about how auto_explain is
> working, as it's not the first time that I hear people thinking or assuming
> that it's executing extra EXPLAIN commands.  Maybe adding some extra
> clarification could help, maybe stating that the emitted plan is the one
> actually used during the query execution.

I couldn't agree more. The "two-step process" mentioned by Karsten is a 
common belief among many people, including experienced PostgreSQL DBAs.



pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: question on auto_explain
Next
From: Kalit Inani
Date:
Subject: Re: PITR based recovery failing due to difference in max_connections