加入 Gitee

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

克隆/下载

STAT_DATABASE_CONFLICTS.md 7.10 KB

# STAT\_DATABASE\_CONFLICTS<a name="ZH-CN_TOPIC_0245374701"></a>

显示当前节点数据库冲突状态的统计信息。

**表 1**  STAT\_DATABASE\_CONFLICTS字段

<a name="zh-cn_topic_0237122597_table4154934155516"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122597_row18237123435511"><th class="cellrowborder" valign="top" width="20.03%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122597_p18237113415552"></a><a name="zh-cn_topic_0237122597_p18237113415552"></a><a name="zh-cn_topic_0237122597_b12237134155515"></a><a name="zh-cn_topic_0237122597_b12237134155515"></a>名称
</th>
<th class="cellrowborder" valign="top" width="16.24%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122597_p1923733455515"></a><a name="zh-cn_topic_0237122597_p1923733455515"></a><a name="zh-cn_topic_0237122597_b72381334165515"></a><a name="zh-cn_topic_0237122597_b72381334165515"></a>类型
</th>
<th class="cellrowborder" valign="top" width="63.73%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122597_p1238834185513"></a><a name="zh-cn_topic_0237122597_p1238834185513"></a><a name="zh-cn_topic_0237122597_b1223819347557"></a><a name="zh-cn_topic_0237122597_b1223819347557"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122597_row142381834195510"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p1323919344558"></a><a name="zh-cn_topic_0237122597_p1323919344558"></a>datid
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p82393348553"></a><a name="zh-cn_topic_0237122597_p82393348553"></a>oid
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p1723983495510"></a><a name="zh-cn_topic_0237122597_p1723983495510"></a>数据库标识。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row1423933435511"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p15239143425510"></a><a name="zh-cn_topic_0237122597_p15239143425510"></a>datname
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p202392340551"></a><a name="zh-cn_topic_0237122597_p202392340551"></a>name
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p62401134115515"></a><a name="zh-cn_topic_0237122597_p62401134115515"></a>数据库名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row924023485518"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p824023445519"></a><a name="zh-cn_topic_0237122597_p824023445519"></a>confl_tablespace
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p1024019341556"></a><a name="zh-cn_topic_0237122597_p1024019341556"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p122401134105511"></a><a name="zh-cn_topic_0237122597_p122401134105511"></a>冲突的表空间的数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row162408344556"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p22411134165513"></a><a name="zh-cn_topic_0237122597_p22411134165513"></a>confl_lock
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p1424123445510"></a><a name="zh-cn_topic_0237122597_p1424123445510"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p17241134185520"></a><a name="zh-cn_topic_0237122597_p17241134185520"></a>冲突的锁数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row1624153465520"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p3241123495516"></a><a name="zh-cn_topic_0237122597_p3241123495516"></a>confl_snapshot
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p42411934125517"></a><a name="zh-cn_topic_0237122597_p42411934125517"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p524120348554"></a><a name="zh-cn_topic_0237122597_p524120348554"></a>冲突的快照数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row6242153419557"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p172429347554"></a><a name="zh-cn_topic_0237122597_p172429347554"></a>confl_bufferpin
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p924293412556"></a><a name="zh-cn_topic_0237122597_p924293412556"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p15242183485518"></a><a name="zh-cn_topic_0237122597_p15242183485518"></a>冲突的缓冲区数目。
</td>
</tr>
<tr id="zh-cn_topic_0237122597_row1524211349559"><td class="cellrowborder" valign="top" width="20.03%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122597_p52421234175517"></a><a name="zh-cn_topic_0237122597_p52421234175517"></a>confl_deadlock
</td>
<td class="cellrowborder" valign="top" width="16.24%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122597_p9242634135519"></a><a name="zh-cn_topic_0237122597_p9242634135519"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="63.73%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122597_p924243465516"></a><a name="zh-cn_topic_0237122597_p924243465516"></a>冲突的死锁数目。
</td>
</tr>
</tbody>
</table>

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

提交于 2020-06-24 19:41 . Add legal notice, administrator guide, technical white paper and other…

STAT_DATABASE_CONFLICTS

显示当前节点数据库冲突状态的统计信息。

表 1 STAT_DATABASE_CONFLICTS字段

名称	类型	描述
datid	oid	数据库标识。
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

3.0.0

openGauss / docs

STAT_DATABASE_CONFLICTS

简介

发行版

贡献者

近期动态

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

STAT_DATABASE_CONFLICTS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs