Re: pg_stat_activity undocumented? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: pg_stat_activity undocumented?
Date
Msg-id h4rlnv$jm6$1@ger.gmane.org
Whole thread Raw
In response to Re: pg_stat_activity undocumented?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PostgreSQL server listen on other port than 5432
Next
From: Greg Stark
Date:
Subject: Re: Clients disconnect but query still runs