数据仓库服务 GAUSSDB(DWS)-统计信息函数:pgxc_get_wlm_session_info_bytime(text, timestamp without time zone, timestamp without time zone, int)

时间:2024-04-18 16:25:03

pgxc_get_wlm_session_info_bytime(text, timestamp without time zone, timestamp without time zone, int)

描述:PGXC_WLM_SESSION_INFO视图在统计数据量很大的场景中性能较差,建议使用该函数进行筛选查询。入参分别为:筛选时间列('start_time', 'finish_time'),起始区间时间,结束区间时间,每个CN返回的最大数量。返回值为GS_WLM_SESSION_HISTORY。

返回值类型:setof record

support.huaweicloud.com/sqlreference-830-dws/dws_06_0065.html