查看用户对应的资源队列的占比 select usename,rsqname,activestats,memorylimit,corelimit,vsegresourcequota from pg_user,pg_roles,pg_resqueue where pg_user.usename = pg_roles.rolname and pg_roles.rolresqueue = pg_resqueue.oid; --查看每个结点的内存 show hawq_rm_memory_limit_perseg ; hawq_rm_memory_limit_perseg --查看每个结点的core show hawq_rm_nvcore_limit_perseg ; hawq_rm_nvcore_limit_perseg