Add planner expectations for Memoize in EXPLAIN

5697

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v10, Patch count: 1, First patch: +65−3, All patches: +65−3

Topic

Performance

Tags

Created

2025-04-14 07:54:20

Last modified

2025-04-14 07:56:46 (2 months ago)

Latest email

2025-07-04 08:30:53 (2 days ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

Target version

Authors

Ilia Evdokimov (ilidock95)

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-04 08:30:53 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest 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>
    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-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