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 <https://play.google.com/store/apps/details?id=com.opentaps.crm2client>, iPad/iPhone <https://itunes.apple.com/us/app/opentaps-crm2/id899333198>, Gmail <https://chrome.google.com/webstore/detail/opentaps-crm2/apkbgpfokhbplllnjkndenaopihfiaop> - It's Free!