Performance Insights for Postgres 12.2 is consuming 100% CPU

A query for select datname, pid, usename, application_name, client_addr, client_hostname, wait_event_type, wait_event, query, backend_type from pg_stat_activity where state = 'active' is running permanently under user rdsadmin from 127.0.0.1, consuming 100% CPU on Postgres 12.2 in RDS.

主題

資料庫

標籤

效能洞察

語言

English

Blg

已提問 4 年前檢視次數 505 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

Yes, this is an issue with Performance Insights on Postgres 12.2.
The query in questions runs with minimal CPU and the display of 100% CPU is incorrect.
A fix has been implemented and will be rolled out to the fleet.

Kyle

AWS-User-1731424

已回答 4 年前

Performance Insights for Postgres 12.2 is consuming 100% CPU

相關內容