From: | Oliver Crow <ocrow(at)simplexity(dot)net> |
---|---|
To: | "Delao, Darryl W" <ddelao(at)ou(dot)edu> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Monitoring |
Date: | 2003-03-06 01:33:15 |
Message-ID: | 20030305170814.W82803-100000@iguana.simplexity.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-06 18:05:04 | Re: TODO item completed |
Previous Message | Neil Conway | 2003-03-06 01:15:19 | Re: Monitoring |