Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TOy3J-0005YM-Hb
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 21:54:53 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TOy3E-0001fB-G4
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 21:54:52 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q9ILslZU020443;
	Thu, 18 Oct 2012 17:54:47 -0400 (EDT)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Craig James <cjames@emolecules.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Odd DEALLOCATE statements never finish in 9.2?
In-reply-to: 
 <CAFwQ8rfvsRe0XJt6F=TS6TB0=02xshTK_TNE=BkDa2SO4wQJPQ@mail.gmail.com>
References: 
 <CAFwQ8rfvsRe0XJt6F=TS6TB0=02xshTK_TNE=BkDa2SO4wQJPQ@mail.gmail.com>
Comments: In-reply-to Craig James <cjames@emolecules.com>
	message dated "Thu, 18 Oct 2012 14:47:49 -0700"
Date: Thu, 18 Oct 2012 17:54:46 -0400
Message-ID: <20442.1350597286@sss.pgh.pa.us>
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201210/83
X-Sequence-Number: 40199

Craig James <cjames@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.

			regards, tom lane