timescaledb_information.hypertables

Since 0.1.0

Get metadata information about hypertables.

For more information about using hypertables, including chunk size partitioning, see the hypertable section.

Samples

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       | public
hypertable_name         | metrics
owner                   | sven
num_dimensions          | 1
num_chunks              | 0
compression_enabled     | f
tablespaces             | NULL
primary_dimension       | time
primary_dimension_type  | timestamp with time zone

Returns

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?
tablespaces	TEXT	Tablespaces attached to the hypertable
primary_dimension	TEXT	Name of the primary (time) dimension column
primary_dimension_type	TEXT	Data type of the primary dimension column