How to identify users with superuser access in Redshift database

Use the below sql query to get a list of all superusers in Redshift database.

select usename from pg_user_info 
where usesuper='true' and usesysid > 100;

See also  How to get current date, day, month, year in Redshift database