Re: Why my query not using index to sort?

On 9/28/18 11:32 AM, Arup Rakshit wrote:
> Yes. But I thought I could improve it, so that it can be finished in 
> 0.xx ms. It takes now between 1.7 to 1.9 ms in production.

That is not what you showed in your first post:

Planning time: 0.178 ms
Execution time: 0.527 ms



> 
> 
> Thanks,
> 
> Arup Rakshit
> ar@zeit.io <mailto:ar@zeit.io>
> 
> 
> 
>> On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer 
>> <andreas@a-kretschmer.de <mailto:andreas@a-kretschmer.de>> wrote:
>>
>>
>>
>> Am 28.09.2018 um 18:03 schrieb Arup Rakshit:
>>> Also I meatn the execution time is less than I had before with 
>>> enable_sort = off.
>>
>> yeah, but not that much. different plan.
>>
>>
>> Regards, Andreas
>>
>> -- 
>> 2ndQuadrant - The PostgreSQL Support Company.
>> www.2ndQuadrant.com <http://www.2ndQuadrant.com>
>>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com