On Wed, 17 Apr, 2024, 12:40 pm , <gparc@xxxxxxx> wrote:
De: "Juan Rodrigo Alejandro Burgos Mella" <rodrigoburgosmella@xxxxxxxxx>
À: "yudhi s" <learnerdatabase99@xxxxxxxxx>
Cc: "pgsql-general" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Envoyé: Mardi 16 Avril 2024 22:29:35
Objet: Re: Controlling resource utilizationRegardsALTER ROLE <your-username> SET statement_timeout = '<time_unit>';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?
