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?

asked a year ago63 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions