PSQL – How many connections live / created at any given time ? Ar thse getting Closed ? If Not how long do they persist

[RohitDhankar]

Within the Python code there is very bad code - many functions are creating connections to PSQL . Find out for the PSQL – How many CONNs created at anytime ? Are they getting Closed ? If Not how long do they need to persist ?

[RohitDhankar]

Solved - created a python method psql_liveConn_Status() , that monitors PSQL and shows the live connections status , the PSQL query, etc . Done primarily basis inputs from PSQL Documentation and the SO Questions here :-

https://stackoverflow.com/questions/41444890/how-to-use-server-side-cursors-with-psycopg2

https://stackoverflow.com/questions/49926044/django-connection-pooling-to-postgresql

[RohitDhankar]

The PSQL Live connection status function , psql_liveConn_Status() , provides useful information that needs to be persisted . As on date , just dumped a CSV from the DF . Also showing the DF in a Modal . Further need to get this DF , into a SQLite or PSQL table and persist .