How to set postgres query execution timeout from application level?

Question

I am creating a web application in php(using Laravel), I would like to set a query execution timeout to PostgreSQL but I don't have access to server configuration, so is there any other way set query execution timeout through application level?

Thank you

Use a DB-level or user-level configuration: 1. ALTER DATABASE postgres SET statement_timeout='1s'; 2. ALTER ROLE postgres SET statement_timeout='1s'; — kbridge4096
– kbridge4096, Commented Apr 20, 2019 at 10:24

greg · Accepted Answer · 2016-07-01 09:54:38Z

23

Simply send the following statement:

set statement_timeout TO 100;

Postgresql will then cancel all queries exceeding 100ms.

answered Jul 1, 2016 at 9:54

greg

3,5351 gold badge27 silver badges35 bronze badges

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

1 Comment

Dipu R Over a year ago

thank you, for you quick response, is there any PDO configuration or is there any way to run an init query in laravel?

Collectives™ on Stack Overflow

How to set postgres query execution timeout from application level?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related