Timescaledb: Get chunk time interval

[vanwalj]

Hello !

Is there any way to get an existing chunk time interval and the current chunk time interval ?

thanks !

[mfreed]

Please see http://docs.timescale.com/latest/api#chunk_relation_size_pretty. E.g.

SELECT chunk_table, partitioning_columns, ranges FROM chunk_relation_size_pretty('<HYPERTABLE NAME>');

[vanwalj]

Perfect, it worked, thanks :)

[jianhaiqing]

If the hypertable is created just, we still can't get the chunk time.

[bboule]

@jianhaiqing if you run SELECT * FROM chunk_relation_size_pretty('cpu'); w4and sub cpu for the name of your hypertable you will get the chunk ranges... have you tried that?

[shane-axiom]

In 2.x you want

SELECT * FROM timescaledb_information.chunks;