Re: Unexpected query plan results - Mailing list pgsql-performance

From Anne Rosset
Subject Re: Unexpected query plan results
Date
Msg-id 4A205A4A.5050406@collab.net
Whole thread Raw
In response to Re: Unexpected query plan results  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Unexpected query plan results
List pgsql-performance
Robert Haas wrote:

>On Thu, May 28, 2009 at 6:46 PM, Anne Rosset <arosset@collab.net> wrote:
>
>
>>                                                 ->  Index Scan using
>>item_pk on item  (cost=0.00..176865.31 rows=97498 width=88) (actual
>>time=117.304..2405.060 rows=71 loops=1)
>>                                                       Filter: ((NOT
>>is_deleted) AND ((folder_id)::text = 'tracker3641'::text))
>>
>>
>
>The fact that the estimated row count differs from the actual row
>count by a factor of more than 1000 is likely the root cause of your
>problem here.  You probably want to figure out why that's happening.
>How many rows are in that table and what value are you using for
>default_statistics_target?
>
>...Robert
>
>

The table has 468173 rows and the value for default_statistics_target is
750.
Anne

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Unexpected query plan results
Next
From: Robert Haas
Date:
Subject: Re: Unexpected query plan results