---
title: timescaledb_information.hypertables | Tiger Data Docs
description: Get metadata about hypertables
---

Since [0.1.0](https://github.com/timescale/timescaledb/releases/tag/0.1.0)

Get metadata information about hypertables.

For more information about using hypertables, including chunk size partitioning, see the [hypertable section](/docs/learn/hypertables/understand-hypertables/index.md).

## 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   |