Analyzing Postgres Performance Problems Using Perf and eBPF

Explore advanced techniques for analyzing Postgres performance issues using perf and eBPF in this 27-minute conference talk from Citus Con: An Event for Postgres 2022. Dive into real-world examples demonstrating how these powerful tools can provide detailed insights for monitoring and ad-hoc analysis in production environments. Learn to gather crucial information often missed by common monitoring tools, including cache hit ratios, network transfer impacts on query speed, and CPU usage from SSL or Postgres extensions. Discover how to leverage perf, a Linux kernel profiling tool, bpftrace, and the combination of pg_stat_statements with BPF to answer complex performance questions. Gain valuable knowledge from Andres Freund, a PostgreSQL core team member and experienced developer, as he shares his expertise in database performance optimization.

Introduction.
Perf—a Linux kernel profiling tool.
bpftrace.
pg_stat_statements + BPF.
Q&A with Andres & Marco.