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 1tjv6b-00Efzn-Hi for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Feb 2025 06:59:49 +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 1tjv6Z-00DoT3-Jr for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Feb 2025 06:59:47 +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 1tjv6Z-00DoSv-8E for pgsql-hackers@lists.postgresql.org; Mon, 17 Feb 2025 06:59:47 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tjv6X-001GDM-0R for pgsql-hackers@lists.postgresql.org; Mon, 17 Feb 2025 06:59:46 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-38f325dd9e6so960639f8f.1 for ; Sun, 16 Feb 2025 22:59:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739775583; x=1740380383; 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=biBFCamO2P+Hl/bUbbLUUgaaaRYDEhsOeJkKh88rQNE=; b=H1IJy+92z8teeEWefKw9sht3ieeT+wekhQzwixKo1x84bVs52svYm+7B9i0ix0qmU0 XbN/Rg/EamJ196BKg3yGcY90cmzHKpOdlt+hKM/1gMgesiYd+CfzefPpG2SPFf2TIsDl frH08l5E9tDGZT99WfcgH9t2KoOHsGc/nyz0VmSl7XPY4Yw9QrGLteKoJAsQGGj7vDjU cyjeY0kooyixRVpa6eCC1V+IZ7/yTnYIBq3CID7Do2Xw65mdUn/apXRmIvVIT3EAyO8h tlrjbP/Vir7H9Bu55LAA9mh/F6gQaStlpU6JikVmzsndz5VBogw2fD/PENZOucHA9Qr7 xSsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739775583; x=1740380383; 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=biBFCamO2P+Hl/bUbbLUUgaaaRYDEhsOeJkKh88rQNE=; b=ScjmP02M12ugpp8U64Qo0x57LqjZHoRCQWVJ3WeXZe48baIYG/Hbz8CANpfPtImEyB Ju9qSFhDrF2BGsWQUbZwo1OYxhPrcmq3egdSEfvK347LyiZV8kXywEn2mcu0/BVHdnsp H5ACIK+UlK3qf//QtHufuY6JrpTXCDBYuCAVxDAzCsTXx0jv4744ajKXC5K19bCdKuFl lxjyD4f96Co6caolHe1x84IfnhedaVRINhNKI8AW9DZayB4gqX+LHXVd9rIA4GOyiz9t qtmSS95SvtbQlaa7Gu45yprVs2h2YdphFDN+HkwTQm3PTjaPqcuxq99R4MuskqRiDhSe UQZw== X-Forwarded-Encrypted: i=1; AJvYcCUL3szdGGFTDNqkIQIiDhOUK7d9hiS9XoV/yaP7djvb9JfpRfSkihLoOhmMCo5IXmX8KV/v4vcB05k3ThpT@lists.postgresql.org X-Gm-Message-State: AOJu0YxwavJp4kplwGjOV6qxQGTOAXD/UyIQNIhtmZt0T3+zc0Bk7BbI sYBNWmaIghaQBuJhsrcLExiOrapk/z//qBuCOyZxhVmonThdOb4v X-Gm-Gg: ASbGncvlUrJCx0PvDllyHtcHCVj+YhCmrty47YYw258W1ANXt7IiXQUyLAMH0dUDhU+ nDxwClFFN1LNSxVdTg2ExFygk4BJkRvffPaYTISkflPiUr8tynQbvhtJx2LvDNxm/uZ8TCxJvDq +FIENZxT6YMtUZJl6hQ8NIWLARQixdAkpmI3L4TtEgyJhVm3Z3T9Siy//1SeEk2a1qcgtXwQkPq 77Fcywx52dbt3B8xfWtnAEnWgmvaFkexprwuGnGEx5fW2U/NyTs0T5s9ZGdzj+lDYzklroV9bya GD6zkUNY4yPDzalnOLOMyBBxizxOpoCNvnsuW/fi3IEPQy1tiJ2lJLi/J+dcrYTtmsjseDPwmNh UOkhd6nRQNcrFVHb+fNmpQf4fJKjaTgK3YVFsvTyrHeY4Wjk= X-Google-Smtp-Source: AGHT+IEFKVNDXnfxDlDp7S8TgnYHf6MkcDYSoEtBOD9sRerrCq5Gm/0MsCLsQPOXbBPoQvXyiJXxsg== X-Received: by 2002:a05:6000:2ab:b0:38f:3e8d:dd42 with SMTP id ffacd0b85a97d-38f3e8dde30mr3460985f8f.53.1739775582727; Sun, 16 Feb 2025 22:59:42 -0800 (PST) Received: from ip-10-97-1-34.eu-west-3.compute.internal (ec2-15-237-181-182.eu-west-3.compute.amazonaws.com. [15.237.181.182]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38f258b434fsm11568852f8f.16.2025.02.16.22.59.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 16 Feb 2025 22:59:42 -0800 (PST) Date: Mon, 17 Feb 2025 06:59:40 +0000 From: Bertrand Drouvot To: Michael Paquier 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: 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, Feb 06, 2025 at 10:28:48AM +0000, Bertrand Drouvot wrote: > Hi, > > On Thu, Feb 06, 2025 at 10:38:55AM +0900, Michael Paquier wrote: > > On Wed, Feb 05, 2025 at 02:28:08PM +0000, Bertrand Drouvot wrote: > > > Agree, I'll start a dedicated thread for that. > > > > Thanks. > > Done in [1]. > > [1]: https://www.postgresql.org/message-id/flat/Z6SOha5YFFgvpwQY%40ip-10-97-1-34.eu-west-3.compute.internal Thanks for having committed the work done in [1] above. 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]. I'll add it in the new patch serie for this thread (that simplifies the new pg_stat_wal_build_tuple() among other things) unless Nazir beat me to it. [2]: https://www.postgresql.org/message-id/Z6L3ZNGCljZZouvN%40paquier.xyz Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com