Please show EXPLAIN ANALYZE output for your queries, not just EXPLAIN. Also it would be useful to see the pg_stats rows for the date_key and content_key columns.
regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend