Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
MV_ PLANCACHE
This view shows plancache information for all nodes in the cluster.
It shows all plans that are currently in SingleStore’s in-memory plancache for all nodes - plans are removed from this view, and statistics and counters are reset to zero, when the plan expires (after being unused for the setting of the engine variable plan_
), when the node restarts, or when the plan must be recompiled or reloaded (e.
Column Name |
Description |
---|---|
|
The ID of the node. |
|
Context database selected with |
|
Query text with all numeric and string parameters replaced by tags (depending on parameter and/or query type). |
|
The unique |
|
The type of query plan: interpreted or compiled. |
|
The number of successful executions of a given query. |
|
Number of unsuccessful executions of a given query (i. |
|
The cumulative number of rows returned by a |
|
The cumulative time, in milliseconds, spent executing a given query. |
|
The average execution time (in milliseconds) of a given query plan. |
|
|
|
|
|
|
|
Cumulative number of rows at the cluster level streamed from leaves and processed by a given |
|
Cumulative time, in milliseconds, at the cluster level spent waiting for results from leaves. |
|
The amount of time, in milliseconds, a given query spent queued by Workload Management. |
|
The amount of time, in milliseconds, a given query spent queued by Resource Governance. |
|
The path to the plan files on disk. |
|
The total amount of time, in milliseconds, a given query spends queued. |
|
The timestamp at which a given query was first created or loaded from disk. |
|
The timestamp at which a given query was last executed. |
|
The average amount of memory used (in bytes) to execute this query, over time. |
|
Any warnings associated with a given query plan. |
|
Additional information about the query plan, in JSON format. |
|
Information about the query plan used by the optimizer, in JSON format. |
|
The amount of CPU time, in milliseconds, spent executing the query. |
|
This is the maximum memory use (in bytes) of all of the operators used in each run, averaged across all runs of the same query plan, over time. |
|
The average amount of data (in bytes) spilt to disk during query execution. |
|
The average number (in bytes) that could not be found in the blob cache and had to be downloaded from the unlimited storage. |
|
The time (milliseconds) that were spent on waiting for blob cache data. |
|
The |
|
The values of all engine variables that affect a given query plan. |
Last modified: April 22, 2024