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.
