How to see timescale table size

answer re: TimescaleDB's drop_chunks Statement doesn't drop accurate timed chunks

Jan 19 '19

1

Let me clarify Diana's comment: Every chunk is defined by a bounding box; for time, you can think of these as start_time and end_time. If you specify something like:

select drop_chunks(interval '1 hours', 'my_table')

This says to drop all chunks whose end_time is more than 1 hour ago. So…

Open Full Answer

SELECT * FROM chunk_relation_size_pretty('my_table');