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

Top comments (0)

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More