From: Robert Haas <robertmhaas@gmail.com>
To: Sebastjan Trepca <trepca@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problems with ordering (can't force query planner to use an index)
Date: Tue, 3 Mar 2009 12:40:44 -0500
Message-ID: <603c8f070903030940n3fb1e9eay53666d06cf489469@mail.gmail.com> (raw)
In-Reply-To: <cd329af80903030920x7ccb7b10l7a279a464cab5bd4@mail.gmail.com>
References: <cd329af80903030905y2efa15bdt123779ee8877df4a@mail.gmail.com>
<603c8f070903030912t36c541ebr50b4576c7a9a5b65@mail.gmail.com>
<cd329af80903030920x7ccb7b10l7a279a464cab5bd4@mail.gmail.com>
On Tue, Mar 3, 2009 at 12:20 PM, Sebastjan Trepca <trepca@gmail.com> wrote:
> But it's already attached in the first mail or am I missing something?
>
> If you don't see it, check this: http://pastebin.com/d71b996d0
Woops, sorry, I thought you had sent plain EXPLAIN. I see it now.
The lowest level at which I see a problem is here:
-> Index Scan using core_accessor_fresh_idx on core_accessor
(cost=0.00..5460.07 rows=2970 width=92) (actual time=0.068..54.921
rows=69312 loops=1)
Index Cond: ((slot_id = 472) AND (slot_type_id = 119) AND (label =
''::text) AND (user_id = 0) AND (role = 0) AND (publish_state >= 60))
For some reason it expect 2970 rows but gets 69312.
A good place to start is to change your default_statistics_target
value to 100 in postgresql.conf, restart postgresql, and re-ANALYZE.
...Robert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: robertmhaas@gmail.com, trepca@gmail.com
Subject: Re: Problems with ordering (can't force query planner to use an index)
In-Reply-To: <603c8f070903030940n3fb1e9eay53666d06cf489469@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox