加入 Gitee

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

克隆/下载

GLOBAL_STATIO_USER_SEQUENCES.md 6.34 KB

# GLOBAL\_STATIO\_USER\_SEQUENCES<a name="ZH-CN_TOPIC_0245374781"></a>

GLOBAL\_STATIO\_USER\_SEQUENCES视图显示各节点的命名空间中所有用户关系表类型为序列的IO状态信息。

**表 1**  GLOBAL\_STATIO\_USER\_SEQUENCES字段

<a name="zh-cn_topic_0237122677_table8513172121319"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122677_row105855211138"><th class="cellrowborder" valign="top" width="17.27%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122677_p1458552181316"></a><a name="zh-cn_topic_0237122677_p1458552181316"></a><a name="zh-cn_topic_0237122677_b165856215134"></a><a name="zh-cn_topic_0237122677_b165856215134"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.8%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122677_p4585202115139"></a><a name="zh-cn_topic_0237122677_p4585202115139"></a><a name="zh-cn_topic_0237122677_b058602114139"></a><a name="zh-cn_topic_0237122677_b058602114139"></a>类型
</th>
<th class="cellrowborder" valign="top" width="65.93%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122677_p12586142115135"></a><a name="zh-cn_topic_0237122677_p12586142115135"></a><a name="zh-cn_topic_0237122677_b25861621131317"></a><a name="zh-cn_topic_0237122677_b25861621131317"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122677_row15586421181319"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p35866216136"></a><a name="zh-cn_topic_0237122677_p35866216136"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p1658616212133"></a><a name="zh-cn_topic_0237122677_p1658616212133"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p175861721111318"></a><a name="zh-cn_topic_0237122677_p175861721111318"></a>数据库进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122677_row5586132114136"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p1458614218139"></a><a name="zh-cn_topic_0237122677_p1458614218139"></a>relid
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p1158713218137"></a><a name="zh-cn_topic_0237122677_p1158713218137"></a>oid
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p1958715219133"></a><a name="zh-cn_topic_0237122677_p1958715219133"></a>序列OID。
</td>
</tr>
<tr id="zh-cn_topic_0237122677_row18587621141316"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p6587102116138"></a><a name="zh-cn_topic_0237122677_p6587102116138"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p2587152191316"></a><a name="zh-cn_topic_0237122677_p2587152191316"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p1587152161318"></a><a name="zh-cn_topic_0237122677_p1587152161318"></a>序列中模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122677_row85871121121315"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p1058752110138"></a><a name="zh-cn_topic_0237122677_p1058752110138"></a>relname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p2587142181317"></a><a name="zh-cn_topic_0237122677_p2587142181317"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p19590162116134"></a><a name="zh-cn_topic_0237122677_p19590162116134"></a>序列名。
</td>
</tr>
<tr id="zh-cn_topic_0237122677_row1459022116131"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p1359052171320"></a><a name="zh-cn_topic_0237122677_p1359052171320"></a>blks_read
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p1590202112134"></a><a name="zh-cn_topic_0237122677_p1590202112134"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p145905211134"></a><a name="zh-cn_topic_0237122677_p145905211134"></a>从序列中读取的磁盘块数。
</td>
</tr>
<tr id="zh-cn_topic_0237122677_row195906216138"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122677_p9591921181318"></a><a name="zh-cn_topic_0237122677_p9591921181318"></a>blks_hit
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122677_p75911421171316"></a><a name="zh-cn_topic_0237122677_p75911421171316"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122677_p105911021111318"></a><a name="zh-cn_topic_0237122677_p105911021111318"></a>序列中缓存命中数。
</td>
</tr>
</tbody>
</table>

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

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

GLOBAL_STATIO_USER_SEQUENCES

GLOBAL_STATIO_USER_SEQUENCES视图显示各节点的命名空间中所有用户关系表类型为序列的IO状态信息。

表 1 GLOBAL_STATIO_USER_SEQUENCES字段

名称	类型	描述
node_name	name	数据库进程名称。
relid	oid	序列OID。
schemaname	name	序列中模式名。
relname	name	序列名。
blks_read	bigint	从序列中读取的磁盘块数。
blks_hit	bigint	序列中缓存命中数。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.1.0

openGauss / docs

GLOBAL_STATIO_USER_SEQUENCES

简介

发行版

贡献者

近期动态

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

GLOBAL_STATIO_USER_SEQUENCES

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs