I need to use data from " pg_stat_statements" to show up on grafana dashboard but I am not sure how.
Since the grafanareaduser requires superuser privileges, it doesn’t seem safe as anyone having access to the dashboard can run truncate or delete queries.
How can this be configured correctly? and show all the queries and stats from the last 15 days to see what’s causing a bottleneck in postgres performance.
Thanks
Abhineet