加入 Gitee

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

克隆/下载

SESSION_MEMORY_RUNTIME.md 13.36 KB

# SESSION\_MEMORY\_RUNTIME<a name="ZH-CN_TOPIC_0245374748"></a>

SESSION\_MEMORY\_RUNTIME视图显示和当前用户执行复杂作业正在运行时的负载管理内存使用的信息。

**表 1**  SESSION\_MEMORY\_RUNTIME字段

<a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_tce1ea54f74504644b7f980853f22794a"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r14b9fa4a58204bbab642f0bf46f3f8de"><th class="cellrowborder" valign="top" width="21.97%" id="mcps1.2.4.1.1"><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a3fcf91a0349b474682cfc07d8a313fa9"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a3fcf91a0349b474682cfc07d8a313fa9"></a>名称
</th>
<th class="cellrowborder" valign="top" width="25.590000000000003%" id="mcps1.2.4.1.2"><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a60661672ed474fd5b40472e38ed8b327"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a60661672ed474fd5b40472e38ed8b327"></a>类型
</th>
<th class="cellrowborder" valign="top" width="52.44%" id="mcps1.2.4.1.3"><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ad90d348199094bf0844cb534a0a3396e"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ad90d348199094bf0844cb534a0a3396e"></a>描述
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r7158c77052434dae83b32f56bee4d6e7"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a61c2c478cc3a49f799b5b68c28176baf"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a61c2c478cc3a49f799b5b68c28176baf"></a>datid
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ae9a7e937a6554d858098f2b969cb41c7"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ae9a7e937a6554d858098f2b969cb41c7"></a>oid
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a17756112b1744cb5b7cd24d594652cbb"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a17756112b1744cb5b7cd24d594652cbb"></a>连接后端的数据库OID。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r5546c6cba2754c4080d9d5877dd6b113"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a895d8adfdab94401b41aecbdf073a4ba"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a895d8adfdab94401b41aecbdf073a4ba"></a>usename
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a493e76ffbeba4e8088f3ecfdb18a11f2"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a493e76ffbeba4e8088f3ecfdb18a11f2"></a>name
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_af25195a9f1bf4052ab0b7ffd846938f2"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_af25195a9f1bf4052ab0b7ffd846938f2"></a>登录到该后端的用户名。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r86ba9ba4bd5b4bb595c5ea15b99e24ff"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ac59cc014238a4799b204cca486c421de"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_ac59cc014238a4799b204cca486c421de"></a>pid
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a4f95f46565034c008164059d39b18395"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a4f95f46565034c008164059d39b18395"></a>bigint
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a709556b91beb493783674a9585377b8d"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a709556b91beb493783674a9585377b8d"></a>后端线程ID。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_re6c14be36872468b8f01e3f260e9f0bc"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a057b7566759b43cd88634e295ba3bb27"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a057b7566759b43cd88634e295ba3bb27"></a>start_time
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aa5bc4c52045242d18e3bee93ba6d7fdd"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aa5bc4c52045242d18e3bee93ba6d7fdd"></a>timestamp with time zone
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a39d3f079fe4343448547033bb4a1b671"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a39d3f079fe4343448547033bb4a1b671"></a>语句执行的开始时间。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r99466f64fb374203aa552172de792487"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a6cc65231d18b4ca899985835e5b5b08e"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a6cc65231d18b4ca899985835e5b5b08e"></a>min_peak_memory
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a192275ba936e40d988e45d9c5f88a72b"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a192275ba936e40d988e45d9c5f88a72b"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a5414192b19be4cefbcfd461e902d4436"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a5414192b19be4cefbcfd461e902d4436"></a>语句在数据库节点上的最小内存峰值大小，单位MB。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_re055c85bc03840d4b060bbf387917f9b"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a59c3cd806b5c499f8687c6ef3d0b9cef"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a59c3cd806b5c499f8687c6ef3d0b9cef"></a>max_peak_memory
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a84bb9a95e91e4571a33e06bd0ffd3fd8"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a84bb9a95e91e4571a33e06bd0ffd3fd8"></a>integer
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a629c6cd6f2f74cbfaf5ba0eb93a87cf9"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a629c6cd6f2f74cbfaf5ba0eb93a87cf9"></a>语句在数据库节点上的最大内存峰值大小，单位MB。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r9e7963aa6ddd4e76b55f4b0c86a9eced"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a4e699fac705342f494d33f7f37efde07"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a4e699fac705342f494d33f7f37efde07"></a>spill_info
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aae3018b41e064e4ba9e7ac6ca05d3b43"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aae3018b41e064e4ba9e7ac6ca05d3b43"></a>text
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><div class="p" id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aa9b7a1e8f84048e0aab9363ce5863040"><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aa9b7a1e8f84048e0aab9363ce5863040"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_aa9b7a1e8f84048e0aab9363ce5863040"></a>语句在数据库节点上的下盘信息：<a name="zh-cn_topic_0237122644_ul16420191016115"></a><a name="zh-cn_topic_0237122644_ul16420191016115"></a><ul id="zh-cn_topic_0237122644_ul16420191016115"><li>None：数据库节点均未下盘</li><li>All：数据库节点均下盘</li><li>[a:b]：数量为b个数据库节点中有a个数据库节点下盘</li></ul>
</div>
</td>
</tr>
<tr id="zh-cn_topic_0237122644_zh-cn_topic_0059778509_r20a852653bf04c838d4916f7e2ea5e8d"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_abc4cb8f0eb84413db0788a258c9b4460"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_abc4cb8f0eb84413db0788a258c9b4460"></a>query
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a2f3e2b88c74441459690cb44ea0a2bce"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a2f3e2b88c74441459690cb44ea0a2bce"></a>text
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a2acd1ec4776046228cf63bba17211a36"></a><a name="zh-cn_topic_0237122644_zh-cn_topic_0059778509_a2acd1ec4776046228cf63bba17211a36"></a>正在执行的语句。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_row154664212341"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_p646772133417"></a><a name="zh-cn_topic_0237122644_p646772133417"></a>node_group
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_p44671211349"></a><a name="zh-cn_topic_0237122644_p44671211349"></a>text
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_p8467629348"></a><a name="zh-cn_topic_0237122644_p8467629348"></a>语句所属用户对应的逻辑openGauss。
</td>
</tr>
<tr id="zh-cn_topic_0237122644_row1256413231231"><td class="cellrowborder" valign="top" width="21.97%" headers="mcps1.2.4.1.1 "><a name="zh-cn_topic_0237122644_p628521318590"></a><a name="zh-cn_topic_0237122644_p628521318590"></a>top_mem_dn
</td>
<td class="cellrowborder" valign="top" width="25.590000000000003%" headers="mcps1.2.4.1.2 "><a name="zh-cn_topic_0237122644_p182861313165916"></a><a name="zh-cn_topic_0237122644_p182861313165916"></a>text
</td>
<td class="cellrowborder" valign="top" width="52.44%" headers="mcps1.2.4.1.3 "><a name="zh-cn_topic_0237122644_p10286101313597"></a><a name="zh-cn_topic_0237122644_p10286101313597"></a>mem使用量topN信息。
</td>
</tr>
</tbody>
</table>

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

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

