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.
Use the Active queries tab to inspect actively running queries and information relevant to the query. The list shows the following columns:
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:
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:
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.
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.
Is the information on this page helpful?
Yes
No