user308827
Reputation: 22011
Finding number of open connections to postgres database
I connect to a postgres database hosted on AWS. Is there a way to find out the number of open connections to that database using python API?
Upvotes: 0
Views: 79
Answers (1)
BryceH
Reputation: 2798
I assume this is for RDS. There is no direct way via the AWS API. You could potentially get it from CloudWatch but you'd be better off connecting to the database and getting the count that way by querying pg_stat_activity.
Upvotes: 1
Related Questions
- How to list active connections on PostgreSQL?
- Right query to get the current number of connections in a PostgreSQL DB
- Executing Postgresql Query in Python
- AWS - connect to PostgreSQL from Python not working
- How to identify number of connections to a Postgres Database (heroku)?
- Linux command to know the number of active db connections at any point of time in postgres?
- How to know the exactly total of current connections to PostgreSQL?
- Checking if connection to database exists before opening a new one in python
- Monitoring django postgres connections
- How can I find the number of connections currently active in PostgreSQL?