加入 Gitee

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

克隆/下载

SUMMARY_STAT_DATABASE_CONFLICTS.md 6.41 KB

# SUMMARY\_STAT\_DATABASE\_CONFLICTS<a name="ZH-CN_TOPIC_0245374702"></a>

显示openGauss内汇聚的数据库冲突状态的统计信息。

**表 1**  SUMMARY\_STAT\_DATABASE\_CONFLICTS字段

<a name="zh-cn_topic_0237122598_table1212791117569"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122598_row919731185614"><th class="cellrowborder" valign="top" width="22.78%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122598_p16197121165612"></a><a name="zh-cn_topic_0237122598_p16197121165612"></a><a name="zh-cn_topic_0237122598_b819791112560"></a><a name="zh-cn_topic_0237122598_b819791112560"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.869999999999997%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122598_p11197101115568"></a><a name="zh-cn_topic_0237122598_p11197101115568"></a><a name="zh-cn_topic_0237122598_b8197171112567"></a><a name="zh-cn_topic_0237122598_b8197171112567"></a>类型
</th>
<th class="cellrowborder" valign="top" width="60.35%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122598_p1419791110564"></a><a name="zh-cn_topic_0237122598_p1419791110564"></a><a name="zh-cn_topic_0237122598_b201978111564"></a><a name="zh-cn_topic_0237122598_b201978111564"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122598_row2197151112562"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p91971011125614"></a><a name="zh-cn_topic_0237122598_p91971011125614"></a>datname
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p1819713117566"></a><a name="zh-cn_topic_0237122598_p1819713117566"></a>name
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p1519801185613"></a><a name="zh-cn_topic_0237122598_p1519801185613"></a>数据库名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122598_row1119801113566"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p919841115619"></a><a name="zh-cn_topic_0237122598_p919841115619"></a>confl_tablespace
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p31982119567"></a><a name="zh-cn_topic_0237122598_p31982119567"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p9198191185616"></a><a name="zh-cn_topic_0237122598_p9198191185616"></a>冲突的表空间的数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122598_row19198131117569"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p1519812110562"></a><a name="zh-cn_topic_0237122598_p1519812110562"></a>confl_lock
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p1219881145610"></a><a name="zh-cn_topic_0237122598_p1219881145610"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p91999114563"></a><a name="zh-cn_topic_0237122598_p91999114563"></a>冲突的锁数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122598_row21996115566"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p111998112566"></a><a name="zh-cn_topic_0237122598_p111998112566"></a>confl_snapshot
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p2019961135619"></a><a name="zh-cn_topic_0237122598_p2019961135619"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p019971115618"></a><a name="zh-cn_topic_0237122598_p019971115618"></a>冲突的快照数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122598_row161991911175613"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p1719951115613"></a><a name="zh-cn_topic_0237122598_p1719951115613"></a>confl_bufferpin
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p52001611185618"></a><a name="zh-cn_topic_0237122598_p52001611185618"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p1120012114566"></a><a name="zh-cn_topic_0237122598_p1120012114566"></a>冲突的缓冲区数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122598_row4200611175619"><td class="cellrowborder" valign="top" width="22.78%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122598_p7200711125612"></a><a name="zh-cn_topic_0237122598_p7200711125612"></a>confl_deadlock
</td>
<td class="cellrowborder" valign="top" width="16.869999999999997%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122598_p620017110564"></a><a name="zh-cn_topic_0237122598_p620017110564"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="60.35%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122598_p9200111175614"></a><a name="zh-cn_topic_0237122598_p9200111175614"></a>冲突的死锁数目。
</td>
</tr>
</tbody>
</table>

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

提交于 2020-08-12 11:20 . Delete monitor administrator

SUMMARY_STAT_DATABASE_CONFLICTS

显示openGauss内汇聚的数据库冲突状态的统计信息。

表 1 SUMMARY_STAT_DATABASE_CONFLICTS字段

名称	类型	描述
datname	name	数据库名称。
confl_tablespace	bigint	冲突的表空间的数目。
confl_lock	bigint	冲突的锁数目。
confl_snapshot	bigint	冲突的快照数目。
confl_bufferpin	bigint	冲突的缓冲区数目。
confl_deadlock	bigint	冲突的死锁数目。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

2.1.0

openGauss / docs

SUMMARY_STAT_DATABASE_CONFLICTS

简介

发行版

贡献者

近期动态

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

SUMMARY_STAT_DATABASE_CONFLICTS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs