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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