Re: EXPLAIN BUFFERS

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Euler Taveira de Oliveira <euler(at)timbira(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: EXPLAIN BUFFERS
Date: 2009-12-07 14:24:55
Message-ID: 603c8f070912070624w7ce45c98mb6e3eb8f0b97c40e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 7, 2009 at 1:28 AM, Itagaki Takahiro
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>> (ii) format: why does text output format have less counters than the other ones?
>
> That's because lines will be too long for text format. I think the
> three values in it are the most important and useful ones.

I disagree. I objected to showing only part of the information when I
looked at this patch last CommitFest, and I object again now. I do
*NOT* want to have to use JSON or XML to get at the counters you've
arbitrarily decided are not interesting to me. I think with a little
creativity we can certainly get these into the text format, and I'm
willing to help with that. In fact, if you want, I'll pick up this
patch and make it my first commit, though since you're now a committer
as well perhaps you'd prefer to do it yourself.

>> (v) accumulative: i don't remember if we discussed it but is there a reason
>> the number of buffers isn't accumulative? We already have cost and time that
>> are both accumulative. I saw BufferUsageAccumDiff() function but didn't try to
>> figure out why it isn't accumulating or passing the counters to parent nodes.
>
> It's reasonable. I'll change so if no objections.

+1 to change it.

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message marcin mank 2009-12-07 14:39:25 Re: bug: fuzzystrmatch levenshtein is wrong
Previous Message Xin Wang 2009-12-07 13:50:09 How to cache a non-unique index?