Note
This view is available starting with V4.0.0.
Purpose
In parallel execution scenarios, this view displays the execution information of all tenants on each thread of 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 started running. |
Sample query
In the sys tenant, query the execution information of all threads of all tenants 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: Y4Cxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-0-0
QC_ID: 1
SQC_ID: 0
WORKER_ID: 0
DFO_ID: 0
START_TIME: 2023-04-23 17:29:17.372461
***************** 2. row *****************
SESSION_ID: 3221520410
TENANT_ID: 1004
SVR_IP: 192.xx.xx.xx
SVR_PORT: 19510
TRACE_ID: Y4Cxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-0-0
QC_ID: 1
SQC_ID: 0
WORKER_ID: 0
DFO_ID: 0
START_TIME: 2023-04-23 17:29:15.372461
2 rows in set