Postgresql 14.3 Performance insight RDS Admin Never Stopping Query Bug

Question

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 !

Sachin_M · Answer

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!

Postgresql 14.3 Performance insight RDS Admin Never Stopping Query Bug

Relevant content