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 1tjvVv-00EjlJ-21 for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Feb 2025 07:25:59 +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 1tjvVt-00E31q-Ov for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Feb 2025 07:25:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tjvVt-00E31h-Fv for pgsql-hackers@lists.postgresql.org; Mon, 17 Feb 2025 07:25:57 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tjvVr-001IRw-0k for pgsql-hackers@lists.postgresql.org; Mon, 17 Feb 2025 07:25:57 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 241E41140120; Mon, 17 Feb 2025 02:25:53 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Mon, 17 Feb 2025 02:25:53 -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=fm3; t=1739777153; x=1739863553; bh=pceEdUY+RL wTFP0LrvPy48ngW/KpTVgyJh66xlYI0h8=; b=UzMjIpc3LgoNmsVh0g8lFsdaER +XZ3+Kxjdvus2FSsM6aCnT3qIJQ1PIOEGZkzHIaV78G6swgyp+aEGdMOG0anJmnT JmAYKzsYMs2twMQLiGZfWRtIo0Tlnjnc3VUCjHzHcQhvNQ1XoCLSTeAEy5qUrkGb CBLl8BTcNK2s3oJ2wjoDANA3h/Ck7CW/wx0g5/pcJmVjaTs5jJcp7aSL+F/5S4ga VwOfOa9xYBNL8FPOJorHC1n8VJf/TwVllfef5HuFsZKPcW3Fu2f/slv7Rmfnsp7P I1PArcOKsHsNJ1W2YJu83SUkIOo0jNPdwsUpgxs6QtukvMfaGxOHmSJwSVAg== 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=fm3; t= 1739777153; x=1739863553; bh=pceEdUY+RLwTFP0LrvPy48ngW/KpTVgyJh6 6xlYI0h8=; b=wygyTTPUzRE2JtoL4q1RUjefxeynZ9evCOaPe7tQ1aaf9XxYLsx VGavrkkBRBRLt1DuEdQVuJFRpFVIOLtWwwJUvyRqiRBSAtkfTx6lURN8tIEggSeZ DCwgky7UW/iR1Ep8FdXrTht9tFRxuXoZtlM1VF3/EEEXYAFRRzOP4hApipVsgl01 V4upwK4WtfuvOYt/ys2nwMkxZCj/rV1bXekL9U5+jyhIM+Uqsz0srskdgsU0TeqL OChqs5FRD1LOrgDd4elvg0NrCy+MvX7ZF5qWiYGugHnuTf4p58x09Yn/iKqSqOuH TRLhIJN4hPCuIcPkocJ3HxQmR/qSfDb+93A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdehjeejjecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffk fhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrh cuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeet leeifedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghl sehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegsvghrthhrrghnuggurhhouhhvohhtrdhpghesghhmrghilhdr tghomhdprhgtphhtthhopegrnhgurhgvshesrghnrghrrgiivghlrdguvgdprhgtphhtth hopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhr ghdprhgtphhtthhopegshigrvhhuiiekudesghhmrghilhdrtghomh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 17 Feb 2025 02:25:51 -0500 (EST) Date: Mon, 17 Feb 2025 16:25:46 +0900 From: Michael Paquier To: Bertrand Drouvot Cc: Andres Freund , pgsql-hackers@lists.postgresql.org, Nazir Bilal Yavuz Subject: Re: per backend WAL statistics Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="A94uyZYk4LlYtQ8F" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --A94uyZYk4LlYtQ8F Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Feb 17, 2025 at 06:59:40AM +0000, Bertrand Drouvot wrote: > There is still something that would simplify what is done here: it's the > "the elimination of the write & sync columns for pg_stat_wal" mentioned in [2]. Yeah, still you cannot just remove them because the data tracked in pg_stat_io is not entirely the same, right? -- Michael --A94uyZYk4LlYtQ8F Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmey5HoACgkQnvQgOdby QH316w//XCfgoSCWlTWNCx8QsjywaM5pFE7FWQWOxLFgq2PDebFwO+U4D2cQa/r5 NS/nV1k0t84t7TGhUEj2JyWC3947VszxfU9ieojsF75rbk8XCz3J7sSkeCNKGFGi AauR8hsS24HC1Vc9BP09Qhr2eK6ElQJkw8ItPyUjjFXa1rPnGJN9Ceh3NsR727IL lgjPodE9L52sFp4maAn1Md3Bfwk2PQLnfA3wkDUdZLW9uJ5Nn+O36AJMEW4687p1 Fj9Fdu7sY80M7xoh1a6RdSAfwnJ25TshBieVGlUQWinNfNy7xzJ5fEgDQOJc/y6b ACJhoQ4nyjUYw8ZV8cfNoD3a7UDFTRTuhtCgwv6tB+BPuZYyDKVH2otI+xr+S8Dp lFlHVxiBfneXA/uIVUknxh9qY0JdLw2GT1LpKlaKbk83bVP1J94pUQCwftjuWzZR kE0GWubekGsbX/mE2IDrHsP46Juj+Thcx0EoA815zd5eAjnTHyMGmZdN6W8sq94B Gb0RQrVxY5HkXuX8avOvbtWQZqlPyYvGs73nbWT/RCnbPdr1NIuRqKCVfW1h7qta GNA7bX534GMbwUavoiyxJAxymih/FpQRRe0YnsMudhPfCLj7DLClzBfU5Xxf05je OAa01ZrrJr9derb9sm/wlajQRShhUe5N8f/yYD7T1R9PNVGfBRo= =7WEr -----END PGP SIGNATURE----- --A94uyZYk4LlYtQ8F--