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

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

To: David Rowley <dgrowleyml@gmail.com>

Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Lukas Fittl <lukas@fittl.com>, Daniel Gustafsson <daniel@yesql.se>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Nikolay Samokhvalov <samokhvalov@gmail.com>, Andrei Lepikhov <lepihov@gmail.com>

Date: 2025-04-15T22:09:20Z

Lists: pgsql-hackers

Attachments

v8-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Mem.patch (text/x-patch)
v8-0002-Add-Estimated-Hit-Ratio-for-Memoize-plan-nodes-in.patch (text/x-patch)
v8-0003-Show-estimated-lookups-in-EXPLAIN-ouput-for-Memoi.patch (text/x-patch)

I've prepared the updated patches as discussed, including the addition 
of estimated lookups in the EXPLAIN output for Memoize. Please let me 
know if you have any feedback or further suggestions.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.