---
title: timescaledb_information.hypertable_columnstore_settings | Tiger Data Docs
description: Get information about columnstore settings for all hypertables
---

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

`timescaledb_information.hypertable_columnstore_settings` replaces `timescaledb_information.hypertable_compression_settings`, deprecated in 2.18.0. The columns are the same.

Retrieve information about the settings for all hypertables in the columnstore.

## Samples

To retrieve information about settings:

- **Show columnstore settings for all hypertables**:

  ```
  SELECT * FROM timescaledb_information.hypertable_columnstore_settings;
  ```

  Returns:

  ```
  hypertable               | measurements
  segmentby                |
  orderby                  | "time" DESC
  compress_interval_length |
  ```

- **Retrieve columnstore settings for a specific hypertable**:

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

  Returns:

  ```
  hypertable               | metrics
  segmentby                | metric_id
  orderby                  | "time"
  compress_interval_length |
  ```

## Returns

| Name                       | Type       | Description                                                                                                      |
| -------------------------- | ---------- | ---------------------------------------------------------------------------------------------------------------- |
| `hypertable`               | `REGCLASS` | A hypertable which has the [columnstore enabled](/docs/reference/timescaledb/hypercore/alter_table/index.md).    |
| `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 chunks during compression](/docs/build/columnar-storage/setup-hypercore/index.md). |
| `index`                    | `JSONB`    | The sparse index details.                                                                                        |