query plan
The operations a database chooses to answer a query.
Use this when A query is slow and adding indexes would be guesswork.
without the term
“This query takes eight seconds in production. Can you add some indexes or whatever to make it faster? Just don't guess, figure out what the database is actually doing.”
with the term · How do you ask a model for query plan?
Inspect this query plan on representative test data. Identify the costly operation and compare the plan after one targeted change.
What is query plan?
A query plan shows scans, joins, sorts, and estimated work. EXPLAIN ANALYZE also executes the query and measures it.
Why does query plan matter when vibe coding?
A plausible index suggestion may optimize a query the application never runs.
How do you do query plan?
Inspect a representative query and data set. Check actual rows, loops, and timing; use a safe environment for executing analysis.
What goes wrong with query plan?
EXPLAIN ANALYZE is run on a write under the assumption that it only explains.