> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# timescaledb_information.hypertable_compression_settings

> Get information about compression settings for all hypertables

export const CHUNK = 'chunk';

export const HYPERTABLE = 'hypertable';

<Icon icon="tag" iconType="duotone" /> Since [1.5.0][tsdb-1.5.0]

Shows information about compression settings for each {HYPERTABLE} {CHUNK} that has compression enabled on it.

## Samples

Show compression settings for all {HYPERTABLE}s:

```sql theme={"dark"}
SELECT * FROM timescaledb_information.hypertable_compression_settings;
```

```sql theme={"dark"}
hypertable                | measurements
segmentby                 |
orderby                   | time DESC
compress_interval_length  | 7 days
index                     |
```

Find compression settings for a specific {HYPERTABLE}:

```sql theme={"dark"}
SELECT * FROM timescaledb_information.hypertable_compression_settings WHERE hypertable::TEXT LIKE 'metrics';
```

```sql theme={"dark"}
hypertable                | metrics
segmentby                 | metric_id
orderby                   | time DESC
compress_interval_length  | 7 days
index                     |
```

## Available columns

| Name                       | Type       | Description                                                                                         |
| -------------------------- | ---------- | --------------------------------------------------------------------------------------------------- |
| `hypertable`               | `REGCLASS` | Hypertable which has compression enabled                                                            |
| `segmentby`                | `TEXT`     | List of columns used for segmenting the compressed data                                             |
| `orderby`                  | `TEXT`     | List of columns used for ordering compressed data along with ordering and NULL ordering information |
| `compress_interval_length` | `TEXT`     | The compress chunk time interval for the hypertable                                                 |
| `index`                    | `JSONB`    | The compression index configuration                                                                 |

[tsdb-1.5.0]: https://github.com/timescale/timescaledb/releases/tag/1.5.0