How do you read a query plan (`EXPLAIN` / `EXPLAIN ANALYZE`) to diagnose a slow query in Rails?

Topic: rails, Database. Level: Intermediate.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.