If I see a sudden connection spike (say once in 2 months). What are the
steps I need to follow as a dba?
Check idle and kill? Check of stat activity for active queries? How do I
ensure how much time is long running query? Blocking queries? How much of
blocking time is considered to be dangerous? Locks - should we conclude
anything from wait event and wait event type ?
All these won't help nd have to look into pgbadger?