timescaledb_information.hypertable_columnstore_settings

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

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 |

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`	`TEXT`	The sparse index details.