Explain plan cost/time visualisation

[sasha-alias]

When analysing long query plans it's often hard to get which part is the most expensive. So adding some formatting and visualisation for EXPLAIN output. So far the development version looks like on a screenshot below. Further ideas are very appreciated

[maury91]

I think the best will be a flowchart like the old SQL programs:

there's a nice library in react to create those flowcharts: https://github.com/projectstorm/react-diagrams

[sasha-alias]

Actually I'm not a big fan of a flowchart representation of explain plan. From my point of view it doesn't help to troubleshoot the things, especially when it comes to complicated queries with dozens of lines. And copy/paste with text works much better then with charts :) So far I added 2 diagrams to the plan nodes: inclusive cost/time and exclusive cost/time. This way it should be easier to identify from the quick look which part of the plan has the issues. Also I've made nodes collapsible, so you are able to hide a part of the plan you are not interested in (line 9 on the picture). And have made some text formatting for easier reading... Work is still in progress

[sasha-alias]

@maury91 thanks for pointing out the react-diagrams library. It looks very promising. I think it can be used for tackling ER Diagrams #20

[sasha-alias]

thanks to @tvondra there will be 2 views for explain plan :) feedback is very appreciated

[tvondra]

So my nagging while drinking beer worked? We need to go for a beer more often!

[sasha-alias]

yeah 🍺 actually being more on devops side I missed the use cases of consulting DBAs, that was useful to hear. @tvondra check this out http://explain.sqltabs.com/

[sasha-alias]

v0.18.0 released