No affiliation, just used it for years and loved how it works, especially when comparing cardinality estimations to actuals, index designs, and general performance characteristics.
Re:Visualizing SQL Plan Execution Time with FlameGraphs
by tanelpoder on Friday November 02, 2018 @08:45PM
(#18367959)
I only applied this on Oracle, not too familiar with with DB2, but as long as DB2 has a (text) tool that reports exec plan node level metrics, this can be converted into a flame chart.
Re:Visualizing SQL Plan Execution Time with FlameGraphs
by tanelpoder on Friday November 02, 2018 @03:45PM
(#18366110)
Hi, it's using Oracle's default client sqlplus for extracting data and spool it in flamegraph.pl-friendly format to disk. And then the script runs flamegraph.pl to turn this data into a .svg chart and opens it with your default browser.
No affiliation, just used it for years and loved how it works, especially when comparing cardinality estimations to actuals, index designs, and general performance characteristics.