postgres-query-optimization

PostgreSQL query optimization uses EXPLAIN ANALYZE to expose execution plan bottlenecks like sequential scans and N+1 patterns. This skill interprets those results to pinpoint performance issues such as large scans and slow joins, guiding targeted query optimization.

Index design for PostgreSQL performance tuning requires matching index strategies to specific query patterns. This skill provides concrete index suggestions based on your execution plans, helping eliminate large scans and resolve slow joins in production databases.

Fixing N+1 queries and slow joins in PostgreSQL requires query rewrites and proper indexing. This skill analyzes your execution plans to provide concrete query rewrite recommendations that eliminate these common performance bottlenecks.

Production database troubleshooting and configuration tuning are supported through practical checklists and best practices. This skill delivers concrete configuration tuning steps alongside index suggestions and query rewrites based on EXPLAIN ANALYZE results.

You should avoid adding indexes when query rewrites or configuration tuning can resolve the bottleneck instead. This skill weighs index design against query rewrite recommendations, ensuring you apply the correct optimization strategy for your specific execution plan.