目录
查询chunk信息
--查询chunk信息
SELECT chunk_name, range_start, range_end, is_compressed FROM timescaledb_information.chunks
查询已经压缩的chunk
--查询已经压缩的chunk
SELECT chunk_name, is_compressed FROM timescaledb_information.chunks WHERE is_compressed = true
查询chunk的range,compression等信息
--查询chunk的range,compression等信息
SELECT DISTINCT
ch.chunk_name,
ch.hypertable_schema,
ch.hypertable_name,
ch.range_start,
ch.range_end,
ch.is_compressed,
concat (
CAST (
( COALESCE ( ccs.before_compression_total_bytes, NULL, cds.total_bytes ) ) / pow( 1024, 2 ) AS DECIMAL ( 38, 2 )
),
'MB'