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.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wR5TP-0026BC-1E
	for pgsql-hackers@arkaria.postgresql.org;
	Sun, 24 May 2026 09:50:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1wR5TL-00GjJw-1X
	for pgsql-hackers@arkaria.postgresql.org;
	Sun, 24 May 2026 09:50:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <me@jeltef.nl>)
	id 1wR5TL-00GjJo-0K
	for pgsql-hackers@lists.postgresql.org;
	Sun, 24 May 2026 09:50:16 +0000
Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <me@jeltef.nl>)
	id 1wR5TJ-00000001Asy-1Rgu
	for pgsql-hackers@postgresql.org;
	Sun, 24 May 2026 09:50:15 +0000
Received: by mail-lf1-x133.google.com with SMTP id
 2adb3069b0e04-5a40502e63bso8829727e87.0
        for <pgsql-hackers@postgresql.org>;
 Sun, 24 May 2026 02:50:12 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; t=1779616211; cv=none;
        d=google.com; s=arc-20240605;
        b=McoOR2/Yde7uvEmEgygmx/8c1ZtV7USoH2ZllEbX1LMT4oi2p23EDqp6HHM5EL0yDU
         0qAxndMVd+Y7NjClVl4DwA881/a1AYof5W2UEDQgJl1AXAO0nFrCwFoiShG9g4lyE3xS
         hKDeAmvqjYtia7ACtpSwOh2axTicQfMZLK3CGtlEeOitraoGNWfd4kXkANQ+4yeKsdLI
         r1ZTKpSsPjwyOXqL06QsGCxi/k9TWs6QL61KBnp/3oJEHN9lF7MV9/TCmXFClyWrXhUK
         MpQkwJd//jhdbzfBj4b03vCmxfKT7lk5r45dIDAE/hu5dBI+9OYxSbSi8aLqKadwILgF
         m02A==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20240605;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:dkim-signature;
        bh=jkLNl+WSKfRH3/3jQOuiu3KTaeB32c6PQ2p1OTmE3ns=;
        fh=EBQdDuxtmV+CeNKaVQtGzSECgfXa14afYf4v1b+rDAQ=;
        b=WNx/dg6Bxc73MYz32rXCkTA25qfKhE4IpwRQD7OSxjbCbMi6nPhVjxnAFogQPJHjma
         Keo5iLcwuABo171GVT69cJ0E44QsmcguS5DNWB5UrKyGUhviG105KdqR79a3begB7FgH
         9EeN0YPyUNsIDzV6NHYC18aWXPA3p5ICGTBCfUy3LvjK0Lm/LecZ0tLeu3JHkTVjxcjS
         AUUC0Lt5zlTjFzQ+otySAS+/EuIBc9PSkSQCf081ZoGO06aB5zCbrC03HamNYSA0o/X1
         aGjU+lhDfaHJxhjTqcqsbJjKJ2XCh7X2IRyjwV77X/+8HKXhBng4psYUyTTrDhDa4/Ww
         ZaRg==;
        darn=postgresql.org
ARC-Authentication-Results: i=1; mx.google.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=jeltef.nl; s=google; t=1779616211; x=1780221011;
 darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=jkLNl+WSKfRH3/3jQOuiu3KTaeB32c6PQ2p1OTmE3ns=;
        b=PTWYgBh5ooyYILEV61AT0V0455GXvAdWTBv6mn7gywWBjC9IrHZH5HL8RGLd6+9DYZ
         4cCRx4FCSv/diKRbJAo9BY01xzUOP0JGga3QiXySrZn7SKhsYSvp2P7Np95J71l2VbHM
         bxLBW/McRvOsYqmDz6Zq1Rkxz2+EsPK/RKhuoJ1Az0pJjqeSjibCvajUfaeOJ71zgThE
         rmMWwc6xRME34b4EVCxDVLd7pGozFmq6bA8Y+0vKHlSkyK9lfCc8BXmnr6g+kSOWEVOk
         50R/Q3GGj7VFvXTCvkQBRUJjVnydNfEAgvXTUPPLRkA08IieQ0HJgb13AtajGVibkwWt
         3vPw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20251104; t=1779616211; x=1780221011;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=jkLNl+WSKfRH3/3jQOuiu3KTaeB32c6PQ2p1OTmE3ns=;
        b=NKzTcmtnGpopJVRk/6bh50Fgd8Wcsf5glUqLHHRR289SAklkklnsil5FEQrbOz8Kxl
         ASy+5odp/NTwuoDovBlKNKkZYen3QmEonWu2sv8THqJzVO/KP98WIEy9sSIyRXzEmnQz
         r1wA8qG+jdxvaqQ7twXWdqtopbWery6Uzsks9UJP3oWPJA4bxZzimja/ith6FUwO2yvV
         7Oa/z7oY8Bpm275uaYD37o4Y4uEPN5b0whfOHXpkUFJgIcSz/x79helxkHtCiHb8+XAS
         np6J7UbsBzUeZfdcZ4FKGkJBMq2Xx1vJk7YFeY3BOMSct3cxVDmJwX8YLDfStuKopBz3
         7wvQ==
