Include information on buffer usage during planning phase, in EXPLAIN output.
authorFujii Masao <fujii@postgresql.org>
Fri, 3 Apr 2020 02:27:09 +0000 (11:27 +0900)
committerFujii Masao <fujii@postgresql.org>
Fri, 3 Apr 2020 02:27:09 +0000 (11:27 +0900)
commited7a5095716ee498ecc406e1b8d5ab92c7662d10
tree80dd8638547301c7077968858ca52a978e35ec85
parentac44367efbef198c57a18b96dbc6a39191720994
Include information on buffer usage during planning phase, in EXPLAIN output.

When BUFFERS option is enabled, EXPLAIN command includes the information
on buffer usage during each plan node, in its output. In addition to that,
this commit makes EXPLAIN command include also the information on
buffer usage during planning phase, in its output. This feature makes it
easier to discern the cases where lots of buffer access happen during
planning.

Author: Julien Rouhaud, slightly revised by Fujii Masao
Reviewed-by: Justin Pryzby
Discussion: https://postgr.es/m/16109-26a1a88651e90608@postgresql.org
src/backend/commands/explain.c
src/backend/commands/prepare.c
src/include/commands/explain.h
src/test/regress/expected/explain.out