Horton

Re: EXPLAIN BUFFERS

Alvaro Herrera <alvherre@commandprompt.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Cc: Greg Smith <greg@2ndquadrant.com>, Euler Taveira de Oliveira <euler@timbira.com>, 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-10T15:26:27Z
Lists: pgsql-hackers 
Takahiro Itagaki escribió:

> =# EXPLAIN (BUFFERS, ANALYZE) SELECT *
>       FROM pgbench_accounts a, pgbench_branches b
>      WHERE a.bid = b.bid AND abalance > 0 ORDER BY abalance;
>                                                           QUERY PLAN
> ------------------------------------------------------------------------------------------------------------------------------
>  Sort  (cost=2891.03..2891.04 rows=1 width=461) (actual time=22.494..22.494 rows=0 loops=1)
>    Sort Key: a.abalance
>    Sort Method:  quicksort  Memory: 25kB
>    Blocks: (shared hit=96 read=1544 written=0) (local hit=0 read=0 written=0) (temp read=0 written=0)

Maybe I missed part of this discussion, but it seems a bit weird to have
an option named "buffers" turn on a line that specifies numbers of
"blocks".  I kept looking for where you were specifying the BLOCKS
option to EXPLAIN in the command ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.