5 (Powerful) PostgreSQL functions for Monitoring and Analytics

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!

About the speaker

Avthar Sewrathan

Developer Advocate @ Timescale

Avthar is passionate about empowering people through technology. That's why he loves being a Developer Advocate at Timescale, where he helps engineers leverage the power of time-series data to analyze the past, monitor the present, and predict and plan for the future.

Originally from a small town in South Africa, Avthar lived in Costa Rica before earning a CS degree from Princeton University. He previously co-founded a crypto-enabled social network that gave people more privacy and control over their data.

He's also fanatical about learning how to learn, the journey of mastery and how we can all be our best selves.