Your Postgres CPU is at 60%, users are complaining about slow pages, and EXPLAIN ANALYZE on the query in psql shows a fast index scan. The real problem is the other 99% of your queries. Here is how to use pg_stat_statements, auto_explain, and planner cost…