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 1tXeQX-00BnSD-7W for pgsql-general@arkaria.postgresql.org; Tue, 14 Jan 2025 10:45:43 +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 1tXeQV-00H9m4-RK for pgsql-general@arkaria.postgresql.org; Tue, 14 Jan 2025 10:45:40 +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 1tXeQV-00H9lv-9x for pgsql-general@lists.postgresql.org; Tue, 14 Jan 2025 10:45:39 +0000 Received: from forward502b.mail.yandex.net ([2a02:6b8:c02:900:1:45:d181:d502]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tXeQS-000LAe-1W for pgsql-general@lists.postgresql.org; Tue, 14 Jan 2025 10:45:38 +0000 Received: from mail-nwsmtp-mxback-production-main-85.sas.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-85.sas.yp-c.yandex.net [IPv6:2a02:6b8:c1e:47a0:0:640:1bca:0]) by forward502b.mail.yandex.net (Yandex) with ESMTPS id E65C9614F9; Tue, 14 Jan 2025 13:45:30 +0300 (MSK) Received: from mail.yandex.com (2a02:6b8:c10:3c88:0:640:ff3b:0 [2a02:6b8:c10:3c88:0:640:ff3b:0]) by mail-nwsmtp-mxback-production-main-85.sas.yp-c.yandex.net (mxback/Yandex) with HTTPS id QjMFhw1O0W20-oeEDXRmB; Tue, 14 Jan 2025 13:45:30 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=primeit.com.tr; s=mail; t=1736851530; bh=hkPx4zJM18S6IY5VVT2HQINXxd7K1jWvfnHcttzY+0Q=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=U+pQLF5Meb8q5muvUG75U39h3Dqh+GAuqktYGvA1+N+8FHVRe3eBkoiLCon1ndFgS 7Y1QyZpAnIPFFs6fIFw4tOfWcwmZ3nkOsxyhYMmepAAW1dElLN8QiKPd5ejegHBZ9F iXNVGL1R17D58YmjOghFXyG4J3QyOyFLiU/3dDS8= Authentication-Results: mail-nwsmtp-mxback-production-main-85.sas.yp-c.yandex.net; dkim=pass header.i=@primeit.com.tr Received: by mail-sendbernar-production-main-66.sas.yp-c.yandex.net with HTTP; Tue, 14 Jan 2025 13:45:29 +0300 From: =?utf-8?B?RcWfcmVmIEhhbMSxY8Sxb8SfbHU=?= To: David Rowley Cc: "pgsql-general@lists.postgresql.org" In-Reply-To: References: <1348181736777057@mail.yandex.com> Subject: Re: About PostgreSQL Query Plan MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Tue, 14 Jan 2025 13:45:29 +0300 Message-Id: <256381736851444@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+wqA8L2Rpdj48ZGl2Pk9rYXksIHRoYW5rIHlvdSB2 ZXJ5IG11Y2gsIE1yLiBEYXZpZCwgZm9yIHlvdXIgc3VwcG9ydCBhbmQgdGhlIGluZm9ybWF0aW9u LDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkXFn3JlZjwvZGl2PjwvZGl2PjxkaXY+wqA8L2Rpdj48 ZGl2Pi0tLS0tLS0tLS0tLS0tLS08L2Rpdj48ZGl2PlRvOiBFxZ9yZWYgSGFsxLFjxLFvxJ9sdSAo ZXNyZWYuaGFsaWNpb2dsdUBwcmltZWl0LmNvbS50cik7PC9kaXY+PGRpdj5DYzogcGdzcWwtZ2Vu ZXJhbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZzs8L2Rpdj48ZGl2PlN1YmplY3Q6IEFib3V0IFBvc3Rn cmVTUUwgUXVlcnkgUGxhbjs8L2Rpdj48ZGl2PjE0LjAxLjIwMjUsIDEzOjA5LCAiRGF2aWQgUm93 bGV5IiAmbHQ7ZGdyb3dsZXltbEBnbWFpbC5jb20mZ3Q7OjwvZGl2PjxibG9ja3F1b3RlPjxwPk9u IFR1ZSwgMTQgSmFuIDIwMjUgYXQgMDM6NDUsIEXFn3JlZiBIYWzEsWPEsW/En2x1PGJyIC8+Jmx0 OzxhIGhyZWY9Im1haWx0bzplc3JlZi5oYWxpY2lvZ2x1QHByaW1laXQuY29tLnRyIiByZWw9Im5v b3BlbmVyIG5vcmVmZXJyZXIiPmVzcmVmLmhhbGljaW9nbHVAcHJpbWVpdC5jb20udHI8L2E+Jmd0 OyB3cm90ZTo8L3A+PGJsb2NrcXVvdGU+wqBJIGRvIG5vdCBmdWxseSB1bmRlcnN0YW5kIHRoZSBs b2dpYyBvZiB0aGlzIGlzc3VlLiBJIHdvdWxkIGJlIHZlcnkgZ3JhdGVmdWwgaWYgeW91IGNhbiBz aGFyZSBpbmZvcm1hdGlvbiBvbiB0aGUgc3ViamVjdC48YnIgLz48YnIgLz7CoFRoZSBxdWVyeSBw bGFuIGlzIGFzIGZvbGxvd3MuPGJyIC8+PGJyIC8+wqBVcGRhdGUgb24gInRlc3RfdGFibGUxIiB0 dDEgKGNvc3Q9MC4xMy4uMTU5MTEyLjg0IHJvd3M9MCB3aWR0aD0wKTxiciAvPsKgwqDCoFVwZGF0 ZSBvbiAidGVzdF90YWJsZTFfcGFydGl0aW9uXzIwMjBfMTAiIHR0MTxiciAvPsKgwqDCoFVwZGF0 ZSBvbiAidGVzdF90YWJsZTFfcGFydGl0aW9uXzIwMjBfMTEiIHR0MTwvYmxvY2txdW90ZT48cD4u Li48YnIgLz7CoFVwZGF0ZSBvbiAidGVzdF90YWJsZTFfcGFydGl0aW9uXzIwMjVfMTIiIHR0MTwv cD48YmxvY2txdW90ZT7CoMKgwqBVcGRhdGUgb24gInRlc3RfdGFibGUxX3BhcnRpdGlvbl9kZWZh dWx0IiB0dDE8YnIgLz7CoMKgwqAtJmd0OyBOZXN0ZWQgTG9vcCAoY29zdD0wLjEzLi4xNTkxMTIu ODQgcm93cz0xIHdpZHRoPTUzKTxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoC0mZ3Q7IFNlcSBTY2Fu IG9uICJ0ZW1wX3Rlc3RfdGFibGUxIiB0ZW1wIChjb3N0PTAuMDAuLjE5LjIwIHJvd3M9OTIwIHdp ZHRoPTMxKTxiciAvPsKgwqDCoMKgwqDCoMKgwqDCoC0mZ3Q7IEFwcGVuZCAoY29zdD0wLjEzLi4x NzIuMjkgcm93cz02NCB3aWR0aD0zOCk8YnIgLz7CoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqBTdWJwbGFucyBSZW1vdmVkOiA2MDwvYmxvY2txdW90ZT48cD48YnIgLz5UaGUgcGFydGl0aW9u cyBtZW50aW9uZWQgaW4gdGhlICJVcGRhdGUgb24iIHBvcnRpb24gb2YgdGhlIEVYUExBSU48YnIg Lz5hcmVuJ3QgYmVpbmcgc2Nhbm5lZC4gVGhlc2UgYXJlIGp1c3QgcmVzdWx0IHJlbGF0aW9ucyB0 aGF0IHBvdGVudGlhbGx5PGJyIC8+Y291bGQgaGF2ZSB0dXBsZXMgcm91dGVkIHRvIHRoZW0uIFRo ZSBrZXkgcGFydCBvZiB0aGUgRVhQTEFJTiBvdXRwdXQ8YnIgLz50byBrbm93aW5nIHRoYXQgdGhl IHVucmVsYXRlZCBwYXJ0aXRpb25zIGFyZSBwcnVuZWQgaXMgZnJvbSB3aGljaDxiciAvPnBhcnRp dGlvbnMgYXJlIG1lbnRpb25lZCBiZWxvdyB0aGUgIkFwcGVuZCIgbm9kZS4gWW91IGNhbiBzZWUg dGhhdCA2MDxiciAvPm9mIHlvdXIgNjQgcGFydGl0aW9ucyB3ZXJlIHBydW5lZCB3aXRoIHRoZSAi U3VicGxhbnMgUmVtb3ZlZDogNjAiPGJyIC8+cGFydC4gVGhlIGV4ZWN1dG9yIGlzIG9ubHkgZ29p bmcgdG8gc2NhbiB0aGUgNCByZW1haW5pbmcgb25lcyB0aGF0IHlvdTxiciAvPnNlZSBiZWxvdyB0 aGUgIkFwcGVuZCIuPGJyIC8+PGJyIC8+SSB3b3VsZG4ndCB3b3JyeSB0b28gbXVjaCBhYm91dCB0 aGUgYWRkaXRpb25hbCBwYXJ0aXRpb25zIG1lbnRpb25lZCBpbjxiciAvPnRoZSAiVXBkYXRlIG9u Ii4gV2UgbWF5YmUgY291bGQgZG8gYSBiaXQgbW9yZSB3b3JrIHRvIGluaXRpYWxpc2UgdGhvc2U8 YnIgLz5tb3JlIGxhemlseSBhcyB3ZSBkbyBmb3IgSU5TRVJUIHN0YXRlbWVudHMsIGJ1dCBJJ2Qg YmUgc3VycHJpc2VkIGlmIGl0PGJyIC8+d2FzIGEgcHJvYmxlbSBmb3IgNjQgcGFydGl0aW9ucywg ZXNwZWNpYWxseSBzbyBmb3IgYW4gdXBkYXRlIHN0YXRlbWVudDxiciAvPnRoYXQgbWlnaHQgYmUg dG91Y2hpbmcgMyBtb250aHMgb2YgZGF0YS4gTm90aGluZyBhYm91dCB0aGVzZSBleGlzdGluZzxi ciAvPmluIHRoZSAiVXBkYXRlIG9uIiBwb3J0aW9uIG9mIHRoZSBFWFBMQUlOIG91dHB1dCBtZWFu cyB0aGF0IHRoYXQ8YnIgLz5wYXJ0aXRpb24gd2lsbCBiZSBzY2FubmVkIGJ5IHRoZSBVUERBVEUg c3RhdGVtZW50LCByZXN0IGFzc3VyZWQuPGJyIC8+PGJyIC8+RGF2aWQ8L3A+PC9ibG9ja3F1b3Rl PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4tLcKgPC9kaXY+PGRpdj48aW1nIHNyYz0i aHR0cHM6Ly9hdmF0YXJzLm1kcy55YW5kZXgubmV0L2dldC1tYWlsLXNpZ25hdHVyZS8xNjQwMTAy LzY1YmI1NDVhZTBmNDQ0NTcwMTBhZDNhYWEzM2QxZmNhL29yaWciIC8+PC9kaXY+PGRpdj7CoDwv ZGl2Pg==