Re: pg_stat_activity undocumented?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_stat_activity undocumented?
Date: 2009-07-30 08:30:55
Message-ID: h4rlnv$jm6$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Magnus Hagander, 30.07.2009 09:24:
> On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer<spam_eater(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-07-30 08:54:52 Re: Clients disconnect but query still runs
Previous Message Richard Huxton 2009-07-30 08:26:58 Re: PostgreSQL server listen on other port than 5432