We would like to have read privilege to see which queries are running in the background.
Solution
You can use the statistics collector mentioned on following documentation page: Link
This feature allows you to retrieve information about the current status of the PostgreSQL cluster, like active queries.
Notes