How to get the total of current connection in PostgreSQL?
Hello, I have a small project using the PostgreSQL database. As I know default maximum number connection of PostgreSQL is 100 connections at the same time. So how can I get the total current connection is connecting to my database?
I want to make a service and send a message to Telegram if the total current connection larger than 70%.
I try the query below but it's not correct:
select count(*) from pg_stat_activity;
Please, help me how to get the total of the current connection in PostgreSQL?
Thank a lot.
-
J0
Jose Luis Apr 10 2021
I usually command below to tracking total current connections in PostgreSQL :
SELECT usename, datname, COUNT(1) FROM pg_stat_activity GROUP BY usename, datname
Because a database maybe has many users with many DB names so above command will filter by user login.
I hope it useful for you.
-
D0
Denis Cano Apr 10 2021
It depends on the version of Postgre but I usually use the command below to get count current connections
SELECT sum(numbackends) FROM pg_stat_database;
You can use
SELECT * FROM pg_stat_database;
command to get all columns to have in that table and you can get more information from it such as DB name, deadlock, conflict...
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.