Re: Why are a lot of ROLLBACK queries in idle state

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Why are a lot of ROLLBACK queries in idle state
Date: 2016-11-18 13:01:31
Message-ID: o0mu37$bnq$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

rajan schrieb am 18.11.2016 um 12:56:
> If the _session_ is idle then shouldn't it be removed from pg_stat_activity?

The session is only removed from pg_stat_activity when it's closed, i.e. when the client disconnects.

Being "idle" and disconnecting are two completely different things

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-11-18 16:01:12 Re: vacuum full is not reclaiming the space and showing non-removable rows
Previous Message rajan 2016-11-18 12:00:49 vacuum full is not reclaiming the space and showing non-removable rows