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.