Index strategies, query optimization, and EXPLAIN ANALYZE patterns. Study notes, not a production war story.

Two users booked the same turf slot at the same time. Here's what was happening at the database level and how SELECT FOR UPDATE fixed it.