Re: Why my query not using index to sort?

[Arup Rakshit <ar@xxxxxxx>]

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

Thanks,

Arup Rakshit

ar@xxxxxxx

On 28-Sep-2018, at 9:29 PM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> 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