活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

GS_SESSION_MEMORY视图统计Session级别的内存使用情况，包含执行作业在数据节点上gaussdb线程和Stream线程分配的所有内存。当GUC参数enable_memory_limit的值为off时，本视图不可用。<figure class="table"><table style=";"><tbody><tr><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:0.0000pt 5.4000pt;vertical-align:top;width:113.7500pt;">名称</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:0.0000pt 5.4000pt;vertical-align:top;width:127.5000pt;">类型</td><td style="background-color:rgb(215, 215, 215);border:1.0000pt solid windowtext;padding:0.0000pt 5.4000pt;vertical-align:top;width:184.9000pt;">描述</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:113.7500pt;">sessid</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:127.5000pt;">text</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:184.9000pt;">线程启动时间+线程标识。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:113.7500pt;">init_mem</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:127.5000pt;">integer</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:184.9000pt;">当前正在执行作业进入执行器前已分配的内存，单位MB。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:113.7500pt;">used_mem</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:127.5000pt;">integer</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:184.9000pt;">当前正在执行作业已分配的内存，单位MB。</td></tr><tr><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:113.7500pt;">peak_mem</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:127.5000pt;">integer</td><td style="border-bottom:1.0000pt solid windowtext;border-left:1.0000pt solid windowtext;border-right:1.0000pt solid windowtext;border-top-style:none;padding:0.0000pt 5.4000pt;vertical-align:top;width:184.9000pt;">当前正在执行作业已分配的内存峰值，单位MB。</td></tr></tbody></table></figure>

GBase 8c

GS_SESSION_MEMORY系统视图说明

名称	类型	描述
sessid	text	线程启动时间+线程标识。
init_mem	integer	当前正在执行作业进入执行器前已分配的内存，单位MB。
used_mem	integer	当前正在执行作业已分配的内存，单位MB。
peak_mem	integer	当前正在执行作业已分配的内存峰值，单位MB。

GS_SESSION_MEMORY系统视图说明

热门帖子