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 operator type of 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 Workarea strategy. Valid values:
|
| 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 that 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 size of the requested 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 runs:
|
| 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 to create 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 |