sql-optimization-patterns

To fix slow query performance, this Skill analyzes PostgreSQL EXPLAIN plans to identify execution bottlenecks like sequential scans. It then recommends specific query rewriting and indexing strategies to reduce load times.

Use B-Tree indexes for standard equality and range queries, and GIN or GiST indexes for composite data types. This Skill guides you in implementing effective indexing strategies based on your specific query patterns.

Eliminate N+1 queries by applying proven optimization patterns like eager loading and efficient aggregation. This Skill helps you master query rewriting techniques to batch database requests and slash query times.

Implement cursor-based pagination to replace slow OFFSET queries. This Skill teaches proven optimization patterns for efficient SQL pagination that maintains fast database response times on large datasets.

Yes, this Skill addresses database schema design and application performance tuning scenarios. It requires understanding of PostgreSQL indexing and query rewriting techniques to optimize SQL performance effectively.

Slow query performance despite indexes often stems from inefficient execution plans or missing composite indexes. This Skill analyzes your EXPLAIN plan to identify bottlenecks and applies proven optimization patterns to resolve them.