Re: Controlling resource utilization

On Wed, 17 Apr, 2024, 12:40 pm , <gparc(at)free(dot)fr> wrote:

>
>
> ------------------------------
>
> *De: *"Juan Rodrigo Alejandro Burgos Mella" <rodrigoburgosmella(at)gmail(dot)com>
> *À: *"yudhi s" <learnerdatabase99(at)gmail(dot)com>
> *Cc: *"pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
> *Envoyé: *Mardi 16 Avril 2024 22:29:35
> *Objet: *Re: Controlling resource utilization
>
> 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?

>