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

> Get information about compression settings for all chunks

export const HYPERTABLE = 'hypertable';

export const CHUNK = 'chunk';

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

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

## Samples

Show compression settings for all {CHUNK}s:

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

```sql theme={"dark"}
hypertable               | measurements
chunk                    | _timescaledb_internal._hyper_1_1_chunk
segmentby                |
orderby                  | "time" DESC
```

Find all {CHUNK} compression settings for a specific {HYPERTABLE}:

```sql theme={"dark"}
SELECT * FROM timescaledb_information.chunk_compression_settings WHERE hypertable::TEXT LIKE 'metrics';
hypertable               | metrics
chunk					 | _timescaledb_internal._hyper_2_3_chunk
segmentby                | metric_id
orderby                  | "time"
```

## Returns

| Name         | Type       | Description                                                                                         |
| ------------ | ---------- | --------------------------------------------------------------------------------------------------- |
| `hypertable` | `REGCLASS` | Hypertable which has compression enabled                                                            |
| `chunk`      | `REGCLASS` | Chunk 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 |

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