Hi,
I can't find pg_stat_activity in the the documentation.
There are many pg_stat_xxx tables and views, but their columns are not described, or so it seems.
Maybe that is a bug in the documentation, then.
I was looking for what exactly "waiting" means in pg_stat_activity. In the 9.0.1 documentation, it is mentioned that it shows the "waiting status" but that doesn't really help.
http://www.postgresql.org/docs/current/static/monitoring-stats.html#MONITORING-STATS-VIEWS
I was looking for the answer for postgresql version 8.3 (it might differ).
Cheers,
Willy-Bas Loos
--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
