4

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?

Improve this question
2
  • Get the full SQL and not just the first so many characters, then do an EXPLAIN (or better yet EXPLAIN (ANALYZE, BUFFERS)) of it. Commented Dec 1, 2022 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? Commented Dec 1, 2022 at 23:30

1 Answer 1

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.