MV_PLANCACHE
This view shows plancache information for all nodes in the workspace.
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.e. cases where query was aborted or encountered runtime errors). |
| 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 workspace level streamed from leaves and processed by a given |
| Cumulative time, in milliseconds, at the workspace level spent waiting for results from leaves. This includes the time spent executing queries on the 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 last executed. |
| The average amount of memory used (in bytes) to execute this query, over time. Any temporary memory allocation needed to execute a query (including those for hash tables, sorts, result tables, etc.) is tracked here. |
| 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 |
| The values of all engine variables that affect a given query plan. |
| The average amount of data (in bytes) spilt to disk during query execution. |
| The timestamp at which a given query was first created or loaded from disk. |