OBKV-Table 监控指标 - OceanBase 数据库 V4.4.1

OBKV-Table 监控指标

更新时间：2026-01-25 12:06:40

统计信息

可以通过以下示例查询 OBKV-Table 相关的监控指标，指标 ID（190000，190800）。

MySQL [oceanbase]> SELECT distinct class,stat_id,name, value FROM gv$sysstat WHERE stat_id > 190000 AND stat_id < 190800;

返回结果如下。

+-------+---------+---------------------------------------+------------+
| class | stat_id | name                                  | value_type |
+-------+---------+---------------------------------------+------------+
|  4096 |  190001 | single retrieve execute count         | ADD_VALUE  |
|  4096 |  190002 | single retrieve execute time          | ADD_VALUE  |
|  4096 |  190003 | multi retrieve execute count          | ADD_VALUE  |
|  4096 |  190004 | multi retrieve execute time           | ADD_VALUE  |
|  4096 |  190005 | multi retrieve rows                   | ADD_VALUE  |
|  4096 |  190101 | single insert execute count           | ADD_VALUE  |
|  4096 |  190102 | single insert execute time            | ADD_VALUE  |
|  4096 |  190103 | multi insert execute count            | ADD_VALUE  |
|  4096 |  190104 | multi insert execute time             | ADD_VALUE  |
|  4096 |  190105 | multi insert rows                     | ADD_VALUE  |
|  4096 |  190201 | single delete execute count           | ADD_VALUE  |
|  4096 |  190202 | single delete execute time            | ADD_VALUE  |
|  4096 |  190203 | multi delete execute count            | ADD_VALUE  |
|  4096 |  190204 | multi delete execute time             | ADD_VALUE  |
|  4096 |  190205 | multi delete rows                     | ADD_VALUE  |
|  4096 |  190301 | single update execute count           | ADD_VALUE  |
|  4096 |  190302 | single update execute time            | ADD_VALUE  |
|  4096 |  190303 | multi update execute count            | ADD_VALUE  |
|  4096 |  190304 | multi update execute time             | ADD_VALUE  |
|  4096 |  190305 | multi update rows                     | ADD_VALUE  |
|  4096 |  190401 | single insert_or_update execute count | ADD_VALUE  |
|  4096 |  190402 | single insert_or_update execute time  | ADD_VALUE  |
|  4096 |  190403 | multi insert_or_update execute count  | ADD_VALUE  |
|  4096 |  190404 | multi insert_or_update execute time   | ADD_VALUE  |
|  4096 |  190405 | multi insert_or_update rows           | ADD_VALUE  |
|  4096 |  190501 | single replace execute count          | ADD_VALUE  |
|  4096 |  190502 | single replace execute time           | ADD_VALUE  |
|  4096 |  190503 | multi replace execute count           | ADD_VALUE  |
|  4096 |  190504 | multi replace execute time            | ADD_VALUE  |
|  4096 |  190505 | multi replace rows                    | ADD_VALUE  |
|  4096 |  190601 | batch retrieve execute count          | ADD_VALUE  |
|  4096 |  190602 | batch retrieve execute time           | ADD_VALUE  |
|  4096 |  190603 | batch retrieve rows                   | ADD_VALUE  |
|  4096 |  190701 | batch hybrid execute count            | ADD_VALUE  |
|  4096 |  190702 | batch hybrid execute time             | ADD_VALUE  |
|  4096 |  190707 | batch hybrid insert_or_update rows    | ADD_VALUE  |
+-------+---------+---------------------------------------+------------+

Name 中 Batch 和 Multi 语义的区别如下：

Multi 指同一类单操作的 Batch。
Batch Scan, 多个 Scan 的 Batch。
Batch Hybird, 混合 batch, 比如不同类单操作的 Batch。

具体参数说明如下：

Name	描述
single retrieve execute count	get 的执行次数
single retrieve execute time	get 的执行总耗时
multi retrieve execute count	multi get 的执行次数
multi retrieve execute time	multi get 的执行总耗时
multi retrieve rows	multi get 操作的总行数
single insert execute count	insert 的执行次数
single insert execute time	insert 的执行总耗时
multi insert execute count	multi insert 的执行次数
multi insert execute time	multi insert 的执行总耗时
multi insert rows	multi insert 操作的总行数
single delete execute count	delete 的执行次数
single delete execute time	delete 的执行总耗时
multi delete execute count	multi delete 的执行次数
multi delete execute time	multi delete 的执行总耗时
multi delete rows	multi delete 操作的总行数
single update execute count	update 的执行次数
single update execute time	update 的执行总耗时
multi update execute count	multi update 的执行次数
multi update execute time	multi update 的执行总耗时
multi update rows	multi update 操作的总行数
single insert_or_update execute count	insert_or_update 的执行次数
single insert_or_update execute time	insert_or_update的执行总耗时
multi insert_or_update execute count	multi insert_or_update 的执行次数
multi insert_or_update execute time	multi insert_or_update 的执行总耗时
multi insert_or_update rows	multi insert_or_update 操作的总行数
single replace execute count	replace 的执行次数
single replace execute time	replace 的执行总耗时
multi replace execute count	multi replace 的执行次数
multi replace execute time	multi replace 的执行总耗时
multi replace rows	multi replace 操作的总行数
batch retrieve execute count	Batch Scan 的执行次数
batch retrieve execute time	Batch Scan 的执行总耗时
batch retrieve rows	Batch Scan 操作的总行数
batch hybrid execute count	混合 batch 的执行次数
batch hybrid execute time	混合 batch 的执行总耗时
batch hybrid insert_or_update rows	混合 batch 操作的总行数