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/[email protected]

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ed7a5095716ee498ecc406e1b8d5ab92c7662d10

Modified Files
--------------
src/backend/commands/explain.c        | 32 ++++++++++++++++++--
src/backend/commands/prepare.c        | 13 ++++++++-
src/include/commands/explain.h        |  3 +-
src/test/regress/expected/explain.out | 55 ++++++++++++++++++++++++++++++++---
4 files changed, 95 insertions(+), 8 deletions(-)

Reply via email to