ProblemsFTS0007

The Query Gets Slower Every Month

Medium

Problem

Paradox Shop's order-history API now takes 800 RPS, but its three application servers were sized for a much smaller launch and are already over capacity. Its 40-million-row orders table is indexed on customer_id from the last time this happened, but a newer recent-orders dashboard filters by created_at and is back to a full table scan. Scale the app tier to the real traffic, and add the index that dashboard query needs.

Required components

Click to add a component to the canvas.

Additional components

Browse by category. Click or drag a component onto the canvas.

Production Alert
App CPU is at 121%, over the 80% target.
Traffic
800 RPS
App CPU
121%
Monthly cost
$720

Drag components from the library onto the canvas, then drag from a component's right handle to connect it to another.

100%

Design canvas

Sign up to start designing

Sign up free

Premium is free for 58 more days.

$0 / $1,200