The analytics team reports that queries filtering by created_at on the orders table are slow during peak hours. Claude suggests creating an index to improve performance.
The orders table has 12 million rows and handles ~500 inserts per minute during business hours. There is no current index on created_at. The database is PostgreSQL 16 running on a single primary instance with read replicas for analytics.