ES /docs

RecordsController#index permission_joins — inefficient multi-layer JOIN query

Service
cupixworks-api
Occurrences
505
Status
Reported
Confidence
80%
Actionability
28%
Cluster ID
657331ee-e8d5-494a-ad33-ee1e72f27e1c
First Seen
2026-05-26 03:28 UTC
Last Seen
2026-07-16 05:33 UTC
Datadog↗ Slack↗
Actions

RecordsController#index permission_joins — inefficient multi-layer JOIN query

What Happened#

2026-05-26 03:28~06:06 UTC 사이에 cupixworks-api 서비스의 Api::V1::RecordsController#index 엔드포인트에서 평균 1690ms, 최대 2628ms의 응답 지연이 us-west-2, ap-southeast-2, eu-central-1 리전에서 19건 감지되었다. DB 쿼리 시간이 전체 응답의 58%를 차지하며, 결과 건수와 무관하게 1100-1500ms의 고정 DB 오버헤드가 관찰된다.

Quick Facts#

Field Value
resource_name Api::V1::RecordsController#index
top_frame app/repositories/record_repository.rb:143-355
env production (us-west-2, ap-southeast-2, eu-central-1)

Affected Teams#

Team / Domain Error Count Impact
pclconstruction 3 456건 record 조회 시 2200ms+ 지연
gad 2 219건 record 조회 시 2630ms 지연
smacon 2 20건 record 조회에도 2200ms+ 지연
ellisdon 1 535건 record 조회 시 2230ms 지연
varcomac 1 20건 record 조회에도 1900ms 지연
okland 2 6-8건 record 조회에도 1800ms 지연

Timeline#

  1. 2026-05-26T03:28:00Z — 최초 감지 (us-west-2, pclconstruction team, 2797ms)
  2. 2026-05-26T05:44:02Z — 동시간대 ActiveRecord::Deadlocked 발생 (EditingsController#update)
  3. 2026-05-26T06:06:15Z — 마지막 감지

Scoring#

Confidence 80% · Actionability 28%

Confidence#

Dimension Score Detail
Evidence completeness 5/5 8 code refs, 4 log queries
Code path explicitness 3/3 8 file:line refs
Log evidence 2/3 section, query
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 10 file(s)
Single repo 1/3 4 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