| From: | Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lukas Fittl <lukas(at)fittl(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Andrei Lepikhov <lepihov(at)gmail(dot)com> |
| Subject: | Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment |
| Date: | 2025-07-04 08:30:53 |
| Message-ID: | 5c7034c4-c48b-428b-ab3f-67f14d9f542e@tantorlabs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 01.05.2025 15:22, Ilia Evdokimov wrote:
> I attached updated v9 patch with the suggested changes. The updated
> line in the EXPLAIN looks like this:
>
> Text format:
> Estimates: capacity=1 distinct keys=1 lookups=2 hit percent=50.00%
>
> Non-text format:
> Estimated Capacity: 1
> Estimated Distinct Lookup Keys: 1
> Estimated Lookups: 2
> Estimated Hit Percent: 50.00
>
> Any suggestions?
I attached rebased v10 patch on 5a6c39b.
--
Best Regards,
Ilia Evdokimov,
Tantor Labs LLC.
| Attachment | Content-Type | Size |
|---|---|---|
| v10-0001-Expose-cache-hit-statistics-in-Memoize-node-EXPLAIN.patch | text/x-patch | 7.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2025-07-04 08:31:53 | Re: Add 64-bit XIDs into PostgreSQL 15 |
| Previous Message | Andrey Borodin | 2025-07-04 08:25:26 | Re: amcheck: Remove unused IndexCheckableCallback typedef |