SQL Query Optimization Using TimescaleDB Continuous Aggregates

This is the first half of the videos on continuous aggregates. Learn the basics of continuous aggregates, and how to create them. But, note that this is only half of what you need to do to get your continuous aggregates up and running. Make sure to check out the next video on how to set up your continuous aggregate refresh policy! Goodbye, long-running PostgreSQL queries 👋 🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 📌 Watch the full playlist ⇒ https://tsdb.co/getting-started-playlist 📌 Getting started docs ⇒ https://tsdb.co/getting-started-create-cont-aggs 📌 Continuous aggregates docs ⇒ https://tsdb.co/caggs-how-to 📌 Refresh policy docs ⇒ https://tsdb.co/refresh-caggs 🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲 Timescale is the company behind TimescaleDB, the relational database for time-series. With time-series data, developers can understand what is happening right now, how that is changing, and why that is changing. The best way to get TimescaleDB is Timescale Cloud. Try for free today at https://tsdb.co/timescale-cloud. Timescale is a remote-first company with a global workforce and is currently hiring in all departments: https://tsdb.co/timescale-careers 💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲! 🔍 Website ⇒ https://tsdb.co/homepage 🔍 Slack ⇒ https://slack.timescale.com 🔍 GitHub ⇒ https://github.com/timescale 🔍 Twitter ⇒ https://twitter.com/timescaledb 🔍 Twitch ⇒ https://www.twitch.tv/timescaledb 🔍 LinkedIn ⇒ https://www.linkedin.com/company/timescaledb 🔍 Timescale Blog ⇒ https://tsdb.co/blog 🔍 Timescale Documentation ⇒ https://tsdb.co/docs 📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀: ⏱ 0:00 ⇒ Introduction ⏱ 0:59 ⇒ Understanding continuous aggregates ⏱ 6:22 ⇒ Create a continuous aggregate query ⏱ 9:49 ⇒ Create continuous aggregate ⏱ 11:58 ⇒ Outro