News for hackers. Stuff that matters.
Re:Visualizing SQL Plan Execution Time with FlameGraphs by hobs on Friday November 02, 2018 @12:36PM (#18364426)
A 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

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 trollied on Friday November 02, 2018 @12:31PM (#18364367)
Tanel is a well known expert/authority in Oracle circles. He co-founded Gluent ( https://gluent.com/ ), which is helping to reinvent ETL/data warehousing. See https://gluent.com/products/gluent-data-platform/
Re:Visualizing SQL Plan Execution Time with FlameGraphs by sgarman on Friday November 02, 2018 @02:05PM (#18365234)
I'm a big fan of this one: http://tatiyants.com/pev/#/about
Re:Visualizing SQL Plan Execution Time with FlameGraphs by tanelpoder on Friday November 02, 2018 @03:47PM (#18366124)
Yup it looks cool - I actually mentioned it in my post too with a screenshot.
Re:Visualizing SQL Plan Execution Time with FlameGraphs by newman314 on Friday November 02, 2018 @06:59PM (#18367420)
Is there something similar for DB2?
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 rage8885 on Friday November 02, 2018 @03:31PM (#18365992)
what Oracle client is being used in the screenshot of an Oracle Explain Plan?
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.