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 1pjkEo-0005Vg-6E for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Apr 2023 17:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjkEn-00019B-1z for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Apr 2023 17:14:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjjgb-0000c4-CJ for pgsql-bugs@lists.postgresql.org; Tue, 04 Apr 2023 16:39:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pjjgY-000reo-2h for pgsql-bugs@lists.postgresql.org; Tue, 04 Apr 2023 16:39:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=SMFYGlMHT+T2fekgnq+Nmhh0i9oYYXEVgNBN2NYbmQ4=; b=QX+cu65QjBAgmSlSnkPFgJlO9D XzwpIparc2uWDoIAfTx5G+e2YTyYxEeUBRqEO5uO1bf5bLq9fixqsimaHAqzPOxyxCW+6lpkVlOW9 cfNQMY6V1H98lEvF2yUopYLwxSRoidvofw/1OAUw2kru/0eCIeYCeqOivCk9XaiZOpmN2kacn+uhn CoZj86GApTG+BzJmtZhlgoEQFDZ3bCOZWdc9ACJkQawomSRvq3X1oGp2KVuIMJapE3nUAXR7FzLBc yIp2P29yyE3iQYh9y9qGRCkgKfMwyCPDw1GeWhuELzZErLsaeuPm0KRAMIImBWncPOPAhQQ+deBu4 nUsyqtsg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pjjgV-0004Ok-TF for pgsql-bugs@lists.postgresql.org; Tue, 04 Apr 2023 16:39:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pjjgU-004syM-Kg for pgsql-bugs@lists.postgresql.org; Tue, 04 Apr 2023 16:39:02 +0000 Content-Type: multipart/mixed; boundary="===============0935391064583837736==" MIME-Version: 1.0 Subject: BUG #17885: slow planning constraint_exclusion To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sk@zsrv.org Reply-To: sk@zsrv.org, pgsql-bugs@lists.postgresql.org Date: Tue, 04 Apr 2023 16:38:27 +0000 Message-ID: <17885-e01170adb18c7fd1@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0935391064583837736== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg4NQpMb2dnZWQgYnk6ICAgICAgICAgIFNlcmdlaSBLb3JuaWxvdgpF bWFpbCBhZGRyZXNzOiAgICAgIHNrQHpzcnYub3JnClBvc3RncmVTUUwgdmVyc2lvbjogMTUuMgpP cGVyYXRpbmcgc3lzdGVtOiAgIGxpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIZWxsbw0KDQpU b2RheSBJIHdhcyBsb29raW5nIGZvciB0aGUgcHJvYmxlbSBvZiBvbmUgc2xvdyBxdWVyeSBhbmQg bWluaW1pemVkIHRoZQpleGFtcGxlIHRvIHN1Y2ggY2FzZToNCg0KY3JlYXRlIHRhYmxlIHBhcnRf dGVzdCAocmFuZ2UgYmlnaW50LCBjb2xfYSBiaWdpbnQsIGNvbF9iIGJpZ2ludCkgcGFydGl0aW9u CmJ5IHJhbmdlIChyYW5nZSk7DQpzZWxlY3QgZm9ybWF0KCQkY3JlYXRlIHRhYmxlIHBhcnRfdGVz dF8lcyBwYXJ0aXRpb24gb2YgcGFydF90ZXN0IGZvciB2YWx1ZXMKZnJvbSAoICVMICkgdG8gKCAl TCApJCQsIGxwYWQoaTo6dGV4dCwgMywgJzAnKSwgKGktMSkqMWU2LCBpKjFlNikgZnJvbQpnZW5l cmF0ZV9zZXJpZXMoMSw0OSkgYXMgaTsNClxnZXhlYw0KDQpleHBsYWluIChhbmFseXplLGJ1ZmZl cnMpIHNlbGVjdCAqIGZyb20gcGFydF90ZXN0IHdoZXJlIGNvbF9hID0gMTIzDQphbmQgY29sX2Ig bm90IGluICgNCiAwLCAxLCAyLCAzLCA0LCA1LCA2LCA3LCA4LCA5LDEwLDExLDEyLDEzLDE0LDE1 LDE2LDE3LDE4LDE5LA0KMjAsMjEsMjIsMjMsMjQsMjUsMjYsMjcsMjgsMjksMzAsMzEsMzIsMzMs MzQsMzUsMzYsMzcsMzgsMzksDQo0MCw0MSw0Miw0Myw0NCw0NSw0Niw0Nyw0OCw0OSw1MCw1MSw1 Miw1Myw1NCw1NSw1Niw1Nyw1OCw1OSwNCjYwLDYxLDYyLDYzLDY0LDY1LDY2LDY3LDY4LDY5LDcw LDcxLDcyLDczLDc0LDc1LDc2LDc3LDc4LDc5LA0KODAsODEsODIsODMsODQsODUsODYsODcsODgs ODksOTAsOTEsOTIsOTMsOTQsOTUsOTYsOTcsOTgsOTkNCik7DQoNCig1MCBwYXJ0aXRpb25zIGFu ZCAxMDAgZWxlbWVudHMgImluIikNCg0KV2l0aCB0aGlzIHF1ZXJ5IEkgYW0gZ2V0dGluZyBhYm5v cm1hbGx5IGhpZ2ggcGxhbm5pbmcgdGltZToNCg0KIFBsYW5uaW5nIFRpbWU6IDIzOS42MTAgbXMN CiBFeGVjdXRpb24gVGltZTogMC4zMjQgbXMNCiANCkluY3JlYXNpbmcgdGhlIG51bWJlciBvZiBw YXJ0aXRpb25zIG9yIHNpemUgb2YgIm5vdCBpbiIgbGlzdCBmdXJ0aGVyCmluY3JlYXNlcyBwbGFu bmluZyB0aW1lLiBSZXByb2R1Y2VkIG9uIHRvZGF5J3MgSEVBRCAxNmRldiB0b28uIEkgZm91bmQg dGltZQppcyB3YXN0ZWQgc29tZXdoZXJlIGluIHJlbGF0aW9uX2V4Y2x1ZGVkX2J5X2NvbnN0cmFp bnRzLiBJZiBJIGRpc2FibGUKY29uc3RyYWludF9leGNsdXNpb24gY29tcGxldGVseSwgdGhlbiB0 aGUgcGxhbm5pbmcgdGltZSBkcm9wcyB0byBhIGZldwptaWxsaXNlY29uZHMuDQoNCnJlZ2FyZHMs IFNlcmdlaQoK --===============0935391064583837736==--