Re: what does pg_activity mean when the database is stuck?

From: Ciba Sadaf <sadafrazzaque2007(at)gmail(dot)com>
To: Si Chen <sichen(at)opensourcestrategies(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: what does pg_activity mean when the database is stuck?
Date: 2014-06-11 16:04:08
Message-ID: CABoP_emM2hvakKBb0BiBhdPtWO_5W5L=eu95c4Fcu7aw-vK=9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dnt have any unfrmtn
On 11-Jun-2014 9:30 PM, "Si Chen" <sichen(at)opensourcestrategies(dot)com> wrote:

> 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
> http://wiki.postgresql.org/wiki/Lock_Monitoring
>
> But it returned no locked tables.
>
> So what does this mean? Is the select query getting stuck?
> --
> Si Chen
> Open Source Strategies, Inc.
> sichen(at)opensourcestrategies(dot)com
> http://www.OpenSourceStrategies.com
> LinkedIn: http://www.linkedin.com/in/opentaps
> Twitter: http://twitter.com/opentaps
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message boca2608 2014-06-11 16:05:06 Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Previous Message Si Chen 2014-06-11 15:59:56 what does pg_activity mean when the database is stuck?