timescaledb_information.data_nodes

NameTypeDescription
hypertable_schemaTEXTSchema name of the hypertable
hypertable_nameTEXTTable name of the hypertable
ownerTEXTOwner of the hypertable
num_dimensionsSMALLINTNumber of dimensions
num_chunksBIGINTNumber of chunks
compression_enabledBOOLEANIs compression enabled on the hypertable?
is_distributedBOOLEANIs the hypertable distributed?
replication_factorSMALLINTReplication factor for a distributed hypertable
data_nodesARRAYNodes on which hypertable is distributed
tablespacesARRAYTablespaces attached to the hypertable
  1. SELECT create_distributed_hypertable('dist_table', 'time', 'device', replication_factor => 2);
  2. SELECT * FROM timescaledb_information.hypertables
  3. WHERE hypertable_name = 'dist_table';
  4. -[ RECORD 1 ]-------+-----------
  5. hypertable_schema | public
  6. hypertable_name | dist_table
  7. num_chunks | 3
  8. compression_enabled | f
  9. is_distributed | t
  10. replication_factor | 2
  11. data_nodes | {node_1, node_2}