Query History
Last updated
Last updated
The query history section contains a log of all the queries run in the query editor. The logs are displayed in a table to get an overview of all past queries, their status, and other metadata for troubleshooting or auditing.
Click Query History in the navigation panel.
The query history will be displayed.
Click any query ID to see more details about the query.
Select the 'Execution Plan' tab to view how the query was run.
Click the Refresh icon to view the latest results.
Click on 'Select entity type' to find multiple filtering options.
Select the entity type.
Type in the entity name in the space provided and then click on Add Filter to add that filter.
Enter the starting characters of the name to search for.
You can remove the filter one at a time by clicking the x icon or remove all the filters by clicking on Clear Filters.
Click 'Last 5 mins' to set a date range to filter results by.
To show/hide columns and change the page size, click the Settings (wheel) icon and select the required page size and columns from the dropdown list.
The number of rows displayed on the Query History dashboard can be customized according to each user's preference by selecting the desired page size.
Users can customize the visibility of columns in the Query History dashboard based on their requirements. Please note that the query ID cannot be hidden by default.
The chosen page size and column preferences will be automatically saved in the user's account for future reference.
Click the Export CSV button to download a CSV file containing the filtered results. All times in the CSV will use the UTC timezone. You can also customize the query history CSV based on column selection and export data for the selected columns only.
The following information is available in the Query History:
Column | Description |
---|---|
Query ID | A unique Query ID of each query that isexecuted. |
Query hash | A unique identity for similar queries. |
Cached Result | The cached result indicates "yes" if the query retrieved results from the cache and "no" otherwise. |
Status |
|
Planning time (sec) | The amount of time taken by the engine to create a plan for the query. |
Queuing time (sec) | The amount of time the query was queued and waited to be run by the engine. |
Execution time (sec) | The amount of time taken to run the query. |
Client percieved time (sec) | The amount of time elapsed from the initiation of a query by the user to the presentation of results or feedback within the user interface. |
Start time | The time the query started running, i.e. started query planning. Displayed in the browser time zone. |
End time | The time the query completed running, i.e. results were provided. Displayed in the browser time zone. |
Cluster | The name of the cluster used to run the query. |
Run by | The username of the user who ran the query. |