what does pg_activity mean when the database is stuck?

Поиск
Список
Период
Сортировка
От Si Chen
Тема what does pg_activity mean when the database is stuck?
Дата
Msg-id CAAYSSjMPJCfdc_cvkPWtX8tgoFFFe=JSA_NCsnwgQKGBLogo_Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: what does pg_activity mean when the database is stuck?
Re: what does pg_activity mean when the database is stuck?
Список pgsql-general
Дерево обсуждения
I have a problem where postgresql 9.3 got stuck, and the number of postgresql processes increased from about 15 to 225 in 10 minutes.

I ran the query:
select pid, query_start, waiting, state, query from pg_stat_activity order by query_start;

But it showed mostly select statements -- all of them the same one, with a couple of joins.  They are not in a waiting state but have been running for over 2 hours.  

I also checked for locks with the query on

But it returned no locked tables.

So what does this mean?  Is the select query getting stuck?  
--
Si Chen
Open Source Strategies, Inc.
sichen@opensourcestrategies.com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps

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