Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 11:16 AM, John R Pierce wrote: > > On 9/27/2016 12:06 PM, Israel Brewster wrote: >> That helps for one-time stat collection, but as I mentioned in my original >> message, since connections may not last long, I could be getting close to, >> or even

Re: [GENERAL] Determining server load

2016-09-27 Thread John R Pierce
On 9/27/2016 12:06 PM, Israel Brewster wrote: That helps for one-time stat collection, but as I mentioned in my original message, since connections may not last long, I could be getting close to, or even hitting, my connection limit while still getting values back from those that show plenty

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
--- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 --- BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
On 09/27/2016 12:01 PM, Israel Brewster wrote: --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 --- On Sep 27, 2016, at 10:48 AM, Adrian

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:55 AM, Melvin Davidson wrote: > > > > On Tue, Sep 27, 2016 at 2:46 PM, Israel Brewster > wrote: >> >I'm still curious as to how I can track concurrent connections, ... >> >> Have you

Re: [GENERAL] Determining server load

2016-09-27 Thread Melvin Davidson
On Tue, Sep 27, 2016 at 2:46 PM, Israel Brewster wrote: > >I'm still curious as to how I can track concurrent connections, ... >> > > Have you considered enabling the following in postgresql.conf? > log_connections=on > log_disconnections=on > > It will put a bit of a

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:55 AM, Jonathan Vanasco wrote: > > > On Sep 27, 2016, at 2:46 PM, Israel Brewster wrote: > >> I do have those on, and I could write a parser that scans through the logs >> counting connections and disconnections to give a number of current >>

Re: [GENERAL] Determining server load

2016-09-27 Thread Jonathan Vanasco
On Sep 27, 2016, at 2:46 PM, Israel Brewster wrote: > I do have those on, and I could write a parser that scans through the logs > counting connections and disconnections to give a number of current > connections at any given time. Trying to make it operate "in real time" would > be

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
On 09/27/2016 11:40 AM, Israel Brewster wrote: On Sep 27, 2016, at 9:55 AM, John R Pierce wrote: On 9/27/2016 9:54 AM, Israel Brewster wrote: I did look at pgbadger, which tells me I have gotten as high as 62 connections/second, but given that most of those connections

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
> >I'm still curious as to how I can track concurrent connections, ... > > Have you considered enabling the following in postgresql.conf? > log_connections=on > log_disconnections=on > > It will put a bit of a bloat in you postgres log, but it will all allow you > extract connects/disconnects

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 9:55 AM, John R Pierce wrote: > > On 9/27/2016 9:54 AM, Israel Brewster wrote: >> >> I did look at pgbadger, which tells me I have gotten as high as 62 >> connections/second, but given that most of those connections are probably >> very short lived

Re: [GENERAL] Determining server load

2016-09-27 Thread Melvin Davidson
On Tue, Sep 27, 2016 at 2:25 PM, Israel Brewster wrote: > On Sep 27, 2016, at 10:07 AM, Adrian Klaver > wrote: > > > > On 09/27/2016 09:54 AM, Israel Brewster wrote: > >> I have a Postgresql (9.4.6) cluster that hosts several databases, used >

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:07 AM, Adrian Klaver wrote: > > On 09/27/2016 09:54 AM, Israel Brewster wrote: >> I have a Postgresql (9.4.6) cluster that hosts several databases, used >> by about half-a-dozen different in-house apps. I have two servers set up >> as

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
On 09/27/2016 09:54 AM, Israel Brewster wrote: I have a Postgresql (9.4.6) cluster that hosts several databases, used by about half-a-dozen different in-house apps. I have two servers set up as master-slave with streaming replication. Lately I've been running into an issue where one of the apps

Re: [GENERAL] Determining server load

2016-09-27 Thread John R Pierce
On 9/27/2016 9:54 AM, Israel Brewster wrote: I did look at pgbadger, which tells me I have gotten as high as 62 connections/second, but given that most of those connections are probably very short lived that doesn't really tell me anything about concurrent connections. Each connection

[GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
I have a Postgresql (9.4.6) cluster that hosts several databases, used by about half-a-dozen different in-house apps. I have two servers set up as master-slave with streaming replication. Lately I've been running into an issue where one of the apps periodically can't connect to the db. The problem