Re: Way to tell what SQL is currently running?

From: Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Way to tell what SQL is currently running?
Date: 2003-08-25 17:13:29
Message-ID: Pine.LNX.4.33.0308251912160.31338-100000@zeus.gau.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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..."

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2003-08-25 17:37:24 Re: Way to tell what SQL is currently running?
Previous Message Nabil Sayegh 2003-08-25 17:09:41 Re: doc on searching, and sorting