pgsql: instrumentation: Separate per-node logic from other uses - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: instrumentation: Separate per-node logic from other uses
Date
Msg-id E1w9WdG-00391c-2k@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
instrumentation: Separate per-node logic from other uses

Previously, different places (e.g. query "total time") were repurposing the
Instrumentation struct initially introduced for capturing per-node statistics
during execution. This overuse of the same struct is confusing, e.g. by
cluttering calls of InstrStartNode/InstrStopNode in unrelated code paths, and
prevents future refactorings.

Instead, simplify the Instrumentation struct to only track time and WAL/buffer
usage. Similarly, drop the use of InstrEndLoop outside of per-node
instrumentation - these calls were added without any apparent benefit since
the relevant fields were never read.

Introduce the NodeInstrumentation struct to carry forward the per-node
instrumentation information. WorkerInstrumentation is renamed to
WorkerNodeInstrumentation for clarity.

In passing, clarify that InstrAggNode is expected to only run after
InstrEndLoop (as it does in practice), and drop unused code.

This also fixes a consequence-less bug: Previously ->async_mode was only set
when a non-zero instrument_option was passed. That turns out to be harmless
right now, as ->async_mode only affects a timing related field.

Author: Lukas Fittl <lukas@fittl.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/CAP53PkzdBK8VJ1fS4AZ481LgMN8f9mJiC39ZRHqkFUSYq6KWmg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5a79e78501f46bd3ac7fbd0ff84cf1e20dbafd19

Modified Files
--------------
contrib/auto_explain/auto_explain.c             |   8 +-
contrib/pg_stat_statements/pg_stat_statements.c |   8 +-
contrib/postgres_fdw/postgres_fdw.c             |   2 +-
src/backend/commands/explain.c                  |  30 +++--
src/backend/executor/execMain.c                 |   8 +-
src/backend/executor/execParallel.c             |  24 ++--
src/backend/executor/execProcnode.c             |   4 +-
src/backend/executor/instrument.c               | 149 +++++++++++++++---------
src/include/executor/instrument.h               |  60 +++++++---
src/include/nodes/execnodes.h                   |   9 +-
src/tools/pgindent/typedefs.list                |   3 +-
11 files changed, 178 insertions(+), 127 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: instrumentation: Separate trigger logic from other uses
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Convert pg_stat_statements to use the new shmem allocation funct