Name | Type | Description |
---|
hypertable_schema | TEXT | Schema name of the hypertable |
hypertable_name | TEXT | Table name of the hypertable |
owner | TEXT | Owner of the hypertable |
num_dimensions | SMALLINT | Number of dimensions |
num_chunks | BIGINT | Number of chunks |
compression_enabled | BOOLEAN | Is compression enabled on the hypertable? |
is_distributed | BOOLEAN | Is the hypertable distributed? |
replication_factor | SMALLINT | Replication factor for a distributed hypertable |
data_nodes | ARRAY | Nodes on which hypertable is distributed |
tablespaces | ARRAY | Tablespaces attached to the hypertable |
SELECT create_distributed_hypertable('dist_table', 'time', 'device', replication_factor => 2);
SELECT * FROM timescaledb_information.hypertables
WHERE hypertable_name = 'dist_table';
-[ RECORD 1 ]-------+-----------
hypertable_schema | public
hypertable_name | dist_table
num_chunks | 3
compression_enabled | f
is_distributed | t
replication_factor | 2
data_nodes | {node_1, node_2}