Re: Way to tell what SQL is currently running? - Mailing list pgsql-novice

From Tomka Gergely
Subject Re: Way to tell what SQL is currently running?
Date
Msg-id Pine.LNX.4.33.0308251912160.31338-100000@zeus.gau.hu
Whole thread Raw
In response to Way to tell what SQL is currently running?  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: Way to tell what SQL is currently running?
List pgsql-novice
2003-08-25 ragyogó napján Patrick Hatcher ezt üzente:

> 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

Hmm, i have a pg_stat_activity table, this is enough?

--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."


pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: doc on searching, and sorting
Next
From: Ron Johnson
Date:
Subject: Re: Number of rows in a table