select count(*), datname from pg_stat_activity group by datname; -- count by database.
select pg_terminate_backend(pid) from pg_stat_activity where datname='BICTU_PHASE2'; -- close all connections in a specific database.