Si Chen <sichen@xxxxxxxxxxxxxxxxxxxxxxxx> writes: > I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be > showing <IDLE> when no query is being run. > Is there a way for it to show the last query, even if it was run a while > ago? More recent versions act that way. There is no way to make 9.0.x do it short of patching the source code. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
