timescaledb_information.chunk_columnstore_settings

Get information about settings on each chunk in the columnstore

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 in the .

Samples

To retrieve information about settings:

• Show settings for all s in the :

  SELECT * FROM timescaledb_information.chunk_columnstore_settings
  

  Returns:

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

• Find all settings for a specific :

  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 in the .
chunk	REGCLASS	The name of the 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.