加入 Gitee

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

克隆/下载

STAT_XACT_USER_FUNCTIONS.md 6.41 KB

# STAT\_XACT\_USER\_FUNCTIONS<a name="ZH-CN_TOPIC_0245374713"></a>

视图包含当前节点本事务内函数执行的统计信息。

**表 1**  STAT\_XACT\_USER\_FUNCTIONS字段

<a name="zh-cn_topic_0237122609_table10110112517620"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122609_row141921125161"><th class="cellrowborder" valign="top" width="17.299999999999997%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122609_p111921325869"></a><a name="zh-cn_topic_0237122609_p111921325869"></a><a name="zh-cn_topic_0237122609_b151921625062"></a><a name="zh-cn_topic_0237122609_b151921625062"></a>名称
</th>
<th class="cellrowborder" valign="top" width="24.21%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122609_p5192182513618"></a><a name="zh-cn_topic_0237122609_p5192182513618"></a><a name="zh-cn_topic_0237122609_b17192202518618"></a><a name="zh-cn_topic_0237122609_b17192202518618"></a>类型
</th>
<th class="cellrowborder" valign="top" width="58.489999999999995%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122609_p719219258613"></a><a name="zh-cn_topic_0237122609_p719219258613"></a><a name="zh-cn_topic_0237122609_b1119215251063"></a><a name="zh-cn_topic_0237122609_b1119215251063"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122609_row171921325662"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p91931725262"></a><a name="zh-cn_topic_0237122609_p91931725262"></a>funcid
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p21932025162"></a><a name="zh-cn_topic_0237122609_p21932025162"></a>oid
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p719312256613"></a><a name="zh-cn_topic_0237122609_p719312256613"></a>函数标识。
</td>
</tr>
<tr id="zh-cn_topic_0237122609_row1019372513619"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p111933258614"></a><a name="zh-cn_topic_0237122609_p111933258614"></a>schemaname
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p71939251566"></a><a name="zh-cn_topic_0237122609_p71939251566"></a>name
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p81947251167"></a><a name="zh-cn_topic_0237122609_p81947251167"></a>模式的名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122609_row619519251962"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p1619517257613"></a><a name="zh-cn_topic_0237122609_p1619517257613"></a>funcname
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p14195425360"></a><a name="zh-cn_topic_0237122609_p14195425360"></a>name
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p1319510251361"></a><a name="zh-cn_topic_0237122609_p1319510251361"></a>函数名称。
</td>
</tr>
<tr id="zh-cn_topic_0237122609_row101951251768"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p91961125667"></a><a name="zh-cn_topic_0237122609_p91961125667"></a>calls
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p1019602518614"></a><a name="zh-cn_topic_0237122609_p1019602518614"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p71969251665"></a><a name="zh-cn_topic_0237122609_p71969251665"></a>函数被调用的次数。
</td>
</tr>
<tr id="zh-cn_topic_0237122609_row519632516614"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p7196725864"></a><a name="zh-cn_topic_0237122609_p7196725864"></a>total_time
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p12196142518617"></a><a name="zh-cn_topic_0237122609_p12196142518617"></a>double precision
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p019612251365"></a><a name="zh-cn_topic_0237122609_p019612251365"></a>函数的总执行时长。
</td>
</tr>
<tr id="zh-cn_topic_0237122609_row121977251561"><td class="cellrowborder" valign="top" width="17.299999999999997%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122609_p41974256618"></a><a name="zh-cn_topic_0237122609_p41974256618"></a>self_time
</td>
<td class="cellrowborder" valign="top" width="24.21%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122609_p619717251967"></a><a name="zh-cn_topic_0237122609_p619717251967"></a>double precision
</td>
<td class="cellrowborder" valign="top" width="58.489999999999995%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122609_p619772512611"></a><a name="zh-cn_topic_0237122609_p619772512611"></a>当前线程调用函数的总的时长。
</td>
</tr>
</tbody>
</table>

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

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

STAT_XACT_USER_FUNCTIONS

视图包含当前节点本事务内函数执行的统计信息。

表 1 STAT_XACT_USER_FUNCTIONS字段

名称	类型	描述
funcid	oid	函数标识。
schemaname	name	模式的名称。
funcname	name	函数名称。
calls	bigint	函数被调用的次数。
total_time	double precision	函数的总执行时长。
self_time	double precision	当前线程调用函数的总的时长。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.1.0

openGauss / docs

STAT_XACT_USER_FUNCTIONS

简介

发行版

贡献者

近期动态

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

STAT_XACT_USER_FUNCTIONS

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs