Use when a query or endpoint is slow, when designing indexes, or when reviewing data access code — reading EXPLAIN output, index selection, N+1 queries, pagination, and connection pool limits. Triggers on slow queries, timeouts under load, "the database is the bottleneck", ORM-generated SQL, or adding an index.
