Search Postgresql Archives

Re: Question about Expected rows value in EXPLAIN output for Nested Loop node

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux