timescaledb_information.hypertable_columnstore_settings

Get information about columnstore settings for all hypertables

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

Samples

To retrieve information about settings:

• Show settings for all s:

  SELECT * FROM timescaledb_information.hypertable_columnstore_settings;
  

  Returns:

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

• Retrieve settings for a specific :

  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 which has the 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 s during compression.
index	JSONB	The sparse index details.