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 1k8mhB-0000sy-BT for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Aug 2020 15:41:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k8mhA-0002yM-8o for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Aug 2020 15:41:40 +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 1k8mhA-0002yF-2H for pgsql-hackers@lists.postgresql.org; Thu, 20 Aug 2020 15:41:40 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8mh8-00070R-0U for pgsql-hackers@lists.postgresql.org; Thu, 20 Aug 2020 15:41:39 +0000 Received: from hnk.local (p12054-ipngn2901funabasi.chiba.ocn.ne.jp [153.212.171.54]) by oss.nttdata.com (Postfix) with ESMTPSA id 9D92E60560; Fri, 21 Aug 2020 00:41:34 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.102.3 at oss.nttdata.com Subject: Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) To: Julien Rouhaud , David Rowley Cc: Justin Pryzby , Pierre Giraud , PostgreSQL Developers , Fujii Masao References: <07b226e6-fa49-687f-b110-b7c37572f69e@dalibo.com> <20200819032706.GQ17022@telsasoft.com> <20200819072133.jnmtux7qbyxywh6r@nol> <20200819090429.s7hoyyw4a6jumgkc@nol> <5605ac79-90c0-6a5f-256d-5cabf52a3fe8@oss.nttdata.com> From: Fujii Masao Message-ID: <0d074a53-fd91-b1dd-a529-173d07627465@oss.nttdata.com> Date: Fri, 21 Aug 2020 00:41:34 +0900 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Thunderbird/68.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020/08/20 22:34, Julien Rouhaud wrote: > On Thu, Aug 20, 2020 at 12:29 PM David Rowley wrote: >> >> On Thu, 20 Aug 2020 at 19:58, Fujii Masao wrote: >>> >>> On 2020/08/20 13:00, David Rowley wrote: >>>> I forgot to mention earlier, you'll also need to remove the part in >>>> the docs that mentions BUFFERS requires ANALYZE. >>> >>> Thanks for the review! I removed that. >>> Attached is the updated version of the patch. >>> I also added the regression test performing "explain (buffers on)" >>> without "analyze" option. >> >> Looks good to me. > > Looks good to me too. David and Julien, thanks for the review! I'd like to wait for Pierre's opinion about this change before committing the patch. Pierre, could you share your opinion about this change? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION