Thread: current connections and queries

current connections and queries

From
david blood
Date:
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


Re: current connections and queries

From
"Hunter, Ray"
Date:
<p><font size="2">I have usually check my Pgsql connections on Linux with the ps command.</font><p><font
size="2">Example: ps -gaux | grep 'postmaster'</font><p><font size="2">This works for me.  However, I do not need to
seethe exact query.</font><p><font size="2">Ray Hunter</font><br /><font size="2">Firmware Engineer</font><p><font
size="2">ENTERASYSNETWORKS</font><br /><p><font size="2">-----Original Message-----</font><br /><font size="2">From:
davidblood [<a href="mailto:davidjblood@yahoo.com">mailto:davidjblood@yahoo.com</a>] </font><br /><font size="2">Sent:
Friday,February 15, 2002 10:27 AM</font><br /><font size="2">To: pgsql-sql@postgresql.org</font><br /><font
size="2">Subject:[SQL] current connections and queries</font><br /><p><font size="2">is there away to see the current
connectionsto the postmaster and what queries are running?</font><br /><p><font
size="2">__________________________________________________</font><br/><font size="2">Do You Yahoo!?</font><br /><font
size="2">Gotsomething to say? Say it better with Yahoo! Video Mail </font><br /><font size="2"><a
href="http://mail.yahoo.com"target="_blank">http://mail.yahoo.com</a></font><p><font
size="2">---------------------------(endof broadcast)---------------------------</font><br /><font size="2">TIP 3: if
posting/readingthrough Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that
yourmessage can get through to the mailing list cleanly</font>