Sample Header Ad - 728x90

high cpu spikes on postgresql (rds)

0 votes
1 answer
310 views
I have a PG 15(.5) RDS instance, which is experiencing intermittent random(?) periods of high cpu; that do not seem to, afaict, correlate with an obvious cause: perf insights - high cpu Here is one example. The queries being made before/during & after are the same; and if run with the same params once the cpu drops back down, are quick as before. I also don't see any increase in transactions: tps or tuples: tuples during that period; or any large vacuum. The only graph that seems to line up, is this one: IO cache vs. disk reads (Blocks per second) according to the pg docs, this is: > Number of times disk blocks were found already in the buffer cache, so that a read was not necessary so I'm not clear why that would be related. The instance is an db.r7g.8xlarge, with 1758 GiB of gp2; and isn't running particularly hot, as the graph shows. Is there something I can do to find out what the cpu is actually doing? Do I need to catch it in the act?
Asked by grahamrhay (101 rep)
Jun 6, 2024, 02:33 PM
Last activity: May 21, 2025, 09:01 PM