Re: Idle query that's not "<IDLE>"?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Idle query that's not "<IDLE>"?
Date: 2018-11-06 21:04:23
Message-ID: CAKFQuwb-FeygC3SLUFf6GBAVHV4-wTprMDz72VWXpm-s95_SOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 6, 2018 at 1:59 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> Right. But when does the query text become "<IDLE>"? Or has that become obsolete? (We recently migrated from 8.4.)

That behavior changed sometime around 9.0; since it always shows the
last query executed it logically follows that it will never show the
placeholder "<IDLE>" (I suppose it might do so upon initial connect if
no queries have been sent yet...not sure what it says then or even if
it is possible)

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-11-06 21:11:10 Re: Idle query that's not "<IDLE>"?
Previous Message Tom Lane 2018-11-06 21:03:35 Re: backend crash on DELETE, reproducible locally