pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frédéric Yhuel <frederic.yhuel@dalibo.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: question on auto_explain
Date: Fri, 4 Aug 2023 09:28:39 +0200
Message-ID: <b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com> (raw)
In-Reply-To: <20230804053319.uuwupt4qtiwf5x3v@jrouhaud>
References: <trinity-606c746c-267c-4492-a262-bb6b287e7490-1691080184980@3c-app-gmx-bs14>
	<CAKFQuwa4T-ihtV5sQ=PW86evygx8YFKKXbFUshUCRTdN0eo0Xg@mail.gmail.com>
	<trinity-dd3b1a5a-7646-4c8d-8a15-0bd59dd5fb83-1691081608121@3c-app-gmx-bs14>
	<trinity-7a634cbb-d52a-48c7-b541-78c3b16a8629-1691091939561@3c-app-gmx-bs14>
	<20230804053319.uuwupt4qtiwf5x3v@jrouhaud>



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.





view thread (5+ messages)  latest in thread

Message-ID: <b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com>
Permalink:  ../b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com/
Also on:    postgresql.org/message-id/b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: frederic.yhuel@dalibo.com
  Subject: Re: question on auto_explain
  In-Reply-To: <b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com>
  References: <trinity-606c746c-267c-4492-a262-bb6b287e7490-1691080184980@3c-app-gmx-bs14> <CAKFQuwa4T-ihtV5sQ=PW86evygx8YFKKXbFUshUCRTdN0eo0Xg@mail.gmail.com> <trinity-dd3b1a5a-7646-4c8d-8a15-0bd59dd5fb83-1691081608121@3c-app-gmx-bs14> <trinity-7a634cbb-d52a-48c7-b541-78c3b16a8629-1691091939561@3c-app-gmx-bs14> <20230804053319.uuwupt4qtiwf5x3v@jrouhaud> <b64fedc2-6fe0-98dc-a16b-d4b625a5aa7f@dalibo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox