PostgreSQL 12.2: rdsadmin uses one complete CPU for a query continuously

Question

Hi,  
  
After upgrading from **Postgres 11.6** to **Postgres 12.2**, I see the below query running continuously by **rdsadmin** user which utilize _**1 CPU session**_ (Performance insight metric) always.

```
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';
```

**Support SQL ID**: ABC984CB7D824C0B21231ED51029F922E2B7B905  
**Support Digest ID**: 06A5CA3B12445E220C7E915CF1F050004A10A957

Accepted Answer

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.  
  
Kyle

Answer

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

Answer

Hi HalTemp,  
  
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.  
  
Screenshot: https://pasteboard.co/J74z88Z.jpg

Answer

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.

PostgreSQL 12.2: rdsadmin uses one complete CPU for a query continuously

Contenuto pertinente