antrophiclove
← Kütüphaneye dön
Kurulum
mkdir -p .claude/commands && curl -sL https://www.antrophiclove.com/api/kaynak/analyze-query/raw -o .claude/commands/analyze-query.md

Hedef dosya: .claude/commands/analyze-query.md

ÖnizlemeHam metin⑂ Kendi sürümünü oluştur
Analyze database queries for performance issues using EXPLAIN plans and query patterns.

## Steps


1. Identify the slow or problematic query:
2. Run EXPLAIN (or EXPLAIN ANALYZE) on the query:
3. Analyze common performance issues:
4. Check for lock contention:
5. Suggest optimizations:
6. Estimate improvement from each suggestion.

## Format


```
Query: <simplified query>
Current Time: <execution time>
Issues Found:
  - <issue>: <impact>
```


## Rules

- Always use EXPLAIN ANALYZE for real execution statistics.
- Consider the query frequency when prioritizing optimizations.
- Test optimizations on a staging environment first.