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?

posta un anno fa65 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande