---
name: indexes
description: Analyze database queries and recommend missing indexes with performance impact analysis
---

# Database Index Analysis

**Current Time:** !`date`
**PostgreSQL:** !`psql --version`

**Scope:** `$ARGUMENTS` (or entire codebase if not specified)

Scan whole codebase and tell me what indexes are missing.

## 📚 **DOCUMENTATION REQUIREMENTS**

**Create comprehensive database analysis documentation at:**

- `docs/tasks/backend/DD-MM-YYYY/<semantic-db-id>/`

**Documentation Structure:**

- `README.md` - Database analysis overview and objectives
- `query-analysis.md` - Detailed query performance analysis
- `index-recommendations.md` - Missing indexes and impact analysis
- `performance-metrics.md` - Before/after performance comparisons
- `implementation-plan.md` - Index creation strategy and migration plan
- `monitoring-setup.md` - Performance monitoring and alerting

**Semantic Database Task ID Examples:**

- `user-query-optimization`
- `order-performance-indexes`
- `search-query-acceleration`
- `relationship-index-analysis`
- `slow-query-investigation`

Please analyze all database queries, identify missing indexes, and document recommendations according to the standards above.

$ARGUMENTS