Re: Pg_stat_activity
| От | David G. Johnston |
|---|---|
| Тема | Re: Pg_stat_activity |
| Дата | |
| Msg-id | CAKFQuwZh6YYC3dsiaK38DC19K9w9gLPT3WRBWJr8-s3SRncAag@mail.gmail.com обсуждение исходный текст |
| Ответ на | Pg_stat_activity (Rajesh Kumar <rajeshkumar.dba09@gmail.com>) |
| Список | pgsql-hackers |
On Saturday, February 15, 2025, Rajesh Kumar <rajeshkumar.dba09@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.
В списке pgsql-hackers по дате отправления: