Partition pruning

  • Fix
  • Flow 08

Difficulty 3 of 5

A page-view table holds 1 billion rows from two years. The dashboard asks for yesterday's totals twice each second, and each query takes 30 s. Bring dashboard p99 below 2 s, keep writes below 100 ms, stay under 40 USD/mo, and use at most 2 edits.

09:05. Dashboard queries time out at 60 s. The page-view store reads 4,000 MB/s from a 500 MB/s disk.

Play level

HTTP/2HTTP/2Users3,000 req/sUsers2 req/sWide-column…4 vCPU · 4 GB
HTTP/2HTTP/2Users3,000 req/sUsers2 req/sWide-colu…4 vCPU · 4 GB
The board at the start of the level
Keys on a hash ringArrow keys add or remove a node. Tap to switch the hash.

Hash ring · 3 to 4 nodes · 8 of 36 keys move

Goals and limits

p99 latency (Dash)
under 2 s
p99 latency (Views)
under 100 ms
Error rate (*)
under 0.1%
Monthly cost
under 40 USD/mo
Edit limit
2
Traffic
2 req/s

Concepts

How players did

Player results load from the server.

All levels