Re: Why my query not using index to sort?

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: Why my query not using index to sort?
Дата
Msg-id 40D9D4B8-7D62-4E6E-B6E9-3F83DACA2D45@zeit.io
обсуждение исходный текст
Ответ на Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Дерево обсуждения
Also I meatn the execution time is less than I had before with enable_sort = off. Why 6 rows was a side question. :)

Thanks,

Arup Rakshit



On 28-Sep-2018, at 9:29 PM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:



Am 28.09.2018 um 16:49 schrieb Arup Rakshit:
 Planning time: 1.867 ms
 Execution time: 0.252 ms
(6 rows)

Why it is showing *6 rows*? Also it seems less than what I had before:


the explain-output are 6 rows ;-)


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



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

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: Re: Why my query not using index to sort?
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Why my query not using index to sort?