Use the below sql statement to view the recent 100 queries run by a user ordered by the most recent query on top where ‘nameoftheuser’ is the username.
select * from svl_qlog
where userid = (select usesysid from pg_user where usename='nameoftheuser')
order by starttime desc
limit 100;