WAITING in PG_STATS_ACTIVITY

Started by Nonamealmost 19 years ago2 messagesgeneral

ruediger.papke@t-online.de

almost 19 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

almost 19 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