timescaledb_information.hypertables

Get metadata information about hypertables.

Available columns

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_nodesTEXTNodes on which hypertable is distributed
tablespacesTEXTTablespaces attached to the hypertable

Sample usage

Get information about a hypertable.

  2. CREATE TABLE dist_table(time timestamptz, device int, temp float);
  4. SELECT create_distributed_hypertable('dist_table', 'time', 'device', replication_factor => 2);
  6. SELECT * FROM timescaledb_information.hypertables
  8.   WHERE hypertable_name = 'dist_table';
  10. -[ RECORD 1 ]-------+-----------
  12. hypertable_schema   | public
  14. hypertable_name     | dist_table
  16. owner               | postgres 
  19. num_dimensions      | 2
  21. num_chunks          | 3
  23. compression_enabled | f
  25. is_distributed      | t
  27. replication_factor  | 2
  29. data_nodes          | {node_1, node_2}
  31. tablespaces         |