# MV\_MEMORY\_USAGE

This view contains memory usage information that can be used to query specific memory usage types and identify the most significant memory consumers (processes, queries, or rowstore tables).

Refer to [Identifying and Reducing Memory Usage](https://docs.singlestore.com/db/v9.1/reference/troubleshooting-reference/identifying-and-reducing-memory-usage.md) for more information.

| Column Name       | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `NODE_ID`         | The unique ID of a given node.                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| `ALLOC_BYTES`     | The memory usage in bytes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| `ALLOC_PROFILE`   | The memory allocation type.`Total_<category>_memory`indicates the total memory usage in`<category>`.`Buffer_Manager_<category>`indicates the total memory used by the buffer manager in`<category>`.Memory usage options include:`Linux_resident_memory`,`Linux_resident_shared_memory`,`Malloc_active_memory`,`Malloc`,`Total_server_memory`,`Total_table_memory`, and additional options that provide fine-grained detail for in-depth investigations.                                                 |
| `OWNER`           | A JSON object identifying the structure that holds the memory.For a database table, the JSON is similar to:`{"DATABASE":"XDB_0","TABLE":"Xtab1"}`For a process, the JSON is similar to:`{"ACTIVITY":"Select_profile_symbols__MV_MEMORY_USAGE__et_al_36da08f893abf492",  "ACTIVITY_TRACKING_ID":null,  "AGGREGATOR_ACTIVITY":"Select_profile_symbols__MV_MEMORY_USAGE__et_al_36da08f893abf492",  "DATABASE":"information_schema",  "RAW_TASK":"information_schema",  "THREAD_ID":1159312,"TYPE":"Query"}` |
| `OWNER_TYPE`      | The type of the owner. Options include:<ul> <li><code>SERVER</code>: Owned by the engine.</li> <li><code>ALLOCATOR</code>: Owned by an allocator.</li> <li><code>RG_POOL</code>: Owned by the resource group pool.</li> <li><code>USER_TABLE</code>, <code>INTERNAL_TABLE</code>, <code>TEMP_TABLE</code>: Owned by a user table, system table, or temp table.</li> <li><code>PROCESS</code>: Owned by an active process.</li> <li><code>TRANSACTION</code>: Owned by a transaction.</li> </ul>          |
| `GROUP_ID`        | A unique identifier (ID) assigned to a memory usage group. This ID does not have a specific meaning. It is a unique identifier only.                                                                                                                                                                                                                                                                                                                                                                     |
| `SUBGROUP_IDS`    | A JSON object that includes one or more subgroup IDs. Use the subgroup IDs to obtain a breakdown of the memory usage for group`GROUP_ID`and`ALLOC_PROFILE`.                                                                                                                                                                                                                                                                                                                                              |
| `AGGREGATE_COUNT` | If the row was aggregated, the number of aggregated rows. Otherwise 1.A value of`<others>`in`OWNER`indicates the value is an aggregated value.                                                                                                                                                                                                                                                                                                                                                           |

## Remarks

> **❗ Important**: It is acceptable to aggregate memory groups (`ALLOC_PROFILE` options) with the same ID. Do not aggregate across different groups. Aggregating across different groups results in double counting.

## ALLOC\_PROFILE

The memory used by different `ALLOC_PROFILE` options is not mutually exclusive and is not additive.

For example, the `ALLOC_PROFILE` option `Buffer_memory_for_table` shows the memory used for each table in the system and includes both the memory used by the rowstore and the in-memory portion of the columnstore. Memory usage can also be displayed by allocation type such as `Buffer_tracked_regular` or `Buffer_not_tracked`. Thus, a particular piece of memory may be counted both in `Buffer_memory_for_table` and `Buffer_tracked_regular`.

## OWNER

When `OWNER` is `<others>`, this indicates that the engine has aggregated values displayed in this row to minimize the number of rows output.

Use the information in the `OWNER` column to join with `MV_TASKS` or `MV_ACTIVITIES`.

## Security

The `PROCESS_ACL` and `SHOW_METADATA_ACL` permissions are required to see the content of this view.

***

Modified at: March 17, 2026

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-memory-usage/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-memory-usage/)

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