Skip to main content
Get metadata information about s. For more information about using s, including size partitioning, see the section.

Samples

Get information about a .
CREATE TABLE metrics(time timestamptz, device int, temp float);
SELECT create_hypertable('metrics','time');

SELECT * from timescaledb_information.hypertables WHERE hypertable_name = 'metrics';

-[ RECORD 1 ]-------+--------
hypertable_schema   | public
hypertable_name     | metrics
owner               | sven
num_dimensions      | 1
num_chunks          | 0
compression_enabled | f
tablespaces         | NULL

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 s
compression_enabledBOOLEANIs compression enabled on the ?
is_distributedBOOLEAN Sunsetted 2.14.0 Is the distributed?
replication_factorSMALLINT Sunsetted 2.14.0 Replication factor for a distributed
data_nodesTEXT Sunsetted 2.14.0 Nodes on which is distributed
tablespacesTEXTTablespaces attached to the