Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions - Mailing list pgsql-hackers

From sirisha chamarthi
Subject Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions
Date
Msg-id CAKrAKeXRmqi65dA0HoiLfteFBE8pjqQKPkt50cyY0ihJ8Vg7nw@mail.gmail.com
Whole thread Raw
Responses Re: Proposal: Allow user with pg_monitor role to call pg_stat_reset* functions
List pgsql-hackers
Hi Hackers,

At present, calling pg_stat_reset* functions requires super user access unless explicitly grant execute permission on those. In this thread, I am proposing to grant execute on them to users with pg_monitor role permissions. This comes handy to the monitoring users (part of pg_monitor role) to capture the stats fresh and analyze. Do you see any concerns with this approach?

Thanks,
Sirisha

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [PoC] Improve dead tuple storage for lazy vacuum
Next
From: Laurenz Albe
Date:
Subject: Re: Reducing power consumption on idle servers