PostgreSQL Optimization Workflow

Overview

Specialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration.

When to Use This Workflow

Use this workflow when:

• Optimizing slow PostgreSQL queries
• Designing indexing strategies
• Analyzing database performance
• Tuning PostgreSQL configuration
• Managing production databases

Workflow Phases

Phase 1: Performance Assessment

Skills to Invoke

• database-optimizer - Database optimization
• postgres-best-practices - PostgreSQL best practices

Actions

1. Check database version
2. Review configuration
3. Analyze slow queries
4. Check resource usage
5. Identify bottlenecks

Copy-Paste Prompts

Use @database-optimizer to assess PostgreSQL performance

Phase 2: Query Analysis

Skills to Invoke

• sql-optimization-patterns - SQL optimization
• postgres-best-practices - PostgreSQL patterns

Actions

1. Run EXPLAIN ANALYZE
2. Identify scan types
3. Check join strategies
4. Analyze execution time
5. Find optimization opportunities

Copy-Paste Prompts

Use @sql-optimization-patterns to analyze and optimize queries

Phase 3: Indexing Strategy

Skills to Invoke

• database-design - Index design
• postgresql - PostgreSQL indexing