public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: yudhi <[email protected]>
Cc: Juan Rodrigo Alejandro Burgos Mella <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Controlling resource utilization
Date: Wed, 17 Apr 2024 10:14:23 +0200 (CEST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEzWdqdJzxUjotQYPpN-6zropJ3e9gMHYOxvtunjJaQj5H1FQA@mail.gmail.com>
References: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com>
	<CAHbZ42wp3330nZcEWWq5PS5UrB36TCCW7iw=+q122bj_ejQoAg@mail.gmail.com>
	<CAEzWdqcHxchRxcAYr_OQaVbYOfAEqOCgshGuydf0LmLBe0waZQ@mail.gmail.com>
	<CAHbZ42zeyjryzSQH=X+TPutaVOOhGT9sOa1HEBF__eALowUngA@mail.gmail.com>
	<[email protected]>
	<CAEzWdqdJzxUjotQYPpN-6zropJ3e9gMHYOxvtunjJaQj5H1FQA@mail.gmail.com>

> De: "yudhi" <[email protected]>
> À: "gparc" <[email protected]>
> Cc: "Juan Rodrigo Alejandro Burgos Mella" <[email protected]>,
> "pgsql-general" <[email protected]>
> Envoyé: Mercredi 17 Avril 2024 09:42:49
> Objet: Re: Controlling resource utilization

> On Wed, 17 Apr, 2024, 12:40 pm , < [ mailto:[email protected] | [email protected] ] >
> wrote:

>>> De: "Juan Rodrigo Alejandro Burgos Mella" < [
>>> mailto:[email protected] | [email protected] ] >
>>> À: "yudhi s" < [ mailto:[email protected] |
>>> [email protected] ] >
>>> Cc: "pgsql-general" < [ mailto:[email protected] |
>>> [email protected] ] >
>>> 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?

To verify the setting, you can use this command in psql : \drds <your-username> 

Concerning system resources like CPUs it's not possible. 
You can use pg_settings view to see which setting you can change and in which context : [ https://www.postgresql.org/docs/current/view-pg-settings.html | https://www.postgresql.org/docs/current/view-pg-settings.html ] 

Regards 
Gilles 

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Controlling resource utilization
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox