pg_stat_activity

Поиск
Список
Период
Сортировка
От Bala Venkat
Тема pg_stat_activity
Дата
Msg-id CACnhOfJkBq3KAZQuzsyrRracjTYs=dbxoWgdEtexrmETf9eG-A@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_stat_activity  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Дерево обсуждения
We are using postgres 9.0.  When I looked at the pg_stat_activity table.

I have some rows where there is difference of 2 hours between  backend_start  and xact_start

But there is only few milli seconds between xact_start and query_start. 

All them have wait as false.

My question is,  is the query still executing and also why would there be that much time difference between backend_start  and xact_start

Appreciate your thoughts and inputs..

thanks a lot..
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Victor Sterpu"
Дата:
Сообщение: Re: Lock problem
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: pg_stat_activity