Yes, this is a bug in PI on RDS PostgreSQL 12.2.
It is misreporting this query as taking up CPU when in fact it is not.
Will try and get a status on when this will be resolved.
For the time being this SQL and CPU load attributed to it can be ignored.
That looks like it may be a Performance Insight query, so would only happen while running PI. Anyway, not clear anyone from the RDS team will see your post as they don't regularly participate in the forum. Since it looks like PI you could try to PM awskyleh so he'll see it the next time he logs into the forum.
I have sent a PM to awskyleh. Its been more than 30 days, no response from him.
Is there any way I can raise this bug to RDS PI team?
I'm not able to trust the PI stats anymore because of this issue.
We are having the same issue since upgrading to PostgreSQL 12.2.
We ran some benchmarks and it does not look like a full CPU is blocked by the query as Performance Insights indicates, but of course, it makes the PI charts harder to use...
Any news on this or how to proceed would be highly appreciated
Fetch the number of rows returned/affected by a SQL queryasked 4 months ago
FATAL: password authentication failed for user "postgresasked 5 years ago
How can I migrate a jsonb column from postgres on RDS to S3?asked 2 months ago
RDS PostgreSQL 11.1: high CPU and Write IOPS after upgrade?asked 3 years ago
Poor query performance after upgrading from Aurora PostgreSQL 12 to 13asked 4 months ago
PostgreSQL 12.2: rdsadmin uses one complete CPU for a query continuouslyAccepted Answerasked 3 years ago
Redshift Federated Query (RDS Postgres) Long Varchar Value Error (code 25101)asked 4 months ago
Performance Insights for Postgres 12.2 is consuming 100% CPUasked 2 years ago
How to create SSL dblink connection from RDS to postgres on premise?asked 8 months ago
60K updates to RDS Postgres - performance challengeAccepted Answerasked 2 years ago