Retrieving Execution Plan Output Using SQreamDB Studio

You may use SQreamDB Studio to create a query plan snapshot to be used for monitoring and troubleshooting slow running statements and for identifying long-running execution Workers (components that process data), that may cause performance issues.

Retrieving Execution Plan Output

You can retrieve the execution plan output either after the query execution has completed, in the case of a hanging query, or if you suspect no progress is being made.

  1. In the Result Panel, select Execution Details View.

    The Execution Tree window opens.

  1. From the upper-right corner, select the icon-download to download a CSV execution plan table.

  1. Save the execution plan on your local machine.

You can analyze this information using Monitoring Query Performance or with assistance from SQreamDB Support.