> ## Documentation Index > Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt > Use this file to discover all available pages before exploring further. # SHOW ZONE CONFIGURATIONS Use the `SHOW ZONE CONFIGURATIONS` [statement](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) to view details about existing [replication zones](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). ## Synopsis ![show\_zone syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/show_zone.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=2811bede8b30424cc33ede79b92ea663) ## Required privileges No [privileges](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#managing-privileges) are required to list replication zones. ## Parameters | Parameter | Description | | - | - | | `zone_name` | The name of the system [range](https://docs.cockroachlabs.com/docs/stable/architecture/overview.md#architecture-range) for which to show [replication zone configurations](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). | | `database_name` | The name of the [database](https://docs.cockroachlabs.com/docs/stable/create-database.md) for which to show [replication zone configurations](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). | | `table_name` | The name of the [table](https://docs.cockroachlabs.com/docs/stable/create-table.md) for which to show [replication zone configurations](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). | | `partition_name` | The name of the [partition](https://docs.cockroachlabs.com/docs/stable/partitioning.md) for which to show [replication zone configurations](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). | | `index_name` | The name of the [index](https://docs.cockroachlabs.com/docs/stable/indexes.md) for which to show [replication zone configurations](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md). | ## Examples #### 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](https://docs.cockroachlabs.com/docs/stable/movr.md). To follow along, run [`cockroach demo`](https://docs.cockroachlabs.com/docs/stable/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 ``` ### View all replication zones ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ALL ZONE CONFIGURATIONS; ``` ``` target | raw_config_sql -------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------- RANGE default | ALTER RANGE default CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 90000, | num_replicas = 3, | constraints = '[]', | lease_preferences = '[]' DATABASE system | ALTER DATABASE system CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 90000, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' RANGE meta | ALTER RANGE meta CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 3600, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' RANGE system | ALTER RANGE system CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 90000, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' RANGE liveness | ALTER RANGE liveness CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 600, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' TABLE system.public.replication_constraint_stats | ALTER TABLE system.public.replication_constraint_stats CONFIGURE ZONE USING | gc.ttlseconds = 600, | constraints = '[]', | lease_preferences = '[]' TABLE system.public.replication_stats | ALTER TABLE system.public.replication_stats CONFIGURE ZONE USING | gc.ttlseconds = 600, | constraints = '[]', | lease_preferences = '[]' PARTITION us_west OF INDEX movr.public.users@primary | ALTER PARTITION us_west OF INDEX movr.public.users@primary CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_east OF INDEX movr.public.users@primary | ALTER PARTITION us_east OF INDEX movr.public.users@primary CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION europe_west OF INDEX movr.public.users@primary | ALTER PARTITION europe_west OF INDEX movr.public.users@primary CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION us_west OF INDEX movr.public.vehicles@primary | ALTER PARTITION us_west OF INDEX movr.public.vehicles@primary CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_west OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users | ALTER PARTITION us_west OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_east OF INDEX movr.public.vehicles@primary | ALTER PARTITION us_east OF INDEX movr.public.vehicles@primary CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION us_east OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users | ALTER PARTITION us_east OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION europe_west OF INDEX movr.public.vehicles@primary | ALTER PARTITION europe_west OF INDEX movr.public.vehicles@primary CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION europe_west OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users | ALTER PARTITION europe_west OF INDEX movr.public.vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION us_west OF INDEX movr.public.rides@primary | ALTER PARTITION us_west OF INDEX movr.public.rides@primary CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_west OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users | ALTER PARTITION us_west OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_west OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles | ALTER PARTITION us_west OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_east OF INDEX movr.public.rides@primary | ALTER PARTITION us_east OF INDEX movr.public.rides@primary CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION us_east OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users | ALTER PARTITION us_east OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION us_east OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles | ALTER PARTITION us_east OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION europe_west OF INDEX movr.public.rides@primary | ALTER PARTITION europe_west OF INDEX movr.public.rides@primary CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION europe_west OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users | ALTER PARTITION europe_west OF INDEX movr.public.rides@rides_auto_index_fk_city_ref_users CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION europe_west OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles | ALTER PARTITION europe_west OF INDEX movr.public.rides@rides_auto_index_fk_vehicle_city_ref_vehicles CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' PARTITION us_west OF INDEX movr.public.vehicle_location_histories@primary | ALTER PARTITION us_west OF INDEX movr.public.vehicle_location_histories@primary CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_east OF INDEX movr.public.vehicle_location_histories@primary | ALTER PARTITION us_east OF INDEX movr.public.vehicle_location_histories@primary CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION europe_west OF INDEX movr.public.vehicle_location_histories@primary | ALTER PARTITION europe_west OF INDEX movr.public.vehicle_location_histories@primary CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' TABLE movr.public.promo_codes | ALTER TABLE movr.public.promo_codes CONFIGURE ZONE USING | num_replicas = 3, | constraints = '{+region=us-east1: 1}', | lease_preferences = '[[+region=us-east1]]' INDEX movr.public.promo_codes@promo_codes_idx_us_west | ALTER INDEX movr.public.promo_codes@promo_codes_idx_us_west CONFIGURE ZONE USING | num_replicas = 3, | constraints = '{+region=us-west1: 1}', | lease_preferences = '[[+region=us-west1]]' INDEX movr.public.promo_codes@promo_codes_idx_europe_west | ALTER INDEX movr.public.promo_codes@promo_codes_idx_europe_west CONFIGURE ZONE USING | num_replicas = 3, | constraints = '{+region=europe-west1: 1}', | lease_preferences = '[[+region=europe-west1]]' PARTITION us_west OF INDEX movr.public.user_promo_codes@primary | ALTER PARTITION us_west OF INDEX movr.public.user_promo_codes@primary CONFIGURE ZONE USING | constraints = '[+region=us-west1]' PARTITION us_east OF INDEX movr.public.user_promo_codes@primary | ALTER PARTITION us_east OF INDEX movr.public.user_promo_codes@primary CONFIGURE ZONE USING | constraints = '[+region=us-east1]' PARTITION europe_west OF INDEX movr.public.user_promo_codes@primary | ALTER PARTITION europe_west OF INDEX movr.public.user_promo_codes@primary CONFIGURE ZONE USING | constraints = '[+region=europe-west1]' (34 rows) ``` ### View the default replication zone for the cluster ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ZONE CONFIGURATION FROM RANGE default; ``` ``` target | raw_config_sql ----------------+------------------------------------------- RANGE default | ALTER RANGE default CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 90000, | num_replicas = 3, | constraints = '[]', | lease_preferences = '[]' (1 row) ``` ### View the replication zone for a database To control replication for a specific database, use the `ALTER DATABASE ... CONFIGURE ZONE` statement to define the relevant values (other values will be inherited from the parent zone): ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER DATABASE movr CONFIGURE ZONE USING num_replicas = 5, gc.ttlseconds = 100000; ``` ``` CONFIGURE ZONE 1 ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ZONE CONFIGURATION FROM DATABASE movr; ``` ``` target | raw_config_sql ----------------+------------------------------------------- DATABASE movr | ALTER DATABASE movr CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 100000, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' (1 row) ``` ### View the replication zone for a table To control replication for a specific table, use the `ALTER TABLE ... CONFIGURE ZONE` statement to define the relevant values (other values will be inherited from the parent zone): ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER TABLE users CONFIGURE ZONE USING num_replicas = 5, gc.ttlseconds = 100000; ``` ``` CONFIGURE ZONE 1 ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ZONE CONFIGURATION FROM TABLE users; ``` ``` target | raw_config_sql --------------+----------------------------------------- TABLE users | ALTER TABLE users CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 100000, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' (1 row) ``` You can also use [`SHOW CREATE TABLE`](https://docs.cockroachlabs.com/docs/stable/show-create) to view zone configurations for a table. If a table is partitioned, but no zones are configured, the `SHOW CREATE TABLE` output includes a warning. ### View the replication zone for an index To control replication for a specific index, use the [`ALTER INDEX ... CONFIGURE ZONE`](https://docs.cockroachlabs.com/docs/stable/alter-index#configure-zone) statement to define the relevant values (other values will be inherited from the parent zone): ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER INDEX vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING num_replicas = 5, gc.ttlseconds = 100000; ``` ``` CONFIGURE ZONE 1 ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ZONE CONFIGURATION FROM INDEX vehicles@vehicles_auto_index_fk_city_ref_users; ``` ``` target | raw_config_sql -------------------------------------------------------+---------------------------------------------------------------------------------- INDEX vehicles@vehicles_auto_index_fk_city_ref_users | ALTER INDEX vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 100000, | num_replicas = 5, | constraints = '[]', | lease_preferences = '[]' (1 row) ``` ### View the replication zone for a partition > [!TIP] > > Most users should not need to use partitioning directly. Instead, they should use CockroachDB's built-in [multi-region capabilities](https://docs.cockroachlabs.com/docs/stable/multiregion-overview.md), which automatically handle geo-partitioning and other low-level details. Once [partitions have been defined for a table or a secondary index](https://docs.cockroachlabs.com/docs/stable/partitioning.md), to control replication for a partition, use `ALTER PARTITION OF INDEX CONFIGURE ZONE`: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER PARTITION us_west OF INDEX vehicles@primary CONFIGURE ZONE USING num_replicas = 5, constraints = '[+region=us-west1]'; ``` ``` CONFIGURE ZONE 1 ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER PARTITION us_west OF INDEX vehicles@vehicles_auto_index_fk_city_ref_users CONFIGURE ZONE USING num_replicas = 5, constraints = '[+region=us-west1]'; ``` ``` CONFIGURE ZONE 1 ``` To define replication zones for identically named partitions of a table and its secondary indexes, you can use the `@*` syntax to save several steps: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > ALTER PARTITION us_west OF INDEX vehicles@* CONFIGURE ZONE USING num_replicas = 5, constraints = '[+region=us-west1]'; ``` To view the zone configuration for a partition, use `SHOW ZONE CONFIGURATION FROM PARTITION OF INDEX `: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ZONE CONFIGURATION FROM PARTITION us_west OF INDEX vehicles@primary; ``` ``` target | raw_config_sql ----------------------------------------------+------------------------------------------------------------------------- PARTITION us_west OF INDEX vehicles@primary | ALTER PARTITION us_west OF INDEX vehicles@primary CONFIGURE ZONE USING | range_min_bytes = 134217728, | range_max_bytes = 536870912, | gc.ttlseconds = 90000, | num_replicas = 5, | constraints = '[+region=us-west1]', | lease_preferences = '[]' (1 row) ``` > [!TIP] > > You can also use the [`SHOW CREATE TABLE`](https://docs.cockroachlabs.com/docs/stable/show-create) statement or [`SHOW PARTITIONS`](https://docs.cockroachlabs.com/docs/stable/show-partitions) statements to view details about all of the replication zones defined for the partitions of a table and its secondary indexes. ## See also * [Replication Controls](https://docs.cockroachlabs.com/docs/stable/configure-replication-zones.md) * [`ALTER DATABASE ... CONFIGURE ZONE`](https://docs.cockroachlabs.com/docs/stable/alter-database#configure-zone) * [`ALTER INDEX ... CONFIGURE ZONE`](https://docs.cockroachlabs.com/docs/stable/alter-index#configure-zone) * [`ALTER RANGE ... CONFIGURE ZONE`](https://docs.cockroachlabs.com/docs/stable/alter-range#configure-zone) * [`ALTER TABLE ... CONFIGURE ZONE`](https://docs.cockroachlabs.com/docs/stable/alter-table#configure-zone) * [SQL Statements](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) * [Troubleshoot Replication Zones](https://docs.cockroachlabs.com/docs/stable/troubleshoot-replication-zones.md)