On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Craig James <cja...@emolecules.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 >
