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 1tXOKA-0064Zq-0V for pgsql-general@arkaria.postgresql.org; Mon, 13 Jan 2025 17:34:02 +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 1tXOK8-00C7GT-Fi for pgsql-general@arkaria.postgresql.org; Mon, 13 Jan 2025 17:34:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tXNpF-00BcPv-9J for pgsql-general@lists.postgresql.org; Mon, 13 Jan 2025 17:02:05 +0000 Received: from forward501a.mail.yandex.net ([178.154.239.81]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tXNpA-000Cl5-1n for pgsql-general@lists.postgresql.org; Mon, 13 Jan 2025 17:02:05 +0000 Received: from mail-nwsmtp-mxback-production-main-842.myt.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-842.myt.yp-c.yandex.net [IPv6:2a02:6b8:c00:2595:0:640:7a38:0]) by forward501a.mail.yandex.net (Yandex) with ESMTPS id 51AFA6146A; Mon, 13 Jan 2025 20:01:57 +0300 (MSK) Received: from mail.yandex.com (2a02:6b8:c12:422b:0:640:82ac:0 [2a02:6b8:c12:422b:0:640:82ac:0]) by mail-nwsmtp-mxback-production-main-842.myt.yp-c.yandex.net (mxback/Yandex) with HTTPS id d1Sjii0OuCg0-JK80mCet; Mon, 13 Jan 2025 20:01:56 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=primeit.com.tr; s=mail; t=1736787716; bh=6m1nBtwrVmc0W627EQ7XqmRlY0PQpP9kZXvd28saX7o=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=juH89j1shRsniPH137bswIUHHykEVbTLhl3ekPrB7NqQ3KdJMEf1IeGPMBZP6sBtS OUUlAK6HY8S3KcHqnLa/uYtNxeHJHKtdHseqwEx6fhLboJ+8J2rIZWOBTfnwAChd05 0D5QAvrR4V92462pcuGKUIVvox0rIp9riIFq8pVg= Authentication-Results: mail-nwsmtp-mxback-production-main-842.myt.yp-c.yandex.net; dkim=pass header.i=@primeit.com.tr Received: by psojrjlde2lj37wi.myt.yp-c.yandex.net with HTTP; Mon, 13 Jan 2025 20:01:56 +0300 From: =?utf-8?B?RcWfcmVmIEhhbMSxY8Sxb8SfbHU=?= To: "depesz@depesz.com" Cc: "pgsql-general@lists.postgresql.org" In-Reply-To: References: <1348181736777057@mail.yandex.com> <260121736786553@mail.yandex.com> Subject: Re: About PostgreSQL Query Plan MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Mon, 13 Jan 2025 20:01:56 +0300 Message-Id: <2341736787555@mail.yandex.com> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj48ZGl2PkhlbGxvLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlllcywgeW91IGFyZSByaWdo dDsgaXQgc2VlbXMgdGhhdCBvbmx5IDQgYmF0Y2hlcyBoYWQgZGF0YSBjaGFuZ2VzLiBIb3dldmVy LCB0aGUgcXVlcnkgYWxzbyBhY2Nlc3NlZCBvdGhlciBiYXRjaGVzIGFuZCB0aGVuIHJlbW92ZWQg dGhlbSBhZ2Fpbi4gV2hhdCBjb3VsZCBiZSB0aGUgcmVhc29uIGZvciB0aGlzIGFuZCBob3cgY2Fu IGl0IGJlIHNvbHZlZD88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5PYnZpb3VzbHksIEkgd291bGQg bGlrZSB0byB1bmRlcnN0YW5kIHRoaXMgc2l0dWF0aW9uIGJldHRlciBhbmQgbGVhcm4gdGhlIHNv bHV0aW9uLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2Pkkgd291bGQgYmUgdmVyeSBncmF0ZWZ1bCBp ZiB5b3UgY291bGQgaGVscCBtZS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5UaGFuayB5b3UsPC9k aXY+PGRpdj7CoDwvZGl2PjxkaXY+RcWfcmVmIEhhbMSxY8Sxb8SfbHU8L2Rpdj48L2Rpdj48ZGl2 PsKgPC9kaXY+PGRpdj4tLS0tLS0tLS0tLS0tLS0tPC9kaXY+PGRpdj5UbzogRcWfcmVmIEhhbMSx Y8Sxb8SfbHUgKGVzcmVmLmhhbGljaW9nbHVAcHJpbWVpdC5jb20udHIpOzwvZGl2PjxkaXY+Q2M6 IHBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmc7PC9kaXY+PGRpdj5TdWJqZWN0OiBB Ym91dCBQb3N0Z3JlU1FMIFF1ZXJ5IFBsYW47PC9kaXY+PGRpdj4xMy4wMS4yMDI1LCAxOTo1Niwg Imh1YmVydCBkZXBlc3ogbHViYWN6ZXdza2kiICZsdDtkZXBlc3pAZGVwZXN6LmNvbSZndDs6PC9k aXY+PGJsb2NrcXVvdGU+PHA+T24gTW9uLCBKYW4gMTMsIDIwMjUgYXQgMDc6NDg6MDlQTSArMDMw MCwgRcWfcmVmIEhhbMSxY8Sxb8SfbHUgd3JvdGU6PC9wPjxibG9ja3F1b3RlPsKgSGVsbG8sPGJy IC8+wqDCoDxiciAvPsKgWWVzLCB5b3UgYXJlIHJpZ2h0OyB0aGlzIHF1ZXJ5IGlzIG5vdCBhIFNF TEVDVCwgaXQgaXMgYW4gVVBEQVRFIHF1ZXJ5LCB0aGVyZSB3YXMgYSBtaXN0YWtlIGluIGV4cHJl c3NpbmcgaXQgaGVyZS4gVGhlIGNvbHVtbnMgSSB3YW50PGJyIC8+wqB0byB1cGRhdGUgaGVyZSBv bmx5IG9wZXJhdGUgb24gZGF0YSBmcm9tIHRoZSBsYXN0IDMgbW9udGhzIHRpbWUgaW50ZXJ2YWwu PGJyIC8+wqDCoDxiciAvPsKgSSBhbSBhbHNvIHNoYXJpbmcgdGhlIEVYUExBSU4gQU5BTFlaRSBv dXRwdXQgb2YgdGhlIHJlbGV2YW50IHF1ZXJ5IGJlbG93OjxiciAvPsKgwqA8YnIgLz7CoFVwZGF0 ZSBvbiAiVGVzdFRhYmxlMSIgdDHCoCAoY29zdD0wLjEzLi4xNTkxMTQuODQgcm93cz0wIHdpZHRo PTApIChhY3R1YWwgdGltZT0wLjAwNy4uMC4wMDggcm93cz0wIGxvb3BzPTEpPGJyIC8+wqDCoCBV cGRhdGUgb24gIlBhcnRpdGlvblRhYmxlXzIwMjBfMTAiIHQxPC9ibG9ja3F1b3RlPjxwPuKApiA2 MSBsaW5lcyByZW1vdmVkIOKApjwvcD48YmxvY2txdW90ZT7CoMKgIFVwZGF0ZSBvbiAiUGFydGl0 aW9uVGFibGVfMjAyNV8xMiIgdDE8YnIgLz7CoMKgIFVwZGF0ZSBvbiAiRGVmYXVsdFBhcnRpdGlv blRhYmxlIiB0MTxiciAvPsKgwqAgLSZndDvCoCBOZXN0ZWQgTG9vcMKgIChjb3N0PTAuMTMuLjE1 OTExNC44NCByb3dzPTEgd2lkdGg9NTMpIChhY3R1YWwgdGltZT0wLjAwNi4uMC4wMDYgcm93cz0w IGxvb3BzPTEpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoCAtJmd0O8KgIFNlcSBTY2FuIG9uICJUZW1w VGFibGUxIiB0bXDCoCAoY29zdD0wLjAwLi4xOS4yMCByb3dzPTkyMCB3aWR0aD0zMSkgKGFjdHVh bCB0aW1lPTAuMDA2Li4wLjAwNiByb3dzPTAgbG9vcHM9MSk8YnIgLz7CoMKgwqDCoMKgwqDCoMKg IC0mZ3Q7wqAgQXBwZW5kwqAgKGNvc3Q9MC4xMy4uMTcyLjI5IHJvd3M9NjQgd2lkdGg9MzgpIChu ZXZlciBleGVjdXRlZCk8YnIgLz7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIFN1YnBsYW5z IFJlbW92ZWQ6IDYwPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCAtJmd0O8KgIElu ZGV4IFNjYW4gdXNpbmcgcGFydGl0aW9udGFibGVfMjAyNF8xMF9wa2V5IG9uICJQYXJ0aXRpb25U YWJsZV8yMDI0XzEwIiB0MsKgIChjb3N0PTAuNDMuLjQuMjEgcm93cz0xIHdpZHRoPTM4KSAobmV2 ZXIgZXhlY3V0ZWQpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oCBJbmRleCBDb25kOiAoKCJDb2wxIiA9IHRtcC4iQ29sMiIpIEFORCAoIkNvbDMiICZndDs9IChD VVJSRU5UX0RBVEUgLSAnMyBtb25zJzo6aW50ZXJ2YWwpKSBBTkQgKCJDb2wzIiAmbHQ7PSBDVVJS RU5UX0RBVEUpKTxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAg RmlsdGVyOiAoKE5PVCAiSXNEZWxldGVkIikgQU5EICgiQ29sNCIgPSB0bXAuIkNvbDUiKSk8YnIg Lz7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIC0mZ3Q7wqAgSW5kZXggU2NhbiB1c2luZyBw YXJ0aXRpb250YWJsZV8yMDI0XzExX3BrZXkgb24gIlBhcnRpdGlvblRhYmxlXzIwMjRfMTEiIHQz wqAgKGNvc3Q9MC40My4uNC4yMyByb3dzPTEgd2lkdGg9MzgpIChuZXZlciBleGVjdXRlZCk8YnIg Lz7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEluZGV4IENvbmQ6ICgo IkNvbDEiID0gdG1wLiJDb2wyIikgQU5EICgiQ29sMyIgJmd0Oz0gKENVUlJFTlRfREFURSAtICcz IG1vbnMnOjppbnRlcnZhbCkpIEFORCAoIkNvbDMiICZsdDs9IENVUlJFTlRfREFURSkpPGJyIC8+ wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBGaWx0ZXI6ICgoTk9UICJJ c0RlbGV0ZWQiKSBBTkQgKCJDb2w0IiA9IHRtcC4iQ29sNSIpKTxiciAvPsKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqAgLSZndDvCoCBJbmRleCBTY2FuIHVzaW5nIHBhcnRpdGlvbnRhYmxlXzIw MjRfMTJfcGtleSBvbiAiUGFydGl0aW9uVGFibGVfMjAyNF8xMiIgdDTCoCAoY29zdD0wLjQzLi40 LjM0IHJvd3M9MSB3aWR0aD0zOCkgKG5ldmVyIGV4ZWN1dGVkKTxiciAvPsKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgSW5kZXggQ29uZDogKCgiQ29sMSIgPSB0bXAuIkNv bDIiKSBBTkQgKCJDb2wzIiAmZ3Q7PSAoQ1VSUkVOVF9EQVRFIC0gJzMgbW9ucyc6OmludGVydmFs KSkgQU5EICgiQ29sMyIgJmx0Oz0gQ1VSUkVOVF9EQVRFKSk8YnIgLz7CoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEZpbHRlcjogKChOT1QgIklzRGVsZXRlZCIpIEFORCAo IkNvbDQiID0gdG1wLiJDb2w1IikpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCAt Jmd0O8KgIEluZGV4IFNjYW4gdXNpbmcgcGFydGl0aW9udGFibGVfMjAyNV8wMV9wa2V5IG9uICJQ YXJ0aXRpb25UYWJsZV8yMDI1XzAxIiB0NcKgIChjb3N0PTAuNDMuLjMuNzIgcm93cz0xIHdpZHRo PTM4KSAobmV2ZXIgZXhlY3V0ZWQpPGJyIC8+wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoCBJbmRleCBDb25kOiAoKCJDb2wxIiA9IHRtcC4iQ29sMiIpIEFORCAoIkNvbDMi ICZndDs9IChDVVJSRU5UX0RBVEUgLSAnMyBtb25zJzo6aW50ZXJ2YWwpKSBBTkQgKCJDb2wzIiAm bHQ7PSBDVVJSRU5UX0RBVEUpKTxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqAgRmlsdGVyOiAoKE5PVCAiSXNEZWxldGVkIikgQU5EICgiQ29sNCIgPSB0bXAuIkNv bDUiKSk8YnIgLz7CoFBsYW5uaW5nIFRpbWU6IDMuODYwIG1zPGJyIC8+wqBFeGVjdXRpb24gVGlt ZTogMC4wNjYgbXM8L2Jsb2NrcXVvdGU+PHA+PGJyIC8+V2VsbCwgaXQgaGVscGVkLCBhbmQgSSBt aXNzZWQgc29tZSBiaXRzIG9mIGluZm9ybWF0aW9uIGVhcmxpZXIuPGJyIC8+R2VuZXJhbGx5IGl0 IGxvb2tzIHRoYXQgaXQgd2FzIHRyeWluZyB0byBzY2FuIG9ubHkgNCBwYXJ0aXRpb25zLCBidXQ8 YnIgLz50aGV5IGFsbCBnb3Qgc2tpcHBlZC48YnIgLz48YnIgLz5CZXN0IHJlZ2FyZHMsPGJyIC8+ PGJyIC8+ZGVwZXN6PGJyIC8+wqA8L3A+PC9ibG9ja3F1b3RlPjxkaXY+wqA8L2Rpdj48ZGl2PsKg PC9kaXY+PGRpdj4tLcKgPC9kaXY+PGRpdj48aW1nIHNyYz0iaHR0cHM6Ly9hdmF0YXJzLm1kcy55 YW5kZXgubmV0L2dldC1tYWlsLXNpZ25hdHVyZS8xNjQwMTAyLzY1YmI1NDVhZTBmNDQ0NTcwMTBh ZDNhYWEzM2QxZmNhL29yaWciIC8+PC9kaXY+PGRpdj7CoDwvZGl2Pg==