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 1pTu42-0008MP-7K for pgsql-committers@arkaria.postgresql.org; Mon, 20 Feb 2023 00:29:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pTu40-0002Ml-Rq for pgsql-committers@arkaria.postgresql.org; Mon, 20 Feb 2023 00:29:52 +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 1pTu40-0002Mc-KR for pgsql-committers@lists.postgresql.org; Mon, 20 Feb 2023 00:29:52 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTu3x-0004Nx-K7 for pgsql-committers@lists.postgresql.org; Mon, 20 Feb 2023 00:29:52 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTu3v-0003mq-M5 for pgsql-committers@lists.postgresql.org; Mon, 20 Feb 2023 00:29:47 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pTu3u-00204Y-8m for pgsql-committers@lists.postgresql.org; Mon, 20 Feb 2023 00:29:46 +0000 Content-Type: multipart/mixed; boundary="===============8961402998453927157==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Refactor tests of pg_stat_statements for planning, utility and l X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 20 Feb 2023 00:29:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8961402998453927157== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVmYWN0b3IgdGVzdHMgb2YgcGdfc3RhdF9zdGF0ZW1lbnRzIGZvciBwbGFubmluZywgdXRpbGl0 eSBhbmQgbGV2ZWwgdHJhY2tpbmcKCnBnX3N0YXRfc3RhdGVtZW50cy5zcWwgYWN0cyBhcyB0aGUg bWFpbiBmaWxlIGZvciBhbGwgdGhlIGNvcmUgdGVzdHMgb2YKdGhlIG1vZHVsZSwgYnV0IHRoaW5n cyBoYXZlIGJlY29tZSBjb21wbGljYXRlZCB0byBmb2xsb3cgb3ZlciB0aGUgeWVhcnMKYXMgc29t ZSBvZiB0aGUgc3ViLXNjZW5hcmlvcyB0ZXN0ZWQgaW4gdGhpcyBmaWxlIHJlbHkgb24gYXNzdW1w dGlvbnMKdGhhdCBjb21lIGZyb20gY29tcGxldGVseSBkaWZmZXJlbnQgYXJlYXMgb2YgaXQsIGxp a2UgYSBHVUMgc2V0dXAgb3IgYQpyZWxhdGlvbiBjcmVhdGVkIHByZXZpb3VzbHkuICBGb3IgZXhh bXBsZSwgcm93IHRyYWNraW5nIGZvciBDVEFTL0NPUFkKd2FzIGxvb2tpbmcgYXQgdGhlIG51bWJl ciBvZiBwbGFucywgd2hpY2ggd2FzIG5vdCBuZWNlc3NhcnksIG9yIGxldmVsCnRyYWNraW5nIHdh cyBtaXhlZCB3aXRoIGNoZWNrcyBvbiBwbGFubmVyIGNvdW50cy4KClRoaXMgY29tbWl0IHJlZmFj dG9ycyB0aGUgdGVzdHMgb2YgcGdfc3RhdF9zdGF0ZW1lbnRzLCBieSBtb3ZpbmcgdGVzdApjYXNl cyBvdXQgb2YgcGdfc3RhdF9zdGF0ZW1lbnRzLnNxbCBpbnRvIHRoZWlyIG93biBmaWxlLCBhcyBv ZjoKLSBQbGFubmluZy1yZWxhdGVkIHRlc3RzIGluIHBsYW5uaW5nLnNxbCwgZm9yIFtyZV1wbGFu IGNvdW50cyBhbmQKdG9wLWxldmVsIGhhbmRsaW5nLiAgVGhlc2UgZGVwZW5kIG9uIHBnX3N0YXRf c3RhdGVtZW50cy50cmFja19wbGFubmluZy4KLSBVdGlsaXRpZXMgaW4gdXRpbGl0eS5zcWwgKHBn X3N0YXRfc3RhdGVtZW50cy50cmFja191dGlsaXR5KSwgdGhhdAppbmNsdWRlcyBub3cgdGhlIHRl c3RzIGZvcjoKLS0gUm93IHRyYWNraW5nIGZvciBDVEFTLCBDUkVBVEUgTUFURVJJQUxJWkVEIFZJ RVcsIENPUFkuCi0tIEJhc2ljIHV0aWxpdHkgc3RhdGVtZW50cy4KLS0gU0VUIHN0YXRlbWVudHMu Ci0gVHJhY2tpbmcgbGV2ZWwsIGRlcGVuZGluZyBvbiBwZ19zdGF0X3N0YXRlbWVudHMudHJhY2su ICBUaGlzIHBhcnQgaGFzCmJlZW4gbG9va2luZyBhdCBzY2VuYXJpb3Mgd2l0aCBETyBibG9ja3Ms IFBMIGZ1bmN0aW9ucyBhbmQgU1FMCmZ1bmN0aW9ucy4KCnBnX3N0YXRfc3RhdGVtZW50cy5zcWwg KHN0aWxsIG5hbWVkIHRoZSBzYW1lIGZvciBub3cpIHN0aWxsIGluY2x1ZGVzCnNvbWUgY2hlY2tz IGZvciByb2xlLWxldmVsIHRyYWNraW5nIGFuZCBXQUwgZ2VuZXJhdGlvbiBtZXRyaWNzLCB0aGF0 Cm91Z2h0IHRvIGJlY29tZSBpbmRlcGVuZGVudCBpbiB0aGUgbG9uZyB0ZXJtIGZvciBjbGFyaXR5 LgoKV2hpbGUgb24gaXQsIHRoaXMgc3dpdGNoZXMgdGhlIG9yZGVyIG9mIHRoZSBhdHRyaWJ1dGVz IHdoZW4gcXVlcnlpbmcKcGdfc3RhdF9zdGF0ZW1lbnRzLCB0aGUgcXVlcnkgZmllbGQgYmVjb21p bmcgbGFzdC4gIFRoaXMgbWFrZXMgbXVjaAplYXNpZXIgdGhlIHRyYWNraW5nIG9mIGNoYW5nZXMg cmVsYXRlZCB0byBub3JtYWxpemF0aW9uLCBhcyBxdWVyaWVzIGFyZQp0aGUgb25seSB2YXJpYWJs ZS1sZW5ndGggYXR0cmlidXRlcyBxdWVyaWVkICh1bmFsaWduZWQgbW9kZSB3b3VsZCBiZSBvbmUK ZXh0cmEgY2hvaWNlLCBidXQgdGhhdCByZWR1Y2VzIHRoZSBjaGVja3Mgb24gdGhlIG90aGVyIGZp ZWxkcykuCgpUZXN0IHNjZW5hcmlvcyBhbmQgdGhlaXIgcmVzdWx0cyBtYXRjaCBleGFjdGx5IHdp dGggd2hhdCB3YXMgaGFwcGVuaW5nCmJlZm9yZSB0aGlzIGNvbW1pdCBpbiB0ZXJtcyBvZiBjYWxs cywgbnVtYmVyIG9mIHBsYW5zLCBudW1iZXIgb2Ygcm93cywKY2FjaGVkIGRhdGEgb3IgbGV2ZWwg dHJhY2tpbmcsIHNvIHRoaXMgaGFzIG5vIGVmZmVjdCBvbiB0aGUgY292ZXJhZ2UgaW4KdGVybXMg b2Ygd2hhdCBpcyBwcm9kdWNlZCBieSB0aGUgcmVwb3J0cyBpbiB0aGUgdGFibGUKcGdfc3RhdF9z dGF0ZW1lbnRzLiAgQSBmb2xsb3ctdXAgcGF0Y2ggd2lsbCBleHRlbmQgbW9yZSB0aGUgdGVzdHMg b2YKcGdfc3RhdF9zdGF0ZW1lbnRzIGFyb3VuZCB1dGlsaXRpZXMsIHNvIHRoaXMgc3BsaXQgY3Jl YXRlcyBhIGZvdW5kYXRpb24KZm9yIHRoaXMgcHVycG9zZSwgd2l0aG91dCBjb21wbGljYXRpbmcg bW9yZSBwZ19zdGF0X3N0YXRlbWVudHMuc3FsLgoKUmV2aWV3ZWQtYnk6IEJlcnRyYW5kIERyb3V2 b3QKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9ZK01SZEVxOVc5WFZhMkFCQHBhcXVp ZXIueHl6CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0 LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZThkYmRiMTVkYmM4NTI5NTE4YWIwMzAzYmYz NThkMDdjN2FkOWUxOAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wZ19z dGF0X3N0YXRlbWVudHMvTWFrZWZpbGUgICAgICAgICAgICAgICAgfCAgIDIgKy0KY29udHJpYi9w Z19zdGF0X3N0YXRlbWVudHMvZXhwZWN0ZWQvY2xlYW51cC5vdXQgICAgfCAgIDEgKwouLi4vcGdf c3RhdF9zdGF0ZW1lbnRzL2V4cGVjdGVkL2xldmVsX3RyYWNraW5nLm91dCB8IDIwNCArKysrKysr KysrKwouLi4vZXhwZWN0ZWQvcGdfc3RhdF9zdGF0ZW1lbnRzLm91dCAgICAgICAgICAgICAgICB8 IDM5MyArLS0tLS0tLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wZ19zdGF0X3N0YXRlbWVudHMvZXhw ZWN0ZWQvcGxhbm5pbmcub3V0ICAgfCAgODggKysrKysKY29udHJpYi9wZ19zdGF0X3N0YXRlbWVu dHMvZXhwZWN0ZWQvdXRpbGl0eS5vdXQgICAgfCAxMzIgKysrKysrKwpjb250cmliL3BnX3N0YXRf c3RhdGVtZW50cy9tZXNvbi5idWlsZCAgICAgICAgICAgICB8ICAgNCArCmNvbnRyaWIvcGdfc3Rh dF9zdGF0ZW1lbnRzL3NxbC9jbGVhbnVwLnNxbCAgICAgICAgIHwgICAxICsKY29udHJpYi9wZ19z dGF0X3N0YXRlbWVudHMvc3FsL2xldmVsX3RyYWNraW5nLnNxbCAgfCAgOTkgKysrKysrCi4uLi9w Z19zdGF0X3N0YXRlbWVudHMvc3FsL3BnX3N0YXRfc3RhdGVtZW50cy5zcWwgIHwgMTc4ICstLS0t LS0tLS0KY29udHJpYi9wZ19zdGF0X3N0YXRlbWVudHMvc3FsL3BsYW5uaW5nLnNxbCAgICAgICAg fCAgMzEgKysKY29udHJpYi9wZ19zdGF0X3N0YXRlbWVudHMvc3FsL3V0aWxpdHkuc3FsICAgICAg ICAgfCAgNjAgKysrKwoxMiBmaWxlcyBjaGFuZ2VkLCA2MjMgaW5zZXJ0aW9ucygrKSwgNTcwIGRl bGV0aW9ucygtKQoK --===============8961402998453927157==--