返回 Skill 列表
extension
分类: 开发与工程无需 API Key

plain-optimize

捕获并分析性能跟踪以识别慢查询和N+1问题。在分析性能或优化数据库查询时使用。

person作者: jakexiaohubgithub

Performance Optimization Workflow

1. Capture Traces

Make a request with tracing enabled:

uv run plain request /path --user 1 --header "Observer: persist"

2. Find Traces

uv run plain observer traces --request-id <request-id>

3. Analyze Trace

uv run plain observer trace <trace-id> --json

4. Identify Bottlenecks

Look for:

  • N+1 queries (many similar queries)
  • Slow database queries
  • Missing indexes
  • Unnecessary work in hot paths

5. Apply Fixes

  • Add select_related() / prefetch_related() for N+1
  • Add database indexes for slow queries
  • Cache expensive computations

6. Verify Improvement

Re-run the trace and compare.