Re: Why my query not using index to sort?

[Arup Rakshit <ar@xxxxxxx>]

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@xxxxxxx

On 29-Sep-2018, at 12:17 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxx <mailto:ar@xxxxxxx>

On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx <mailto:andreas@xxxxxxxxxxxxxxx>> 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@xxxxxxxxxxx