--- title: "OBKV-Table 监控指标 - OceanBase 数据库 V4.4.1 | OceanBase 文档中心" description: "OBKV-Table 监控指标 统计信息 可以通过以下示例查询 OBKV-Table 相关的监控指标，指标 ID（190000，190800）。 MySQL [oceanbase]> SELECT distinct class,stat_id,name, value FROM gv$sysstat WHERE sta…" image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库KV 型 - V 4.4.1 # OBKV-Table 监控指标 更新时间：2026-01-25 12:06:40 [编辑](https://github.com/oceanbase/oceanbase-kv/edit/V4.4.1/zh-CN/100.obkv-table/210.obkv-table-manage/200.obkv-table-monitor-items.md) ## 统计信息 可以通过以下示例查询 OBKV-Table 相关的监控指标，指标 ID（190000，190800）。 ```sql MySQL [oceanbase]> SELECT distinct class,stat_id,name, value FROM gv$sysstat WHERE stat_id > 190000 AND stat_id < 190800; ``` 返回结果如下。 ```shell +-------+---------+---------------------------------------+------------+ | 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 操作的总行数 | 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线