> ## Documentation Index > Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # SHOW RANGES export const InternalLink = ({version, path = "", children, ...props}) => { let detectedVersion = version || "stable"; if (typeof window !== 'undefined' && !version) { const match = window.location.pathname.match(/\/docs\/([^/]+)/); if (match) { detectedVersion = match[1]; } } const normalizedPath = path.startsWith("/") ? path.slice(1) : path; return {children} ; }; The `SHOW RANGES` statement shows information about the ranges that comprise the data for a table, index, database, or the current catalog. This information is useful for verifying how SQL data maps to underlying ranges, and where the replicas for those ranges are located. The statement syntax and output documented on this page use the updated `SHOW RANGES` that **will become the default in CockroachDB v23.2**. To enable this syntax and output, set the cluster setting `sql.show_ranges_deprecated_behavior.enabled` to `false`: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SET CLUSTER SETTING sql.show_ranges_deprecated_behavior.enabled = false; ``` The pre-v23.1 output of `SHOW RANGES` is deprecated in v23.1 **and will be removed in v23.2**. When you use the deprecated version of the `SHOW RANGES` statement, the following message will appear, reminding you to update the cluster setting: ``` NOTICE: attention! the pre-23.1 behavior of SHOW RANGES and crdb_internal.ranges{,_no_leases} is deprecated! HINT: Consider enabling the new functionality by setting 'sql.show_ranges_deprecated_behavior.enabled' to 'false'. The new SHOW RANGES statement has more options. Refer to the online documentation or execute 'SHOW RANGES ??' for details. ``` To show range information for a specific row in a table or index, use the `SHOW RANGE ... FOR ROW` statement. ## Synopsis show_ranges syntax diagram ## Required privileges To use the `SHOW RANGES` statement, a user must either be a member of the `admin` role (the `root` user belongs to the `admin` role by default) or have the `ZONECONFIG` privilege defined. ## Parameters | Parameter | Description | | ------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `table_name` | The name of the table you want range information about. | | `table_index_name` | The name of the index you want range information about. | | `database_name` | The name of the database you want range information about. | | `opt_show_ranges_options` | The [options](#options) used to configure what fields appear in the [response](#response). | ## Options The following options are available to affect the output. Multiple options can be passed at once, separated by commas. * `TABLES`: List tables contained per range. * `INDEXES`: List indexes contained per range. * `DETAILS`: Add range size, leaseholder and other details. Note that this incurs a large computational overhead because it needs to fetch data across nodes. * `KEYS`: Include binary [start and end keys](#start-key). ## Response The specific fields in the response vary depending on the values passed as [options](#options). The following fields may be returned: | Field | Description | Emitted for option(s) | | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | `start_key` | The start key for the range. | Always emitted. | | `end_key` | The end key for the range. | Always emitted. | | `raw_start_key` | The start key for the range, displayed as a hexadecimal byte value. | `KEYS` | | `raw_end_key` | The end key for the range, displayed as a hexadecimal byte value. | `KEYS` | | `range_id` | The internal range ID. | Always emitted. | | `voting_replicas` | The nodes that contain the range's voting replicas (that is, the replicas that participate in Raft elections). | Always emitted. | | `non_voting_replicas` | The nodes that contain the range's non-voting replicas. | Always emitted. | | `replicas` | The nodes that contain the range's replicas. | Always emitted. | | `replica_localities` | The localities of the range's replicas. | Always emitted. | | `range_size` | The size of the range in bytes. | `DETAILS` | | `range_size_mb` | The size of the range in MiB. | `DETAILS` | | `lease_holder` | The node that contains the range's leaseholder. | `DETAILS` | | `lease_holder_locality` | The locality of the range's leaseholder. | `DETAILS` | | `learner_replicas` | The *learner replicas* of the range. A learner replica is a replica that has just been added to a range, and is thus in an interim state. It accepts messages but doesn't vote in Raft elections. This means it doesn't affect quorum and thus doesn't affect the stability of the range, even if it's very far behind. | Always emitted. | | `split_enforced_until` | The time a range split is enforced until. This can be set using `ALTER TABLE ... SPLIT AT` using the `WITH EXPIRATION` clause. Example: `2262-04-11 23:47:16.854776` (this is a default value which means "never"). | Always emitted. | | `schema_name` | The name of the schema this range holds data for. | `TABLES`, `INDEXES` | | `table_name` | The name of the table this range holds data for. | `TABLES`, `INDEXES` | | `table_id` | The internal ID of the table this range holds data for. | `TABLES`, `INDEXES` | | `table_start_key` | The start key of the first range that holds data for this table. | `TABLES` | | `table_end_key` | The end key of the last range that holds data for this table. | `TABLES` | | `raw_table_start_key` | The start key of the first range that holds data for this table, expressed as `BYTES`. | `TABLES`, `KEYS` | | `raw_table_end_key` | The end key of the last range that holds data for this table, expressed as `BYTES`. | `TABLES`, `KEYS` | | `index_name` | The name of the index this range holds data for. | `INDEXES` | | `index_id` | The internal ID of the index this range holds data for. | `INDEXES` | | `index_start_key` | The start key of the first range of index data. | `INDEXES` | | `index_end_key` | The end key of the last range of index data. | `INDEXES` | | `raw_index_start_key` | The start key of the first range of index data, expressed as `BYTES`. | `INDEXES`, `KEYS` | | `raw_index_end_key` | The end key of the last range of index data, expressed as `BYTES`. | `INDEXES`, `KEYS` | ## Examples The statement syntax and output documented on this page use the updated `SHOW RANGES` that **will become the default in CockroachDB v23.2**. To enable this syntax and output, set the cluster setting `sql.show_ranges_deprecated_behavior.enabled` to `false`: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SET CLUSTER SETTING sql.show_ranges_deprecated_behavior.enabled = false; ``` The pre-v23.1 output of `SHOW RANGES` is deprecated in v23.1 **and will be removed in v23.2**. When you use the deprecated version of the `SHOW RANGES` statement, the following message will appear, reminding you to update the cluster setting: ``` NOTICE: attention! the pre-23.1 behavior of SHOW RANGES and crdb_internal.ranges{,_no_leases} is deprecated! HINT: Consider enabling the new functionality by setting 'sql.show_ranges_deprecated_behavior.enabled' to 'false'. The new SHOW RANGES statement has more options. Refer to the online documentation or execute 'SHOW RANGES ??' for details. ``` #### Setup The following examples use MovR, a fictional vehicle-sharing application, to demonstrate CockroachDB SQL statements. For more information about the MovR example application and dataset, see MovR: A Global Vehicle-sharing App. To follow along, run `cockroach demo` with the `--geo-partitioned-replicas` flag. This command opens an interactive SQL shell to a temporary, 9-node in-memory cluster with the `movr` database. ```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} $ cockroach demo --geo-partitioned-replicas ``` ### Show ranges for a database * [Show ranges for a database (without options)](#show-ranges-for-a-database-without-options) * [Show ranges for a database (with tables, keys, details)](#show-ranges-for-a-database-with-tables-keys-details) * [Show ranges for a database (with tables)](#show-ranges-for-a-database-with-tables) * [Show ranges for a database (with indexes)](#show-ranges-for-a-database-with-indexes) * [Show ranges for a database (with details)](#show-ranges-for-a-database-with-details) * [Show ranges for a database (with keys)](#show-ranges-for-a-database-with-keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW DATABASES; ``` ``` database_name | owner | primary_region | secondary_region | regions | survival_goal ----------------+-------+----------------+------------------+---------+---------------- defaultdb | root | NULL | NULL | {} | NULL movr | demo | NULL | NULL | {} | NULL postgres | root | NULL | NULL | {} | NULL system | node | NULL | NULL | {} | NULL (4 rows) ``` #### Show ranges for a database (without options) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr; ``` ``` start_key | end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- /Table/106 | /Table/106/1/"amsterdam" | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... /Table/111/1/"washington dc"/PrefixEnd | /Max | 309 | {3,5,9} | {"region=us-east1,az=d","region=us-west1,az=b","region=europe-west1,az=d"} | {3,5,9} | {} | {} | NULL (178 rows) ``` #### Show ranges for a database (with tables, keys, details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr WITH TABLES, KEYS, DETAILS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | schema_name | table_name | table_id | table_start_key | table_end_key | raw_table_start_key | raw_table_end_key | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+-------------+----------------------------+----------+-----------------+----------------------+---------------------+-------------------+----------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- /Table/106 | /Table/106/1/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 174 | public | users | 106 | /Table/106 | /Table/107 | \xf2 | \xf3 | 0 | 3 | region=us-east1,az=d | {3,6,9} | {"region=us-east1,az=d","region=us-west1,az=c","region=europe-west1,az=d"} | {3,9,6} | {} | {} | NULL | 0 /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 175 | public | users | 106 | /Table/106 | /Table/107 | \xf2 | \xf3 | 0.00011900000000000000000 | 3 | region=us-east1,az=d | {3,7,8} | {"region=us-east1,az=d","region=europe-west1,az=b","region=europe-west1,az=c"} | {3,7,8} | {} | {} | NULL | 119 ... /Table/111/1/"washington dc"/PrefixEnd | /Max | \xf66f891277617368696e67746f6e2064630002 | \xffff | 295 | public | user_promo_codes | 111 | /Table/111 | /Table/112 | \xf66f | \xf670 | 0 | 8 | region=europe-west1,az=c | {3,4,8} | {"region=us-east1,az=d","region=us-west1,az=a","region=europe-west1,az=c"} | {3,8,4} | {} | {} | NULL | 0 (145 rows) ``` #### Show ranges for a database (with tables) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr WITH TABLES; ``` ``` start_key | end_key | range_id | schema_name | table_name | table_id | table_start_key | table_end_key | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+----------+-------------+----------------------------+----------+-----------------+----------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- /Table/106 | /Table/106/1/"amsterdam" | 67 | public | users | 106 | /Table/106 | /Table/107 | {1,4,9} | {"region=us-east1,az=b","region=us-west1,az=a","region=europe-west1,az=d"} | {1,9,4} | {} | {} | NULL /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 68 | public | users | 106 | /Table/106 | /Table/107 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {7,9,8} | {} | {} | NULL ... /Table/111/1/"washington dc"/PrefixEnd | /Max | 311 | public | user_promo_codes | 111 | /Table/111 | /Table/112 | {1,5,7} | {"region=us-east1,az=b","region=us-west1,az=b","region=europe-west1,az=b"} | {1,7,5} | {} | {} | NULL (178 rows) ``` #### Show ranges for a database (with indexes) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr WITH INDEXES; ``` ``` start_key | end_key | range_id | schema_name | table_name | table_id | index_name | index_id | index_start_key | index_end_key | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+----------+-------------+----------------------------+----------+-----------------------------------------------+----------+-----------------+---------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- /Table/106 | /Table/106/1/"amsterdam" | 70 | public | users | 106 | users_pkey | 1 | /Table/106/1 | /Table/106/2 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | public | users | 106 | users_pkey | 1 | /Table/106/1 | /Table/106/2 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... /Table/111/1/"washington dc"/PrefixEnd | /Max | 309 | public | user_promo_codes | 111 | user_promo_codes_pkey | 1 | /Table/111/1 | /Table/111/2 | {3,5,9} | {"region=us-east1,az=d","region=us-west1,az=b","region=europe-west1,az=d"} | {3,5,9} | {} | {} | NULL (179 rows) ``` #### Show ranges for a database (with details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr WITH DETAILS; ``` ``` start_key | end_key | range_id | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+----------+----------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- /Table/106 | /Table/106/1/"amsterdam" | 70 | 0 | 1 | region=us-east1,az=b | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL | 0 /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | 0.00011800000000000000000 | 9 | region=europe-west1,az=d | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL | 118 ... /Table/111/1/"washington dc"/PrefixEnd | /Max | 309 | 0 | 9 | region=europe-west1,az=d | {3,5,9} | {"region=us-east1,az=d","region=us-west1,az=b","region=europe-west1,az=d"} | {3,5,9} | {} | {} | NULL | 0 (178 rows) ``` #### Show ranges for a database (with keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM DATABASE movr WITH KEYS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until -----------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- /Table/106 | /Table/106/1/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL /Table/106/1/"amsterdam" | /Table/106/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... /Table/111/1/"washington dc"/PrefixEnd | /Max | \xf66f891277617368696e67746f6e2064630002 | \xffff | 309 | {3,5,9} | {"region=us-east1,az=d","region=us-west1,az=b","region=europe-west1,az=d"} | {3,5,9} | {} | {} | NULL (178 rows) ``` ### Show ranges for a table * [Show ranges for a table (without options)](#show-ranges-for-a-table-without-options) * [Show ranges for a table (with indexes, keys, details)](#show-ranges-for-a-table-with-indexes-keys-details) * [Show ranges for a table (with indexes)](#show-ranges-for-a-table-with-indexes) * [Show ranges for a table (with details)](#show-ranges-for-a-table-with-details) * [Show ranges for a table (with keys)](#show-ranges-for-a-table-with-keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW TABLES; ``` ``` schema_name | table_name | type | owner | estimated_row_count | locality --------------+----------------------------+-------+-------+---------------------+----------- public | promo_codes | table | demo | 1000 | NULL public | rides | table | demo | 500 | NULL public | user_promo_codes | table | demo | 5 | NULL public | users | table | demo | 50 | NULL public | vehicle_location_histories | table | demo | 1000 | NULL public | vehicles | table | demo | 15 | NULL (6 rows) ``` #### Show ranges for a table (without options) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM TABLE movr.users; ``` ``` start_key | end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until --------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- …/ | …/1/"amsterdam" | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL …/1/"amsterdam" | …/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... …/1/"washington dc"/PrefixEnd | …/ | 154 | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL (27 rows) ``` #### Show ranges for a table (with indexes, keys, details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM TABLE movr.users with INDEXES, KEYS, DETAILS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | index_name | index_id | index_start_key | index_end_key | raw_index_start_key | raw_index_end_key | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size --------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+------------+----------+-----------------+---------------+---------------------+-------------------+---------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- …/ | …/1/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 174 | users_pkey | 1 | …/1 | …/2 | \xf289 | \xf28a | 0 | 3 | region=us-east1,az=d | {3,6,9} | {"region=us-east1,az=d","region=us-west1,az=c","region=europe-west1,az=d"} | {3,9,6} | {} | {} | NULL | 0 …/1/"amsterdam" | …/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 175 | users_pkey | 1 | …/1 | …/2 | \xf289 | \xf28a | 0.00011900000000000000000 | 9 | region=europe-west1,az=d | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL | 119 ... …/1/"washington dc"/PrefixEnd | …/ | \xf2891277617368696e67746f6e2064630002 | \xf3 | 111 | users_pkey | 1 | …/1 | …/2 | \xf289 | \xf28a | 0 | 9 | region=europe-west1,az=d | {1,5,9} | {"region=us-east1,az=b","region=us-west1,az=b","region=europe-west1,az=d"} | {1,9,5} | {} | {} | NULL | 0 (27 rows) ``` #### Show ranges for a table (with indexes) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM TABLE movr.users WITH INDEXES; ``` ``` start_key | end_key | range_id | index_name | index_id | index_start_key | index_end_key | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until --------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+----------+------------+----------+-----------------+---------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- …/ | …/1/"amsterdam" | 70 | users_pkey | 1 | …/1 | …/2 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL …/1/"amsterdam" | …/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | users_pkey | 1 | …/1 | …/2 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... …/1/"washington dc"/PrefixEnd | …/ | 154 | users_pkey | 1 | …/1 | …/2 | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL (27 rows) ``` #### Show ranges for a table (with details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM TABLE movr.users WITH DETAILS; ``` ``` start_key | end_key | range_id | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size --------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+----------+----------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- …/ | …/1/"amsterdam" | 70 | 0 | 1 | region=us-east1,az=b | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL | 0 …/1/"amsterdam" | …/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | 0.00011800000000000000000 | 9 | region=europe-west1,az=d | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL | 118 ... …/1/"washington dc"/PrefixEnd | …/ | 154 | 0 | 4 | region=us-west1,az=a | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL | 0 (27 rows) ``` #### Show ranges for a table (with keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM TABLE movr.users WITH KEYS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until --------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- …/ | …/1/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL …/1/"amsterdam" | …/1/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... …/1/"washington dc"/PrefixEnd | …/ | \xf2891277617368696e67746f6e2064630002 | \xf3 | 154 | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL (27 rows) ``` ### Show ranges for an index * [Show ranges for an index (without options)](#show-ranges-for-an-index-without-options) * [Show ranges for an index (with keys, details)](#show-ranges-for-an-index-with-keys-details) * [Show ranges for an index (with details)](#show-ranges-for-an-index-with-details) * [Show ranges for an index (with keys)](#show-ranges-for-an-index-with-keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW INDEXES FROM movr.users; ``` ``` table_name | index_name | non_unique | seq_in_index | column_name | definition | direction | storing | implicit | visible -------------+------------+------------+--------------+-------------+-------------+-----------+---------+----------+---------- users | users_pkey | f | 1 | city | city | ASC | f | f | t users | users_pkey | f | 2 | id | id | ASC | f | f | t users | users_pkey | f | 3 | name | name | N/A | t | f | t users | users_pkey | f | 4 | address | address | N/A | t | f | t users | users_pkey | f | 5 | credit_card | credit_card | N/A | t | f | t (5 rows) ``` #### Show ranges for an index (without options) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM INDEX movr.users_pkey; ``` ``` start_key | end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until ------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- …/TableMin | …/"amsterdam" | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL …/"amsterdam" | …/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... …/"washington dc"/PrefixEnd | …/ | 154 | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL (27 rows) ``` #### Show ranges for an index (with keys, details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM INDEX movr.users_pkey WITH KEYS, DETAILS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size ------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+---------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- …/TableMin | …/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 174 | 0 | 3 | region=us-east1,az=d | {3,6,9} | {"region=us-east1,az=d","region=us-west1,az=c","region=europe-west1,az=d"} | {3,9,6} | {} | {} | NULL | 0 …/"amsterdam" | …/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 175 | 0.00011900000000000000000 | 9 | region=europe-west1,az=d | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL | 119 ... …/"washington dc"/PrefixEnd | …/ | \xf2891277617368696e67746f6e2064630002 | \xf3 | 111 | 0 | 9 | region=europe-west1,az=d | {1,5,9} | {"region=us-east1,az=b","region=us-west1,az=b","region=europe-west1,az=d"} | {1,9,5} | {} | {} | NULL | 0 (27 rows) ``` #### Show ranges for an index (with details) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM INDEX movr.users_pkey WITH DETAILS; ``` ``` start_key | end_key | range_id | range_size_mb | lease_holder | lease_holder_locality | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until | range_size ------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+----------+----------------------------+--------------+--------------------------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------+------------- …/TableMin | …/"amsterdam" | 70 | 0 | 1 | region=us-east1,az=b | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL | 0 …/"amsterdam" | …/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | 71 | 0.00011800000000000000000 | 9 | region=europe-west1,az=d | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL | 118 ... …/"washington dc"/PrefixEnd | …/ | 154 | 0 | 4 | region=us-west1,az=a | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL | 0 (27 rows) ``` #### Show ranges for an index (with keys) ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW RANGES FROM INDEX movr.users_pkey WITH KEYS; ``` ``` start_key | end_key | raw_start_key | raw_end_key | range_id | replicas | replica_localities | voting_replicas | non_voting_replicas | learner_replicas | split_enforced_until ------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+----------+------------------------------------------------------------------------------------+-----------------+---------------------+------------------+----------------------------- …/TableMin | …/"amsterdam" | \xf2 | \xf28912616d7374657264616d0001 | 70 | {1,6,8} | {"region=us-east1,az=b","region=us-west1,az=c","region=europe-west1,az=c"} | {1,6,8} | {} | {} | NULL …/"amsterdam" | …/"amsterdam"/"\xb333333@\x00\x80\x00\x00\x00\x00\x00\x00#" | \xf28912616d7374657264616d0001 | \xf28912616d7374657264616d000112b333333333334000ff8000ff00ff00ff00ff00ff00ff230001 | 71 | {7,8,9} | {"region=europe-west1,az=b","region=europe-west1,az=c","region=europe-west1,az=d"} | {9,7,8} | {} | {} | NULL ... …/"washington dc"/PrefixEnd | …/ | \xf2891277617368696e67746f6e2064630002 | \xf3 | 154 | {2,4,7} | {"region=us-east1,az=c","region=us-west1,az=a","region=europe-west1,az=b"} | {2,4,7} | {} | {} | NULL (27 rows) ``` ## See also * `SHOW RANGE ... FOR ROW` * `ALTER TABLE ... SPLIT AT` * `ALTER INDEX ... SPLIT AT` * `CREATE TABLE` * `CREATE INDEX` * Indexes * Partitioning tables * Architecture Overview