PostgreSQL is ideal for real-time monitoring and historical analysis, partially due to its support for full SQL: the expressive and extensively documented king of query languages. But, it can take awhile to get the hang of writing efficient, readable queries for common monitoring and analysis tasks.

Join Avthar Sewrathan, Timescale Developer Advocate and time-series pro, to learn how to write 5 simple, efficient queries that give you more insight from your data - whether you’re monitoring real-time changes in your systems or analyzing historical data to look for patterns.

In this demo-packed session, he’ll draw on his own experiences, recommendations from TimescaleDB’s PostgreSQL extension developers, and advice from Timescale community members. You’ll get the detailed, practical guidance you need to take your monitoring and analytical queries to the next level.

During the session you’ll:

• Learn essential PostgreSQL functions and build queries for common monitoring scenarios, such as calculating deltas and rates
• Use special TimescaleDB SQL functions to simplify time-series analysis for scenarios like filling gaps in data and examining metrics over arbitrary time intervals
• Hear best practices and guidance that you can customize for your projects
• Ask questions and get advice from Timescale technical experts
• Get technical resources to apply what you learn

We’ll focus on code and step-by-step demos, using a real world example and time-series dataset, and we’ll have experts on hand to answer your questions.

Sign up even if you’re unable to attend live - you’ll receive the recording, resources, and demos shortly afterwards.

Our goal: make sure you’re well-equipped to continue your journey to PostgreSQL mastery 🎉

We hope to see you soon!