Start a new topic

How to Monitor connections pooling?

Initially one should increase the  MAXIMUMPOOLSIZE  which will allow to accommodate more concurrent tasks.

we can also the increase Connection Timeout parameter if you have the default value from 5000 to 10000.

And now to monitor connection pooling, we should use the below commands

netstat -ant | grep 5432  
lsof -nP -i :5432 -sTCP:ESTABLISHED
ss -46 -np state established dport = :5432 | grep 'java' | sort -r -k 3,3 | nl 

If the pools is working you should see 10 ESTABLISHED connections to your respective ports

for your reference

Login to post a comment