On Fri, Mar 2, 2012 at 12:55 PM, Tomas Vondra <t...@fuzzy.cz> 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!
