timescaledb_information.hypertables

Get metadata information about hypertables.

Available columns

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 TEXT Nodes on which hypertable is distributed
tablespaces TEXT Tablespaces 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         |