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: aka.ms/citusco...
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:
Twitter - @CitusCon, / cituscon
🔔 Subscribe to the Citus monthly technical newsletter:
aka.ms/citus-n...
#CitusCon #PostgreSQL #Citus