# MV\_ROW\_CHANGE\_COUNTS

This view is primarily for internal use, SingleStore recommends using [MV\_COLLECTED\_ROW\_CHANGE\_COUNTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-collected-row-change-counts.md) instead.

This view returns a row for each partition of each table with autostats (automatic statistics) hosted in the cluster, along with a change count.

These statistics are in-memory and show the number of row changes (inserts, updates, and deletes) that have been applied to the table partition since it became online on the host. In-memory statistics do not persist across restarts.

The write behavior to the view is controlled via the following engine variables: `change_count_write_interval` and `background_statistics_collection_interval`

| Column name     | Description                                                                 |
| --------------- | --------------------------------------------------------------------------- |
| `table_name`    | The name of the table in the database.                                      |
| `database_name` | The name of the database associated with the activity.                      |
| `partition`     | The table partition in the database.                                        |
| `changed`       | The count of changes (inserts, updates, and deletes) for a table partition. |
| `token`         | The token associated with the table partition.                              |

An example query related to this view:

```sql
SELECT table_name, database_name, SUM(changed) FROM MV_ROW_CHANGE_COUNTS GROUP BY ALL;

```

```output

+------------+---------------+--------------+
| table_name | database_name | sum(changed) |
+------------+---------------+--------------+
| t          | db1           |            3 |
| t2         | db1           |            0 |
+------------+---------------+--------------+
```

***

Modified at: March 8, 2024

Source: [/db/v9.1/reference/information-schema-reference/management/mv-row-change-counts/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-row-change-counts/)

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