ES /docs

CapturesController#index Redis cache miss causing excessive DB joins

Service
cupixworks-api
Occurrences
574
Status
Reported
Confidence
85%
Actionability
28%
Cluster ID
6ea5c685-591f-4611-8009-08c0bbdc0b80
First Seen
2026-05-26 03:47 UTC
Last Seen
2026-06-20 00:04 UTC
Datadog↗ Slack↗
Actions

CapturesController#index Redis cache miss causing excessive DB joins

What Happened#

2026-05-26 04:26~06:07 UTC 사이에 cupixworks-api의 CapturesController#index 엔드포인트에서 평균 2376ms, 최대 3527ms의 응답 지연이 8건 발생했다. us-west-2와 ap-southeast-2 두 리전에서 관측되었으며, 주요 원인은 AccessibleEntities::Cache 권한 캐시 미스 시 발생하는 다단계 permission 쿼리이다.

Quick Facts#

Field Value
resource_name Api::V1::CapturesController#index
top_frame app/repositories/capture_repository.rb:662-680
env production (us-west-2, ap-southeast-2)
avg_duration_ms 2376
max_duration_ms 3527

Affected Teams#

Team / Domain Error Count Impact
samsungenatest (us-west-2) 3 Captures 목록 조회 3.5초 이상 지연
fgip-pkg1 (us-west-2) 1 필터 없는 전체 조회 시 2890ms
varcomac (us-west-2) 1 record 필터 조회 3503ms
clark-vdc (us-west-2) 1 record 필터 조회 3524ms
endeavourgroup (ap-southeast-2) 1 지연 1074ms (상대적 경미)
multiplex-global (ap-southeast-2) 1 지연 1203ms

Timeline#

  1. 2026-05-26 04:26:38Z — 최초 발생 (ap-southeast-2)
  2. 2026-05-26 06:07:15Z — 마지막 발생 (us-west-2)
  3. 2026-05-26 — error-sweeper 감지 및 RCA 수행

Scoring#

Confidence 85% · Actionability 28%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 14 code refs, 4 log queries
Code path explicitness 3/3 14 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 9 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