Re: Problems with non use of indexes

[Tyler Durden <tylersticky@xxxxxxxxx>]

On Fri, Mar 2, 2012 at 12:55 PM, Tomas Vondra <tv@xxxxxxxx> wrote:

On 2 Březen 2012, 13:45, Tyler Durden wrote:
>>
> Yes, but if I remove *U0."user_id" = 1 *will use the index:

Which PostgreSQL version is that? Post EXPLAIN ANALYZE output for all
three queries, not just EXPLAIN. And use explain.depesz.com if possible,
it's much more readable.

kind regards
Tomas

I'm using PostgreSQL 8.4.2 and you can find the EXPLAIN ANALYSE VERBOSE in http://explain.depesz.com/s/hk2

Thanks!