where is pg_stat_activity (and others) in the documentation?

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: where is pg_stat_activity (and others) in the documentation?
Date: 2010-11-15 10:15:19
Message-ID: AANLkTimuufXSoYEP2ukzWZS51HRWUCq6T0FKeO9AUimE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2010-11-15 10:42:23 Re: Postgres forums ... take 2
Previous Message Elliot Chance 2010-11-15 10:08:36 Fwd: Postgres forums ... take 2