Re: [GENERAL] is there a way log last query in pg_stat_activity

2014-08-14 Thread Tom Lane
Si Chen writes: > I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be > showing 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 p

[GENERAL] is there a way log last query in pg_stat_activity

2014-08-14 Thread Si Chen
I'm using Postgresql 9.0, and my pg_stat_activity.query seems to always be showing 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 communicat