sql-optimization-patterns

Analyze EXPLAIN output to identify SQL query bottlenecks by reviewing execution plan operations, scanning for sequential scans on large tables, and evaluating join methods. This Skill helps interpret query plans to pinpoint slow database operations and missing indexes.

The best way to optimize slow PostgreSQL queries is applying advanced indexing strategies like composite indexes, partial indexes, and specialized types such as GIN, GiST, and BRIN. This Skill guides creating effective indexes to slash query times and improve data retrieval.

Fix N+1 queries and inefficient pagination in SQL databases by applying pattern-based refactoring techniques. This Skill provides query optimization patterns to restructure data retrieval, eliminate redundant queries, and improve aggregation performance.

Use composite indexes for multi-column filtering and partial indexes for specific query subsets to achieve SQL optimization. This Skill helps determine the appropriate indexing strategy by analyzing query plans and schema design for improved application responsiveness.

Yes, you can use these SQL query tuning patterns for databases other than PostgreSQL. While the Skill focuses on PostgreSQL features like GIN and BRIN indexes, the core query plan analysis, indexing strategies, and pattern-based refactoring apply to other SQL databases.