Horton

Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: cddca5ec13d27017281422124cae0480cddfb663
Author: Robert Haas <rhaas@postgresql.org>
Date: 2009-12-15T04:57:48Z
Releases: 9.0.0 
Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics.

This patch also removes buffer-usage statistics from the track_counts
output, since this (or the global server statistics) is deemed to be a better
interface to this information.

Itagaki Takahiro, reviewed by Euler Taveira de Oliveira.

Files

PathChange+/−
contrib/auto_explain/auto_explain.c modified +20 −4
contrib/pg_stat_statements/pg_stat_statements.c modified +2 −2
doc/src/sgml/auto-explain.sgml modified +20 −1
doc/src/sgml/ref/explain.sgml modified +20 −2
src/backend/commands/copy.c modified +2 −2
src/backend/commands/explain.c modified +93 −2
src/backend/commands/tablecmds.c modified +2 −2
src/backend/executor/execMain.c modified +5 −7
src/backend/executor/execProcnode.c modified +2 −2
src/backend/executor/functions.c modified +2 −2
src/backend/executor/instrument.c modified +43 −4
src/backend/executor/spi.c modified +2 −2
src/backend/storage/buffer/buf_init.c modified +1 −11
src/backend/storage/buffer/bufmgr.c modified +9 −55
src/backend/storage/buffer/localbuf.c modified +3 −2
src/backend/storage/file/buffile.c modified +4 −3
src/backend/tcop/postgres.c modified +1 −7
src/backend/tcop/pquery.c modified +6 −6
src/include/commands/explain.h modified +2 −1
src/include/executor/execdesc.h modified +3 −3
src/include/executor/executor.h modified +2 −2
src/include/executor/instrument.h modified +26 −2
src/include/nodes/execnodes.h modified +2 −2
src/include/storage/buf_internals.h modified +1 −11
src/include/storage/bufmgr.h modified +1 −3