Investigate performance degradation in GET /api/v4/projects endpoint

Problem Statement

The GET /api/v4/projects endpoint is experiencing performance degradation, falling short of the target Apdex score for the Group Organizations component. As the 7th most used grouporganizations endpoint, this degradation impacts a significant portion of our user base.

Current Performance Metrics

Metric	Current Value	Target	Gap
GET /api/v4/projects Apdex	95.38%	-	-
Rails request Apdex	99.61%	99.95%	-0.34%
API Usage Rank	7th most used	-	-

Monitoring Period: 2025-09-22 to 2025-10-20
Dashboard: SLI violation dashboard (internal)

Impact

• User Impact: Performance degradation affects API consumers relying on project listings
• Business Impact: As a highly utilized endpoint, degraded performance impacts overall platform reliability
• SLI Compliance: Currently not meeting the 99.95% target for Group Organizations

Objective

Investigate and identify the root cause of performance degradation in the /api/v4/projects endpoint and propose solutions to improve its performance metrics.

Success Criteria

• Identify factors contributing to the performance degradation
• Document findings and potential bottlenecks
• Propose actionable solutions to bridge the gap between current (99.61%) and target (99.95%) baseline Apdex scores

---

Description was generated using AI