Zet - How do I check connections on postgres?

How do I check connections on postgres?

SELECT * FROM pg_stat_activity WHERE datname = 'drain_kevin';

from term

export HOST=db-write.infra-devel-eu-central-1.kaarbontech.net

sudo -u postgres psql -h $HOST -c "SELECT * FROM pg_stat_activity WHERE datname = 'drain_wokingtree';"

Find the pid and you can disconnect it with

sudo -u postgres psql -h $HOST -c "SELECT pg_terminate_backend(your_pid_here);"

to kill all:

    SELECT pg_terminate_backend(pg_stat_activity.pid)
    FROM pg_stat_activity
    WHERE pg_stat_activity.datname = 'drain_kevin'
    AND pid <> pg_backend_pid();

in the term:

    sudo -u postgres psql -h $HOST -c "SELECT pg_terminate_backend(pg_stat_activity.pid)
    FROM pg_stat_activity
    WHERE pg_stat_activity.datname = 'drain_wokingtree'
    AND pid <> pg_backend_pid();"

#postgres