Re: After upgrade to 9.6: waiting column does not exist

Johann Spies <johann.spies@xxxxxxxxx> · Fri, 9 Dec 2016 10:55:12 +0200

On 9 December 2016 at 10:13, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote:

    On 09/12/2016 10:04, John R Pierce
      wrote:

      are you running some sort of monitoring software thats
        periodically looking at pg_stat_activity ?   whatever query its
        doing needs to be rewritten to take into account the
        pg_stat_activity changes in 9.6

Thanks John.  I see munin queries the 'waiting'  column. 

    Also It would help to modify your log line prefix (log_line_prefix)
    to include client's address, PID, and application name.

Thanks for the hint Achilleas.  It makes a lot of sense.

Regards
Johann 
-- 
Because experiencing your loyal love is better than life itself, 
my lips will praise you.  (Psalm 63:3)