Add planner expectations for Memoize in EXPLAIN

Edit
ID 5697
Title Add planner expectations for Memoize in EXPLAIN
CI (CFBot) Summary
Stats (from CFBot) Patch version: v11, Patch count: 1, First patch: +62−12, All patches: +62−12
Topic Performance
Tags Performance
Created 2025-04-14 07:54:20
Last modified 2025-07-29 08:04:39 (yesterday)
Latest email 2025-07-29 03:59:35 (yesterday)
Status
PG19-1 (2025-07-01 - 2025-07-31): Committed
Target version 19
Authors Ilia Evdokimov (ilidock95)
Reviewers Become reviewer
Committer David Rowley (davidrowley)
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
2025-07-29 08:04:39 Ilia Evdokimov (ilidock95) Closed in commitfest PG19-1 with status: Committed
2025-07-29 08:04:39 Ilia Evdokimov (ilidock95) Changed committer to davidrowley
2025-07-18 12:07:49 Ilia Evdokimov (ilidock95) Changed tags to Performance
2025-04-14 07:56:46 Ilia Evdokimov (ilidock95) Changed name to Add planner expectations for Memoize in EXPLAIN
2025-04-14 07:54:20 Ilia Evdokimov (ilidock95) Attached mail thread CAP53Pky29GWAVVk3oBgKBDqhND0BRBN6yTPeguV_qSivFL5N_g@mail.gmail.com
2025-04-14 07:54:20 Ilia Evdokimov (ilidock95) Created patch record
Edit