5mins of Postgres E5: Debugging a 100% CPU utilization spike with Postgres EXPLAIN and perf
Today, we’ll take a look at a hairy Postgres incident and how we can use Postgres EXPLAIN and the Linux perf command to debug high CPU utilization in Postgres.
Find the article on our blog here: https://pganalyze.com/blog/5mins-postgres-high-cpu-utilization-explain-plans-linux-perf
*Learn more about pganalyze:*
https://pganalyze.com
https://pganalyze.com/newsletter
https://twitter.com/pganalyze/
What we have discussed in this episode of 5mins of Postgres:
A Hairy PostgreSQL Incident: https://ardentperf.com/2022/02/10/a-hairy-postgresql-incident/
Profiling with perf (Postgres Wiki): https://wiki.postgresql.org/wiki/Profiling_with_perf
0x.tools by Tanel Poder: https://0x.tools/#cpu-profiling
Tanel Poder on Twitter: https://twitter.com/tanelpoder
Jeremy Schneider on Twitter: https://twitter.com/jer_s
Comments are closed.