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 1tDlPb-0031Bh-2B for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Nov 2024 14:10:31 +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 1tDlPZ-0066FG-M2 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Nov 2024 14:10: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 1tDlPZ-0066F8-C4 for pgsql-hackers@lists.postgresql.org; Wed, 20 Nov 2024 14:10:29 +0000 Received: from mail-wr1-x429.google.com ([2a00:1450:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tDlPW-002t3c-RK for pgsql-hackers@lists.postgresql.org; Wed, 20 Nov 2024 14:10:28 +0000 Received: by mail-wr1-x429.google.com with SMTP id ffacd0b85a97d-38242abf421so1601026f8f.2 for ; Wed, 20 Nov 2024 06:10:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732111825; x=1732716625; 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=cCdeadk4IzLxhXi39J+nPl0wDNJbMe9j4mRHG7waGro=; b=BGVt/CFe5FHteiTNcJqLZhXHdiUmv4nfzuZlIPjI2jmk6BEIQ5C9wP1BAfLLxgGxZL IeP30soBG1J32Pzjiq2bJdqp7BqIAyeEjdFYfs1UqmOpzCYE354t6tMWvFUzJUWQMfiT li+FzXo1k1z1alTUx6OvWGNTdFO2gaT9UWMsTxLd5AUt9IyghX61klnBFmttNXuI/m2a fj/OBn6WOsA+2tLIbkbHxgs5004QzIr2TDPCRcMs1gjCdsEGchyc9pHJLwoGnZ7h05c1 CV7P29kPZInuKk5cPqrN/7grkBiHHRKz3RdmeP76nh3G1NZt1rsYLXM7B4Y6aJtW296T S5Mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732111825; x=1732716625; 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=cCdeadk4IzLxhXi39J+nPl0wDNJbMe9j4mRHG7waGro=; b=p4V9zabfU41KXuPTzu7IU/89ZkDUKt2wuCOAUFe/6Pk1TkZXsH6333AESfhg5wiTN2 RaOAzMlryMT10WPz4ixdsZGMBquR8Ep34KGnF4xgcZ+R65OG8Xo2owbt5ywoHhkd26v2 kgidpWquTyW8zMRC/5+Zgijagx5PxRaASqn0NnG9ZWqr9RBQygaO8x5vOSGFK477dKhv loW2BYEfZuKdwoJUFp5J/Iwr7SmO/1fdbcnytSEmzB6seugGd1eJJbF7ypcQb7HAmbyJ cg6mKZ4qNp3ZrV4O0fsjEsLpj+j3XN2AfYW1KV2K4gvUrdAWdbQOT0fG69xionxLWqpg Gw5w== X-Forwarded-Encrypted: i=1; AJvYcCWu8mdfXqaCJJ3ogVWp2ij6AsPUJC8vRbnHFeOznPL/qQxwcxP+YJmVgN2Yg9Hw7ON1ZIO2nZH+eDyS+1CR@lists.postgresql.org X-Gm-Message-State: AOJu0YzNEz1tktx5soJIKt1KL6Nqz0DQuLPkg+dbTgMf1nwWeWgwVN4O zH0FWA61AYgMCe60oG4WziVjJRQFBCp12pe13czBf9BmRrzJk1dy X-Gm-Gg: ASbGncsj7MfZAlEXsq6chdPU8PNZo5zXhygAqDykoHH/FMJ9MMp+CfjU97RTTAIeD9f V7C1yBlK7vRaM7DCNm3nU0itY4wi1Ujcb136trXHsOoFHqT9iqU0fKCZeKZ3YToO3FGqdfPb9wd nvKyd+cJad2n0fPqfgfIe0E3XpHs6gZooejsSJRuoKcUl0ddwFY+o6sx4eco4hsuO5+ftRQu8E9 swq31Xyyvz73eYZPPkFnU1ZaAblBdY25XkiUvmk6YPT1kTi1HysyKkFTq6LFHhfXCykJ3VzKL4u BEtxpZOY7jwsZFsgW7nWcpTDfQGMWnT7DpY0Fk7Qq/58f4/PFnZ+A4T47uKeqFFyQRHdocTq7BH j X-Google-Smtp-Source: AGHT+IGYEgphkASfHHo7ybNgCzRwXJudKWpMy4fyEsBOLBPXT5cdj7piMksLldIhNcF/PjEiRiRWeQ== X-Received: by 2002:a05:6000:184e:b0:382:3285:3ed with SMTP id ffacd0b85a97d-38254b154demr2160828f8f.38.1732111824982; Wed, 20 Nov 2024 06:10:24 -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-3825490c34asm2190598f8f.28.2024.11.20.06.10.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Nov 2024 06:10:24 -0800 (PST) Date: Wed, 20 Nov 2024 14:10:23 +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, Nov 14, 2024 at 03:31:51PM +0900, Michael Paquier wrote: > + /* > + * Do serialize or not this kind of stats. > + */ > + bool to_serialize:1; > > Not sure that "serialize" is the best term that applies here. For > pgstats entries, serialization refers to the matter of writing their > entries with a "serialized" name because they have an undefined number > when stored locally after a reload. I'd suggest to split this concept > into its own patch, rename the flag as "write_to_file" Yeah, also this could useful for custom statistics. So I created a dedicated thread and a patch proposal (see [1]). [1]: https://www.postgresql.org/message-id/Zz3skBqzBncSFIuY%40ip-10-97-1-34.eu-west-3.compute.internal Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com