CPU内存每月的平均使用率

最新推荐文章于 2025-07-29 15:57:41 发布

原创最新推荐文章于 2025-07-29 15:57:41 发布 · 865 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个用于获取过去两个月内系统CPU和内存平均使用情况的API实现方案。通过查询特定的历史数据表，该API能够收集并返回指定时间段内的系统资源利用率数据。

def add_months(sourcedate, months):
month = sourcedate.month - 1 + months
year = int(sourcedate.year + month / 12)
month = month % 12 + 1
day = min(sourcedate.day, calendar.monthrange(year, month)[1])
return datetime.date(year, month, day)

class cpumem_api():
def get(self):
self.set_header("Content-Type", "application/json")
# this_time = add_months(datetime.datetime.today(), -2)
# years = this_time.strftime('%Y')
# month = this_time.strftime('%m')
# index = int(int(month) - 1)
# for this_month in month_list:
# this_month = month_list[index]
# index = index + 1

today = datetime.datetime.today()
this_list = []
month_count = 0
while month_count < 2:
day = today - relativedelta(months=month_count)
this_list.append(day.strftime('%Y%m'))
month_count += 1
results = {}
cpus = []
mems = []
for item in this_list:
sql = """
SELECT avg(sy+us+id) FROM his_cpu_mon_%s
""" % item
cpu = list(self.pg.db.query(sql))
cpus.append(apu)
sql = """
SELECT avg(us) FROM his_mem_mon_%s
""" % item
mem = list(self.pg.db.query(sql))
mems.append(mem)
results['cpus'] = cpus
results['mems'] = mems
data = json.dumps({"data": results}, cls=public_bz.ExtEncoder)
self.write(data)