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

From:	Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To:	David Rowley <dgrowleyml(at)gmail(dot)com>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lukas Fittl <lukas(at)fittl(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Andrei Lepikhov <lepihov(at)gmail(dot)com>
Subject:	Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Date:	2025-04-15 22:09:20
Message-ID:	7e995158-157e-4ec6-a7c8-266c1a6f7b43@tantorlabs.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-03-05 00:20:59 from Lukas Fittl <lukas(at)fittl(dot)com> 📎  2023-03-07 09:51:20 from David Rowley <dgrowleyml(at)gmail(dot)com>   2023-07-06 07:56:18 from Daniel Gustafsson <daniel(at)yesql(dot)se>    2023-07-06 08:27:26 from Lukas Fittl <lukas(at)fittl(dot)com>     2025-03-20 08:47:56 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎      2025-03-20 10:37:35 from David Rowley <dgrowleyml(at)gmail(dot)com>       2025-03-20 12:04:43 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>       2025-03-20 12:32:41 from Andrei Lepikhov <lepihov(at)gmail(dot)com>        2025-03-20 14:03:25 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎         2025-03-20 18:54:07 from Andrei Lepikhov <lepihov(at)gmail(dot)com>          2025-03-21 02:50:11 from David Rowley <dgrowleyml(at)gmail(dot)com>           2025-03-21 09:02:36 from Andrei Lepikhov <lepihov(at)gmail(dot)com>            2025-03-21 10:08:14 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎            2025-03-23 21:16:18 from David Rowley <dgrowleyml(at)gmail(dot)com>             2025-03-24 21:23:18 from Andrei Lepikhov <lepihov(at)gmail(dot)com>              2025-03-24 22:05:16 from David Rowley <dgrowleyml(at)gmail(dot)com>               2025-03-24 22:15:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2025-03-24 22:30:03 from Lukas Fittl <lukas(at)fittl(dot)com>                 2025-03-24 22:45:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2025-03-25 09:32:52 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                  2025-03-26 19:37:34 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2025-03-27 10:12:38 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>                    2025-03-27 12:46:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2025-03-27 13:46:50 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                     2025-03-28 12:20:44 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                      2025-04-01 07:52:52 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>                       2025-04-01 21:06:59 from David Rowley <dgrowleyml(at)gmail(dot)com>                        2025-04-02 09:35:33 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                         2025-04-14 09:02:41 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>                        2025-04-14 16:31:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2025-04-14 19:49:23 from Andrei Lepikhov <lepihov(at)gmail(dot)com>                         2025-04-14 20:53:05 from David Rowley <dgrowleyml(at)gmail(dot)com>                          2025-04-14 23:14:37 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                           2025-04-15 00:23:11 from David Rowley <dgrowleyml(at)gmail(dot)com>                            2025-04-15 09:44:13 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>                             2025-04-15 20:20:00 from David Rowley <dgrowleyml(at)gmail(dot)com>                              2025-04-15 22:09:20 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                               2025-04-17 21:29:37 from David Rowley <dgrowleyml(at)gmail(dot)com>                            2025-04-15 16:24:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2025-04-15 20:49:46 from David Rowley <dgrowleyml(at)gmail(dot)com>                              2025-04-16 16:09:41 from Maciek Sakrejda <maciek(at)pganalyze(dot)com>                2025-03-25 03:32:56 from David Rowley <dgrowleyml(at)gmail(dot)com>               2025-03-25 06:40:47 from Andrei Lepikhov <lepihov(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v8-0001-Show-ndistinct-and-est_entries-in-EXPLAIN-for-Mem.patch	text/x-patch	5.9 KB
v8-0002-Add-Estimated-Hit-Ratio-for-Memoize-plan-nodes-in.patch	text/x-patch	5.6 KB
v8-0003-Show-estimated-lookups-in-EXPLAIN-ouput-for-Memoi.patch	text/x-patch	4.0 KB

In response to

• Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment at 2025-04-15 20:20:00 from David Rowley

Responses

• Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment at 2025-04-17 21:29:37 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jelte Fennema-Nio	2025-04-15 22:25:43	Re: dispchar for oauth_client_secret
Previous Message	Jelte Fennema-Nio	2025-04-15 22:00:19	Re: pipelining in psql, commit 41625ab