加入 Gitee

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

克隆/下载

GLOBAL_CKPT_STATUS.md 7.13 KB

# GLOBAL\_CKPT\_STATUS<a name="ZH-CN_TOPIC_0245374819"></a>

GLOBAL\_CKPT\_STATUS视图用于显示openGauss所有实例的检查点信息和各类日志刷页情况。

**表 1**  GLOBAL\_CKPT\_STATUS字段

<a name="zh-cn_topic_0237122715_table421592221420"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122715_row92161022161412"><th class="cellrowborder" valign="top" width="31.433143314331435%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122715_p1521662211418"></a><a name="zh-cn_topic_0237122715_p1521662211418"></a>名称
</th>
<th class="cellrowborder" valign="top" width="22.7022702270227%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122715_p15216522161417"></a><a name="zh-cn_topic_0237122715_p15216522161417"></a>类型
</th>
<th class="cellrowborder" valign="top" width="45.86458645864587%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122715_p1221682216148"></a><a name="zh-cn_topic_0237122715_p1221682216148"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122715_row921682241410"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p7216722161418"></a><a name="zh-cn_topic_0237122715_p7216722161418"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p1321792214146"></a><a name="zh-cn_topic_0237122715_p1321792214146"></a>text
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p7217192271410"></a><a name="zh-cn_topic_0237122715_p7217192271410"></a>数据库进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row1121711228149"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p82171322161420"></a><a name="zh-cn_topic_0237122715_p82171322161420"></a>ckpt_redo_point
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p42171622121410"></a><a name="zh-cn_topic_0237122715_p42171622121410"></a>test
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p14217162241415"></a><a name="zh-cn_topic_0237122715_p14217162241415"></a>当前实例的检查点。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row221732231414"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p202173229142"></a><a name="zh-cn_topic_0237122715_p202173229142"></a>ckpt_clog_flush_num
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p1621812214140"></a><a name="zh-cn_topic_0237122715_p1621812214140"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p1221842219146"></a><a name="zh-cn_topic_0237122715_p1221842219146"></a>从启动到当前时间clog刷盘页面数。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row1218182219146"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p921862241415"></a><a name="zh-cn_topic_0237122715_p921862241415"></a>ckpt_csnlog_flush_num
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p8218122281417"></a><a name="zh-cn_topic_0237122715_p8218122281417"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p14218132213145"></a><a name="zh-cn_topic_0237122715_p14218132213145"></a>从启动到当前时间csnlog刷盘页面数。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row122181222171411"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p142181522161410"></a><a name="zh-cn_topic_0237122715_p142181522161410"></a>ckpt_multixact_flush_num
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p1321882291414"></a><a name="zh-cn_topic_0237122715_p1321882291414"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p521918228145"></a><a name="zh-cn_topic_0237122715_p521918228145"></a>从启动到当前时间multixact刷盘页面数。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row721922281413"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p1421992216144"></a><a name="zh-cn_topic_0237122715_p1421992216144"></a>ckpt_predicate_flush_num
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p721952211143"></a><a name="zh-cn_topic_0237122715_p721952211143"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p221911220143"></a><a name="zh-cn_topic_0237122715_p221911220143"></a>从启动到当前时间predicate刷盘页面数。
</td>
</tr>
<tr id="zh-cn_topic_0237122715_row172192225148"><td class="cellrowborder" valign="top" width="31.433143314331435%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122715_p122191322141415"></a><a name="zh-cn_topic_0237122715_p122191322141415"></a>ckpt_twophase_flush_num
</td>
<td class="cellrowborder" valign="top" width="22.7022702270227%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122715_p15219182218145"></a><a name="zh-cn_topic_0237122715_p15219182218145"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="45.86458645864587%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122715_p19220922111420"></a><a name="zh-cn_topic_0237122715_p19220922111420"></a>从启动到当前时间twophase刷盘页面数。
</td>
</tr>
</tbody>
</table>

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

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

GLOBAL_CKPT_STATUS

GLOBAL_CKPT_STATUS视图用于显示openGauss所有实例的检查点信息和各类日志刷页情况。

表 1 GLOBAL_CKPT_STATUS字段

名称	类型	描述
node_name	text	数据库进程名称。
ckpt_redo_point	test	当前实例的检查点。
ckpt_clog_flush_num	bigint	从启动到当前时间clog刷盘页面数。
ckpt_csnlog_flush_num	bigint	从启动到当前时间csnlog刷盘页面数。
ckpt_multixact_flush_num	bigint	从启动到当前时间multixact刷盘页面数。
ckpt_predicate_flush_num	bigint	从启动到当前时间predicate刷盘页面数。
ckpt_twophase_flush_num	bigint	从启动到当前时间twophase刷盘页面数。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

3.0.0

openGauss / docs

GLOBAL_CKPT_STATUS

简介

发行版

贡献者

近期动态

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

GLOBAL_CKPT_STATUS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs