Unused indexes

Store 03
SQLUsers3,500 req/sPostgres2 vCPU · 2 GB
SQLUsers3,500 req/sPostgres2 vCPU · 2 GB

Tune the parts. Turn every goal green.

Traffic
3,500 req/s · 10% reads
Limit
Postgres answers about 5,000 writes/s
Bill
  • Postgres8 USD/mo
8 of 40 USD/mo

Goals

Not tested yet

99 of 100 requests finish faster than this.How busy the busiest CPU is. Keep room for spikes.What the servers and services cost each month.

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.

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

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