Get metadata information about hypertables.
For more information about using hypertables, including chunk size partitioning, see the hypertable section.
| 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 |
Get information about a hypertable.
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 | publichypertable_name | metricsowner | svennum_dimensions | 1num_chunks | 0compression_enabled | ftablespaces | NULL
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.