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

Edit
ID 4236
Title Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Monitoring & Control
Tags
Created 2023-03-05 00:22:58
Last modified 2023-09-01 12:35:41 (2 years ago)
Latest email 2025-07-29 03:59:35 (2 months ago)
Status
2023-09 (2023-09-01 – 2023-09-30): Returned with feedback
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
Target version
Authors Lukas Fittl (lfittl)
Reviewers Become reviewer
Committer
Links
Emails
Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
First at 2023-03-05 00:20:59 by Lukas Fittl <lukas at fittl.com>
Latest at 2025-07-29 03:59:35 by Lukas Fittl <lukas at fittl.com>
Latest attachment (v11-0001-Expose-cache-hit-statistics-in-Memoize-node-EXPL.patch) at 2025-07-21 22:17:36 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v11-0001-Expose-cache-hit-statistics-in-Memoize-node-EXPL.patch) at 2025-07-21 22:17:36 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Expose-cache-hit-statistics-in-Memoize-node-EXPLAIN.patch) at 2025-07-04 08:30:53 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v9-0001-Expose-cache-hit-statistics-in-Memoize-node-EXPLAIN.patch) at 2025-05-01 12:22:34 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v8-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Mem.patch) at 2025-04-15 22:09:20 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v7-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Mem.patch) at 2025-04-14 23:14:37 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v6-0001-Display-estimated-distinct-keys-and-cache-capacity.patch) at 2025-04-02 09:35:33 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v5-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Memoize.patch) at 2025-03-28 12:20:44 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v4-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Memoize.patch) at 2025-03-21 10:08:14 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v3-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Memoize.patch) at 2025-03-20 14:03:25 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v2-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Memoize.patch) at 2025-03-20 08:47:56 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v1-0001-Add-Estimated-Cache-Hit-Ratio-for-Memoize-plan-no.patch) at 2023-03-05 00:20:59 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
History
When Who What
2023-09-01 12:35:41 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Returned with feedback
2023-08-01 18:03:29 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-06 07:27:58 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2023-03-05 00:23:14 Lukas Fittl (lfittl) Changed authors to Lukas Fittl (lfittl)
2023-03-05 00:22:58 Lukas Fittl (lfittl) Attached mail thread CAP53Pky29GWAVVk3oBgKBDqhND0BRBN6yTPeguV_qSivFL5N_g@mail.gmail.com
2023-03-05 00:22:58 Lukas Fittl (lfittl) Created patch record
Edit