public inbox for [email protected]  

help / color / mirror / Atom feed

From: Oliver Crow <[email protected]>
To: Delao, Darryl W <[email protected]>
Cc: [email protected]
Subject: Re: Monitoring
Date: Wed, 5 Mar 2003 17:33:15 -0800 (PST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>



On Wed, 5 Mar 2003, Delao, Darryl W wrote:

> Anyone aware of any tool or command line option to view active and inactive
> postgres connections?  Is there a setting in postgres that sets the
> Time_Wait to something lower?  Also, is there a command to kill a specific
> connection at any given time?

Postgres starts a server process for each client connection.  You can use
/bin/ps to show the active connection processes.  The process command
string gives some information about what each connection is doing -- the
user and database being used, whether the connection is idle or processing
a query and the type of the query, as well as whether it's in a
transaction.

You can kill a connection, simply by killing the corresponding postgres
process.

% ps -auwwx | grep ^pgsql

pgsql  52081  Tue03PM  0:02.27 /usr/local/bin/postmaster (postgres)
pgsql  52082  Tue03PM  0:00.20 postmaster: stats buffer process    (postgres)
pgsql  52084  Tue03PM  0:00.98 postmaster: stats collector process    (postgres)
pgsql  65062  5:05PM   0:04.25 postmaster: ocrow ocrow [local] SELECT (postgres)
pgsql  65071  5:05PM   0:00.04 postmaster: ocrow ocrow [local] idle (postgres)

In this list process 65062 is executing a select query, and 65071
is idle.


Oliver

view thread (4+ messages)

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Monitoring
  In-Reply-To: <[email protected]>

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

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