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?

preguntada hace un año65 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas