pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tomeh, Husam <htomeh@corelogic.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: High-water Mark for number of sessions/connections reached in Postgres
Date: Mon, 09 Aug 2010 18:39:16 -0400
Message-ID: <1281393490-sup-5210@alvh.no-ip.org> (raw)
In-Reply-To: <AANLkTimdgjUwnBo1N1j40oBE6pVgupoG7CGBweX_Nw-g@mail.gmail.com>
References: <B6C40D17104BEF47B1CB85623CDFAC63AB4AED@COVMSGCES-EMB13.cov.virginia.gov>
	<AANLkTin1Kx2wTYsdTgoYd4mrhrjY2r9KikJzR=YkvEDe@mail.gmail.com>
	<F849E59B1BB96C42A849EBCD724513F515FC3CEF3F@ISCESNA01CXMB02.infosolco.net>
	<AANLkTimkB3ymPmCj5rmJKY-7J_51J53pFTn44cj8By+k@mail.gmail.com>
	<AANLkTimdgjUwnBo1N1j40oBE6pVgupoG7CGBweX_Nw-g@mail.gmail.com>

Excerpts from Scott Marlowe's message of lun ago 09 18:29:58 -0400 2010:
> If you want a date stamp, you can change the ps ax stuff to look like this:
> 
> date +"%Y-%m-%d %H:%M:%S"|tr "\n" ":";ps ax|grep postgres:|grep -v grep|wc -l

FWIW the "grep" business is best solved by ps itself, something like 
ps ax -C postgres

date +"%Y-%m-%d %H:%M:%S"|tr "\n" ":";ps ax -C  postgres|wc -l

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



view thread (10+ messages)  latest in thread

Message-ID: <1281393490-sup-5210@alvh.no-ip.org>
Permalink:  ../1281393490-sup-5210@alvh.no-ip.org/
Also on:    postgresql.org/message-id/1281393490-sup-5210@alvh.no-ip.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, scott.marlowe@gmail.com, htomeh@corelogic.com
  Subject: Re: High-water Mark for number of sessions/connections reached in Postgres
  In-Reply-To: <1281393490-sup-5210@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox