OB 4.0 OB_SQL_AUDIT逻辑读次数等信息均为0

OceanBase 技术问题
,
#1

【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】5.7.25-OceanBase_CE-v4.0.0.0

做一次表的全表扫描，但是在oceanbase.gv$OB_SQL_AUDIT中看到的DISK_READS，DATA_BLOCK_READ_CNT，DATA_BLOCK_CACHE_HIT等均为0，应该怎么样才能正常显示呢？

obclient [tpch1]> explain extended pretty_color select sum(c_acctbal) from customer where c_comment = 'seq2';
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Plan signature: 10892131842833082527
========================================================
|ID|OPERATOR                 |NAME    |EST. ROWS|COST  |
--------------------------------------------------------
|0 |SCALAR GROUP BY          |        |1        |121388|
|1 | PX COORDINATOR          |        |1        |121388|
|2 |  EXCHANGE OUT DISTR     |:EX10000|1        |121388|
|3 |   MERGE GROUP BY        |        |1        |121387|
|4 |    PX PARTITION ITERATOR|        |2        |121387|
|5 |     TABLE SCAN          |customer|2        |121387|
========================================================

Outputs & filters: 
-------------------------------------
  0 - output([T_FUN_SUM(T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0))(0x7fcad6ca6b10)]), filter(nil), rowset=256, 
      group(nil), agg_func([T_FUN_SUM(T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0))(0x7fcad6ca6b10)])
  1 - output([T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0)]), filter(nil), rowset=256
  2 - output([T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0)]), filter(nil), rowset=256, dop=1
  3 - output([T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0)]), filter(nil), rowset=256, 
      group(nil), agg_func([T_FUN_SUM(customer.c_acctbal(0x7fcad6c3cea0))(0x7fcad6c3c7e0)])
  4 - output([customer.c_acctbal(0x7fcad6c3cea0)]), filter(nil), rowset=256, 
      force partition granule.
  5 - output([customer.c_acctbal(0x7fcad6c3cea0)]), filter([customer.c_comment(0x7fcad6c3c270) = 'seq2'(0x7fcad6c3bb90)]), rowset=256, 
      access([customer.c_comment(0x7fcad6c3c270)], [customer.c_acctbal(0x7fcad6c3cea0)]), partitions(p[0-7]), 
      is_index_back=false, filter_before_indexback[false], 
      range_key([customer.c_custkey(0x7fcad6c3b2e0)]), range(MIN ; MAX)always true

Used Hint:
-------------------------------------
  /*+
  */

Qb name trace:
-------------------------------------
  stmt_id:0, stmt_type:T_EXPLAIN 
  stmt_id:1, SEL$1


Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      GBY_PUSHDOWN(@"SEL$1")
      FULL(@"SEL$1" "tpch1"."customer"@"SEL$1")
      OPTIMIZER_FEATURES_ENABLE('4.0.0.0')
      END_OUTLINE_DATA
  */

Plan Type:
-------------------------------------
DISTRIBUTED

Optimization Info:
-------------------------------------
customer:table_rows:1500000, physical_range_rows:1500000, logical_range_rows:1500000, index_back_rows:0, output_rows:1, est_method:basic_stat, optimization_method=cost_based, avaiable_index_name[customer], pruned_index_name[customer_idx1]


Parameters:
-------------------------------------

 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.002 sec)

obclient [tpch1]> select sum(c_acctbal) from customer where c_comment = 'seq2';
+----------------+
| sum(c_acctbal) |
+----------------+
|           NULL |
+----------------+
1 row in set (0.098 sec)

obclient [tpch1]> select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%' \G
*************************** 1. row ***************************
             QUERY_SQL: explain extended pretty_color select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 0
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 2. row ***************************
             QUERY_SQL: select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
2 rows in set (0.001 sec)
#4

可以给下复现sql么，我这边尝试了一下简单的sql，目前看是正常的，或者说是一个什么样的场景

image
image1290×314 7.16 KB

#5

我那个也是简单SQL，用的tpch的customer表的查询，上面有例子。
我数据库版本用的4.0 的今年发的那个最新版本，不知道是不是最新版本的问题。

#6

我刚才又测试了下，可以了，不知道之前是哪里设置有问题，多谢：

image
image2509×877 85.5 KB

看之前的记录确实没有，后来又执行一次显示可以了：

obclient [tpch]> select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%' \G
*************************** 1. row ***************************
             QUERY_SQL: explain extended pretty_color select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 0
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 2. row ***************************
             QUERY_SQL: select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 3. row ***************************
             QUERY_SQL: select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 2
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
3 rows in set (0.004 sec)

obclient [tpch]> select sum(c_acctbal) from customer where c_comment = 'seq2';
+----------------+
| sum(c_acctbal) |
+----------------+
|           NULL |
+----------------+
1 row in set (3.205 sec)

