Note
This view is available starting with V2.2.77.
Purpose
This view displays the workarea information of the current active operator on the current node.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SQL_HASH_VALUE | bigint(0) | NO | The hash value of the executed statement. This value is currently NULL. |
| SQL_ID | varchar(32) | NO | The unique identifier of the SQL statement. |
| SQL_EXEC_START | date | NO | The start time of the SQL statement execution. |
| SQL_EXEC_ID | bigint(20) | NO | The unique identifier of the SQL statement execution. |
| WORKAREA_ADDRESS | varbinary(8) | NO | The address of the workarea. |
| OPERATION_TYPE | varchar(40) | NO | The type of the operator in the workarea. For example, Sort, Hash Join, Group by, and so on. |
| OPERATION_ID | bigint(20) | NO | The unique identifier of the operator in the plan tree. |
| POLICY | varchar(6) | NO | The policy of the workarea:
|
| SID | bigint(20) | NO | The unique identifier of the session. |
| QCINST_ID | bigint(0) | NO | The instance ID of the query coordinator. |
| QCSID | bigint(0) | NO | The session identifier of the query coordinator. |
| ACTIVE_TIME | bigint(20) | NO | The average time when the workarea is active, in milliseconds. |
| WORK_AREA_SIZE | bigint(20) | NO | The maximum value of the workarea used by the operator, in bytes. |
| EXPECT_SIZE | bigint(20) | NO | The expected size of the workarea, in bytes. |
| ACTUAL_MEM_USED | bigint(20) | NO | The amount of memory allocated to the workarea, in bytes. |
| MAX_MEM_USED | bigint(20) | NO | The maximum memory usage of the workarea, in bytes. |
| NUMBER_PASSES | bigint(20) | NO | The mode in which the workarea is running:
|
| TEMPSEG_SIZE | bigint(20) | NO | The size of the temporary space used by the workarea, in bytes. If this value is NULL, no temporary file was written. |
| TABLESPACE | varchar(20) | NO | The table namespace for writing temporary files. If this value is NULL, no temporary file was written. |
| SEGRFNO# | bigint(0) | NO | The number of files related to writing temporary files. NULL indicates that no temporary file was written. |
| SEGBLK# | bigint(0) | NO | The number of blocks used for creating temporary files by the workarea. NULL indicates that no temporary file was written. |
| CON_ID | bigint(20) | NO | The tenant ID |
| SVR_IP | varchar(46) | NO | The IP address of the server |
| SVR_PORT | bigint(20) | NO | The port number of the server |