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-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
What we have discussed in this episode of 5mins of Postgres:
A Hairy PostgreSQL Incident: https://ardentperf.com/2022/02/10/a-h...
Profiling with perf (Postgres Wiki): https://wiki.postgresql.org/wiki/Prof...
0x.tools by Tanel Poder: https://0x.tools/#cpu-profiling
Tanel Poder on Twitter: / tanelpoder
Jeremy Schneider on Twitter: / jer_s