Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment

Lukas Fittl <lukas@fittl.com>

From: Lukas Fittl <lukas@fittl.com>
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>
Date: 2025-07-29T03:59:35Z
Lists: pgsql-hackers
On Mon, Jul 28, 2025 at 8:26 PM 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

-- 
Lukas Fittl