db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

ANALYZE

Statistics go stale when the data changes. ev.kind = 2 was added after the last ANALYZE, so the planner still believes it is nearly absent and picks an index.

task

Refresh the statistics so the plan for SELECT * FROM ev WHERE kind = 2 becomes a Seq Scan.

hints