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 1tOZlC-007HVY-Iy for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2024 09:57:30 +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 1tOZlB-008PFD-Ra for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2024 09:57:29 +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 1tOZlB-008PF5-HU for pgsql-hackers@lists.postgresql.org; Fri, 20 Dec 2024 09:57:29 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOZl4-000WxI-Pm for pgsql-hackers@lists.postgresql.org; Fri, 20 Dec 2024 09:57:28 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-385e06af753so995386f8f.2 for ; Fri, 20 Dec 2024 01:57:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734688641; x=1735293441; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=FBEmDa0BffwXABYGWUrYxH1UhRL4h/ZCF1RCQpYad30=; b=FUuuwuw5N6FCxvo4JwOpNkMFwFiOXGnb947NmY+yxCaAg9dbIC0OVqaCRD+wJ3xo+y v8v8R4N0mW/0RfSp/ZQtT8kl7FCA5/5wVZ5lbuOAojPYbPz/4d6YhArh8F5O1wCesdt8 dUpovizrH8NW5SbPBHBXukqFw3Sw7o/KuGNy0cYeKgzUzGMw7jTdY3YzdAeyKq/l6Y3b G0XqtDC7ltfTtam9CaAWWSklbd1rk8b5wcpzuBUDuDdIVSK+/9YORkp/Syi39M1gzTdY gmFFJRQFJmEVUDVT9fT9l3rdCRGsLU+X4JZo7o1W3xL4os901EXD25edTG03yqq511v3 WLYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734688641; x=1735293441; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=FBEmDa0BffwXABYGWUrYxH1UhRL4h/ZCF1RCQpYad30=; b=fWujLfQDbA5Mk3dUsU39Oy9eLGLkpltpGFtpsw5E1gDSTJEbSKYlKM8ZUVtDA0RBUy 5i+OM7Rr8te6LJlhfMmUZu7GWcaEPKNBHKTVGEOp1yF0BRhkrURQwMFu+T6lm51ABrc3 27u7mn+OfuIaaduy7puWTAXuDFd/OR7K94aVa6FuAzKQJ1rJaON2hkFOJvG24q4xrv15 OnHMCYUvacos6Qgp+wRYyoYSaZpVa6yzGgiowoxSfg99ZUOip6UmhC82yb6sFD4k/uTo sEvnXBd3rNx8E/ooLzThY0iOBaWz/PTINdnG9Ogqclie/L6h88/zPI9UKCv6ozcPPKMl wBow== X-Forwarded-Encrypted: i=1; AJvYcCVXhP0KRY4hsWGlkHN9PolhZJZnE82vZDv9r0Lr0bFqcrREYJA/DHM40jJBG512kAKJI+DW20cl3wQoLBGQ@lists.postgresql.org X-Gm-Message-State: AOJu0Yx4FiXEIyXs+OL+CW70SgCwtzB1HhD0groRO/ZB8GO0VzjWo3Oi x06jqXIYtwt/zC1+2cmikj9DTtPI75SfFeh4bwKAxW1AKyaZG9fF X-Gm-Gg: ASbGncuu6tplUCZ+a8mWn1xA1MpnAQeBCYZuTYpIWPyao2Tu7oH4MWO9hy1tS34Tdpz zEZi/KEP/mEnsSgI7TFrhsWEm92mNQDDJWsirE90Luj7WP32EQcRkwQVU9qaNS6Un2kzlbNGmm1 sO10iFiKaoKB8QlgICPtnIOz8/+ilFZ/0H/MjEKRUkpUt0BpbtfVpbzUrfR+l8FdY/YjCWPm8A6 F79h+V9DQpQd0P/ZaRJKFRaTZcOF06/ljBVZVohq/zoJ37ImzDdBaXxMqKtBvytFkSzjVA7OX8O UOX7TqSGB3JNfaBKIYPxICuhH882xFaLi8JZ4FT4CeWhtMmp3IIU5Dka/nqvmSgsKLziay3MYxh /fW0vR3w= X-Google-Smtp-Source: AGHT+IH3FuckGi045Y9OLz4sJ9kzeCtNZEV9wbacSpxzgVGJp07y3n8kx4M+rGKfwSNmHiSz5wxwLg== X-Received: by 2002:a5d:64e9:0:b0:385:f56c:d90a with SMTP id ffacd0b85a97d-38a223fd452mr2241269f8f.55.1734688641232; Fri, 20 Dec 2024 01:57:21 -0800 (PST) Received: from ip-10-97-1-34.eu-west-3.compute.internal (ec2-15-236-134-5.eu-west-3.compute.amazonaws.com. [15.236.134.5]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38a1c832e8asm3596937f8f.37.2024.12.20.01.57.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Dec 2024 01:57:20 -0800 (PST) Date: Fri, 20 Dec 2024 09:57:19 +0000 From: Bertrand Drouvot To: Michael Paquier 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: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, Dec 19, 2024 at 06:12:04AM +0000, Bertrand Drouvot wrote: > On Thu, Dec 19, 2024 at 01:21:54PM +0900, Michael Paquier wrote: > > bumped the two version counters, and done. > > The existing structure could be expanded in the > > future to add more information about other statistics related to > > backends, depending on requirements or ideas. BTW, now that the per backend I/O statistics is done, I'll start working on per backend wal statistics. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com