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)
- Exactly 18334 rows were returned
- Every row was read and filtered
- An index on
statuswas used - The rows were read in sorted order
A Seq Scan reads the whole table and applies the filter row by row; no index on
Play SQL & Databases ▸
status was used.