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 [email protected] > On 29-Sep-2018, at 12:17 AM, Adrian Klaver <[email protected]> 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 >> [email protected] <mailto:[email protected]> >>> On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <[email protected] >>> <mailto:[email protected]>> 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 > [email protected]
