From: | Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge |
Date: | 2024-06-18 12:10:02 |
Message-ID: | AS4PR10MB55453B71CDBE29FAE75645478DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)albe(at)cybertec(dot)at>
Sent: Tuesday, June 18, 2024 5:11 PM
To: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org
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
From | Date | Subject | |
---|---|---|---|
Next Message | lennam | 2024-06-18 13:22:59 | RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge |
Previous Message | Laurenz Albe | 2024-06-18 11:40:32 | Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge |