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:01:56
Message-ID: 6647C2E0-6C14-4599-A6DB-F9F379E539DF@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oh I see. That makes sense, I was reading too much into that line.. :)

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

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2018-09-28 16:03:44 Re: Why my query not using index to sort?
Previous Message Andreas Kretschmer 2018-09-28 15:59:57 Re: Why my query not using index to sort?