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 1rmhoJ-009O76-BF for pgsql-committers@arkaria.postgresql.org; Tue, 19 Mar 2024 22:19:55 +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 1rmhoH-000rhA-7k for pgsql-committers@arkaria.postgresql.org; Tue, 19 Mar 2024 22:19:53 +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 1rmhoH-000rh2-0b for pgsql-committers@lists.postgresql.org; Tue, 19 Mar 2024 22:19:53 +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 1rmho9-005OUD-An for pgsql-committers@lists.postgresql.org; Tue, 19 Mar 2024 22:19:52 +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 1rmho8-00ElK5-Mj for pgsql-committers@lists.postgresql.org; Tue, 19 Mar 2024 22:19:45 +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 1rmho7-004evd-6q for pgsql-committers@lists.postgresql.org; Tue, 19 Mar 2024 22:19:43 +0000 Content-Type: multipart/mixed; boundary="===============9020297134188181401==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve EXPLAIN's display of SubPlan nodes and output parameters X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 19 Mar 2024 22:19:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============9020297134188181401== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBFWFBMQUlOJ3MgZGlzcGxheSBvZiBTdWJQbGFuIG5vZGVzIGFuZCBvdXRwdXQgcGFy YW1ldGVycy4KCkhpc3RvcmljYWxseSB3ZSd2ZSBwcmludGVkIFN1YlBsYW4gZXhwcmVzc2lvbiBu b2RlcyBhcyAiKFN1YlBsYW4gTikiLAp3aGljaCBpcyBwcmV0dHkgdW5pbmZvcm1hdGl2ZS4gIFRy eWluZyB0byByZXByb2R1Y2UgdGhlIG9yaWdpbmFsIFNRTApmb3IgdGhlIHN1YnF1ZXJ5IGlzIHN0 aWxsIGFzIGltcHJhY3RpY2FsIGFzIGJlZm9yZSwgYW5kIHdvdWxkIGJlCm1pZ2h0eSB2ZXJib3Nl IGFzIHdlbGwuICBIb3dldmVyLCB3ZSBjYW4gc3RpbGwgZG8gYmV0dGVyIHRoYW4gdGhhdC4KRGlz cGxheWluZyB0aGUgInRlc3RleHByIiB3aGVuIHByZXNlbnQsIGFuZCBhZGRpbmcgYSBrZXl3b3Jk IHRvCmluZGljYXRlIHRoZSBTdWJMaW5rVHlwZSwgZ29lcyBhIGxvbmcgd2F5IHRvd2FyZCBzaG93 aW5nIHdoYXQncwpyZWFsbHkgZ29pbmcgb24uCgpJbiBhZGRpdGlvbiwgdGhpcyBwYXRjaCBnZXRz IHJpZCBvZiBFWFBMQUlOJ3MgdXNlIG9mICIkbiIgdG8gcmVwcmVzZW50CnN1YnBsYW4gYW5kIGlu aXRwbGFuIG91dHB1dCBQYXJhbXMuICBJbnN0ZWFkIHdlIG5vdyBwcmludCAiKFN1YlBsYW4KTiku Y29sWCIgb3IgIihJbml0UGxhbiBOKS5jb2xYIiB0byByZXByZXNlbnQgdGhlIFgndGggb3V0cHV0 IGNvbHVtbgpvZiB0aGF0IHN1YnBsYW4uICBUaGlzIGVsaW1pbmF0ZXMgY29uZnVzaW9uIHdpdGgg dGhlIHVzZSBvZiAiJG4iIHRvCnJlcHJlc2VudCBQQVJBTV9FWFRFUk4gUGFyYW1zLCBhbmQgaXQn cyB1c2VmdWwgZm9yIHRoZSBmaXJzdCBwYXJ0IG9mCnRoaXMgY2hhbmdlIGJlY2F1c2UgaXQgZWxp bWluYXRlcyBuZWVkaW5nIHNvbWUgb3RoZXIgaW5kaWNhdGlvbiBvZgp3aGljaCBzdWJwbGFuIGlz IHJlZmVyZW5jZWQgYnkgYSBTdWJQbGFuIHRoYXQgaGFzIGEgdGVzdGV4cHIuCgpJbiBwYXNzaW5n LCB0aGlzIGFkZHMgc2ltcGxlIHJlZ3Jlc3Npb24gdGVzdCBjb3ZlcmFnZSBvZiB0aGUKUk9XQ09N UEFSRV9TVUJMSU5LIGNvZGUgcGF0aHMsIHdoaWNoIHdlcmUgZW50aXJlbHkgdW5idXJkZW5lZApi eSB0ZXN0aW5nIGJlZm9yZS4KClRvbSBMYW5lIGFuZCBEZWFuIFJhc2hlZWQsIHJldmlld2VkIGJ5 IEFsZWtzYW5kZXIgQWxla3NlZXYuClRoYW5rcyB0byBDaGFudGFsIEtlbGxlciBmb3IgcmFpc2lu ZyB0aGUgcXVlc3Rpb24gb2Ygd2hldGhlcgp0aGlzIGFyZWEgY291bGRuJ3QgYmUgaW1wcm92ZWQu CgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzI4Mzg1MzguMTcwNTY5Mjc0N0Bzc3Mu cGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZmQwMzk4ZmNiMDk5OTgwZmJlZGJiNzc1 MDM1NmVmMjM0NDA4YzFjOQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9w b3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8ICAzNCArLS0KZG9jL3NyYy9z Z21sL3BlcmZvcm0uc2dtbCAgICAgICAgICAgICAgICAgICAgICB8IDEwMiArKysrKysrKy0Kc3Jj L2JhY2tlbmQvY29tbWFuZHMvZXhwbGFpbi5jICAgICAgICAgICAgICAgICB8ICAzMiAtLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vc3Vic2VsZWN0LmMgICAgICAgICB8ICAyMiArLQpzcmMv YmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAgICAgICAgICAgIHwgMjMxICsrKysrKysr KysrKysrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9hZ2dyZWdhdGVzLm91dCAgICAg ICB8ICA0OCArKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ3JvdXBpbmdzZXRzLm91dCAg ICAgfCAgMjAgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmhlcml0Lm91dCAgICAgICAg ICB8ICAzMCArLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbnNlcnRfY29uZmxpY3Qub3V0 ICB8ICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICAgICAg IHwgIDI2ICstLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL21lbW9pemUub3V0ICAgICAgICAg IHwgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWVyZ2Uub3V0ICAgICAgICAgICAg fCAgIDYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fcHJ1bmUub3V0ICB8 IDI5MiArKysrKysrKysrKystLS0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv cG9ydGFscy5vdXQgICAgICAgICAgfCAgMTIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9y b3dzZWN1cml0eS5vdXQgICAgICB8IDEyMiArKysrKy0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL3Jvd3R5cGVzLm91dCAgICAgICAgIHwgICA4ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvc2VsZWN0X3BhcmFsbGVsLm91dCAgfCAgMzcgKystLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL3NxbGpzb24ub3V0ICAgICAgICAgIHwgICA0ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvc3Vic2VsZWN0Lm91dCAgICAgICAgfCAxNTcgKysrKysrKystLS0tLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3VwZGF0YWJsZV92aWV3cy5vdXQgIHwgIDQwICsrLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC91cGRhdGUub3V0ICAgICAgICAgICB8ICAgOCArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3dpbmRvdy5vdXQgICAgICAgICAgIHwgICAyICstCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvd2l0aC5vdXQgICAgICAgICAgICAgfCAgIDYgKy0Kc3JjL3Rlc3QvcmVn cmVzcy9zcWwvc3Vic2VsZWN0LnNxbCAgICAgICAgICAgICB8ICAxNCArKwoyNCBmaWxlcyBjaGFu Z2VkLCA3OTMgaW5zZXJ0aW9ucygrKSwgNDY0IGRlbGV0aW9ucygtKQoK --===============9020297134188181401==--