WAITING in PG_STATS_ACTIVITY

Started by Nonameover 18 years ago2 messagesgeneral

ruediger.papke@t-online.de

over 18 years ago

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

Tom Lane

tgl@sss.pgh.pa.us

over 18 years ago

In reply to: Noname (#1)

Re: WAITING in PG_STATS_ACTIVITY

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