How to list active connections on PostgreSQL?

sql postgresql database-connection listings
Tregoreg picture Tregoreg · Dec 12, 2014 · Viewed 168.8k times · Source

Is there a command in PostgreSQL to select active connections to a given database?

psql states that I can't drop one of my databases because there are active connections to it, so I would like to see what the connections are (and from which machines)

Answer

Tregoreg picture Tregoreg · Dec 12, 2014

Oh, I just found that command on PostgreSQL forum:

SELECT * FROM pg_stat_activity;

Related questions

AWS RDS PostgreSQL error "remaining connection slots are reserved for non-replication superuser connections"

In the dashboard I see there are currently 22 open connections to the DB instance, blocking new connections with the error: remaining connection slots are reserved for non-replication superuser connections. I'm accessing the DB from web service API running on EC2 …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How do I (or can I) SELECT DISTINCT on multiple columns?

I need to retrieve all rows from a table where 2 columns combined are all different. So I want all the sales that do not have any other sales that happened on the same day for the same price. The sales …

Read More