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