EditingsController#index N+1 queries via fetch_cache — cache cold overlay
Service
cupixworks-api
Occurrences
1,725
Status
Approved
Confidence
85%
Actionability
28%
Cluster ID
e22fbc1c-f3d4-41d5-b0dc-f63a7a4f14ed
First Seen
2026-05-26 03:23 UTC
Last Seen
2026-06-23 22:35 UTC
Actions
현재 상태 approved 에서는 실행할 액션이 없습니다.
EditingsController#index N+1 queries via fetch_cache — cache cold overlay
What Happened#
2026-05-27 06:04:18 UTC에 cupixworks-api 서비스의 Api::V1::EditingsController#index 엔드포인트가 1453ms 응답 시간을 기록했다. DB 시간(84ms)과 직렬화 시간(115ms)을 합쳐도 약 200ms에 불과하며, 나머지 ~1250ms는 Redis 캐시 miss 시 발생하는 N+1 fetch_cache 호출과 Elasticsearch 쿼리 오버헤드로 소요되었다.
Quick Facts#
| Field | Value |
|---|---|
| resource_name | Api::V1::EditingsController#index |
| top_frame | app/repositories/base_repository.rb:70 |
| env | production, us-west-2 |
| duration | 1453ms (DB: 84ms, Serialization: 115ms) |
| pagination | total_entries: 1589, per_page: 25, page: 1 |
Timeline#
- 2026-05-27T06:04:18Z — 클라이언트(13.124.199.63, ap-northeast-2)가
GET /api/v1/editings?editing_type=siteinsights요청 - 2026-05-27T06:04:21Z — 응답 완료 (1451ms 소요)
- 2026-05-27T06:04:18Z — error-sweeper가 latency cluster로 감지
- 2026-05-27 — RCA 분석 수행
Scoring#
Confidence 85% · Actionability 28%
Confidence#
| Dimension | Score | Detail |
|---|---|---|
| Evidence completeness | 5/5 | 16 code refs, 2 log queries |
| Code path explicitness | 3/3 | 16 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 | 24 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 |