加入 Gitee

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

克隆/下载

SUMMARY_STAT_SYS_INDEXES.md 6.44 KB

# SUMMARY\_STAT\_SYS\_INDEXES<a name="ZH-CN_TOPIC_0245374690"></a>

openGauss内汇聚pg\_catalog、information\_schema以及pg\_toast模式中所有系统表的索引状态信息。

**表 1**  SUMMARY\_STAT\_SYS\_INDEXES字段

<a name="zh-cn_topic_0237122586_table9684257144317"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122586_row1977695711431"><th class="cellrowborder" valign="top" width="18.96%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122586_p3776195764317"></a><a name="zh-cn_topic_0237122586_p3776195764317"></a><a name="zh-cn_topic_0237122586_b127761557194312"></a><a name="zh-cn_topic_0237122586_b127761557194312"></a>名称
</th>
<th class="cellrowborder" valign="top" width="17.39%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122586_p10776357134310"></a><a name="zh-cn_topic_0237122586_p10776357134310"></a><a name="zh-cn_topic_0237122586_b15776145711436"></a><a name="zh-cn_topic_0237122586_b15776145711436"></a>类型
</th>
<th class="cellrowborder" valign="top" width="63.65%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122586_p127761257104318"></a><a name="zh-cn_topic_0237122586_p127761257104318"></a><a name="zh-cn_topic_0237122586_b167761357124314"></a><a name="zh-cn_topic_0237122586_b167761357124314"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122586_row1577665734312"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p18776857184311"></a><a name="zh-cn_topic_0237122586_p18776857184311"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p67761572432"></a><a name="zh-cn_topic_0237122586_p67761572432"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p10777195724314"></a><a name="zh-cn_topic_0237122586_p10777195724314"></a>索引中模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122586_row277795764314"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p7777657174319"></a><a name="zh-cn_topic_0237122586_p7777657174319"></a>relname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p877715570432"></a><a name="zh-cn_topic_0237122586_p877715570432"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p9777195754318"></a><a name="zh-cn_topic_0237122586_p9777195754318"></a>索引的表名。
</td>
</tr>
<tr id="zh-cn_topic_0237122586_row16777165754312"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p18777185719438"></a><a name="zh-cn_topic_0237122586_p18777185719438"></a>indexrelname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p1977717573430"></a><a name="zh-cn_topic_0237122586_p1977717573430"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p37771457184316"></a><a name="zh-cn_topic_0237122586_p37771457184316"></a>索引名。
</td>
</tr>
<tr id="zh-cn_topic_0237122586_row127771257174311"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p77771657114314"></a><a name="zh-cn_topic_0237122586_p77771657114314"></a>idx_scan
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p1277775718434"></a><a name="zh-cn_topic_0237122586_p1277775718434"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p12778135774315"></a><a name="zh-cn_topic_0237122586_p12778135774315"></a>索引上开始的索引扫描数。
</td>
</tr>
<tr id="zh-cn_topic_0237122586_row7778185724313"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p10778185744317"></a><a name="zh-cn_topic_0237122586_p10778185744317"></a>idx_tup_read
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p677825711437"></a><a name="zh-cn_topic_0237122586_p677825711437"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p157781157144318"></a><a name="zh-cn_topic_0237122586_p157781157144318"></a>通过索引上扫描返回的索引项数。
</td>
</tr>
<tr id="zh-cn_topic_0237122586_row877845714439"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122586_p777945754314"></a><a name="zh-cn_topic_0237122586_p777945754314"></a>idx_tup_fetch
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122586_p18779105754316"></a><a name="zh-cn_topic_0237122586_p18779105754316"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122586_p1077935734311"></a><a name="zh-cn_topic_0237122586_p1077935734311"></a>通过使用索引的简单索引扫描抓取的活表行数。
</td>
</tr>
</tbody>
</table>

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

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

SUMMARY_STAT_SYS_INDEXES

openGauss内汇聚pg_catalog、information_schema以及pg_toast模式中所有系统表的索引状态信息。

表 1 SUMMARY_STAT_SYS_INDEXES字段

名称	类型	描述
schemaname	name	索引中模式名。
relname	name	索引的表名。
indexrelname	name	索引名。
idx_scan	numeric	索引上开始的索引扫描数。
idx_tup_read	numeric	通过索引上扫描返回的索引项数。
idx_tup_fetch	numeric	通过使用索引的简单索引扫描抓取的活表行数。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.1.0

openGauss / docs

SUMMARY_STAT_SYS_INDEXES

简介

发行版

贡献者

近期动态

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

SUMMARY_STAT_SYS_INDEXES

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs