postgres-expert

What problem does it solve?

This Skill addresses the challenges of optimizing PostgreSQL database performance, ensuring efficient query execution, effective indexing, and sound database administration practices.

Core Features & Use Cases

• Query Optimization: Analyzes query plans and suggests improvements for speed and resource usage.
• Indexing Strategies: Recommends appropriate index types (B-tree, GIN, GiST, BRIN) and creation methods (covering, partial) based on access patterns.
• Schema Design: Guides on normalization and denormalization trade-offs for performance.
• Database Administration: Provides advice on vacuuming, analyzing, and managing connections.
• Use Case: A developer struggling with slow-running reports can use this Skill to identify bottlenecks and implement optimized queries and indexes.

Quick Start

Analyze the query plan for the following SQL statement: EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM users WHERE created_at > '2023-01-01';