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 1tNU0V-0002K4-HW for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Dec 2024 09:36:47 +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 1tNTzV-0001YM-QX for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Dec 2024 09:35:45 +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 1tNTzV-0001Y8-BI for pgsql-hackers@lists.postgresql.org; Tue, 17 Dec 2024 09:35:45 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNTzR-0000IY-Ij for pgsql-hackers@lists.postgresql.org; Tue, 17 Dec 2024 09:35:43 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-436345cc17bso24775935e9.0 for ; Tue, 17 Dec 2024 01:35:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734428139; x=1735032939; 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=zoCJKWOoz4XmUXsLNfeh0ydlumMoWXAbjYoB0zyHjFc=; b=iBev5v0cpSdicBtZJquePEPQ9uakRxopLIevCboDXLjfk3URoMgMxWKOiO+2SmFviO vPH0d6xKH+3v2wMj3+HmhafZts4u71CFEbxhKvu+2vN56fpW/F/p2WD+iaQj0ZeJ0Bje TI8ndh0ePeFNMI3fd26emgudpWY6nm1GdU2Q44MP2nF1gVptP0WRPBTFReRX+wk+5YB4 VOrj7v2zLkzqTJyG0LoKOIaSPKBU+8A6stna7I94rjJFVPlyq8///ifA1Wbv6KtFkiHZ S2BEu0y0WysXYIWSSAlIRQhLVuHZgyvD2ijs8q08xb7aGlg356pgzrbs4QBy1DTWs1LW 2Uhw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734428139; x=1735032939; 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=zoCJKWOoz4XmUXsLNfeh0ydlumMoWXAbjYoB0zyHjFc=; b=upnyKSp1wYA3cne9BF05Vcdu+ybukPtvDvvUCCyvx0ynFSelwMyGwzoSjWQ5ckUODL GwyBxNFdIkpWiTnzyjpAt27cidTPsG4OFi9G4+WWAnU5pctyCni42GkJtRgkbzf2wIQi 9MGwlehqZNmEP9Om7MDa4QJzhP/p9LezG5YW8cC5pY6Du4+nyXqndRnuHllaMYBuShmz mlliyKs2XveoRVc6k3hXngWTr6rBJyo5ww/zes+wcopdcBPQf4Iz5KjXjtUjzk+Hwl58 4JFP94axIX6vyd4/vfKYNeZKP/PKldOHVHrEyjyTvCEklt/HqwG9lt0Q9Pt8PELVVJyY Tndw== X-Forwarded-Encrypted: i=1; AJvYcCWPopkzCBtHqRXyj2DS9mnyXK4brhFRvmi0R6XYlUKlnPsCrlWktuXPfPSyZQUxdUuEyn1I+XX+phWteGNw@lists.postgresql.org X-Gm-Message-State: AOJu0YyGFiwPoQ/20oe5ZO7K6q3v456gl9h3OnnjF0+p/jWDjKS4HcDd owMDOzS+7kfnOlVZQUUO9iIcqvAKkpqgi5dZr0XacaQO+TJiI5rW X-Gm-Gg: ASbGncuAmUo0Ty7f+KJdK2PFqu5L081Ft6MZpoQQ6dn/QXqUEa9C/09lUDhi+lbfBgJ aGTmRhSb+1VyM7GFZc5X5e1IFLowWD4lnlsXj4QFiszP65zbpEBmCVzWnb5F7qaFzmbv+8684jE j24pHomIwMnOF0FPtJtaZzEXt+kBTYjzZPAp0rbxOj5RvihF1GA9AnSUZkedEpY7iO3aXFtAsfy hCtyzHEMCcV7glE0BVynmiz7HdK//m4wzONwZ+ZGTtpWKdWdKCgzRVcJZC+UQ//oHbSOV90xwZM VfVQ+RK3p5UGZvoPX3w8X/qBJzypBGdpKlSJ7wA8ELOG5MJj9DTkQpabp8UcCqS4YGtnIzJCxK8 bZtlxDmk= X-Google-Smtp-Source: AGHT+IHMIgz9htUFCQw+VThnkZe5+DupzKlhksDYdM0xyfOqw/Kymqp+/UaTZxP1+Q+TlTRjLopb6Q== X-Received: by 2002:a05:6000:1544:b0:385:f060:b7fc with SMTP id ffacd0b85a97d-388da3a1286mr2372897f8f.25.1734428139185; Tue, 17 Dec 2024 01:35:39 -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-388c801acf2sm10494291f8f.52.2024.12.17.01.35.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Dec 2024 01:35:38 -0800 (PST) Date: Tue, 17 Dec 2024 09:35:37 +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 Tue, Dec 17, 2024 at 06:13:44PM +0900, Michael Paquier wrote: > On Tue, Dec 17, 2024 at 08:13:59AM +0000, Bertrand Drouvot wrote: > > Having said that, v9-0002 looks good to me (except the pgstat_fetch_proc_stat_io > > renaming). > > This routine returns a PgStat_Backend from a pgstats entry of type > PGSTAT_KIND_BACKEND, so the name in v9-0001 would not be true once > more types of stats data are attached to this structure. Fair enough, let's go with the name change done in v9-0002. > The name in > v9-0002 is more consistent long-term. Agree, we may need to add parameters to it but we'll see when the time comes. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com