Diagnose slow database access patterns — N+1 queries, missing eager-loading in SQLAlchemy, and inefficient aggregation — particularly in list and analytics endpoints (Drives, Applications, Results, Analytics). Use when the user reports a slow endpoint, before demoing the Analytics dashboard, or when reviewing any endpoint that returns a list of records with related data (e.g. applications with their drive and company details). This complements database-index-optimization (which fixes missing indexes) by focusing on query construction and ORM usage patterns instead.
