From davidjblood@yahoo.com Fri Feb 15 17:27:10 2002 Received: from web20604.mail.yahoo.com (web20604.mail.yahoo.com [216.136.226.162]) by postgresql.org (8.11.3/8.11.4) with SMTP id g1FHRAE24506 for ; Fri, 15 Feb 2002 12:27:10 -0500 (EST) (envelope-from davidjblood@yahoo.com) Message-ID: <20020215172715.8264.qmail@web20604.mail.yahoo.com> Received: from [12.254.136.144] by web20604.mail.yahoo.com via HTTP; Fri, 15 Feb 2002 09:27:15 PST Date: Fri, 15 Feb 2002 09:27:15 -0800 (PST) From: david blood Subject: current connections and queries To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200202/269 X-Sequence-Number: 6692 is there away to see the current connections to the postmaster and what queries are running? __________________________________________________ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com From rhunter@enterasys.com Thu Feb 21 19:31:08 2002 Received: from ctron-dnm.ctron.com (ctron-dnm.enterasys.com [12.25.1.120]) by postgresql.org (Postfix) with ESMTP id 4D763475981 for ; Thu, 21 Feb 2002 14:31:08 -0500 (EST) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id OAA02772; Thu, 21 Feb 2002 14:40:40 -0500 (EST) Received: from cnc-exc2(134.141.77.103) by ctron-dnm.ctron.com via smap (4.1) id xma002747; Thu, 21 Feb 02 14:40:22 -0500 Received: by smtp.enterasys.com with Internet Mail Service (5.5.2653.19) id ; Thu, 21 Feb 2002 14:29:55 -0500 Message-ID: <59358A738F45D51186A30008C74CE250E81403@slc-exc1.ctron.com> From: "Hunter, Ray" To: "'david blood'" , pgsql-sql@postgresql.org Subject: Re: current connections and queries Date: Thu, 21 Feb 2002 14:30:11 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1BB0E.2D8F3220" X-Archive-Number: 200202/272 X-Sequence-Number: 6695 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C1BB0E.2D8F3220 Content-Type: text/plain I have usually check my Pgsql connections on Linux with the ps command. Example: ps -gaux | grep 'postmaster' This works for me. However, I do not need to see the exact query. Ray Hunter Firmware Engineer ENTERASYS NETWORKS -----Original Message----- From: david blood [mailto:davidjblood@yahoo.com] Sent: Friday, February 15, 2002 10:27 AM To: pgsql-sql@postgresql.org Subject: [SQL] current connections and queries is there away to see the current connections to the postmaster and what queries are running? __________________________________________________ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly ------_=_NextPart_001_01C1BB0E.2D8F3220 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: [SQL] current connections and queries

I have usually check my Pgsql connections on Linux with t= he ps command.

Example:  ps -gaux | grep 'postmaster'

This works for me.  However, I do not need to see th= e exact query.

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS


-----Original Message-----
From: david blood [mailto:davidjblood@yahoo.com]
Sent: Friday, February 15, 2002 10:27 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] current connections and queries


is there away to see the current connections to the postm= aster and what queries are running?


__________________________________________________
Do You Yahoo!?
Got something to say? Say it better with Yahoo! Video Ma= il
http= ://mail.yahoo.com

---------------------------(end of broadcast)------------= ---------------
TIP 3: if posting/reading through Usenet, please send an= appropriate subscribe-nomail command to majordomo@postgresql.org so that y= our message can get through to the mailing list cleanly

------_=_NextPart_001_01C1BB0E.2D8F3220--