Last Updated: May 15, 2019·
How to check who/what is connected to your PostgreSQL database?
How many times have we faced this kind of message...
DETAIL: There is 1 other session using the database.
... and had no idea what and who is connected to our db? To get this information, just open up your SQL console and type in
SELECT * FROM pg_stat_activity;
This should result in following listing being displayed
Written by Błażej Kosmowski
PHP Flash messages
Have a fresh tip? Share with Coderwall community!
Post a tip
Best #Session Authors
Sponsored by #native_company# — Learn More