How to Debug Slow Queries with Flame Graphs

In this episode of The Software Engineering Podcast, Lucas and Luna dive into the practical use of flame graphs for diagnosing slow database queries. They walk through a real case where a Node.js service was timing out, and how a senior engineer used a flame graph to pinpoint the bottleneck—a missing index that caused a full table scan on a 10-million-row table. The conversation covers when to use flame graphs over traditional EXPLAIN plans, how to read the x-axis and y-axis, and why the 'wide bars' often point to the real culprit. They also discuss open-source tools like Brendan Gregg's FlameGraph and async-profiler, and share tips for integrating flame graphs into your observability stack. If you've ever stared at a slow query log without knowing where to start, this episode gives you a concrete technique to try Monday morning. #FlameGraphs #DatabasePerformance #QueryOptimization #BackendEngineering #NodeJS #PostgreSQL #PerformanceDebugging #Observability #Indexing #OpenSource #SoftwareEngineering #Technology #FexingoBusiness #BusinessPodcast #SQL #Profiling #BrendanGregg #asyncProfiler Keep every episode free: buymeacoffee.com/fexingo