From: | arun chirappurath <arunsnmimt(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Access issue for system queries |
Date: | 2024-03-30 04:47:28 |
Message-ID: | CAA23SdsAXTRfKXn3kBsYhoC+1q0ZXoYkeX+17CuUTh+MgGqCFw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all,
I have granted access to pg_read_all_stats and pg_read_allsettings to
user..still they are not able to receive results from this query.its
empty..we can run SELECT * FROM pg_stat_statements alone..but not below
statement..what could be the reason?
WITH statements AS (
SELECT * FROM pg_stat_statements pss
JOIN pg_roles pr ON (userid=oid)
WHERE rolname = current_user
)
SELECT calls,
min_exec_time,
max_exec_time,
mean_exec_time,
stddev_exec_time,
(stddev_exec_time/mean_exec_time) AS coeff_of_variance,
query
FROM statements
WHERE calls > 500
AND shared_blks_hit > 0
ORDER BY mean_exec_time DESC
LIMIT 10
Regards,
Arun
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2024-03-30 05:06:29 | Re: Access issue for system queries |
Previous Message | Justin Clift | 2024-03-30 03:33:42 | Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe |