Postgres Pro
Downloads
Home   >   mailing lists

Re: Why my query not using index to sort? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: Why my query not using index to sort?
Date
Msg-id 40D9D4B8-7D62-4E6E-B6E9-3F83DACA2D45@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
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 by date:

Previous
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Why my query not using index to sort?