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 1rUUuy-00BHa7-0P for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jan 2024 16:55:32 +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 1rUUux-00FirC-7P for pgsql-committers@arkaria.postgresql.org; Mon, 29 Jan 2024 16:55:31 +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 1rUUux-00Fir2-0i for pgsql-committers@lists.postgresql.org; Mon, 29 Jan 2024 16:55:31 +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.94.2) (envelope-from ) id 1rUUuu-004019-Fj for pgsql-committers@lists.postgresql.org; Mon, 29 Jan 2024 16:55:29 +0000 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 1rUUut-00C6RT-Uz for pgsql-committers@lists.postgresql.org; Mon, 29 Jan 2024 16:55:27 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rUUut-003iEY-FZ for pgsql-committers@lists.postgresql.org; Mon, 29 Jan 2024 16:55:27 +0000 Content-Type: multipart/mixed; boundary="===============4977511183639722538==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add EXPLAIN (MEMORY) to report planner memory consumption X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Jan 2024 16:55:27 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4977511183639722538== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIEVYUExBSU4gKE1FTU9SWSkgdG8gcmVwb3J0IHBsYW5uZXIgbWVtb3J5IGNvbnN1bXB0aW9u CgpUaGlzIGFkZHMgYSBuZXcgIk1lbW9yeToiIGxpbmUgdW5kZXIgdGhlICJQbGFubmluZzoiIGdy b3VwICh3aGljaApjdXJyZW50bHkgb25seSBoYXMgIkJ1ZmZlcnM6Iikgd2hlbiB0aGUgTUVNT1JZ IG9wdGlvbiBpcyBzcGVjaWZpZWQuCgpJbiBvcmRlciB0byBtYWtlIHRoZSByZXBvcnRpbmcgcmVh c29uYWJseSBhY2N1cmF0ZSwgd2UgY3JlYXRlIGEgc2VwYXJhdGUKbWVtb3J5IGNvbnRleHQgZm9y IHBsYW5uZXIgYWN0aXZpdGllcywgdG8gYmUgdXNlZCBvbmx5IHdoZW4gdGhpcyBvcHRpb24KaXMg Z2l2ZW4uICBUaGUgdG90YWwgYW1vdW50IG9mIG1lbW9yeSBhbGxvY2F0ZWQgYnkgdGhhdCBjb250 ZXh0IGlzCnJlcG9ydGVkIGFzICJhbGxvY2F0ZWQiOyB3ZSBzdWJ0cmFjdCBtZW1vcnkgaW4gdGhl IGNvbnRleHQncyBmcmVlbGlzdHMKZnJvbSB0aGF0IGFuZCByZXBvcnQgdGhhdCByZXN1bHQgYXMg InVzZWQiLiAgV2UgdXNlCk1lbW9yeUNvbnRleHRTdGF0c0ludGVybmFsKCkgdG8gb2J0YWluIHRo ZSBxdWFudGl0aWVzLgoKVGhlIGNvZGUgc3RydWN0dXJlIHRvIHNob3cgYnVmZmVyIHVzYWdlIGR1 cmluZyBwbGFubmluZyB3YXMgbm90IGluCmFtYXppbmcgc2hhcGUsIHNvIEkgKMOBbHZhcm8pIG1v ZGlmaWVkIHRoZSBwYXRjaCBhIGJpdCB0byBjbGVhbiB0aGF0IHVwCmluIHBhc3NpbmcuCgpBdXRo b3I6IEFzaHV0b3NoIEJhcGF0ClJldmlld2VkLWJ5OiBEYXZpZCBSb3dsZXksIEFuZHJleSBMZXBp a2hvdiwgSmlhbiBIZSwgQW5keSBGYW4KRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWVzc2FnZS1pZC9DQUV4SFc1c1pBPTVMSl9aUHBSTy13MDljazh6OXA3ZWFZQXFxM0tz OUdEZmhyeGVXQndAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81ZGU4OTBl MzYxMGQ1YTEyY2RhZWEzNjQxM2Q5NjdjZjVjNTQ0ZTIwCgpNb2RpZmllZCBGaWxlcwotLS0tLS0t LS0tLS0tLQpjb250cmliL2F1dG9fZXhwbGFpbi9hdXRvX2V4cGxhaW4uYyAgIHwgICAyICsKZG9j L3NyYy9zZ21sL3JlZi9leHBsYWluLnNnbWwgICAgICAgICB8ICAxNCArKysrCnNyYy9iYWNrZW5k L2NvbW1hbmRzL2V4cGxhaW4uYyAgICAgICAgfCAxNTIgKysrKysrKysrKysrKysrKysrKysrKysr KysrKy0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy9wcmVwYXJlLmMgICAgICAgIHwgIDIyICsr KystCnNyYy9iYWNrZW5kL3V0aWxzL21tZ3IvbWN4dC5jICAgICAgICAgfCAgMTMgKysrCnNyYy9p bmNsdWRlL2NvbW1hbmRzL2V4cGxhaW4uaCAgICAgICAgfCAgIDQgKy0Kc3JjL2luY2x1ZGUvdXRp bHMvbWVtdXRpbHMuaCAgICAgICAgICB8ICAgMiArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv ZXhwbGFpbi5vdXQgfCAgNzYgKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv ZXhwbGFpbi5zcWwgICAgICB8ICAgOCArKwo5IGZpbGVzIGNoYW5nZWQsIDI2NSBpbnNlcnRpb25z KCspLCAyOCBkZWxldGlvbnMoLSkKCg== --===============4977511183639722538==--