Insights query details#

Query details are available in Starburst Insights for any query in the Insights query history. Click on a Query ID in the display to access the details for a particular query.

The Query details tab displays either general or advanced information about a specific query, depending on the selected tab. Use the Back button on the top right hand corner of the view to navigate to the query history.

General#

The general view provides higher level information about the query processing.

Query text#

The text area allows you to view the SQL statement as submitted to the SEP cluster for processing. You can copy the text with the copy icon, or maximize the text area with the window icon. You can re-run the query in Worksheets by clicking the >_ icon.

Query details text area

Basic information#

The displayed metadata about the query processing includes the following information:

  • ID

  • User

  • Principal

  • User groups

  • Client

  • Client address

  • CPU time

  • Elapsed time

Query execution#

The Query execution diagram displays performance and timing data about query processing:

Query execution diagram

Cluster resources#

The cluster resources view provides information about the cluster load during the time when the query was queued and executing. Query execution times are influenced by the available resources (CPU, memory), and the number of concurrent queries. This view provides you with the context necessary to interpret query execution data.

Query cluster resources

The charts included in this view are similar to the ones on the cluster history pane. They additionally show the time range when the query ran as a highlighted area on the timeline.

Advanced#

The advanced view provides lower level details about the query processing.

Query details Advanced pane

Tables#

The table shows a list of all tables accessed by the query including the following information:

  • Table

  • Schema

  • Catalog

  • Rows processed

  • Bytes processed

  • Read or write operation

Query plan#

The query plan used for processing the query on the cluster. It can be copied or maximized using the icons.

Execution details#

You can see the following timing and performance details about query processing on the cluster:

  • Elapsed time

  • CPU time

  • Parallelism

  • Active

  • Rows read

  • Bytes read

  • Rows written

  • Bytes written

  • Peak memory