Analyzing Postgres performance problems using perf and eBPF | Citus Con: An Event for Postgres 2022 скачать в хорошем качестве

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. Ever wondered what the cache hit ratio including both Postgres' shared_buffers and the OS page cache is? Whether queries are slow due to data transferred over the network? How much CPU usage is caused by SSL or a Postgres extension? Learn how to answer these and many other questions by watching Andres’s talk in the Americas livestream at Citus Con! 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. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:48 Perf—a Linux kernel profiling tool ⏩ 12:48 bpftrace ⏩ 23:08 pg_stat_statements + BPF ⏩ 25:32 Q&A with Andres & Marco ✅ 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   #CitusCon #PostgreSQL #Database