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--