Re: EXPLAIN BUFFERS
Euler Taveira <euler@timbira.com>
From: Euler Taveira de Oliveira <euler@timbira.com>
To: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Cc: Jeff Janes <jeff.janes@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2009-12-07T16:15:57Z
Lists: 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/