Elein <elein@nextbus.com> writes:
>> In 7.2 there is a system view pg_stat_activity.
> This is very nice. I can't ever see the current query, however,
> even as postgres. Is this column just to tease us? I can
> see it could be a security issue.
You need to turn on query stats. See
http://developer.postgresql.org/docs/postgres/monitoring-stats.html
regards, tom lane