Re: <IDLE> connections and cpu consumption

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: <IDLE> connections and cpu consumption
Date: 2011-11-09 19:57:49
Message-ID: 4EBADB3D.9070608@hogranch.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/09/11 11:35 AM, Gauthier, Dave wrote:
> Ahhhh... so if the script that has the connection open would only terminate the transaction, then vacuum wouldn't get behind?
>
> I actually made a change in that script to rollback when the script doesn't need the changes in the transaction, hopefully allowing vacuum to do its thing.

(from memory, I might have details wrong here)...

select now()-xact_start as "Transaction Age", usename, datname,
procpid, application_name
from pg_stat_activity where current_query='<IDLE> in
transaction" order by 1 desc;

that will list the age of those idle-in-transactions, oldest on top.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2011-11-09 20:24:39 Re: Insufficient privilege when initiating backup
Previous Message Cody Caughlan 2011-11-09 19:48:58 Insufficient privilege when initiating backup