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

> Get information about columnstore settings for all hypertables

export const HYPERTABLE = 'hypertable';

export const COLUMNSTORE = 'columnstore';

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

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

Retrieve information about the settings for all {HYPERTABLE}s in the {COLUMNSTORE}.

## Samples

To retrieve information about settings:

* **Show {COLUMNSTORE} settings for all {HYPERTABLE}s**:

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

  Returns:

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

* **Retrieve {COLUMNSTORE} settings for a specific {HYPERTABLE}**:

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

  Returns:

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

## Returns

| Name                       | Type       | Description                                                                                |
| -------------------------- | ---------- | ------------------------------------------------------------------------------------------ |
| `hypertable`               | `REGCLASS` | A {HYPERTABLE} which has the [{COLUMNSTORE} enabled][compression_alter-table].             |
| `segmentby`                | `TEXT`     | The list of columns used to segment data.                                                  |
| `orderby`                  | `TEXT`     | List of columns used to order the data, along with ordering and NULL ordering information. |
| `compress_interval_length` | `TEXT`     | Interval used for [rolling up {CHUNK}s during compression][rollup-compression].            |
| `index`                    | `JSONB`    | The sparse index details.                                                                  |

[compression_alter-table]: /api-reference/timescaledb/hypercore/alter_table

[rollup-compression]: /manage-data/capabilities/compression/manual-compression/#roll-up-uncompressed-chunks-when-compressing

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