obclient [tpch]> select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%' \G
*************************** 1. row ***************************
             QUERY_SQL: explain extended pretty_color select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 0
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 2. row ***************************
             QUERY_SQL: select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 3. row ***************************
             QUERY_SQL: select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 2
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 4. row ***************************
             QUERY_SQL: select QUERY_SQL,IS_INNER_SQL,AFFECTED_ROWS,RETURN_ROWS,ROW_CACHE_HIT,BLOOM_FILTER_CACHE_HIT,BLOCK_CACHE_HIT,DISK_READS,TABLE_SCAN,DATA_BLOCK_READ_CNT,DATA_BLOCK_CACHE_HIT,INDEX_BLOCK_READ_CNT,INDEX_BLOCK_CACHE_HIT,BLOCKSCAN_BLOCK_CNT,BLOCKSCAN_ROW_CNT from oceanbase.gv$OB_SQL_AUDIT where QUERY_SQL like '%seq2%'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 3
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 0
            DISK_READS: 0
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 0
  DATA_BLOCK_CACHE_HIT: 0
  INDEX_BLOCK_READ_CNT: 0
 INDEX_BLOCK_CACHE_HIT: 0
   BLOCKSCAN_BLOCK_CNT: 0
     BLOCKSCAN_ROW_CNT: 0
*************************** 5. row ***************************
             QUERY_SQL: select sum(c_acctbal) from customer where c_comment = 'seq2'
          IS_INNER_SQL: 0
         AFFECTED_ROWS: 0
           RETURN_ROWS: 1
         ROW_CACHE_HIT: 0
BLOOM_FILTER_CACHE_HIT: 0
       BLOCK_CACHE_HIT: 72
            DISK_READS: 11659
            TABLE_SCAN: 1
   DATA_BLOCK_READ_CNT: 11680
  DATA_BLOCK_CACHE_HIT: 23
  INDEX_BLOCK_READ_CNT: 52
 INDEX_BLOCK_CACHE_HIT: 49
   BLOCKSCAN_BLOCK_CNT: 11679
     BLOCKSCAN_ROW_CNT: 1499869
5 rows in set (0.003 sec)
#7

如果再出现问题也可以反馈相应问题

#8

好的，多谢！

#9

这个我验证了下，是当语句短时间内多次执行时候，各指标就变为0，像是有缓存查询，但是默认又是关闭的，我并没有开启。
我在4.2版本下的结果：

obclient [oceanbase]> select
    ->   TRACE_ID,
    ->   QUERY_SQL,
    ->   TABLE_SCAN,
    ->   ROW_CACHE_HIT,
    ->   MEMSTORE_READ_ROW_COUNT,
    ->   SSSTORE_READ_ROW_COUNT,
    ->   BLOCK_CACHE_HIT,
    ->   DATA_BLOCK_READ_CNT,
    ->   DATA_BLOCK_CACHE_HIT,
    ->   INDEX_BLOCK_READ_CNT,
    ->   INDEX_BLOCK_CACHE_HIT,
    ->   BLOCKSCAN_BLOCK_CNT,
    ->   BLOCKSCAN_ROW_CNT,
    ->   BLOOM_FILTER_CACHE_HIT,
    ->   DISK_READS,
    ->   PUSHDOWN_STORAGE_FILTER_ROW_CNT
    -> FROM
    ->   oceanbase.GV$OB_SQL_AUDIT
    -> WHERE
    ->   QUERY_SQL LIKE '%test_customer_custkey_all%' and QUERY_SQL not like '%sql_audit%'
    -> ORDER BY
    ->   REQUEST_TIME DESC
    -> LIMIT
    ->   10 \G
*************************** 1. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E8A-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 2. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E7A-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 3. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E68-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 4. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E56-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 5. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E45-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 6. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E34-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 7. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E23-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 8. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5E10-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 9. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5DFE-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 0
                BLOCK_CACHE_HIT: 0
            DATA_BLOCK_READ_CNT: 0
           DATA_BLOCK_CACHE_HIT: 0
           INDEX_BLOCK_READ_CNT: 0
          INDEX_BLOCK_CACHE_HIT: 0
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
*************************** 10. row ***************************
                       TRACE_ID: YB42C0A81FC9-000604DBF12F5DEC-0-0
                      QUERY_SQL: select  /*+ test_customer_custkey_all */ * from tpch10.customer where c_custkey=110000
                     TABLE_SCAN: 0
                  ROW_CACHE_HIT: 0
        MEMSTORE_READ_ROW_COUNT: 0
         SSSTORE_READ_ROW_COUNT: 1
                BLOCK_CACHE_HIT: 2
            DATA_BLOCK_READ_CNT: 1
           DATA_BLOCK_CACHE_HIT: 1
           INDEX_BLOCK_READ_CNT: 2
          INDEX_BLOCK_CACHE_HIT: 1
            BLOCKSCAN_BLOCK_CNT: 0
              BLOCKSCAN_ROW_CNT: 0
         BLOOM_FILTER_CACHE_HIT: 0
                     DISK_READS: 0
PUSHDOWN_STORAGE_FILTER_ROW_CNT: 0
10 rows in set (0.062 sec)

看10. row部分，就是第一次执行时候指标还正常，多次执行后指标都变为0了。