[GENERAL] waiting in pg_stats_activity

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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postma

Re: [GENERAL] WAITING in PG_STATS_ACTIVITY

[EMAIL PROTECTED] 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 ---(end of br

[GENERAL] WAITING in PG_STATS_ACTIVITY

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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postma