MIME-Version: 1.0
References: 
 <CAP53Pky29GWAVVk3oBgKBDqhND0BRBN6yTPeguV_qSivFL5N_g@mail.gmail.com>
 <CA+TgmobDHmaNTqi5yLPJoW6fTCuiWOgF9CSCSHX_OTLmGxYRUQ@mail.gmail.com>
 <CAApHDvqYL3OVvOsyvEPsDJ7h4zQh=LEygQgcQSN-TemRJLMb6Q@mail.gmail.com>
 <3ea66a50-e4b0-4f20-ae0c-4d9cbaf81cfb@tantorlabs.com>
 <CAApHDvpuM8jW-BGu7B=i6uv+jmndEo-2z_BYvj5JNmx=qV-uSQ@mail.gmail.com>
 <0e8dc4fa-3655-4e9f-9424-9b32a15e6acd@tantorlabs.com>
 <CAApHDvqmyHuEt7rdFLJr4cZecbhno5OZ6iL5EQNNu9Oi1f93sQ@mail.gmail.com>
 <7e995158-157e-4ec6-a7c8-266c1a6f7b43@tantorlabs.com>
 <CAApHDvq0Zz3+nh9hPRBP-oAocFZETfhdE_jcN8aG+Thc24Zk5g@mail.gmail.com>
 <06840539-e321-4930-9f89-cfc783c5b80a@tantorlabs.com>
 <15e0422a-31ec-4e82-b0cf-0839f636b185@tantorlabs.com>
 <5c7034c4-c48b-428b-ab3f-67f14d9f542e@tantorlabs.com>
 <CAApHDvq+uqf3MRFb+Ai3W1k3fMnrwWBLhzUAYj3_+MM8jK32fA@mail.gmail.com>
 <34407b2d-946b-40cd-a665-49ca6af62fb9@gmail.com>
 <CAApHDvr-0MLz58OPgzFdOfVouCGFm23iO4Bn_4hLBgCLzG+==w@mail.gmail.com>
 <3a4bff1b-f6d5-41d4-b956-2da25bed0aae@tantorlabs.com>
 <CAApHDvp2nD4zndtHRfk30LzAXHPm7jorDo0SVtqaQiLtppFjaA@mail.gmail.com>
In-Reply-To: 
 <CAApHDvp2nD4zndtHRfk30LzAXHPm7jorDo0SVtqaQiLtppFjaA@mail.gmail.com>
From: Lukas Fittl <lukas@fittl.com>
Date: Mon, 28 Jul 2025 20:59:35 -0700
Message-ID: 
 <CAP53Pkyi+YOMF9Z7YvurCM20=Tpci7p4F1kV298er8k4Bv77bA@mail.gmail.com>
Subject: Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost
 adjustment
To: David Rowley <dgrowleyml@gmail.com>
Cc: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>,
 Andrei Lepikhov <lepihov@gmail.com>,
	Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Daniel Gustafsson <daniel@yesql.se>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	Nikolay Samokhvalov <samokhvalov@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000f177b7063b0971ed"
Archived-At: 
 <https://www.postgresql.org/message-id/CAP53Pkyi%2BYOMF9Z7YvurCM20%3DTpci7p4F1kV298er8k4Bv77bA%40mail.gmail.com>
Precedence: bulk

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

On Mon, Jul 28, 2025 at 8:26=E2=80=AFPM David Rowley <dgrowleyml@gmail.com>=
 wrote:

> I understand not everyone got what they wanted here, but I hope what's
> been added is ok for the majority of people.
>

For what its worth, the last version you posted (v11) looks good to me as
well, and +1 on the "Estimates:" style that puts them all on one line in
text mode.

I think this will help a lot in understanding Memoize's impact on plans
better, thanks everyone for pushing this forward!

Thanks,
Lukas

--=20
Lukas Fittl

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jul 28, 2025 at =
8:26=E2=80=AFPM David Rowley &lt;<a href=3D"mailto:dgrowleyml@gmail.com" ta=
rget=3D"_blank">dgrowleyml@gmail.com</a>&gt; wrote:</div><div class=3D"gmai=
l_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex">I understand not=
 everyone got what they wanted here, but I hope what&#39;s<br>
been added is ok for the majority of people.<br></blockquote></div><div><br=
 clear=3D"all"></div><div>For what its worth, the last version you posted (=
v11) looks good to me as well, and=C2=A0+1=C2=A0on the &quot;Estimates:&quo=
t; style that puts them all on one line in text mode.</div><div><br></div><=
div>I think this will help a lot in understanding Memoize&#39;s impact on p=
lans better, thanks everyone for pushing this forward!</div><div><br></div>=
<div>Thanks,</div><div>Lukas</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">Lukas Fittl</div></=
div></div></div></div></div></div>
</div>

--000000000000f177b7063b0971ed--