timescaledb_information.hypertable_columnstore_settings

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

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

⌘I