public inbox for [email protected]help / color / mirror / Atom feed
Connection exceeded alert. 3+ messages / 3 participants [nested] [flat]
* Connection exceeded alert. @ 2024-08-06 04:32 Rajesh Kumar <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Rajesh Kumar @ 2024-08-06 04:32 UTC (permalink / raw) To: Pgsql-admin <[email protected]> Hi all, I have been trying to find a steps or solution for past 1 year once we received a connection exceeded alert. Couldn't get any answer from anybody or internet so far. Today I checked a pgbadger report and matched the timeline and found that, at that time of sudden connection hike (not normal), there were 3 queries running at that time (2 update queries on table a , took 5s each, one insert query on table b which took 2.5mns). Anybody provide me steps what all I have to do 1. At that time of connection hike 2. If I am been asked to check after sometime as connection dropped to analyse. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Connection exceeded alert. @ 2024-08-06 05:43 Muhammad Waqas <[email protected]> parent: Rajesh Kumar <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Muhammad Waqas @ 2024-08-06 05:43 UTC (permalink / raw) To: Rajesh Kumar <[email protected]>; +Cc: Pgsql-admin <[email protected]> Please check maximum connection / Session parameter in postgreSQL.conf file and you can increase maximum session/connection. Please also check locking on database. 2024년 8월 6일 (화) 오전 9:32, Rajesh Kumar <[email protected]>님이 작성: > Hi all, > > I have been trying to find a steps or solution for past 1 year once we > received a connection exceeded alert. Couldn't get any answer from anybody > or internet so far. > > Today I checked a pgbadger report and matched the timeline and found > that, at that time of sudden connection hike (not normal), there were 3 > queries running at that time (2 update queries on table a , took 5s each, > one insert query on table b which took 2.5mns). > > Anybody provide me steps what all I have to do 1. At that time of > connection hike 2. If I am been asked to check after sometime as connection > dropped to analyse. > -- *Muhammad Waqas* *Senior Technical Support Engineer - Tech Support Center (Karachi)* Mobile: +92-322-2844150 Email: *[email protected] <[email protected]>* 1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem, DHA Phase 5 Tauheed Commercial Area, Defense V Defense Housing Authority, Karachi, Karachi City, Sindh, 75500 Pakistan. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Connection exceeded alert. @ 2024-08-06 06:21 khan Affan <[email protected]> parent: Rajesh Kumar <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: khan Affan @ 2024-08-06 06:21 UTC (permalink / raw) To: Rajesh Kumar <[email protected]>; +Cc: Pgsql-admin <[email protected]> Hi Rajesh, To effectively troubleshoot this issue, please share your current PostgreSQL configuration values for shared_buffers, work_mem, and maintenance_work_mem. Additionally, please provide details about the application generating these queries. Are they triggered by POST or GET requests? To gain deeper insights into query performance, execute the following commands: EXPLAIN (ANALYZE, BUFFERS) <your_query>; SELECT pid, usename, query, state, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event IS NOT NULL; These commands will help identify performance bottlenecks and resource contention. On Tue, Aug 6, 2024 at 9:32 AM Rajesh Kumar <[email protected]> wrote: > Hi all, > > I have been trying to find a steps or solution for past 1 year once we > received a connection exceeded alert. Couldn't get any answer from anybody > or internet so far. > > Today I checked a pgbadger report and matched the timeline and found > that, at that time of sudden connection hike (not normal), there were 3 > queries running at that time (2 update queries on table a , took 5s each, > one insert query on table b which took 2.5mns). > > Anybody provide me steps what all I have to do 1. At that time of > connection hike 2. If I am been asked to check after sometime as connection > dropped to analyse. > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-06 06:21 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-06 04:32 Connection exceeded alert. Rajesh Kumar <[email protected]> 2024-08-06 05:43 ` Muhammad Waqas <[email protected]> 2024-08-06 06:21 ` khan Affan <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox