DEV Community

Ahmad Ya'kob Ubaidullah
Ahmad Ya'kob Ubaidullah

Posted on

How to see timescale table size

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…

SELECT * FROM chunk_relation_size_pretty('my_table');

Pasted_Image_30_11_2020__1_00_PM

Discussion (0)