DEV Community

loading...

How to see timescale table size

abigoroth profile image Ahmad Ya'kob Ubaidullah ・1 min read

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

pic
Editor guide