Way to tell what SQL is currently running?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Way to tell what SQL is currently running?
Date: 2003-08-25 16:39:30
Message-ID: OF73023A11.9EC8ECA8-ON88256D8D.005B42FF-88256D8D.005C2731@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm finding that some update process is holding all other transactions on a
particular table. Is there a way to tell what the Update statement is that
is running? I tried to use TOP, but it does not provide enough of the SQL
string to help.
TIA

Patrick Hatcher

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message WillyLinux - 2003-08-25 16:40:06 unsubscribe
Previous Message Luis Hernandez 2003-08-25 16:32:02 doc on searching, and sorting