Re: question on auto_explain

From: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: question on auto_explain
Date: 2023-08-04 07:28:39
Message-ID: b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kalit Inani 2023-08-04 08:57:13 Re: PITR based recovery failing due to difference in max_connections
Previous Message Julien Rouhaud 2023-08-04 05:33:19 Re: question on auto_explain