Query details pane#

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

The Query details pane 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#

You can view the SQL statement submitted to the SEP cluster for processing, as well as access it in a separate larger dialog and copy the content.

Basic information#

The displayed meta data about the query processing includes the following information:

  • ID

  • User

  • Principal

  • User groups

  • Client

  • Client address

  • CPU time

  • Elapsed time

Query execution#

This graph displays performance and timing data about query processing.

Advanced#

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

Tables#

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

  • Table

  • Schema

  • Catalog

  • Rows

  • Bytes

  • Read or write operation

Query plan#

The query plan used for processing the query on the cluster.

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