MV_ QUERY_ ACTIVITIES
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 high-level summary profile of all the queries that ran recently in the cluster.
Each row describes a query sent to the cluster, as well as queries sent between nodes.
Column name |
Description |
---|---|
|
An ID shared by all instances of the activity. |
|
The de-parameterized text of the query. |
|
The name of the database associated with the query, or |
|
Milliseconds spent running on a CPU. |
|
Milliseconds spent waiting for a CPU to become available. |
|
Wall clock milliseconds elapsed during execution. |
|
Milliseconds spent waiting on locks and condition variables, excluding row locks. |
|
Milliseconds spent waiting for physical disk I/O to complete. |
|
Milliseconds spent waiting for sockets to be ready to send or receive data. |
|
Number of bytes SingleStore sent and received to sockets. |
|
Number of bytes that SingleStore read and wrote to the filesystem or the in memory transaction log. |
|
|
|
Number of page faults which required disk I/O to resolve. |
|
The number of instances which were running at the end of the interval (where the workload profile was taken). |
|
The number of instances which completed successfully during the interval (where the workload profile was taken). |
|
The number of instances which completed unsuccessfully during the interval (where the workload profile was taken). |
|
The number of warnings generated during query execution. |
|
A high-level information of the plan. |
Last modified: June 1, 2023