CREATE USER su WITH SUPERUSER;
ERROR:  role "su" already exists
SET ROLE su;
CREATE EXTENSION pg_stat_monitor;
CREATE USER u1;
CREATE USER u2;
SET ROLE su;
SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

SET ROLE u1;
CREATE TABLE t1 (a int);
SELECT * FROM t1;
 a 
---
(0 rows)

SET ROLE u2;
CREATE TABLE t2 (a int);
SELECT * FROM t2;
 a 
---
(0 rows)

SET ROLE su;
SELECT userid, query FROM pg_stat_monitor ORDER BY query COLLATE "C";
 userid |              query              
--------+---------------------------------
 u1     | CREATE TABLE t1 (a int);
 u2     | CREATE TABLE t2 (a int);
 u1     | SELECT * FROM t1;
 u2     | SELECT * FROM t2;
 su     | SELECT pg_stat_monitor_reset();
 su     | SET ROLE su;
 u1     | SET ROLE u1;
 u2     | SET ROLE u2;
(8 rows)

SELECT pg_stat_monitor_reset();
 pg_stat_monitor_reset 
-----------------------
 
(1 row)

DROP TABLE t1;
DROP TABLE t2;
DROP USER u1;
DROP USER u2;
DROP EXTENSION pg_stat_monitor;