Unused indexes

  • Tune
  • Store 03

Difficulty 1 of 5

The database receives 350 reads and 3,150 writes each second. Only one of its ten indexes serves the read query. Keep p99 below 50 ms and CPU below 85 percent.

Play level

SQLUsers3,500 req/sPostgres2 vCPU · 2 GB
SQLUsers3,500 req/sPostgres2 vCPU · 2 GB
The board at the start of the level
An index against a full scanTap to add or remove the index

Index · 4 pages read per query · disk writes per insert: 2

Goals and limits

p99 latency
under 50 ms
CPU use
under 85%
Monthly cost
under 40 USD/mo
Traffic
3,500 req/s

Concepts

How players did

Player results load from the server.

All levels