Thread: Typo
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?
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
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