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 1qMNn9-002GrE-Dk for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 07:09:40 +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 1qMNn7-001mws-TD for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 07:09:37 +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 1qMNn6-001mvf-O4 for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 07:09:37 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMNn2-000SJw-6M for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 07:09:35 +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=PwSkd3fHT3icb7Mx65D0J7pdKHxP/L/H3eqKdef56gg=; b=O rz4Ko9qCcUU1HHUncbYClXj8ARtgqpJgzfqc/+n/mGN3SqdBRCaq5GPf5TjhoM+H oc4Hm+78rOPUpTEOsdFUnMGlAJe2749V8p3+xVGTXWs2ZYmohOmYi5WWNXqQi6R7 YEyKkEHCXlZi9zAahFfpCCe6061qIQx0DfZhLmbLVM= Received: from gzhcoder$126.com ( [222.175.120.219, 211.144.19.63] ) by ajax-webmail-wmsvr50 (Coremail) ; Thu, 20 Jul 2023 15:09:22 +0800 (CST) X-Originating-IP: [222.175.120.219, 211.144.19.63] Date: Thu, 20 Jul 2023 15:09:22 +0800 (CST) From: gzh To: pgsql-general@lists.postgresql.org Subject: =?GBK?Q?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 X-NTES-SC: AL_QuyTC/SYuUEt5CeeZ+kXk0oXj+Y2WsK2vPgv245ROZ00uCrq9DguVlRMFl33y86FBS+MmzOsUApTw9V1Q45Ke6OpLvhjyfmP+iwKInGDFW1K Content-Type: multipart/alternative; boundary="----=_Part_62096_172103084.1689836962764" MIME-Version: 1.0 Message-ID: <6212ea1b.425b.1897221c3cc.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowAB3HFuj3bhk41IGAA--.53412W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbiuByyWWJVnGu-OwACsJ X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_62096_172103084.1689836962764 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGkgZXZlcnlvbmUsCgoKCgpJJ20gcnVubmluZyBpbnRvIHNvbWUgcGVyZm9ybWFuY2UgaXNzdWVz IHdpdGggbXkgU1FMIHF1ZXJ5LgoKVGhlIGZvbGxvd2luZyBTUUwgcXVlcnkgaXMgdGFraW5nIGEg bG9uZyB0aW1lIHRvIGV4ZWN1dGUuCgoKCgpleHBsYWluIGFuYWx5emUKCnNlbGVjdCBDT1VOVChF VF9DRCkKCmZyb20gVEJMX1NIQQoKV0hFUkUgVEJMX1NIQS5NU19DRCA9ICcwMDknCgphbmQgVEJM X1NIQS5FVFJZUyBpbgoKICAgKHNlbGVjdCBUQkxfSU5GLlJZX0NECgogICAgZnJvbSBUQkxfSU5G CgogICAgV0hFUkUgVEJMX0lORi5NU19DRCA9ICcwMDknCgogICBBTkQgVEJMX0lORi5SWV9DRCA9 ICcwMDAwMDEnCgogICApCgotLS0tLSBFeGVjdXRpb24gUGxhbiAtLS0tLQoKTGltaXQgIChjb3N0 PTI3Mzg3MDkuNTcuLjI3Mzg3MDkuNTggcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0xMjQx NjguNzY5Li4xMjQxNjguNzcxIHJvd3M9MSBsb29wcz0xKQoKICAtPiAgQWdncmVnYXRlICAoY29z dD0yNzM4NzA5LjU3Li4yNzM4NzA5LjU4IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MTI0 MTY4Ljc2Ny4uMTI0MTY4Ljc2OSByb3dzPTEgbG9vcHM9MSkKCiAgICAgICAgLT4gIE5lc3RlZCBM b29wICAoY29zdD0wLjI5Li4yNzMwNzAyLjYzIHJvd3M9MzIwMjc3NCB3aWR0aD05KSAoYWN0dWFs IHRpbWU9OTcyNjQuMTY2Li4xMjM5MjAuNzY5IHJvd3M9MzIwMDAwMCBsb29wcz0xKQoKICAgICAg ICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIFRCTF9JTkZfcGtjIG9uIFRCTF9JTkYg IChjb3N0PTAuMjkuLjguMzEgcm93cz0xIHdpZHRoPTkpIChhY3R1YWwgdGltZT0wLjAyNS4uMC4w MzAgcm93cz0xIGxvb3BzPTEpCgogICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgoTVNf Q0QgPSAnMDA5Jzo6YnBjaGFyKSBBTkQgKFJZX0NEID0gJzAwMDAwMSc6OmJwY2hhcikpCgogICAg ICAgICAgICAgICAgICAgIEhlYXAgRmV0Y2hlczogMQoKICAgICAgICAgICAgICAtPiAgU2VxIFNj YW4gb24gVEJMX1NIQSAgKGNvc3Q9MC4wMC4uMjY5ODY2Ni41OCByb3dzPTMyMDI3NzQgd2lkdGg9 MTgpIChhY3R1YWwgdGltZT05NzI2NC4xMzguLjEyMzU1NC43OTIgcm93cz0zMjAwMDAwIGxvb3Bz PTEpCgogICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKChNU19DRCA9ICcwMDknOjpicGNoYXIp IEFORCAoRVRSWVMgPSAnMDAwMDAxJzo6YnBjaGFyKSkKCiAgICAgICAgICAgICAgICAgICAgUm93 cyBSZW1vdmVkIGJ5IEZpbHRlcjogMzIwMDAzMjUKClBsYW5uaW5nIFRpbWU6IDAuMTYyIG1zCgpF eGVjdXRpb24gVGltZTogMTI0MTY4LjgzOCBtcwoKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KCgoK ClRoZSBpbmRleCBpcyBkZWZpbmVkIGFzIGZvbGxvd3MuCgoKCgpDUkVBVEUgSU5ERVggaW5kZXhf c2VhcmNoXzAxIE9OIG1kYi5UQkxfU0hBIFVTSU5HIGJ0cmVlIChNU19DRCwgRVRSWVMpOwoKCgoK CgoKV2hlbiBJIHRha2UgdGhlIGZvbGxvd2luZyBzcWwgc3RhdGVtZW50LCB0aGUgaW5kZXggd29y a3MgZmluZSBhbmQgdGhlIHF1ZXJ5IGlzIGZhc3QuCgoKCgpzZWxlY3QgQ09VTlQoRVRfQ0QpCgpm cm9tIFRCTF9TSEEKCldIRVJFIE1TX0NEID0gJzAwOScKCkFORCBFVFJZUyA9ICcwMDAwMDEnCgoK CgpUaGUgYW1vdW50IG9mIGRhdGEgaW4gdGhlIHRhYmxlIGlzIGFzIGZvbGxvd3MuCgpUQkxfU0hB ICAgIDM4NzAwMzI1CgpUQkxfSU5GICAgIDM1NTQ2CgoKCgpBbnkgc3VnZ2VzdGlvbnMgZm9yIGlt cHJvdmluZyB0aGUgcGVyZm9ybWFuY2Ugb2YgdGhlIHF1ZXJ5IHdvdWxkIGJlIGdyZWF0bHkgYXBw cmVjaWF0ZWQuCgoKCgpUaGFua3MgaW4gYWR2YW5jZSE= ------=_Part_62096_172103084.1689836962764 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46MDsiPkhpIGV2ZXJ5b25lLDwvcD48 cCBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPkknbSBydW5u aW5nIGludG8gc29tZSBwZXJmb3JtYW5jZSBpc3N1ZXMgd2l0aCBteSBTUUwgcXVlcnkuPC9wPjxw IHN0eWxlPSJtYXJnaW46MDsiPlRoZSBmb2xsb3dpbmcgU1FMIHF1ZXJ5IGlzIHRha2luZyBhIGxv bmcgdGltZSB0byBleGVjdXRlLjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0 eWxlPSJtYXJnaW46MDsiPmV4cGxhaW4gYW5hbHl6ZTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5z ZWxlY3QgQ09VTlQoRVRfQ0QpPC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPmZyb20gVEJMX1NIQTwv cD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5XSEVSRSBUQkxfU0hBLk1TX0NEID0gJzAwOSc8L3A+PHAg c3R5bGU9Im1hcmdpbjowOyI+YW5kIFRCTF9TSEEuRVRSWVMgaW48L3A+PHAgc3R5bGU9Im1hcmdp bjowOyI+Jm5ic3A7ICZuYnNwOyhzZWxlY3QgVEJMX0lORi5SWV9DRDwvcD48cCBzdHlsZT0ibWFy Z2luOjA7Ij4mbmJzcDsgJm5ic3A7IGZyb20gVEJMX0lORjwvcD48cCBzdHlsZT0ibWFyZ2luOjA7 Ij4mbmJzcDsgJm5ic3A7IFdIRVJFIFRCTF9JTkYuTVNfQ0QgPSAnMDA5JzwvcD48cCBzdHlsZT0i bWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7QU5EIFRCTF9JTkYuUllfQ0QgPSAnMDAwMDAxJzwvcD48 cCBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7KTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7 Ij4tLS0tLSBFeGVjdXRpb24gUGxhbiAtLS0tLTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5MaW1p dCZuYnNwOyAoY29zdD0yNzM4NzA5LjU3Li4yNzM4NzA5LjU4IHJvd3M9MSB3aWR0aD04KSAoYWN0 dWFsIHRpbWU9MTI0MTY4Ljc2OS4uMTI0MTY4Ljc3MSByb3dzPTEgbG9vcHM9MSk8L3A+PHAgc3R5 bGU9Im1hcmdpbjowOyI+Jm5ic3A7IC0mZ3Q7Jm5ic3A7IEFnZ3JlZ2F0ZSZuYnNwOyAoY29zdD0y NzM4NzA5LjU3Li4yNzM4NzA5LjU4IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MTI0MTY4 Ljc2Ny4uMTI0MTY4Ljc2OSByb3dzPTEgbG9vcHM9MSk8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+ Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IC0mZ3Q7Jm5ic3A7IE5lc3RlZCBMb29wJm5ic3A7 IChjb3N0PTAuMjkuLjI3MzA3MDIuNjMgcm93cz0zMjAyNzc0IHdpZHRoPTkpIChhY3R1YWwgdGlt ZT05NzI2NC4xNjYuLjEyMzkyMC43Njkgcm93cz0zMjAwMDAwIGxvb3BzPTEpPC9wPjxwIHN0eWxl PSJtYXJnaW46MDsiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAtJmd0OyZuYnNwOyBJbmRleCBPbmx5IFNjYW4gdXNpbmcgVEJMX0lORl9wa2Mgb24gVEJM X0lORiZuYnNwOyAoY29zdD0wLjI5Li44LjMxIHJvd3M9MSB3aWR0aD05KSAoYWN0dWFsIHRpbWU9 MC4wMjUuLjAuMDMwIHJvd3M9MSBsb29wcz0xKTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJz cDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNw OyAmbmJzcDsgSW5kZXggQ29uZDogKChNU19DRCA9ICcwMDknOjpicGNoYXIpIEFORCAoUllfQ0Qg PSAnMDAwMDAxJzo6YnBjaGFyKSk8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+Jm5ic3A7ICZuYnNw OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 IEhlYXAgRmV0Y2hlczogMTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij4mbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgLSZndDsmbmJzcDsgU2VxIFNjYW4gb24g VEJMX1NIQSZuYnNwOyAoY29zdD0wLjAwLi4yNjk4NjY2LjU4IHJvd3M9MzIwMjc3NCB3aWR0aD0x OCkgKGFjdHVhbCB0aW1lPTk3MjY0LjEzOC4uMTIzNTU0Ljc5MiByb3dzPTMyMDAwMDAgbG9vcHM9 MSk8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZu YnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IEZpbHRlcjogKChNU19DRCA9 ICcwMDknOjpicGNoYXIpIEFORCAoRVRSWVMgPSAnMDAwMDAxJzo6YnBjaGFyKSk8L3A+PHAgc3R5 bGU9Im1hcmdpbjowOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDMyMDAw MzI1PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPlBsYW5uaW5nIFRpbWU6IDAuMTYyIG1zPC9wPjxw IHN0eWxlPSJtYXJnaW46MDsiPkV4ZWN1dGlvbiBUaW1lOiAxMjQxNjguODM4IG1zPC9wPjxwIHN0 eWxlPSJtYXJnaW46MDsiPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPC9wPjxwIHN0eWxlPSJtYXJn aW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+VGhlIGluZGV4IGlzIGRlZmluZWQg YXMgZm9sbG93cy48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFy Z2luOjA7Ij5DUkVBVEUgSU5ERVggaW5kZXhfc2VhcmNoXzAxIE9OIG1kYi5UQkxfU0hBIFVTSU5H IGJ0cmVlIChNU19DRCwgRVRSWVMpOzwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxw IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+V2hlbiBJIHRh a2UgdGhlIGZvbGxvd2luZyBzcWwgc3RhdGVtZW50LCB0aGUgaW5kZXggd29ya3MgZmluZSBhbmQg dGhlIHF1ZXJ5IGlzIGZhc3QuPC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5 bGU9Im1hcmdpbjowOyI+c2VsZWN0IENPVU5UKEVUX0NEKTwvcD48cCBzdHlsZT0ibWFyZ2luOjA7 Ij5mcm9tIFRCTF9TSEE8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+V0hFUkUgTVNfQ0QgPSAnMDA5 JzwvcD48cCBzdHlsZT0ibWFyZ2luOjA7Ij5BTkQgRVRSWVMgPSAnMDAwMDAxJzwvcD48cCBzdHls ZT0ibWFyZ2luOjA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46MDsiPlRoZSBhbW91bnQgb2Yg ZGF0YSBpbiB0aGUgdGFibGUgaXMgYXMgZm9sbG93cy48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+ VEJMX1NIQSZuYnNwOyAmbmJzcDsgMzg3MDAzMjU8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+VEJM X0lORiZuYnNwOyAmbmJzcDsgMzU1NDY8L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+PGJyPjwvcD48 cCBzdHlsZT0ibWFyZ2luOjA7Ij5Bbnkgc3VnZ2VzdGlvbnMgZm9yIGltcHJvdmluZyB0aGUgcGVy Zm9ybWFuY2Ugb2YgdGhlIHF1ZXJ5IHdvdWxkIGJlIGdyZWF0bHkgYXBwcmVjaWF0ZWQuPC9wPjxw IHN0eWxlPSJtYXJnaW46MDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjowOyI+VGhhbmtzIGlu IGFkdmFuY2UhPC9wPjwvZGl2Pg== ------=_Part_62096_172103084.1689836962764--