| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Michael Christofides <michael(at)pgmustard(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE |
| Date: | 2024-11-20 19:30:08 |
| Message-ID: | CAECtzeVkkmvmHWVOTzwpX_GX+k4h7EWAyfERqes9C0z4pzMN2A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Le mer. 20 nov. 2024 à 16:51, Greg Sabino Mullane <htamfids(at)gmail(dot)com> a
écrit :
> On Wed, Nov 20, 2024 at 1:26 AM Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
>
>> OK, but I'm not sure which example I should pick to add dirtied and
>> written shared buffers. It looks kinda artificial. Should I choose one
>> randomly?
>>
>
> It will be artificial, but I think that's ok: anyone running it on their
> own will be getting different numbers anyway. I was looking at the "14.1.2
> EXPLAIN ANALYZE" section in perform.sgml. Here's some actual numbers I got
> with some playing around with concurrent updates:
>
> Recheck Cond: (unique1 < 10)
>> Heap Blocks: exact=5
>> Buffers: shared hit=2 read=5 written=4
>
> ...
>
>> Planning:
>> Buffers: shared hit=289 dirtied=9
>
>
>
OK, I'm fine with this. v4 patch attached with one plan showing read,
written, and dirtied buffers.
Thanks for all your comments/reviews.
--
Guillaume.
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Enable-BUFFERS-by-default-with-EXPLAIN-ANALYZE.patch | text/x-patch | 77.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2024-11-20 19:40:05 | Re: Adding skip scan (including MDAM style range skip scan) to nbtree |
| Previous Message | David E. Wheeler | 2024-11-20 18:04:17 | Re: RFC: Additional Directory for Extensions |