is there a way log last query in pg_stat_activity

[Si Chen <sichen@xxxxxxxxxxxxxxxxxxxxxxxx>]

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?

--

Si Chen
Open Source Strategies, Inc.
twitter.com/opentaps

Unify social, email, and business communications with opentaps CRM2 for Android, iPad/iPhone, Gmail - It's Free!