public inbox for [email protected]help / color / mirror / Atom feed
Monitoring 4+ messages / 4 participants [nested] [flat]
* Monitoring @ 2003-03-05 17:21 Delao, Darryl W <[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:50 Rod Taylor <[email protected]> parent: Delao, Darryl W <[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-06 01:15 Neil Conway <[email protected]> parent: Delao, Darryl W <[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-06 01:33 Oliver Crow <[email protected]> parent: Delao, Darryl W <[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