Initially one should increase the MAXIMUMPOOLSIZE which will allow to accommodate more concurrent tasks.
And now to monitor connection pooling, we should use the below commands
netstat -ant | grep 5432 lsof -nP -i :5432 -sTCP:ESTABLISHEDss -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
Bharat Joshi
Initially one should increase the MAXIMUMPOOLSIZE which will allow to accommodate more concurrent tasks.
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