Page 5,000

Store 11
SQLUsers500 req/sPostgres1 vCPU · 2 GB
SQLUsers500 req/sPostgres1 vCPU · 2 GB

Fix the board. Turn every goal green.

Traffic
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.

Page 5,000 has 50 rows after 249,950 earlier rows. OFFSET visits all of those earlier rows on every request. Keep p99 below 100 ms.

0:00. Deep pages are slow. Graph: rows read per request grow with the page number.

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.