Answers for "postgres show active connections"

SQL
1

psql connections

SELECT * FROM pg_stat_activity;
Posted by: Guest on August-17-2020
0

check connections to database postgres

SELECT * FROM pg_stat_activity WHERE datname='db_name';
Posted by: Guest on February-07-2020
0

postgres active connections

SELECT * FROM pg_stat_activity;

OR

SELECT datid, datname, pid, usename, state, query FROM pg_stat_activity;
Posted by: Guest on May-14-2021

Code answers related to "postgres show active connections"

Code answers related to "SQL"

Browse Popular Code Answers by Language