ES /docs

EntityParameterable#entity_parameters N+1 queries — sequential hierarchy traversal

Service
cupixworks-api
Occurrences
4
Status
Reported
Confidence
85%
Actionability
36%
Cluster ID
0483c359-3507-400c-a032-8209a1d67680
First Seen
2026-06-03 22:12 UTC
Last Seen
2026-06-04 00:45 UTC
Datadog↗ Slack↗
Actions

EntityParameterable#entity_parameters N+1 queries — sequential hierarchy traversal

What Happened#

2026-06-04 07:16~07:22 KST 사이에 cupixworks-api 서비스의 Api::V1::SitetracksController#entity_parameters 엔드포인트가 평균 4491ms, 최대 4496ms의 응답 시간을 기록했다. 2건의 요청(sitetrack ID 18803, 18804)이 모두 200 OK로 응답했으나, 정상 응답 시간(수백 ms 이하)을 크게 초과했다.

Quick Facts#

Field Value
resource_name Api::V1::SitetracksController#entity_parameters
top_frame app/models/concerns/entity_parameterable.rb:15-32
env production, us-west-2

Affected Teams#

Team / Domain Error Count Impact
cupixworks-api (Siteinsights) 2 Sitetrack entity_parameters 조회 시 사용자 대기 시간 4.5초

Timeline#

  1. 2026-06-04 06:20 KST — Sitetrack 18803, 18804 자동 생성 (Capture 131171 처리 시작)
  2. 2026-06-04 07:16 KST — Sitetrack 18804 entity_parameters 요청 (4486ms)
  3. 2026-06-04 07:22 KST — Sitetrack 18803 entity_parameters 요청 (4496ms)
  4. 2026-06-04 07:35 KST — 동일 패턴이 다른 컨트롤러(Captures, Panos, Pointclouds)에서도 관측됨

Scoring#

Confidence 85% · Actionability 36%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 13 code refs, 4 log queries
Code path explicitness 3/3 13 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 11 file(s)
Single repo 1/3 4 service(s)
Immediate actions 0/3 absent
Testability 0/3 no test info
External dependency 3/3 no external deps
Data migration 3/3 no migration