performance-query-review

To diagnose slow ORM queries, analyze endpoint query paths to detect N+1 patterns, assess query shapes, and evaluate index usage. Provide the endpoint or query path along with observed latency to produce evidence-backed bottlenecks and minimal measurable fixes.

Fix database query bottlenecks by identifying slow query paths and ORM loading issues. Apply targeted optimizations like pagination adjustments and index improvements, then verify results with minimal measurable steps to reduce overall endpoint response time.

Run EXPLAIN ANALYZE when the database performance review indicates complex query shapes or missing indexes warrant deeper inspection. The review process clearly indicates when EXPLAIN or EXPLAIN ANALYZE is warranted to validate query execution plans and bottlenecks.

The best way to identify N+1 patterns is to review ORM query execution in task or job surfaces that fetch related data. Analyzing query paths exposes repeated loading, enabling targeted optimizations and verified latency improvements.

Yes, you can assess pagination and index usage by reviewing the query shape and ORM loading behavior. The performance review produces evidence-backed bottlenecks and actionable recommendations to apply minimal fixes for slow database queries.