SHOW LOCALITY

The SHOW LOCALITY returns the of the current node.

If locality was not specified on node startup, the statement returns an empty row.

Required privileges

No 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 .

To follow along, run 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 .

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

Show locality

> 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 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 .

See also