Re: Way to tell what SQL is currently running?

Поиск
Список
Период
Сортировка
От Tomka Gergely
Тема Re: Way to tell what SQL is currently running?
Дата
Msg-id Pine.LNX.4.33.0308251912160.31338-100000@zeus.gau.hu
обсуждение исходный текст
Ответ на Way to tell what SQL is currently running?  ("Patrick Hatcher" <PHatcher@macys.com>)
Ответы Re: Way to tell what SQL is currently running?  ("Patrick Hatcher" <PHatcher@macys.com>)
Список 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 по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: Re: doc on searching, and sorting
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Number of rows in a table