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.

                        regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to