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 1tPxZu-00GdTA-Hi for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Dec 2024 05:35:34 +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 1tPxZs-001uSU-NP for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Dec 2024 05:35:32 +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 1tPxZs-001uSM-Db for pgsql-hackers@lists.postgresql.org; Tue, 24 Dec 2024 05:35:32 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tPxZq-000ISG-22 for pgsql-hackers@lists.postgresql.org; Tue, 24 Dec 2024 05:35:31 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.phl.internal (Postfix) with ESMTP id 0B3DB1140107; Tue, 24 Dec 2024 00:35:29 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Tue, 24 Dec 2024 00:35:29 -0500 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:subject :subject:to:to; s=fm2; t=1735018529; x=1735104929; bh=G87oNbMKr6 nkRBotXN8/R3ZPicRNRxumcDFvOj33qu8=; b=TFAAeaY0mWLN0A2dC8PrCk2NWv VD7xoRoNf/RU+RMD0xXW+OmbfizAB49M+RbWB1hikC2sB0/dhqgAz3yTM0eLKD+X IfjR0YTPhgG+bXsQG6tTMZdexBu0+VPtEjcNcMogAc3/b6Pe36iNXK+FQnUHM9ez w4K2ZZs3eJVJq4hMwruK1KY4RxWYm0hQzXQ2ZZaBKHhhf2WCEu6W+h+5aVJdqqGn sVfuK1EfnmW4XbvSPQITmMzm6oDQDKYLmFwhlRswvRP8kTorZOACirs6FN33ZrED FuMIW41k60M3SbFO9mDHQGGIWg9k5NT/3rqfcyao9jT887TbUz1uJcFKph5g== 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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1735018529; x=1735104929; bh=G87oNbMKr6nkRBotXN8/R3ZPicRNRxumcDF vOj33qu8=; b=BkQO14RKk7gh6gEx/HUxWqMD0jucQWOXNI2rr4AAd7u+FlssFfh iIdePzEhmgvXUnWzPMhHyAnNdUBoVyTV/G2HMtzcZGTCX7yvhMaWfUCkXpI/n1VE m8SKIaCy0PzpL4GDocyR6fROCeEYVSLkBQ0bw3sm0F2uIv7mQSw5/8unRSwxEigP PODxoh/EwudjHtiORDrhHVWwmTms+DauoZYPZ6AxdRMR8rrmEktC3CPSjyrFqXHd yoLgg/ozNgIWGxAEWbguvvAIeOOWXXkO1iPrFK5suNJDzDwBvEeYARaC1jShaS3X cN6xwqD6bJtj3PUiCcVW+Wcg9hHt8EwoP3A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddruddufedgkeefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeff jeevgfevuddvjedtvddtieejheduueelvddufedtgfefjedvkeevkeeivddvnecuffhomh grihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipd hnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegsvghr thhrrghnuggurhhouhhvohhtrdhpghesghhmrghilhdrtghomhdprhgtphhtthhopegshi grvhhuiiekudesghhmrghilhdrtghomhdprhgtphhtthhopegrlhhvhhgvrhhrvgesrghl vhhhrdhnohdqihhprdhorhhgpdhrtghpthhtohephhhorhhikhihohhtrgdrnhhtthesgh hmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhs rdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 24 Dec 2024 00:35:26 -0500 (EST) Date: Tue, 24 Dec 2024 14:35:16 +0900 From: Michael Paquier To: Bertrand Drouvot Cc: Nazir Bilal Yavuz , Alvaro Herrera , Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org Subject: Re: per backend I/O statistics Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="rECXrpPm7ZSQm2Jo" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --rECXrpPm7ZSQm2Jo Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Dec 20, 2024 at 09:57:19AM +0000, Bertrand Drouvot wrote: > BTW, now that the per backend I/O statistics is done, I'll start working on per > backend wal statistics. I think that this is a good idea. It does not actually overlap the proposal in [1] as the stats persistency is not the same. What this thread has taught me is that you could just plug in the stats of the new backend-level structure a PgStat_WalStats and retrieve them with a new function that returns a single tuple with the WAL stats attributes. That should be rather straight-forward to achieve. [1]: https://commitfest.postgresql.org/51/4950/ -- Michael --rECXrpPm7ZSQm2Jo Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmdqSBQACgkQnvQgOdby QH2SZg/+Mq9939c0JnWvgxNb0GY8zOOzjHI2kC6Sbp1FWrD+QGjWpdKzgtOXJzzp DmdjZo0v8DQUkEUlTSLPBeMjfks7dToVjiFiNcx+aa0iatR6QWcT9Ej6IcRPttZ1 gkNgEVW9LslQGsJAC7Rfou6JZ4oxAhb9InMsXSwGnjXkysv2RRHySoXLpcN4v+UF H91sK3YZa2lLz+F+ZoFGHh39wLy5POAe9jSS7XQHViMLgjYksukTFdgbwzuQoCEX QlFnQ2Am6GgBwWAAKMv75O/mIQAgeertTkYwspBYg+5DJerMCG/XI/5s2SXGecQ3 KwXia9qY6MTyX5puDSewQk/QJNCPGIK3wrmNmTLWH8JqXPhQxDzLWIS8SnKAGwzN k7AZZS0APZ53OyxkYYFptr/Y7qAfj1SW+zn4OIJ10aF0Z4/YxPloQ3myG0dFS9IT Bsvl2MwXsfTvakj4vHyWgyqqwXtCWWrApWsp3XQW9TxvJHI72V6lgGVa3SMvfR9s evAf2lt48Ft1SA7vYiZCwKAHm6Fac8QWYAqASQLehm5cjAKE760YJNn1JUsz4CCA OQMDzP1i6MngIKHpRj9HtBNrMi/nbTNwSfCWzlSfsn/23B51TdoMQt88IneHIYDo Hx88oqUPHNB5U/j6bY+qlEUPRnopvQNV8wEJ7vmS+yyw/pWI1uk= =7NQZ -----END PGP SIGNATURE----- --rECXrpPm7ZSQm2Jo--