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 1qMfBi-002xzQ-Q3 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 01:44:11 +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 1qMfBg-0078h0-F9 for pgsql-general@arkaria.postgresql.org; Fri, 21 Jul 2023 01:44:08 +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 1qMfBf-0078ZD-94 for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 01:44:07 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMfBZ-000bGM-90 for pgsql-general@lists.postgresql.org; Fri, 21 Jul 2023 01:44:04 +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=7IpYNoqidDcoWb0ysBqvXy+GTXuw1OvYtQLtYI93pko=; b=Q yycPGzx5gr/eCemU1cIyW0zVCu39t5vytssu3z3+27hSX+FLRzWTTXUxmlr76rNg GUZFBfUri3nxZ3r89RwHsWMkInAdmFDwi4bmBEOv9jeryhhVWHubovn2WsKAlal3 1XyAemOSuA5FBTxOVkzJ/iwiw5Mgp1bmEXNB0xLsSU= Received: from gzhcoder$126.com ( [119.163.77.89] ) by ajax-webmail-wmsvr50 (Coremail) ; Fri, 21 Jul 2023 09:43:52 +0800 (CST) X-Originating-IP: [119.163.77.89] Date: Fri, 21 Jul 2023 09:43:52 +0800 (CST) From: gzh To: "Laurenz Albe" Cc: pgsql-general@lists.postgresql.org Subject: =?GBK?Q?Re:_How_to_improve_the_performance_of_my_SQL_query=A3=BF?= 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> <369ee851ef59bc84190f1631219b5a0c8f7907e9.camel@cybertec.at> <1937d056.71e9.18973a752d0.Coremail.gzhcoder@126.com> X-NTES-SC: AL_QuyTC/WbvEAo5CKeYekWnEgXj+c7Xsu4u/0v34FSNps0uCrA2TAuVlREDHH3y86wCC+MmzORYiJP1fpRcbJTY6NcU3T9BDLkY2U1nfEIG3gn Content-Type: multipart/alternative; boundary="----=_Part_17443_457907784.1689903832268" MIME-Version: 1.0 Message-ID: <6f3fd2f9.12b3.189761e1ccc.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowACHLFvZ4rlkb7UGAA--.56895W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi3AezWVpEFq1g2AABst X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_17443_457907784.1689903832268 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 VGhlIGRlZmluaXRpb25zIG9mIHRoZSBjb2x1bW5zIHVzZWQgaW4gU1FMIGFyZSBhcyBmb2xsb3dz LgoKCgoKVEJMX1NIQQoKCgoKbXNfY2QgY2hhcmFjdGVyKDYpIE5PVCBOVUxMICAgICAgIC0tIFBS SU1BUlkgS0VZCgpldF9jZCBjaGFyYWN0ZXIoOCkKCmV0cnlzIGNoYXJhY3Rlcig4KQoKCgoKVEJM X0lORgoKCgoKbXNfY2QgY2hhcmFjdGVyKDYpIE5PVCBOVUxMICAgICAgIC0tIFBSSU1BUlkgS0VZ CgpyeV9jZCBjaGFyYWN0ZXIoOCkgTk9UIE5VTEwgICAgICAgLS0gUFJJTUFSWSBLRVkKCgoKCkkg bWFkZSBzb21lIG1vZGlmaWNhdGlvbnMgdG8gdGhlIGRhdGEsIGFuZCBJIHJlYWxpemVkIHRoYXQg SSBzaG91bGQgbm90IGNoYW5nZSB0aGUgbGVuZ3RoIG9mIHRoZSBkYXRhLiAKClRoZSBhY3R1YWwg ZGF0YSBhbmQgaXRzIGNvcnJlc3BvbmRpbmcgZXhlY3V0aW9uIHBsYW4gYXJlIHNob3duIGJlbG93 LgoKCgoKZXhwbGFpbiBhbmFseXplCgpzZWxlY3QgQ09VTlQoRVRfQ0QpCgpmcm9tIFRCTF9TSEEK CldIRVJFIFRCTF9TSEEuTVNfQ0QgPSAnTUxEMDA5JwoKYW5kIFRCTF9TSEEuRVRSWVMgaW4KCiAg IChzZWxlY3QgVEJMX0lORi5SWV9DRAoKICAgIGZyb20gVEJMX0lORgoKICAgIFdIRVJFIFRCTF9J TkYuTVNfQ0QgPSAnTUxEMDA5JwoKICAgQU5EIFRCTF9JTkYuUllfQ0QgPSAnMDAwMDAwMDEnCgog ICApCgotLS0tLSBFeGVjdXRpb24gUGxhbiAtLS0tLQoKTGltaXQgIChjb3N0PTI3Mzg3MDkuNTcu LjI3Mzg3MDkuNTggcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0xMjQxNjguNzY5Li4xMjQx NjguNzcxIHJvd3M9MSBsb29wcz0xKQoKICAtPiAgQWdncmVnYXRlICAoY29zdD0yNzM4NzA5LjU3 Li4yNzM4NzA5LjU4IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MTI0MTY4Ljc2Ny4uMTI0 MTY4Ljc2OSByb3dzPTEgbG9vcHM9MSkKCiAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0w LjI5Li4yNzMwNzAyLjYzIHJvd3M9MzIwMjc3NCB3aWR0aD05KSAoYWN0dWFsIHRpbWU9OTcyNjQu MTY2Li4xMjM5MjAuNzY5IHJvd3M9MzIwMDAwMCBsb29wcz0xKQoKICAgICAgICAgICAgICAtPiAg SW5kZXggT25seSBTY2FuIHVzaW5nIFRCTF9JTkZfcGtjIG9uIFRCTF9JTkYgIChjb3N0PTAuMjku LjguMzEgcm93cz0xIHdpZHRoPTkpIChhY3R1YWwgdGltZT0wLjAyNS4uMC4wMzAgcm93cz0xIGxv b3BzPTEpCgogICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgoTVNfQ0QgPSAnTUxEMDA5 Jzo6YnBjaGFyKSBBTkQgKFJZX0NEID0gJzAwMDAwMDAxJzo6YnBjaGFyKSkKCiAgICAgICAgICAg ICAgICAgICAgSGVhcCBGZXRjaGVzOiAxCgogICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBU QkxfU0hBICAoY29zdD0wLjAwLi4yNjk4NjY2LjU4IHJvd3M9MzIwMjc3NCB3aWR0aD0xOCkgKGFj dHVhbCB0aW1lPTk3MjY0LjEzOC4uMTIzNTU0Ljc5MiByb3dzPTMyMDAwMDAgbG9vcHM9MSkKCiAg ICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoKE1TX0NEID0gJ01MRDAwOSc6OmJwY2hhcikgQU5E IChFVFJZUyA9ICcwMDAwMDAwMSc6OmJwY2hhcikpCgogICAgICAgICAgICAgICAgICAgIFJvd3Mg UmVtb3ZlZCBieSBGaWx0ZXI6IDMyMDAwMzI1CgpQbGFubmluZyBUaW1lOiAwLjE2MiBtcwoKRXhl Y3V0aW9uIFRpbWU6IDEyNDE2OC44MzggbXMKCgoKCgoKCgoKCgoKCgoKCgoKCgpBdCAyMDIzLTA3 LTIwIDIyOjQ4OjE5LCAiTGF1cmVueiBBbGJlIiA8bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0PiB3 cm90ZToKPk9uIFRodSwgMjAyMy0wNy0yMCBhdCAyMjoxNCArMDgwMCwgZ3poIHdyb3RlOgo+PiBU aGUgaW5mb3JtYXRpb24gSSBwcm92aWRlZCBpcyBpbmNvcnJlY3QsIHBsZWFzZSBzZWUgbXkgcHJl dmlvdXMgcmVwbHkuCj4KPk15IHF1ZXN0aW9uIHJlbWFpbnM6IEkgd291bGQgbGlrZSB0byBzZWUg dGhlIHRhYmxlIGRlZmluaXRpb25zLgo+Cj5BbHNvLCBkaWQgeW91IEFOQUxZWkUgdGhlIHRhYmxl cz8KPgo+WW91cnMsCj5MYXVyZW56IEFsYmUK ------=_Part_17443_457907784.1689903832268 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5UaGUgZGVmaW5pdGlvbnMg b2YgdGhlIGNvbHVtbnMgdXNlZCBpbiBTUUwgYXJlIGFzIGZvbGxvd3MuPC9wPjxwIHN0eWxlPSJt YXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5UQkxfU0hBPC9wPjxwIHN0 eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5tc19jZCBjaGFy YWN0ZXIoNikgTk9UIE5VTEwmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDstLSBQUklNQVJZIEtF WTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+ZXRfY2QgY2hhcmFjdGVyKDgpPC9wPjxwIHN0eWxl PSJtYXJnaW46IDA7Ij5ldHJ5cyBjaGFyYWN0ZXIoOCk8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsi Pjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPlRCTF9JTkY8L3A+PHAgc3R5bGU9Im1hcmdp bjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPm1zX2NkIGNoYXJhY3Rlcig2KSBO T1QgTlVMTCZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOy0tIFBSSU1BUlkgS0VZPC9wPjxwIHN0 eWxlPSJtYXJnaW46IDA7Ij5yeV9jZCBjaGFyYWN0ZXIoOCkgTk9UIE5VTEwmbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDstLSBQUklNQVJZIEtFWTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJy PjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+SSBtYWRlIHNvbWUgbW9kaWZpY2F0aW9ucyB0byB0 aGUgZGF0YSwgYW5kIEkgcmVhbGl6ZWQgdGhhdCBJIHNob3VsZCBub3QgY2hhbmdlIHRoZSBsZW5n dGggb2YgdGhlIGRhdGEuJm5ic3A7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5UaGUgYWN0dWFs IGRhdGEgYW5kIGl0cyBjb3JyZXNwb25kaW5nIGV4ZWN1dGlvbiBwbGFuIGFyZSBzaG93biBiZWxv dy48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsi PmV4cGxhaW4gYW5hbHl6ZTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+c2VsZWN0IENPVU5UKEVU X0NEKTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+ZnJvbSBUQkxfU0hBPC9wPjxwIHN0eWxlPSJt YXJnaW46IDA7Ij5XSEVSRSBUQkxfU0hBLk1TX0NEID0gJ01MRDAwOSc8L3A+PHAgc3R5bGU9Im1h cmdpbjogMDsiPmFuZCBUQkxfU0hBLkVUUllTIGluPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4m bmJzcDsgJm5ic3A7KHNlbGVjdCBUQkxfSU5GLlJZX0NEPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij4mbmJzcDsgJm5ic3A7IGZyb20gVEJMX0lORjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jm5i c3A7ICZuYnNwOyBXSEVSRSBUQkxfSU5GLk1TX0NEID0gJ01MRDAwOSc8L3A+PHAgc3R5bGU9Im1h cmdpbjogMDsiPiZuYnNwOyAmbmJzcDtBTkQgVEJMX0lORi5SWV9DRCA9ICcwMDAwMDAwMSc8L3A+ PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOyAmbmJzcDspPC9wPjxwIHN0eWxlPSJtYXJnaW46 IDA7Ij4tLS0tLSBFeGVjdXRpb24gUGxhbiAtLS0tLTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+ TGltaXQmbmJzcDsgKGNvc3Q9MjczODcwOS41Ny4uMjczODcwOS41OCByb3dzPTEgd2lkdGg9OCkg KGFjdHVhbCB0aW1lPTEyNDE2OC43NjkuLjEyNDE2OC43NzEgcm93cz0xIGxvb3BzPTEpPC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij4mbmJzcDsgLSZndDsmbmJzcDsgQWdncmVnYXRlJm5ic3A7IChj b3N0PTI3Mzg3MDkuNTcuLjI3Mzg3MDkuNTggcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0x MjQxNjguNzY3Li4xMjQxNjguNzY5IHJvd3M9MSBsb29wcz0xKTwvcD48cCBzdHlsZT0ibWFyZ2lu OiAwOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IC0mZ3Q7Jm5ic3A7IE5lc3RlZCBMb29w Jm5ic3A7IChjb3N0PTAuMjkuLjI3MzA3MDIuNjMgcm93cz0zMjAyNzc0IHdpZHRoPTkpIChhY3R1 YWwgdGltZT05NzI2NC4xNjYuLjEyMzkyMC43Njkgcm93cz0zMjAwMDAwIGxvb3BzPTEpPC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgLSZndDsmbmJzcDsgSW5kZXggT25seSBTY2FuIHVzaW5nIFRCTF9JTkZfcGtj IG9uIFRCTF9JTkYmbmJzcDsgKGNvc3Q9MC4yOS4uOC4zMSByb3dzPTEgd2lkdGg9OSkgKGFjdHVh bCB0aW1lPTAuMDI1Li4wLjAzMCByb3dzPTEgbG9vcHM9MSk8L3A+PHAgc3R5bGU9Im1hcmdpbjog MDsiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJz cDsgJm5ic3A7ICZuYnNwOyBJbmRleCBDb25kOiAoKE1TX0NEID0gJ01MRDAwOSc6OmJwY2hhcikg QU5EIChSWV9DRCA9ICcwMDAwMDAwMSc6OmJwY2hhcikpPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgSGVhcCBGZXRjaGVzOiAxPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4m bmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgLSZndDsmbmJz cDsgU2VxIFNjYW4gb24gVEJMX1NIQSZuYnNwOyAoY29zdD0wLjAwLi4yNjk4NjY2LjU4IHJvd3M9 MzIwMjc3NCB3aWR0aD0xOCkgKGFjdHVhbCB0aW1lPTk3MjY0LjEzOC4uMTIzNTU0Ljc5MiByb3dz PTMyMDAwMDAgbG9vcHM9MSk8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBG aWx0ZXI6ICgoTVNfQ0QgPSAnTUxEMDA5Jzo6YnBjaGFyKSBBTkQgKEVUUllTID0gJzAwMDAwMDAx Jzo6YnBjaGFyKSk8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBSb3dzIFJl bW92ZWQgYnkgRmlsdGVyOiAzMjAwMDMyNTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+UGxhbm5p bmcgVGltZTogMC4xNjIgbXM8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPkV4ZWN1dGlvbiBUaW1l OiAxMjQxNjguODM4IG1zPC9wPjxkaXY+PGJyPjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48 YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0 aW9uOnJlbGF0aXZlO3pvb206MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48 L2Rpdj48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cHJlPjxicj5BdCAyMDIzLTA3LTIw IDIyOjQ4OjE5LCAiTGF1cmVueiBBbGJlIiAmbHQ7bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0Jmd0 OyB3cm90ZToKJmd0O09uIFRodSwgMjAyMy0wNy0yMCBhdCAyMjoxNCArMDgwMCwgZ3poIHdyb3Rl OgomZ3Q7Jmd0OyBUaGUgaW5mb3JtYXRpb24gSSBwcm92aWRlZCBpcyBpbmNvcnJlY3QsIHBsZWFz ZSBzZWUgbXkgcHJldmlvdXMgcmVwbHkuCiZndDsKJmd0O015IHF1ZXN0aW9uIHJlbWFpbnM6IEkg d291bGQgbGlrZSB0byBzZWUgdGhlIHRhYmxlIGRlZmluaXRpb25zLgomZ3Q7CiZndDtBbHNvLCBk aWQgeW91IEFOQUxZWkUgdGhlIHRhYmxlcz8KJmd0OwomZ3Q7WW91cnMsCiZndDtMYXVyZW56IEFs YmUKPC9wcmU+PC9kaXY+ ------=_Part_17443_457907784.1689903832268--