Postgres - View all connections details
31 Jan 15:08

Simply execute the following query:

SELECT datname, application_name, client_addr FROM pg_stat_activity WHERE (datname NOT IN ('', '_dodb')) ORDER BY client_addr, application_name;

If you want to limit that search to certain database, use this:

SELECT datname, application_name, client_addr FROM pg_stat_activity WHERE (datname IN ('your-database')) ORDER BY client_addr, application_name;

Have a successful debugging!

Comments

Empty! You must sign in to add comments.