Surprisingly according to my last post, the additional where ci.item_id=cr.item_id makes PostgreSQL faster. So it looks like this performance issue is unique to Oracle. The query still takes .5 secs, but we know count is not fast on PostgreSQL under an circumstances.