SingleStore Managed Service

Using Visual Explain

To use Visual Explain, highlight the desired query in the SQL Editor and click the Visual Explain icon to the left of the Run button. The icon resembles a tree. After clicking, you may then choose between EXPLAIN and PROFILE.

At the top-left of the Visual Explain page, you may choose the Actual, Estimated, or Difference options for a given query plan.

At the center of this interface is a tree composed of clickable elements, where each element displayed is a single query plan operation. These are ordered so that the operator at the top of the tree is the one that returns the result to the client.

An alternative method for using Visual Explain is to click the Visual Explain icon in the left sidebar and upload a JSON file that contains a query plan.