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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay