From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Order of views in stats docs |
Date: | 2014-11-16 14:43:17 |
Message-ID: | CABUevEzFr5HYjD6Za=xXPLwxSM6S7sFTkX_w=3vJc_3PMG5pLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Nov 9, 2014 at 3:46 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, Nov 6, 2014 at 3:01 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>> On 11/6/14 6:16 AM, Magnus Hagander wrote:
>>> Another thought I had in that case is maybe we need to break out the
>>> pg_stat_activity and pg_stat_replication views into their own table.
>>> They are really the only two views that are different in a lot of
>>> ways. Maybe call the splits "session statistics views" and "object
>>> statistics views", instead of just "standard statistics views"? The
>>> difference being that they show snapshots of *right now*, whereas all
>>> the other views show accumulated statistics over time.
>>
>> Yeah, splitting this up a bit would help, too.
>
> Here's an initial run of this. It still feels wrong that we have the
> dynamic views under "the statistics collector". Perhaps longterm we
> should look at actually splitting them out to a completely different
> sect1?
>
> I only fixed the obvious parts in this - the split out, and the moving
> of pg_stat_database_conflicts. But it's a first step at least.
>
> Objections?
Hearing no objections, I've pushed this. There's more to do, but it's a start.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Ullrich | 2014-11-16 20:56:41 | Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED |
Previous Message | Simon Riggs | 2014-11-16 14:00:02 | Re: Index scan optimization |