X-Forwarded-Encrypted: i=1;
 AFNElJ8M9+NoN819sDMe8NAYiz129We1ocOCqr1eHRQQdP8nNjrmf9sTNoiBheWhT834FC0s4pvkhy/wVOfy6cMt@postgresql.org
X-Gm-Message-State: AOJu0YwyJTpaRd5nmVuMV7WYAzZDBH088zFLdgVn2dURCzl5U4tUp5Xd
	hPBM8ym2bvzWfeeGhDbkke0aBQD9UNdQjHYe8eb442WGkY8gh7e7weJDpKYbcg52eIwSFgtG0/z
	38SRJZXTSgQcnc5rMbX/uVSpoNN+iBZkgVeO453JRtw==
X-Gm-Gg: Acq92OFQo4CemabD3jDLcWLXaWUiPfGwr/NRZHsBj0TYwodHPxyTTcxEAHRtMdJP7FU
	8RyGQ+brle+RechVVmafCiYfo5i/xipb2OLVied3jgI03FWz+wCSDqaSrddIPQyYny96rzYiQe7
	4FnlUTvYYLx12YNMsXIscKB2vwCAlgGRtEtfXJy1+sutXAmN508/RP6jAKgqWr1gsWEEdk8YpED
	//ABoMtNSFatjH86KCM2su+ZJ9651D2vtURUezlWR/ojA+1HBHtKzPNTGIaqDhU9Ijkvmenm6zt
	mqDt/tgRNTSnlsKM9sM=
X-Received: by 2002:a05:6512:3b9d:b0:5a8:9f6f:3212 with SMTP id
 2adb3069b0e04-5aa323a9b83mr3303417e87.34.1779616210662; Sun, 24 May 2026
 02:50:10 -0700 (PDT)
MIME-Version: 1.0
References: <c20f6340eb26f3b736abc59471bfada8@oss.nttdata.com>
 <CAGXjcj=hnEZCCDDMRv06EQnDcv0mRe6+Ph1gv8=Hb7NEc51y5A@mail.gmail.com>
 <CAM6-o=DnHSj2q9_+Wohrvagd-QAqvpoepNRS9LRadMBCkTAMkw@mail.gmail.com>
In-Reply-To: 
 <CAM6-o=DnHSj2q9_+Wohrvagd-QAqvpoepNRS9LRadMBCkTAMkw@mail.gmail.com>
From: Jelte Fennema-Nio <postgres@jeltef.nl>
Date: Sun, 24 May 2026 11:50:00 +0200
X-Gm-Features: AVHnY4Lqs5DBxAlSf3qFPq5rqKyzVYwUAAN8JMO2XQ2AIFjOVYLuubMMW6gcyGk
Message-ID: 
 <CAGECzQSOrmOTSyVHi1tkx9QDg9_PkVJudtdTH0B7ovHeZXtFLQ@mail.gmail.com>
Subject: Re: RFC: Allow EXPLAIN to Output Page Fault Information
To: Atsushi Torikoshi <torikoshia.tech@gmail.com>
Cc: vellaipandiyan sm <vellaipandiyan.sm@gmail.com>,
 torikoshia <torikoshia@oss.nttdata.com>,
	Pgsql Hackers <pgsql-hackers@postgresql.org>, Tomas Vondra <tomas@vondra.me>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CAGECzQSOrmOTSyVHi1tkx9QDg9_PkVJudtdTH0B7ovHeZXtFLQ%40mail.gmail.com>
Precedence: bulk

On Fri, 22 May 2026 at 18:07, Atsushi Torikoshi
<torikoshia.tech@gmail.com> wrote:
> Updated the patch to clarify that the reported values include not only
> the backend process executing the query, but also any parallel query
> worker processes involved in the query.

For PG19 Tomas added an IO option to EXPLAIN. I think it would be
better to have the Storage IO tracking be enabled by the IO option,
rather than the BUFFERS option.