Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oDozd-00043E-0g for pgsql-committers@arkaria.postgresql.org; Tue, 19 Jul 2022 15:18:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oDozb-0004y4-8J for pgsql-committers@arkaria.postgresql.org; Tue, 19 Jul 2022 15:18:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oDozb-0004xv-1f for pgsql-committers@lists.postgresql.org; Tue, 19 Jul 2022 15:18:35 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oDozV-0004CE-Ky for pgsql-committers@lists.postgresql.org; Tue, 19 Jul 2022 15:18:34 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oDozV-0004OF-8u for pgsql-committers@lists.postgresql.org; Tue, 19 Jul 2022 15:18:29 +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 1oDozT-000Hm7-Hp for pgsql-committers@lists.postgresql.org; Tue, 19 Jul 2022 15:18:28 +0000 Content-Type: multipart/mixed; boundary="===============4184944115777658892==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Estimate cost of elided SubqueryScan, Append, MergeAppend nodes X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 19 Jul 2022 15:18:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4184944115777658892== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RXN0aW1hdGUgY29zdCBvZiBlbGlkZWQgU3VicXVlcnlTY2FuLCBBcHBlbmQsIE1lcmdlQXBwZW5k IG5vZGVzIGJldHRlci4KCnNldHJlZnMuYyBjb250YWlucyBsb2dpYyB0byBkaXNjYXJkIG5vLW9w IFN1YnF1ZXJ5U2NhbiBub2RlcywgdGhhdCBpcywKb25lcyB0aGF0IGhhdmUgbm8gcXVhbCB0byBj aGVjayBhbmQgY29weSB0aGUgaW5wdXQgdGFyZ2V0bGlzdCB1bmNoYW5nZWQuCihGb3JtYWxseSBp dCdzIG5vdCB2ZXJ5IG5pY2UgdG8gYmUgYXBwbHlpbmcgc3VjaCBvcHRpbWl6YXRpb25zIHNvIGxh dGUKaW4gdGhlIHBsYW5uZXIsIGJ1dCB0aGVyZSBhcmUgcHJhY3RpY2FsIHJlYXNvbnMgZm9yIGl0 OyBtb3N0bHkgdGhhdCB3ZQpjYW4ndCB1bmlmeSByZWxpZHMgYmV0d2VlbiB0aGUgc3VicXVlcnkg YW5kIHRoZSBwYXJlbnQgcXVlcnkgdW50aWwgd2UKZmxhdHRlbiB0aGUgcmFuZ2V0YWJsZSBkdXJp bmcgc2V0cmVmcy5jLikgIFRoaXMgYmVoYXZpb3IgZmFsc2lmaWVzIG91cgpwcmV2aW91cyBjb3N0 IGVzdGltYXRlcywgc2luY2Ugd2Ugd291bGQndmUgY2hhcmdlZCBjcHVfdHVwbGVfY29zdCBwZXIK cm93IGp1c3QgdG8gcGFzcyBkYXRhIHRocm91Z2ggdGhlIG5vZGUuICBNb3N0IG9mIHRoZSB0aW1l IHRoYXQncyBsaXR0bGUKZW5vdWdoIHRvIG5vdCBtYXR0ZXIsIGJ1dCB0aGVyZSBhcmUgY2FzZXMg d2hlcmUgdGhpcyBlZmZlY3QgdmlzaWJseQpjaGFuZ2VzIHRoZSBwbGFuIGNvbXBhcmVkIHRvIHdo YXQgeW91IHdvdWxkJ3ZlIGdvdHRlbiB3aXRoIG5vCnN1Yi1zZWxlY3QuCgpUbyBpbXByb3ZlIHRo ZSBzaXR1YXRpb24sIG1ha2UgdGhlIGNhbGxlcnMgb2YgY29zdF9zdWJxdWVyeXNjYW4gdGVsbApp dCB3aGV0aGVyIHRoZXkgdGhpbmsgdGhlIHRhcmdldGxpc3QgaXMgdHJpdmlhbC4gIGNvc3Rfc3Vi cXVlcnlzY2FuCmFscmVhZHkgaGFzIHRoZSBxdWFsIGxpc3QsIHNvIGl0IGNhbiBjaGVjayB0aGUg b3RoZXIgaGFsZiBvZiB0aGUKY29uZGl0aW9uIGVhc2lseS4gIEl0IGNvdWxkIG1ha2UgaXRzIG93 biBkZXRlcm1pbmF0aW9uIG9mIHRsaXN0CnRyaXZpYWxpdHkgdG9vLCBidXQgZG9pbmcgc28gd291 bGQgYmUgcmVwZXRpdGl2ZSAoZm9yIGNhbGxlcnMgdGhhdAptYXkgY2FsbCBpdCBzZXZlcmFsIHRp bWVzKSBvciB1bm5lY2Vzc2FyaWx5IGV4cGVuc2l2ZSAoZm9yIGNhbGxlcnMKdGhhdCBjYW4gZGV0 ZXJtaW5lIHRoaXMgbW9yZSBjaGVhcGx5IHRoYW4gYSBnZW5lcmFsIHRlc3Qgd291bGQgZG8pLgoK VGhpcyBpc24ndCBhIDEwMCUgc29sdXRpb24sIGJlY2F1c2UgY3JlYXRlcGxhbi5jIGFsc28gZG9l cyB0aGluZ3MKdGhhdCBjYW4gZmFsc2lmeSBhbnkgZWFybGllciBlc3RpbWF0ZSBvZiB3aGV0aGVy IHRoZSB0bGlzdCBpcwp0cml2aWFsLiAgSG93ZXZlciwgaXQgZml4ZXMgbmVhcmx5IGFsbCBjYXNl cyBpbiBwcmFjdGljZSwgaWYgcmVzdWx0cwpmb3IgdGhlIHJlZ3Jlc3Npb24gdGVzdHMgYXJlIGFu eXRoaW5nIHRvIGdvIGJ5LgoKc2V0cmVmcy5jIGFsc28gY29udGFpbnMgbG9naWMgdG8gZGlzY2Fy ZCBuby1vcCBBcHBlbmQgYW5kIE1lcmdlQXBwZW5kCm5vZGVzLiAgV2UgZGlkIGhhdmUga25vd2xl ZGdlIG9mIHRoYXQgYmVoYXZpb3IgYXQgY29zdGluZyB0aW1lLCBidXQKc29tZWJvZHkgZmFpbGVk IHRvIHVwZGF0ZSBpdCB3aGVuIGEgY2hlY2sgb24gcGFyYWxsZWwtYXdhcmVuZXNzIHdhcwphZGRl ZCB0byB0aGUgc2V0cmVmcy5jIGxvZ2ljLiAgRml4IHRoYXQgd2hpbGUgd2UncmUgaGVyZS4KClRo ZXNlIGNoYW5nZXMgcmVzdWx0IGluIHR3byBtaW5vciBjaGFuZ2VzIGluIHF1ZXJ5IHBsYW5zIHNo b3duIGluCm91ciByZWdyZXNzaW9uIHRlc3RzLiAgTmVpdGhlciBpcyByZWxldmFudCB0byB0aGUg cHVycG9zZXMgb2YgaXRzCnRlc3QgY2FzZSBBRkFJQ1QuCgpQYXRjaCBieSBtZTsgdGhhbmtzIHRv IFJpY2hhcmQgR3VvIGZvciByZXZpZXcuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t LzI1ODEwNzcuMTY1MTcwMzUyMEBzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ZTJmNmMzMDdjMDI5MjRlNmVlMTY2Nzg5MGI1NjI4MGFiMTk2MGQyZQoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0aHMuYyAgICAg fCAzMyArKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNp emUuYyAgICAgfCAyMCArKysrKysrKysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zZXRy ZWZzLmMgICAgICB8IDE2ICsrKysrLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVw dW5pb24uYyAgICB8IDI3ICsrKysrKysrKysrKy0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRp bC9wYXRobm9kZS5jICAgICB8IDU2ICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0Kc3Jj L2luY2x1ZGUvb3B0aW1pemVyL2Nvc3QuaCAgICAgICAgICAgICAgfCAgMyArLQpzcmMvaW5jbHVk ZS9vcHRpbWl6ZXIvcGF0aG5vZGUuaCAgICAgICAgICB8ICA3ICsrLS0Kc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9jcmVhdGVfdmlldy5vdXQgfCAxNiArKysrLS0tLS0Kc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9qb2luLm91dCAgICAgICAgfCAgOCArKy0tLQo5IGZpbGVzIGNoYW5nZWQsIDE0 NyBpbnNlcnRpb25zKCspLCAzOSBkZWxldGlvbnMoLSkKCg== --===============4184944115777658892==--