加入 Gitee

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

克隆/下载

GLOBAL_WAIT_EVENTS.md 12.11 KB

# GLOBAL\_WAIT\_EVENTS<a name="ZH-CN_TOPIC_0289900024"></a>

GLOBAL\_WAIT\_EVENTS视图显示各节点的event的等待相关的统计信息。

**表 1**  GLOBAL\_WAIT\_EVENTS字段

<a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_table1387502102110"></a>
<table><thead align="left"><tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row425822172115"><th class="cellrowborder" valign="top" width="21.33213321332133%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p2252022172116"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p2252022172116"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b1625172242110"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b1625172242110"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.761676167616763%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1025222152113"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1025222152113"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b1225102218211"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b1225102218211"></a>类型
</th>
<th class="cellrowborder" valign="top" width="61.90619061906191%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p52592211213"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p52592211213"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b52592252119"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_b52592252119"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row025102210213"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p152662210213"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p152662210213"></a>nodename
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p162615226216"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p162615226216"></a>text
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1226522182117"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1226522182117"></a>数据库进程名称。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row826142219219"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p172618226210"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p172618226210"></a>type
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1526422142118"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1526422142118"></a>text
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p82632214216"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p82632214216"></a>event类型。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row102622217217"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1226172212111"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1226172212111"></a>event
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p3261322102118"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p3261322102118"></a>text
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p526182272120"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p526182272120"></a>event名称。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row92719222211"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p14271922162119"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p14271922162119"></a>wait
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p182782202119"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p182782202119"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p427162272112"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p427162272112"></a>等待次数。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row1027162292119"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p122782262111"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p122782262111"></a>failed_wait
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p112714227210"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p112714227210"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p3271022102116"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p3271022102116"></a>失败的等待次数。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row02732272115"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p42742219215"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p42742219215"></a>total_wait_time
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1827152216218"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1827152216218"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1528622182114"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1528622182114"></a>总等待时间（单位：微秒）。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row112818226210"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p42802220215"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p42802220215"></a>avg_wait_time
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p028192217218"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p028192217218"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p02872212119"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p02872212119"></a>平均等待时间（单位：微秒）。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row128122102117"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p5280220211"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p5280220211"></a>max_wait_time
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p528122213210"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p528122213210"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p6281322202110"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p6281322202110"></a>最大等待时间（单位：微秒）。
</td>
</tr>
<tr id="zh-cn_topic_0283137094_zh-cn_topic_0237122730_row1228182215213"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1928152211211"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p1928152211211"></a>min_wait_time
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p629142252114"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p629142252114"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p329162242119"></a><a name="zh-cn_topic_0283137094_zh-cn_topic_0237122730_p329162242119"></a>最小等待时间（单位：微秒）。
</td>
</tr>
<tr id="row3305161181317"><td class="cellrowborder" valign="top" width="21.33213321332133%" headers="mcps1.2.4.1.1 "><a name="p252505414573"></a><a name="p252505414573"></a>last_updated
</td>
<td class="cellrowborder" valign="top" width="16.761676167616763%" headers="mcps1.2.4.1.2 "><a name="p165252540572"></a><a name="p165252540572"></a>timestamp with time zone
</td>
<td class="cellrowborder" valign="top" width="61.90619061906191%" headers="mcps1.2.4.1.3 "><a name="p195259548572"></a><a name="p195259548572"></a>最后一次更新该事件的时间。
</td>
</tr>
</tbody>
</table>

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

提交于 2020-12-29 10:58 . new feature

GLOBAL_WAIT_EVENTS

GLOBAL_WAIT_EVENTS视图显示各节点的event的等待相关的统计信息。

表 1 GLOBAL_WAIT_EVENTS字段

名称	类型	描述
nodename	text	数据库进程名称。
type	text	event类型。
event	text	event名称。
wait	bigint	等待次数。
failed_wait	bigint	失败的等待次数。
total_wait_time	bigint	总等待时间（单位：微秒）。
avg_wait_time	bigint	平均等待时间（单位：微秒）。
max_wait_time	bigint	最大等待时间（单位：微秒）。
min_wait_time	bigint	最小等待时间（单位：微秒）。
last_updated	timestamp with time zone	最后一次更新该事件的时间。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

2.0.0

openGauss / docs

GLOBAL_WAIT_EVENTS

简介

发行版

贡献者

近期动态

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

GLOBAL_WAIT_EVENTS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs