Re: EXPLAIN BUFFERS - Mailing list pgsql-hackers

From Euler Taveira de Oliveira
Subject Re: EXPLAIN BUFFERS
Date
Msg-id 4B1D2A3D.8090007@timbira.com
Whole thread Raw
In response to Re: EXPLAIN BUFFERS  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: EXPLAIN BUFFERS
List pgsql-hackers
Itagaki Takahiro escreveu:
> I think the current output is enough and useful in normal use.
> We can use XML or JSON format for more details.
> 
I don't think it is a good idea to have different information in different
formats. I'm with Robert; *don't* do that. If you want to suppress the other
ones in text format, do it in the others too. One idea is to add them only if
we prefer the VERBOSE output.

> I think
>     Blocks Hit: 1641  Read: 0  Temp Read: 1443
> means
>     Blocks (Hit: 1641  Read: 0  Temp Read: 1443)
> i.e., Blocks of hit, blocks of reads, and Blocks of temp reads.
> 
But the latter is more clear than the former.

> I cannot understand what you mean -- should I suppress the lines when they
> have all-zero values?
> 
There are nodes that don't read or write blocks. If we go this way, we need to
document this behavior.


--  Euler Taveira de Oliveira http://www.timbira.com/


pgsql-hackers by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: strange segfault with 8.3.8
Next
From: "Kevin Grittner"
Date:
Subject: Re: [PATCH] Largeobject Access Controls (r2460)