Check if PostgreSQL is using SSL

psql_check_ssl.sql

SELECT s.pid, s.ssl, s.version, a.client_addr, a.usename, a.datname, a.query 
  FROM pg_stat_ssl AS s 
  JOIN pg_stat_activity AS a ON a.pid = s.pid;

-- You can see `t|f` in `ssl` field