SHOW LOCALITY

The SHOW LOCALITY statement returns the locality of the current node. If locality was not specified on node startup, the statement returns an empty row.

Required privileges

No privileges are required to list the locality of the current node.

Synopsis

Example

Setup

The following example uses 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 movr with the --nodes and --demo-locality tags. This command opens an interactive SQL shell to a temporary, multi-node in-memory cluster with the movr database preloaded and set as the current database.

$ cockroach demo movr --nodes=3 --demo-locality=region=us-east,az=a:region=us-central,az=b:region=us-west1,az=c

> SHOW LOCALITY;

       locality
+---------------------+
  region=us-east,az=a
(1 row)

Show locality with a built-in function

If you know the locality key, you can use the crdb_internal.locality_value built-in function to return the locality value for the current node:

> SELECT * FROM crdb_internal.locality_value('region');

  crdb_internal.locality_value
+------------------------------+
  us-east
(1 row)

> SELECT * FROM crdb_internal.locality_value('az');

  crdb_internal.locality_value
+------------------------------+
  a
(1 row)

For a more extensive example, see Create a table with node locality information.

Statements

Syntax

Data Types

Spatial Data

Constraints

SHOW LOCALITY

Required privileges

Synopsis

Example

Setup

Show locality

Show locality with a built-in function

See also

​Required privileges

​Synopsis

​Example

​Setup

​Show locality

​Show locality with a built-in function

​See also

Required privileges

Synopsis

Example

Setup

Show locality

Show locality with a built-in function

See also