Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_stat_activity undocumented?

pg_stat_activity undocumented?

From
Thomas Kellerer
Date:
Hi,

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

Is this not a "offical" view?

Regards
Thomas

Re: pg_stat_activity undocumented?

From
Magnus Hagander
Date:
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/

Re: pg_stat_activity undocumented?

From
Thomas Kellerer
Date:
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
informationabout the database) I would prefer a complete list of all these objects in a single place. 

Cheers
Thomas

Re: pg_stat_activity undocumented?

From
"Albe Laurenz"
Date:
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

Re: pg_stat_activity undocumented?

From
Thomas Kellerer
Date:
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