From argos
Yavaş query, index, lock, connection ve migration performans teşhisi.
npx claudepluginhub resultakak/argos --plugin argosThis skill uses the workspace's default tool permissions.
`agents/shared/severity-rubric.md` ve `agents/shared/escalation-matrix.md` default-load
Mandates invoking relevant skills via tools before any response in coding sessions. Covers access, priorities, and adaptations for Claude Code, Copilot CLI, Gemini CLI.
Share bugs, ideas, or general feedback.
agents/shared/severity-rubric.md ve agents/shared/escalation-matrix.md default-load
sayılır (agents/coordination.md §11). Bu skill'in çıktısı Critical / High / Medium /
Low + kanıt formatında olmak zorunda — spekülatif Critical yasak. Sahiplik dışı bulgu
ilgili agent'a delege; karar yetkisi eşiği aşılırsa kullanıcı onayı zorunlu.
database-optimizer — ORM N+1 için backend-reviewer'a delege.
pg_stat_statements top: total_exec_time, calls, mean_exec_timepg_stat_activity: active query, wait_eventpg_locks join pg_stat_activity -> blocker tespitpg_stat_user_indexes: idx_scan = 0 olanlar (kullanılmayan index)pg_stat_user_tables: seq_scan vs idx_scan oranıEXPLAIN (ANALYZE, BUFFERS, VERBOSE) <query>ANALYZE <table> veya default_statistics_targetCREATE INDEX CONCURRENTLY (lock değil)ALTER TABLE ADD COLUMN NULL + backfill batch + SET NOT NULLlock_timeout set + retrylog_min_duration_statement)EXPLAIN ANALYZE plan kanıtıpg_stat_user_indexes)SELECT * prod kodWHERE LOWER(col) = $1 index'sizWHERE date_trunc('day', x) = ...) — expression index yoksaIN (subquery) çok büyük sub -> JOIN tercihALTER TABLE ADD COLUMN NOT NULL DEFAULT ... büyük tabloda (lock tüm tablo, eski PG'de rewrite)User: /orders endpoint p99 1.2s
Agent:
1. pg_stat_statements top 5 -> ORDER BY mean_exec_time
2. SELECT ... FROM orders JOIN users ON ... WHERE u.email = $1
3. EXPLAIN ANALYZE -> Seq Scan on users (2.1M rows)
4. \d users -> email kolonunda index yok
5. Çözüm: CREATE INDEX CONCURRENTLY ix_users_email ON users (email);
6. Build süresi ~30s tahmin, lock yok
7. Onay, çalıştır, query yeniden ölç -> 12ms
# Postgres Perf: <query/feature>
## Plan Özeti
## Bottleneck
## Önerilen index/rewrite
## Beklenen kazanım
## Risk