Note
This view is available starting with V4.0.0.
Purpose
In parallel execution scenarios, this view displays the execution information for each thread in the current tenant on all OBServer nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SESSION_ID | bigint(20) | NO | For V4.2.x:
|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | Server IP address |
| SVR_PORT | bigint(20) | NO | Server port |
| TRACE_ID | varchar(128) | NO | SQL trace_id |
| QC_ID | bigint(20) | NO | px qc_id |
| SQC_ID | bigint(20) | NO | px sqc_id |
| WORKER_ID | bigint(20) | NO | Thread ID |
| DFO_ID | bigint(20) | NO | px dfo_id |
| START_TIME | timestamp(6) | NO | The time when the thread started running. |
Sample query
Query the execution information for all threads in the current tenant on all OBServer nodes in parallel execution scenarios.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_PX_WORKER_STAT\G
The query result is as follows:
***************** 1. row *****************
SESSION_ID: 3221520411
TENANT_ID: 1002
SVR_IP: 192.xx.xx.xx
SVR_PORT: 19510
TRACE_ID: Y4Cxxxxxxxxxxxxxxxxxxxxxxx-0-0
QC_ID: 1
SQC_ID: 0
WORKER_ID: 0
DFO_ID: 0
START_TIME: 2023-04-23 17:29:17.372461
1 row in set