Postgres Pro
Downloads
Home   >   mailing lists

Re: User roles for gathering performance metrics data - Mailing list pgsql-general

From Christophe Pettus
Subject Re: User roles for gathering performance metrics data
Date
Msg-id 3CA91D7E-0CD1-41BD-B710-3785D86645CE@thebuild.com
Whole thread Raw
In response to User roles for gathering performance metrics data  (Siraj G <tosiraj.g@gmail.com>)
List pgsql-general
Tree view 

> On Mar 26, 2024, at 22:30, Siraj G <tosiraj.g@gmail.com> wrote:
> I am from Oracle background. In Oracle, we grant select_catalog_role or select any dictionary role to users who want
tostudy performance data. I am trying to get similar information on the roles or privileges in PgSQL that we might want
torequest to investigate the performance problems? 

You probably want pg_monitor:

    https://www.postgresql.org/docs/current/predefined-roles.html

pgsql-general by date:

Previous
From: Siraj G
Date:
Subject: User roles for gathering performance metrics data
Next
From: "David G. Johnston"
Date:
Subject: Re: User roles for gathering performance metrics data