db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

ANALYZE

EXPLAIN (ANALYZE) runs the query and adds what really happened: actual rows and actual time per node. Compare actual rows with the estimate to spot a bad plan.

task

Run EXPLAIN (ANALYZE) on SELECT * FROM orders WHERE status = 'new', then return the actual row count of its top node.

hints