Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
Keep in mind that you can only see those statements if you are the same user or are a superuser. I'm not sure yet if users in the pg_monitor role have visibility.