The latest payments

The finance screen shows the ten latest payments. There are a hundred and twenty thousand payments, and all of them are sorted for the sake of ten rows. Remove the sort from the plan.

Speed this query up with an index

SELECT * FROM payments ORDER BY created_at DESC LIMIT 10

Solution requirement

Just CREATE/ALTER/DROP — no trailing SELECT needed.

What counts as solved

You may only change the schema: indexes and ANALYZE. The query stays as the task wrote it — no need to send it back.

the plan has no Sort
the plan has no Seq Scan on payments
the query reads at most 12 8 KB pages

Grading runs on a larger dataset than the samples show — the answer has to hold at scale.

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid