Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1olhTm-0002fz-K4 for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2022 02:09:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1olhTk-0007p3-Gd for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Oct 2022 02:09:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1olhTj-0007ou-Tz for pgsql-hackers@lists.postgresql.org; Fri, 21 Oct 2022 02:09:44 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1olhTf-0007fl-4r for pgsql-hackers@lists.postgresql.org; Fri, 21 Oct 2022 02:09:43 +0000 Received: by mail-io1-xd29.google.com with SMTP id n73so1147631iod.13 for ; Thu, 20 Oct 2022 19:09:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=kEBbZBl7N5yAa3kveQJCQt4T/M7RH1dTQl+zy1q39W8=; b=ImePT8BZN3tNNGzrXU6OCb2kWrSEDDk8JZf939RI67aTfq1hCHn78n83nvTIUbaLGh 2vHz0cn/PH71TPNs0Ygq/8Y7Ckft7rvDL22H+REV6Qf6VdLT972gEDJO7EJ7rPsXQxg4 j1jFP2D0xvLbr+35SzgOkai+mBCn8EDiRh+9yR77G9RKTyGbQP0Zkw9d/5CIr/X+kTIp mur1ODWLQ147/s+iB7NvOMdSJMhwjeLH9E2QGi4gypFk6QSiqDpG1TdtrVgVkIxyO9hd SoKuuE26nYkStWDL2iBbXk20qmSygbTSP59S9uCVtZi6miJ21+WZ5h9JdD8m8zekDivR VJ+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=kEBbZBl7N5yAa3kveQJCQt4T/M7RH1dTQl+zy1q39W8=; b=LERYg0krOfXHbIaBOmjckJwfChj/to7i4FKeyJYB2xE9bC1FG92bPQdftwyw7YXpol REvfl4yvX9a+XdkB33yrLz3Q/cp7ylSQtUfRQy2icZl38K0eQP9oP3wznrlyjjFDyTnW cne3fuh0eYP1HzdkIdCBywLsvVMiurMpOi2n6vND6y8dViS6lOL23P6gnXTf/gb/ppLl ZAdIihgfOhmj47jgdZwmYjoHRGXpGr4ATrXx087id/uJOAqUEGguYflgHmfxEZjv/QcZ IsGbS97VYRp0C4OY1NJeFgZMWLAwkQSDBtYoB+ipq+o2knQixUIOO5cPW5pEzP+0Q8Df 4YuA== X-Gm-Message-State: ACrzQf2MiGPGWQPSXVZ4e9I4N4F8Ra0nEs8sNr8Ga5FXkmn1/e06CIDO M/Hm4tz0vOr4bJtXglKjZzFEog== X-Google-Smtp-Source: AMsMyM7ymN8T3MO+sWm4QrWSxhksWuc8KCWaBZsgwJKSieHkEp0aBSlgDLwNvPblR0OLMpgXOruYJA== X-Received: by 2002:a05:6638:3c49:b0:363:c8dc:fb2f with SMTP id bg9-20020a0566383c4900b00363c8dcfb2fmr12669475jab.119.1666318176637; Thu, 20 Oct 2022 19:09:36 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id q6-20020a0566380ec600b0036345b91f4asm3900335jas.23.2022.10.20.19.09.35 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 20 Oct 2022 19:09:35 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 99552800C98; Thu, 20 Oct 2022 21:09:34 -0500 (CDT) Date: Thu, 20 Oct 2022 21:09:34 -0500 From: Justin Pryzby To: "David G. Johnston" Cc: Nikolay Samokhvalov , pgsql-hackers@lists.postgresql.org Subject: Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) Message-ID: <20221021020934.GA13372@telsasoft.com> References: <20211115190954.GO17618@telsasoft.com> <20211202005820.GJ17618@telsasoft.com> <20220124173548.GV23027@telsasoft.com> <20220905112031.GF31833@telsasoft.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="YiEDa0DAkWCtVeE4" Content-Disposition: inline In-Reply-To: <20220905112031.GF31833@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --YiEDa0DAkWCtVeE4 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Rebased. BTW, I think it may be that the GUC should be marked PGDLLIMPORT ? --YiEDa0DAkWCtVeE4 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-Add-GUC-explain_regress.patch"