Optimizing Performance

What problem does it solve?

This Skill addresses slow-running PostgreSQL queries and database performance issues, ensuring your application remains responsive and efficient.

Core Features & Use Cases

• Performance Diagnosis: Utilizes EXPLAIN ANALYZE to pinpoint bottlenecks in query execution.
• Index Optimization: Guides the creation of appropriate indexes (B-tree, GIN, GiST) based on query patterns.
• Query Rewriting: Provides strategies for optimizing SQL query structure to improve performance.
• Connection Pooling: Advises on configuring connection pools for efficient database resource management.
• Monitoring: Recommends enabling slow query logs and using pg_stat_statements for ongoing performance tracking.
• Use Case: An e-commerce application experiences slow product searches. This Skill can analyze the search query, identify a missing index on the product name, suggest its creation, and confirm the performance improvement.

Quick Start

Use the Optimizing Performance skill to diagnose and fix a slow query by analyzing its EXPLAIN ANALYZE output and adding the appropriate index.