SHARDS

Lists the shards in your database.

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.

Examples

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