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.

Not sure how different the RDS version is, but in regular Postgres you don't need to edit a config file to achieve that, you can simply run set statement_timeout = ...; to change that value for your session. — user330315
– user330315, Commented Jan 13, 2020 at 12:26

Raj Paliwal · Accepted Answer · 2020-01-15 11:44:18Z

21

You can achieve it by creating Parameter groups in AWS RDS

Please follow below steps.

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

answered Jan 15, 2020 at 11:44

Raj Paliwal

9471 gold badge9 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

If this answer helped you, could you please accept it

What is the default value, if you don't enter one?

@user2468842 the default is 0, which is equivalent to no timeout

Can the same be done per user?