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.
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.
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.
8 comments
[ 4.0 ms ] story [ 18.8 ms ] threadNo affiliation, just used it for years and loved how it works, especially when comparing cardinality estimations to actuals, index designs, and general performance characteristics.