I have a problem that CPU Session continuously uses session with rds admin query in RDS postgresql15.3, occupies

1

Hello, I'm working on database migration.

I restored my database with snapshot from different account, and upgraded RDS postgresql version to 15.3. But all of my databases (write for 1 and readonly for 3) are showing metrics of session 1 with rdsadmin query.

In performance insight, this SQL Statement 'select pid, usename, client_addr, client_hostname, wait_event_type, wait_event_type || ? || wait_event as wait_event, query, datname, application_name, backend_type, query_id from pg_stat_activity w where w.state = ? and COALESCE(w.wait_event,?) not in (?,?)' shows Load the highest Load 1.0 by waits (AAS)

I found a similar issue raised in 12.2 (https://repost.aws/questions/QUhzcRl7G0S_WGVwjkIeZ8Sw/postgresql-12-2-rdsadmin-uses-one-complete-cpu-for-a-query-continuously). Is this issue related to the issue raised in 12.2? or Should I take some actions to fix this?

已提问 1 年前67 查看次数
没有答案

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

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

回答问题的准则