Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
This view displays the real-time execution information about join filters on all OBServer nodes in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| QC_SESSION_ID | NUMBER | NO | The query coordinator (QC) session ID of the given cursor for a parallel query. For V4.3.x:
|
| QC_INSTANCE_ID | NUMBER | NO | The QC instance ID of the given cursor for the parallel query. |
| SQL_PLAN_HASH_VALUE | NUMBER | NO | The hash value of the SQL plan of the cursor for the given parallel query. |
| FILTER_ID | NUMBER | NO | The ID of the connection filter in the given cursor. This ID corresponds to the filter ID in the execution plan. |
| BITS_SET | NUMBER | NO | The size of the bitmap for the Bloom filter. In the current version of OceanBase Database, this column is used only for compatibility. |
| FILTERED | NUMBER | NO | The number of rows processed by the connection filter. |
| PROBED | NUMBER | NO | The number of rows in the right-side table that have been tested by using the bitmap filter. Here, the value is the sum of filtered and unfiltered rows. |
| ACTIVE | NUMBER | NO | Indicates whether the filter is active. |
| CON_ID | NUMBER | NO | The ID of the data container. |
| TRACE_ID | CHAR(64) | NO | The trace ID of the SQL statement. |
Sample query
Query execution-related information about join filters in the current user tenant.
obclient [SYS]> SELECT * FROM SYS.GV$SQL_JOIN_FILTER;
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 | 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 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2457 | NULL | 1004 | y70***************************-0-0 |
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------------------------------------+
8 rows in set