explainQuery
explainQueryRetrieve the full engine-specific execution plan for a SELECT or WITH query to inspect raw database planner details. Use when you need granular plan output rather than compact performance analysis.
Instructions
Return the full engine-specific textual execution plan for a SELECT / WITH statement. Use when raw plan detail is needed; prefer analyzePlan for compact performance findings. Bind '?'->params, ':name'->namedParams; never mix. E.g. :status -> namedParams={status:'PAID'} — key is the bare name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| params | No | Values for '?' placeholders, in order. | |
| analyze | No | Execute the query to collect runtime stats where supported (default false). | |
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namedParams | No | Values for ':name' placeholders, keyed by name. |