check connection postgresql code example

Example: psql connections

SELECT * FROM pg_stat_activity;