The missing index

Store 02
SQLUsers0 req/sPostgres1 vCPU · 2 GB
SQLUsers0 req/sPostgres1 vCPU · 2 GB

Fix the board. Turn every goal green.

Traffic
0 req/s · up to 500 req/s · reads only
Limit
Postgres answers about 15,000 reads/s
Bill
  • Postgres8 USD/mo
8 of 50 USD/mo

Goals

Not tested yet

99 of 100 requests finish faster than this.What the servers and services cost each month.

At 0:20, a new filter starts 500 reads/s over one million rows. Each read scans the whole table. Keep p99 below 50 ms.

0:20. Database CPU jumps. Graph: rows read per filter query rise to the full 1 million rows.

An index against a full scanTap to add or remove the index

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

Parts you can add: Postgres. At most 16 parts. Budget: 50 USD/mo.

Tap a part to add it, or drag it onto a trace.Click a part to add it, or drag it onto a trace.