Available in VPC
This Query History guide describes the interface of the Query History menu and how to view the history of executed queries.
Query History interface
The Query History interface includes the following components:
| Component | Description |
|---|---|
| ① Menu name | Current menu name. |
| ② Basic features | Query History features.
|
| ③ Status filter | You can select the query execution status from the dropdown menu to check the history by status. |
| ④ Search bar | Enter a query to search. |
| ⑤ Execution history | Check the execution history of queries for the past 1 month (see View query execution history). |
View query execution history
To view the query execution history:
- In the VPC environment on the NAVER Cloud Platform console, navigate to
> Services > Big Data & Analytics > Data Query. - Click the Query History menu.
- If necessary, select the status of the query execution history you want to view or enter search keywords in the search bar, then click
.
- The selected status or searched history will be displayed.
- The following describes each item:
Item Description Query Status Reuse (client) Execution start time (UTC+09:00) Run time Data size processed - To view details about the query execution history, click [View details]. The information available in each tab is as follows.
- [Details] tab: You can view detailed information about the query execution (see View details).
- [Execution structure diagram] tab: You can view the execution diagram, execution details, and scan table information for the query (see View execution structure diagram).
View details
Details you can view in the [Details] tab are as follows:
| Type | Information | Description |
|---|---|---|
| Execution information | Execution ID | A unique ID automatically assigned at the time of query execution |
| Reuse status | Whether to reuse results from previous execution when executing queries | |
| Query statement | Executed query content | |
| Status | Query execution status (see View query execution history). | |
| Client type | Type of client that requested the query execution (see View query execution history). | |
| Parameter information | Parameter value used for query execution (see Run query using parameter). | |
| Table information | Catalog | Name of the data source used during the query execution |
| Table | Name of the table used during the query execution | |
| Schema | Name of the database used during the query execution | |
| Execution time information | Creation date and time | Time when the query was created |
| Start date and time | Time when the query execution started | |
| End date and time | Time when the query execution finished | |
| Total execution time | Sum of run time and internal processing time | |
| Waiting time | Time spent waiting from the query request to the start of execution | |
| Planning time | Time spent planning the query | |
| Run time | Query execution time | |
| Scanning time | Time spent scanning data | |
| Execution data information | Output data size | Size of the data output by the query execution |
| Output data count | Number of data output by the query execution | |
| Scanned data size | Size of the data scanned during the query execution | |
| Execution infrastructure information | Maximum memory usage | Maximum amount of memory used during the query execution |
| CPU usage time | Amount of CPU time used during the query execution |
View execution structure diagram
In the [Execution structure diagram] tab, you can click on each stage of the execution structure diagram to view details about the query execution in the stage. The following is the details you can view:
| Type | Information | Description |
|---|---|---|
| Execution information | Stage | The selected step in the execution structure diagram |
| Status | Status of the stage (see View query execution history). | |
| Scanned data size | Size of the data scanned in the stage | |
| Scanned data count | Number of data scanned in the stage | |
| Output data size | Size of the data output in the stage | |
| Output data count | Number of data output in the stage | |
| Maximum memory usage | Maximum memory usage in the stage | |
| Scanning time | Time spent scanning data | |
| Start date and time | Time when the query execution started | |
| End date and time | Time when the query execution finished | |
| Run time | Time when the query execution finished | |
| Waiting time | Time spent waiting from the query request to the start of execution | |
| CPU usage time | CPU time used in the stage | |
| Scanned table information | Table | Catalog and schema information of the table scanned in the stage |
| Column (type) | Properties and data type information of the table scanned in the stage |