SHARDS

Lists the shards in your database.

Column Name Data Type Description
SHARD_OID

INTEGER

The OID of the shard.
SHARD_NAME

VARCHAR

The name of the shard.
SHARD_TYPE		

VARCHAR

The type of the shard.
LOWER_HASH_BOUND

VARCHAR

The lower hash bound of the shard.
UPPER_HASH_BOUND

VARCHAR

The upper hash bound of the shard.
IS_REPLICATED

BOOLEAN

Defines if the shard is replicated.
HAS_OBJECTS

BOOLEAN

Defines if the shard contains objects.

Example

=> SELECT * FROM SHARDS;
-[ RECORD 1 ]----+------------------
shard_oid        | 45035996273704980
shard_name       | replica
shard_type       | Replica
lower_hash_bound | 
upper_hash_bound | 
is_replicated    | t
has_objects      | t
...