Re: Why my query not using index to sort?

Yes, I have shown the explain plan output. But in my application log the sql query prints 1.7 to 1.9 ms.

Thanks,

Arup Rakshit
ar(at)zeit(dot)io

> On 29-Sep-2018, at 12:17 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> 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(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>
>>> On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de <mailto:andreas(at)a-kretschmer(dot)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(dot)klaver(at)aklaver(dot)com