加入 Gitee

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

克隆/下载

STATIO_ALL_SEQUENCES.md 5.43 KB

# STATIO\_ALL\_SEQUENCES<a name="ZH-CN_TOPIC_0245374797"></a>

STATIO\_ALL\_SEQUENCES视图包含数据库中每个序列的每一行，显示特定序列关于I/O的统计。

**表 1**  STATIO\_ALL\_SEQUENCES字段

<a name="zh-cn_topic_0237122693_table159871453260"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122693_row1263114611263"><th class="cellrowborder" valign="top" width="17.27%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122693_p264114602618"></a><a name="zh-cn_topic_0237122693_p264114602618"></a><a name="zh-cn_topic_0237122693_b12641467262"></a><a name="zh-cn_topic_0237122693_b12641467262"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.8%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122693_p1064246102612"></a><a name="zh-cn_topic_0237122693_p1064246102612"></a><a name="zh-cn_topic_0237122693_b664154652619"></a><a name="zh-cn_topic_0237122693_b664154652619"></a>类型
</th>
<th class="cellrowborder" valign="top" width="65.93%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122693_p1964104622612"></a><a name="zh-cn_topic_0237122693_p1964104622612"></a><a name="zh-cn_topic_0237122693_b176410469261"></a><a name="zh-cn_topic_0237122693_b176410469261"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122693_row1164114614267"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122693_p765124672611"></a><a name="zh-cn_topic_0237122693_p765124672611"></a>relid
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122693_p76554672611"></a><a name="zh-cn_topic_0237122693_p76554672611"></a>oid
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122693_p26514617261"></a><a name="zh-cn_topic_0237122693_p26514617261"></a>序列OID。
</td>
</tr>
<tr id="zh-cn_topic_0237122693_row16656465267"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122693_p965104682618"></a><a name="zh-cn_topic_0237122693_p965104682618"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122693_p186510462262"></a><a name="zh-cn_topic_0237122693_p186510462262"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122693_p766104614263"></a><a name="zh-cn_topic_0237122693_p766104614263"></a>序列中模式名。
</td>
</tr>
<tr id="zh-cn_topic_0237122693_row18661246112611"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122693_p66614469269"></a><a name="zh-cn_topic_0237122693_p66614469269"></a>relname
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122693_p1566164614260"></a><a name="zh-cn_topic_0237122693_p1566164614260"></a>name
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122693_p196620464263"></a><a name="zh-cn_topic_0237122693_p196620464263"></a>序列名。
</td>
</tr>
<tr id="zh-cn_topic_0237122693_row766124632613"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122693_p86624615263"></a><a name="zh-cn_topic_0237122693_p86624615263"></a>blks_read
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122693_p167174652618"></a><a name="zh-cn_topic_0237122693_p167174652618"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122693_p146712466267"></a><a name="zh-cn_topic_0237122693_p146712466267"></a>从序列中读取的磁盘块数。
</td>
</tr>
<tr id="zh-cn_topic_0237122693_row1467124613265"><td class="cellrowborder" valign="top" width="17.27%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122693_p46784617262"></a><a name="zh-cn_topic_0237122693_p46784617262"></a>blks_hit
</td>
<td class="cellrowborder" valign="top" width="16.8%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122693_p26784613262"></a><a name="zh-cn_topic_0237122693_p26784613262"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="65.93%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122693_p146744622611"></a><a name="zh-cn_topic_0237122693_p146744622611"></a>序列中缓存命中数。
</td>
</tr>
</tbody>
</table>

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

提交于 2020-06-24 19:41 . Add legal notice, administrator guide, technical white paper and other…

STATIO_ALL_SEQUENCES

STATIO_ALL_SEQUENCES视图包含数据库中每个序列的每一行，显示特定序列关于I/O的统计。

表 1 STATIO_ALL_SEQUENCES字段

名称	类型	描述
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

3.0.0

openGauss / docs

STATIO_ALL_SEQUENCES

简介

发行版

贡献者

近期动态

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

STATIO_ALL_SEQUENCES

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs