Review query insights #

The Query insights pane shows a list of all active and completed queries processed on all clusters up to the last 30 days. Use query insights to inspect active or completed query execution processes.

Query insights is limited to your current login username’s history unless your current role has the View all query history account-level privilege.

×

View active queries #

Use the Active queries tab to inspect actively running queries and information relevant to the query. The list shows the following columns:

• Status: the status of the query, such as running.
• Query ID: shows the unique identifier for each query; click the ID to open the Query details pane for this query.
• Cluster: is the name of the cluster used to process the query.
• Query text: displays the full or partial SQL text of the query.
• Email: identifies the user who submitted the query.
• Role: specifies the name of the role used by the user when submitting the query.
• Submitted date: uses the browser timezone and shows the start date and time of the query processing.

View and filter completed queries #

Use the Completed queries tab to view completed queries and information relevant to the query. Additionally, you can filter completed queries by a number of categories, such as user role, query text, and date.

To use the filter, expand Show filters. The Date attribute field is fixed and cannot be selected. Click Apply filters to reveal the next filter attribute. In the field, expand the drop down menu, then select an attribute.

You can continue to select attributes individually from the drop-down menu or combine multiple selections with + Add filter.

Click to remove a single filter attribute.

Click Apply filters to update the list based on the selected filter attributes.

Click Reset filters to remove all selected filter attributes and update the list.

Use the filter to display queries according to the filter attributes you choose. By default, queries with the date of Today are displayed. You can filter queries using the following attributes:

• Date: Dates include Today, Yesterday, Last 7 days, Last 30 days, and Custom range. The custom range option is limited to the last 30 days.
• Query text: Search text used in query statements.
• Cluster: Filter by cluster name.
• Catalog: Filter by catalog name.
• Schema: Filter by schema name.
• Table: Filter by table name.
• Email: Filter by username.
• Role: Filter by role name.
• Status: Filter by status; Finished or Failed.

To reorder the query list by column, click a column name to sort by that column. Click the column name again to reverse the sort order. All columns are sortable except Query ID and Query text.

The queries shown in the list are determined by the defined filter. It is not refreshed automatically so recently completed queries may not show up. Click Refresh results to reload queries in the list.

The following columns are displayed:

• Status uses for successfully completed queries, and for failed queries.
• Query ID shows the unique identifier for each query; click the ID to open the Query details.
• Cluster is the name of the cluster used to process the query.
• Query text displays the full or partial SQL text of the query.
• Email identifies the user who submitted the query.
• Cached results indicates whether the result set of the query has been cached.
• Role specifies the name of the role used by the user when submitting the query.
• Create date uses the browser timezone and shows the start date and time of the query processing.
• Elapsed time is the total duration for processing the query.

There is a limit on the number of rows that can be displayed in the query history list for technical reasons related to the size of event records, not the number of queries sent. Accordingly, you might not see a row for every query sent.

Galaxy Telemetry catalog #

A Starburst-managed built-in catalog named galaxy_telemetry provides access to a queryable table containing the last 30 days of your query history.

Query history data is located in the query_history table within the public schema, and available to AWS clusters in the us-east-1 region. New history data is accessible within two hours of query completion.

The catalog is read-only, and available to the accountadmin role. Additional roles can be granted access.

For more details on the galaxy catalog, see Catalogs > Galaxy Telemetry.