加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

SUMMARY_STATIO_ALL_INDEXES.md 5.53 KB

# SUMMARY\_STATIO\_ALL\_INDEXES<a name="ZH-CN_TOPIC_0245374795"></a>

SUMMARY\_STATIO\_ALL\_INDEXES视图包含含openGauss内汇聚的数据库中的每个索引行， 显示特定索引的I/O的统计。

<a name="zh-cn_topic_0237122691_table9322152172514"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122691_row10388102119256"><th class="cellrowborder" valign="top" width="18.96%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122691_p6389121162512"></a><a name="zh-cn_topic_0237122691_p6389121162512"></a><a name="zh-cn_topic_0237122691_b5389182115253"></a><a name="zh-cn_topic_0237122691_b5389182115253"></a>名称
</th>
<th class="cellrowborder" valign="top" width="17.39%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122691_p5389122162514"></a><a name="zh-cn_topic_0237122691_p5389122162514"></a><a name="zh-cn_topic_0237122691_b1538992142514"></a><a name="zh-cn_topic_0237122691_b1538992142514"></a>类型
</th>
<th class="cellrowborder" valign="top" width="63.65%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122691_p12389521192515"></a><a name="zh-cn_topic_0237122691_p12389521192515"></a><a name="zh-cn_topic_0237122691_b19389721202513"></a><a name="zh-cn_topic_0237122691_b19389721202513"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122691_row10389162122514"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122691_p9389721172518"></a><a name="zh-cn_topic_0237122691_p9389721172518"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122691_p93900215258"></a><a name="zh-cn_topic_0237122691_p93900215258"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122691_p139042111253"></a><a name="zh-cn_topic_0237122691_p139042111253"></a>该索引的模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122691_row12390102132518"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122691_p339017219251"></a><a name="zh-cn_topic_0237122691_p339017219251"></a>relname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122691_p1239011219251"></a><a name="zh-cn_topic_0237122691_p1239011219251"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122691_p1839022112511"></a><a name="zh-cn_topic_0237122691_p1839022112511"></a>该索引的表名。
</td>
</tr>
<tr id="zh-cn_topic_0237122691_row6390721192519"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122691_p163909213254"></a><a name="zh-cn_topic_0237122691_p163909213254"></a>indexrelname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122691_p2039122111255"></a><a name="zh-cn_topic_0237122691_p2039122111255"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122691_p3391321112514"></a><a name="zh-cn_topic_0237122691_p3391321112514"></a>索引名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122691_row18391102162513"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122691_p1539112110259"></a><a name="zh-cn_topic_0237122691_p1539112110259"></a>idx_blks_read
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122691_p439132114259"></a><a name="zh-cn_topic_0237122691_p439132114259"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122691_p339152119251"></a><a name="zh-cn_topic_0237122691_p339152119251"></a>从索引中读取的磁盘块数。
</td>
</tr>
<tr id="zh-cn_topic_0237122691_row19391142102513"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122691_p83911021132520"></a><a name="zh-cn_topic_0237122691_p83911021132520"></a>idx_blks_hit
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122691_p143911021162515"></a><a name="zh-cn_topic_0237122691_p143911021162515"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122691_p2039111211255"></a><a name="zh-cn_topic_0237122691_p2039111211255"></a>索引命中缓存数。
</td>
</tr>
</tbody>
</table>

一键复制编辑原始数据按行查看历史

提交于 2020-08-12 11:20 . Delete monitor administrator

SUMMARY_STATIO_ALL_INDEXES

SUMMARY_STATIO_ALL_INDEXES视图包含含openGauss内汇聚的数据库中的每个索引行，显示特定索引的I/O的统计。

名称	类型	描述
schemaname	name	该索引的模式名。
relname	name	该索引的表名。
indexrelname	name	索引名称。
idx_blks_read	numeric	从索引中读取的磁盘块数。
idx_blks_hit	numeric	索引命中缓存数。

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

2.0.0

openGauss / docs

SUMMARY_STATIO_ALL_INDEXES

简介

发行版

贡献者

近期动态

openGauss / docs .gitee-modal { width: 500px !important; }

SUMMARY_STATIO_ALL_INDEXES

简介

发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

贡献者

近期动态

搜索帮助

openGauss / docs