MIME-Version: 1.0
References: <CANNMO++9W_UA8PB9AkDRF3JBv4K7K1FnisrXTjicL+WZhwUJzw@mail.gmail.com>
 <CA+TgmoZF7PbO7DB_VMQS4664EgOdObhFtAoLUb83bp3i-623UQ@mail.gmail.com>
 <CANNMO++d9CKuJEzSnRWFCHcmKr2DGASTtEMZ9bpEYHSa4QFQvA@mail.gmail.com>
 <3076356.1730831425@sss.pgh.pa.us> <CANNMO++W7MM8T0KyXN3ZheXXt-uLVM3aEtZd+WNfZ=obxffUiA@mail.gmail.com>
 <CAKFQuwbLq3GWoJw-zNa43pkcfg5gh4gGQKMptQtp4qX_nQL9AQ@mail.gmail.com>
 <CAApHDvrYwEt=ueMTn39okNihZffhKgqvxedLqDJu=hmSsZ=g9Q@mail.gmail.com>
 <CAFwT4nC5255GkSt1WEfTHi6cwUuY4fjUmH15nD91c1JvNoOxNA@mail.gmail.com>
 <CAECtzeUKbyZNuFRu4DTr_3p44egDXGbPpGonixqJninWXyBvnQ@mail.gmail.com>
 <CA+TgmobY4N3QYWTW4bj9K=gG3Q4rTAsZLvi_=ODZYRBpk=ZVNA@mail.gmail.com>
 <CAECtzeVvrjxXmE3TB9zz3MD_RwiE=MCg2Xjx0HXoSn4e-VRSOg@mail.gmail.com>
 <CAECtzeWpusNrZADkQ01ZZL_fFtOWtwtnw_uixqy9hgK0qUCScQ@mail.gmail.com>
 <CA+TgmoZO2HtDGHf7K4rmNdfUGuS=ngsPgwrH=JdyF6Okcnzfkw@mail.gmail.com>
 <CAECtzeW=yo4H-G8rBheWwiET-e+PaBpOHHaL9Yu0JpYTd557_Q@mail.gmail.com>
 <CAKAnmmLOkvJ85MGyouFBr2tS+0TSZ87=t=8iaZKU25WG98nZaw@mail.gmail.com> <CAECtzeUwpK5gNWQqoK4ZjwXANtdE2fWirJyaBDqkytPzfWZqzg@mail.gmail.com>
In-Reply-To: <CAECtzeUwpK5gNWQqoK4ZjwXANtdE2fWirJyaBDqkytPzfWZqzg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 20 Nov 2024 10:50:36 -0500
Message-ID: <CAKAnmm+QQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp=NQ@mail.gmail.com>
Subject: Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Robert Haas <robertmhaas@gmail.com>, Michael Christofides <michael@pgmustard.com>, 
	David Rowley <dgrowleyml@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>, 
	Nikolay Samokhvalov <samokhvalov@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000008139d006275a1e26"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BQQP-dTkjsDVbEcphrdXqCTq-ALTCMUwPaYWZmqUp%3DNQ%40mail.gmail.com>
Precedence: bulk

--0000000000008139d006275a1e26
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 20, 2024 at 1:26=E2=80=AFAM Guillaume Lelarge <guillaume@lelarg=
e.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=3D5
>          Buffers: shared hit=3D2 read=3D5 written=3D4

...

>  Planning:
>    Buffers: shared hit=3D289 dirtied=3D9


Cheers,
Greg

--0000000000008139d006275a1e26
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Nov 20, 2024 at 1:26=E2=80=AFAM G=
uillaume Lelarge &lt;<a href=3D"mailto:guillaume@lelarge.info">guillaume@le=
large.info</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">OK, but I&#39;m not sure which exam=
ple I should pick to add dirtied and written shared buffers. It looks kinda=
 artificial. Should I choose one randomly?</div></div></div></blockquote><d=
iv><br></div><div>It will be artificial, but I think that&#39;s ok: anyone =
running=C2=A0it on their own will be getting different numbers anyway. I wa=
s looking at the &quot;14.1.2 EXPLAIN ANALYZE&quot; section in perform.sgml=
. Here&#39;s some actual numbers I got with some playing around=C2=A0with c=
oncurrent updates:</div><div><br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Recheck Cond: (unique1 &lt;=
 10)<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Heap Blocks: exact=3D5<br>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0Buffers: shared hit=3D2 read=3D5 written=3D4</bl=
ockquote><div>...</div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
=C2=A0Planning:<br>=C2=A0 =C2=A0Buffers: shared hit=3D289 dirtied=3D9</bloc=
kquote><div><br></div><div>Cheers,</div><div>Greg</div><div><br></div></div=
></div>

--0000000000008139d006275a1e26--