On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Craig James <cjames(at)emolecules(dot)com> writes:
> > I installed 9.2 on our new server and am seeing something odd that
> doesn't
> > happen in 8.4:
>
> > postgres=# select datname, pid, usename, query from pg_stat_activity
> where
> > query != '<IDLE>';
>
> The query column now means "current or last query" --- there's a
> separate column to check for the idle status. Those DEALLOCATEs
> are evidently what your app does before going idle.
>
Nice feature. Thanks.
Craig
>
> regards, tom lane
>