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 1k95bA-0008Nm-EL for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Aug 2020 11:52:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k95b8-0001fR-4x for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Aug 2020 11:52:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k95b7-0001fK-U3 for pgsql-hackers@lists.postgresql.org; Fri, 21 Aug 2020 11:52:41 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k95b5-0004a8-C8 for pgsql-hackers@lists.postgresql.org; Fri, 21 Aug 2020 11:52:40 +0000 Received: from hnk.local (p12054-ipngn2901funabasi.chiba.ocn.ne.jp [153.212.171.54]) by oss.nttdata.com (Postfix) with ESMTPSA id 40941604E0; Fri, 21 Aug 2020 20:52:35 +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: Pierre Giraud , pgsql-hackers@lists.postgresql.org, depesz@depesz.com, depesz@gmail.com 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> <0d074a53-fd91-b1dd-a529-173d07627465@oss.nttdata.com> <4e932e5e-8d86-4dcd-632e-f7c6e2c35a83@dalibo.com> From: Fujii Masao Message-ID: Date: Fri, 21 Aug 2020 20:52: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: <4e932e5e-8d86-4dcd-632e-f7c6e2c35a83@dalibo.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020/08/21 14:54, Pierre Giraud wrote: > Le 20/08/2020 à 17:41, Fujii Masao a écrit : >> >> >> 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? > > It looks good to me too. Thanks a lot! Pushed. Thanks! > Let's not forget to notify Hubert (depesz) once integrated. You're going to do that? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION