Php max runtime - postgresql

Question

Is it possible to use PostgreSQL functions in PHP, so you can specify the maximum query execution time? I do not want to include this from the configuration file because I need to limit only certain requests.

Answer 1

run from php request before the main request

as

SET statement_timeout TO 5000; 

Answer 2

You can use set_time_limit() According to the PHP doc:

When called, set_time_limit() restarts the timeout counter from zero. In other words, if the timeout is the default 30 seconds, and 25 seconds into script execution a call such as set_time_limit(20) is made, the script will run for a total of 45 seconds before timing out When called, set_time_limit() restarts the timeout counter from zero. In other words, if the timeout is the default 30 seconds, and 25 seconds into script execution a call such as set_time_limit(20) is made, the script will run for a total of 45 seconds before timing out .