Timescaledb

timescaledb.md

See table chunks info using chunk_relation_size_pretty function

https://docs.timescale.com/v0.12/api#chunk_relation_size_pretty

SELECT chunk_table, table_size, index_size, total_size FROM chunk_relation_size_pretty('meas_time_data');

Delete chunks from timescale db

https://docs.timescale.com/latest/api#drop_chunks

Drop chunks older than 3 months

SELECT drop_chunks(interval '3 months');