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