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 1qMfU9-002ynS-R0 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 02:03:13 +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 1qMfU8-007irI-C1 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 02:03:12 +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 1qMfU7-007iqa-WA for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 02:03:12 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMfU2-000qmJ-74 for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 02:03:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=i04C5X+LjFZ8Jgrw+EmazHIZx0n+F175gPRw3z+mM3s=; b=P lZW7GIvtkrr5vH2EBe/zI16CauQdq+HA81UuaDHrivutn8Dn6sUFekX0OAK+d5k8 FvjL9rsRyBS5sJGQd9gHX2ATMDsa/X6jGEk3oiUvJlu09jNTtyaauFuLIPX4TJ+Z qb064LJumfI+X3zgPvgyOrMCGdPJ/GFF4E319bCbEM= Received: from gzhcoder$126.com ( [119.163.77.89] ) by ajax-webmail-wmsvr50 (Coremail) ; Fri, 21 Jul 2023 10:02:51 +0800 (CST) X-Originating-IP: [119.163.77.89] Date: Fri, 21 Jul 2023 10:02:51 +0800 (CST) From: gzh To: "jian he" Cc: "Erik Wienhold" , pgsql-general@lists.postgresql.org Subject: =?UTF-8?Q?Re:How_to_improve_the_performance_of_my_SQL_query=EF=BC=9F?= X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 126com In-Reply-To: References: <6212ea1b.425b.1897221c3cc.Coremail.gzhcoder@126.com> <1360960490.395085.1689840435026@office.mailbox.org> <1628bf9c.6d72.1897315f05f.Coremail.gzhcoder@126.com> X-NTES-SC: AL_QuyTC/Wbu0Es5yGcZekWnEgXj+c7Xsu4u/0v34FSNps0uCrA2TAuVlREDHH3y86wCC+MmzORYiJP1fpRcbJTY6NRlJUPuzrCuXDahqBti5BO Content-Type: multipart/alternative; boundary="----=_Part_21894_1720350711.1689904971143" MIME-Version: 1.0 Message-ID: <76afcab2.1762.189762f7d87.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowAAHtFpM57lkJLwGAA--.56721W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi5QazWVpD+de03gABsV X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_21894_1720350711.1689904971143 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 PnNlbGVjdCAoMzg3MDAzMjUgLSAxMTgzMzQ0MikgLzM4NzAwMzI1LjA7Cj5pcyAwLjY5IGFwcHJv eC4KPlNvIEkgdGhpbmsgaXQgc2F5cyBhcm91bmQgNjklICBvZiByb3dzIHNhdGlzZnkgdGhlIHF1 ZXJ5IGNvbmRpdGlvbi5UaGFuayB5b3UgZm9yIHlvdXIgcmVwbHkuIEkgaGF2ZSBsZWFybmVkIGEg bG90IGZyb20gaXQuCgoKCgoKCgoKCgoKQXQgMjAyMy0wNy0yMCAyMzoyMDoxNiwgImppYW4gaGUi IDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+IHdyb3RlOgo+T24gVGh1LCBKdWwgMjAsIDIw MjMgYXQgNzozNuKAr1BNIGd6aCA8Z3poY29kZXJAMTI2LmNvbT4gd3JvdGU6Cj4+Cj4+Cj4+IFRo YW5rIHlvdSB2ZXJ5IG11Y2ggZm9yIHRha2luZyB0aGUgdGltZSB0byByZXBseSB0byBteSBxdWVz dGlvbi4KPj4KPj4KPj4gU29ycnksIEkgcHJvdmlkZWQgaW5jb3JyZWN0IGluZm9ybWF0aW9uLgo+ Pgo+PiBUaGUgaW5kZXggYWxzbyBkb2VzIG5vdCB3b3JrIGluIHRoZSBmb2xsb3dpbmcgcXVlcnkg c3RhdGVtZW50Lgo+Pgo+Pgo+PiA+IHNlbGVjdCBDT1VOVChFVF9DRCkKPj4KPj4gPiBmcm9tIFRC TF9TSEEKPj4KPj4gPiBXSEVSRSBNU19DRCA9ICcwMDknCj4+Cj4+ID4gQU5EIEVUUllTID0gJzAw MDAwMScKPj4KPj4KPj4gUVVFUlkgUExBTgo+Pgo+PiBMaW1pdCAgKGNvc3Q9MjQxOTY0My40Ny4u MjQxOTY0My40OCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTEyODY2Ny40MzkuLjEyODY2 OC4yNTAgcm93cz0xIGxvb3BzPTEpCj4+Cj4+ICAgLT4gIEZpbmFsaXplIEFnZ3JlZ2F0ZSAgKGNv c3Q9MjQxOTY0My40Ny4uMjQxOTY0My40OCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTEy ODY2Ny40MzcuLjEyODY2OC4yNDYgcm93cz0xIGxvb3BzPTEpCj4+Cj4+ICAgICAgICAgLT4gIEdh dGhlciAgKGNvc3Q9MjQxOTY0My4yNS4uMjQxOTY0My40NiByb3dzPTIgd2lkdGg9OCkgKGFjdHVh bCB0aW1lPTEyODY2NC4xMDguLjEyODY2OC4yMzMgcm93cz0zIGxvb3BzPTEpCj4+Cj4+ICAgICAg ICAgICAgICAgV29ya2VycyBQbGFubmVkOiAyCj4+Cj4+ICAgICAgICAgICAgICAgV29ya2VycyBM YXVuY2hlZDogMgo+Pgo+PiAgICAgICAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNv c3Q9MjQxODY0My4yNS4uMjQxODY0My4yNiByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTEy ODY1NS4yNTYuLjEyODY1NS4yNTggcm93cz0xIGxvb3BzPTMpCj4+Cj4+ICAgICAgICAgICAgICAg ICAgICAgLT4gIFBhcmFsbGVsIFNlcSBTY2FuIG9uIFRCTF9TSEEgIChjb3N0PTAuMDAuLjI0MTU1 NDguODUgcm93cz0xMjM3NzYyIHdpZHRoPTkpIChhY3R1YWwgdGltZT03NTM1Ny40NTUuLjEyODUz MS42MTUgcm93cz0xMDY2NjY3IGxvb3BzPTMpCj4+Cj4+ICAgICAgICAgICAgICAgICAgICAgICAg ICAgRmlsdGVyOiAoKE1TX0NEID0gJzAwOSc6OmJwY2hhcikgQU5EIChFVFJZUyA9ICcwMDAwMDEn OjpicGNoYXIpKQo+Pgo+PiAgICAgICAgICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBi eSBGaWx0ZXI6IDExODMzNDQyCj4+Cj4+IFBsYW5uaW5nIFRpbWU6IDAuMTE4IG1zCj4+Cj4+IEV4 ZWN1dGlvbiBUaW1lOiAxMjg2NjguMjkwIG1zCj4+Cj4+Cj4+IFRoZSBUQkxfU0hBIHRhYmxlIGhh cyBhbm90aGVyIGluZGV4LCBhcyBzaG93biBiZWxvdy4KPj4KPj4KPj4gQ1JFQVRFIElOREVYIGlu ZGV4X3NlYXJjaF8wMiBPTiBtZGIuVEJMX1NIQSBVU0lORyBidHJlZSAoRVRfQ0QsIEVUUllTKQo+ Pgo+PiBDUkVBVEUgSU5ERVggaW5kZXhfc2VhcmNoXzAzIE9OIG1kYi5UQkxfU0hBIFVTSU5HIGJ0 cmVlIChNU19DRCwgRVRfREFZLCBCS19DRCwgRlJfQ0QsIFJNX0NEKQo+Pgo+Cj4+ICAgICAgICAg ICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTE4MzM0NDIKPnNlbGVj dCAoMzg3MDAzMjUgLSAxMTgzMzQ0MikgLzM4NzAwMzI1LjA7Cj5pcyAwLjY5IGFwcHJveC4KPlNv IEkgdGhpbmsgaXQgc2F5cyBhcm91bmQgNjklICBvZiByb3dzIHNhdGlzZnkgdGhlIHF1ZXJ5IGNv bmRpdGlvbi4KPgo+YnV0IEkgYW0gbm90IHN1cmUgaW4gdGhlIGZvbGxvd2luZyAyIGNhc2VzLCB3 aGV0aGVyIHRoZSBhY3R1YWwgcm93cwo+YXJlIG5vaXN5IG9yIG5vdC4gSSBjYW4gbm90IGZpbmQg dGhlIGRvYyBleHBsYWluaW5nIGl0Lgo+PiBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGFjdHVhbCB0aW1l PTEyODY1NS4yNTYuLjEyODY1NS4yNTggcm93cz0xIGxvb3BzPTMpCj4+IEZpbmFsaXplIEFnZ3Jl Z2F0ZSAoYWN0dWFsIHRpbWU9MTI4NjY3LjQzNy4uMTI4NjY4LjI0NiByb3dzPTEgbG9vcHM9MSkK ------=_Part_21894_1720350711.1689904971143 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwcmU+Jmd0O3NlbGVjdCAoMzg3MDAzMjUgLSAxMTgzMzQ0Mikg LzM4NzAwMzI1LjA7CiZndDtpcyAwLjY5IGFwcHJveC4KJmd0O1NvIEkgdGhpbmsgaXQgc2F5cyBh cm91bmQgNjklICBvZiByb3dzIHNhdGlzZnkgdGhlIHF1ZXJ5IGNvbmRpdGlvbi48L3ByZT48cCBz dHlsZT0ibWFyZ2luOiAwOyI+VGhhbmsgeW91IGZvciB5b3VyIHJlcGx5LiBJIGhhdmUgbGVhcm5l ZCBhIGxvdCBmcm9tIGl0LjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cCBzdHls ZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48ZGl2IHN0eWxlPSJwb3NpdGlvbjpyZWxhdGl2ZTt6b29t OjEiPjwvZGl2PjxkaXYgaWQ9ImRpdk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+PHAgc3R5bGU9Im1h cmdpbjogMDsiPjxicj48L3A+PHByZT48YnI+QXQgMjAyMy0wNy0yMCAyMzoyMDoxNiwgImppYW4g aGUiICZsdDtqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20mZ3Q7IHdyb3RlOgomZ3Q7T24gVGh1 LCBKdWwgMjAsIDIwMjMgYXQgNzozNuKAr1BNIGd6aCAmbHQ7Z3poY29kZXJAMTI2LmNvbSZndDsg d3JvdGU6CiZndDsmZ3Q7CiZndDsmZ3Q7CiZndDsmZ3Q7IFRoYW5rIHlvdSB2ZXJ5IG11Y2ggZm9y IHRha2luZyB0aGUgdGltZSB0byByZXBseSB0byBteSBxdWVzdGlvbi4KJmd0OyZndDsKJmd0OyZn dDsKJmd0OyZndDsgU29ycnksIEkgcHJvdmlkZWQgaW5jb3JyZWN0IGluZm9ybWF0aW9uLgomZ3Q7 Jmd0OwomZ3Q7Jmd0OyBUaGUgaW5kZXggYWxzbyBkb2VzIG5vdCB3b3JrIGluIHRoZSBmb2xsb3dp bmcgcXVlcnkgc3RhdGVtZW50LgomZ3Q7Jmd0OwomZ3Q7Jmd0OwomZ3Q7Jmd0OyAmZ3Q7IHNlbGVj dCBDT1VOVChFVF9DRCkKJmd0OyZndDsKJmd0OyZndDsgJmd0OyBmcm9tIFRCTF9TSEEKJmd0OyZn dDsKJmd0OyZndDsgJmd0OyBXSEVSRSBNU19DRCA9ICcwMDknCiZndDsmZ3Q7CiZndDsmZ3Q7ICZn dDsgQU5EIEVUUllTID0gJzAwMDAwMScKJmd0OyZndDsKJmd0OyZndDsKJmd0OyZndDsgUVVFUlkg UExBTgomZ3Q7Jmd0OwomZ3Q7Jmd0OyBMaW1pdCAgKGNvc3Q9MjQxOTY0My40Ny4uMjQxOTY0My40 OCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTEyODY2Ny40MzkuLjEyODY2OC4yNTAgcm93 cz0xIGxvb3BzPTEpCiZndDsmZ3Q7CiZndDsmZ3Q7ICAgLSZndDsgIEZpbmFsaXplIEFnZ3JlZ2F0 ZSAgKGNvc3Q9MjQxOTY0My40Ny4uMjQxOTY0My40OCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0 aW1lPTEyODY2Ny40MzcuLjEyODY2OC4yNDYgcm93cz0xIGxvb3BzPTEpCiZndDsmZ3Q7CiZndDsm Z3Q7ICAgICAgICAgLSZndDsgIEdhdGhlciAgKGNvc3Q9MjQxOTY0My4yNS4uMjQxOTY0My40NiBy b3dzPTIgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTEyODY2NC4xMDguLjEyODY2OC4yMzMgcm93cz0z IGxvb3BzPTEpCiZndDsmZ3Q7CiZndDsmZ3Q7ICAgICAgICAgICAgICAgV29ya2VycyBQbGFubmVk OiAyCiZndDsmZ3Q7CiZndDsmZ3Q7ICAgICAgICAgICAgICAgV29ya2VycyBMYXVuY2hlZDogMgom Z3Q7Jmd0OwomZ3Q7Jmd0OyAgICAgICAgICAgICAgIC0mZ3Q7ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAg KGNvc3Q9MjQxODY0My4yNS4uMjQxODY0My4yNiByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1l PTEyODY1NS4yNTYuLjEyODY1NS4yNTggcm93cz0xIGxvb3BzPTMpCiZndDsmZ3Q7CiZndDsmZ3Q7 ICAgICAgICAgICAgICAgICAgICAgLSZndDsgIFBhcmFsbGVsIFNlcSBTY2FuIG9uIFRCTF9TSEEg IChjb3N0PTAuMDAuLjI0MTU1NDguODUgcm93cz0xMjM3NzYyIHdpZHRoPTkpIChhY3R1YWwgdGlt ZT03NTM1Ny40NTUuLjEyODUzMS42MTUgcm93cz0xMDY2NjY3IGxvb3BzPTMpCiZndDsmZ3Q7CiZn dDsmZ3Q7ICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoKE1TX0NEID0gJzAwOSc6 OmJwY2hhcikgQU5EIChFVFJZUyA9ICcwMDAwMDEnOjpicGNoYXIpKQomZ3Q7Jmd0OwomZ3Q7Jmd0 OyAgICAgICAgICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDExODMz NDQyCiZndDsmZ3Q7CiZndDsmZ3Q7IFBsYW5uaW5nIFRpbWU6IDAuMTE4IG1zCiZndDsmZ3Q7CiZn dDsmZ3Q7IEV4ZWN1dGlvbiBUaW1lOiAxMjg2NjguMjkwIG1zCiZndDsmZ3Q7CiZndDsmZ3Q7CiZn dDsmZ3Q7IFRoZSBUQkxfU0hBIHRhYmxlIGhhcyBhbm90aGVyIGluZGV4LCBhcyBzaG93biBiZWxv dy4KJmd0OyZndDsKJmd0OyZndDsKJmd0OyZndDsgQ1JFQVRFIElOREVYIGluZGV4X3NlYXJjaF8w MiBPTiBtZGIuVEJMX1NIQSBVU0lORyBidHJlZSAoRVRfQ0QsIEVUUllTKQomZ3Q7Jmd0OwomZ3Q7 Jmd0OyBDUkVBVEUgSU5ERVggaW5kZXhfc2VhcmNoXzAzIE9OIG1kYi5UQkxfU0hBIFVTSU5HIGJ0 cmVlIChNU19DRCwgRVRfREFZLCBCS19DRCwgRlJfQ0QsIFJNX0NEKQomZ3Q7Jmd0OwomZ3Q7CiZn dDsmZ3Q7ICAgICAgICAgICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjog MTE4MzM0NDIKJmd0O3NlbGVjdCAoMzg3MDAzMjUgLSAxMTgzMzQ0MikgLzM4NzAwMzI1LjA7CiZn dDtpcyAwLjY5IGFwcHJveC4KJmd0O1NvIEkgdGhpbmsgaXQgc2F5cyBhcm91bmQgNjklICBvZiBy b3dzIHNhdGlzZnkgdGhlIHF1ZXJ5IGNvbmRpdGlvbi4KJmd0OwomZ3Q7YnV0IEkgYW0gbm90IHN1 cmUgaW4gdGhlIGZvbGxvd2luZyAyIGNhc2VzLCB3aGV0aGVyIHRoZSBhY3R1YWwgcm93cwomZ3Q7 YXJlIG5vaXN5IG9yIG5vdC4gSSBjYW4gbm90IGZpbmQgdGhlIGRvYyBleHBsYWluaW5nIGl0Lgom Z3Q7Jmd0OyBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGFjdHVhbCB0aW1lPTEyODY1NS4yNTYuLjEyODY1 NS4yNTggcm93cz0xIGxvb3BzPTMpCiZndDsmZ3Q7IEZpbmFsaXplIEFnZ3JlZ2F0ZSAoYWN0dWFs IHRpbWU9MTI4NjY3LjQzNy4uMTI4NjY4LjI0NiByb3dzPTEgbG9vcHM9MSkKPC9wcmU+PC9kaXY+ ------=_Part_21894_1720350711.1689904971143--