Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

MV_ACTIVITIES_EXTENDED_CUMULATIVE

This view provides a detailed profile of completed and currently running tasks on all nodes of the cluster.

It holds a row per activity. Each row describes completed and currently running instances of its activity. It reports the sum of the profiling statistics of each instance, as collected over its lifetime. Activities can include tasks such as garbage collection and backups, in addition to queries.

MV_ACTIVITIES_EXTENDED_CUMULATIVE may only be queried while connected to an aggregator node.

Be aware when using this view that it does not fully describe past system behavior because it does not include all completed instances. This is because historical task statistics may be discarded by SingleStore Helios at unspecified times.

Column name

Description

NODE_ID

An ID equal to id in the row of mv_nodes describing the node on which the activity’s instances have run.

ACTIVITY_TYPE

The type of the activity.

ACTIVITY_NAME

An ID shared by all instances of the activity. This ID is often human-readable, but does not include the query text for query tasks. See mv_queries.

AGGREGATOR_ACTIVITY_NAME

The aggregator_activity_name of the activity.

DATABASE_NAME

The name of the database associated with the activity, or NULL if none could be assigned.

ACTIVITY_TRACKING_ID

An ID that can be used to identify the activities associated with a session. Configure the activity_tracking_id session engine variable to specify an ID for all the activities associated with the queries run in the current session.

In the case of pipeline queries, this value is set automatically in the following way:

  • If the queries are directly run by the pipeline, their activity_tracking_id is PI_<PIPELINE_ID>.

  • If the pipeline calls a stored procedure, the activity_tracking_id of the queries run by this stored procedure is set as PR_PI_<PIPELINE_ID>.

PARTITION_ID

The unique ID of the database partition associated with the activity, or NULL if none could be assigned.

LAST_FINISHED_TIMESTAMP

The timestamp of the most recent completion of an instance of this activity.

RUN_COUNT

The number of running instances of this activity.

SUCCESS_COUNT

The number of successfully completed instances of this activity.

FAILURE_COUNT

The number of unsuccessfully completed instances of this activity.

EXTENDED_STATISTICS

This view contains all extended statistics columns, including: cpu_time_ms, cpu_wait_time_ms, disk_logical_read_b, disk_logical_write_b, disk_physical_read_b, disk_physical_write_b, disk_time_ms, elapsed_time_ms, lock_row_time_ms, lock_time_ms, log_buffer_b, log_buffer_time_ms, log_flush_time_ms, memory_bs, memory_major_faults, network_logical_recv_b, network_logical_send_b, and network_time_ms.

Last modified:

Was this article helpful?