OceanBase 實時執(zhí)行計劃展示

obclient>VIEW_DEFINITION='SELECT * 
                 FROM oceanbase.gv$plan_cache_plan_explain
                 WHERE IP =host_ip() AND PORT = rpc_port()'

obclient>SELECT * FROM v$plan_cache_plan_stat  WHERE tenant_id= 1001 
                                AND STATEMENT LIKE 'INSERT INTO T1 VALUES%'\G

***************************1. row ***************************
       tenant_id: 1001
          svr_ip:100.81.152.44
        svr_port:15212
         plan_id: 7
          sql_id:0
            type: 1
       statement: insert into t1 values(1)
       plan_hash:1
last_active_time:2016-05-28 19:08:57.416670
    avg_exe_usec:0
slowest_exe_time:1970-01-01 08:00:00.000000
slowest_exe_usec:0
      slow_count:0
       hit_count:0
        mem_used:8192
1 rowin set (0.01 sec)

注意 
這里展示的計劃為物理執(zhí)行計劃，在算子命名上會與 EXPLAIN 所展示的邏輯執(zhí)行計劃有所不同。

obclient>SELECT * FROM v$plan_cache_plan_explain
           WHERE tenant_id = 1001 AND plan_id = 7;
                            
+-----------+---------------+-------+---------+--------------------+------+------+------+
| TENANT_ID | IP            | PORT  | PLAN_ID | OPERATOR           | NAME | ROWS | COST |
+-----------+---------------+-------+---------+--------------------+------+------+------+
|      1001 | 100.81.152.44 | 15212 |       7 |  PHY_ROOT_TRANSMIT | NULL |    0 |    0 |
|      1001 | 100.81.152.44 | 15212 |       7 |   PHY_INSERT       | NULL |    0 |    0 |
|      1001 | 100.81.152.44 | 15212 |       7 |    PHY_EXPR_VALUES | NULL |    0 |    0 |
+-----------+---------------+-------+---------+--------------------+------+------+------+
3 rows in set (0.01 sec)

注意 
如果訪問 gv$plan_cache_plan_explain，必須給定 IP、port、tenant_id 和 plan_id 這四列的值。
如果訪問 v$plan_cache_plan_explain，必須給定 tenant_id 和 plan_id 的值，否則系統(tǒng)將返回空集。