加入 Gitee

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

克隆/下载

GLOBAL_STAT_XACT_ALL_TABLES.md 10.96 KB

# GLOBAL\_STAT\_XACT\_ALL\_TABLES<a name="ZH-CN_TOPIC_0245374706"></a>

显示各节点的命名空间中所有普通表和toast表的事务状态信息。

**表 1**  GLOBAL\_STAT\_XACT\_ALL\_TABLES字段

<a name="zh-cn_topic_0237122602_table1343541913012"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122602_row12574141910010"><th class="cellrowborder" valign="top" width="17.27%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122602_p15741191900"></a><a name="zh-cn_topic_0237122602_p15741191900"></a><a name="zh-cn_topic_0237122602_b55748196016"></a><a name="zh-cn_topic_0237122602_b55748196016"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.8%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122602_p557491915017"></a><a name="zh-cn_topic_0237122602_p557491915017"></a><a name="zh-cn_topic_0237122602_b1257417191801"></a><a name="zh-cn_topic_0237122602_b1257417191801"></a>类型
</th>
<th class="cellrowborder" valign="top" width="65.93%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122602_p17575519707"></a><a name="zh-cn_topic_0237122602_p17575519707"></a><a name="zh-cn_topic_0237122602_b12575619504"></a><a name="zh-cn_topic_0237122602_b12575619504"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122602_row357519191500"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p1757551915015"></a><a name="zh-cn_topic_0237122602_p1757551915015"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p857561913015"></a><a name="zh-cn_topic_0237122602_p857561913015"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p155761519607"></a><a name="zh-cn_topic_0237122602_p155761519607"></a>数据库进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row16576019807"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p557611911011"></a><a name="zh-cn_topic_0237122602_p557611911011"></a>relid
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p175763191604"></a><a name="zh-cn_topic_0237122602_p175763191604"></a>oid
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p85761719102"></a><a name="zh-cn_topic_0237122602_p85761719102"></a>表的OID。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row115761019402"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p195778198012"></a><a name="zh-cn_topic_0237122602_p195778198012"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p1557713191301"></a><a name="zh-cn_topic_0237122602_p1557713191301"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p057781911017"></a><a name="zh-cn_topic_0237122602_p057781911017"></a>此表的模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row1057791913017"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p957711191001"></a><a name="zh-cn_topic_0237122602_p957711191001"></a>relname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p15770191701"></a><a name="zh-cn_topic_0237122602_p15770191701"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p257714192006"></a><a name="zh-cn_topic_0237122602_p257714192006"></a>表名。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row2057718191102"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p757711191019"></a><a name="zh-cn_topic_0237122602_p757711191019"></a>seq_scan
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p20577719202"></a><a name="zh-cn_topic_0237122602_p20577719202"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p1057819191107"></a><a name="zh-cn_topic_0237122602_p1057819191107"></a>此表发起的顺序扫描数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row55787191102"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p15781319807"></a><a name="zh-cn_topic_0237122602_p15781319807"></a>seq_tup_read
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p8578111920014"></a><a name="zh-cn_topic_0237122602_p8578111920014"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p257818194012"></a><a name="zh-cn_topic_0237122602_p257818194012"></a>顺序扫描抓取的活跃行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row657811193012"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p1257821915014"></a><a name="zh-cn_topic_0237122602_p1257821915014"></a>idx_scan
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p185789191206"></a><a name="zh-cn_topic_0237122602_p185789191206"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p25785192010"></a><a name="zh-cn_topic_0237122602_p25785192010"></a>此表发起的索引扫描数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row257871914017"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p4578141919014"></a><a name="zh-cn_topic_0237122602_p4578141919014"></a>idx_tup_fetch
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p55790191401"></a><a name="zh-cn_topic_0237122602_p55790191401"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p125791119307"></a><a name="zh-cn_topic_0237122602_p125791119307"></a>索引扫描抓取的活跃行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row95792191809"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p557919191201"></a><a name="zh-cn_topic_0237122602_p557919191201"></a>n_tup_ins
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p1157915194020"></a><a name="zh-cn_topic_0237122602_p1157915194020"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p1257951910010"></a><a name="zh-cn_topic_0237122602_p1257951910010"></a>插入行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row13579219407"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p15795191010"></a><a name="zh-cn_topic_0237122602_p15795191010"></a>n_tup_upd
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p55793191502"></a><a name="zh-cn_topic_0237122602_p55793191502"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p115791619904"></a><a name="zh-cn_topic_0237122602_p115791619904"></a>更新行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row157918191403"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p1557961915010"></a><a name="zh-cn_topic_0237122602_p1557961915010"></a>n_tup_del
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p85801194012"></a><a name="zh-cn_topic_0237122602_p85801194012"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p458001916011"></a><a name="zh-cn_topic_0237122602_p458001916011"></a>删除行数。
</td>
</tr>
<tr id="zh-cn_topic_0237122602_row1658071910011"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122602_p658019195012"></a><a name="zh-cn_topic_0237122602_p658019195012"></a>n_tup_hot_upd
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122602_p158018195011"></a><a name="zh-cn_topic_0237122602_p158018195011"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122602_p558081919019"></a><a name="zh-cn_topic_0237122602_p558081919019"></a>HOT更新行数（比如没有更新所需的单独索引）。
</td>
</tr>
</tbody>
</table>

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

提交于 2020-11-09 15:59 . sync dts

GLOBAL_STAT_XACT_ALL_TABLES

显示各节点的命名空间中所有普通表和toast表的事务状态信息。

表 1 GLOBAL_STAT_XACT_ALL_TABLES字段

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

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

git@gitee.com:opengauss/docs.git

opengauss

docs

2.1.0

openGauss / docs

GLOBAL_STAT_XACT_ALL_TABLES

简介

发行版

贡献者

近期动态

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

GLOBAL_STAT_XACT_ALL_TABLES

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs