GeistHaus
log in · sign up

Visualizing SQL Plan Execution Time With FlameGraphs - Tanel Poder Blog

tanelpoder.com

Update: I wrote a follow-up article about adding Loop Counters and Row Counts to SQL Plan FlameGraphs. I also show some old examples of “Bookshelf Graph” visualizations there. Check it out after reading this post first. Introduction Brendan Gregg invented and popularized a way to profile & visualize program response time by sampling stack traces and using his FlameGraph concept & tools. This technique is a great way for visualizing metrics in nested hierarchies, what stack-based program execution uses under the hood for invoking and tracking function calls. If you don’t know what FlameGraphs are, I suggest you read Brendan’s explanation first. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.

1 page links to this URL