SQL Arena

Последние платежи

Последние платежи

Финансовый экран показывает десять последних платежей. Платежей сто двадцать тысяч, и все они сортируются ради десяти строк. Уберите сортировку из плана.

Speed this query up with an index
SELECT * FROM payments ORDER BY created_at DESC LIMIT 10

Apenas CREATE/ALTER/DROP — não é preciso um SELECT no final.

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
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid