timescaledb_information.chunk_columnstore_settings

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