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