Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRpF2-003G3N-P9 for pgsql-general@arkaria.postgresql.org; Fri, 04 Aug 2023 07:28:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qRpEz-004sJy-M7 for pgsql-general@arkaria.postgresql.org; Fri, 04 Aug 2023 07:28:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRpEz-004sJq-AE for pgsql-general@lists.postgresql.org; Fri, 04 Aug 2023 07:28:53 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRpEu-000SZy-Bu for pgsql-general@lists.postgresql.org; Fri, 04 Aug 2023 07:28:52 +0000 Received: from [192.168.1.35] (lfbn-nan-1-2223-111.w92-139.abo.wanadoo.fr [92.139.174.111]) by mail.dalibo.com (Postfix) with ESMTPSA id 4FD6F1F8AF for ; Fri, 4 Aug 2023 09:28:41 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1691134121; bh=wwaFh2Bjx0SzNhTTQIHUjm2PB0bYVFdl31vT4OOrMD4=; h=Date:Subject:To:References:From:In-Reply-To:From; b=A4YFec1SP3/OrMJjfz9kBB4gLmGePojmSAgB56wWFsbLb2K2/bf4TFRVD30wCMy40 snRGDBuEumuaVba4hXe4hFYGim/q9hZotJsmhgiHLM+EryWJyuTX6ufDKUTNzd0t00 3Y7FJ3cpXkdD88j/7Z7gEnx2DS2WZ78Elv3aeTmc= Message-ID: Date: Fri, 4 Aug 2023 09:28:39 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.1 Subject: Re: question on auto_explain Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <20230804053319.uuwupt4qtiwf5x3v@jrouhaud> From: =?UTF-8?Q?Fr=c3=a9d=c3=a9ric_Yhuel?= In-Reply-To: <20230804053319.uuwupt4qtiwf5x3v@jrouhaud> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.