Postgres Pro
Downloads
Home   >   mailing lists

Re: Why are a lot of ROLLBACK queries in idle state - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Why are a lot of ROLLBACK queries in idle state
Date
Msg-id o0mu37$bnq$1@blaine.gmane.org
Whole thread Raw
In response to Re: Why are a lot of ROLLBACK queries in idle state  (rajan <vgmonnet@gmail.com>)
Responses Re: Why are a lot of ROLLBACK queries in idle state
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: rajan
Date:
Subject: vacuum full is not reclaiming the space and showing non-removable rows
Next
From: Tom Lane
Date:
Subject: Re: vacuum full is not reclaiming the space and showing non-removable rows