Postgres Pro
Downloads
Home   >   mailing lists

where is pg_stat_activity (and others) in the documentation? - Mailing list pgsql-general

From Willy-Bas Loos
Subject where is pg_stat_activity (and others) in the documentation?
Date
Msg-id AANLkTimuufXSoYEP2ukzWZS51HRWUCq6T0FKeO9AUimE@mail.gmail.com
Whole thread Raw
Responses Re: where is pg_stat_activity (and others) in the documentation?  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Elliot Chance
Date:
Subject: Fwd: Postgres forums ... take 2
Next
From: Magnus Hagander
Date:
Subject: Re: Postgres forums ... take 2