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
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных