Pginfo,
> Yes I have indexes on all this fields.
> Also I vacuumed and that is the result after it.
> Actualy I do not see what bad in query execution. The problem is in
> sort
> time!
Hmmm... I don't understand. The way I read the EXPLAIN, the sort is
only taking a few seconds. Am I missing something, here?
And that's "VACUUM FULL ANALYZE", not just "VACUUM", yes?
If all of the above has been tried, what happens to the query when you
set enable_seqscan=off?
-Josh Berkus