Database Query Optimization

Speeds up slow database queries by walking you through execution plan analysis, indexing strategies, and query rewrites. You'll use EXPLAIN ANALYZE to spot sequential scans that should be index scans, then apply fixes based on the specific bottleneck. Works well when you're debugging performance regressions or trying to reduce database CPU before scaling up hardware. The reference guides cover common patterns like avoiding N+1 queries and choosing between different index types. Honest take: this is solid for the 80% of query problems that come down to missing indexes or bad joins, but complex optimization still needs domain expertise.