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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Question about Expected rows value in EXPLAIN output for NestedLoop node
Дата
Msg-id 7ad0fba4-73b3-1459-93a7-a30cdcbb5bb9@aklaver.com
обсуждение исходный текст
Ответ на Re: Question about Expected rows value in EXPLAIN output for Nested Loop node  (bb ddd <nnickoloff1234@abv.bg>)
Ответы Re: Question about Expected rows value in EXPLAIN output for Nested Loop node  (bb ddd <nnickoloff1234@abv.bg>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: bb ddd
Дата:
Сообщение: Re: Question about Expected rows value in EXPLAIN output for Nested Loop node
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: perl path issue