Re: Number of Connections

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: pgsql-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Number of Connections
Date: 2001-02-16 20:05:50
Message-ID: 20010216150549.B523@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 16, 2001 at 02:09:42PM -0500, Bryan White wrote:
> I use:
> ps ax | grep postgres | wc -l
> Note the value is often one to high because is picks up the grep process.

Why not just remove 'grep' - i.e

ps ax | grep postgres | grep -v grep | wc -l

HTH,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Four stages of acceptance:
i) this is worthless nonsense;
ii) this is an interesting, but perverse, point of view;
iii) this is true, but quite unimportant;
iv) I always said so.
-- J. B. S. Haldane in Journal of Genetics 58:464 (1963).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2001-02-16 20:09:00 Re: Postgres slowdown on large table joins
Previous Message David Wheeler 2001-02-16 20:05:38 Re: Case insensitive selects?