MV_ ACTIVITIES_ EXTENDED
This view provides a detailed profile of all tasks which ran recently on any node in the cluster.
It holds a row per activity.
mv_
determines recent resource use by computing the change in mv_
over an interval of time.activities_
session variable.
mv_
may only be queried while connected to an aggregator node.
SingleStore recommends using this view to get fine-grained understanding of the system behavior described in mv_
.mv_
and mv_
are:
-
For most queries,
mv_
will report the resource usage of the query with at least a row per partition.activities_ extended -
mv_
aggregates these into a single row per query.activities -
mv_
reports simplified statistics, whileactivities mv_
reports extended statistics.activities_ extended
However, SingleStore recommends against the use of mv_
to compute the average latency or resource usage of a query.mv_
for this purpose instead.
Column name |
Description |
---|---|
|
An |
|
The type of the activity. |
|
The name of the activity. |
|
The aggregator activity name of the activity. |
|
The name of the database associated with the activity, or |
|
The unique ID of the database partition associated with the activity, or |
|
The number of instances which were running at the end of the interval. |
|
The number of instances which completed successfully during the interval. |
|
The number of instances which completed unsuccessfully during the interval. |
This view contains all extended statistics columns. |
Last modified: March 8, 2024