Re: Why my query not using index to sort?

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Why my query not using index to sort?
Date: 2018-09-28 15:59:57
Message-ID: e737e767-6e89-3c37-e86f-c82e13855a51@a-kretschmer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Arup Rakshit 2018-09-28 16:01:56 Re: Why my query not using index to sort?
Previous Message Durgamahesh Manne 2018-09-28 15:41:37 regarding bdr extension