SESSION_MEMORY_RUNTIME

SESSION_MEMORY_RUNTIME视图显示和当前用户执行复杂作业正在运行时的负载管理内存使用的信息。

表 1 SESSION_MEMORY_RUNTIME字段

名称	类型	描述
datid	oid	连接后端的数据库OID。
usename	name	登录到该后端的用户名。
pid	bigint	后端线程ID。
start_time	timestamp with time zone	语句执行的开始时间。
min_peak_memory	integer	语句在数据库节点上的最小内存峰值大小，单位MB。
max_peak_memory	integer	语句在数据库节点上的最大内存峰值大小，单位MB。
spill_info	text	语句在数据库节点上的下盘信息： None：数据库节点均未下盘 All：数据库节点均下盘 [a:b]：数量为b个数据库节点中有a个数据库节点下盘
query	text	正在执行的语句。
node_group	text	语句所属用户对应的逻辑openGauss。
top_mem_dn	text	mem使用量topN信息。

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

git@gitee.com:opengauss/docs.git

opengauss

docs

1.1.0

openGauss / docs

SESSION_MEMORY_RUNTIME

简介

发行版

贡献者

近期动态

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

SESSION_MEMORY_RUNTIME

简介

发行版

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

贡献者

近期动态

搜索帮助

openGauss / docs