PG pg_stat_activity


### check all connection
```typeselect *from pg_stat_activitywhere datname = 'mydatabasename';```

> [How to see active connections and "current activity" in PostgreSQL 8.4](https://serverfault.com/questions/128284/how-to-see-active-connections-and-current-activity-in-postgresql-8-4)













