Skilldepository

Knowledge base for teams

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!

0 uses

0 points

Empty! You must sign in to add comments.

How to restore DB from SQLC file How to add polish dictionary to postgres How to run PostgreSQL if 'postmaster.pid' already exists Cleaning schema.rb How to detect time-overlapping-records in Postgres + Rails

How to hold Mac from going into sleep?Fix libv8 / therubyracer installing error BalenaOS - Operating system that helps to run Docker solutions on SBCs (eg. Raspberry Pi, Orange Pi, etc)Brakeman - An awesome gem that scans your app against vulnerabilities.Fix bundler error "can't find gem bundler (>= 0.a) with executable bundle"