On 07/03/2014 06:59 PM, Huang, Suya wrote:
BTW, I’m using the pgbadger report to check for peak connections/sessions.
Hi,
We’ve experienced a DB issue yesterday and after checked the log found that the peak sessions is 3000 while the peak DB connections is only around 30. The application is having problem of pulling data but no warnings in DB log as it doesn’t exceed max_connections.
How could this happen? How does sessions/connections work in Postgres?
As handy as pgbadger is, I have found that its max-connections values don't pass the "sniff test" as it generally shows peak values that exceed the configured number of connections. I haven't dug in to find out why but could conjecture that the fact that log entries are generally truncated to the nearest second could cause this sort of thing.
Unexpected connection buildup is often a side-effect of something else like a large resource-intensive query, a query holding locks that prevent the other connections' queries from completing or a variety of other things.
If you are looking to solve/prevent the undescribed "issue", please provide more detail.
-Steve