sas_history_lookup
Check whether SAS-issued SQL appears in SingleStore's plan cache or local query history, returning plan-cache details when the statement is absent from history.
Instructions
Is this SQL (sent to SingleStore by SAS) in the cluster's plan cache or the local query history?
``plan``: the plan cache entry as a Query History plan-cache row (``key`` "plan:…", totals, parameterized
text), so the editor can open Query History on it when the statement isn't in its list (runs under the
trace threshold of 1 s only show in the plan cache).Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| database | No |