I am using Spring Data in my spring boot application and my data base is postgreSQL, I have some jobs and services which are connecting to db for different purposes.
recently I have encountered with connection problems
here is a sample logs of my hikari monitoring :
1399-10-09 00:03:22 INFO [INTERNAL NA ] HikariMonitorService.checkHikari : hikari pool: total=50 active=50 idle=0 waiting=5
1399-10-09 00:03:27 INFO [INTERNAL NA ] HikariMonitorService.checkHikari : hikari pool: total=50 active=50 idle=0 waiting=5
1399-10-09 00:03:32 INFO [INTERNAL NA ] HikariMonitorService.checkHikari : hikari pool: total=50 active=50 idle=0 waiting=5
1399-10-09 00:03:37 INFO [INTERNAL NA ] HikariMonitorService.checkHikari : hikari pool: total=50 active=50 idle=0 waiting=5
1399-10-09 00:03:42 INFO [INTERNAL NA ] HikariMonitorService.checkHikari : hikari pool: total=50 active=50 idle=0 waiting=5
as you see all of the connections are in use
I want to know somehow which services/or Jobs are consuming most of the connections ?
is there some monitoring/profiling tool for showing which service consumes which connection ?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…