timescaledb_information.hypertable_columnstore_settings

Since 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.
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.
index	JSONB	The sparse index details.