Note
This view is available starting with V2.2.77.
Purpose
This view displays the Workarea information of the current active Operator on all nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SQL_HASH_VALUE | bigint(0) | NO | The hash value of the executed statement. This value is NULL. |
| SQL_ID | varchar(32) | NO | The unique identifier of the SQL statement. |
| SQL_EXEC_START | date | NO | The time when the SQL statement started to be executed. |
| SQL_EXEC_ID | bigint(20) | NO | The unique identifier of the SQL 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, and Group by. |
| OPERATION_ID | bigint(20) | NO | The unique identifier of the operator in the plan tree. |
| POLICY | varchar(6) | NO | The strategy 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 ID of the query coordinator. |
| ACTIVE_TIME | bigint(20) | NO | The average time when the Workarea is active, in ms. |
| 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 is written. |
| TABLESPACE | varchar(20) | NO | The table namespace where the temporary file is written. If this value is NULL, no temporary file is written. |
| SEGRFNO# | bigint(0) | NO | The number of files related to the writing of the temporary file. NULL indicates that no temporary file is written. |
| SEGBLK# | bigint(0) | NO | The number of blocks used to create the temporary file by the Workarea. NULL indicates that no temporary file is 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. |