how to check open connections in postgresql code example

SELECT * FROM pg_stat_activity;