postgres-optimization

What problem does it solve?

This Skill helps users improve the performance of their PostgreSQL databases by providing guidance on query optimization, indexing strategies, and schema design.

Core Features & Use Cases

• Query Analysis: Understand EXPLAIN ANALYZE output to identify performance bottlenecks.
• Indexing: Create appropriate indexes (simple, composite, partial, JSONB GIN) to speed up data retrieval.
• Partitioning: Implement table partitioning for better manageability and performance on large datasets.
• JSONB Operations: Efficiently query and manage JSONB data types.
• Use Case: A developer is experiencing slow query times on a large orders table. They can use this Skill to analyze their query with EXPLAIN ANALYZE, identify missing indexes, and create them, or consider partitioning the table by date.

Quick Start

Use the postgres-optimization skill to create a composite index on the orders table for user_id and status.