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

2019-05-10 Thread bb ddd
Hello, I have the following question. Looking at the output of EXPLAIN ANALYZE: 1) I have 2 Index Scans inside a Nested Loop2) Nested Loop's expected rows=12683.1) First Index Scan's expected rows=73.2) Second Index Scan's expected rows=43810 I was living under the impression that a Nested Loop'

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

2019-05-10 Thread bb ddd
s expected rows=7 3.2) Second Index Scan's expected rows=43810 > Оригинално писмо ---- >От: bb ddd nnickoloff1...@abv.bg >Относно: Question about Expected rows value in EXPLAIN output for Nested Loop >node >До: pgsql-gene...@postgresql.org &

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

2019-05-10 Thread bb ddd
t for Nested Loop node >До: bb ddd >Изпратено на: 10.05.2019 16:52 > 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 let

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

2019-05-11 Thread bb ddd
am just guessing. > Оригинално писмо >От: Adrian Klaver adrian.kla...@aklaver.com >Относно: Re: Question about Expected rows value in EXPLAIN output for Nested Loop node >До: bb ddd >Изпратено на: 10.05.2019 19:02 > On 5/10/19 8:56 AM, bb ddd wrote: > >