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

4236

Title

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 (1 year ago)

Latest email

2025-07-29 03:59:35 (2 days 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