General concepts: time_bucket() and time_bucket_gapfill() functions

Опубликовано: 04 Март 2026
на канале: Tiger Data (creators of TimescaleDB)
4,697
43

In this episode, Timescale team members Miranda Auhl and David Kohn dive into the time_bucket() and time_bucket_gapfill functions and explore what it is, how to use them, and how it works!

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Hyperfunction API documentation ⇒ https://tsdb.co/gapfilling-interpolation
📌 time_bucket_gapfill() documentation ⇒ https://tsdb.co/time-bucket-gapfill-docs
📌 time_bucket() documentation ⇒ https://tsdb.co/time-bucket-docs

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒   / timescaledb  
🔍 Twitch ⇒   / timescaledb  
🔍 LinkedIn ⇒   / timescaledb  
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introduction
⏱ 4:00 ⇒ time_bucket()
⏱ 41:56 ⇒ time_bucket_ng()
⏱ 58:22 ⇒ outro