16 ms·
Visualizing SQL Plan Execution Time with FlameGraphs
- trollied 8y agoTanel is a well known expert/authority in Oracle circles. He co-founded Gluent ( https://gluent.com/ https://gluent.com/ ), which is helping to reinvent ETL/data warehousing. See https://gluent.com/products/gluent-data-platform/ https://gluent.com/products/gluent-data-platform/
- hobs 8y agoA great tool in the SQL Server space that helps with this kind of stuff is SentryOne's plan explorer - https://www.sentryone.com/plan-explorer https://www.sentryone.com/plan-explorer 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.
- sgarman 8y agoI'm a big fan of this one: http://tatiyants.com/pev/#/about http://tatiyants.com/pev/#/about
- tanelpoder 8y agoYup it looks cool - I actually mentioned it in my post too with a screenshot.
- rage8885 8y agowhat Oracle client is being used in the screenshot of an Oracle Explain Plan?
- tanelpoder 8y agoHi, 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.
- newman314 8y agoIs there something similar for DB2?
- tanelpoder 8y agoI 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.