How to get the total of current connection in PostgreSQL?

Dung Do Tien Apr 10 2021 214

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.

Have 2 answer(s) found.
  • J

    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.

  • D

    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...

Related Q&A May You Like

  1. MySql throw no database selected, select the default DB to be used by double-clicking its name
  2. How to generate whole sql database script in MySql Workbench
  3. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  4. What is best way to convert datetime to date in Sql Server?
  5. How to compare date without time with now() in PostgreSQL?
  6. MySQL Error Code: 1175. safe update mode update a table without a WHERE
  7. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  8. ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
  9. Calculating distance between two positions(lat, long) in SQL Server
  10. MySQL Error: 'Access denied for user 'root'@'localhost'
  11. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  12. How to backup and restore MSSQL Server database in Ubuntu
  13. ERROR: OFFSET must not be negative in PostgreSQL
  14. How to update top N records for a table in PostgreSQL?
  15. PostgreSQL Error: Terminating connection due to administrator command
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close