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

hypertableREGCLASSHypertable which has compression enabled
segmentbyTEXTList of columns used for segmenting the compressed data
orderbyTEXTList of columns used for ordering compressed data along with ordering and NULL ordering information
compress_interval_lengthTEXTInterval used for rolling up chunks during compression

Show compression settings for all hypertables:

SELECT * FROM timescaledb_information.hypertable_compression_settings'
hypertable | measurements
segmentby |
orderby | "time" DESC
compress_interval_length |

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"
compress_interval_length |


Found an issue on this page?

Report an issue!