Note
This view is available starting with V4.0.0.
Purpose
In parallel execution scenarios, this view displays the execution information of each thread for the current tenant on the current OBServer node.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SESSION_ID | bigint(20) | NO | For V4.2.x versions:
|
| TENANT_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 of the server. |
| TRACE_ID | varchar(128) | NO | The trace_id of the SQL statement. |
| QC_ID | bigint(20) | NO | The qc_id in px. |
| SQC_ID | bigint(20) | NO | The sqc_id in px. |
| WORKER_ID | bigint(20) | NO | The thread ID. |
| DFO_ID | bigint(20) | NO | The dfo_id in px. |
| START_TIME | timestamp(6) | NO | The time when the thread starts running. |
Sample query
In the user tenant, query the execution information of all threads for the current tenant on the current OBServer node in parallel execution scenarios.
obclient [oceanbase]> SELECT * FROM oceanbase.V$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