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
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Session
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#