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

> Get information about settings on each chunk in the columnstore

export const CHUNK = 'chunk';

export const HYPERTABLE = 'hypertable';

export const COLUMNSTORE = 'columnstore';

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

<Info>
  `timescaledb_information.chunk_columnstore_settings` replaces `timescaledb_information.chunk_compression_settings`, deprecated in 2.18.0. The columns are the same.
</Info>

Retrieve the compression settings for each {CHUNK} in the {COLUMNSTORE}.

## Samples

To retrieve information about settings:

* **Show settings for all {CHUNK}s in the {COLUMNSTORE}**:

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

  Returns:

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

- **Find all {CHUNK} {COLUMNSTORE} settings for a specific {HYPERTABLE}**:

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

  Returns:

  ```sql theme={"dark"}
  hypertable | chunk | segmentby | orderby
  ------------+-------+-----------+---------
  metrics | _timescaledb_internal._hyper_2_3_chunk | metric_id | "time"
  ```

## Returns

| Name         | Type       | Description                                                                                                              |
| ------------ | ---------- | ------------------------------------------------------------------------------------------------------------------------ |
| `hypertable` | `REGCLASS` | The name of the {HYPERTABLE} in the {COLUMNSTORE}.                                                                       |
| `chunk`      | `REGCLASS` | The name of the {CHUNK} in the `hypertable`.                                                                             |
| `segmentby`  | `TEXT`     | The list of columns used to segment the `hypertable`.                                                                    |
| `orderby`    | `TEXT`     | The list of columns used to order the data in the `hypertable`, along with the ordering and `NULL` ordering information. |
| `index`      | `JSONB`    | The sparse index details.                                                                                                |

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