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.

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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인