Sign in to confirm you’re not a bot
This helps protect our community. Learn more

What I learned creating Postgres monitoring metrics for Citus on Azure | Citus Con 2022

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.1K views 3 years ago #PostgreSQL #CitusCon #Citus
Video of a talk by Sena Gungor at Citus Con: An Event for Postgres. Abstract: PostgreSQL provides many metrics and information with a substantial amount of documentation regarding monitoring. In my work as a developer for the Citus extension to Postgres, and in my collaboration with the engineers who support our managed Postgres service on Azure, I’ve learned that designing monitoring dashboards and monitoring the most necessary metrics can be tricky. In this talk, I will walk you through my own developer journey, as I figured out how to create better monitoring dashboards that keep an eye on what’s happening behind the scenes with the Hyperscale (Citus) database clusters. I’ll cover the details of what I learned about Postgres metrics and Postgres logs that can give you insights about performance, reliability, and security. Sena Gungor is a software engineer on the Postgres team at Microsoft, focused on the Citus extension to Postgres and on  …...more
...more
What I learned creating Postgres monitoring metrics for Citus on Azure | Citus Con 2022
179Likes
2,136Views
2022Apr 12
Video of a talk by Sena Gungor at Citus Con: An Event for Postgres. Abstract: PostgreSQL provides many metrics and information with a substantial amount of documentation regarding monitoring. In my work as a developer for the Citus extension to Postgres, and in my collaboration with the engineers who support our managed Postgres service on Azure, I’ve learned that designing monitoring dashboards and monitoring the most necessary metrics can be tricky. In this talk, I will walk you through my own developer journey, as I figured out how to create better monitoring dashboards that keep an eye on what’s happening behind the scenes with the Hyperscale (Citus) database clusters. I’ll cover the details of what I learned about Postgres metrics and Postgres logs that can give you insights about performance, reliability, and security. Sena Gungor is a software engineer on the Postgres team at Microsoft, focused on the Citus extension to Postgres and on database monitoring tools. Sena earned her B.S. degree in Computer Engineering at METU. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:13 Root cause analysis, alerts, & more ⏩ 02:18 Granularity, constant monitoring, filtering, etc ⏩ 04:31 System resource metrics ⏩ 07:52 Database metrics ⏩ 10:12 Citus-specific metrics ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect: Twitter – @CitusCon,   / cituscon   🔔 Subscribe to the Citus monthly technical newsletter: https://aka.ms/citus-newsletter #CitusCon #PostgreSQL #Citus

Follow along using the transcript.

Microsoft Developer

588K subscribers