Read the docs on going SET statement_timeout TO ...;
Chris
Michael Ryan S. Puncia wrote:
Hi,
How can I automatically kill a process in the database (ex a select or
explain) if it exceeds my limit of 2 or 3 mins ..
For example : I have a query that already running for 3 or 4 mins I
want to k
Hi,
How can I automatically kill a process in the database (ex a
select or explain) if it exceeds my limit of 2 or 3 mins ..
For example : I have a query that already running for
3 or 4 mins I want to kill that process for a reason and return a
Signal to the user.
Thanks
Michael
