Re: Why my query not using index to sort?

From: Arup Rakshit <ar(at)zeit(dot)io>
To: 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 16:03:44
Message-ID: 40D9D4B8-7D62-4E6E-B6E9-3F83DACA2D45@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Also I meatn the execution time is less than I had before with enable_sort = off. Why 6 rows was a side question. :)

Thanks,

Arup Rakshit
ar(at)zeit(dot)io

> On 28-Sep-2018, at 9:29 PM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> wrote:
>
>
>
> Am 28.09.2018 um 16:49 schrieb Arup Rakshit:
>> Planning time: 1.867 ms
>> Execution time: 0.252 ms
>> (6 rows)
>>
>> Why it is showing *6 rows*? Also it seems less than what I had before:
>>
>
> the explain-output are 6 rows ;-)
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
> www.2ndQuadrant.com
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-09-28 16:16:30 Re: Why my query not using index to sort?
Previous Message Arup Rakshit 2018-09-28 16:01:56 Re: Why my query not using index to sort?