# MV\_SEQUENCES

This view shows the status and statistics of all sequences in the system. It provides information about sequence ownership, current values, performance metrics, and cache statistics for both leaf nodes and aggregators. Refer to [AUTO\_INCREMENT AS SEQUENCE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-table/#section-idm234966854099799.md) for related information.

| **Column Name**     | **Description**                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `NODE_ID`           | ID of the node to which the other columns in the view apply.                                                                                                                                                                                                                                                                                                                                                                                                                   |
| `DATABASE_NAME`     | Name of the database that contains the table.                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| `TABLE_NAME`        | Name of the table that contains the sequence column.                                                                                                                                                                                                                                                                                                                                                                                                                           |
| `COLUMN_NAME`       | Name of the column defined as a sequence.                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| `PARTITION_ID`      | ID of the partition that currently owns the sequence and coordinates unique values for all aggregators.                                                                                                                                                                                                                                                                                                                                                                        |
| `IS_OWNER_LEAF`     | Indicates whether this node is the leaf node that owns the partition and receives range requests from aggregators.                                                                                                                                                                                                                                                                                                                                                             |
| `IS_AGGREGATOR`     | Indicates whether this node functions as an aggregator.                                                                                                                                                                                                                                                                                                                                                                                                                        |
| `VALUE`             | Has different meanings depending on the node role:<ul> <li>Owner leaf: Start value of the next sequence range to serve.</li> <li>Aggregator: Next sequence value to generate from the cached range.</li> </ul>                                                                                                                                                                                                                                                                 |
| `LAST_ACCESS_TIME`  | Timestamp of the last range request from an aggregator. Applies only to the owner leaf.                                                                                                                                                                                                                                                                                                                                                                                        |
| `CURRENT_RANGE`     | Size of the sequence range starting from`VALUE`.SingleStoreadjusts this size based on load and the following variables:`sequence_min_cache_count`,`sequence_max_cache_count`,`sequence_cache_resize_up_time_us`,`sequence_cache_resize_down_time_us`. Refer to[Configure Sequences](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-table/#section-idm234966857481733.md)for more information.Applies to the owner leaf only. |
| `FETCHES`           | Number of range requests sent by this aggregator to the owner leaf. Applies to aggregators only.                                                                                                                                                                                                                                                                                                                                                                               |
| `CACHE_MISSES`      | Number of times an aggregator required a new range because no valid cached range was available. High values indicate potential performance issues.                                                                                                                                                                                                                                                                                                                             |
| `PRE_FETCHES`       | Number of successful pre-fetch operations performed by an aggregator before exhausting its current range.                                                                                                                                                                                                                                                                                                                                                                      |
| `DOUBLE_PREFETCHES` | Number of times an aggregator attempted to pre-fetch while another fetch was already in progress. High values indicate heavy load and rapid cache exhaustion.                                                                                                                                                                                                                                                                                                                  |
| `ERRORS`            | Number of errors encountered when requesting a new range from the owner leaf. High values may indicate cluster instability or network problems.                                                                                                                                                                                                                                                                                                                                |

## LMV\_SEQUENCES

The `LMV_SEQUENCES` view provides the same information as `MV_SEQUENCES` but only for the local node. It excludes the `NODE_ID` column.

Use this view to inspect sequence behavior on the current node without querying cluster-wide data.

***

Modified at: February 18, 2026

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

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