| 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: | Whole Thread | Raw Message | 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
| 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 |