Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eR2jr-0007XJ-P3 for pgsql-docs@arkaria.postgresql.org; Mon, 18 Dec 2017 21:14:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eR2jr-00068g-Bq for pgsql-docs@arkaria.postgresql.org; Mon, 18 Dec 2017 21:14:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eR2jr-00068S-0B for pgsql-docs@lists.postgresql.org; Mon, 18 Dec 2017 21:14:19 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eR2jn-0001Dq-Ov for pgsql-docs@postgresql.org; Mon, 18 Dec 2017 21:14:18 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id CF0AD20C4F; Mon, 18 Dec 2017 16:14:13 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute7.internal (MEProxy); Mon, 18 Dec 2017 16:14:13 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=D+qfbb klXIXg8oF5im7zKLPOGCQW6eK9lbyHWHzbyqw=; b=cTz6M0UNI5fPber3uLQSaY bVIuHnThXPN6LRAePC/8yFAzq4zo3Q57PdWVI8NdXnchunEmF9Kl9fQSs9CwPN7e FH1LUjspqkzbpNsyWPs99r3II6Pxy7chlsiCVm2tPPGOs6gMpf0fERJGdi9ohlRY NYi96ZXIVOZuPU0io1HHnOvv+ASdYgBV32Tyc1Z1fqjGNIQ+RENxTjCXXJRMrHy9 WtyAsVQqp00LRI7nrS8JHkToc5eE4k1f+vmKO2vQH1KBYhk2rR2fzS9BwYm0Vs1Q Ukbn22lm4wzJHu1ugJF9J62z5UbCDjKEuiAS1zkLsLWCkQcLlB6n61jqH/PnAQJA == X-ME-Sender: Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id 8BE717E0E6; Mon, 18 Dec 2017 16:14:13 -0500 (EST) Subject: Re: Typo From: Peter Eisentraut To: blaz@merela.org, pgsql-docs@postgresql.org References: <20171212120227.20142.46037@wrigleys.postgresql.org> Organization: 2ndQuadrant Message-ID: <28908563-4c3a-c29e-7657-359ce2cc0aa0@2ndquadrant.com> Date: Mon, 18 Dec 2017 16:14:13 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/12/17 11:26, Peter Eisentraut wrote: > On 12/12/17 07:02, blaz@merela.org wrote: >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/10/static/using-explain.html >> Description: >> >> "The costs of the loop node are then set on the basis of the cost of the >> outer scan, plus one repetition of the inner scan for each outer row (10 * >> 7.87, here), plus a little CPU time for join processing." >> >> Shouldn't it be "10 * 7.91" inside the braces? > > Yes. That wasn't updated when the EXPLAIN output was regenerated some > time ago. Do you see any other numbers in the next that don't match the > EXPLAIN output? Fixes committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services