timescaledb_information.hypertable_columnstore_settings

检索列式存储中所有超表的设置信息。

检索设置信息

• 显示所有超表的列式存储设置:

  SELECT * FROM timescaledb_information.hypertable_columnstore_settings;

  复制

  返回值

  hypertable               | measurements
  segmentby                | 
  orderby                  | "time" DESC
  compress_interval_length |

  复制

• 检索特定超表的列式存储设置:

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

  复制

  返回值

  hypertable               | metrics
  segmentby                | metric_id 
  orderby                  | "time" 
  compress_interval_length |

  复制