Click MemSQL → Workloads to view the list of queries. By default, queries that completed execution over the past 24 hours are displayed.
The following metrics are displayed for each query.
|Query||The statement of the query. Click to copy the query onto the clipboard.|
|Duration||The time taken for the query to run.|
|Status||The status of the query, whether succeeded, or failed.|
|CPU Time||The total time the query ran on the CPU.|
|CPU Wait Time||The time spent waiting for the CPU to become available|
|Disk Time||The time spent waiting for physical disk I/O to complete.|
|Lock Row Time||The time spent waiting on row locks.|
|Lock Time||The time spent waiting on locks and condition variables, excluding row locks.|
|Network Time||The time spent waiting for sockets to be ready to send or receive data.|
|Memory||The amount of memory used, in byte-seconds.|
|Finished Time||The time at which the query finished executing. The time is displayed in Date:Time format and is the local time of the server on which the query was run.|
Click the Download button to download workloads information. Information of the earliest 10 queries is downloaded as a .xlsx file.
Advanced Search Options
The search field in the MemSQL Workloads Page supports Influx-like query statements. For example, if you want to search for a query, use the format parametername:value. However, you need to know the full name of the parameter to be able to use it. For example, the name of the parameter visible in the UI is CPU Time. However, internally, the parameter name is cpu_time_ms. Hence, if you want to search for queries with CPU Time = 1, you need to type cpu_time_ms:1.
MemSQL Workload Details
Click a query to view its details in the Workload Details page. The Workload Details page displays the SQL query and its execution metrics.
Click to copy the query onto the clipboard.
The query execution metrics are categorized into the following groups - Query execution metrics, Memory, and Network.
|Metric Type||Metric Name||Description|
|Query execution||CPU time||The time spent running by the query on the CPU, in milliseconds.|
|CPU wait time||The time spent in waiting for a CPU to become available, in milliseconds.|
|Disk time||The time spent waiting for physical disk I/O to complete, in milliseconds.|
|Lock row time||The time spent in waiting on table row locks, in milliseconds.|
|Lock time||The time spent waiting on locks and condition variables, excluding row locks. The time is displayed in milliseconds.|
|Log buffer time||The time spent waiting for space in the transaction log buffer, in milliseconds.|
|Log flush time||The time spent waiting for transaction log records to be flushed to disk, in milliseconds.|
|Network time||The time spent waiting for sockets to be ready to send or receive data, in milliseconds.|
|Memory||Disk Logical Read||The number of bytes read from the filesystem.|
|Disk Logical Write||The number of bytes written to the filesystem.|
|Disk Physical Read||The number of bytes actually read from the disk.|
|Disk Physical Write||The number of bytes actually written to the disk.|
|Network Metrics||Network Logical Send||The number of bytes written to a socket.|
|Network Logical Received||The number of bytes received from a socket.|