---
title: timescaledb_information.chunk_columnstore_settings | Tiger Data Docs
description: Get information about settings on each chunk in the columnstore
---

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

`timescaledb_information.chunk_columnstore_settings` replaces `timescaledb_information.chunk_compression_settings`, deprecated in 2.18.0. The columns are the same.

Retrieve the compression settings for each chunk in the columnstore.

## Samples

To retrieve information about settings:

- **Show settings for all chunks in the columnstore**:

  ```
  SELECT * FROM timescaledb_information.chunk_columnstore_settings
  ```

  Returns:

  ```
  hypertable | chunk | segmentby | orderby
  ------------+-------+-----------+---------
  measurements | _timescaledb_internal._hyper_1_1_chunk| | "time" DESC
  ```

* **Find all chunk columnstore settings for a specific hypertable**:

  ```
  SELECT *
  FROM timescaledb_information.chunk_columnstore_settings
  WHERE hypertable::TEXT LIKE 'metrics';
  ```

  Returns:

  ```
  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.                                                                                                |