Postgres Pro
Downloads
Home   >   mailing lists

Re: Why my query not using index to sort? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: Why my query not using index to sort?
Date
Msg-id 6647C2E0-6C14-4599-A6DB-F9F379E539DF@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
Oh I see. That makes sense, I was reading too much into that line.. :)

Thanks,

Arup Rakshit



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



pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?