Note
This view is available starting with V4.2.0.
Purpose
This view dynamically displays information about the execution of join filters on the current OBServer node for each tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| QC_SESSION_ID | bigint(0) | NO | The QC (Query Coordinator) session ID of the parallel query cursor. For V4.2.x:
|
| QC_INSTANCE_ID | bigint(0) | NO | The QC (Query Coordinator) instance ID of the parallel query cursor. |
| SQL_PLAN_HASH_VALUE | bigint(0) | NO | The hash value of the SQL plan of the parallel query cursor. |
| FILTER_ID | bigint(20) | NO | The ID that identifies the join filter in the cursor. This ID corresponds to the filter ID in the execution plan. |
| BITS_SET | bigint(0) | NO | The size of the bitmap (join bitmap) used in the BLOOM_FILTER. This field is used only for compatibility in the current version. |
| FILTERED | bigint(20) | NO | The number of rows processed by the join filter. |
| PROBED | bigint(20) | NO | The total number of rows in the right table that have passed the bitmap filter test. This includes both filtered and unfiltered rows. |
| ACTIVE | bigint(0) | NO | Indicates whether the filter is active (YES) or inactive (NO). |
| CON_ID | bigint(20) | NO | The ID of the container to which the data belongs. |
| TRACE_ID | varchar(64) | NO | The trace ID corresponding to the SQL statement. |
Sample query
In the sys tenant, query the information about the Join Filter execution of each tenant on the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$SQL_JOIN_FILTER LIMIT 10;
The query result is as follows:
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------+
| SVR_IP | SVR_PORT | QC_SESSION_ID | QC_INSTANCE_ID | SQL_PLAN_HASH_VALUE | FILTER_ID | BITS_SET | FILTERED | PROBED | ACTIVE | CON_ID | TRACE_ID |
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------+
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1002 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1002 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1002 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2509 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2530 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2504 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------+
10 rows in set