Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ugmDu-007EwI-Sk for pgsql-committers@arkaria.postgresql.org; Tue, 29 Jul 2025 15:26:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ugmDt-002Rp9-Hc for pgsql-committers@arkaria.postgresql.org; Tue, 29 Jul 2025 15:26:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ugarD-00Dj9n-Ho for pgsql-committers@lists.postgresql.org; Tue, 29 Jul 2025 03:18:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ugarB-001JHW-3A for pgsql-committers@lists.postgresql.org; Tue, 29 Jul 2025 03:18:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=+aMctfDLhZlrTPNh0aKqDnNvxsijMauK52tYBaDhBa4=; b=loxZ2CpU+UBAz3v2xbfSU1r4OK MvgCh9dottzHSVzovha618h4zRFGnWYBpscPEhtqo4tf27go34OoSoAnPWnWfkMJCo3PRMv6SteYn 41RWISnfyK/WFphP+ge0719nmIKH9zTDNz6fq2lPEoDS6i0ks3TSk4ccZSSt1fFZT+WgsQWNzTvKv eyVkhI32hCDv5VuwHDvvIL3DRTCxoPbGaCaJU6pZ84LZUvKTHHdJw849aJQEOEk6FFypa93wz5g/Q hRr7ttO3bgkCHIKc5aRMyHS50wShwmqFkPZzDT8IrOpkPPiXz4zNFmYU+2W3djSk4dyyOc7LmvZNS sjDVND6g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ugarA-003i4N-33 for pgsql-committers@lists.postgresql.org; Tue, 29 Jul 2025 03:18:25 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ugarA-001F32-2M for pgsql-committers@lists.postgresql.org; Tue, 29 Jul 2025 03:18:25 +0000 Content-Type: multipart/mixed; boundary="===============4127601983678828942==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Display Memoize planner estimates in EXPLAIN X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 29 Jul 2025 03:18:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4127601983678828942== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RGlzcGxheSBNZW1vaXplIHBsYW5uZXIgZXN0aW1hdGVzIGluIEVYUExBSU4KClRoZXJlJ3ZlIGJl ZW4gYSBmZXcgY29tcGxhaW50cyB0aGF0IGl0IGNhbiBiZSBvdmVybHkgZGlmZmljdWx0IHRvIGZp Z3VyZQpvdXQgd2h5IHRoZSBwbGFubmVyIHBpY2tlZCBhIE1lbW9pemUgcGxhbi4gIFRvIGhlbHAg YWRkcmVzcyB0aGF0LCBoZXJlIHdlCmFkanVzdCB0aGUgRVhQTEFJTiBvdXRwdXQgdG8gZGlzcGxh eSB0aGUgZm9sbG93aW5nIGFkZGl0aW9uYWwgZGV0YWlsczoKCjEpIFRoZSBlc3RpbWF0ZWQgbnVt YmVyIG9mIGNhY2hlIGVudHJpZXMgdGhhdCBjYW4gYmUgc3RvcmVkIGF0IG9uY2UKMikgVGhlIGVz dGltYXRlZCBudW1iZXIgb2YgdW5pcXVlIGxvb2t1cCBrZXlzIHRoYXQgd2UgZXhwZWN0IHRvIHNl ZQozKSBUaGUgbnVtYmVyIG9mIGxvb2t1cHMgd2UgZXhwZWN0CjQpIFRoZSBlc3RpbWF0ZWQgaGl0 IHJhdGlvCgpUZWNobmljYWxseSAjNCBjYW4gYmUgY2FsY3VsYXRlZCB1c2luZyAjMSwgIzIgYW5k ICMzLCBidXQgaXQncyBub3QgYQpwYXJ0aWN1bGFybHkgb2J2aW91cyBjYWxjdWxhdGlvbiwgc28g d2Ugb3B0IHRvIGRpc3BsYXkgaXQgZXhwbGljaXRseS4KVGhlIG9yaWdpbmFsIHBhdGNoIGJ5IEx1 a2FzIEZpdHRsIG9ubHkgZGlzcGxheWVkIHRoZSBoaXQgcmF0aW8sIGJ1dAp0aGVyZSB3YXMgYSBm ZWFyIHRoYXQgbWlnaHQgbGVhZCB0byBtb3JlIHF1ZXN0aW9ucyBhYm91dCBob3cgdGhhdCB3YXMK Y2FsY3VsYXRlZC4gIFRoZSBpZGVhIHdpdGggZGlzcGxheWluZyBhbGwgNCBpcyB0byBiZSB0cmFu c3BhcmVudCB3aGljaAptYXkgYWxsb3cgcXVlcmllcyB0byBiZSB0dW5lZCBtb3JlIGVhc2lseS4g IEZvciBleGFtcGxlLCBpZiAjMiBpc24ndApjb3JyZWN0IHRoZW4gbWF5YmUgZXh0ZW5kZWQgc3Rh dGlzdGljcyBvciBhIG1hbnVhbCBuX2Rpc3RpbmN0IGVzdGltYXRlIGNhbgpiZSB1c2VkIHRvIGhl bHAgZml4IHBvb3IgcGxhbiBjaG9pY2VzLgoKQXV0aG9yOiBJbGlhIEV2ZG9raW1vdiA8aWx5YS5l dmRva2ltb3ZAdGFudG9ybGFicy5jb20+CkF1dGhvcjogTHVrYXMgRml0dGwgPGx1a2FzQGZpdHRs LmNvbT4KUmV2aWV3ZWQtYnk6IERhdmlkIFJvd2xleSA8ZGdyb3dsZXltbEBnbWFpbC5jb20+ClJl dmlld2VkLWJ5OiBBbmRyZWkgTGVwaWtob3YgPGxlcGlob3ZAZ21haWwuY29tPgpSZXZpZXdlZC1i eTogUm9iZXJ0IEhhYXMgPHJvYmVydG1oYWFzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6 Ly9wb3N0Z3IuZXMvbS9DQVA1M1BreTI5R1dBVlZrM29CZ0tCRHFoTkQwQlJCTjZ5VFBlZ3VWX3FT aXZGTDVOX2clNDBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzRiYzYyYjg2 ODQ5MDY1OTM5YTZiODUyNzNmZWNlNmI5MmQ2ZTk3YmYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2V4cGxhaW4uYyAgICAgICAgICB8IDIxICsrKysr KysrKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAg fCAxOCArKysrKysrKysrKystLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vY3JlYXRl cGxhbi5jIHwgMTUgKysrKysrKysrKysrLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3Bh dGhub2RlLmMgICB8IDExICsrKysrKysrLS0tCnNyYy9pbmNsdWRlL25vZGVzL3BhdGhub2Rlcy5o ICAgICAgICAgICB8ICA0ICsrKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGxhbm5vZGVzLmggICAgICAg ICAgIHwgMTAgKysrKysrKysrKwpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aG5vZGUuaCAgICAg ICAgfCAgMiArLQo3IGZpbGVzIGNoYW5nZWQsIDY2IGluc2VydGlvbnMoKyksIDE1IGRlbGV0aW9u cygtKQoK --===============4127601983678828942==--