timescaledb_information.chunk_columnstore_settings

Retrieve the compression settings for each chunk in the columnstore.

To retrieve information about settings:

• Show settings for all chunks in the columnstore:

  SELECT * FROM timescaledb_information.chunk_columnstore_settings

  Copy

  Returns:

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

  Copy

• Find all chunk columnstore settings for a specific hypertable:

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

  Copy

  Returns:

  hypertable | chunk | segmentby | orderby 
  ------------+-------+-----------+---------
  metrics | _timescaledb_internal._hyper_2_3_chunk | metric_id | "time"

  Copy