# 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 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:<ul> <li>If the queries are directly run by the pipeline, their <code>activity_tracking_id</code> is <code>PI_&#x3C;PIPELINE_ID></code>.</li> <li>If the pipeline calls a stored procedure, the <code>activity_tracking_id</code> of the queries run by this stored procedure is set as <code>PR_PI_&#x3C;PIPELINE_ID></code>.</li> </ul> |
| `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](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/management-statistics-reference/#extended-statistics.md) | 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`.                                                                                                                                                                                                                                       |

***

Modified at: March 5, 2026

Source: [/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities-extended-cumulative/](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities-extended-cumulative/)

(An index of the documentation is available at /llms.txt)