Query history pane#

Query history pane is accessed in Starburst Insights by using the Query History item on the left-hand navigation.

Insights query history provides access to information about the queries that have been processed on the SEP cluster.

Filters#

Insights provides filters that allow to to choose what data is displayed. These filters are defined at the top of the page. Query attributes can be combined in a single filter with a logical AND. The following attributes are available for use as filters:

  • After date

  • Before date

  • Query text

  • User

  • User group

  • Query ID

  • Status

Completed queries table#

A view of completed queries, located beneath the filters, includes the following columns:

  • Status

  • Query ID

  • Query text

  • User

  • Create date

  • CPU time

  • Elapsed time

Clicking Query ID allows you to access further query details.

Completed queries report#

A report detailing completed queries is accessed using the Reports button on the right.

The Reports view includes the following charts:

  • Top 5 users by queries

  • Top 5 users by CPU time

  • Top 5 users by data read

  • Queries over time

  • Top 5 users by data written

  • Top 5 tables by queries

  • Top 5 clients by queries