Rajan,
* rajan (vgmonnet@gmail.com) wrote:
> When monitoring using pg_stat_satements I see that postgres by default
> conceals queries executed by other users from the user who is selecting the
> pg_stat_statements view.
>
> I have edited the pg_stat_statements.c by disabling the superuser check
> function so that all queries will be visible to all users.
>
> Can this be posted as a patch to postgresql?
We don't want that to be generally viewable but rather something where
an administrator can control who can see it.
The current proposal for that is to have a set of default roles, one of
which will have this ability.
The thread on that topic starts here:
http://www.postgresql.org/message-id/flat/20150508042928.GP30322@tamriel.snowman.net#20150508042928.GP30322@tamriel.snowman.net
With the latest patch here:
http://www.postgresql.org/message-id/20150930111120.GM3685@tamriel.snowman.net
Thanks!
Stephen