MV_ ACTIVITIES_ EXTENDED
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.
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, including: |
Last modified: October 18, 2024