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 1pQuYJ-0000AE-E8 for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Feb 2023 18:24:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pQuYI-0006w1-AE for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Feb 2023 18:24:46 +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 1pQuYG-0006vp-RQ for pgsql-hackers@lists.postgresql.org; Sat, 11 Feb 2023 18:24:46 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pQuYD-0004si-W5 for pgsql-hackers@postgresql.org; Sat, 11 Feb 2023 18:24:43 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 76FC532008FA; Sat, 11 Feb 2023 13:24:39 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Sat, 11 Feb 2023 13:24:40 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc: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=fm1; t=1676139879; x=1676226279; bh=gmVXYQV2gA H24m5HueDyP9oCTlL1Kg/zJmgarjO1t6g=; b=T1Fi9h+fpuYuF5Mi5ELqHN59QT hbbbwiLAAgCAaBgi2iidPg8hFtGLUFlB3Tv9x/K0BlqBlgALQx7/JcC4J9o4ecWK L966DLfcW83NJ2arbfTAt6bcHF6EKRgI5CMdKFcE+hi1hYQ+6kgV8/LK6uw7SB+D fzZIborofPg9tLfutEkq9CrfBiQ1bJfXs7NwE+TXRXha1IxQMN3Zh/md34IK5LiT jz39MGVBRqn27yAEtGuboZjha/4uSKy+5HgV2WStKkiAcU0xdWaQCCTvEdhVA7IY iC0mGa+M+A4RmmUSEFs/sL8h5DHPMMp56KPtM4RobQjaqBGT80576ROHX3VA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= fm1; t=1676139879; x=1676226279; bh=gmVXYQV2gAH24m5HueDyP9oCTlL1 Kg/zJmgarjO1t6g=; b=Nioqyl+k2NExJFMZdrpEedQAptl1nQlZCUlmJCV0WmY7 +bHuHSrG1zb4gXo5Y0tkybzKwzdVdX9kmrmvQW7mRfWU3rcJ2e7Q0ZWUWdM5utJk pS+3IM6IvZjiukk8fV4w74FkiJKRiyQRWHwqWNCM79yYRJu1Zg3jttAOGJS7vCDT /51xftCR6sLZQdQVetrBGCa0tAV33Xp+hhYzHHpF4904A9KhKlKe4uuKDwLIrvIb vybFLSBl3IJqqX0iP4yovPTpCDmmHG9iZSDNxtq6sccnO46NmOg7l4kU4AmvTaVd euUS/SvL4kbWtdqyYgu7TVAee6VNG6CaDYQX/8Lf7g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrudehjedgudduudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkfhggtggujgesth dtredttddtvdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegrnhgurhgvshes rghnrghrrgiivghlrdguvgeqnecuggftrfgrthhtvghrnhepvdfffeevhfetveffgeeite efhfdtvdffjeevhfeuteegleduheetveduieettddunecuvehluhhsthgvrhfuihiivgep tdenucfrrghrrghmpehmrghilhhfrhhomheprghnughrvghssegrnhgrrhgriigvlhdrug gv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 11 Feb 2023 13:24:38 -0500 (EST) Date: Sat, 11 Feb 2023 10:24:37 -0800 From: Andres Freund To: Kyotaro Horiguchi Cc: melanieplageman@gmail.com, vignesh21@gmail.com, pryzby@telsasoft.com, lukas@fittl.com, alvherre@alvh.no-ip.org, magnus@hagander.net, pgsql-hackers@postgresql.org, thomas.munro@gmail.com, m.sakrejda@gmail.com Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Message-ID: <20230211182437.ype5tk3awen2htvw@awork3.anarazel.de> References: <20230124.172203.448918351330829200.horikyota.ntt@gmail.com> <20230124223512.xqp7tjgqvzqokaxq@awork3.anarazel.de> <20230125.165617.724951472557617342.horikyota.ntt@gmail.com> <20230208063814.boyh5ibydbfuo2uk@awork3.anarazel.de> <20230209050319.chyyup4vtq4jzobq@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230209050319.chyyup4vtq4jzobq@awork3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2023-02-08 21:03:19 -0800, Andres Freund wrote: > Pushed the first (and biggest) commit. More tomorrow. Just pushed the actual pg_stat_io view, the splitting of the tablespace test, and the pg_stat_io tests. Yay! Thanks all for patch and review! > Already can't wait to see incremental improvements of this version of > pg_stat_io ;). Tracking buffer hits. Tracking Wal IO. Tracking relation IO > bypassing shared buffers. Per connection IO statistics. Tracking IO time. That's still the case. Greetings, Andres Freund