VM资源统计

#统计一个集群，所有计算节点上的VM的资源大小：cpu、内存、磁盘

SELECT

SUM(vcpus) AS total_vcpus,

SUM(memory_mb) AS total_memory_mb,

SUM(memory_mb) / 1024 AS total_memory_gb,

SUM(root_gb) AS total_disk_gb

FROM

instances

WHERE node IN (

'compute1.openstack.ops.bj4.wormpex.com',

'compute5.openstack.ops.bj4.wormpex.com',

'compute3.openstack.ops.bj4.wormpex.com',

'compute4.openstack.ops.bj4.wormpex.com',

'compute2.openstack.ops.bj4.wormpex.com',

'compute6.openstack.ops.bj4.wormpex.com' )

and vm_state='active';