Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: Why my query not using index to sort?
Date
Msg-id e737e767-6e89-3c37-e86f-c82e13855a51@a-kretschmer.de
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
Responses Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
List pgsql-general
Tree view 

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: Durgamahesh Manne
Date:
Subject: regarding bdr extension
Next
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?