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 年前510 查看次数

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

相关内容