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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
