Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jLTG5-0004fd-Lw
	for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2020 15:01:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jLTG4-0002Gz-Bx
	for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Apr 2020 15:01:52 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1jLTG3-0002DN-Jq
	for pgsql-hackers@lists.postgresql.org; Mon, 06 Apr 2020 15:01:52 +0000
Received: from [64.147.123.20] (helo=wout4-smtp.messagingengine.com)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1jLTFz-0002Ju-VB
	for pgsql-hackers@postgresql.org; Mon, 06 Apr 2020 15:01:51 +0000
Received: from compute1.internal (compute1.nyi.internal [10.202.2.41])
	by mailout.west.internal (Postfix) with ESMTP id 17620396;
	Mon,  6 Apr 2020 11:01:35 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute1.internal (MEProxy); Mon, 06 Apr 2020 11:01:35 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm2; bh=jSmNzYbpWZRi4PA9ZVMJUgqyqyAYcvV6Nvahpzx6A
	IY=; b=gHC8XWLpksVspqY/wIuf5IKXSfDBgEndyY4H2HKVGcOBTFfbHC0Kq0JUl
	K6DI3OkWOrZk5ALd3XwXpO4rZeyK3kFDx09qM3qOa581Uui2mB9bnp3VAaMCSL80
	lAk/MPSmCcJutHF23PG3is/MEs9q2KBzlfThHySOXs1xOzvLedRN7LdBYz2rWSd+
	mDOha8FMEjLCGBSFAFr+FmAFeRjB71PjVrrlJlG8j6QX44JqYUXoYY3sDADB1HYu
	gD39dqE4i9wSs1LLuJIQEzCbFRLGEYgs2dVmUfzRJgBZAehlvjsLXKjjbTDEXsVL
	t75nca+4a0T6jlPrvTjX5g8C3AhSw==
X-ME-Sender: <xms:TUSLXo3tWWJuE_LTFjWqvhUcoOwpfXJrMfiUVjKSB1ZfiMtVCwzcow>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduhedrudefgdejiecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu
    uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc
    fjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv
    rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh
    hurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdrtgho
    mhenucfkphepleefrddvgedvrddvudefrddvgedunecuvehluhhsthgvrhfuihiivgeptd
    enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedv
    nhguqhhurggurhgrnhhtrdgtohhm
X-ME-Proxy: <xmx:TUSLXrJ4PV8yl8Raz8JKfVmWAAGNJGyIALSBbFiQoA9KMo1JRUtLaQ>
    <xmx:TUSLXmAFE62_XY10sER2ddj0jP4BMSrQukDnicErNLvBquTVkR6axA>
    <xmx:TUSLXtYblKWRyOORWt2JvAj7pvxWorfKfaPvgwVWXgD7piD2C-jxbA>
    <xmx:TkSLXidwkUxf6qQPtDII5Pii7mxiwX6JL2T_HSBESUNAg25Ysq4ELQ>
Received: from april.pezone.net (p5df2d5f1.dip0.t-ipconnect.de
 [93.242.213.241])
	by mail.messagingengine.com (Postfix) with ESMTPA id 9B4F3328006B;
	Mon,  6 Apr 2020 11:01:32 -0400 (EDT)
Subject: Re: WAL usage calculation patch
To: Amit Kapila <amit.kapila16@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>
References: <20200330124356.GE79261@nol>
 <CAGz5QC+H4idCkRNojT0=VDLYs7mRBM0an6OZwS5NBdbrb6yKJA@mail.gmail.com>
 <20200401080152.GA82418@nol>
 <CAA4eK1KxT5ckuaiQqhUsNn=S3yQsxgC5aeiUoXxnS-i2W4K+_g@mail.gmail.com>
 <20200401142954.GA64485@nol>
 <CAA4eK1JULzGi9SrCnnPbKKiLaVnPhU+uUbbghduRNnC-zFeKAQ@mail.gmail.com>
 <20200402083035.GB64485@nol>
 <CAA4eK1+CDwmKyJeDYHZ4xFftK9TRW5pF+kkPsgGY8UAJqFNJKQ@mail.gmail.com>
 <20200402124818.GD64485@nol>
 <CAA4eK1LNg7Q6pxrochATMSJmadrzPKJODGAAxbgmgnWbi63UNw@mail.gmail.com>
 <CAFiTN-sHQ-bHwqEYOVOMjZ7VoQafWKLaTYiWvf-rR+twZ4LOwQ@mail.gmail.com>
 <CAFiTN-sONFPUHxMpn9m4=Z+m_MubCdvcVD75+QRK5jxVmUce8w@mail.gmail.com>
 <CAA4eK1LjkwGOegWMfs3tggD3-BXLzyZXFz7qBZaf_yLBPjZdHQ@mail.gmail.com>
 <CAFiTN-su_D35-csorD=soxnkL=g9ZVdnTN3QfPfK_TNp2t4Kug@mail.gmail.com>
 <CAFiTN-vAqkDV5Whxw2OvdbN9OU7xZyKzRrUG6m6dr8nvG-R=Yw@mail.gmail.com>
 <CAA4eK1Jh=EjwK+etqeaWM6gcNaex1FX6xTFqR7QXXQy2CmGQsw@mail.gmail.com>
 <CAA4eK1KqiWqAgw9ETchcQf-z9ZY4aUN-4QvTh0R26+DpNnTDHg@mail.gmail.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>,
 Kuntal Ghosh <kuntalghosh.2007@gmail.com>,
 Fujii Masao <masao.fujii@oss.nttdata.com>,
 Kirill Bychik <kirill.bychik@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 Thomas Munro <thomas.munro@gmail.com>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <ef8c966f-e50a-c583-7b1e-85de6f4ca0d3@2ndquadrant.com>
Date: Mon, 6 Apr 2020 17:01:30 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAA4eK1KqiWqAgw9ETchcQf-z9ZY4aUN-4QvTh0R26+DpNnTDHg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.20 (deferred)
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>
Precedence: bulk

I noticed in some of the screenshots that were tweeted that for example in

     WAL:  records=1  bytes=56

there are two spaces between pieces of data.  This doesn't match the 
rest of the EXPLAIN output.  Can that be adjusted?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services