ALTER ROLE <your-username> SET statement_timeout = '<time_unit>';
Regards
Gilles
Thank you so much. That helps.
This statement is succeeding for user as I executed. So it's working I believe.
But to immediately verify without manually running queries and waiting for it to be auto killed to confirm, Is there any system table which we can verify to see if this setting is effective, as because I don't see any such columns in pg_user or pg_role which shows the statement_timeout.
And is there a way to put similar cap/restrictions on other db resources like cpu, memory, I/O at specific user/role level?
To verify the setting, you can use this command in psql : \drds <your-username>
Concerning system resources like CPUs it's not possible.