timescaledb_information.chunk_compression_settings

Get information about compression settings for all chunks

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

Samples

Show compression settings for all s:

SELECT * FROM timescaledb_information.chunk_compression_settings'
hypertable               | measurements
chunk					 | _timescaledb_internal._hyper_1_1_chunk
segmentby                |
orderby                  | "time" DESC

Find all compression settings for a specific :

SELECT * FROM timescaledb_information.chunk_compression_settings WHERE hypertable::TEXT LIKE 'metrics';
hypertable               | metrics
chunk					 | _timescaledb_internal._hyper_2_3_chunk
segmentby                | metric_id
orderby                  | "time"

Arguments

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Hypertable which has compression enabled
chunk	REGCLASS	-	✔	Chunk 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