CaptureRepository#show N+1 query — DB contention
Service
cupixworks-api
Occurrences
12
Status
Reported
Confidence
85%
Actionability
28%
Cluster ID
b77e9f75-6878-4610-b4ed-b245a3bf7f5a
First Seen
2026-06-01 12:59 UTC
Last Seen
2026-06-19 19:46 UTC
Datadog
SlackActions
CaptureRepository#show N+1 query — DB contention
What Happened#
2026-06-04 09:46 KST에 cupixworks-api 서비스의 Api::V1::CapturesController#download_multiple_resource 엔드포인트에서 3100ms의 응답 지연이 발생했다. 해당 요청은 capture 707591의 processing_options 리소스 다운로드였으며, 동시에 해당 capture의 preprocessor 처리 완료 및 skat master 호출이 진행되는 high-load 시점에 발생했다.
Quick Facts#
| Field | Value |
|---|---|
| resource_name | Api::V1::CapturesController#download_multiple_resource |
| top_frame | app/controllers/concerns/multiple_resourcable_controller.rb:20 |
| env | production, us-west-2 |
| avg_duration | 3100ms |
| max_duration | 3100ms |
Timeline#
- 2026-06-04 09:46:10 KST —
download_multiple_resource요청 발생 (3100ms latency, APM trace 3203445943561624117) - 2026-06-04 09:46:14 KST —
[302] GET /api/v1/captures/707591/resources/processing_options/download완료 로그 기록 - 2026-06-04 09:46:54 KST — 동일 capture 707591에 대해 preprocessor_agent_finished, CreateCaptureJob, skat master 호출 등 대량 처리 작업 동시 진행
Scoring#
Confidence 85% · Actionability 28%
Confidence#
| Dimension | Score | Detail |
|---|---|---|
| Evidence completeness | 5/5 | 11 code refs, 4 log queries |
| Code path explicitness | 3/3 | 11 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 | 19 file(s) |
| Single repo | 1/3 | 3 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 |