Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy
Top Slow Endpoints by p95 in Last 7 Days
Interviewer prompt: API owners need the highest-latency endpoints with enough traffic to matter. Return endpoint, avg_p95_ms, and total_requests for the last 7 days. Include endpoints with at least 10,000 requests. Sort by avg_p95_ms desc and return top 5.
Schema Context
endpoint_metrics(endpoint, event_time, p95_ms, request_count)