From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Arup Rakshit <ar(at)zeit(dot)io>, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Why my query not using index to sort? |
Date: | 2018-09-28 18:47:25 |
Message-ID: | 2c10559c-21fa-bb73-3814-cec5583ddb6c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Arup Rakshit | 2018-09-28 18:51:20 | Re: Why my query not using index to sort? |
Previous Message | Arup Rakshit | 2018-09-28 18:32:38 | Re: Why my query not using index to sort? |