Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)

From: Pierre Giraud <pierre(dot)giraud(at)dalibo(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)
Date: 2020-08-20 08:03:12
Message-ID: 2fd56df7-ec7f-5c8a-0268-33be181438e9@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)fujii(at)oss(dot)nttdata(dot)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,
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2020-08-20 08:07:57 Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)
Previous Message Fujii Masao 2020-08-20 07:58:38 Re: [PG13] Planning (time + buffers) data structure in explain plan (format text)