Sample Header Ad - 728x90

What are some likely causes of high Client:ClientRead AAS in AWS RDS?

3 votes
1 answer
2943 views
I have a particular query, its a simple select with an inner join. Seems to be pretty well indexed. But it's registering as a worst offender in performance insights. With a 0.13 on CPU and a 4.5 on Client:ClientRead. All the documentation and articles I can find indicate this is common for bulk data copying. But I don't think this is the case. Since it's such a basic select. It's being called around 70 times per second. Which isn't even that high compared to others I have in the 500 calls per second, and it's only serving back about 7 rows, 10 columns each. So other than bulk data copying, what other factors might be giving me a high AAS for clientRead?
Asked by invertedSpear (201 rep)
Apr 6, 2021, 03:30 PM
Last activity: Dec 16, 2021, 02:06 PM