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 1pf67K-0005dF-Hk for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Mar 2023 21:35:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pf67J-0001Gh-9C for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Mar 2023 21:35:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf67I-0001GX-Ob for pgsql-hackers@lists.postgresql.org; Wed, 22 Mar 2023 21:35:32 +0000 Received: from smtp-fw-9103.amazon.com ([207.171.188.200]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf67F-0007HW-Da for pgsql-hackers@postgresql.org; Wed, 22 Mar 2023 21:35:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1679520929; x=1711056929; h=from:to:cc:date:message-id:references:in-reply-to: mime-version:subject; bh=qKWLoTWJ3znthOs7eBttbtsqLnkFR1OARrALPHHqsC8=; b=B7Yy72ViIEUsVZSP1QQAJ/75jN3oVSmM2P/FritfItGT5lZEQPc8Fsaw uMHSGWdEZJRrqSIRCKOUeZqNiv9qAKgkmMES46v3K+7f+3iHkvhuISW4q SsboXuYHvj6cKUwDUX1Ofo1aJl1vFOxy34zjWd8ejUktERi+tJEGyGE1Z c=; X-Amazon-filename: v3-0001-Correct-accumulation-of-counters-for-extended-query-.patch X-IronPort-AV: E=Sophos;i="5.98,282,1673913600"; d="scan'208,223";a="1115410724" Subject: Re: [BUG] pg_stat_statements and extended query protocol Thread-Topic: [BUG] pg_stat_statements and extended query protocol Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-iad-1a-m6i4x-9fe6ad2f.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-9103.sea19.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 22 Mar 2023 21:35:27 +0000 Received: from EX19MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1a-m6i4x-9fe6ad2f.us-east-1.amazon.com (Postfix) with ESMTPS id 1FA038115F; Wed, 22 Mar 2023 21:35:24 +0000 (UTC) Received: from EX19D013UWA002.ant.amazon.com (10.13.138.210) by EX19MTAUWB001.ant.amazon.com (10.250.64.248) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1118.25; Wed, 22 Mar 2023 21:35:23 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA002.ant.amazon.com (10.13.138.210) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1118.24; Wed, 22 Mar 2023 21:35:23 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1118.024; Wed, 22 Mar 2023 21:35:23 +0000 From: "Imseih (AWS), Sami" To: "Drouvot, Bertrand" , Michael Paquier CC: David Zhang , "pgsql-hackers@postgresql.org" Thread-Index: AQHZMRPVSK6etgQmu0ylv8x6o85VDq7nTseAgAZX4oCABx1JgIABXzGAgACXgQCAAslkgIAKr18AgACMsgCAAHiOgIABwU+AgABce4A= Date: Wed, 22 Mar 2023 21:35:23 +0000 Message-ID: References: <9B9BB0F2-68A3-44E0-946E-3D9051F83369@amazon.com> <3499c5ed-5511-0801-ccfe-297b098aa8fe@highgo.ca> <3227719C-F7A3-4A94-B0A5-D27673316560@amazon.com> <0d583e2a-8214-4975-a4b4-7e9e0b8f8e9c@gmail.com> In-Reply-To: <0d583e2a-8214-4975-a4b4-7e9e0b8f8e9c@gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.95.205.36] Content-Type: multipart/mixed; boundary="_002_DF31196477CB4027B00A0AD7A3DB61D5amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_002_DF31196477CB4027B00A0AD7A3DB61D5amazoncom_ Content-Type: text/plain; charset="utf-8" Content-ID: <4E65044B2C37D94792BF979A5989F516@amazon.com> Content-Transfer-Encoding: base64 PiBXaGF0IGFib3V0IHVzaW5nIGFuIHVpbnQ2NCBmb3IgY2FsbHM/IFRoYXQgc2VlbXMgbW9yZSBh cHByb3ByaWF0ZSB0byBtZSAoZXZlbiBpZg0KPiBxdWVyeURlc2MtPnRvdGFsdGltZS0+Y2FsbHMg d2lsbCBiZSBwYXNzZWQgKHdoaWNoIGlzIGludDY0KSwgYnV0IHRoYXQncyBhbHJlYWR5DQo+IGFs c28gdGhlIGNhc2UgZm9yIHRoZSAicm93cyIgYXJndW1lbnQgYW5kIHF1ZXJ5RGVzYy0+dG90YWx0 aW1lLT5yb3dzX3Byb2Nlc3NlZCkNCg0KVGhhdCdzIGZhaXINCg0KDQo+IEknbSBub3Qgc3VyZSBp dCdzIHdvcnRoIG1lbnRpb25pbmcgdGhhdCB0aGUgbmV3IGNvdW50ZXJzIGFyZSAiY3VycmVudGx5 IiB1c2VkIHdpdGggdGhlIEV4ZWN1dG9yUnVuLg0KDQpTdXJlLCBJIHN1cHBvc2UgdGhlc2UgZmll bGRzIGNvdWxkIGJlIHVzZWQgb3V0c2lkZSBvZiBFeGVjdXRvclJ1bi4gR29vZCBwb2ludC4NCg0K DQo+IEFsc28sIEkgd29uZGVyIGlmICJyb3dzIiAoYW5kIG5vdCByb3dzX3Byb2Nlc3NlZCkgd291 bGQgbm90IGJlIGEgYmV0dGVyIG5hbWluZy4NCg0KQWdyZWUuDQoNCkkgd2VudCB3aXRoIHJvd3Nf cHJvY2Vzc2VkIGluaXRpYWxseSwgc2luY2UgaXQgd2FzIGFjY3VtdWxhdGluZyBlc19wcm9jZXNz ZWQsDQpidXQgYXMgdGhlIHByZXZpb3VzIHBvaW50LCB0aGlzIGluc3RydW1lbnRhdGlvbiBjb3Vs ZCBiZSB1c2VkIG91dHNpZGUgb2YNCkV4ZWN1dG9yUnVuLg0KDQp2MyBhZGRyZXNzZXMgdGhlIGNv bW1lbnRzLg0KDQoNClJlZ2FyZHMsDQoNCg0KLS0NClNhbWkgSW1zZWloDQpBbWF6b24gV2ViIFNl cnZpY2VzIChBV1MpDQoNCg0KDQo= --_002_DF31196477CB4027B00A0AD7A3DB61D5amazoncom_ Content-Type: application/octet-stream; name="v3-0001-Correct-accumulation-of-counters-for-extended-query-.patch" Content-Description: v3-0001-Correct-accumulation-of-counters-for-extended-query-.patch Content-Disposition: attachment; filename="v3-0001-Correct-accumulation-of-counters-for-extended-query-.patch"; size=4266; creation-date="Wed, 22 Mar 2023 21:35:23 GMT"; modification-date="Wed, 22 Mar 2023 21:35:23 GMT" Content-ID: <536FEF4051855640BDC682B3FBEC6B42@amazon.com> Content-Transfer-Encoding: base64 RnJvbSA5NDI3Nzc3Y2NjNmZjODRhMDg3Yjk4NDViY2U1ODA1NGI2Mjg0NThkIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBFQzIgRGVmYXVsdCBVc2VyIDxlYzItdXNlckBpcC0xNzItMzEt MjYtMjIxLmVjMi5pbnRlcm5hbD4KRGF0ZTogV2VkLCAyMiBNYXIgMjAyMyAyMDoxNDo1MSArMDAw MApTdWJqZWN0OiBbUEFUQ0ggMS8xXSBDb3JyZWN0IGFjY3VtdWxhdGlvbiBvZiBjb3VudGVycyBm b3IgZXh0ZW5kZWQgcXVlcnkKIHByb3RvY29sCgpJbiBwZ19zdGF0X3N0YXRlbWVudHMsIEVTdGF0 ZS0+ZXNfcHJvY2Vzc2VkIGNhbm5vdCByZWxpYWJseQpiZSB1c2VkIHRvIGNvdW50IHRoZSByb3dz IHByb2Nlc3NlZCBmb3IgYSBzdGF0ZW1lbnQgdGhhdApnb2VzIHRocm91Z2ggZXh0ZW5kZWQgcXVl cnkgcHJvdG9jb2wuIFRoaXMgaXMgYmVjYXVzZSwgc3VjaAphIHN0YXRlbWVudCBtYXkgZ28gdGhy b3VnaCBFeGVjdXRvclJ1biBtb3JlIHRoYW4gb25jZSwgYW5kCmVzX3Byb2Nlc3NlZCBpcyByZXNl dCBhZnRlciBldmVyeSBjYWxsLiBUaGlzIGZpeCBhZGRyZXNzZXMKdGhpcyBpc3N1ZSBieSBhY2N1 dW11bGF0aW5nIHRoZSAjIG9mIGNhbGxzIGFuZCByb3cgcHJvY2Vzc2VkCmluIEluc3RydW1lbnRh dGlvbiBhbmQgdGhlIGNvcnJlY3QgdG90YWxzIGFyZSBhdmFpbGFibGUgdG8KRXhlY3V0b3JFbmQg KCBhbmQgcGdzc19zdG9yZSApIGJlZm9yZSB0aGUgSW5zdHJ1bWVudGF0aW9uCmlzIGRlc3Ryb3ll ZC4KCkRpc2N1c3Npb246IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZmxh dC9FQkU2QzUwNy05RUI2LTQxNDItOUU0RC0zOEIxNjczMzYzQTclNDBhbWF6b24uY29tCi0tLQog Li4uL3BnX3N0YXRfc3RhdGVtZW50cy9wZ19zdGF0X3N0YXRlbWVudHMuYyAgICB8IDE4ICsrKysr KysrKysrKysrLS0tLQogc3JjL2luY2x1ZGUvZXhlY3V0b3IvaW5zdHJ1bWVudC5oICAgICAgICAg ICAgICB8ICAyICsrCiAyIGZpbGVzIGNoYW5nZWQsIDE2IGluc2VydGlvbnMoKyksIDQgZGVsZXRp b25zKC0pCgpkaWZmIC0tZ2l0IGEvY29udHJpYi9wZ19zdGF0X3N0YXRlbWVudHMvcGdfc3RhdF9z dGF0ZW1lbnRzLmMgYi9jb250cmliL3BnX3N0YXRfc3RhdGVtZW50cy9wZ19zdGF0X3N0YXRlbWVu dHMuYwppbmRleCA1Mjg1YzNmN2ZhLi5mNmQ1YWM5NDAyIDEwMDY0NAotLS0gYS9jb250cmliL3Bn X3N0YXRfc3RhdGVtZW50cy9wZ19zdGF0X3N0YXRlbWVudHMuYworKysgYi9jb250cmliL3BnX3N0 YXRfc3RhdGVtZW50cy9wZ19zdGF0X3N0YXRlbWVudHMuYwpAQCAtMzQwLDcgKzM0MCw3IEBAIHN0 YXRpYyB2b2lkIHBnc3Nfc3RvcmUoY29uc3QgY2hhciAqcXVlcnksIHVpbnQ2NCBxdWVyeUlkLAog CQkJCQkgICBpbnQgcXVlcnlfbG9jYXRpb24sIGludCBxdWVyeV9sZW4sCiAJCQkJCSAgIHBnc3NT dG9yZUtpbmQga2luZCwKIAkJCQkJICAgZG91YmxlIHRvdGFsX3RpbWUsIHVpbnQ2NCByb3dzLAot CQkJCQkgICBjb25zdCBCdWZmZXJVc2FnZSAqYnVmdXNhZ2UsCisJCQkJCSAgIHVpbnQ2NCBjYWxs cywgY29uc3QgQnVmZmVyVXNhZ2UgKmJ1ZnVzYWdlLAogCQkJCQkgICBjb25zdCBXYWxVc2FnZSAq d2FsdXNhZ2UsCiAJCQkJCSAgIGNvbnN0IHN0cnVjdCBKaXRJbnN0cnVtZW50YXRpb24gKmppdHVz YWdlLAogCQkJCQkgICBKdW1ibGVTdGF0ZSAqanN0YXRlKTsKQEAgLTg1Nyw2ICs4NTcsNyBAQCBw Z3NzX3Bvc3RfcGFyc2VfYW5hbHl6ZShQYXJzZVN0YXRlICpwc3RhdGUsIFF1ZXJ5ICpxdWVyeSwg SnVtYmxlU3RhdGUgKmpzdGF0ZSkKIAkJCQkgICBQR1NTX0lOVkFMSUQsCiAJCQkJICAgMCwKIAkJ CQkgICAwLAorCQkJCSAgIDAsCiAJCQkJICAgTlVMTCwKIAkJCQkgICBOVUxMLAogCQkJCSAgIE5V TEwsCkBAIC05NDIsNiArOTQzLDcgQEAgcGdzc19wbGFubmVyKFF1ZXJ5ICpwYXJzZSwKIAkJCQkg ICBQR1NTX1BMQU4sCiAJCQkJICAgSU5TVFJfVElNRV9HRVRfTUlMTElTRUMoZHVyYXRpb24pLAog CQkJCSAgIDAsCisJCQkJICAgMSwKIAkJCQkgICAmYnVmdXNhZ2UsCiAJCQkJICAgJndhbHVzYWdl LAogCQkJCSAgIE5VTEwsCkBAIC0xMDE0LDYgKzEwMTYsMTIgQEAgcGdzc19FeGVjdXRvclJ1bihR dWVyeURlc2MgKnF1ZXJ5RGVzYywgU2NhbkRpcmVjdGlvbiBkaXJlY3Rpb24sIHVpbnQ2NCBjb3Vu dCwKIAkJZXhlY19uZXN0ZWRfbGV2ZWwtLTsKIAl9CiAJUEdfRU5EX1RSWSgpOworCisJaWYgKHF1 ZXJ5RGVzYy0+dG90YWx0aW1lKQorCXsKKwkJcXVlcnlEZXNjLT50b3RhbHRpbWUtPmNhbGxzKys7 CisJCXF1ZXJ5RGVzYy0+dG90YWx0aW1lLT5yb3dzICs9IHF1ZXJ5RGVzYy0+ZXN0YXRlLT5lc19w cm9jZXNzZWQ7CisJfQogfQogCiAvKgpAQCAtMTA2MCw3ICsxMDY4LDggQEAgcGdzc19FeGVjdXRv ckVuZChRdWVyeURlc2MgKnF1ZXJ5RGVzYykKIAkJCQkgICBxdWVyeURlc2MtPnBsYW5uZWRzdG10 LT5zdG10X2xlbiwKIAkJCQkgICBQR1NTX0VYRUMsCiAJCQkJICAgcXVlcnlEZXNjLT50b3RhbHRp bWUtPnRvdGFsICogMTAwMC4wLAkvKiBjb252ZXJ0IHRvIG1zZWMgKi8KLQkJCQkgICBxdWVyeURl c2MtPmVzdGF0ZS0+ZXNfcHJvY2Vzc2VkLAorCQkJCSAgIHF1ZXJ5RGVzYy0+dG90YWx0aW1lLT5y b3dzLAorCQkJCSAgIHF1ZXJ5RGVzYy0+dG90YWx0aW1lLT5jYWxscywKIAkJCQkgICAmcXVlcnlE ZXNjLT50b3RhbHRpbWUtPmJ1ZnVzYWdlLAogCQkJCSAgICZxdWVyeURlc2MtPnRvdGFsdGltZS0+ d2FsdXNhZ2UsCiAJCQkJICAgcXVlcnlEZXNjLT5lc3RhdGUtPmVzX2ppdCA/ICZxdWVyeURlc2Mt PmVzdGF0ZS0+ZXNfaml0LT5pbnN0ciA6IE5VTEwsCkBAIC0xMTkxLDYgKzEyMDAsNyBAQCBwZ3Nz X1Byb2Nlc3NVdGlsaXR5KFBsYW5uZWRTdG10ICpwc3RtdCwgY29uc3QgY2hhciAqcXVlcnlTdHJp bmcsCiAJCQkJICAgUEdTU19FWEVDLAogCQkJCSAgIElOU1RSX1RJTUVfR0VUX01JTExJU0VDKGR1 cmF0aW9uKSwKIAkJCQkgICByb3dzLAorCQkJCSAgIDEsCiAJCQkJICAgJmJ1ZnVzYWdlLAogCQkJ CSAgICZ3YWx1c2FnZSwKIAkJCQkgICBOVUxMLApAQCAtMTIyNSw3ICsxMjM1LDcgQEAgcGdzc19z dG9yZShjb25zdCBjaGFyICpxdWVyeSwgdWludDY0IHF1ZXJ5SWQsCiAJCSAgIGludCBxdWVyeV9s b2NhdGlvbiwgaW50IHF1ZXJ5X2xlbiwKIAkJICAgcGdzc1N0b3JlS2luZCBraW5kLAogCQkgICBk b3VibGUgdG90YWxfdGltZSwgdWludDY0IHJvd3MsCi0JCSAgIGNvbnN0IEJ1ZmZlclVzYWdlICpi dWZ1c2FnZSwKKwkJICAgdWludDY0IGNhbGxzLCBjb25zdCBCdWZmZXJVc2FnZSAqYnVmdXNhZ2Us CiAJCSAgIGNvbnN0IFdhbFVzYWdlICp3YWx1c2FnZSwKIAkJICAgY29uc3Qgc3RydWN0IEppdElu c3RydW1lbnRhdGlvbiAqaml0dXNhZ2UsCiAJCSAgIEp1bWJsZVN0YXRlICpqc3RhdGUpCkBAIC0x MzUwLDcgKzEzNjAsNyBAQCBwZ3NzX3N0b3JlKGNvbnN0IGNoYXIgKnF1ZXJ5LCB1aW50NjQgcXVl cnlJZCwKIAkJaWYgKElTX1NUSUNLWShlLT5jb3VudGVycykpCiAJCQllLT5jb3VudGVycy51c2Fn ZSA9IFVTQUdFX0lOSVQ7CiAKLQkJZS0+Y291bnRlcnMuY2FsbHNba2luZF0gKz0gMTsKKwkJZS0+ Y291bnRlcnMuY2FsbHNba2luZF0gKz0gY2FsbHM7CiAJCWUtPmNvdW50ZXJzLnRvdGFsX3RpbWVb a2luZF0gKz0gdG90YWxfdGltZTsKIAogCQlpZiAoZS0+Y291bnRlcnMuY2FsbHNba2luZF0gPT0g MSkKZGlmZiAtLWdpdCBhL3NyYy9pbmNsdWRlL2V4ZWN1dG9yL2luc3RydW1lbnQuaCBiL3NyYy9p bmNsdWRlL2V4ZWN1dG9yL2luc3RydW1lbnQuaAppbmRleCA4N2U1ZTIxODNiLi4zM2YzMDgzMmQ3 IDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9leGVjdXRvci9pbnN0cnVtZW50LmgKKysrIGIvc3Jj L2luY2x1ZGUvZXhlY3V0b3IvaW5zdHJ1bWVudC5oCkBAIC04OCw2ICs4OCw4IEBAIHR5cGVkZWYg c3RydWN0IEluc3RydW1lbnRhdGlvbgogCWRvdWJsZQkJbmZpbHRlcmVkMjsJCS8qICMgb2YgdHVw bGVzIHJlbW92ZWQgYnkgIm90aGVyIiBxdWFscyAqLwogCUJ1ZmZlclVzYWdlIGJ1ZnVzYWdlOwkJ LyogdG90YWwgYnVmZmVyIHVzYWdlICovCiAJV2FsVXNhZ2UJd2FsdXNhZ2U7CQkvKiB0b3RhbCBX QUwgdXNhZ2UgKi8KKwlpbnQ2NCAgICAgICBjYWxsczsJCQkvKiB0b3RhbCBjYWxscyAqLworCWlu dDY0ICAgICAgIHJvd3M7CS8qIHRvdGFsIHJvd3MgKi8KIH0gSW5zdHJ1bWVudGF0aW9uOwogCiB0 eXBlZGVmIHN0cnVjdCBXb3JrZXJJbnN0cnVtZW50YXRpb24KLS0gCjIuMzkuMgoK --_002_DF31196477CB4027B00A0AD7A3DB61D5amazoncom_--