RDS performance insight SQL query "other"

Other is just compile of some other minor events, usually they aren't a reason for the problem.

You probably see "CPU" / "Vaccum" / "Lock:" as reason for high CPU utilization. The Load you are seeing as well, might be caused by concurrent sessions, assuming 4CPU database, if you start 8 queries at the same time, you will probably notice some CPU wait/load in the database.

It's hard to give any real insights without more details.

In Performance Insights, ‘Other’ means that there's not one single item that occupies most of the resource - rather, the collective of "others" is distributing most of the resources among them.

You can also define “Other SQL" as the aggregate amount of queries that weren't enough to make it into the TopN. A high "Other" usually means there were a lot of other queries happening at the time but no particular query significantly impacted database time.

For additional details and specifics, kindly open a support case with our Support Engineering team with instance details. https://console.aws.amazon.com/support/home#