$ ./guess_the_languageSQL & Databases
SQL & Databases · medium · #22

What does this PostgreSQL EXPLAIN line tell you?

Seq Scan on orders  (cost=0.00..18334.00 rows=52 width=40)
  Filter: (status = 'new'::text)
  1. Exactly 18334 rows were returned
  2. Every row was read and filtered
  3. An index on status was used
  4. The rows were read in sorted order
A Seq Scan reads the whole table and applies the filter row by row; no index on status was used.
Play SQL & Databases ▸