| From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| 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 15:50:36 |
| Message-ID: | CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
Cheers,
Greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Jackson | 2024-11-20 15:51:12 | Add Option To Check All Addresses For Matching target_session_attr |
| Previous Message | Fujii Masao | 2024-11-20 15:43:46 | Re: Add reject_limit option to file_fdw |