Databases

Make slow queries fast, and know why they were slow

How a database stores rows, finds them through indexes, plans a query and keeps transactions apart. Every example runs on a real PostgreSQL in your browser, against a sample shop with 100,000 orders, and every plan shown on these pages came from a real run.

New and still in draft: the pages say so until someone other than the author has reviewed them.

Start here

How data is stored and found

Reading query plans

Writing faster SQL

Concurrency

Scaling a table

Practice

Esc
↑ ↓ to move↵ to open