语法
SELECT * FROM information_schema.processlist WHERE resource_pool_name =’
pool_name’ AND vc=’vc_name’;
可以加如下辅助查询条件,如:
running_time = 0; //等待任务
示例
gbase> SELECT * FROM information_schema.processlist\G
*************************** 1. row ***************************
ID: 524
TASKID: 0
SUBTASKID: 0
THREADID: 27957
USER: root
HOST: 192.168.6.154:27779
VC: vcname000001
DB: NULL
COMMAND: Sleep
START_TIME: 2018-07-06 14:39:43
TIME: 612
STATE:
RESOURCE_POOL_NAME: NULL
RESOURCE_POOL_ID: NULL
RESOURCE_POOl_PRIORITY: NULL
WAITING_TIME: NULL
RUNNING_TIME: NULL
LOCK: NULL
WAIT: NULL
INFO: NULL
TRACE: NULL
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
498