Thread: WAITING in PG_STATS_ACTIVITY

WAITING in PG_STATS_ACTIVITY

From

ruediger.papke@t-online.de

Date:

19 August 2007, 06:49:14

Hi,

little question:
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 ?
TIA
ruediger

Re: WAITING in PG_STATS_ACTIVITY

From

Tom Lane

Date:

19 August 2007, 13:46:27

ruediger.papke@t-online.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