Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) - Mailing list pgsql-hackers

From Pierre Giraud
Subject Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)
Date
Msg-id 2fd56df7-ec7f-5c8a-0268-33be181438e9@dalibo.com
Whole thread Raw
In response to Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
Can you please show what the plan would look like for?

=# explain (buffers on, summary on, format JSON) select * from t;



Le 20/08/2020 à 09:58, Fujii Masao a écrit :
> 
> 
> On 2020/08/20 13:00, David Rowley wrote:
>> On Thu, 20 Aug 2020 at 03:31, Fujii Masao
>> <masao.fujii@oss.nttdata.com> wrote:
>>> With the patch, for example, whatever "summary" settng is, "buffers on"
>>> displays the planner's buffer usage if it happens.
>>
>> 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.
> 
> Regards,
> 



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)
Next
From: Fujii Masao
Date:
Subject: Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)