Insights query history#

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

Insights query history provides access to information about running, queued, completed, and failed queries processed on the SEP cluster.

Filters#

Insights provides filters that allow to to choose what data is displayed:

Query history filters

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

Queries table#

The table of 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.

Clicking Edit in Worksheet for the query text takes you to the Worksheet tab, where you can edit the query as needed, and run it.

Completed queries report#

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

Note

Reports do not include data about running and queued queries.

The Reports pane includes the following charts:

  • Queries over time

  • Top 5 users by CPU time or queries

  • Top 5 users by data read or written

  • Top 5 sources by CPU time or queries

  • Top 5 sources by data read or written

  • Top 5 tables by data read or written

  • Top 5 clients by number of queries

Completed queries report