pg_stat_activity undocumented?

On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer<spam_eater@gmx.net> wrote:

Hi,

is there a reason why pg_stat_activity is not documented in the chapter
"System Catalogs"?
Is this not a "offical" view?

It's not a catalog, it's a statistics view. It's documented in "26.2.
The Statistics Collector", specifically 26.2.2.

--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

Magnus Hagander, 30.07.2009 09:24:

On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer<spam_eater@gmx.net> wrote:

Hi,

is there a reason why pg_stat_activity is not documented in the chapter
"System Catalogs"?
Is this not a "offical" view?

It's not a catalog, it's a statistics view. It's documented in "26.2.
The Statistics Collector", specifically 26.2.2.

Thanks for the answer.

I understand the reasoning, although when looking for system views (or catalog views or anything else that contains information about the database) I would prefer a complete list of all these objects in a single place.

Cheers
Thomas

Thomas Kellerer wrote:

is there a reason why pg_stat_activity is not documented in
the chapter "System Catalogs"?

Is this not a "offical" view?

I guess it is because they are documented in
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
in Chapter 26.

Maybe a remark in the system catalogs documentation would be helpful.

Yours,
Laurenz Albe

Albe Laurenz, 30.07.2009 11:55:

is there a reason why pg_stat_activity is not documented in
the chapter "System Catalogs"?

I guess it is because they are documented in
http://www.postgresql.org/docs/8.4/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE
in Chapter 26.

Maybe a remark in the system catalogs documentation would be helpful.

Yes, definitely. At least that's the chapter where I start looking for things like that.

Thomas