timescaledb_information.chunk_columnstore_settings

检索列式存储中每个分块的压缩设置。

检索设置信息

• 显示列式存储中所有分块的设置:

  SELECT * FROM timescaledb_information.chunk_columnstore_settings

  复制

  返回

  hypertable | chunk | segmentby | orderby 
  ------------+-------+-----------+---------    
  measurements | _timescaledb_internal._hyper_1_1_chunk| | "time" DESC

  复制

• 查找特定超表的所有分块列式存储设置:

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

  复制

  返回

  hypertable | chunk | segmentby | orderby 
  ------------+-------+-----------+---------
  metrics | _timescaledb_internal._hyper_2_3_chunk | metric_id | "time"

  复制