加入 Gitee

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

克隆/下载

SUMMARY_STAT_XACT_SYS_TABLES.md 9.33 KB

# SUMMARY\_STAT\_XACT\_SYS\_TABLES<a name="ZH-CN_TOPIC_0245374708"></a>

显示openGauss内汇聚的命名空间中系统表的事务状态信息。

**表 1**  SUMMARY\_STAT\_XACT\_SYS\_TABLES字段

<a name="zh-cn_topic_0237122604_table157278311218"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122604_row138291831027"><th class="cellrowborder" valign="top" width="18.96%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122604_p88299311215"></a><a name="zh-cn_topic_0237122604_p88299311215"></a><a name="zh-cn_topic_0237122604_b3829153328"></a><a name="zh-cn_topic_0237122604_b3829153328"></a>名称
</th>
<th class="cellrowborder" valign="top" width="17.39%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122604_p882912312214"></a><a name="zh-cn_topic_0237122604_p882912312214"></a><a name="zh-cn_topic_0237122604_b88300318217"></a><a name="zh-cn_topic_0237122604_b88300318217"></a>类型
</th>
<th class="cellrowborder" valign="top" width="63.65%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122604_p383017314212"></a><a name="zh-cn_topic_0237122604_p383017314212"></a><a name="zh-cn_topic_0237122604_b148308310219"></a><a name="zh-cn_topic_0237122604_b148308310219"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122604_row19830232029"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p58301030211"></a><a name="zh-cn_topic_0237122604_p58301030211"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p3830631425"></a><a name="zh-cn_topic_0237122604_p3830631425"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p68301831327"></a><a name="zh-cn_topic_0237122604_p68301831327"></a>此表的模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row10830939213"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p88301831025"></a><a name="zh-cn_topic_0237122604_p88301831025"></a>relname
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p1883053721"></a><a name="zh-cn_topic_0237122604_p1883053721"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p16830932214"></a><a name="zh-cn_topic_0237122604_p16830932214"></a>表名。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row18318319211"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p1983114310216"></a><a name="zh-cn_topic_0237122604_p1983114310216"></a>seq_scan
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p12831631927"></a><a name="zh-cn_topic_0237122604_p12831631927"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p138311634213"></a><a name="zh-cn_topic_0237122604_p138311634213"></a>此表发起的顺序扫描数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row28310318212"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p383111315212"></a><a name="zh-cn_topic_0237122604_p383111315212"></a>seq_tup_read
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p98311531324"></a><a name="zh-cn_topic_0237122604_p98311531324"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p883153826"></a><a name="zh-cn_topic_0237122604_p883153826"></a>顺序扫描抓取的活跃行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row8831931527"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p208321731122"></a><a name="zh-cn_topic_0237122604_p208321731122"></a>idx_scan
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p188328312213"></a><a name="zh-cn_topic_0237122604_p188328312213"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p1283212314213"></a><a name="zh-cn_topic_0237122604_p1283212314213"></a>此表发起的索引扫描数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row1483211311219"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p983223724"></a><a name="zh-cn_topic_0237122604_p983223724"></a>idx_tup_fetch
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p58321532210"></a><a name="zh-cn_topic_0237122604_p58321532210"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p28321031425"></a><a name="zh-cn_topic_0237122604_p28321031425"></a>索引扫描抓取的活跃行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row18321937215"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p0832231528"></a><a name="zh-cn_topic_0237122604_p0832231528"></a>n_tup_ins
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p1783211311212"></a><a name="zh-cn_topic_0237122604_p1783211311212"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p5833634210"></a><a name="zh-cn_topic_0237122604_p5833634210"></a>插入行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row20833136219"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p13833143729"></a><a name="zh-cn_topic_0237122604_p13833143729"></a>n_tup_upd
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p88331034217"></a><a name="zh-cn_topic_0237122604_p88331034217"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p10833435211"></a><a name="zh-cn_topic_0237122604_p10833435211"></a>更新行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row08331731216"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p5834636212"></a><a name="zh-cn_topic_0237122604_p5834636212"></a>n_tup_del
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p148341036218"></a><a name="zh-cn_topic_0237122604_p148341036218"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p138342031622"></a><a name="zh-cn_topic_0237122604_p138342031622"></a>删除行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122604_row48343311216"><td class="cellrowborder" valign="top" width="18.96%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122604_p108348318211"></a><a name="zh-cn_topic_0237122604_p108348318211"></a>n_tup_hot_upd
</td>
<td class="cellrowborder" valign="top" width="17.39%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122604_p108351931124"></a><a name="zh-cn_topic_0237122604_p108351931124"></a>numeric
</td>
<td class="cellrowborder" valign="top" width="63.65%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122604_p19835935212"></a><a name="zh-cn_topic_0237122604_p19835935212"></a>HOT更新行数（比如没有更新所需的单独索引）。
</td>
</tr>
</tbody>
</table>

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

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

SUMMARY_STAT_XACT_SYS_TABLES

显示openGauss内汇聚的命名空间中系统表的事务状态信息。

表 1 SUMMARY_STAT_XACT_SYS_TABLES字段

名称	类型	描述
schemaname	name	此表的模式名。
relname	name	表名。
seq_scan	numeric	此表发起的顺序扫描数。
seq_tup_read	numeric	顺序扫描抓取的活跃行数。
idx_scan	numeric	此表发起的索引扫描数。
idx_tup_fetch	numeric	索引扫描抓取的活跃行数。
n_tup_ins	numeric	插入行数。
n_tup_upd	numeric	更新行数。
n_tup_del	numeric	删除行数。
n_tup_hot_upd	numeric	HOT更新行数（比如没有更新所需的单独索引）。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.0.1

openGauss / docs

SUMMARY_STAT_XACT_SYS_TABLES

简介

发行版

贡献者

近期动态

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

SUMMARY_STAT_XACT_SYS_TABLES

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs