Episode
Analyzing Postgres performance problems using perf and eBPF | Citus Con: An Event for Postgres 2022
In this talk presented at Citus Con: An Event for Postgres, Andres Freund uses a few real-world examples to walk you through the basics of using tools like perf and eBPF for monitoring and ad-hoc analysis in production Postgres environments. Common Postgres and OS-level monitoring tools give you useful information to analyze and prevent some kinds of database performance problems, but often lack sufficient detail. The Perf and eBPF tracing tools allow to gather a lot of the missing details—in some cases cheaply enough to make continuous monitoring feasible.
Andres Freund is a member of the PostgreSQL core team and a long-time PostgreSQL developer. He has worked on many aspects of Postgres, including logical decoding, scalability, pluggable table storage, query execution performance, bug fixing, and patch review. Andres works for Microsoft, doing open source PostgreSQL development.
Recommended resources
- Watch more Citus Con talks on docs.microsoft.com and YouTube
- Everything you need to know about Citus Con: An Event for Postgres can be found here
Connect
- Citus Con | Twitter: @CitusCon
In this talk presented at Citus Con: An Event for Postgres, Andres Freund uses a few real-world examples to walk you through the basics of using tools like perf and eBPF for monitoring and ad-hoc analysis in production Postgres environments. Common Postgres and OS-level monitoring tools give you useful information to analyze and prevent some kinds of database performance problems, but often lack sufficient detail. The Perf and eBPF tracing tools allow to gather a lot of the missing details—in some cases cheaply enough to make continuous monitoring feasible.
Andres Freund is a member of the PostgreSQL core team and a long-time PostgreSQL developer. He has worked on many aspects of Postgres, including logical decoding, scalability, pluggable table storage, query execution performance, bug fixing, and patch review. Andres works for Microsoft, doing open source PostgreSQL development.
Recommended resources
- Watch more Citus Con talks on docs.microsoft.com and YouTube
- Everything you need to know about Citus Con: An Event for Postgres can be found here
Connect
- Citus Con | Twitter: @CitusCon
Have feedback? Submit an issue here.