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?

gefragt vor einem Jahr67 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen