Add planner expectations for Memoize in EXPLAIN

5697

Title

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

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