There are two slow queries: a COUNT and an actual retrieval with similar conditions. http://paste.ubuntu.com/465800/ is an EXPLAIN ANALYZE of the latter query, from yesterday.
There are two slow queries: a COUNT and an actual retrieval with similar conditions. http:// paste.ubuntu. com/465800/ is an EXPLAIN ANALYZE of the latter query, from yesterday.