Postgresql 14.3 Performance insight RDS Admin Never Stopping Query Bug

1

Related to https://repost.aws/questions/QUhzcRl7G0S_WGVwjkIeZ8Sw/postgresql-12-2-rdsadmin-uses-one-complete-cpu-for-a-query-continuously https://repost.aws/questions/QUKRiZ5SyHTsmXaa9r5Lnsuw/performance-insights-for-postgres-12-2-is-consuming-100-cpu

It appears this bug has made a come back with PostgreSQL 14.3. The query that appears is the following :

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 = 'active' and COALESCE(w.wait_event,'') not in ('WalSenderMain','WalSenderWaitForWAL');

Can you confirm this is purely a Performance Insight bug and could you look into a fix ?

Thanks a lot !

sachal
已提问 1 年前319 查看次数
1 回答
0

Hello,

This is a know issue in the Performance Insights and it should not cause any performance impact on your instance. We understand that this is a sub-optimal experience, and apologize for any inconvenience it causes. The RDS Performance Insights team is working on a quick, secure workaround to address the issue.

I hope this helps!

AWS
已回答 10 个月前

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

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

回答问题的准则