Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDjNF-0008Ln-Mm for pgsql-general@arkaria.postgresql.org; Mon, 26 Jun 2023 10:23:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qDjNE-0006q4-4K for pgsql-general@arkaria.postgresql.org; Mon, 26 Jun 2023 10:23:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDjND-0006pv-0U for pgsql-general@lists.postgresql.org; Mon, 26 Jun 2023 10:23:07 +0000 Received: from m7214.mail.163.com ([220.181.72.14]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qDjN9-000ZF5-73 for pgsql-general@lists.postgresql.org; Mon, 26 Jun 2023 10:23:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=afEN7A206pbhvybH6Yru1TzEalog8WA015p7ueDvAL4=; b=D qPjlqpc24xJD6Nq9vmoUbzrdNJUOni4dsQhlcDb+gHIqK5jK7pMtCWBtYEC/9zN/ E6eHBjSXSTOa6jN0eHYfJeylwXcqZFXFU32LwUgFE2PHWfns3bzJH4rllSiOQ6QS 3KHVxiYpLL8j+LVYH7wvqwKnb7e76TVDPjj7EupIVI= Received: from cavonchen$163.com ( [139.159.170.10] ) by ajax-webmail-wmsvr222 (Coremail) ; Mon, 26 Jun 2023 18:22:58 +0800 (GMT+08:00) X-Originating-IP: [139.159.170.10] Date: Mon, 26 Jun 2023 18:22:58 +0800 (GMT+08:00) From: =?UTF-8?B?6ZmI6ZSh5rGJ?= To: "pavel.stehule" Cc: pgsql-general Subject: =?UTF-8?Q?=E5=9B=9E=E5=A4=8D=EF=BC=9AHow_to_show_current_schema_of?= =?UTF-8?Q?_running_queries_in_postgresql_13?= X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.13 build 20210622(1d4788a8) MailAndroid/7.14.7_(12) Copyright (c) 2002-2023 www.mailtech.cn 163com In-Reply-To: References: X-NTES-SC: AL_QuyTBfucu0Es7iWQYekZnEgXgeg9X8qysvUv24dSPps0sSH38Tk4cHhqGEX12d+iCB+unjaPfTlV5PRFQ6pzcKxMhCfBOofUMUCdWAnpVSTp Content-Type: multipart/alternative; boundary="----=_Part_109825_1686156381.1687774978587" MIME-Version: 1.0 Message-ID: <66b3ebd1.90e4.188f73a621c.Coremail.cavonchen@163.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: p8eowACH+kgCZ5lkIbwvAA--.860W X-CM-SenderInfo: pfdy00hfkh0qqrwthudrp/1tbiKRKatlXl6OKwlAABsI X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_109825_1686156381.1687774978587 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 SSBoYXZlIG5vIHdheSB0byBmb3JjZSB1c2VycyBkb2luZyB0aGlz4oCmCgoKCi0tLS0g5Zue5aSN 55qE5Y6f6YKu5Lu2IC0tLS0KfCDlj5Hku7bkurogfCBQYXZlbCBTdGVodWxlPHBhdmVsLnN0ZWh1 bGVAZ21haWwuY29tPiB8Cnwg5pel5pyfIHwgMjAyM+W5tDA25pyIMjbml6UgMTc6NTEgfAp8IOaU tuS7tuS6uiB8IOmZiOmUoeaxiTxjYXZvbmNoZW5AMTYzLmNvbT4gfAp8IOaKhOmAgeiHsyB8IHBn c3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmcgfAp8IOS4u+mimCB8IFJlOiBIb3cgdG8g c2hvdyBjdXJyZW50IHNjaGVtYSBvZiBydW5uaW5nIHF1ZXJpZXMgaW4gcG9zdGdyZXNxbCAxMyB8 CgoKCgpwbyAyNi4gNi4gMjAyMyB2IDk6MTkgb2Rlc8OtbGF0ZWwgUGF2ZWwgU3RlaHVsZSA8cGF2 ZWwuc3RlaHVsZUBnbWFpbC5jb20+IG5hcHNhbDoKCkhpCgoKCgoKCgpubywgdGhlcmUgaXMgbm90 aGluZyBmb3IgdGhpcyBwdXJwb3NlLgoKCnlvdSBjYW4gdXNlIGFwcGxpY2F0aW9uX25hbWUKCgpz byB1c2VyIGNhbiBkbwoKClNFVCBzZWFyY2hfcGF0aD1NeVNjaGVtYTsKU0VUIGFwcGxpY2F0aW9u X25hbWUgPSAnTXlTY2hlbWEnOwpTRUxFQ1QgKiBGUk9NIC4uLgoKCgoKYW5kIGFwcGxpY2F0aW9u IG5hbWUgaXMgdmlzaWJsZSBmcm9tIHBnX3N0YXRfYWN0aXZpdHkKCgpyZWdhcmRzCgoKUGF2ZWwg U3RlaHVsZQogCgoKCgoKIAoKClRoYW5rIHlvdSEKQmVzdCByZWdhcmRzLApDYXZvbkNoZW4KCgoK ------=_Part_109825_1686156381.1687774978587 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 SSBoYXZlIG5vIHdheSB0byBmb3JjZSB1c2VycyBkb2luZyB0aGlz4oCmPGJyPjxicj48YnI+PGh0 bWw+CjxoZWFkPgogICAgPG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0 ZXh0L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPgo8L2hlYWQ+Cjxib2R5Pgo8ZGl2IGNsYXNzPSJudGVz LW1haWxtYXN0ZXItcXVvdGUiIHN0eWxlPSJwYWRkaW5nLXRvcDogMXB4OyBwYWRkaW5nLWJvdHRv bTogMXB4Ij4KICAgIDxkaXYgc3R5bGU9IiBtYXJnaW4tdG9wOiAyMHB4OyBtYXJnaW4tYm90dG9t OiAxMnB4OyBmb250LXNpemU6IDE0cHg7IGxpbmUtaGVpZ2h0OiAxLjI1OyBjb2xvcjogIzg5ODk4 YzsgIj4tLS0tIOWbnuWkjeeahOWOn+mCruS7tiAtLS0tPC9kaXY+CiAgICA8ZGl2IHN0eWxlPSIg bWFyZ2luLWJvdHRvbTogMTJweDsgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMS4yNTsg Y29sb3I6ICMyYzJjMmU7IHBhZGRpbmc6IDJweDsgYm9yZGVyLXJhZGl1czogOHB4OyBiYWNrZ3Jv dW5kLWNvbG9yOiAjZjBmMGYwOyAiPgogICAgICAgIDx0YWJsZSB3aWR0aD0iMTAwJSIgY2VsbHBh ZGRpbmc9IjAiIGNlbGxzcGFjaW5nPSIxMCIgYm9yZGVyPSIwIj4KICAgICAgICAgICAgPHRyPgog ICAgICAgICAgICAgICAgPHRkIHZhbGlnbj0idG9wIiBzdHlsZT0iIHdpZHRoOiA0ZW07IGZvbnQt c2l6ZTogMTNweDsgbGluZS1oZWlnaHQ6IDEuMjU7IGNvbG9yOiAjODk4OThjOyB3aGl0ZS1zcGFj ZTogbm93cmFwOyAiPuWPkeS7tuS6ujwvdGQ+CiAgICAgICAgICAgICAgICA8dGQgdmFsaWduPSJ0 b3AiIHN0eWxlPSIgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMS4yNTsgY29sb3I6ICMy YzJjMmU7IHdvcmQtYnJlYWs6IGJyZWFrLWFsbDsgIj48YSBjbGFzcz0ibWFpbC1mcm9tIiBzdHls ZT0iY29sb3I6ICMxYzgzZWI7IHRleHQtZGVjb3JhdGlvbjogbm9uZSIgaHJlZj0ibWFpbHRvOnBh dmVsLnN0ZWh1bGVAZ21haWwuY29tIj5QYXZlbCBTdGVodWxlJmx0O3BhdmVsLnN0ZWh1bGVAZ21h aWwuY29tJmd0OzwvYT48L3RkPgogICAgICAgICAgICA8L3RyPgogICAgICAgICAgICA8dHI+CiAg ICAgICAgICAgICAgICA8dGQgdmFsaWduPSJ0b3AiIHN0eWxlPSIgd2lkdGg6IDRlbTsgZm9udC1z aXplOiAxM3B4OyBsaW5lLWhlaWdodDogMS4yNTsgY29sb3I6ICM4OTg5OGM7IHdoaXRlLXNwYWNl OiBub3dyYXA7ICI+5pel5pyfPC90ZD4KICAgICAgICAgICAgICAgIDx0ZCBjbGFzcz0ibWFpbC1k YXRlIiB2YWxpZ249InRvcCIgc3R5bGU9IiBmb250LXNpemU6IDEzcHg7IGxpbmUtaGVpZ2h0OiAx LjI1OyBjb2xvcjogIzJjMmMyZTsgd29yZC1icmVhazogYnJlYWstYWxsOyAiPjIwMjPlubQwNuac iDI25pelIDE3OjUxPC90ZD4KICAgICAgICAgICAgPC90cj4KICAgICAgICAgICAgPHRyIHN0eWxl PSIiPgogICAgICAgICAgICAgICAgPHRkIHZhbGlnbj0idG9wIiBzdHlsZT0iIHdpZHRoOiA0ZW07 IGZvbnQtc2l6ZTogMTNweDsgbGluZS1oZWlnaHQ6IDEuMjU7IGNvbG9yOiAjODk4OThjOyAiPuaU tuS7tuS6ujwvdGQ+CiAgICAgICAgICAgICAgICA8dGQgdmFsaWduPSJ0b3AiIHN0eWxlPSIgZm9u dC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMS4yNTsgY29sb3I6ICMyYzJjMmU7IHdvcmQtYnJl YWs6IGJyZWFrLWFsbDsgIj48YSBjbGFzcz0ibWFpbC10byIgc3R5bGU9ImNvbG9yOiAjMWM4M2Vi OyB0ZXh0LWRlY29yYXRpb246IG5vbmUiIGhyZWY9Im1haWx0bzpjYXZvbmNoZW5AMTYzLmNvbSI+ 6ZmI6ZSh5rGJJmx0O2Nhdm9uY2hlbkAxNjMuY29tJmd0OzwvYT48L3RkPgogICAgICAgICAgICA8 L3RyPgogICAgICAgICAgICA8dHIgc3R5bGU9IiI+CiAgICAgICAgICAgICAgICA8dGQgdmFsaWdu PSJ0b3AiIHN0eWxlPSIgd2lkdGg6IDRlbTsgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDog MS4yNTsgY29sb3I6ICM4OTg5OGM7ICI+5oqE6YCB6IezPC90ZD4KICAgICAgICAgICAgICAgIDx0 ZCB2YWxpZ249InRvcCIgc3R5bGU9IiBmb250LXNpemU6IDEzcHg7IGxpbmUtaGVpZ2h0OiAxLjI1 OyBjb2xvcjogIzJjMmMyZTsgd29yZC1icmVhazogYnJlYWstYWxsOyAiPjxhIGNsYXNzPSJtYWls LWNjIiBzdHlsZT0iY29sb3I6ICMxYzgzZWI7IHRleHQtZGVjb3JhdGlvbjogbm9uZSIgaHJlZj0i bWFpbHRvOnBnc3FsLWdlbmVyYWxAbGlzdHMucG9zdGdyZXNxbC5vcmciPnBnc3FsLWdlbmVyYWxA bGlzdHMucG9zdGdyZXNxbC5vcmc8L2E+PC90ZD4KICAgICAgICAgICAgPC90cj4KICAgICAgICAg ICAgPHRyPgogICAgICAgICAgICAgICAgPHRkIHZhbGlnbj0idG9wIiBzdHlsZT0iIHdpZHRoOiA0 ZW07IGZvbnQtc2l6ZTogMTNweDsgbGluZS1oZWlnaHQ6IDEuMjU7IGNvbG9yOiAjODk4OThjOyAi PuS4u+mimDwvdGQ+CiAgICAgICAgICAgICAgICA8dGQgY2xhc3M9Im1haWwtc3ViamVjdCIgdmFs aWduPSJ0b3AiIHN0eWxlPSIgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMS4yNTsgY29s b3I6ICMyYzJjMmU7IHdvcmQtYnJlYWs6IGJyZWFrLWFsbDsgIj5SZTogSG93IHRvIHNob3cgY3Vy cmVudCBzY2hlbWEgb2YgcnVubmluZyBxdWVyaWVzIGluIHBvc3RncmVzcWwgMTM8L3RkPgogICAg ICAgICAgICA8L3RyPgogICAgICAgIDwvdGFibGU+CiAgICA8L2Rpdj4KICAgIDxkaXY+PGRpdiBk aXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+PGJyPjwvZGl2Pjxicj48ZGl2IGNsYXNzPSJnbWFpbF9x dW90ZSI+PGRpdiBkaXI9Imx0ciIgY2xhc3M9ImdtYWlsX2F0dHIiPnBvIDI2LiA2LiAyMDIzIHYm bmJzcDs5OjE5IG9kZXPDrWxhdGVsIFBhdmVsIFN0ZWh1bGUgJmx0OzxhIGhyZWY9Im1haWx0bzpw YXZlbC5zdGVodWxlQGdtYWlsLmNvbSI+cGF2ZWwuc3RlaHVsZUBnbWFpbC5jb208L2E+Jmd0OyBu YXBzYWw6PGJyPjwvZGl2PjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1h cmdpbjowcHggMHB4IDBweCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQs MjA0KTtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2IGRpcj0ibHRyIj48ZGl2PkhpPGJyPjwvZGl2Pjxi cj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+PGJyPjxkaXY+PGJyPjwvZGl2PjxkaXY+bm8sIHRo ZXJlIGlzIG5vdGhpbmcgZm9yIHRoaXMgcHVycG9zZS48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2 PnlvdSBjYW4gdXNlIGFwcGxpY2F0aW9uX25hbWU8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PnNv IHVzZXIgY2FuIGRvPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5TRVQgc2VhcmNoX3BhdGg9TXlT Y2hlbWE7PC9kaXY+PGRpdj5TRVQgYXBwbGljYXRpb25fbmFtZSA9ICdNeVNjaGVtYSc7PC9kaXY+ PGRpdj5TRUxFQ1QgKiBGUk9NIC4uLjwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2PjwvZGl2Pjwv YmxvY2txdW90ZT48ZGl2Pjxicj48L2Rpdj48ZGl2PmFuZCBhcHBsaWNhdGlvbiBuYW1lIGlzIHZp c2libGUgZnJvbSBwZ19zdGF0X2FjdGl2aXR5PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5yZWdh cmRzPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5QYXZlbCBTdGVodWxlPC9kaXY+PGRpdj4mbmJz cDs8YnI+PC9kaXY+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2lu OjBweCAwcHggMHB4IDAuOGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQp O3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgZGlyPSJsdHIiPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3Rl Ij48ZGl2PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Jm5ic3A7PGJy PjwvZGl2PjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowcHgg MHB4IDBweCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQsMjA0KTtwYWRk aW5nLWxlZnQ6MWV4Ij48YnI+VGhhbmsgeW91ITxicj5CZXN0IHJlZ2FyZHMsPGJyPkNhdm9uQ2hl bjxicj48YnI+PGJyPjxicj4KCiAgICAKCjxkaXY+Cgo8L2Rpdj4KPC9ibG9ja3F1b3RlPjwvZGl2 PjwvZGl2Pgo8L2Jsb2NrcXVvdGU+PC9kaXY+PC9kaXY+CjwvZGl2Pgo8L2Rpdj4KPC9ib2R5Pgo8 L2h0bWw+ ------=_Part_109825_1686156381.1687774978587--