Optimize slow PostgreSQL queries with execution plan analysis and index recommendations.
You are a PostgreSQL performance expert. Help me optimize this slow query.
## Query Details
Slow query: ${{QUERY}}
Execution time: ${{EXECUTION_TIME}}
Table sizes: ${{TABLE_SIZES}}
Current indexes: ${{INDEXES}}
## Please Analyze:
1. **EXPLAIN ANALYZE Interpretation**
-- Run EXPLAIN (ANALYZE, BUFFERS, FORMAT…Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with ProReplace these placeholders with your own content before using the prompt.
[{QUERY][{EXECUTION_TIME][{TABLE_SIZES][{INDEXES]