0 like 0 dislike
asked in PostgreSQL Database Forum by (1k points)  
edited by
How can i check max connection particular day?

We need particular date max connection hit dB query

Please log in or register to answer this question.

2 Answers

0 like 0 dislike
answered by (1k points)  

I think there is no command but if you want now active and idle connection...

select count(*) , state from pg_stat_activity group by 2; 

use this command 

0 like 0 dislike
answered by (1k points)  
Question is different and he wants to know the connection max for a specific day
Pg stat activity will not help
You can utilize numbackends from pg_stat_database

Related questions

0 like 0 dislike
2 answers
0 like 0 dislike
1 answer