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 1peQQt-0001aD-8I for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:04:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peQQs-0004uX-3c for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Mar 2023 01:04:58 +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 1peQQr-0004u4-Qk for pgsql-hackers@lists.postgresql.org; Tue, 21 Mar 2023 01:04:57 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peQQn-0008Bz-8o for pgsql-hackers@postgresql.org; Tue, 21 Mar 2023 01:04:57 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id 33A5732007D7; Mon, 20 Mar 2023 21:04:51 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Mon, 20 Mar 2023 21:04:51 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1679360690; x=1679447090; bh=01 JuWE6QmeoJvwcx01RN6DVQAnmftDBdLuIvWzzWof0=; b=DK1ORt1ewt3X6oA3+j YzgBpZ8ABjwaSXmVjnplV3rSqrVNo17tvnSJQ0LzMjpmrB4gGWHuYCI81WVkQ4Vg HZSsaByMz/RyDgE9qBEycPABnVPICsfb72sX9sNecoj48rYhrG96lsuprHeRHPsa KRAg1ROD4sM1qC7cQoG92wLyI9TuQjHlx2My3e9AE6tgzsH5RQiiSFzO+vpP/gdO vLbvHM+NbIuA9fRs8zmYUyvSoJRlYY/rWEuUY2rt7V9oeZrzlX/uWwWflxyhPjYY iq/4iwXxbS6skRie4VGEHxtLL498lTFWgbSeGXo+UEpIYNfnCItWsWiULSE7Rbvx 8c+Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1679360690; x=1679447090; bh=01JuWE6QmeoJv wcx01RN6DVQAnmftDBdLuIvWzzWof0=; b=QH6uVNxW8MwhjP6bqncjlVt8DD6Ad tF9llsxMcYE0sWZMyclQLfrYzCX+LP4tWUX5/P1+dL37cFzmlDJJD7YyItPOHaRn fPYT7W3/9M4ryKYplm2Otc80r14QtLsjT9Q2Da5N5Yu/x6xm21XzSIKlpquVG3o6 XS9EBXixmJvEGv4jaHtpAlK9JrfmosoyGwr5WZjEWbH/iZpqTO3vRhRsp3hXdvh9 Fg3jP971f9AP1uSTlUf4MKk4cQ0Bv/3OLHn6QqxrvzUnspEUZw0t8U2HnDpkye8k pMjusKK5YSfPySvdFkww8bgxBqzll+DXKqNlxAY5MA1TiwUvbp7PeWwNQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrvdefledgvdejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 20 Mar 2023 21:04:49 -0400 (EDT) Date: Tue, 21 Mar 2023 10:04:46 +0900 From: Michael Paquier To: "Imseih (AWS), Sami" Cc: David Zhang , "pgsql-hackers@postgresql.org" Subject: Re: [BUG] pg_stat_statements and extended query protocol Message-ID: References: <9B9BB0F2-68A3-44E0-946E-3D9051F83369@amazon.com> <3499c5ed-5511-0801-ccfe-297b098aa8fe@highgo.ca> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="uNkKduFFziBYAoTn" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --uNkKduFFziBYAoTn Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Mar 20, 2023 at 09:41:12PM +0000, Imseih (AWS), Sami wrote: > I was thinking about this and it seems to me we can avoid > adding new fields to Estate. I think a better place to track > rows and calls is in the Instrumentation struct. >=20 > If this is more palatable, I can prepare the patch. This indeed feels a bit more natural seen from here, after looking at the code paths using an Instrumentation in the executor and explain, for example. At least, this stresses me much less than adding 16 bytes to EState for something restricted to the extended protocol when it comes to monitoring capabilities. -- Michael --uNkKduFFziBYAoTn Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmQZAq4ACgkQnvQgOdby QH1r/BAAhUw9HBy8WDIDOPT+RX7HdNq5yfY+XC8f4soczPAq5EpJ4LP1zqv7y4Lj 84U6R5ZHs0jUApYUIchcj+9uKu89p4JQl9vy5MPLsHR3o31fwBueK7Bahf1pf8j9 6UST5dPyokHNypFaHF109Ar3idRQ9RqMUez0ik6nZZaaGKsRhSdHQSQOQRZ4Dxkk /R9zTFpjADIFmUc3Tc+bhwPTXdv5XTnzVnI4de/hsmxEnpn4+tz3C3NkzMkOjbp7 q+BvJFFDX4qIR8/xVSEQr6sZujFooOgBfoMPPjQRrROr5LAE0LfNmug4sokjaU0e h39U3oUXn7wik3Ml50zTVm0XrR8hP6jgJue4cCZCNnZwiccKAMa57kc2IoJdxQ00 rkypQd4JK1xK3+ljl/72BgRUrVGq2ndhvYUKS2zlblVafA8jjE56CpjWNa8af7Xl CEEUr07inoIrdwBOZKhxTD0L71iEJdVeltM56SmXK5oAdAEo1jgm7yHRUhU9BgKH KQ+oRfaLq7GgnaDVtKcy2uREfXjqCY1clTfM87shMn/H2X0Va57dn+1uEiAM7Z6C JycOLOqf3bq1vKJ2Wk2wjEQ8+63izm/GEM/RLiQ8hitG09slTLrlFrBxr7LrfLlW UzqKsLSHkbDEftk/ZG2zMxD5FELeI9kI2U0v8OWhKHAOaanfxy8= =8kdR -----END PGP SIGNATURE----- --uNkKduFFziBYAoTn--