Query History

This page explains how to view, manage, and track past queries executed in the e6data Query Editor.

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.

Viewing Query History

1. Click Query History in the navigation panel.

2. Choose the cluster you want to view the query history for. Without selecting a cluster, the query history will not be displayed.

3. The query history will be displayed.

4. Click any query ID to see more details about the query.

   • Select the 'Execution Plan' tab to view how the query was run.

5. Click the Refresh icon to view the latest results.

Query History

Viewing a query

Viewing query execution plan

Filtering Query History

1. Click on 'Select entity type' to find multiple filtering options.

2. Select the entity type.

3. 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.

4. You can remove the filter one at a time by clicking the x icon or remove all the filters by clicking on Clear Filters.

5. Click 'Last 5 mins' to set a date range to filter results by.

Customizing Query History View

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.

Prefrences

Export Query History

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.

Column filter

Query Information

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	The status of the query. There are five possible statuses: SUCCESS FAILED RUNNING TIMEOUT PARSING FAILED CANCELLED
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.

Query History Walkthrough