pgsql: Include information on buffer usage during planning phase, in EX

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Include information on buffer usage during planning phase, in EX
Date: 2020-04-03 02:28:27
Message-ID: E1jKC4J-0007R3-Bo@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2020-04-03 02:46:33 pgsql: Add support for \aset in pgbench
Previous Message Fujii Masao 2020-04-03 01:41:09 Re: pgsql: pg_waldump: Add a --quiet option.