加入 Gitee

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

克隆/下载

GLOBAL_GET_BGWRITER_STATUS.md 5.97 KB

# GLOBAL\_GET\_BGWRITER\_STATUS<a name="ZH-CN_TOPIC_0281105078"></a>

GLOBAL\_GET\_BGWRITER\_STATUS视图显示整个集群所有实例bgwriter线程刷页信息，候选buffer链中页面个数，buffer淘汰信息。

**表 1**  GLOBAL\_GET\_BGWRITER\_STATUS字段

<a name="zh-cn_topic_0059778133_tc25f02433de2419f8da4d0a8c2c8e562"></a>
<table><thead align="left"><tr id="zh-cn_topic_0059778133_rea54060e599a49eb9c70be97cf91d9a0"><th class="cellrowborder" valign="top" width="22.55%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0059778133_a32c1f84b5026462b86d11c4d809914f3"></a><a name="zh-cn_topic_0059778133_a32c1f84b5026462b86d11c4d809914f3"></a>名称
</th>
<th class="cellrowborder" valign="top" width="20.69%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0059778133_adc94583cb9b24e22bc66ecd21efdbf23"></a><a name="zh-cn_topic_0059778133_adc94583cb9b24e22bc66ecd21efdbf23"></a>类型
</th>
<th class="cellrowborder" valign="top" width="56.76%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0059778133_a338cfb9341434b298385f2ba72e9620a"></a><a name="zh-cn_topic_0059778133_a338cfb9341434b298385f2ba72e9620a"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="row757161654315"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="p15571161614431"></a><a name="p15571161614431"></a>node_name
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="p1457191694314"></a><a name="p1457191694314"></a>text
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="p14572111616430"></a><a name="p14572111616430"></a>实例名称。
</td>
</tr>
<tr id="row4331121184412"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="p42652367477"></a><a name="p42652367477"></a>bgwr_actual_flush_total_num
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="p183326113441"></a><a name="p183326113441"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="p196485711489"></a><a name="p196485711489"></a>从启动到当前时间bgwriter线程总计刷脏页数量。
</td>
</tr>
<tr id="zh-cn_topic_0059778133_r70b979ea9a8c44088f169a2ed862a5e8"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="p286612409472"></a><a name="p286612409472"></a>bgwr_last_flush_num
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="p141611830114819"></a><a name="p141611830114819"></a>integer
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0059778133_a382f47d73e7848e19eb1855c75c577e6"></a><a name="zh-cn_topic_0059778133_a382f47d73e7848e19eb1855c75c577e6"></a>bgwriter线程上一批刷脏页数量。
</td>
</tr>
<tr id="zh-cn_topic_0059778133_r04a260d93f86474d8a270ecddee95749"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="p9514114434720"></a><a name="p9514114434720"></a>candidate_slots
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0059778133_af6663e23d11a47f5be18a42f98533bb8"></a><a name="zh-cn_topic_0059778133_af6663e23d11a47f5be18a42f98533bb8"></a>integer
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0059778133_a0faf0893b3f8464aba64d3360be7ea39"></a><a name="zh-cn_topic_0059778133_a0faf0893b3f8464aba64d3360be7ea39"></a>当前候选buffer链中页面个数。
</td>
</tr>
<tr id="zh-cn_topic_0059778133_r34e57b3cec1d444992a50a171f8473cc"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="p208491052104717"></a><a name="p208491052104717"></a>get_buffer_from_list
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0059778133_aa36bd62dac9d4647b36218100312733d"></a><a name="zh-cn_topic_0059778133_aa36bd62dac9d4647b36218100312733d"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0059778133_a8392d26664af4197b11ac091cba47b60"></a><a name="zh-cn_topic_0059778133_a8392d26664af4197b11ac091cba47b60"></a>buffer淘汰从候选buffer链中获取页面的次数。
</td>
</tr>
<tr id="zh-cn_topic_0059778133_re2b1e3c100874445ae8b9f6672fd44b8"><td class="cellrowborder" valign="top" width="22.55%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0059778133_aa94b6d5d13c04feb8de4b1e39807c33c"></a><a name="zh-cn_topic_0059778133_aa94b6d5d13c04feb8de4b1e39807c33c"></a>get_buffer_clock_sweep
</td>
<td class="cellrowborder" valign="top" width="20.69%" headers="mcps1.2.4.1.2 "><a name="p13777192233610"></a><a name="p13777192233610"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="56.76%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0059778133_a027cb0c2fb494d2f96e6a0450a09023e"></a><a name="zh-cn_topic_0059778133_a027cb0c2fb494d2f96e6a0450a09023e"></a>buffer淘汰从原淘汰方案中获取页面的次数。
</td>
</tr>
</tbody>
</table>

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

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

GLOBAL_GET_BGWRITER_STATUS

GLOBAL_GET_BGWRITER_STATUS视图显示整个集群所有实例bgwriter线程刷页信息，候选buffer链中页面个数，buffer淘汰信息。

表 1 GLOBAL_GET_BGWRITER_STATUS字段

名称	类型	描述
node_name	text	实例名称。
bgwr_actual_flush_total_num	bigint	从启动到当前时间bgwriter线程总计刷脏页数量。
bgwr_last_flush_num	integer	bgwriter线程上一批刷脏页数量。
candidate_slots	integer	当前候选buffer链中页面个数。
get_buffer_from_list	bigint	buffer淘汰从候选buffer链中获取页面的次数。
get_buffer_clock_sweep	bigint	buffer淘汰从原淘汰方案中获取页面的次数。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.0.1

openGauss / docs

GLOBAL_GET_BGWRITER_STATUS

简介

发行版

贡献者

近期动态

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

GLOBAL_GET_BGWRITER_STATUS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs