On Saturday, February 15, 2025, Rajesh Kumar <rajeshkumar.db...@gmail.com> wrote:
> 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? > This is an inappropriate question for the -hackers mailing list. Both -admin and -general are better places to get help on learning how to be a DBA. This list is basically for discussing potential patches to the codebase. David J.
