Hello,
i have " <insufficient privilege>" in the query column of pg_stat_statements.
SELECT substring(query, 1, 50) AS short_query,
round(total_time::numeric, 2) AS total_time,
calls,
round(mean_time::numeric, 2) AS mean,
round((100 * total_time /
sum(total_time::numeric) OVER ())::numeric, 2) AS percentage_cpu
FROM pg_stat_statements
ORDER BY total_time DESC
LIMIT 20;
short_query | total_time | calls | mean | percentage_cpu
--------------------------+------------+--------+--------+----------------
<insufficient privilege> | 271357.92 | 21922 | 12.38 | 30.75
<insufficient privilege> | 261464.89 | 10961 | 23.85 | 29.63
<insufficient privilege> | 249198.72 | 7307 | 34.10 | 28.24
<insufficient privilege> | 40971.65 | 21922 | 1.87 | 4.64
<insufficient privilege> | 17908.37 | 21922 | 0.82 | 2.03
...
i'm using a user how is membre of azure_pg_admin group.