Add planner expectations for Memoize in EXPLAIN

5697

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v8, Patch count: 3, First patch: +40−3, All patches: +65−3

Topic

Performance

Created

2025-04-14 07:54:20

Last modified

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

Latest email

2025-04-15 22:09:20 (14 hours ago)

Status

2025-07: 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-04-15 22:09:20 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest 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>
    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