It now creates three tabs under the 'Explain' panel when executing a query using the Explain Analyze/Explain button from the toolbar of the Query tool.
Graphical --------- -> Graphical Explain Plan
Analysis -------- -> Table to show details of the explain plan analyse. -> Each row represents the statistics per Explain Plan Node -> It may contains columns like node information, exclusive timing (time spent for this explain node excluding the child nodes), inclusive timing, actual rows, plan rows, rowsx (misestimation between planned vs actual rows), loop. -> Background color of exclusive, inclusive, rows changes based on their values. i.e. If Percentage of exclusive, and inclusive timings of total query time is: > 90 - Red Color > 50 - Orange (Between Red & Yellow Color) > 10 - Yellow color
If planner misestimation for the rows is > 1000 times - Red Color > 100 times - Orange (Between Red & Yellow Color) > 10 times - Yellow Color Also - if actual rows <= planned rows then it shows up arrow, else it shows down arrow.
Statistics ---------- -> It contains a HTML table for the statistics per Node Type, and a HTML table for the statistics per table.
