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

From: Lukas Fittl <lukas(at)fittl(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Andrei Lepikhov <lepihov(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Daniel Gustafsson <daniel(at)yesql(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
Subject: Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Date: 2025-07-29 03:59:35
Message-ID: CAP53Pkyi+YOMF9Z7YvurCM20=Tpci7p4F1kV298er8k4Bv77bA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jul 28, 2025 at 8:26 PM David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2025-07-29 04:00:01 Re: Improve error reporting in 027_stream_regress test
Previous Message David G. Johnston 2025-07-29 03:54:04 Re: implement CAST(expr AS type FORMAT 'template')