Re: WAITING in PG_STATS_ACTIVITY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ruediger(dot)papke(at)t-online(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAITING in PG_STATS_ACTIVITY
Date: 2007-08-19 16:46:21
Message-ID: 18612.1187541981@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ruediger(dot)papke(at)t-online(dot)de writes:
> when is WAITING in PG_STATS_ACTIVITYset to TRUE ?
> When this connection is waiting on a lock , or are there any other
> reasons, waiting on another resource ?

Only when waiting on a lock.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-08-19 17:01:41 Re: Searching for Duplicates and Hosed the System
Previous Message Bill Thoen 2007-08-19 16:44:51 Searching for Duplicates and Hosed the System