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 a...@zeit.io > On 29-Sep-2018, at 12:17 AM, Adrian Klaver <adrian.kla...@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 >> a...@zeit.io <mailto:a...@zeit.io> >>> On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <andr...@a-kretschmer.de >>> <mailto:andr...@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.kla...@aklaver.com
