3

Hello I'm looking at Performance Insights in AWS RDS (Postgres 10)

I slice by "Waits"

enter image description here

enter image description here

enter image description here

When I see Top databases, Top Applications, Top session Types and Top Users they are all actually higher than the SQL queries it self

From these metrics how do you tell what is bottlenecking the CPU?

deagleshot
  • 175
  • 7
  • Get the full SQL and not just the first so many characters, then do an `EXPLAIN` (or better yet `EXPLAIN (ANALYZE, BUFFERS)`) of it. – jjanes Dec 01 '22 at 23:27
  • "When I see Top databases, Top Applications, Top session Types and Top Users they are all actually higher than the SQL queries it self" Are those things comparable to each other? – jjanes Dec 01 '22 at 23:30

1 Answers1

2

Top waits, Top SQL, etc. are all different dimensions that you can use to understand what's contributing to database load. Dimensions are not comparable with each other.

It sounds like you want to diagnose what's contributing to the PostgreSQL "CPU" wait event. You can find more information on this topic in the official RDS docs on Tuning with wait event.

If the issue turns out to be suboptimal queries, then you can find the worst performers in the Top SQL tab (dimension) of Performance Insights.

jtoberon
  • 8,706
  • 1
  • 35
  • 48