Re: Performance of a nested loop, whose inner loop uses an index scan.

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Performance of a nested loop, whose inner loop uses an index scan.
Дата
Msg-id CAJghg4Lbs-a-_xTmdTWcuQTiZCpv8hTjv2-kWc2_teyNAWiD8w@mail.gmail.com
обсуждение исходный текст
Ответ на Performance of a nested loop, whose inner loop uses an index scan.  (negora <public@negora.com>)
Ответы Re: Performance of a nested loop, whose inner loop uses an index scan.  (negora <public@negora.com>)
Список pgsql-performance
Дерево обсуждения

On Wed, Oct 19, 2016 at 8:54 AM, negora <public@negora.com> wrote:
    Nested Loop  (cost=245.92..383723.28 rows=7109606 width=38) (actual
time=1.091..2616.553 rows=8906075 loops=1)

I wonder about the use-case for this query, because it returns more than 8M rows, so 2.6 seconds that sounds that much for so many rows. Is it for an end user application? Isn't there any kind of pagination?


--
Matheus de Oliveira


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

Предыдущее
От: negora
Дата:
Сообщение: Performance of a nested loop, whose inner loop uses an index scan.
Следующее
От: negora
Дата:
Сообщение: Re: Performance of a nested loop, whose inner loop uses an index scan.