pgsql: Include information on buffer usage during planning phase, in EX - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: Include information on buffer usage during planning phase, in EX
Date
Msg-id E1jKC4J-0007R3-Bo@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Include information on buffer usage during planningphase, in EX  (Michael Paquier <michael@paquier.xyz>)
List pgsql-committers
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

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(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pgsql: pg_waldump: Add a --quiet option.
Next
From: Michael Paquier
Date:
Subject: pgsql: Add support for \aset in pgbench