ElementTracesController#index N+1 Redis lookups — missing eager loads
Service
cupixworks-api
Occurrences
280
Status
Reported
Confidence
85%
Actionability
28%
Cluster ID
0bf4e621-ae8a-42f6-ac06-dee17149ee99
First Seen
2026-05-26 03:21 UTC
Last Seen
2026-06-19 22:29 UTC
Actions
ElementTracesController#index N+1 Redis lookups — missing eager loads
What Happened#
2026-05-26 03:21~06:09 UTC 동안 Api::V1::ElementTracesController#index 엔드포인트에서 평균 1282ms, 최대 1934ms의 응답 지연이 4개 리전(us-west-2, ap-southeast-1, ap-northeast-1, ap-southeast-2)에 걸쳐 46건 발생했다. DB 처리 시간은 평균 14ms(전체의 1.5%)에 불과하며, 나머지 98.5%의 지연은 application layer에서 발생한다.
Quick Facts#
| Field | Value |
|---|---|
| resource_name | Api::V1::ElementTracesController#index |
| top_frame | app/repositories/base_repository.rb:70-112 |
| env | production (us-west-2, ap-southeast-1, ap-northeast-1, ap-southeast-2) |
Timeline#
- 2026-05-26T03:21:20Z — 최초 slow request 감지 (ap-southeast-2)
- 2026-05-26T06:09:01Z — 마지막 slow request 기록
- 2026-05-26 — RCA 분석 완료
Scoring#
Confidence 85% · Actionability 28%
Confidence#
| Dimension | Score | Detail |
|---|---|---|
| Evidence completeness | 5/5 | 17 code refs, 2 log queries |
| Code path explicitness | 3/3 | 17 file:line refs |
| Log evidence | 3/3 | section, query, pattern |
| RCA structure | 3/3 | 3/3 sections |
| Revision history | 0/3 | 0 revision(s) |
| Agent execution | 3/3 | success |
Actionability#
| Dimension | Score | Detail |
|---|---|---|
| Fix complexity | 1/5 | critical |
| Affected files | 1/5 | 15 file(s) |
| Single repo | 1/3 | 2 service(s) |
| Immediate actions | 0/3 | absent |
| Testability | 0/3 | no test info |
| External dependency | 1/3 | external deps found |
| Data migration | 3/3 | no migration |