The function pg_stat_get_backend_activity doesn't return anything unless you are the superuser, but why won't it show you anying for queries run by the current user?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных