Higher CPU usage than usual db.t2.large Postgresql

0

Hello,

Since Wednesday, 26.05., we are experiencing higher CPU usage than usual on our db.t2.large Postgresql instance in eu-west-1a region. The usage is always above the 30% threshold and our CPU credits are almost over since they are reaching critical levels. The database is servicing a website which is not really that heavy and even during the night there are no visitors, just crawlers. For the first month and a half we didn't have any issues and now suddenly even if there are no connections the CPU usage is 26-28% and our credit usage is constantly above 3.

There is no increase in the users of the website, no problem with the EC2 server, no difference at all. It's even a weekend and there is even less writing on the DB, but still we are 300 credits down since yesterday. We are expecting to reach 0 credit balance at the end of today and the next week hasn't even started yet, when the people are actually active on the site.

What can we do? I have rebooted the instance, turned on Enhanced monitoring which proved that during the night there are 0 connections most of the time.

已提问 5 年前224 查看次数
2 回答
0

Apparently bots can cause this even if their crawling triggers one of the quickest requests. Quantity over quality here. Please delete the thread.

已回答 5 年前
0

What version of PostgreSQL is this?

Have you tried Performance Insights to see where the load is coming from?

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.html

Kyle

已回答 5 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则