MemSQL Workloads

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.

MetricDescription
QueryThe statement of the query. Click Copy to copy the query onto the clipboard.
DurationThe time taken for the query to run.
StatusThe status of the query, whether succeeded, or failed.
CPU TimeThe total time the query ran on the CPU.
CPU Wait TimeThe time spent waiting for the CPU to become available
Disk TimeThe time spent waiting for physical disk I/O to complete.
Lock Row TimeThe time spent waiting on row locks.
Lock TimeThe time spent waiting on locks and condition variables, excluding row locks.
Network TimeThe time spent waiting for sockets to be ready to send or receive data.
MemoryThe amount of memory used, in byte-seconds.
Finished TimeThe 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 Download 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 copy to copy the query onto the clipboard.

The query execution metrics are categorized into the following groups - Query execution metrics, Memory, and Network.

Metric TypeMetric NameDescription
Query executionCPU timeThe time spent running by the query on the CPU, in milliseconds.
CPU wait timeThe time spent in waiting for a CPU to become available, in milliseconds.
Disk timeThe time spent waiting for physical disk I/O to complete, in milliseconds.
Lock row timeThe time spent in waiting on table row locks, in milliseconds.
Lock timeThe time spent waiting on locks and condition variables, excluding row locks. The time is displayed in milliseconds.
Log buffer timeThe time spent waiting for space in the transaction log buffer, in milliseconds.
Log flush timeThe time spent waiting for transaction log records to be flushed to disk, in milliseconds.
Network timeThe time spent waiting for sockets to be ready to send or receive data, in milliseconds.
MemoryDisk Logical ReadThe number of bytes read from the filesystem.
Disk Logical WriteThe number of bytes written to the filesystem.
Disk Physical ReadThe number of bytes actually read from the disk.
Disk Physical WriteThe number of bytes actually written to the disk.
Network MetricsNetwork Logical SendThe number of bytes written to a socket.
Network Logical ReceivedThe number of bytes received from a socket.