Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eOnO6-0006IN-NY for pgsql-docs@arkaria.postgresql.org; Tue, 12 Dec 2017 16:26:34 +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 1eOnO6-0005VA-AH for pgsql-docs@arkaria.postgresql.org; Tue, 12 Dec 2017 16:26:34 +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 1eOnO6-0005V0-5A for pgsql-docs@lists.postgresql.org; Tue, 12 Dec 2017 16:26:34 +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 1eOnO0-0005Yw-J0 for pgsql-docs@postgresql.org; Tue, 12 Dec 2017 16:26:33 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id EDF6B21661; Tue, 12 Dec 2017 11:26:26 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute7.internal (MEProxy); Tue, 12 Dec 2017 11:26:26 -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=ISkPZY aLsa11InzQ5d4D83mWz1ZJYeq/Vg4auSIMUQQ=; b=pGy9RdOLVrvJ+SrN1HuXE6 t/Hi+2UsZnH1YDleXJ7zhYH0yf+cOPANfuHTbdxSj9MwOX33AlodATzGJj9NcORp BJzwR3giopYzYjf53XsYIQaiYVjqECjJNUVZcD1lK74gYxET99wwIdOT9RflKjYI +S9VFooicaFF/yzZY0291U2rpwt18kCPgttzYWbAN9rijyRZb/aqz23ipI3IAL8Z 7LoilCkqJDkZHazAS+lz369UoudPwh1oGdnwHplwO3vyJwGfOaD1ABJUOydScrCR xAHizmYNIo/zT/ivGTD295PwUsOaS/v/6bU7Wwlk10ygWeRl+gS8oLEay3tp6JMQ == 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 6EA237E349; Tue, 12 Dec 2017 11:26:26 -0500 (EST) Subject: Re: Typo To: blaz@merela.org, pgsql-docs@postgresql.org References: <20171212120227.20142.46037@wrigleys.postgresql.org> From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Tue, 12 Dec 2017 11:26:25 -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: <20171212120227.20142.46037@wrigleys.postgresql.org> 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 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? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services