How to set query timeout time in RDS postgres

Question

Can we set the query timeout option in the AWS Postgres instance?

I know we can do it locally in the configuration file if we have a local setup but not sure about AWS RDS.

Any help would be appreciated because due to the above issue CPU utilization is increasing.

Answer 1

You can achieve it by creating Parameter groups in AWS RDS

Please follow below steps.

1. Go to AWS Console -> Amazon RDS
2. Select Parameter Group to create parameter group
3. select appropriate version of Postgres,provide group name and click on create.
4. Now select the created Parameter Group and search the parameter as statement_timeout
5. Click on Edit Parameter button and set the value inside the Values box
6. Save changes.
7. Now while creating or modifying the database select newly created parameter group.