加入 Gitee

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

克隆/下载

GLOBAL_RECOVERY_STATUS.md 8.65 KB

# GLOBAL\_RECOVERY\_STATUS<a name="ZH-CN_TOPIC_0245374825"></a>

GLOBAL\_RECOVERY\_STATUS视图显示关于主机和备机的日志流控信息。

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

<a name="zh-cn_topic_0237122721_table134071140163518"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122721_row13408114014356"><th class="cellrowborder" valign="top" width="18.001800180018%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122721_p240804093518"></a><a name="zh-cn_topic_0237122721_p240804093518"></a>名称
</th>
<th class="cellrowborder" valign="top" width="30.833083308330835%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122721_p440834053514"></a><a name="zh-cn_topic_0237122721_p440834053514"></a>类型
</th>
<th class="cellrowborder" valign="top" width="51.16511651165116%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122721_p440884017353"></a><a name="zh-cn_topic_0237122721_p440884017353"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122721_row114085401354"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p144096403358"></a><a name="zh-cn_topic_0237122721_p144096403358"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p18409164063512"></a><a name="zh-cn_topic_0237122721_p18409164063512"></a>text
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p145153413368"></a><a name="zh-cn_topic_0237122721_p145153413368"></a>主机进程名称，包含主机和备机。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row11409154013514"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p1140964013354"></a><a name="zh-cn_topic_0237122721_p1140964013354"></a>standby_node_name
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p24104404359"></a><a name="zh-cn_topic_0237122721_p24104404359"></a>text
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p134410263345"></a><a name="zh-cn_topic_0237122721_p134410263345"></a>备机进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row474773932717"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p9747173918271"></a><a name="zh-cn_topic_0237122721_p9747173918271"></a>source_ip
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p1747103910277"></a><a name="zh-cn_topic_0237122721_p1747103910277"></a>text
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p274716398271"></a><a name="zh-cn_topic_0237122721_p274716398271"></a>主机的IP地址。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row2747183932710"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p6748739122713"></a><a name="zh-cn_topic_0237122721_p6748739122713"></a>source_port
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p69110313321"></a><a name="zh-cn_topic_0237122721_p69110313321"></a>integer
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p67481839152710"></a><a name="zh-cn_topic_0237122721_p67481839152710"></a>主机的端口号。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row1739511578287"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p4396157102810"></a><a name="zh-cn_topic_0237122721_p4396157102810"></a>dest_ip
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p1239695711280"></a><a name="zh-cn_topic_0237122721_p1239695711280"></a>text
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p6396155714282"></a><a name="zh-cn_topic_0237122721_p6396155714282"></a>备机的IP地址。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row11297437298"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p1729715320298"></a><a name="zh-cn_topic_0237122721_p1729715320298"></a>dest_port
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p1929763172914"></a><a name="zh-cn_topic_0237122721_p1929763172914"></a>integer
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p429711372915"></a><a name="zh-cn_topic_0237122721_p429711372915"></a>备机的端口号。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row1337710832915"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p193774872915"></a><a name="zh-cn_topic_0237122721_p193774872915"></a>current_rto
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p153779817298"></a><a name="zh-cn_topic_0237122721_p153779817298"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p737778132912"></a><a name="zh-cn_topic_0237122721_p737778132912"></a>备机当前的日志流控时间，单位秒。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row577111141318"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p1377119149312"></a><a name="zh-cn_topic_0237122721_p1377119149312"></a>target_rto
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p1877117149312"></a><a name="zh-cn_topic_0237122721_p1877117149312"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p187711014203117"></a><a name="zh-cn_topic_0237122721_p187711014203117"></a>备机通过GUC参数设置的预期流控时间，单位秒。
</td>
</tr>
<tr id="zh-cn_topic_0237122721_row10388522203113"><td class="cellrowborder" valign="top" width="18.001800180018%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122721_p143892022143115"></a><a name="zh-cn_topic_0237122721_p143892022143115"></a>current_sleep_time
</td>
<td class="cellrowborder" valign="top" width="30.833083308330835%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122721_p18389122212317"></a><a name="zh-cn_topic_0237122721_p18389122212317"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="51.16511651165116%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122721_p77453121341"></a><a name="zh-cn_topic_0237122721_p77453121341"></a>为了达到这个预期主机所需要的睡眠时间，单位微妙。
</td>
</tr>
</tbody>
</table>

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

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

GLOBAL_RECOVERY_STATUS

GLOBAL_RECOVERY_STATUS视图显示关于主机和备机的日志流控信息。

表 1 GLOBAL_RECOVERY_STATUS字段

名称	类型	描述
node_name	text	主机进程名称，包含主机和备机。
standby_node_name	text	备机进程名称。
source_ip	text	主机的IP地址。
source_port	integer	主机的端口号。
dest_ip	text	备机的IP地址。
dest_port	integer	备机的端口号。
current_rto	bigint	备机当前的日志流控时间，单位秒。
target_rto	bigint	备机通过GUC参数设置的预期流控时间，单位秒。
current_sleep_time	bigint	为了达到这个预期主机所需要的睡眠时间，单位微妙。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

2.0.0

openGauss / docs

GLOBAL_RECOVERY_STATUS

简介

发行版

贡献者

近期动态

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

GLOBAL_RECOVERY_STATUS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs