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 327CBA05-3910-416D-B1E0-175C44A256AE@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Why my query not using index to sort?  (Rob Sargent <robjsargent@gmail.com>)
Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view

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



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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Rob Sargent
Date:
Subject: Re: Why my query not using index to sort?