Tool to find the number of open postgresql connection in the application

Question

Is there any tool to find the number of open postgresql connection in the application.

http://stackoverflow.com/questions/5267715/whats-the-correct-query-for-getting-the-current-number-of-connections-in-a-postg — ntalbs, Sep 12 '14 at 05:04

score 1 · Accepted Answer · answered Sep 12 '14 at 12:03

1

Try this

select * from pg_stat_activity;

answered Sep 12 '14 at 12:03

Sajeev

1 Answers1