There is no superuser required to view pg_stat_activity, a normal user can also view or access.
I believe Shreeyansh is incorrect. You can view some fields as a normal user but you can't view query text (in addition to some others) unless you are superuser, or perhaps the new monitoring role in Pg10.