timescaledb_information.hypertable_compression_settings

Get information about compression settings for all hypertables

Since 1.5.0

Shows information about compression settings for each hypertable chunk that has compression enabled on it.

​

Samples

Show compression settings for all hypertables:

SELECT * FROM timescaledb_information.hypertable_compression_settings;

hypertable                | measurements
segmentby                 |
orderby                   | time DESC
compress_interval_length  | 7 days
index                     |

Find compression settings for a specific hypertable:

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

hypertable                | metrics
segmentby                 | metric_id
orderby                   | time DESC
compress_interval_length  | 7 days
index                     |

​

Available columns

Name	Type	Description
hypertable	REGCLASS	Hypertable which has compression enabled
segmentby	TEXT	List of columns used for segmenting the compressed data
orderby	TEXT	List of columns used for ordering compressed data along with ordering and NULL ordering information
compress_interval_length	TEXT	The compress chunk time interval for the hypertable
index	JSONB	The compression index configuration