Hello @Laurenz, Thank you for your quick response. However, the parameters are already in place as you said. Although, there is no issue with the update statement. The Execution Plan and the usage of index is optimal for the query. I just want to verify if any connection pooling is required from database side Regards, Phani -----Original Message----- From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx> Sent: Tuesday, June 18, 2024 5:11 PM To: Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge On Tue, 2024-06-18 at 10:38 +0000, Phani Prathyush Somayajula wrote: > I have an AWS RDS instance > > We are seeing a lot of CPU consumption where we’re load testing our application. > The query which is taking a lot of time is running less than 1ms if I > run through my psql client on the server and is taking 162ms if I run it from dBeaver. > > I just want to analyse if the parameters that I set are optimal to the application or not. I don't think that twiddling the parameters will make a lot of difference there. The exception could be if you are retrieving results with a cursor; then setting "cursor_tuple_fraction" to 1 could make a difference. Other than that, you should use auto_explain with "auto_explain.log_analyze = on" and "auto_explain.log_buffers = on" to capture an execution plan from the slow execution with DBeaver or your application. Examining that plan should show what is going on. Yours, Laurenz Albe
