Re: pgsql: Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics. - Mailing list pgsql-committers

From Robert Haas
Subject Re: pgsql: Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics.
Date
Msg-id 603c8f070912151236m64e2f621i1c783e2df5f2bc07@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics.  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-committers
On Tue, Dec 15, 2009 at 1:32 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Tue, 2009-12-15 at 04:57 +0000, Robert Haas wrote:
>> This patch also removes buffer-usage statistics from the track_counts
>> output, since this (or the global server statistics) is deemed to be a
>> better interface to this information.
>
> I hope anything being removed is documented, though I don't see that.
> Do you mean pg_statio_* tables no longer track heap_blocks* ? That is my
> understanding of what track_counts gives us. I think you mean
> log_*_stats, which is something else entirely.

Oops.  You're right, it's log_*_stats, rather than track_counts().
Unfortunately, the format of the log_*_stats output is not documented:
we can't remove this from the list of things that log_*_stats is
documented to print, because there is no such list.  That might be
worth correcting, but the lack of pre-existing documentation didn't
seem like something this patch should try to fix.

...Robert

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add a hook to let loadable modules get control at ProcessUtility
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Avoid unnecessary copying of source string when generating a