MV_FINISHED_TASKS
This view provides a detailed profile of completed tasks on all nodes of the workspace.
It holds a row per activity. Each row describes completed instances of its activity. It reports the sum of the profiling statistics of each instance, as collected over its lifetime.
mv_finished_tasks
may only be queried while connected to an aggregator node.
We recommend against extensive use of this view. It doesn’t accurately describe past system behavior because it doesn’t include all completed instances. It will also hide the performance impact of long-running tasks which have yet to complete.
However, we do recommend using this view to estimate the average latency or resource usage of a query. This is because all other statistics tables include currently running tasks in their profiles, skewing attempted average calculations.
Column name | Description |
---|---|
| An ID equal to |
| The |
| An ID shared by all instances of the activity. This ID is often human-readable, but does not include the query text for query tasks. Join with |
| The |
| The name of the database associated with the activity, or |
| The unique ID of the database partition associated with the activity, or |
| The timestamp of the most recent completion of an instance of the activity. |
| The number of successfully completed instances of this activity. |
| The number of unsuccessfully completed instances of this activity. |
This view contains all extended statistics columns. |