常用Prometheus SQL

1、主机存活状态

up{project=~"$project"} == 1 # 机器启动状态
up{project=~"$project"} != 1  # 机器非启动状态

 2、CPU空闲率

avg by (instance) (irate(node_cpu_seconds_total{instance=~"****", mode="idle"}[5m])) * 100

 3、磁盘使用率

(100 - sum by (instance,mountpoint)(node_filesystem_avail_bytes{instance=~"****",fstype!~"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs|udev|none|devpts|sysfs|debugfs|fuse.*"}) / sum by (instance,mountpoint) (node_filesystem_size_bytes{instance=~"****",fstype!~"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs|udev|none|devpts|sysfs|debugfs|fuse.*"}) * 100)

 4、IO

sum by (instance) (irate(node_disk_io_time_seconds_total{instance=~"****"}[3m]))

 5、网络流量

sum by (instance) (irate(node_network_receive_bytes_total{instance=~"****",device!~"bond.*|lo"}[3m]))/1000/1000/125

 6、内存使用率

100 - (node_memory_MemFree_bytes{instance="1.1.1.1",job="bas"} + node_memory_Buffers_bytes{instance="1.1.1.1",job="bas"} + node_memory_Cached_bytes{instance="1.1.1.1",job="bas"}) / node_memory_MemTotal_bytes{instance="1.1.1.1",job="bas"} * 100

 7、磁盘平均读 （IO）M

avg by (instance)(irate(node_disk_read_bytes_total{instance=~"****",job="basic-server"}[5m])/1024/1024)

 8、磁盘平均写（IO）M

avg by (instance)(irate(node_disk_written_bytes_total{instance=~"****",job="basic-server"}[5m])/1024/1024)

 9、网络平均上行（M）

avg by (instance) (irate(node_network_transmit_bytes_total{instance=~"****",job="basic-server"}[5m])/1024/1024)

 10、swap使用 M

(node_memory_SwapTotal_bytes{instance=~"****",job="basic-server"} - node_memory_SwapFree_bytes{instance=~"****",job="basic-server"})/1024/1024

 11、网络平均下行（M）

avg by (instance) (irate(node_network_receive_bytes_total{instance=~"****",job="basic-server"}[5m])/1024/1024)

 12、统计存活总量

count(probe_success{project=~"$project"})

 13、启动时间

windows：
(time() - wmi_system_system_up_time{instance=~"$ip",job="basic-server"}) / 86400
Linux：
sum(time() - node_boot_time_seconds{instance=~"$ip",job="basic-server"})by(instance) / 86400

 14、CPU数量

windows：
wmi_cs_logical_processors{instance=~"$ip",job="zhoujiangtao"}
Linux：
count(node_cpu_seconds_total{instance=~"$ip",mode='system',job="zhoujiangtao"}) by (instance)

 15、磁盘使用率

windows：
(1 - (sum(wmi_logical_disk_free_bytes{instance=~"$ip",volume=~"^[A-Z]:.*$"}) / sum(wmi_logical_disk_size_bytes{instance=~"$ip",volume=~"^[A-Z]:.*$"}))) * 100
Linux：
max((node_filesystem_size_bytes{instance=~"$ip",fstype=~"ext.?|xfs"}-node_filesystem_free_bytes{instance=~"$ip",fstype=~"ext.?|xfs"}) *100/(node_filesystem_avail_bytes {instance=~"$ip",fstype=~"ext.?|xfs"}+(node_filesystem_size_bytes{instance=~"$ip",fstype=~"ext.?|xfs"}-node_filesystem_free_bytes{instance=~"$ip",fstype=~"ext.?|xfs"})))by(instance)

 16、tcp连接数

node_netstat_Tcp_CurrEstab{instance=~"$ip"}