How count active connection postgresql (without idle) for every database?

Question

I have many connection from java server application.

How get numActive connection (like jconsole) on PostgreSQL server? Thanks

That is that table that you've to look at, I don't know the reason why you ask the question? — N00b Pr0grammer, May 17 '17 at 15:49

score 1 · Accepted Answer · answered May 17 '17 at 15:53

The simple answer is:

SELECT datname, count(*) FROM pg_stat_activity
  WHERE state != 'idle' GROUP BY datname;

Is that what you're looking for? It seems from your question like there is something else going on, but without more detail it's impossible to say.

1 Answers1