There were connections hike and I used to check blocking sessions and long running queries using pg_stat_activity.
My manager gave me less rating during performance meeting, because he says even a kid can do this. He said my job is to analyse the cause of connection hike.
