Re: Question about Expected rows value in EXPLAIN output for NestedLoop node - Mailing list pgsql-general

On 5/10/19 5:32 AM, bb ddd wrote:
> 
> Not sure why some of the new lines disappeared in the original message.
> here is the part that got most corrupted with some more new lines lets
> hope it looks more readable now
> 
> 
> 
> 1) I have 2 Index Scans inside a Nested Loop
> 
> 2) Nested Loop's expected rows=1268
> 
> 
> 3.1) First Index Scan's expected rows=7
> 
> 3.2) Second Index Scan's expected rows=43810
> 

The best way to handle this is to post your EXPLAIN output to:

https://explain.depesz.com/

and then post the link here.

-- 
Adrian Klaver
adrian.klaver@aklaver.com