Re: EXPLAIN BUFFERS

Поиск
Список
Период
Сортировка
От Euler Taveira de Oliveira
Тема Re: EXPLAIN BUFFERS
Дата
Msg-id 4B1D2A3D.8090007@timbira.com
обсуждение исходный текст
Ответ на Re: EXPLAIN BUFFERS  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: EXPLAIN BUFFERS  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: strange segfault with 8.3.8
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [PATCH] Largeobject Access Controls (r2460)