The following scripts are useful for getting the current sessions in PostgreSQL. This will list any active sessions along with user information.