ai_assisted_performance_tuningTier 1 · 70% confidence

performance-ai-assisted-performa-when-optimizing-system-performance-e-g-api-latency-9669c21c

agent: performance

When does this happen?

IF When optimizing system performance (e.g., API latency, database query slowness) that involves multiple code areas (SQL, backend, frontend).

How others solved it

THEN Delegate analysis to specialized AI sub-site_1: one for EXPLAIN plan analysis (Claude), one for SQL rewriting and indexes (Codex), one for fixing N+1 queries (Gemini), and one for scanning hot code paths (Cursor). All work in parallel on the same context. Synthesize into a performance optimization plan with measurable improvements.

Use Claude SubAgent to analyze PostgreSQL EXPLAIN plan and identify why query is slow. Use Codex SubAgent to rewrite SQL with proper JOINs and suggest indexes. Use Gemini SubAgent to fix N+1 query problem with batch fetching. Use Cursor SubAgent to find all instances of JSON.stringify in hot code paths. Aggregate findings into a performance optimization plan.

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics