Explain query
explain_queryShow a SELECT query's execution plan without running it, then use analyze for measured timings to identify performance bottlenecks before executing on large tables.
Instructions
Show the query plan for a SELECT without running it. Pass analyze: true to execute it and get measured timings instead of estimates. Use this to tune a query before running it against a large table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single SELECT or WITH statement. | |
| analyze | No | Run the query to collect real timings. Off by default. |