Re: killing idle attaches without killing others

From: Vick Khera <vivek(at)khera(dot)org>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: killing idle attaches without killing others
Date: 2010-08-04 18:40:28
Message-ID: AANLkTinhZZy2JgSDDWKJ9an3K6m7EZE-93SHVq6FAE0p@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 4, 2010 at 10:50 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> wrote:
>
> How does PG determine if a process is <IDLE> ?  It there some sort of timeout?  I want to be able to distinguish between somene who's interrupted on the phone for a couple minutes vs the guy who left the program running over the weekend.

It is <IDLE> if it is not currently running a query.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-08-04 18:45:40 Re: killing idle attaches without killing others
Previous Message gnuoytr 2010-08-04 17:01:43 Re: tgname munged