public inbox for [email protected]
help / color / mirror / Atom feedMonitoring
4+ messages / 4 participants
[nested] [flat]
* Monitoring
@ 2003-03-05 17:21 Delao, Darryl W <[email protected]>
2003-03-05 17:50 ` Re: Monitoring Rod Taylor <[email protected]>
2003-03-06 01:15 ` Re: Monitoring Neil Conway <[email protected]>
2003-03-06 01:33 ` Re: Monitoring Oliver Crow <[email protected]>
0 siblings, 3 replies; 4+ messages in thread
From: Delao, Darryl W @ 2003-03-05 17:21 UTC (permalink / raw)
To: pgsql-docs
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?
Thank you,
Darryl
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Monitoring
2003-03-05 17:21 Monitoring Delao, Darryl W <[email protected]>
@ 2003-03-05 17:50 ` Rod Taylor <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Rod Taylor @ 2003-03-05 17:50 UTC (permalink / raw)
To: Delao, Darryl W <[email protected]>; +Cc: pgsql-docs
On Wed, 2003-03-05 at 12:21, 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?
No, but I'd love something that can throw an SNMP event when queries are
taking too long -- or someone is idling in a transaction...
--
Rod Taylor <[email protected]>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
[application/pgp-signature] signature.asc (187B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Monitoring
2003-03-05 17:21 Monitoring Delao, Darryl W <[email protected]>
@ 2003-03-06 01:15 ` Neil Conway <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Neil Conway @ 2003-03-06 01:15 UTC (permalink / raw)
To: Delao, Darryl W <[email protected]>; +Cc: pgsql-docs
On Wed, 2003-03-05 at 12:21, Delao, Darryl W wrote:
> Anyone aware of any tool or command line option to view active and inactive
> postgres connections?
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/monitoring-stats.html
> Also, is there a command to kill a specific connection at any given time?
kill(1) is the only one I'm aware of.
Cheers,
Neil
P.S. User support questions should probably be directed to a mailing
list like pgsql-general or pgsql-novice
--
Neil Conway <[email protected]> || PGP Key ID: DB3C29FC
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Monitoring
2003-03-05 17:21 Monitoring Delao, Darryl W <[email protected]>
@ 2003-03-06 01:33 ` Oliver Crow <[email protected]>
2 siblings, 0 replies; 4+ messages in thread
From: Oliver Crow @ 2003-03-06 01:33 UTC (permalink / raw)
To: Delao, Darryl W <[email protected]>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-03-06 01:33 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-05 17:21 Monitoring Delao, Darryl W <[email protected]>
2003-03-05 17:50 ` Rod Taylor <[email protected]>
2003-03-06 01:15 ` Neil Conway <[email protected]>
2003-03-06 01:33 ` Oliver Crow <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox