Home > mailing lists

Re: seqscan for 100 out of 3M rows, index present - Mailing list pgsql-performance

From	Willy-Bas Loos
Subject	Re: seqscan for 100 out of 3M rows, index present
Date	June 26, 2013 23:36:14
Msg-id	CAHnozTiLdn=1XH7X4XyUoD3e=n2sXt=RUCZ3KWr-f6W8WK5SFQ@mail.gmail.com Whole thread Raw
In response to	Re: seqscan for 100 out of 3M rows, index present (Jeff Janes <jeff.janes@gmail.com>)
Responses	Re: seqscan for 100 out of 3M rows, index present ("ktm@rice.edu" <ktm@rice.edu>)
List	pgsql-performance

On Wed, Jun 26, 2013 at 10:31 PM, Jeff Janes <jeff.janes@gmail.com> wrote:

Why is it retrieving 3.1 million, when it only needs 17?

that's because of the sequential scan, it reads all the data.

cheers,

willy-bas

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

From: Jeff Janes
Date: 26 June 2013, 23:31:39
Subject: Re: seqscan for 100 out of 3M rows, index present

From: Victor Yegorov
Date: 26 June 2013, 23:46:32
Subject: Re: seqscan for 100 out of 3M rows, index present