3 ms·
Nice, but would be great if it could show it as a Gantt Chart too. The current display shows everything starting at the same time, so doesn’t estimate the tota
by willvarfar 7y ago
Nice, but would be great if it could show it as a Gantt Chart too. The current display shows everything starting at the same time, so doesn’t estimate the total wall clock time.
Now are there similar explainers and visualizers for MySQL and Presto?
- vishesh92 7y agoFor mysql there is https://github.com/Preetam/explain-analyzer https://github.com/Preetam/explain-analyzer haven't tried it myself.
- b2ccb2 7y agoThere is MySQL Workbench, and a collection of Percona tools: https://www.percona.com/blog/2018/03/01/visualize-this-mysql-tools-we-use-to-explain-our-queries/ https://www.percona.com/blog/2018/03/01/visualize-this-mysql...
- pgiraud 7y agoThat's unfortunately impossible to know when a node starts doing some work with the information returned by EXPLAIN.
- willvarfar 7y agoTrue, but showing the critical path puts a lower bound on it, and neatly shows what is serial and what may be parallel